explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wqyTx

Settings
# exclusive inclusive rows x rows loops node
1. 24.374 4,167.597 ↑ 9.6 15,080 1

Gather (cost=1,068.56..1,554,895.43 rows=145,054 width=24) (actual time=222.938..4,167.597 rows=15,080 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Functions: 104
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.140 ms, Inlining 31.170 ms, Optimization 266.163 ms, Emission 154.191 ms, Total 457.664 ms
2. 3.262 4,143.223 ↑ 11.3 7,540 2 / 2

Nested Loop (cost=68.56..1,539,390.03 rows=85,326 width=24) (actual time=228.704..4,143.223 rows=7,540 loops=2)

3. 0.460 231.238 ↑ 1.1 3,206 2 / 2

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

4. 230.503 230.753 ↑ 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=226.483..230.753 rows=3,206 loops=2)

  • Recheck Cond: (layer_id = ANY ('{9}'::integer[]))
  • Heap Blocks: exact=1,579
5. 0.250 0.250 ↓ 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.500..0.500 rows=6,413 loops=1)

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
6. 0.002 0.002 ↓ 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.004..0.004 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.005..0.005 rows=0 loops=1)

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

  • Index Cond: (layer_id = ANY ('{9}'::integer[]))
10. 9.620 3,908.724 ↑ 3.0 2 6,413 / 2

Append (cost=0.42..419.10 rows=6 width=1,892) (actual time=1.164..1.219 rows=2 loops=6,413)

11. 3.207 3.207 ↓ 0.0 0 6,413 / 2

Index Scan using network_points_layer_id_idx on network_points (cost=0.42..27.64 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=6,413)

  • Index Cond: (layer_id = 613)
  • Filter: st_intersects(network_points_1.geom, geom)
12. 3.207 3.207 ↓ 0.0 0 6,413 / 2

Index Scan using network_lines_layer_id_idx on network_lines (cost=0.42..27.64 rows=1 width=128) (actual time=0.001..0.001 rows=0 loops=6,413)

  • Index Cond: (layer_id = 613)
  • Filter: st_intersects(network_points_1.geom, geom)
13. 3.207 3.207 ↓ 0.0 0 6,413 / 2

Index Scan using nonnetwork_points_layer_id_idx on nonnetwork_points (cost=0.42..26.63 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=6,413)

  • Index Cond: (layer_id = 613)
  • Filter: st_intersects(network_points_1.geom, geom)
14. 3.207 3.207 ↓ 0.0 0 6,413 / 2

Index Scan using nonnetwork_lines_layer_id_idx on nonnetwork_lines (cost=0.41..27.63 rows=1 width=106) (actual time=0.001..0.001 rows=0 loops=6,413)

  • Index Cond: (layer_id = 613)
  • Filter: st_intersects(network_points_1.geom, geom)
15. 205.216 3,886.278 ↑ 1.0 2 6,413 / 2

Bitmap Heap Scan on nonnetwork_polygons (cost=257.30..309.53 rows=2 width=1,892) (actual time=1.158..1.212 rows=2 loops=6,413)

  • Recheck Cond: (layer_id = 613)
  • Filter: st_intersects(network_points_1.geom, geom)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=11,160
16. 5.991 3,681.062 ↓ 0.0 0 6,413 / 2

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

17. 487.388 487.388 ↑ 1.8 15 6,413 / 2

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

  • Index Cond: (geom && network_points_1.geom)
18. 3,187.683 3,187.683 ↓ 1.0 23,600 6,306 / 2

Bitmap Index Scan on nonnetwork_polygons_layer_id_idx (cost=0.00..250.15 rows=23,324 width=0) (actual time=1.011..1.011 rows=23,600 loops=6,306)

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