explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nBRP

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

Result (cost=48.03..48.04 rows=1 width=64) (actual time=0.115..0.115 rows=1 loops=1)

  • Buffers: shared hit=16
2.          

CTE resultcounts

3. 0.001 0.111 ↓ 0.0 0 1

GroupAggregate (cost=47.89..47.92 rows=1 width=44) (actual time=0.111..0.111 rows=0 loops=1)

  • Group Key: p.donationstatus
  • Buffers: shared hit=16
4. 0.020 0.110 ↓ 0.0 0 1

Sort (cost=47.89..47.90 rows=1 width=9) (actual time=0.110..0.110 rows=0 loops=1)

  • Sort Key: p.donationstatus
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=16
5. 0.047 0.090 ↓ 0.0 0 1

Hash Left Join (cost=38.99..47.88 rows=1 width=9) (actual time=0.089..0.090 rows=0 loops=1)

  • Hash Cond: (p.batchfundexecutionid = e.id)
  • Filter: (e.completedtime IS NULL)
  • Rows Removed by Filter: 139
  • Buffers: shared hit=11
6. 0.028 0.028 ↓ 4.6 139 1

Index Scan using batchfundproject_batchfundsettingsid on batchfundproject p (cost=0.42..9.23 rows=30 width=13) (actual time=0.008..0.028 rows=139 loops=1)

  • Index Cond: (batchfundsettingsid = 415)
  • Buffers: shared hit=7
7. 0.008 0.015 ↑ 79.4 16 1

Hash (cost=22.70..22.70 rows=1,270 width=12) (actual time=0.015..0.015 rows=16 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=1
8. 0.007 0.007 ↑ 79.4 16 1

Seq Scan on batchfundexecution e (cost=0.00..22.70 rows=1,270 width=12) (actual time=0.005..0.007 rows=16 loops=1)

  • Buffers: shared hit=1
9.          

Initplan (for Result)

10. 0.112 0.112 ↓ 0.0 0 1

CTE Scan on resultcounts (cost=0.00..0.02 rows=1 width=8) (actual time=0.112..0.112 rows=0 loops=1)

  • Filter: (donationstatus = 'FUNDED'::batchfunddonationstatus)
  • Buffers: shared hit=16
11. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (donationstatus = 'SKIPPED'::batchfunddonationstatus)
12. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (donationstatus = 'ERROR'::batchfunddonationstatus)
13. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (donationstatus IS NULL)
14. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on resultcounts resultcounts_4 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (donationstatus = 'FUNDED'::batchfunddonationstatus)
Planning time : 0.575 ms
Execution time : 0.224 ms