explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kxVZ

Settings
# exclusive inclusive rows x rows loops node
1. 28,820.548 28,820.548 ↑ 1.0 1 1

CTE Scan on quartiers_statistiques (cost=23.30..23.32 rows=1 width=1,604) (actual time=28,820.548..28,820.548 rows=1 loops=1)

2.          

CTE geom

3. 0.549 1.109 ↑ 1.0 1 1

Aggregate (cost=2.39..2.40 rows=1 width=32) (actual time=1.108..1.109 rows=1 loops=1)

4.          

Initplan (forAggregate)

5. 0.526 0.558 ↑ 1.0 1 1

Aggregate (cost=2.37..2.38 rows=1 width=32) (actual time=0.558..0.558 rows=1 loops=1)

6. 0.032 0.032 ↑ 1.0 1 1

Index Scan using utilisateurs_geometries_pkey on utilisateurs_geometries (cost=0.14..2.36 rows=1 width=62,164) (actual time=0.031..0.032 rows=1 loops=1)

  • Index Cond: (id = 1808)
7. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

8.          

CTE quartiers_rapport_surface

9. 19,570.030 28,809.058 ↓ 8.9 205 1

Nested Loop (cost=0.28..12.60 rows=23 width=1,152) (actual time=173.148..28,809.058 rows=205 loops=1)

10. 1.396 1.396 ↑ 1.0 1 1

CTE Scan on geom (cost=0.00..0.02 rows=1 width=32) (actual time=1.393..1.396 rows=1 loops=1)

11. 9,237.632 9,237.632 ↓ 102.5 205 1

Index Scan using codata_eu_geo_quartiers_statistiques_geom1_idx on geo_quartiers_statistiques (cost=0.28..9.22 rows=2 width=2,490) (actual time=70.587..9,237.632 rows=205 loops=1)

  • Index Cond: (geom && geom.geometrie)
  • Filter: st_relate(geom, geom.geometrie, 'T********'::text)
  • Rows Removed by Filter: 96
12.          

CTE quartiers_statistiques

13. 9.123 28,820.537 ↑ 1.0 1 1

Aggregate (cost=8.10..8.31 rows=1 width=1,604) (actual time=28,820.536..28,820.537 rows=1 loops=1)

14. 28,811.414 28,811.414 ↓ 8.9 205 1

CTE Scan on quartiers_rapport_surface (cost=0.00..0.46 rows=23 width=1,152) (actual time=173.162..28,811.414 rows=205 loops=1)

Planning time : 2.836 ms
Execution time : 28,822.621 ms