explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8gAS

Settings
# exclusive inclusive rows x rows loops node
1. 0.158 29.220 ↑ 4.8 61 1

Sort (cost=9,711.47..9,712.20 rows=292 width=152) (actual time=29.208..29.220 rows=61 loops=1)

  • Sort Key: checkpoints.order_number
  • Sort Method: quicksort Memory: 41kB
  • Buffers: shared hit=1,265 read=295
2. 0.095 29.062 ↑ 4.8 61 1

Nested Loop Left Join (cost=2.66..9,699.52 rows=292 width=152) (actual time=1.289..29.062 rows=61 loops=1)

  • Buffers: shared hit=1,265 read=295
3. 0.109 28.418 ↑ 4.8 61 1

Nested Loop Left Join (cost=2.24..7,432.21 rows=292 width=150) (actual time=1.189..28.418 rows=61 loops=1)

  • Buffers: shared hit=1,026 read=290
4. 0.104 26.540 ↑ 4.8 61 1

Nested Loop (cost=1.83..5,164.91 rows=292 width=148) (actual time=0.988..26.540 rows=61 loops=1)

  • Buffers: shared hit=797 read=275
5. 0.172 18.372 ↑ 1.8 56 1

Nested Loop (cost=1.25..1,343.70 rows=100 width=78) (actual time=0.750..18.372 rows=56 loops=1)

  • Buffers: shared hit=589 read=203
6. 9.688 9.688 ↑ 1.8 56 1

Index Scan using posting_route_pkey on posting_route (cost=0.56..472.70 rows=100 width=73) (actual time=0.432..9.688 rows=56 loops=1)

  • Index Cond: (posting_id = ANY ('{18865610425000, ...}'::bigint[]))
  • Buffers: shared hit=332 read=124
7. 8.512 8.512 ↑ 1.0 1 56

Index Scan using route_uid_index on routes (cost=0.69..8.71 rows=1 width=70) (actual time=0.152..0.152 rows=1 loops=56)

  • Index Cond: (uid = posting_route.route_uid)
  • Buffers: shared hit=257 read=79
8. 8.064 8.064 ↑ 345.0 1 56

Index Scan using checkpoints_route_id_index on checkpoints (cost=0.57..34.76 rows=345 width=74) (actual time=0.143..0.144 rows=1 loops=56)

  • Index Cond: (route_id = routes.id)
  • Buffers: shared hit=208 read=72
9. 1.769 1.769 ↑ 1.0 1 61

Index Scan using points_pkey on points start_point (cost=0.41..7.76 rows=1 width=10) (actual time=0.029..0.029 rows=1 loops=61)

  • Index Cond: (checkpoints.start_point_id = geo_id)
  • Buffers: shared hit=229 read=15
10. 0.549 0.549 ↑ 1.0 1 61

Index Scan using points_pkey on points end_point (cost=0.41..7.76 rows=1 width=10) (actual time=0.009..0.009 rows=1 loops=61)

  • Index Cond: (checkpoints.end_point_id = geo_id)
  • Buffers: shared hit=239 read=5
Planning time : 4.068 ms
Execution time : 29.343 ms