explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lF47

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 23.312 ↑ 1.0 1 1

Result (cost=2,108.26..2,108.27 rows=1 width=64) (actual time=23.312..23.312 rows=1 loops=1)

  • Buffers: shared hit=414 read=108
  • I/O Timings: read=2.237
2.          

CTE resultcounts

3. 6.552 23.302 ↑ 2.0 1 1

HashAggregate (cost=2,108.01..2,108.04 rows=2 width=44) (actual time=23.302..23.302 rows=1 loops=1)

  • Group Key: p.donationstatus
  • Buffers: shared hit=414 read=108
  • I/O Timings: read=2.237
4. 8.502 16.750 ↑ 1.1 35,205 1

Hash Join (cost=38.92..1,817.19 rows=38,776 width=9) (actual time=1.196..16.750 rows=35,205 loops=1)

  • Hash Cond: (p.batchfundexecutionid = e.id)
  • Buffers: shared hit=414 read=108
  • I/O Timings: read=2.237
5. 8.223 8.223 ↑ 1.0 38,826 1

Index Scan using batchfundproject_batchfundsettingsid on batchfundproject p (cost=0.42..1,676.27 rows=38,960 width=13) (actual time=1.117..8.223 rows=38,826 loops=1)

  • Index Cond: (batchfundsettingsid = 411)
  • Buffers: shared hit=410 read=108
  • I/O Timings: read=2.237
6. 0.012 0.025 ↑ 74.4 17 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=1
7. 0.013 0.013 ↑ 74.4 17 1

Seq Scan on batchfundexecution e (cost=0.00..22.70 rows=1,264 width=4) (actual time=0.008..0.013 rows=17 loops=1)

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

Initplan (for Result)

9. 23.305 23.305 ↑ 1.0 1 1

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

  • Filter: (donationstatus = 'FUNDED'::batchfunddonationstatus)
  • Buffers: shared hit=414 read=108
  • I/O Timings: read=2.237
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.000..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.609 ms
Execution time : 23.425 ms