explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EXNs

Settings
# exclusive inclusive rows x rows loops node
1. 516.740 8,387.854 ↓ 24,167.3 314,175 1

Sort (cost=281,542.01..281,542.04 rows=13 width=156) (actual time=8,359.921..8,387.854 rows=314,175 loops=1)

  • Sort Key: zz_pr.country_id, rns2.nndb_id, (COALESCE(sz8.splitted_zone_id, fn8.feature_id)), (COALESCE(sz9.splitted_zone_id, fn9.feature_id)), zz_pr.link_id
  • Sort Method: quicksort Memory: 56469kB
2.          

CTE left_house_data

3. 413.948 1,084.893 ↑ 1.6 358,651 1

HashAggregate (cost=74,213.71..79,837.54 rows=562,383 width=24) (actual time=944.544..1,084.893 rows=358,651 loops=1)

  • Group Key: zz_pr_2.road_link_id, hd.address_range_id, hd.road_name_id, chr.new_address_range_id
4. 123.863 670.945 ↓ 1.7 960,071 1

Hash Left Join (cost=23,251.12..68,589.88 rows=562,383 width=24) (actual time=259.610..670.945 rows=960,071 loops=1)

  • Hash Cond: ((zz_pr_2.road_link_id = chr.road_link_id) AND (hd.unique_id = chr.address_range_id))
5. 263.125 546.184 ↓ 1.7 960,071 1

Hash Right Join (cost=23,154.57..64,275.44 rows=562,383 width=20) (actual time=258.682..546.184 rows=960,071 loops=1)

  • Hash Cond: ((hd.road_link_id = zz_pr_2.road_link_id) AND (hd.address_range_id = zz_pr_2.left_address_range_id))
6. 29.007 29.007 ↑ 1.0 310,972 1

Seq Scan on road_house_data hd (cost=0.00..5,701.72 rows=310,972 width=20) (actual time=0.008..29.007 rows=310,972 loops=1)

7. 115.980 254.052 ↑ 1.0 562,383 1

Hash (cost=14,718.83..14,718.83 rows=562,383 width=8) (actual time=254.052..254.052 rows=562,383 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 30161kB
8. 138.072 138.072 ↑ 1.0 562,383 1

Seq Scan on zz_road_prerequisite_stage_one zz_pr_2 (cost=0.00..14,718.83 rows=562,383 width=8) (actual time=0.019..138.072 rows=562,383 loops=1)

9. 0.554 0.898 ↑ 1.0 3,062 1

Hash (cost=50.62..50.62 rows=3,062 width=20) (actual time=0.898..0.898 rows=3,062 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 200kB
10. 0.344 0.344 ↑ 1.0 3,062 1

Seq Scan on collapsed_house_range chr (cost=0.00..50.62 rows=3,062 width=20) (actual time=0.006..0.344 rows=3,062 loops=1)

11.          

CTE right_house_data

12. 336.053 1,018.646 ↑ 1.6 358,651 1

HashAggregate (cost=74,213.00..79,836.83 rows=562,383 width=24) (actual time=917.556..1,018.646 rows=358,651 loops=1)

  • Group Key: zz_pr_3.road_link_id, hd_1.address_range_id, hd_1.road_name_id, chr_1.new_address_range_id
13. 115.508 682.593 ↓ 1.7 960,071 1

Hash Left Join (cost=23,251.12..68,589.17 rows=562,383 width=24) (actual time=305.112..682.593 rows=960,071 loops=1)

  • Hash Cond: ((zz_pr_3.road_link_id = chr_1.road_link_id) AND (hd_1.unique_id = chr_1.address_range_id))
14. 237.014 566.275 ↓ 1.7 960,071 1

Hash Right Join (cost=23,154.57..64,274.74 rows=562,383 width=20) (actual time=304.262..566.275 rows=960,071 loops=1)

  • Hash Cond: ((hd_1.road_link_id = zz_pr_3.road_link_id) AND (hd_1.address_range_id = zz_pr_3.right_address_range_id))
15. 27.103 27.103 ↑ 1.0 310,972 1

Seq Scan on road_house_data hd_1 (cost=0.00..5,701.72 rows=310,972 width=20) (actual time=0.007..27.103 rows=310,972 loops=1)

16. 114.164 302.158 ↑ 1.0 562,383 1

Hash (cost=14,718.83..14,718.83 rows=562,383 width=8) (actual time=302.158..302.158 rows=562,383 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 30161kB
17. 187.994 187.994 ↑ 1.0 562,383 1

Seq Scan on zz_road_prerequisite_stage_one zz_pr_3 (cost=0.00..14,718.83 rows=562,383 width=8) (actual time=0.010..187.994 rows=562,383 loops=1)

18. 0.447 0.810 ↑ 1.0 3,062 1

Hash (cost=50.62..50.62 rows=3,062 width=20) (actual time=0.810..0.810 rows=3,062 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 200kB
19. 0.363 0.363 ↑ 1.0 3,062 1

Seq Scan on collapsed_house_range chr_1 (cost=0.00..50.62 rows=3,062 width=20) (actual time=0.007..0.363 rows=3,062 loops=1)

20. 21.494 7,871.114 ↓ 24,167.3 314,175 1

Append (cost=121,773.69..121,867.40 rows=13 width=156) (actual time=7,657.797..7,871.114 rows=314,175 loops=1)

21. 511.813 7,849.585 ↓ 26,181.2 314,175 1

HashAggregate (cost=121,773.69..121,774.08 rows=12 width=156) (actual time=7,657.795..7,849.585 rows=314,175 loops=1)

  • Group Key: zz_pr.country_id, rns2.nndb_id, COALESCE(sz8.splitted_zone_id, fn8.feature_id), COALESCE(sz9.splitted_zone_id, fn9.feature_id), CASE WHEN ((fn9.feature_id IS NOT NULL) AND (fn9.feature_id IS NOT NULL) AND ((n8.name)::text = (n9.name)::text) AND (n8.nndb_language_id = n9.nndb_language_id)) THEN 'Y'::text ELSE 'N'::text END, zz_pr.postal_area_id, zz_pr.link_id, CASE WHEN ((zz_pr.side = 'L'::bpchar) AND (zz_pr.address_type = 1)) THEN COALESCE(lhd.new_address_range_id, (zz_pr.left_address_range_id)::bigint) ELSE '1'::bigint END, CASE WHEN ((zz_pr.side = 'R'::bpchar) AND (zz_pr.address_type = 1)) THEN COALESCE(rhd.new_address_range_id, (zz_pr.right_address_range_id)::bigint) ELSE '1'::bigint END, rn.admin_class, zz_pr.is_exit_name, zz_pr.is_junction_name, zz_pr.is_name_on_roadsign, zz_pr.is_postal_name, zz_pr.is_stale_name, zz_pr.is_scenic_name, zz_pr.is_vanity_name, zz_pr.explicatable, CASE WHEN ((erln.source_type <> 'R'::bpchar) OR (erln.source_type IS NULL)) THEN 'Y'::text ELSE 'N'::text END, zz_pr.rdf_link_id
22. 272.937 7,337.772 ↓ 26,446.5 317,358 1

Nested Loop Left Join (cost=106,247.26..121,773.09 rows=12 width=156) (actual time=3,538.175..7,337.772 rows=317,358 loops=1)

23. 45.326 6,747.477 ↓ 26,446.5 317,358 1

Nested Loop Left Join (cost=106,246.96..121,767.82 rows=12 width=145) (actual time=3,538.146..6,747.477 rows=317,358 loops=1)

24. 163.725 6,067.435 ↓ 26,446.5 317,358 1

Nested Loop (cost=106,246.55..121,744.70 rows=12 width=145) (actual time=3,538.132..6,067.435 rows=317,358 loops=1)

25. 109.527 5,586.352 ↓ 26,446.5 317,358 1

Nested Loop (cost=106,246.25..121,739.70 rows=12 width=134) (actual time=3,538.105..5,586.352 rows=317,358 loops=1)

26. 160.169 4,842.109 ↓ 28,850.7 317,358 1

Nested Loop Left Join (cost=106,245.84..121,718.49 rows=11 width=142) (actual time=3,538.070..4,842.109 rows=317,358 loops=1)

27. 158.064 4,681.940 ↓ 28,850.7 317,358 1

Nested Loop Anti Join (cost=106,245.68..121,716.51 rows=11 width=126) (actual time=3,538.065..4,681.940 rows=317,358 loops=1)

28. 198.287 4,523.876 ↓ 21,157.2 317,358 1

Nested Loop Left Join (cost=106,245.53..121,713.76 rows=15 width=126) (actual time=3,538.055..4,523.876 rows=317,358 loops=1)

29. 553.950 4,325.589 ↓ 21,157.2 317,358 1

Hash Right Join (cost=106,245.38..121,711.06 rows=15 width=110) (actual time=3,538.024..4,325.589 rows=317,358 loops=1)

  • Hash Cond: ((lhd.road_link_id = zz_pr.road_link_id) AND (lhd.address_range_id = zz_pr.left_address_range_id))
  • Filter: ((lhd.road_name_id = rns2.nndb_id) OR (lhd.road_name_id IS NULL))
  • Rows Removed by Filter: 309576
30. 1,178.198 1,178.198 ↑ 1.6 358,651 1

CTE Scan on left_house_data lhd (cost=0.00..11,247.66 rows=562,383 width=24) (actual time=944.549..1,178.198 rows=358,651 loops=1)

31. 118.774 2,593.441 ↓ 107.4 317,358 1

Hash (cost=106,201.07..106,201.07 rows=2,954 width=106) (actual time=2,593.441..2,593.441 rows=317,358 loops=1)

  • Buckets: 524288 (originally 4096) Batches: 1 (originally 1) Memory Usage: 44410kB
32. 243.414 2,474.667 ↓ 107.4 317,358 1

Hash Join (cost=25,757.64..106,201.07 rows=2,954 width=106) (actual time=1,534.793..2,474.667 rows=317,358 loops=1)

  • Hash Cond: (COALESCE(erln.fake_name_id, (zz_pr.road_name_id)::bigint) = rns.source_id)
  • Join Filter: ((rhd.road_name_id = rns2.nndb_id) OR (rhd.road_name_id IS NULL))
  • Rows Removed by Join Filter: 309576
33. 105.863 2,174.754 ↓ 1.3 717,171 1

Hash Left Join (cost=23,160.75..93,482.00 rows=562,383 width=116) (actual time=1,478.240..2,174.754 rows=717,171 loops=1)

  • Hash Cond: ((zz_pr.rdf_link_id = erln.link_id) AND (zz_pr.road_name_id = erln.original_name_id))
34. 397.323 2,068.875 ↓ 1.3 717,171 1

Hash Right Join (cost=23,154.57..89,257.95 rows=562,383 width=100) (actual time=1,478.194..2,068.875 rows=717,171 loops=1)

  • Hash Cond: ((rhd.road_link_id = zz_pr.road_link_id) AND (rhd.address_range_id = zz_pr.right_address_range_id))
35. 1,113.257 1,113.257 ↑ 1.6 358,651 1

CTE Scan on right_house_data rhd (cost=0.00..11,247.66 rows=562,383 width=24) (actual time=917.564..1,113.257 rows=358,651 loops=1)

36. 285.434 558.295 ↑ 1.0 562,383 1

Hash (cost=14,718.83..14,718.83 rows=562,383 width=88) (actual time=558.295..558.295 rows=562,383 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 73611kB
37. 272.861 272.861 ↑ 1.0 562,383 1

Seq Scan on zz_road_prerequisite_stage_one zz_pr (cost=0.00..14,718.83 rows=562,383 width=88) (actual time=0.014..272.861 rows=562,383 loops=1)

38. 0.001 0.016 ↓ 0.0 0 1

Hash (cost=6.16..6.16 rows=1 width=32) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
39. 0.015 0.015 ↓ 0.0 0 1

Index Scan using nx_extraroadlinknames_type on extra_road_link_names erln (cost=0.14..6.16 rows=1 width=32) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (type = 'R'::bpchar)
40. 7.529 56.499 ↓ 1.9 19,447 1

Hash (cost=2,469.50..2,469.50 rows=10,191 width=14) (actual time=56.499..56.499 rows=19,447 loops=1)

  • Buckets: 32768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1130kB
41. 17.830 48.970 ↓ 1.9 19,447 1

Hash Join (cost=1,459.22..2,469.50 rows=10,191 width=14) (actual time=27.814..48.970 rows=19,447 loops=1)

  • Hash Cond: ((rns.similar_to = rns2.source_id) AND (rns.transliteration = rns2.transliteration))
42. 3.399 3.399 ↑ 1.0 19,447 1

Seq Scan on road_name_source rns (cost=0.00..762.50 rows=19,450 width=18) (actual time=0.020..3.399 rows=19,447 loops=1)

43. 4.403 27.741 ↑ 1.0 10,269 1

Hash (cost=1,305.18..1,305.18 rows=10,269 width=16) (actual time=27.741..27.741 rows=10,269 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 650kB
44. 12.292 23.338 ↑ 1.0 10,269 1

Hash Join (cost=367.05..1,305.18 rows=10,269 width=16) (actual time=6.665..23.338 rows=10,269 loops=1)

  • Hash Cond: (rns2.nndb_id = rn.road_name_id)
45. 4.437 4.437 ↑ 1.0 19,447 1

Seq Scan on road_name_source rns2 (cost=0.00..762.50 rows=19,450 width=14) (actual time=0.003..4.437 rows=19,447 loops=1)

46. 2.753 6.609 ↑ 1.0 10,269 1

Hash (cost=238.69..238.69 rows=10,269 width=6) (actual time=6.609..6.609 rows=10,269 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 530kB
47. 3.856 3.856 ↑ 1.0 10,269 1

Seq Scan on road_name rn (cost=0.00..238.69 rows=10,269 width=6) (actual time=0.011..3.856 rows=10,269 loops=1)

48. 0.000 0.000 ↓ 0.0 0 317,358

Index Scan using pk_splitted_zone on splitted_zone sz8 (cost=0.15..0.17 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=317,358)

  • Index Cond: (splitted_zone_id = COALESCE(zz_pr.ch_city_id, zz_pr.city_id))
49. 0.000 0.000 ↓ 0.0 0 317,358

Index Only Scan using nx_splittedpostalarea_postalareaid on splitted_postal_area spa (cost=0.15..0.29 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=317,358)

  • Index Cond: (postal_area_id = zz_pr.postal_area_id)
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0 317,358

Index Scan using pk_splitted_zone on splitted_zone sz9 (cost=0.15..0.17 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=317,358)

  • Index Cond: (splitted_zone_id = zz_pr.city_district_id)
51. 634.716 634.716 ↑ 1.0 1 317,358

Index Only Scan using pk_feature_name on feature_name fn8 (cost=0.42..1.92 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=317,358)

  • Index Cond: ((feature_id = COALESCE(sz8.zone_id, zz_pr.ch_city_id, zz_pr.city_id)) AND (name_type = 'D'::bpchar))
  • Heap Fetches: 0
52. 317.358 317.358 ↑ 1.0 1 317,358

Index Scan using pk_names on names n8 (cost=0.29..0.41 rows=1 width=27) (actual time=0.001..0.001 rows=1 loops=317,358)

  • Index Cond: (name_id = fn8.name_id)
53. 634.716 634.716 ↑ 1.0 1 317,358

Index Only Scan using pk_feature_name on feature_name fn9 (cost=0.42..1.92 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=317,358)

  • Index Cond: ((feature_id = COALESCE(sz9.zone_id, zz_pr.city_district_id)) AND (name_type = 'D'::bpchar))
  • Heap Fetches: 0
54. 317.358 317.358 ↑ 1.0 1 317,358

Index Scan using pk_names on names n9 (cost=0.29..0.41 rows=1 width=27) (actual time=0.001..0.001 rows=1 loops=317,358)

  • Index Cond: (name_id = fn9.name_id)
55. 0.001 0.035 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=93.15..93.20 rows=1 width=152) (actual time=0.035..0.035 rows=0 loops=1)

56. 0.002 0.034 ↓ 0.0 0 1

HashAggregate (cost=93.15..93.19 rows=1 width=152) (actual time=0.034..0.034 rows=0 loops=1)

  • Group Key: zz_pr_1.country_id, rns2_1.nndb_id, COALESCE(sz8_1.splitted_zone_id, fn8_1.feature_id), COALESCE(sz9_1.splitted_zone_id, fn9_1.feature_id), CASE WHEN ((fn9_1.feature_id IS NOT NULL) AND (fn9_1.feature_id IS NOT NULL) AND ((n8_1.name)::text = (n9_1.name)::text) AND (n8_1.nndb_language_id = n9_1.nndb_language_id)) THEN 'Y'::text ELSE 'N'::text END, zz_pr_1.postal_area_id, zz_pr_1.link_id, CASE WHEN ((zz_pr_1.side = 'L'::bpchar) AND (zz_pr_1.address_type = 1)) THEN COALESCE(lchr.new_address_range_id, (zz_pr_1.left_address_range_id)::bigint) ELSE '1'::bigint END, CASE WHEN ((zz_pr_1.side = 'R'::bpchar) AND (zz_pr_1.address_type = 1)) THEN COALESCE(rchr.new_address_range_id, (zz_pr_1.right_address_range_id)::bigint) ELSE '1'::bigint END, rn_1.admin_class, zz_pr_1.is_exit_name, zz_pr_1.is_junction_name, 'N'::text, zz_pr_1.is_postal_name, zz_pr_1.is_stale_name, zz_pr_1.is_scenic_name, zz_pr_1.is_vanity_name, 'N'::text, CASE WHEN (erln_1.source_type <> 'R'::bpchar) THEN 'Y'::text ELSE 'N'::text END, zz_pr_1.rdf_link_id
57. 0.000 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=67.86..93.10 rows=1 width=152) (actual time=0.032..0.032 rows=0 loops=1)

58. 0.001 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=67.56..92.66 rows=1 width=141) (actual time=0.032..0.032 rows=0 loops=1)

59. 0.000 0.031 ↓ 0.0 0 1

Nested Loop Left Join (cost=67.15..90.74 rows=1 width=141) (actual time=0.031..0.031 rows=0 loops=1)

60. 0.001 0.031 ↓ 0.0 0 1

Nested Loop (cost=66.99..90.56 rows=1 width=125) (actual time=0.031..0.031 rows=0 loops=1)

61. 0.000 0.030 ↓ 0.0 0 1

Nested Loop (cost=66.70..90.14 rows=1 width=114) (actual time=0.030..0.030 rows=0 loops=1)

62. 0.000 0.030 ↓ 0.0 0 1

Nested Loop Left Join (cost=66.28..88.21 rows=1 width=122) (actual time=0.030..0.030 rows=0 loops=1)

63. 0.000 0.030 ↓ 0.0 0 1

Nested Loop Left Join (cost=66.13..88.03 rows=1 width=106) (actual time=0.030..0.030 rows=0 loops=1)

64. 0.002 0.030 ↓ 0.0 0 1

Nested Loop Left Join (cost=65.85..87.72 rows=1 width=102) (actual time=0.030..0.030 rows=0 loops=1)

65. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=65.57..87.41 rows=1 width=94) (actual time=0.028..0.028 rows=0 loops=1)

66. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=4.02..16.80 rows=1 width=30) (actual time=0.028..0.028 rows=0 loops=1)

67. 0.001 0.028 ↓ 0.0 0 1

Nested Loop (cost=3.73..16.13 rows=2 width=28) (actual time=0.028..0.028 rows=0 loops=1)

68. 0.000 0.027 ↓ 0.0 0 1

Nested Loop (cost=3.45..15.27 rows=2 width=34) (actual time=0.027..0.027 rows=0 loops=1)

69. 0.027 0.027 ↓ 0.0 0 1

Index Scan using nx_extraroadlinknames_type on extra_road_link_names erln_1 (cost=0.14..6.16 rows=1 width=32) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: (type = 'A'::bpchar)
70. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on road_name_source rns_1 (cost=3.30..9.09 rows=2 width=18) (never executed)

  • Recheck Cond: (source_id = erln_1.fake_name_id)
71. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on nx_roadnamesource_sourceid_transliteration (cost=0.00..3.30 rows=2 width=0) (never executed)

  • Index Cond: (source_id = erln_1.fake_name_id)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using nx_roadnamesource_sourceid_transliteration on road_name_source rns2_1 (cost=0.29..0.42 rows=1 width=14) (never executed)

  • Index Cond: ((source_id = rns_1.similar_to) AND (transliteration = rns_1.transliteration))
73. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_road_name on road_name rn_1 (cost=0.29..0.33 rows=1 width=6) (never executed)

  • Index Cond: (road_name_id = rns2_1.nndb_id)
74. 0.000 0.000 ↓ 0.0 0

Index Scan using nx_zzroadprerequisitestageone_rdflinkid on zz_road_prerequisite_stage_one zz_pr_1 (cost=61.55..70.60 rows=1 width=84) (never executed)

  • Index Cond: (rdf_link_id = erln_1.link_id)
  • Filter: ((NOT (hashed SubPlan 3)) AND ((road_name_id = erln_1.original_name_id) OR ((road_name_id IS NULL) AND (erln_1.original_name_id IS NULL))))
75.          

SubPlan (forIndex Scan)

76. 0.000 0.000 ↓ 0.0 0

Unique (cost=0.15..60.63 rows=200 width=8) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Index Only Scan using nx_splittedpostalarea_postalareaid on splitted_postal_area (cost=0.15..56.70 rows=1,570 width=8) (never executed)

  • Heap Fetches: 0
78. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_collapsed_house_range on collapsed_house_range lchr (cost=0.28..0.30 rows=1 width=20) (never executed)

  • Index Cond: ((road_link_id = zz_pr_1.road_link_id) AND (address_range_id = zz_pr_1.left_address_range_id))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_collapsed_house_range on collapsed_house_range rchr (cost=0.28..0.30 rows=1 width=20) (never executed)

  • Index Cond: ((road_link_id = zz_pr_1.road_link_id) AND (address_range_id = zz_pr_1.right_address_range_id))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_splitted_zone on splitted_zone sz8_1 (cost=0.15..0.17 rows=1 width=16) (never executed)

  • Index Cond: (splitted_zone_id = COALESCE(zz_pr_1.ch_city_id, zz_pr_1.city_id))
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_feature_name on feature_name fn8_1 (cost=0.42..1.92 rows=1 width=16) (never executed)

  • Index Cond: ((feature_id = COALESCE(sz8_1.zone_id, zz_pr_1.ch_city_id, zz_pr_1.city_id)) AND (name_type = 'D'::bpchar))
  • Heap Fetches: 0
82. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_names on names n8_1 (cost=0.29..0.41 rows=1 width=27) (never executed)

  • Index Cond: (name_id = fn8_1.name_id)
83. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_splitted_zone on splitted_zone sz9_1 (cost=0.15..0.17 rows=1 width=16) (never executed)

  • Index Cond: (splitted_zone_id = zz_pr_1.city_district_id)
84. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_feature_name on feature_name fn9_1 (cost=0.42..1.92 rows=1 width=16) (never executed)

  • Index Cond: ((feature_id = COALESCE(sz9_1.zone_id, zz_pr_1.city_district_id)) AND (name_type = 'D'::bpchar))
  • Heap Fetches: 0
85. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_names on names n9_1 (cost=0.29..0.41 rows=1 width=27) (never executed)

  • Index Cond: (name_id = fn9_1.name_id)
Planning time : 43.956 ms
Execution time : 8,447.945 ms