explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6AdR

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 5.040 ↑ 1.0 1 1

Result (cost=0.64..0.66 rows=1 width=32) (actual time=5.04..5.04 rows=1 loops=1)

  • Buffers: shared read=5
2.          

Initplan (for Result)

3. 0.002 5.028 ↑ 1.0 1 1

Limit (cost=0.57..0.64 rows=1 width=4) (actual time=5.027..5.028 rows=1 loops=1)

  • Buffers: shared read=5
4. 5.026 5.026 ↑ 304,903,744.0 1 1

Index Only Scan using bumacam_own_snapshot_report_date_idx3 on bumacam_own_snapshot hh (cost=0.57..20,878,642.63 rows=304,903,744 width=4) (actual time=5.026..5.026 rows=1 loops=1)

  • Index Cond: (hh.report_date IS NOT NULL)
  • Heap Fetches: 1
  • Buffers: shared read=5
Planning time : 0.13 ms
Execution time : 5.065 ms