explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8mEEZ

Settings
# exclusive inclusive rows x rows loops node
1. 63.888 803.486 ↑ 27.4 14,689 1

Unique (cost=61,132.18..68,165.53 rows=401,906 width=28) (actual time=645.505..803.486 rows=14,689 loops=1)

  • Buffers: shared hit=5,134, temp read=867 written=871
2. 398.862 739.598 ↑ 2.3 172,202 1

Sort (cost=61,132.18..62,136.94 rows=401,906 width=28) (actual time=645.504..739.598 rows=172,202 loops=1)

  • Sort Key: r.id, t.shape_id, r.agency_id, r.type, r.short_name, r.feed_id
  • Sort Method: external merge Disk: 6,936kB
  • Buffers: shared hit=5,134, temp read=867 written=871
3. 87.172 340.736 ↑ 2.3 172,202 1

Hash Join (cost=842.81..14,103.76 rows=401,906 width=28) (actual time=11.39..340.736 rows=172,202 loops=1)

  • Buffers: shared hit=5,134
4. 201.331 243.958 ↑ 1.0 401,906 1

Hash Join (cost=115.33..11,266.21 rows=401,906 width=32) (actual time=1.756..243.958 rows=401,906 loops=1)

  • Buffers: shared hit=5,059
5. 40.886 40.886 ↑ 1.0 401,906 1

Seq Scan on trip t (cost=0..9,040.06 rows=401,906 width=20) (actual time=0.004..40.886 rows=401,906 loops=1)

  • Buffers: shared hit=5,021
6. 0.942 1.741 ↑ 1.0 3,093 1

Hash (cost=68.93..68.93 rows=3,093 width=23) (actual time=1.74..1.741 rows=3,093 loops=1)

  • Buffers: shared hit=38
7. 0.799 0.799 ↑ 1.0 3,093 1

Seq Scan on route r (cost=0..68.93 rows=3,093 width=23) (actual time=0.004..0.799 rows=3,093 loops=1)

  • Buffers: shared hit=38
8. 7.149 9.606 ↑ 1.0 14,240 1

Hash (cost=513.88..513.88 rows=14,240 width=9) (actual time=9.606..9.606 rows=14,240 loops=1)

  • Buffers: shared hit=75
9. 2.457 2.457 ↑ 1.0 14,240 1

Index Only Scan using shape_line_pkey on shape_line sl (cost=0.29..513.88 rows=14,240 width=9) (actual time=0.015..2.457 rows=14,240 loops=1)

  • Buffers: shared hit=75
Planning time : 0.743 ms
Execution time : 805.916 ms