Álvaro Hernández Tortosa ahachete
-
OnGres
- Madrid, Spain
- Sign in to view email
- www.ongres.com
View 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; |
View 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 |
View 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; |
View 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; |
View Stampede-GithuQuery-PostgreSQL-B
SELECT type_s, count(*) | |
FROM github.events | |
GROUP BY type_s | |
ORDER BY count desc; |
View 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; |
View Stampede-GithubQuery-MongoDB-F
db.events.aggregate( | |
[ | |
{ $match: { "type": "PushEvent", "payload.size": { $gt : 2 } } }, | |
{ $group: { _id: "$repo.name", avg: { $avg: "$payload.size" } } }, | |
{ $sort: { avg: -1 } } | |
], | |
{ allowDiskUse: true, cursor: { batchSize: 100000000 } } | |
); |
View Stampede-GithubQuery-MongoDB-E
db.events.aggregate( | |
[ | |
{ $match: { "type": "PushEvent" } }, | |
{ $project: { "repo.name": 1, "actor.login": 1 } }, | |
{ $group: | |
{ | |
_id: "$repo.name", | |
actor: { $first: "$actor.login"}, | |
count: { $sum: 1 } | |
} |
View Stampede-GithubQuery-MongoDB-D
db.events.aggregate( | |
[ | |
{ $match: { "payload.action": { $exists: true } } }, | |
{ $group: { _id: "$payload.action", total: { $sum: 1 } } }, | |
{ $sort: { total: 1 } } | |
], | |
{ allowDiskUse: true, cursor: { batchSize: 100000000 } } | |
); |
View Stampede-GithubQuery-MongoDB-C
db.events.aggregate( | |
[ | |
{ $group: { _id: "$type", total: { $sum: 1 } } }, | |
{ $sort: { total: -1 } } | |
], | |
{ allowDiskUse: true, cursor: { batchSize: 100000000 } } | |
); |
NewerOlder