explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4V8K

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3.791 6,633.062 ↑ 3.0 2,807 1

Group (cost=33,447.55..33,532.22 rows=8,437 width=29) (actual time=6,625.170..6,633.062 rows=2,807 loops=1)

2. 157.373 6,629.271 ↓ 2.6 22,331 1

Sort (cost=33,447.55..33,468.72 rows=8,467 width=29) (actual time=6,625.168..6,629.271 rows=22,331 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: quicksort Memory: 2513kB
3. 6,444.563 6,471.898 ↓ 2.6 22,331 1

Bitmap Heap Scan on adsets (cost=433.63..32,895.18 rows=8,467 width=29) (actual time=40.003..6,471.898 rows=22,331 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=52907
4. 27.335 27.335 ↓ 8.9 75,102 1

Bitmap Index Scan on idx_account_date_adsets (cost=0.00..431.51 rows=8,467 width=0) (actual time=27.335..27.335 rows=75,102 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