explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qeTx

Settings
# exclusive inclusive rows x rows loops node
1. 151.357 301.050 ↑ 3.9 2,892 1

GroupAggregate (cost=44,496.39..48,739.74 rows=11,293 width=717) (actual time=139.779..301.050 rows=2,892 loops=1)

  • Group Key: platform, publisher_platform, adset_id
2. 114.696 149.693 ↓ 2.0 23,014 1

Sort (cost=44,496.39..44,524.75 rows=11,346 width=139) (actual time=139.654..149.693 rows=23,014 loops=1)

  • Sort Key: platform, publisher_platform, adset_id
  • Sort Method: quicksort Memory: 6882kB
3. 29.922 34.997 ↓ 2.0 23,014 1

Bitmap Heap Scan on adsets (cost=578.35..43,732.24 rows=11,346 width=139) (actual time=7.359..34.997 rows=23,014 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=14176
4. 5.075 5.075 ↓ 2.3 25,828 1

Bitmap Index Scan on idx_account_date_adsets (cost=0.00..575.51 rows=11,346 width=0) (actual time=5.075..5.075 rows=25,828 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
Planning time : 0.304 ms
Execution time : 301.747 ms