explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IkfY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 144,647.225 ↑ 12.4 60 1

Finalize GroupAggregate (cost=228,584.26..228,681.37 rows=747 width=12) (actual time=144,647.173..144,647.225 rows=60 loops=1)

  • Group Key: dfp_ad_unit_device_flaf.date
2. 7.645 144,648.687 ↑ 6.5 115 1

Gather Merge (cost=228,584.26..228,670.16 rows=747 width=12) (actual time=144,647.163..144,648.687 rows=115 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.051 144,641.042 ↑ 12.9 58 2 / 2

Sort (cost=227,584.25..227,586.11 rows=747 width=12) (actual time=144,641.038..144,641.042 rows=58 loops=2)

  • Sort Key: dfp_ad_unit_device_flaf.date
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
4. 5.588 144,640.991 ↑ 12.9 58 2 / 2

Partial HashAggregate (cost=227,541.13..227,548.60 rows=747 width=12) (actual time=144,640.973..144,640.991 rows=58 loops=2)

  • Group Key: dfp_ad_unit_device_flaf.date
5. 442.367 144,635.403 ↑ 4.9 25,585 2 / 2

Hash Join (cost=8.96..226,917.92 rows=124,642 width=12) (actual time=12.073..144,635.403 rows=25,585 loops=2)

  • Hash Cond: (dfp_ad_unit_device_flaf.flaf_id = flaf.pid)
6. 144,192.965 144,192.965 ↑ 1.2 1,760,990 2 / 2

Parallel Index Scan using idx_684476_date on dfp_ad_unit_device_flaf (cost=0.57..220,079.67 rows=2,073,600 width=20) (actual time=0.016..144,192.965 rows=1,760,990 loops=2)

  • Index Cond: (date >= '2020-08-18'::date)
7. 0.005 0.071 ↑ 1.0 11 2 / 2

Hash (cost=8.25..8.25 rows=11 width=8) (actual time=0.070..0.071 rows=11 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.008 0.066 ↑ 1.0 11 2 / 2

HashAggregate (cost=8.14..8.25 rows=11 width=8) (actual time=0.064..0.066 rows=11 loops=2)

  • Group Key: flaf.pid
9. 0.058 0.058 ↑ 1.0 11 2 / 2

Seq Scan on flaf (cost=0.00..8.11 rows=11 width=8) (actual time=0.028..0.058 rows=11 loops=2)

  • Filter: (sub_channel = 'snapchat'::text)
  • Rows Removed by Filter: 318
Planning time : 0.254 ms