PgHero
SELECT SUM("tweets"."retweet_count") AS sum_retweet_count, "tweets"."screen_name" AS tweets_screen_name FROM "tweets" WHERE "tweets"."query_id" = $1 AND "tweets"."retweet" = $2 AND (retweet_count > $3) GROUP BY "tweets"."screen_name"

Total Time ms

Loading...

Average Time ms

Loading...

Calls

Loading...

Tables

Name Rows Indexes
tweets 47372
  • id PRIMARY
  • query_id, retweet, created_at
  • query_id, twitter_id UNIQUE
  • tweet_group_id