explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ih6p

Settings
# exclusive inclusive rows x rows loops node
1. 2.253 198,494.691 ↑ 195.0 4,378 1

GroupAggregate (cost=593,137.20..618,753.96 rows=853,892 width=659) (actual time=198,492.132..198,494.691 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. 1,137.391 198,478.282 ↑ 191.0 4,361 1

GroupAggregate (cost=161,782.28..185,611.90 rows=832,938 width=25) (actual time=197,078.331..198,478.282 rows=4,361 loops=1)

  • Group Key: dfp_ad_unit_device_flaf.date, dfp_ad_unit_device_flaf.site, dfp_ad_unit_device_flaf.flaf_id, dfp_ad_unit_device_flaf.device
4. 1,364.202 197,340.891 ↑ 1.0 881,706 1

Sort (cost=161,782.28..163,996.60 rows=885,728 width=37) (actual time=197,078.183..197,340.891 rows=881,706 loops=1)

  • Sort Key: dfp_ad_unit_device_flaf.date, dfp_ad_unit_device_flaf.site, dfp_ad_unit_device_flaf.flaf_id, dfp_ad_unit_device_flaf.device
  • Sort Method: external merge Disk: 43,888kB
5. 195,976.689 195,976.689 ↑ 1.0 881,706 1

Index Scan using idx_684476_date on dfp_ad_unit_device_flaf (cost=0.57..60,101.83 rows=885,728 width=37) (actual time=2.149..195,976.689 rows=881,706 loops=1)

  • Index Cond: (date >= '2020-10-01'::date)
6. 7.467 198,492.438 ↑ 192.2 4,443 1

Sort (cost=407,525.31..409,660.04 rows=853,892 width=659) (actual time=198,492.122..198,492.438 rows=4,443 loops=1)

  • Sort Key: dfp_av.date, dfp_av.site, dfp_av.flaf_id, flaf.channel, flaf.sub_channel, dfp_av.device
  • Sort Method: quicksort Memory: 540kB
7. 3.206 198,484.971 ↑ 192.2 4,443 1

Hash Left Join (cost=11.40..29,373.77 rows=853,892 width=659) (actual time=197,079.080..198,484.971 rows=4,443 loops=1)

  • Hash Cond: (dfp_av.flaf_id = flaf.pid)
8. 198,481.039 198,481.039 ↑ 191.0 4,361 1

CTE Scan on dfp_no_avantis dfp_av (cost=0.00..16,658.76 rows=832,938 width=644) (actual time=197,078.336..198,481.039 rows=4,361 loops=1)

9. 0.077 0.726 ↑ 1.0 326 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
10. 0.649 0.649 ↑ 1.0 329 1

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

Planning time : 89.266 ms