explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NEAY

Settings
# exclusive inclusive rows x rows loops node
1. 341.086 1,193.579 ↑ 20.2 2,770 1

GroupAggregate (cost=116,218.85..143,107.59 rows=55,932 width=718) (actual time=730.949..1,193.579 rows=2,770 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 755.195 852.493 ↓ 1.0 94,180 1

Sort (cost=116,218.85..116,451.09 rows=92,896 width=144) (actual time=730.786..852.493 rows=94,180 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: external merge Disk: 14128kB
3. 85.740 97.298 ↓ 1.0 94,180 1

Bitmap Heap Scan on adsets (cost=2,832.94..101,882.38 rows=92,896 width=144) (actual time=14.039..97.298 rows=94,180 loops=1)

  • Recheck Cond: (account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[]))
  • Filter: ((date >= '2019-01-06 00:00:00'::timestamp without time zone) AND (date <= '2019-05-13 23:59:59.999999'::timestamp without time zone))
  • Rows Removed by Filter: 36
  • Heap Blocks: exact=14854
4. 11.558 11.558 ↑ 1.0 94,216 1

Bitmap Index Scan on adsets_account_id_index (cost=0.00..2,809.71 rows=97,126 width=0) (actual time=11.558..11.558 rows=94,216 loops=1)

  • Index Cond: (account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[]))