explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AjLh

Settings
# exclusive inclusive rows x rows loops node
1. 29.023 47.770 ↓ 0.0 0 1

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

2. 0.000 18.747 ↓ 1.2 1,970 1

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

3. 1.406 4.987 ↓ 1.2 1,970 1

HashAggregate (cost=5,730.46..5,735.25 rows=1,596 width=28) (actual time=4.297..4.987 rows=1,970 loops=1)

  • Group Key: budget_items_1.id
4. 0.309 3.581 ↓ 1.2 1,970 1

Nested Loop (cost=4.47..5,729.67 rows=1,596 width=28) (actual time=0.171..3.581 rows=1,970 loops=1)

5. 0.383 0.514 ↓ 1.2 197 1

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

  • Recheck Cond: (budget_id = 'c181be3c-935b-408e-9ee1-ac0a2905f4da'::uuid)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=131
6. 0.131 0.131 ↓ 16.1 2,879 1

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

  • Index Cond: (budget_id = 'c181be3c-935b-408e-9ee1-ac0a2905f4da'::uuid)
7. 2.758 2.758 ↑ 1.4 10 197

Index Scan using index_budget_items_on_budget_entity on budget_items budget_items_1 (cost=0.11..34.03 rows=14 width=38) (actual time=0.007..0.014 rows=10 loops=197)

  • Index Cond: (budget_entity_id = budget_entities.id)
  • Filter: (deleted_at IS NULL)
8. 13.790 13.790 ↑ 1.0 1 1,970

Index Scan using budget_items_pkey on budget_items (cost=0.11..0.17 rows=1 width=88) (actual time=0.007..0.007 rows=1 loops=1,970)

  • Index Cond: (id = budget_items_1.id)