explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dWO : Optimization for: plan #qwhB

Settings

Optimization path:

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

Aggregate (cost=58.34..58.35 rows=1 width=8) (actual time=0.055..0.055 rows=1 loops=1)

2. 0.032 0.050 ↓ 1.3 20 1

Bitmap Heap Scan on microcredit_request (cost=4.40..58.30 rows=15 width=4) (actual time=0.027..0.050 rows=20 loops=1)

  • Recheck Cond: (vendor_client_id = 6817)
  • Heap Blocks: exact=15
3. 0.018 0.018 ↓ 1.3 20 1

Bitmap Index Scan on microcredit_request_vendor_client_id_idx (cost=0.00..4.39 rows=15 width=0) (actual time=0.018..0.018 rows=20 loops=1)

  • Index Cond: (vendor_client_id = 6817)