explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qFnC

Settings
# exclusive inclusive rows x rows loops node
1. 272.990 1,093.163 ↑ 21.3 2,934 1

GroupAggregate (cost=231,588.70..255,262.17 rows=62,418 width=717) (actual time=784.908..1,093.163 rows=2,934 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 613.836 820.173 ↓ 1.9 122,076 1

Sort (cost=231,588.70..231,748.92 rows=64,085 width=139) (actual time=784.787..820.173 rows=122,076 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: quicksort Memory: 35499kB
3. 168.469 206.337 ↓ 1.9 122,076 1

Bitmap Heap Scan on adsets (cost=3,206.78..226,472.25 rows=64,085 width=139) (actual time=57.062..206.337 rows=122,076 loops=1)

  • Recheck Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-04-01 00:00:00'::timestamp without time zone) AND (date <= '
  • Heap Blocks: exact=85291
4. 37.868 37.868 ↓ 2.3 144,367 1

Bitmap Index Scan on idx_account_date_adsets (cost=0.00..3,190.76 rows=64,085 width=0) (actual time=37.868..37.868 rows=144,367 loops=1)

  • Index Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-04-01 00:00:00'::timestamp without time zone) AND (date