explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ZOo

Settings
# exclusive inclusive rows x rows loops node
1. 99.259 382.803 ↑ 5.6 2,809 1

GroupAggregate (cost=62,006.76..67,974.60 rows=15,869 width=717) (actual time=274.027..382.803 rows=2,809 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 158.093 283.544 ↓ 2.3 36,294 1

Sort (cost=62,006.76..62,046.70 rows=15,975 width=139) (actual time=273.883..283.544 rows=36,294 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: quicksort Memory: 11177kB
3. 96.723 125.451 ↓ 2.3 36,294 1

Bitmap Heap Scan on adsets (cost=805.37..60,891.42 rows=15,975 width=139) (actual time=47.780..125.451 rows=36,294 loops=1)

  • Recheck Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-05-01 00:00:00'::timestamp without time zone) AND (date <= '
  • Heap Blocks: exact=87912
4. 28.728 28.728 ↓ 7.8 123,907 1

Bitmap Index Scan on idx_account_date_adsets (cost=0.00..801.38 rows=15,975 width=0) (actual time=28.728..28.728 rows=123,907 loops=1)

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