explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BFOh

Settings
# exclusive inclusive rows x rows loops node
1. 4.027 6,191.571 ↑ 3.9 2,892 1

Group (cost=8,629.20..8,742.66 rows=11,293 width=29) (actual time=6,185.424..6,191.571 rows=2,892 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 96.485 6,187.544 ↓ 2.0 23,014 1

Sort (cost=8,629.20..8,657.57 rows=11,346 width=29) (actual time=6,185.423..6,187.544 rows=23,014 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: quicksort Memory: 2566kB
3. 6,091.059 6,091.059 ↓ 2.0 23,014 1

Index Only Scan using adset_idx on adsets (cost=0.56..7,865.05 rows=11,346 width=29) (actual time=1.556..6,091.059 rows=23,014 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 <= '20
  • Heap Fetches: 25828