explain.depesz.com

PostgreSQL's explain analyze made readable

Result: no92

Settings
# exclusive inclusive rows x rows loops node
1. 37.320 3,286.088 ↑ 91.3 130,718 1

Gather (cost=1,068.42..19,173,510.90 rows=11,931,695 width=20) (actual time=245.700..3,286.088 rows=130,718 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Functions: 112
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 11.623 ms, Inlining 43.550 ms, Optimization 286.814 ms, Emission 157.497 ms, Total 499.483 ms
2. 11.271 3,248.768 ↑ 107.4 65,359 2 / 2

Nested Loop (cost=68.42..17,979,341.40 rows=7,018,644 width=20) (actual time=245.128..3,248.768 rows=65,359 loops=2)

3. 0.414 249.039 ↑ 1.1 3,206 2 / 2

Parallel Append (cost=68.14..6,117.02 rows=3,658 width=50) (actual time=245.006..249.039 rows=3,206 loops=2)

4. 248.145 248.610 ↑ 1.1 3,206 2 / 2

Parallel Bitmap Heap Scan on network_points network_points_1 (cost=68.14..6,076.72 rows=3,636 width=40) (actual time=244.990..248.610 rows=3,206 loops=2)

  • Recheck Cond: (layer_id = ANY ('{9}'::integer[]))
  • Heap Blocks: exact=1,639
5. 0.465 0.465 ↓ 1.0 6,413 1 / 2

Bitmap Index Scan on network_points_layer_id_idx (cost=0.00..66.59 rows=6,182 width=0) (actual time=0.930..0.930 rows=6,413 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
6. 0.003 0.003 ↓ 0.0 0 1 / 2

Parallel Index Scan using nonnetwork_polygons_layer_id_idx on nonnetwork_polygons nonnetwork_polygons_1 (cost=0.42..15.12 rows=19 width=1,880) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
7. 0.002 0.002 ↓ 0.0 0 1 / 2

Parallel Index Scan using network_lines_layer_id_idx on network_lines network_lines_1 (cost=0.42..2.64 rows=1 width=116) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
8. 0.003 0.003 ↓ 0.0 0 1 / 2

Parallel Index Scan using nonnetwork_points_layer_id_idx on nonnetwork_points nonnetwork_points_1 (cost=0.42..1.63 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
9. 0.007 0.007 ↓ 0.0 0 1 / 2

Parallel Index Scan using nonnetwork_lines_layer_id_idx on nonnetwork_lines nonnetwork_lines_1 (cost=0.41..2.62 rows=1 width=94) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
10. 12.826 2,988.458 ↑ 9.6 20 6,413 / 2

Append (cost=0.29..4,911.48 rows=192 width=316) (actual time=0.090..0.932 rows=20 loops=6,413)

11. 480.975 480.975 ↑ 27.7 3 6,413 / 2

Index Scan using network_points_geom_idx on network_points (cost=0.29..2,120.54 rows=83 width=48) (actual time=0.090..0.150 rows=3 loops=6,413)

  • Index Cond: (geom && network_points_1.geom)
  • Filter: st_intersects(network_points_1.geom, geom)
  • Rows Removed by Filter: 1
12. 750.321 750.321 ↑ 4.6 7 6,413 / 2

Index Scan using network_lines_geom_idx on network_lines (cost=0.28..818.14 rows=32 width=124) (actual time=0.123..0.234 rows=7 loops=6,413)

  • Index Cond: (geom && network_points_1.geom)
  • Filter: st_intersects(network_points_1.geom, geom)
  • Rows Removed by Filter: 14
13. 128.260 128.260 ↑ 24.0 2 6,413 / 2

Index Scan using nonnetwork_points_geom_idx on nonnetwork_points (cost=0.29..1,227.26 rows=48 width=48) (actual time=0.037..0.040 rows=2 loops=6,413)

  • Index Cond: (geom && network_points_1.geom)
  • Filter: st_intersects(network_points_1.geom, geom)
  • Rows Removed by Filter: 6
14. 22.445 22.445 ↓ 0.0 0 6,413 / 2

Index Scan using nonnetwork_lines_geom_idx on nonnetwork_lines (cost=0.28..52.97 rows=2 width=102) (actual time=0.007..0.007 rows=0 loops=6,413)

  • Index Cond: (geom && network_points_1.geom)
  • Filter: st_intersects(network_points_1.geom, geom)
  • Rows Removed by Filter: 0
15. 1,593.630 1,593.630 ↑ 3.0 9 6,413 / 2

Index Scan using nonnetwork_polygons_geom_idx on nonnetwork_polygons (cost=0.28..691.61 rows=27 width=1,888) (actual time=0.151..0.497 rows=9 loops=6,413)

  • Index Cond: (geom && network_points_1.geom)
  • Filter: st_intersects(network_points_1.geom, geom)
  • Rows Removed by Filter: 6
Execution time : 3,300.022 ms