explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E2NE

Settings
# exclusive inclusive rows x rows loops node
1. 299.518 1,076.007 ↑ 20.2 2,770 1

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

  • Group Key: platform, publisher_platform, adset_id
2. 682.848 776.489 ↓ 1.0 94,180 1

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

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

Bitmap Heap Scan on adsets (cost=2,832.94..101,882.38 rows=92,896 width=144) (actual time=12.732..93.641 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. 10.087 10.087 ↑ 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=10.087..10.087 rows=94,216 loops=1)

  • Index Cond: (account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[]))
Planning time : 0.299 ms
Execution time : 1,078.862 ms