explain.depesz.com

PostgreSQL's explain analyze made readable

Result: irtO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Unique (cost=20.86..20.86 rows=1 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=20.86..20.86 rows=1 width=16) (actual rows= loops=)

  • Sort Key: portion_unavailabilities.id
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.33..20.85 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (portion_unavailabilities.portion_id = portions.id)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on portion_unavailabilities (cost=4.19..12.67 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: (branch_id = 78605)
  • Filter: (status = 'UNAVAILABLE'::portion_unavailability_statuses)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on fk_item_unavailabilities_branch_id (cost=0.00..4.19 rows=5 width=0) (actual rows= loops=)

  • Index Cond: (branch_id = 78605)
6. 0.000 0.000 ↓ 0.0

Index Scan using fk_portions_version_id on portions (cost=0.14..8.16 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (version_id = 'ddb2cb8d-f8b2-4b0a-92cb-69949d866831'::uuid)