explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zno7

Settings
# exclusive inclusive rows x rows loops node
1. 7.128 19.518 ↑ 6.8 459 1

GroupAggregate (cost=12,636.31..13,733.66 rows=3,134 width=638) (actual time=12.061..19.518 rows=459 loops=1)

  • Group Key: platform, publisher_platform, advert_id
2. 8.527 12.390 ↑ 1.4 2,251 1

Sort (cost=12,636.31..12,644.16 rows=3,137 width=132) (actual time=11.975..12.390 rows=2,251 loops=1)

  • Sort Key: platform, publisher_platform, advert_id
  • Sort Method: quicksort Memory: 694kB
3. 3.335 3.863 ↑ 1.4 2,251 1

Bitmap Heap Scan on adverts (cost=149.69..12,454.13 rows=3,137 width=132) (actual time=0.666..3.863 rows=2,251 loops=1)

  • Recheck Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-03-03 00:00:00'::timestamp without time zone) AND (date <= '
  • Heap Blocks: exact=1295
4. 0.528 0.528 ↑ 1.4 2,251 1

Bitmap Index Scan on idx_account_date_adverts (cost=0.00..148.91 rows=3,137 width=0) (actual time=0.528..0.528 rows=2,251 loops=1)

  • Index Cond: ((account_id = ANY ('{1595321963838425,1320001405,urn:li:sponsoredAccount:507697540}'::text[])) AND (date >= '2019-03-03 00:00:00'::timestamp without time zone) AND (date