explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r2bC : Optimization for: plan #Agfi

Settings

Optimization path:

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

Update on judah.tickets tc (cost=233.70..93,725.31 rows=7,402 width=965) (actual time=0.049..0.049 rows=0 loops=1)

  • Buffers: shared hit=39
2.          

Initplan (for Update)

3. 0.023 0.023 ↑ 3.0 1 1

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

  • Output: last_run.last_run
  • Buffers: shared hit=13
4. 0.001 0.049 ↓ 0.0 0 1

Nested Loop (cost=220.67..93,712.28 rows=7,402 width=965) (actual time=0.049..0.049 rows=0 loops=1)

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

Seq Scan on judah.stg_items items (cost=0.00..26.09 rows=2 width=44) (actual time=0.048..0.048 rows=0 loops=1)

  • Output: items.name, items.ctid, items.id
  • Filter: (items.updated_at >= $0)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=39
6. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on judah.tickets tc (cost=220.67..46,713.57 rows=12,953 width=927) (never executed)

  • Output: tc.id, tc.number, tc.on_seal_number, tc.off_seal_number, tc.tank_id, tc.created_by, tc.stop_id, tc.stop_name, tc.route_id, tc.client_day, tc.nri, tc.operator, tc.ticket_date, tc.product, tc.disposition, tc.transporter, tc.load_time, tc.open_gauge_temperature, tc.close_gauge_temperature, tc.observed_temperature, tc.observed_gravity, tc.gross_volume_calculated, tc.gross_volume, tc.net_volume, tc.corrected_gravity, tc.open_gauge, tc.open_gauge_bbl, tc.close_gauge, tc.close_gauge_bbl, tc.ticket_volume, tc.trucking_co, tc.operating_co, tc.well_name, tc.start_time, tc.end_time, tc.volume_disposed, tc.water_source, tc.company_name, tc.lease_name, tc.lane_selection, tc.trucker_id, tc.driver_name, tc.field_ticket_no, tc.ctid
  • Recheck Cond: (tc.tank_id = items.id)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_tickets_tank_id (cost=0.00..217.43 rows=12,953 width=0) (never executed)

  • Index Cond: (tc.tank_id = items.id)