explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xs7q : delivery_report_without_params

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 110.230 ↓ 0.0 0 1

Sort (cost=67.58..70.08 rows=1,000 width=204) (actual time=110.230..110.230 rows=0 loops=1)

  • Sort Key: _endtime_date DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=52 read=1608
  • I/O Timings: read=8.071
2. 110.222 110.222 ↓ 0.0 0 1

Function Scan on live_report_delivery (cost=0.25..17.75 rows=1,000 width=204) (actual time=110.222..110.222 rows=0 loops=1)

  • Buffers: shared hit=52 read=1608
  • I/O Timings: read=8.071