explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rcdd

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 67.377 ↓ 2.6 37 1

GroupAggregate (cost=3,287.68..3,287.96 rows=14 width=21) (actual time=67.348..67.377 rows=37 loops=1)

  • Group Key: subscriber_id, event
2. 0.082 67.346 ↓ 8.5 119 1

Sort (cost=3,287.68..3,287.72 rows=14 width=13) (actual time=67.338..67.346 rows=119 loops=1)

  • Sort Key: subscriber_id
  • Sort Method: quicksort Memory: 30kB
3. 67.264 67.264 ↓ 8.5 119 1

Index Scan using index_mailgun_events_on_store_id_and_subscriber_id on mailgun_events (cost=0.57..3,287.41 rows=14 width=13) (actual time=0.644..67.264 rows=119 loops=1)

  • Index Cond: ((store_id = 4,318) AND (subscriber_id = ANY ('{54793419,54793420,54793421,54793422,54793423,54793424,54793425,54793426,54793427,54793428,54793429,54793430,54793431,54793432,54793433,54793434,54793435,54793436,54793437,54793438,54793439,54793440,54793441,54793442,54793443,54793444,54793445,54793446,54793447,54793448,54793449,54793450,54793451,54793452,54793453,54793454,54793455,54793456,54793457,54793458,54793459,54793460,54793461,54793462,54793463,54793464,54793465,54793466,54793467,54793468,54793469,54793470,54793471,54793472,54793473,54793474,54793475,54793476,54793477,54793478,54793479,54793480,54793481,54793482,54793483,54793484,54793485,54793486,54793487,54793488,54793489,54793490,54793491,54793492,54793493,54793494,54793495}'::integer[])))
  • Filter: ((event)::text = 'clicked'::text)
  • Rows Removed by Filter: 9,613
Planning time : 0.484 ms
Execution time : 67.423 ms