explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vUND : Optimization for: plan #GTvW

Settings

Optimization path:

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

Update on judah.tank_inventories ti (cost=39.14..52.33 rows=2 width=336) (actual time=0.004..0.004 rows=0 loops=1)

2.          

Initplan (for Update)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on judah.last_run (cost=0.00..13.03 rows=3 width=8) (never executed)

  • Output: last_run.last_run
4. 0.002 0.003 ↓ 0.0 0 1

Hash Join (cost=26.11..39.30 rows=2 width=336) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: ti.item_id, ti.client_day, ti.stop_id, items.name, ti.top_gauge, ti.top_gauge_bbl, ti.bottom_gauge, ti.bottom_gauge_bbl, ti.oil_inventory, ti.water_inventory, items.sub_type_code, ti.completion_id, ti.ctid, items.ctid
  • Hash Cond: (ti.item_id = items.id)
5. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on judah.tank_inventories ti (cost=0.00..12.30 rows=230 width=266) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: ti.item_id, ti.client_day, ti.stop_id, ti.top_gauge, ti.top_gauge_bbl, ti.bottom_gauge, ti.bottom_gauge_bbl, ti.oil_inventory, ti.water_inventory, ti.completion_id, ti.ctid
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=26.09..26.09 rows=2 width=48) (never executed)

  • Output: items.name, items.sub_type_code, items.ctid, items.id
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on judah.stg_items items (cost=0.00..26.09 rows=2 width=48) (never executed)

  • Output: items.name, items.sub_type_code, items.ctid, items.id
  • Filter: (items.updated_at >= $0)