explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vz8Y

Settings
# exclusive inclusive rows x rows loops node
1. 121.705 145.455 ↓ 1.0 60,186 1

Sort (cost=7,425.59..7,575.19 rows=59,840 width=239) (actual time=140.731..145.455 rows=60,186 loops=1)

  • Sort Key: aa.stop_location_id
  • Sort Method: quicksort Memory: 17,517kB
2. 13.193 23.750 ↓ 1.0 60,186 1

Hash Right Join (cost=2,466.40..2,677.64 rows=59,840 width=239) (actual time=10.317..23.750 rows=60,186 loops=1)

  • Hash Cond: ((bb.stop_id)::text = (aa.id)::text)
3. 0.254 0.254 ↑ 1.0 4,104 1

Seq Scan on smart_stop_copy bb (cost=0.00..124.04 rows=4,104 width=129) (actual time=0.002..0.254 rows=4,104 loops=1)

4. 6.520 10.303 ↑ 1.0 59,840 1

Hash (cost=1,718.40..1,718.40 rows=59,840 width=110) (actual time=10.303..10.303 rows=59,840 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 8,866kB
5. 3.783 3.783 ↑ 1.0 59,840 1

Seq Scan on stop_2019_12 aa (cost=0.00..1,718.40 rows=59,840 width=110) (actual time=0.004..3.783 rows=59,840 loops=1)

Total runtime : 147.380 ms