explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2gcm

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.118 ↓ 0.0 0 1

Update on budget_items (cost=5,730.58..6,011.51 rows=1,596 width=117) (actual time=1.118..1.118 rows=0 loops=1)

2. 0.001 1.117 ↓ 0.0 0 1

Nested Loop (cost=5,730.58..6,011.51 rows=1,596 width=117) (actual time=1.117..1.117 rows=0 loops=1)

3. 0.015 1.116 ↓ 0.0 0 1

HashAggregate (cost=5,730.46..5,735.25 rows=1,596 width=28) (actual time=1.116..1.116 rows=0 loops=1)

  • Group Key: budget_items_1.id
4. 0.001 1.101 ↓ 0.0 0 1

Nested Loop (cost=4.47..5,729.67 rows=1,596 width=28) (actual time=1.101..1.101 rows=0 loops=1)

5. 0.002 1.100 ↓ 0.0 0 1

Bitmap Heap Scan on budget_entities (cost=4.36..345.99 rows=158 width=22) (actual time=1.100..1.100 rows=0 loops=1)

  • Recheck Cond: (budget_id = '2d57403a-1c7f-4de9-b519-d904f54a8252'::uuid)
  • Filter: (deleted_at IS NULL)
6. 1.098 1.098 ↓ 0.0 0 1

Bitmap Index Scan on index_budget_entities_on_budget (cost=0.00..4.35 rows=179 width=0) (actual time=1.098..1.098 rows=0 loops=1)

  • Index Cond: (budget_id = '2d57403a-1c7f-4de9-b519-d904f54a8252'::uuid)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using index_budget_items_on_budget_entity on budget_items budget_items_1 (cost=0.11..34.03 rows=14 width=38) (never executed)

  • Index Cond: (budget_entity_id = budget_entities.id)
  • Filter: (deleted_at IS NULL)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using budget_items_pkey on budget_items (cost=0.11..0.17 rows=1 width=88) (never executed)

  • Index Cond: (id = budget_items_1.id)