explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pH9s

Settings
# exclusive inclusive rows x rows loops node
1. 19.265 4,261.004 ↑ 9.7 15,080 1

Gather (cost=1,321.64..1,145,548.17 rows=145,725 width=20) (actual time=332.651..4,261.004 rows=15,080 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Functions: 54
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.037 ms, Inlining 27.328 ms, Optimization 147.023 ms, Emission 91.811 ms, Total 272.198 ms
2. 5.159 4,241.739 ↑ 11.4 7,540 2 / 2

Nested Loop (cost=321.64..1,129,975.67 rows=85,721 width=20) (actual time=322.607..4,241.739 rows=7,540 loops=2)

3. 0.482 141.879 ↑ 1.1 3,206 2 / 2

Parallel Append (cost=67.00..6,148.06 rows=3,662 width=52) (actual time=134.504..141.879 rows=3,206 loops=2)

4. 140.707 141.379 ↑ 1.1 3,206 2 / 2

Parallel Bitmap Heap Scan on network_points (cost=67.00..6,077.92 rows=3,634 width=40) (actual time=134.485..141.379 rows=3,206 loops=2)

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

Bitmap Index Scan on network_points_layer_id_idx (cost=0.00..65.45 rows=6,177 width=0) (actual time=1.344..1.344 rows=6,413 loops=1)

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

Parallel Index Scan using nonnetwork_polygons_layer_id_idx on nonnetwork_polygons (cost=0.42..44.94 rows=25 width=1,827) (actual time=0.007..0.007 rows=0 loops=1)

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

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

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

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

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

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

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
10. 500.214 4,094.701 ↑ 1.0 2 6,413 / 2

Bitmap Heap Scan on nonnetwork_polygons nonnetwork_polygons_1 (cost=254.65..306.87 rows=2 width=1,835) (actual time=1.136..1.277 rows=2 loops=6,413)

  • Recheck Cond: (layer_id = 613)
  • Filter: st_intersects(network_points.geom, geom)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=8,306
11. 4.386 3,594.486 ↓ 0.0 0 6,413 / 2

BitmapAnd (cost=254.65..254.65 rows=2 width=0) (actual time=1.121..1.121 rows=0 loops=6,413)

12. 497.007 497.007 ↑ 1.8 15 6,413 / 2

Bitmap Index Scan on nonnetwork_polygons_geom_idx (cost=0.00..0.96 rows=27 width=0) (actual time=0.155..0.155 rows=15 loops=6,413)

  • Index Cond: (geom && network_points.geom)
13. 3,093.093 3,093.093 ↓ 1.0 23,600 6,306 / 2

Bitmap Index Scan on nonnetwork_polygons_layer_id_idx (cost=0.00..247.58 rows=23,421 width=0) (actual time=0.981..0.981 rows=23,600 loops=6,306)

  • Index Cond: (layer_id = 613)
Execution time : 4,266.465 ms