explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SJ1K

Settings
# exclusive inclusive rows x rows loops node
1. 456.405 3,487.367 ↓ 0.0 0 1

Delete on event_seat_state_change essc1 (cost=168,687.77..259,556.84 rows=1,276,337 width=12) (actual time=3,487.367..3,487.367 rows=0 loops=1)

2. 1,038.494 3,030.962 ↑ 7.3 175,938 1

Hash Join (cost=168,687.77..259,556.84 rows=1,276,337 width=12) (actual time=1,529.810..3,030.962 rows=175,938 loops=1)

  • Hash Cond: (essc1.event_id = e1.id)
3. 465.596 465.596 ↑ 1.0 1,656,828 1

Seq Scan on event_seat_state_change essc1 (cost=0.00..64,300.80 rows=1,680,480 width=10) (actual time=0.016..465.596 rows=1,656,828 loops=1)

4. 332.674 1,526.872 ↓ 1.0 1,183,675 1

Hash (cost=148,238.10..148,238.10 rows=1,176,373 width=10) (actual time=1,526.871..1,526.872 rows=1,183,675 loops=1)

  • Buckets: 1048576 Batches: 4 Memory Usage: 20923kB
5. 1,194.198 1,194.198 ↓ 1.0 1,183,675 1

Seq Scan on event e1 (cost=0.00..148,238.10 rows=1,176,373 width=10) (actual time=0.024..1,194.198 rows=1,183,675 loops=1)

  • Filter: (start_time < (now() - '6 days'::interval))
  • Rows Removed by Filter: 373225
Planning time : 0.429 ms
Execution time : 131,928.684 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint event_seat_state_change_seat_st_event_seat_state_change_id_fkey on event_seat_state_change 96,630.127 ms 175938 0.549 ms
for constraint current_event_state_first_event_seat_state_change_id_fkey on event_seat_state_change 11,094.745 ms 175938 0.063 ms
for constraint current_event_state_last_event_seat_state_change_id_fkey on event_seat_state_change 19,510.616 ms 175938 0.111 ms
for constraint current_event_state_last_event_seating_plan_change_id_fkey on current_event 1,061.001 ms 22461 0.047 ms
for constraint current_event_state_last_event_seating_quantitative_summar_fkey on current_event 57.758 ms 208 0.278 ms