explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VqAY

Settings
# exclusive inclusive rows x rows loops node
1. 181.181 296,531.299 ↑ 207.4 4,378 1

GroupAggregate (cost=496,071.01..523,311.31 rows=908,010 width=659) (actual time=296,205.945..296,531.299 rows=4,378 loops=1)

  • Group Key: dfp_av.date, dfp_av.site, dfp_av.flaf_id, flaf.channel, flaf.sub_channel, dfp_av.device
2.          

CTE dfp_no_avantis

3. 293,976.032 293,976.032 ↑ 1.0 881,706 1

Index Scan using idx_684476_date on dfp_ad_unit_device_flaf (cost=0.57..62,316.15 rows=885,728 width=25) (actual time=23.744..293,976.032 rows=881,706 loops=1)

  • Index Cond: (date >= '2020-10-01'::date)
4. 1,511.461 296,350.118 ↑ 1.0 883,933 1

Sort (cost=433,754.86..436,024.88 rows=908,010 width=659) (actual time=296,205.907..296,350.118 rows=883,933 loops=1)

  • Sort Key: dfp_av.date, dfp_av.site, dfp_av.flaf_id, flaf.channel, flaf.sub_channel, dfp_av.device
  • Sort Method: external merge Disk: 39,720kB
5. 349.487 294,838.657 ↑ 1.0 883,933 1

Hash Left Join (cost=11.40..31,234.70 rows=908,010 width=659) (actual time=27.877..294,838.657 rows=883,933 loops=1)

  • Hash Cond: (dfp_av.flaf_id = flaf.pid)
6. 294,485.057 294,485.057 ↑ 1.0 881,706 1

CTE Scan on dfp_no_avantis dfp_av (cost=0.00..17,714.56 rows=885,728 width=644) (actual time=23.748..294,485.057 rows=881,706 loops=1)

7. 0.088 4.113 ↑ 1.0 326 1

Hash (cost=7.29..7.29 rows=329 width=23) (actual time=4.113..4.113 rows=326 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
8. 4.025 4.025 ↑ 1.0 329 1

Seq Scan on flaf (cost=0.00..7.29 rows=329 width=23) (actual time=3.919..4.025 rows=329 loops=1)

Planning time : 343.319 ms