explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x4LG

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.740 ↑ 1.0 1 1

Result (cost=0.36..0.37 rows=1 width=4) (actual time=0.739..0.740 rows=1 loops=1)

  • Buffers: shared hit=79
2.          

Initplan (for Result)

3. 0.001 0.735 ↑ 1.0 1 1

Limit (cost=0.29..0.36 rows=1 width=4) (actual time=0.735..0.735 rows=1 loops=1)

  • Buffers: shared hit=79
4. 0.734 0.734 ↑ 18,481.0 1 1

Index Only Scan using batchfundproject_donationstatus_batchfundsettings on batchfundproject (cost=0.29..1,283.65 rows=18,481 width=4) (actual time=0.734..0.734 rows=1 loops=1)

  • Index Cond: ((id IS NOT NULL) AND (id > 30000) AND (batchfundsettingsid = 411))
  • Heap Fetches: 1
  • Buffers: shared hit=79
Planning time : 0.423 ms
Execution time : 0.778 ms