explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ujqV

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

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

  • Buffers: shared hit=2 read=100
  • I/O Timings: read=0.279
2.          

Initplan (for Result)

3. 0.001 2.166 ↑ 1.0 1 1

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

  • Buffers: shared hit=2 read=100
  • I/O Timings: read=0.279
4. 2.165 2.165 ↑ 20,846.0 1 1

Index Only Scan using batchfundproject_donationstatus_batchfundsettings on batchfundproject (cost=0.29..1,413.48 rows=20,846 width=4) (actual time=2.165..2.165 rows=1 loops=1)

  • Index Cond: ((id IS NOT NULL) AND (id > 1) AND (batchfundsettingsid = 411))
  • Heap Fetches: 1
  • Buffers: shared hit=2 read=100
  • I/O Timings: read=0.279
Planning time : 0.618 ms
Execution time : 2.206 ms