explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7eBc

Settings
# exclusive inclusive rows x rows loops node
1. 90.942 279.314 ↑ 6.7 2,770 1

GroupAggregate (cost=52,604.81..59,918.95 rows=18,503 width=718) (actual time=174.855..279.314 rows=2,770 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 166.908 188.372 ↓ 1.1 22,160 1

Sort (cost=52,604.81..52,656.93 rows=20,850 width=144) (actual time=174.759..188.372 rows=22,160 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: external merge Disk: 3328kB
3. 17.663 21.464 ↓ 1.1 22,160 1

Bitmap Heap Scan on adsets (cost=871.11..51,109.06 rows=20,850 width=144) (actual time=4.658..21.464 rows=22,160 loops=1)

  • Recheck Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-05-06 00:00:00'::timestamp without time zone) AND (date <= '
  • Heap Blocks: exact=5577
4. 3.801 3.801 ↓ 1.1 22,160 1

Bitmap Index Scan on adsets_account_id_date_idx (cost=0.00..865.90 rows=20,850 width=0) (actual time=3.801..3.801 rows=22,160 loops=1)

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