explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ir8x : APBN-976 Оптимизировать запрос withdrawal_requests

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 77.821 ↑ 1.0 1 1

Aggregate (cost=8.44..8.45 rows=1 width=8) (actual time=77.821..77.821 rows=1 loops=1)

2. 77.816 77.816 ↓ 0.0 0 1

Index Only Scan using index_withdrawal_requests_on_status on withdrawal_requests (cost=0.42..8.44 rows=1 width=0) (actual time=77.816..77.816 rows=0 loops=1)

  • Index Cond: (status = 7)
  • Heap Fetches: 105
Planning time : 0.116 ms
Execution time : 77.856 ms