explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gfzn : admin_withdrawal_requests

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4.537 1,311.011 ↑ 1.0 1 1

Aggregate (cost=1,135.55..1,135.56 rows=1 width=8) (actual time=1,311.011..1,311.011 rows=1 loops=1)

2. 1,306.474 1,306.474 ↓ 1.1 17,054 1

Index Only Scan using index_withdrawal_requests_on_status on withdrawal_requests (cost=0.42..1,095.23 rows=16,129 width=0) (actual time=0.641..1,306.474 rows=17,054 loops=1)

  • Index Cond: (status = 3)
  • Heap Fetches: 1,963
Planning time : 0.429 ms
Execution time : 1,311.059 ms