explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zmK2

Settings
# exclusive inclusive rows x rows loops node
1. 89.437 4,100.883 ↓ 541.2 180,207 1

Subquery Scan on z (cost=24.21..3,222.64 rows=333 width=48) (actual time=3,751.187..4,100.883 rows=180,207 loops=1)

  • Filter: (st_perimeter(z.geom) < '3000'::double precision)
2. 17.110 4,011.446 ↓ 180.2 180,207 1

Result (cost=24.21..2,791.98 rows=1,000 width=32) (actual time=3,751.181..4,011.446 rows=180,207 loops=1)

3. 3,258.107 3,994.336 ↓ 180.2 180,207 1

ProjectSet (cost=24.21..31.98 rows=1,000 width=32) (actual time=3,751.174..3,994.336 rows=180,207 loops=1)

4. 53.730 736.229 ↑ 1.0 1 1

Aggregate (cost=24.21..24.22 rows=1 width=32) (actual time=736.229..736.229 rows=1 loops=1)

5. 101.696 682.499 ↓ 178.0 178,038 1

ProjectSet (cost=5.94..11.71 rows=1,000 width=40) (actual time=564.760..682.499 rows=178,038 loops=1)

6. 8.133 580.803 ↓ 77,015.0 77,015 1

Result (cost=5.94..6.20 rows=1 width=40) (actual time=564.736..580.803 rows=77,015 loops=1)

7. 30.280 572.670 ↓ 77,015.0 77,015 1

Sort (cost=5.94..5.94 rows=1 width=40) (actual time=564.733..572.670 rows=77,015 loops=1)

  • Sort Key: (st_zmax((c.geom)::box3d))
  • Sort Method: quicksort Memory: 15843kB
8. 22.261 542.390 ↓ 77,015.0 77,015 1

Subquery Scan on c (cost=5.66..5.93 rows=1 width=40) (actual time=464.492..542.390 rows=77,015 loops=1)

9. 43.783 520.129 ↓ 77,015.0 77,015 1

Unique (cost=5.66..5.66 rows=1 width=72) (actual time=464.483..520.129 rows=77,015 loops=1)

10. 326.160 476.346 ↓ 77,015.0 77,015 1

Sort (cost=5.66..5.66 rows=1 width=72) (actual time=464.480..476.346 rows=77,015 loops=1)

  • Sort Key: (st_force2d(t.geom)), (st_zmax((t.geom)::box3d))
  • Sort Method: quicksort Memory: 23639kB
11. 150.186 150.186 ↓ 77,015.0 77,015 1

Index Scan using idx_spanning_tree_point_id on spanning_tree t (cost=0.56..5.65 rows=1 width=72) (actual time=0.090..150.186 rows=77,015 loops=1)

  • Index Cond: (point_id = '7bc84062-7367-4685-a26e-26a030832352'::uuid)
Planning time : 0.403 ms
Execution time : 4,106.199 ms