explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4pd5

Settings
# exclusive inclusive rows x rows loops node
1. 680,229.026 787,824.554 ↓ 0.0 0 1

Update on gtfs_stop_times_history sth (cost=8.45..23,750.98 rows=1 width=145) (actual time=787,824.554..787,824.554 rows=0 loops=1)

2. 79,460.748 107,595.528 ↓ 999,753.0 999,753 1

Hash Join (cost=8.45..23,750.98 rows=1 width=145) (actual time=25,448.574..107,595.528 rows=999,753 loops=1)

  • Hash Cond: ((tt.trip_id = sth.trip_id) AND (tt.stop_sequence = sth.stop_sequence))
3. 3,117.455 3,117.455 ↑ 1.0 1,036,544 1

Seq Scan on gtfs_stop_times_temp tt (cost=0.00..15,968.44 rows=1,036,544 width=74) (actual time=0.388..3,117.455 rows=1,036,544 loops=1)

4. 2,856.855 25,017.325 ↓ 999,753.0 999,753 1

Hash (cost=8.43..8.43 rows=1 width=107) (actual time=25,017.325..25,017.325 rows=999,753 loops=1)

  • Buckets: 1024 Batches: 128 (originally 1) Memory Usage: 1025kB
5. 22,160.470 22,160.470 ↓ 999,753.0 999,753 1

Index Scan using gtfs_stop_times_history_t_range on gtfs_stop_times_history sth (cost=0.41..8.43 rows=1 width=107) (actual time=0.080..22,160.470 rows=999,753 loops=1)

  • Index Cond: (t_range = '["2014-08-01 07:00:01+00",infinity)'::tstzrange)