|
|
|
## This querys were extracted from AHT blog https://www.8kdata.com/blog/announcing-torodb-stampede-1-0-beta/ for run in our test and modify if necessary.
|
|
|
|
|
|
|
|
|
|
|
|
## PostgreSQL
|
|
|
|
### Stampede-GithuQuery-PostgreSQL-A
|
|
|
|
```
|
|
|
|
SELECT repo.name_s, count(*)
|
|
|
|
FROM github.events AS events
|
|
|
|
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
|
|
|
|
INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
|
|
|
|
WHERE events.type_s = 'IssuesEvent' AND payload.action_s = 'opened'
|
|
|
|
GROUP BY repo.name_s
|
|
|
|
ORDER BY count desc;
|
|
|
|
```
|
|
|
|
### Stampede-GithuQuery-PostgreSQL-B
|
|
|
|
```
|
|
|
|
SELECT type_s, count(*)
|
|
|
|
FROM github.events
|
|
|
|
GROUP BY type_s
|
|
|
|
ORDER BY count desc;
|
|
|
|
```
|
|
|
|
### Stampede-GithuQuery-PostgreSQL-C
|
|
|
|
```
|
|
|
|
SELECT events.type_s, count(*)
|
|
|
|
FROM github.events AS events
|
|
|
|
JOIN github.events_actor AS actor ON (events.did = actor.did)
|
|
|
|
GROUP BY type_s
|
|
|
|
ORDER BY count DESC;
|
|
|
|
```
|
|
|
|
### Stampede-GithuQuery-PostgreSQL-D
|
|
|
|
```
|
|
|
|
SELECT action_s, count(*)
|
|
|
|
FROM github.events_payload
|
|
|
|
WHERE action_s IS NOT NULL
|
|
|
|
GROUP BY action_s
|
|
|
|
ORDER BY count DESC;
|
|
|
|
```
|
|
|
|
### Stampede-GithuQuery-PostgreSQL-E
|
|
|
|
```
|
|
|
|
WITH distinct_commits AS (
|
|
|
|
SELECT DISTINCT repo.name_s, actor.login_s
|
|
|
|
FROM github.events AS events
|
|
|
|
INNER JOIN github.events_actor AS actor ON (events.did = actor.did)
|
|
|
|
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
|
|
|
|
WHERE events.type_s = 'PushEvent'
|
|
|
|
)
|
|
|
|
SELECT name_s, count(*)
|
|
|
|
FROM distinct_commits
|
|
|
|
GROUP BY name_s
|
|
|
|
ORDER BY count DESC;
|
|
|
|
```
|
|
|
|
### Stampede-GithuQuery-PostgreSQL-F
|
|
|
|
```
|
|
|
|
SELECT repo.name_s, avg(payload.size_i)
|
|
|
|
FROM github.events AS events
|
|
|
|
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
|
|
|
|
INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
|
|
|
|
WHERE events.type_s = 'PushEvent' AND payload.size_i > 2
|
|
|
|
GROUP BY repo.name_s
|
|
|
|
ORDER BY avg DESC;
|
|
|
|
``` |
|
|
|
\ No newline at end of file |