explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uSp3

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 0.164 ↓ 0.0 0 1

Update on budget_items (cost=0.11..412.36 rows=100 width=298) (actual time=0.164..0.164 rows=0 loops=1)

2. 0.018 0.126 ↑ 10.0 10 1

Nested Loop (cost=0.11..412.36 rows=100 width=298) (actual time=0.048..0.126 rows=10 loops=1)

3. 0.009 0.018 ↑ 10.0 10 1

Subquery Scan on data_table (cost=0.00..0.46 rows=100 width=280) (actual time=0.010..0.018 rows=10 loops=1)

4. 0.008 0.009 ↑ 10.0 10 1

ProjectSet (cost=0.00..0.16 rows=100 width=128) (actual time=0.005..0.009 rows=10 loops=1)

5. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

6. 0.090 0.090 ↑ 1.0 1 10

Index Scan using budget_items_pkey on budget_items (cost=0.11..4.12 rows=1 width=96) (actual time=0.009..0.009 rows=1 loops=10)

  • Index Cond: (id = (data_table.budget_item_id)::uuid)
Planning time : 0.191 ms
Execution time : 0.223 ms