explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ROCB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.028 ↓ 0.0 0 1

Update on judah.tickets t (cost=13.03..846,277.93 rows=25,906 width=950) (actual time=0.028..0.028 rows=0 loops=1)

  • Buffers: shared hit=15
2.          

Initplan (for Update)

3. 0.016 0.016 ↑ 3.0 1 1

Seq Scan on judah.last_run (cost=0.00..13.03 rows=3 width=8) (actual time=0.015..0.016 rows=1 loops=1)

  • Output: last_run.last_run
  • Buffers: shared hit=13
4. 0.002 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.00..846,264.90 rows=25,906 width=950) (actual time=0.028..0.028 rows=0 loops=1)

  • Output: t.id, t.number, t.on_seal_number, t.off_seal_number, t.tank_id, t.created_by, t.tank_name, t.stop_id, stops.name, stops.route_id, t.client_day, t.nri, t.operator, t.ticket_date, t.product, t.disposition, t.transporter, t.load_time, t.open_gauge_temperature, t.close_gauge_temperature, t.observed_temperature, t.observed_gravity, t.gross_volume_calculated, t.gross_volume, t.net_volume, t.corrected_gravity, t.open_gauge, t.open_gauge_bbl, t.close_gauge, t.close_gauge_bbl, t.ticket_volume, t.trucking_co, t.operating_co, t.well_name, t.start_time, t.end_time, t.volume_disposed, t.water_source, t.company_name, t.lease_name, t.lane_selection, t.trucker_id, t.driver_name, t.field_ticket_no, t.ctid, stops.ctid
  • Join Filter: (t.stop_id = stops.id)
  • Buffers: shared hit=15
5. 0.026 0.026 ↓ 0.0 0 1

Seq Scan on judah.stg_stops stops (cost=0.00..2.01 rows=1 width=76) (actual time=0.026..0.026 rows=0 loops=1)

  • Output: stops.name, stops.route_id, stops.ctid, stops.id
  • Filter: (stops.updated_at >= $0)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=15
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on judah.tickets t (cost=0.00..845,939.06 rows=25,906 width=896) (never executed)

  • Output: t.id, t.number, t.on_seal_number, t.off_seal_number, t.tank_id, t.created_by, t.tank_name, t.stop_id, t.client_day, t.nri, t.operator, t.ticket_date, t.product, t.disposition, t.transporter, t.load_time, t.open_gauge_temperature, t.close_gauge_temperature, t.observed_temperature, t.observed_gravity, t.gross_volume_calculated, t.gross_volume, t.net_volume, t.corrected_gravity, t.open_gauge, t.open_gauge_bbl, t.close_gauge, t.close_gauge_bbl, t.ticket_volume, t.trucking_co, t.operating_co, t.well_name, t.start_time, t.end_time, t.volume_disposed, t.water_source, t.company_name, t.lease_name, t.lane_selection, t.trucker_id, t.driver_name, t.field_ticket_no, t.ctid