explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qqDV

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 32.417 ↑ 1.0 1 1

Result (cost=2,439.82..2,439.83 rows=1 width=64) (actual time=32.417..32.417 rows=1 loops=1)

  • Buffers: shared hit=8 read=1,058
  • I/O Timings: read=10.229
2.          

CTE resultcounts

3. 6.391 32.402 ↑ 2.0 1 1

HashAggregate (cost=2,439.57..2,439.60 rows=2 width=44) (actual time=32.402..32.402 rows=1 loops=1)

  • Group Key: p.donationstatus
  • Buffers: shared hit=8 read=1,058
  • I/O Timings: read=10.229
4. 7.808 26.011 ↑ 1.1 35,205 1

Hash Join (cost=38.50..2,149.35 rows=38,696 width=9) (actual time=6.598..26.011 rows=35,205 loops=1)

  • Hash Cond: (p.batchfundexecutionid = e.id)
  • Buffers: shared hit=8 read=1,058
  • I/O Timings: read=10.229
5. 18.186 18.186 ↑ 1.0 38,826 1

Seq Scan on batchfundproject p (cost=0.00..2,008.64 rows=38,880 width=13) (actual time=6.530..18.186 rows=38,826 loops=1)

  • Filter: (batchfundsettingsid = 411)
  • Rows Removed by Filter: 37,010
  • Buffers: shared hit=4 read=1,058
  • I/O Timings: read=10.229
6. 0.008 0.017 ↑ 79.0 16 1

Hash (cost=22.70..22.70 rows=1,264 width=4) (actual time=0.017..0.017 rows=16 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=1
7. 0.009 0.009 ↑ 79.0 16 1

Seq Scan on batchfundexecution e (cost=0.00..22.70 rows=1,264 width=4) (actual time=0.007..0.009 rows=16 loops=1)

  • Filter: (completedtime IS NOT NULL)
  • Buffers: shared hit=1
8.          

Initplan (for Result)

9. 32.407 32.407 ↑ 1.0 1 1

CTE Scan on resultcounts (cost=0.00..0.04 rows=1 width=8) (actual time=32.407..32.407 rows=1 loops=1)

  • Filter: (donationstatus = 'FUNDED'::batchfunddonationstatus)
  • Buffers: shared hit=8 read=1,058
  • I/O Timings: read=10.229
10. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on resultcounts resultcounts_1 (cost=0.00..0.04 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (donationstatus = 'SKIPPED'::batchfunddonationstatus)
  • Rows Removed by Filter: 1
11. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on resultcounts resultcounts_2 (cost=0.00..0.04 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (donationstatus = 'ERROR'::batchfunddonationstatus)
  • Rows Removed by Filter: 1
12. 0.001 0.001 ↓ 0.0 0 1

CTE Scan on resultcounts resultcounts_3 (cost=0.00..0.04 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (donationstatus IS NULL)
  • Rows Removed by Filter: 1
13. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on resultcounts resultcounts_4 (cost=0.00..0.04 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

  • Filter: (donationstatus = 'FUNDED'::batchfunddonationstatus)
Planning time : 0.639 ms
Execution time : 32.537 ms