explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YgC

options
# exclusive inclusive rows x rows loops node
1. 510.879 856.473 ↓ 118.0 118 1
→

Nested Loop (cost=31.75..1736.07 rows=1 width=202) (actual time=193.415..856.473 rows=118 loops=1)

  • Join Filter: (((SubPlan 9)) = centrality.gnat_symbology_conf.subclass_name)
2.          

Initplan (forNested Loop)
3. 0.002 0.002 ↑ 1.0 1 1
→

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

4. 0.213 0.213 ↑ 1.0 1 1
→

Result (cost=0.00..0.26 rows=1 width=0) (actual time=0.212..0.213 rows=1 loops=1)

5. 0.343 0.343 ↑ 1.0 1 1
→

Result (cost=0.00..0.26 rows=1 width=0) (actual time=0.342..0.343 rows=1 loops=1)

6. 0.186 0.186 ↑ 1.0 1 1
→

Result (cost=0.00..0.26 rows=1 width=0) (actual time=0.185..0.186 rows=1 loops=1)

7. 0.615 0.615 ↑ 1.0 1 1
→

Index Scan using gnat_symbology_conf_pkey on gnat_symbology_conf (cost=0.00..4.88 rows=1 width=112) (actual time=0.613..0.615 rows=1 loops=1)

  • Index Cond: (dataview = 'gnat_switching_device'::text)
  • Filter: ((($2)::double precision >= min_scale) AND ((max_scale IS NULL) OR (max_scale >= ($3)::double precision)))
8. 2.250 344.235 ↓ 2.4 118 1
→

Result (cost=30.96..1728.24 rows=49 width=348) (actual time=186.673..344.235 rows=118 loops=1)

  • One-Time Filter: (($18)::integer = 1)
9.          

CTE symb_cfg
10. 0.004 0.414 ↑ 1.0 1 1
→

Result (cost=5.40..10.27 rows=1 width=151) (actual time=0.410..0.414 rows=1 loops=1)

  • One-Time Filter: $6
11.          

Initplan (forResult)
12. 0.035 0.396 ↑ 1.0 1 1
→

Index Scan using gnat_symbology_conf_pkey on gnat_symbology_conf (cost=0.53..5.40 rows=1 width=0) (actual time=0.396..0.396 rows=1 loops=1)

  • Index Cond: (dataview = 'gnat_switching_device'::text)
  • Filter: ((($4)::double precision >= min_scale) AND (($5)::double precision <= COALESCE(max_scale, 100000000::double precision)))
13.          

Initplan (forIndex Scan)
14. 0.195 0.195 ↑ 1.0 1 1
→

Result (cost=0.00..0.26 rows=1 width=0) (actual time=0.194..0.195 rows=1 loops=1)

15. 0.166 0.166 ↑ 1.0 1 1
→

Result (cost=0.00..0.26 rows=1 width=0) (actual time=0.166..0.166 rows=1 loops=1)

16. 0.014 0.014 ↑ 1.0 1 1
→

Index Scan using gnat_symbology_conf_pkey on gnat_symbology_conf (cost=0.00..4.87 rows=1 width=151) (actual time=0.011..0.014 rows=1 loops=1)

  • Index Cond: ((dataview = 'gnat_switching_device'::text) AND (subclass_name = 'gnat_switching_device'::text))
17.          

Initplan (forResult)
18. 0.665 0.665 ↑ 1.0 1 1
→

Result (cost=0.00..0.51 rows=1 width=0) (actual time=0.664..0.665 rows=1 loops=1)

19. 0.604 0.604 ↑ 1.0 1 1
→

Result (cost=0.00..0.51 rows=1 width=0) (actual time=0.604..0.604 rows=1 loops=1)

20. 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)

21. 0.206 337.882 ↓ 2.4 118 1
→

Nested Loop (cost=19.65..1477.70 rows=49 width=348) (actual time=185.955..337.882 rows=118 loops=1)

22. 0.422 0.422 ↑ 1.0 1 1
→

CTE Scan on symb_cfg (cost=0.00..0.02 rows=1 width=0) (actual time=0.415..0.422 rows=1 loops=1)

23. 84.655 337.254 ↓ 2.4 118 1
→

Nested Loop (cost=19.65..1477.18 rows=49 width=348) (actual time=185.531..337.254 rows=118 loops=1)

  • Join Filter: ((sp_representation_georef.object_id)::integer = (centrality.elec_switching_device.id)::integer)
24. 29.394 42.067 ↓ 2884.0 2884 1
→

Bitmap Heap Scan on sp_representation_georef (cost=17.08..1349.18 rows=1 width=226) (actual time=15.449..42.067 rows=2884 loops=1)

  • Recheck Cond: (geom && '010300002005720000010000000500000074232CFA72E815416F844599A6315C41178046C9FEF215416F844599A6315C41178046C9FEF215416283854F01325C4174232CFA72E815416283854F01325C4174232CFA72E815416F844599A6315C41'::geometry)
  • Filter: (ht_is_valid(ht_data) AND (($17)::integer = (space_id)::integer) AND (geometrytype(geom) = $19))
25. 12.673 12.673 ↓ 7.5 5265 1
→

Bitmap Index Scan on sp_representation_georef_geom_ix (cost=0.00..17.08 rows=698 width=0) (actual time=12.673..12.673 rows=5265 loops=1)

  • Index Cond: (geom && '010300002005720000010000000500000074232CFA72E815416F844599A6315C41178046C9FEF215416F844599A6315C41178046C9FEF215416283854F01325C4174232CFA72E815416283854F01325C4174232CFA72E815416F844599A6315C41'::geometry)
26. 14.420 210.532 ↓ 0.0 0 2884
→

Append (cost=2.57..127.45 rows=44 width=122) (actual time=0.070..0.073 rows=0 loops=2884)

27. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
28. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_switching_device_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
29. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_isolation_device elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
30. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_isolation_device_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
31. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_protection_device elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
32. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_protection_device_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
33. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_control_device elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
34. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_control_device_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
35. 11.536 11.536 ↓ 0.0 0 2884
→

Index Scan using elec_junction_cable_pkey on elec_junction_cable elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.004..0.004 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
36. 14.420 14.420 ↓ 0.0 0 2884
→

Index Scan using elec_bridge_pkey on elec_bridge elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.005..0.005 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
37. 11.536 11.536 ↓ 0.0 0 2884
→

Index Scan using emel_junction_box_pkey on emel_junction_box elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.004..0.004 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
38. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_switch_disconnector elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
39. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_switch_disconnector_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
40. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_disconnector elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
41. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_disconnector_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
42. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_circuit_breaking_device elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
43. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_circuit_breaking_device_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
44. 8.652 8.652 ↓ 0.0 0 2884
→

Index Scan using elec_sectionalizer_pkey on elec_sectionalizer elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
45. 14.420 14.420 ↓ 0.0 0 2884
→

Index Scan using elec_fuse_pkey on elec_fuse elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.005..0.005 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
46. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_discontactor elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
47. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_discontactor_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
48. 11.536 11.536 ↓ 0.0 0 2884
→

Index Scan using elec_switch_pkey on elec_switch elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.004..0.004 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
49. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_fuse_combination_unit elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
50. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_fuse_combination_unit_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
51. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_contactor elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
52. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_contactor_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
53. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_fuse_disconnector_switch elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
54. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_fuse_disconnector_switch_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
55. 2.884 8.652 ↓ 0.0 0 2884
→

Bitmap Heap Scan on elec_fuse_disconnector elec_switching_device (cost=2.57..7.37 rows=3 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Recheck Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
56. 5.768 5.768 ↓ 0.0 0 2884
→

Bitmap Index Scan on elec_fuse_disconnector_pkey (cost=0.00..2.57 rows=3 width=0) (actual time=0.002..0.002 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
57. 11.536 11.536 ↓ 0.0 0 2884
→

Index Scan using elec_circuit_breaker_pkey on elec_circuit_breaker elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.004..0.004 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
58. 8.652 8.652 ↓ 0.0 0 2884
→

Index Scan using elec_autorecloser_pkey on elec_autorecloser elec_switching_device (cost=0.00..4.87 rows=1 width=122) (actual time=0.003..0.003 rows=0 loops=2884)

  • Index Cond: ((centrality.elec_switching_device.id)::integer = (sp_representation_georef.object_id)::integer)
  • Filter: ht_is_valid(centrality.elec_switching_device.ht_data)
59.          

SubPlan (forResult)
60. 2.832 2.832 ↑ 1.0 1 118
→

Index Scan using gnat_symbology_conf_pkey on gnat_symbology_conf (cost=0.00..4.88 rows=1 width=151) (actual time=0.022..0.024 rows=1 loops=118)

  • Index Cond: ((dataview = 'gnat_switching_device'::text) AND (subclass_name = 'gnat_switching_device'::text))