explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VetO

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

Result (cost=0.49..0.50 rows=1 width=4) (actual time=0.044..0.044 rows=1 loops=1)

  • Buffers: shared hit=4
2.          

Initplan (for Result)

3. 0.001 0.041 ↑ 1.0 1 1

Limit (cost=0.29..0.49 rows=1 width=4) (actual time=0.041..0.041 rows=1 loops=1)

  • Buffers: shared hit=4
4. 0.040 0.040 ↑ 1,220.0 1 1

Index Only Scan using batchfundproject_donationstatus_batchfundsettings on batchfundproject (cost=0.29..239.99 rows=1,220 width=4) (actual time=0.040..0.040 rows=1 loops=1)

  • Index Cond: ((id IS NOT NULL) AND (id > 102000) AND (batchfundsettingsid = 411))
  • Heap Fetches: 1
  • Buffers: shared hit=4
Planning time : 0.429 ms
Execution time : 0.082 ms