explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qwhB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.016 0.168 ↑ 1.0 1 1

Aggregate (cost=32.58..32.59 rows=1 width=8) (actual time=0.167..0.168 rows=1 loops=1)

2. 0.152 0.152 ↓ 1.3 20 1

Index Only Scan using microcredit_request_vendor_client_id_idx on microcredit_request (cost=0.28..32.54 rows=15 width=0) (actual time=0.062..0.152 rows=20 loops=1)

  • Index Cond: (vendor_client_id = 6817)
  • Heap Fetches: 19