explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EH1h

Settings
# exclusive inclusive rows x rows loops node
1. 927.731 4,842.441 ↑ 10.2 15,080 1

Gather (cost=1,251.65..1,204,340.79 rows=153,474 width=20) (actual time=339.804..4,842.441 rows=15,080 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Functions: 54
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 4.799 ms, Inlining 30.534 ms, Optimization 158.288 ms, Emission 95.891 ms, Total 289.512 ms
2. 3.776 3,914.710 ↑ 12.0 7,540 2 / 2

Nested Loop (cost=251.65..1,187,993.39 rows=90,279 width=20) (actual time=246.639..3,914.710 rows=7,540 loops=2)

3. 0.468 146.503 ↑ 1.2 3,206 2 / 2

Parallel Append (cost=0.42..2,335.48 rows=3,907 width=51) (actual time=142.603..146.503 rows=3,206 loops=2)

4. 146.021 146.021 ↑ 1.2 3,206 2 / 2

Parallel Index Scan using network_points_layer_id_idx on network_points (cost=0.42..2,261.23 rows=3,879 width=40) (actual time=142.588..146.021 rows=3,206 loops=2)

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

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

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
6. 0.002 0.002 ↓ 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.004..0.004 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 nonnetwork_points_layer_id_idx on nonnetwork_points (cost=0.42..1.63 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
8. 0.007 0.007 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
9. 362.334 3,764.431 ↑ 1.0 2 6,413 / 2

Bitmap Heap Scan on nonnetwork_polygons nonnetwork_polygons_1 (cost=251.23..303.45 rows=2 width=1,835) (actual time=1.083..1.174 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=4,866
10. 2.353 3,402.096 ↓ 0.0 0 6,413 / 2

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

11. 426.465 426.465 ↑ 1.8 15 6,413 / 2

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

  • Index Cond: (geom && network_points.geom)
12. 2,973.279 2,973.279 ↓ 1.0 23,600 6,306 / 2

Bitmap Index Scan on nonnetwork_polygons_layer_id_idx (cost=0.00..244.20 rows=23,117 width=0) (actual time=0.943..0.943 rows=23,600 loops=6,306)

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