explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GgG

Settings
# exclusive inclusive rows x rows loops node
1. 113.520 199.711 ↓ 0.0 0 1

Update on budget_items (cost=41,846.11..43,973.88 rows=12,088 width=117) (actual time=199.711..199.711 rows=0 loops=1)

2. 0.790 86.191 ↑ 1.1 11,214 1

Nested Loop (cost=41,846.11..43,973.88 rows=12,088 width=117) (actual time=25.949..86.191 rows=11,214 loops=1)

3. 7.366 29.331 ↑ 1.1 11,214 1

HashAggregate (cost=41,846.00..41,882.26 rows=12,088 width=28) (actual time=25.938..29.331 rows=11,214 loops=1)

  • Group Key: budget_items_1.id
4. 1.992 21.965 ↑ 1.1 11,214 1

Nested Loop (cost=26.30..41,839.95 rows=12,088 width=28) (actual time=2.492..21.965 rows=11,214 loops=1)

5. 2.727 5.021 ↓ 1.0 1,246 1

Bitmap Heap Scan on budget_entities (cost=26.19..2,325.64 rows=1,197 width=22) (actual time=2.474..5.021 rows=1,246 loops=1)

  • Recheck Cond: (budget_id = '668c3e6e-534e-4aed-846f-c5b307cc39ea'::uuid)
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 16
  • Heap Blocks: exact=1487
6. 2.294 2.294 ↓ 34.5 46,996 1

Bitmap Index Scan on index_budget_entities_on_budget (cost=0.00..26.13 rows=1,362 width=0) (actual time=2.294..2.294 rows=46,996 loops=1)

  • Index Cond: (budget_id = '668c3e6e-534e-4aed-846f-c5b307cc39ea'::uuid)
7. 14.952 14.952 ↑ 1.6 9 1,246

Index Scan using index_budget_items_on_budget_entity on budget_items budget_items_1 (cost=0.11..32.97 rows=14 width=38) (actual time=0.005..0.012 rows=9 loops=1,246)

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

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

  • Index Cond: (id = budget_items_1.id)
Planning time : 0.475 ms
Execution time : 199.851 ms