explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PdZv

Settings
# exclusive inclusive rows x rows loops node
1. 123.128 162.006 ↓ 1.0 60,186 1

Sort (cost=7,517.59..7,667.19 rows=59,840 width=239) (actual time=157.243..162.006 rows=60,186 loops=1)

  • Sort Key: aa.stop_location_id
  • Sort Method: quicksort Memory: 17517kB
2. 14.996 38.878 ↓ 1.0 60,186 1

Hash Right Join (cost=2,466.40..2,769.64 rows=59,840 width=239) (actual time=23.159..38.878 rows=60,186 loops=1)

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

Seq Scan on smart_stop bb (cost=0.00..216.04 rows=4,104 width=129) (actual time=0.002..0.746 rows=4,104 loops=1)

4. 15.499 23.136 ↑ 1.0 59,840 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 8866kB
5. 7.637 7.637 ↑ 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.008..7.637 rows=59,840 loops=1)

Total runtime : 164.070 ms