explain.depesz.com

PostgreSQL's explain analyze made readable

Result: um9c

Settings
# exclusive inclusive rows x rows loops node
1. 5.903 170.205 ↑ 5.6 2,809 1

Group (cost=23,035.54..23,195.29 rows=15,869 width=29) (actual time=161.494..170.205 rows=2,809 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 127.428 164.302 ↓ 2.3 36,294 1

Sort (cost=23,035.54..23,075.48 rows=15,975 width=29) (actual time=161.491..164.302 rows=36,294 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: quicksort Memory: 4372kB
3. 36.874 36.874 ↓ 2.3 36,294 1

Index Only Scan using adset_idx on adsets (cost=0.56..21,920.20 rows=15,975 width=29) (actual time=0.022..36.874 rows=36,294 loops=1)

  • Index Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-05-01 00:00:00'::timestamp without time zone) AND (date <= '20
  • Heap Fetches: 36294
Planning time : 0.153 ms
Execution time : 170.343 ms