explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zkgX

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 38.836 ↑ 1.0 1 1

Result (cost=2,370.39..2,370.40 rows=1 width=64) (actual time=38.835..38.836 rows=1 loops=1)

  • Buffers: shared hit=99 read=496
  • I/O Timings: read=13.931
2.          

CTE resultcounts

3. 7.073 38.820 ↑ 2.0 1 1

HashAggregate (cost=2,370.14..2,370.17 rows=2 width=44) (actual time=38.819..38.820 rows=1 loops=1)

  • Group Key: p.donationstatus
  • Buffers: shared hit=99 read=496
  • I/O Timings: read=13.931
4. 8.814 31.747 ↑ 1.1 35,205 1

Hash Join (cost=299.80..2,077.94 rows=38,960 width=9) (actual time=3.253..31.747 rows=35,205 loops=1)

  • Hash Cond: (p.batchfundexecutionid = e.id)
  • Buffers: shared hit=99 read=496
  • I/O Timings: read=13.931
5. 20.384 20.384 ↑ 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=0.610..20.384 rows=38,826 loops=1)

  • Index Cond: (batchfundsettingsid = 411)
  • Buffers: shared hit=22 read=496
  • I/O Timings: read=13.931
6. 1.290 2.549 ↑ 1.0 10,017 1

Hash (cost=174.17..174.17 rows=10,017 width=4) (actual time=2.548..2.549 rows=10,017 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 481kB
  • Buffers: shared hit=74
7. 1.259 1.259 ↑ 1.0 10,017 1

Seq Scan on batchfundexecution e (cost=0.00..174.17 rows=10,017 width=4) (actual time=0.008..1.259 rows=10,017 loops=1)

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

Initplan (for Result)

9. 38.824 38.824 ↑ 1.0 1 1

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

  • Filter: (donationstatus = 'FUNDED'::batchfunddonationstatus)
  • Buffers: shared hit=99 read=496
  • I/O Timings: read=13.931
10. 0.002 0.002 ↓ 0.0 0 1

CTE Scan on resultcounts resultcounts_1 (cost=0.00..0.04 rows=1 width=8) (actual time=0.002..0.002 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 : 3.575 ms
Execution time : 39.019 ms