explain.depesz.com

PostgreSQL's explain analyze made readable

Result: brwm : Optimization for: admin_withdrawal_requests; plan #gfzn

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.286 7.861 ↑ 1.0 1 1

Aggregate (cost=519.97..519.98 rows=1 width=8) (actual time=7.861..7.861 rows=1 loops=1)

2. 6.575 6.575 ↓ 1.1 17,114 1

Index Only Scan using index_withdrawal_requests_id_partial_status_3 on withdrawal_requests (cost=0.29..479.66 rows=16,126 width=0) (actual time=0.043..6.575 rows=17,114 loops=1)

  • Heap Fetches: 1,500
Planning time : 0.094 ms
Execution time : 7.884 ms