explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zK7O

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1.129 ↑ 8.5 4 1

Nested Loop (cost=14.46..1,383.25 rows=34 width=132) (actual time=0.260..1.129 rows=4 loops=1)

2. 0.083 1.063 ↑ 8.5 4 1

Nested Loop (cost=14.05..1,361.95 rows=34 width=102) (actual time=0.234..1.063 rows=4 loops=1)

  • Join Filter: ((ps.route_path_id)::text = (path_stop.route_path_id)::text)
3. 0.005 0.552 ↑ 6.5 4 1

Nested Loop (cost=13.63..422.77 rows=26 width=96) (actual time=0.151..0.552 rows=4 loops=1)

4. 0.070 0.070 ↑ 1.0 1 1

Index Only Scan using index_stop on stop stop_1 (cost=0.41..8.43 rows=1 width=37) (actual time=0.069..0.070 rows=1 loops=1)

  • Index Cond: (id = '260ef2d1-256e-49f8-bcb6-f18fc88b7ddb'::text)
  • Heap Fetches: 1
5. 0.021 0.477 ↑ 6.5 4 1

Nested Loop (cost=13.22..414.08 rows=26 width=132) (actual time=0.078..0.477 rows=4 loops=1)

6. 0.142 0.180 ↑ 2.8 12 1

Bitmap Heap Scan on path_stop ps (cost=12.80..143.56 rows=33 width=72) (actual time=0.054..0.180 rows=12 loops=1)

  • Recheck Cond: ((stop_id)::text = '260ef2d1-256e-49f8-bcb6-f18fc88b7ddb'::text)
  • Heap Blocks: exact=12
7. 0.038 0.038 ↑ 2.8 12 1

Bitmap Index Scan on path_stop__index_stop_field (cost=0.00..12.79 rows=33 width=0) (actual time=0.038..0.038 rows=12 loops=1)

  • Index Cond: ((stop_id)::text = '260ef2d1-256e-49f8-bcb6-f18fc88b7ddb'::text)
8. 0.276 0.276 ↓ 0.0 0 12

Index Scan using "PK_ROUTE_PATH" on route_path rp (cost=0.41..8.19 rows=1 width=60) (actual time=0.023..0.023 rows=0 loops=12)

  • Index Cond: ((id)::text = (ps.route_path_id)::text)
  • Filter: active
  • Rows Removed by Filter: 1
9. 0.428 0.428 ↑ 1.0 1 4

Index Scan using "FK_path" on path_stop (cost=0.42..36.11 rows=1 width=72) (actual time=0.040..0.107 rows=1 loops=4)

  • Index Cond: ((route_path_id)::text = (rp.id)::text)
  • Filter: end_stop
  • Rows Removed by Filter: 29
10. 0.060 0.060 ↑ 1.0 1 4

Index Scan using index_stop on stop (cost=0.41..0.62 rows=1 width=67) (actual time=0.015..0.015 rows=1 loops=4)

  • Index Cond: ((id)::text = (path_stop.stop_id)::text)