explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iK21

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 664.961 ↓ 31.0 31 1

Subquery Scan on feature_obj_item (cost=2,767.28..2,767.97 rows=1 width=624) (actual time=664.567..664.961 rows=31 loops=1)

2. 0.486 664.952 ↓ 31.0 31 1

Result (cost=2,767.28..2,767.96 rows=1 width=613) (actual time=664.566..664.952 rows=31 loops=1)

3. 0.018 664.466 ↓ 31.0 31 1

Unique (cost=2,767.28..2,767.29 rows=1 width=720) (actual time=664.446..664.466 rows=31 loops=1)

4. 0.112 664.448 ↓ 37.0 37 1

Sort (cost=2,767.28..2,767.28 rows=1 width=720) (actual time=664.445..664.448 rows=37 loops=1)

  • Sort Key: contxt_coia.obj_item_id, selector.idx
  • Sort Method: quicksort Memory: 34kB
5. 0.216 664.336 ↓ 37.0 37 1

Nested Loop (cost=1,814.12..2,767.27 rows=1 width=720) (actual time=659.763..664.336 rows=37 loops=1)

  • Join Filter: ((symbol_map_2525c.geometry IS NULL) OR (geog.cat_code = ANY (symbol_map_2525c.geometry)))
6. 0.042 662.446 ↓ 31.0 31 1

Nested Loop Left Join (cost=1,813.29..1,920.80 rows=1 width=1,710) (actual time=659.534..662.446 rows=31 loops=1)

  • Join Filter: (contxt_oistat.obj_item_stat_ix = obj_item_stat.obj_item_stat_ix)
  • Rows Removed by Join Filter: 3
7. 0.045 662.280 ↓ 31.0 31 1

Nested Loop Left Join (cost=1,812.60..1,917.75 rows=1 width=1,624) (actual time=659.498..662.280 rows=31 loops=1)

8. 0.042 662.173 ↓ 31.0 31 1

Nested Loop Left Join (cost=1,812.33..1,916.54 rows=1 width=1,608) (actual time=659.479..662.173 rows=31 loops=1)

9. 0.404 662.069 ↓ 31.0 31 1

Hash Join (cost=1,812.05..1,915.24 rows=1 width=1,587) (actual time=659.464..662.069 rows=31 loops=1)

  • Hash Cond: (obj_item.obj_item_id = contxt_coia.obj_item_id)
10. 0.606 2.515 ↑ 1.0 3,151 1

Hash Left Join (cost=55.59..146.94 rows=3,151 width=69) (actual time=0.235..2.515 rows=3,151 loops=1)

  • Hash Cond: (obj_item.obj_item_id = wind.wind_id)
11. 0.713 1.906 ↑ 1.0 3,151 1

Hash Left Join (cost=38.61..121.69 rows=3,151 width=55) (actual time=0.221..1.906 rows=3,151 loops=1)

  • Hash Cond: (obj_item.obj_item_id = unit.unit_id)
12. 0.667 1.012 ↑ 1.0 3,151 1

Hash Left Join (cost=19.68..94.47 rows=3,151 width=49) (actual time=0.028..1.012 rows=3,151 loops=1)

  • Hash Cond: (obj_item.obj_item_id = route.route_id)
13. 0.342 0.342 ↑ 1.0 3,151 1

Seq Scan on obj_item (cost=0.00..66.51 rows=3,151 width=21) (actual time=0.011..0.342 rows=3,151 loops=1)

14. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
15. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on route (cost=0.00..14.30 rows=430 width=48) (actual time=0.002..0.003 rows=0 loops=1)

16. 0.103 0.181 ↑ 1.0 575 1

Hash (cost=11.75..11.75 rows=575 width=19) (actual time=0.181..0.181 rows=575 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
17. 0.078 0.078 ↑ 1.0 575 1

Seq Scan on unit (cost=0.00..11.75 rows=575 width=19) (actual time=0.006..0.078 rows=575 loops=1)

18. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=13.10..13.10 rows=310 width=34) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
19. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on wind (cost=0.00..13.10 rows=310 width=34) (actual time=0.002..0.002 rows=0 loops=1)

20. 0.098 659.150 ↓ 31.0 31 1

Hash (cost=1,756.45..1,756.45 rows=1 width=1,570) (actual time=659.150..659.150 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
21. 8.359 659.052 ↓ 31.0 31 1

Nested Loop (cost=803.69..1,756.45 rows=1 width=1,570) (actual time=3.416..659.052 rows=31 loops=1)

  • Join Filter: (contxt_oitype.obj_type_id = obj_type.obj_type_id)
  • Rows Removed by Join Filter: 42749
22. 0.044 20.029 ↓ 31.0 31 1

Nested Loop (cost=138.29..902.30 rows=1 width=309) (actual time=0.801..20.029 rows=31 loops=1)

  • Join Filter: (contxt_coia.obj_item_id = contxt_oitype.obj_item_id)
23. 0.038 19.892 ↓ 31.0 31 1

Nested Loop (cost=138.01..896.04 rows=1 width=275) (actual time=0.791..19.892 rows=31 loops=1)

  • Join Filter: (contxt_coia.obj_item_id = contxt_oihsts.obj_item_id)
24. 0.046 19.730 ↓ 31.0 31 1

Nested Loop Left Join (cost=137.73..889.79 rows=1 width=251) (actual time=0.778..19.730 rows=31 loops=1)

25. 0.065 19.591 ↓ 31.0 31 1

Nested Loop (cost=137.44..882.00 rows=1 width=212) (actual time=0.768..19.591 rows=31 loops=1)

26. 2.690 19.371 ↓ 31.0 31 1

Hash Join (cost=137.15..874.21 rows=1 width=202) (actual time=0.756..19.371 rows=31 loops=1)

  • Hash Cond: (loc.loc_id = contxt_oiloca.loc_id)
27. 4.740 16.602 ↑ 1.0 23,677 1

Hash Left Join (cost=45.20..693.46 rows=23,677 width=122) (actual time=0.108..16.602 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = orbit_area.orbit_area_id)
28. 4.606 11.860 ↑ 1.0 23,677 1

Hash Left Join (cost=25.52..611.62 rows=23,677 width=78) (actual time=0.095..11.860 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = fan_area.fan_area_id)
29. 4.878 7.251 ↑ 1.0 23,677 1

Hash Left Join (cost=5.62..529.56 rows=23,677 width=18) (actual time=0.080..7.251 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = corridor_area.corridor_area_id)
30. 2.309 2.309 ↑ 1.0 23,677 1

Seq Scan on loc (cost=0.00..461.77 rows=23,677 width=13) (actual time=0.005..2.309 rows=23,677 loops=1)

31. 0.040 0.064 ↑ 1.0 161 1

Hash (cost=3.61..3.61 rows=161 width=18) (actual time=0.064..0.064 rows=161 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
32. 0.024 0.024 ↑ 1.0 161 1

Seq Scan on corridor_area (cost=0.00..3.61 rows=161 width=18) (actual time=0.005..0.024 rows=161 loops=1)

33. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=14.40..14.40 rows=440 width=80) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
34. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on fan_area (cost=0.00..14.40 rows=440 width=80) (actual time=0.003..0.003 rows=0 loops=1)

35. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=64) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
36. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on orbit_area (cost=0.00..14.30 rows=430 width=64) (actual time=0.002..0.002 rows=0 loops=1)

37. 0.013 0.079 ↓ 31.0 31 1

Hash (cost=91.94..91.94 rows=1 width=93) (actual time=0.079..0.079 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
38. 0.023 0.066 ↓ 31.0 31 1

Hash Join (cost=47.48..91.94 rows=1 width=93) (actual time=0.052..0.066 rows=31 loops=1)

  • Hash Cond: (contxt_oiloca.obj_item_id = contxt_coia.obj_item_id)
39. 0.006 0.015 ↑ 1.0 31 1

Bitmap Heap Scan on contxt_oiloca (cost=4.52..48.90 rows=31 width=72) (actual time=0.013..0.015 rows=31 loops=1)

  • Recheck Cond: (contxt_id = '10321812000000601400'::numeric)
  • Heap Blocks: exact=1
40. 0.009 0.009 ↑ 1.0 31 1

Bitmap Index Scan on contxt_oiloca_contxt_id_obj_item_id_idx (cost=0.00..4.51 rows=31 width=0) (actual time=0.009..0.009 rows=31 loops=1)

  • Index Cond: (contxt_id = '10321812000000601400'::numeric)
41. 0.015 0.028 ↑ 1.0 33 1

Hash (cost=42.55..42.55 rows=33 width=34) (actual time=0.028..0.028 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
42. 0.007 0.013 ↑ 1.0 33 1

Bitmap Heap Scan on contxt_coia (cost=4.54..42.55 rows=33 width=34) (actual time=0.009..0.013 rows=33 loops=1)

  • Recheck Cond: (contxt_id = '10321812000000601400'::numeric)
  • Heap Blocks: exact=1
43. 0.006 0.006 ↑ 1.0 33 1

Bitmap Index Scan on contxt_coia_contxt_id_obj_item_id_idx (cost=0.00..4.53 rows=33 width=0) (actual time=0.006..0.006 rows=33 loops=1)

  • Index Cond: (contxt_id = '10321812000000601400'::numeric)
44. 0.155 0.155 ↑ 1.0 1 31

Index Scan using rptd_pkey on rptd (cost=0.29..7.79 rows=1 width=35) (actual time=0.005..0.005 rows=1 loops=31)

  • Index Cond: (rptd_id = contxt_oiloca.rptd_id)
45. 0.093 0.093 ↑ 1.0 1 31

Index Scan using geog__loc_id on geog (cost=0.29..7.79 rows=1 width=65) (actual time=0.003..0.003 rows=1 loops=31)

  • Index Cond: (contxt_oiloca.loc_id = loc_id)
46. 0.124 0.124 ↑ 1.0 1 31

Index Scan using contxt_oihsts_contxt_id_obj_item_id_idx on contxt_oihsts (cost=0.28..6.24 rows=1 width=37) (actual time=0.004..0.004 rows=1 loops=31)

  • Index Cond: ((contxt_id = '10321812000000601400'::numeric) AND (obj_item_id = contxt_oiloca.obj_item_id))
47. 0.093 0.093 ↑ 1.0 1 31

Index Scan using contxt_oitype_contxt_id_obj_item_id_idx on contxt_oitype (cost=0.28..6.24 rows=1 width=47) (actual time=0.003..0.003 rows=1 loops=31)

  • Index Cond: ((contxt_id = '10321812000000601400'::numeric) AND (obj_item_id = contxt_oihsts.obj_item_id))
48. 22.380 630.664 ↑ 1.0 1,380 31

Hash Left Join (cost=665.40..836.91 rows=1,380 width=1,274) (actual time=0.081..20.344 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = weapon_type.weapon_type_id)
49. 19.310 608.127 ↑ 1.0 1,380 31

Hash Left Join (cost=649.90..817.78 rows=1,380 width=1,251) (actual time=0.076..19.617 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = vessel_type.vessel_type_id)
50. 19.620 588.814 ↑ 1.0 1,380 31

Hash Left Join (cost=633.83..798.07 rows=1,380 width=1,203) (actual time=0.075..18.994 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = vehicle_type.vehicle_type_id)
51. 20.050 569.098 ↑ 1.0 1,380 31

Hash Left Join (cost=624.62..785.23 rows=1,380 width=1,184) (actual time=0.071..18.358 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = unit_type.unit_type_id)
52. 18.071 548.979 ↑ 1.0 1,380 31

Hash Left Join (cost=619.69..776.67 rows=1,380 width=1,132) (actual time=0.068..17.709 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = task_frmtn_type.task_frmtn_type_id)
53. 17.202 530.906 ↑ 1.0 1,380 31

Hash Left Join (cost=595.74..749.08 rows=1,380 width=1,112) (actual time=0.067..17.126 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = surf_vessel_type.surf_vessel_type_id)
54. 17.265 513.701 ↑ 1.0 1,380 31

Hash Left Join (cost=574.27..723.97 rows=1,380 width=1,064) (actual time=0.067..16.571 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = subsurf_vessel_type.subsurf_vessel_type_id)
55. 16.861 496.434 ↑ 1.0 1,380 31

Hash Left Join (cost=554.37..700.44 rows=1,380 width=1,016) (actual time=0.066..16.014 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = route_type.route_type_id)
56. 18.132 479.570 ↑ 1.0 1,380 31

Hash Left Join (cost=530.42..672.86 rows=1,380 width=968) (actual time=0.065..15.470 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = railcar_type.railcar_type_id)
57. 16.893 461.435 ↑ 1.0 1,380 31

Hash Left Join (cost=510.07..648.87 rows=1,380 width=892) (actual time=0.064..14.885 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = radact_mat_type.radact_mat_type_id)
58. 17.420 444.540 ↑ 1.0 1,380 31

Hash Left Join (cost=488.59..623.77 rows=1,380 width=872) (actual time=0.064..14.340 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = prv_sctr_org_type.prv_sctr_org_type_id)
59. 17.016 427.118 ↑ 1.0 1,380 31

Hash Left Join (cost=467.12..598.66 rows=1,380 width=852) (actual time=0.063..13.778 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = pers_type.pers_type_id)
60. 16.319 410.099 ↑ 1.0 1,380 31

Hash Left Join (cost=447.44..575.35 rows=1,380 width=832) (actual time=0.062..13.229 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = org_type.org_type_id)
61. 16.707 393.731 ↑ 1.0 1,380 31

Hash Left Join (cost=442.49..566.77 rows=1,380 width=816) (actual time=0.060..12.701 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = mrt_eqpt_type.mrt_eqpt_type_id)
62. 16.312 377.022 ↑ 1.0 1,380 31

Hash Left Join (cost=421.02..541.66 rows=1,380 width=740) (actual time=0.059..12.162 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = misc_eqpt_type.misc_eqpt_type_id)
63. 14.780 360.685 ↑ 1.0 1,380 31

Hash Left Join (cost=418.78..535.79 rows=1,380 width=695) (actual time=0.058..11.635 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = mil_post_type.mil_post_type_id)
64. 17.284 345.898 ↑ 1.0 1,380 31

Hash Left Join (cost=417.76..531.13 rows=1,380 width=682) (actual time=0.057..11.158 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = mil_org_type.mil_org_type_id)
65. 16.022 328.569 ↑ 1.0 1,380 31

Hash Left Join (cost=412.81..522.55 rows=1,380 width=669) (actual time=0.055..10.599 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = mil_obs_type.mil_obs_type_id)
66. 20.871 312.542 ↑ 1.0 1,380 31

Hash Left Join (cost=391.33..497.44 rows=1,380 width=593) (actual time=0.054..10.082 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = mat_type.mat_type_id)
67. 16.117 291.307 ↑ 1.0 1,380 31

Hash Left Join (cost=353.69..456.16 rows=1,380 width=580) (actual time=0.041..9.397 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = hrbr_type.hrbr_type_id)
68. 14.568 275.187 ↑ 1.0 1,380 31

Hash Left Join (cost=329.74..428.57 rows=1,380 width=532) (actual time=0.040..8.877 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = group_org_type.group_org_type_id)
69. 15.797 260.617 ↑ 1.0 1,380 31

Hash Left Join (cost=305.79..400.99 rows=1,380 width=512) (actual time=0.039..8.407 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = govt_org_type.govt_org_type_id)
70. 14.846 244.776 ↑ 1.0 1,380 31

Hash Left Join (cost=300.84..392.41 rows=1,380 width=499) (actual time=0.037..7.896 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = geo_feat_type.geo_feat_type_id)
71. 15.027 229.927 ↑ 1.0 1,380 31

Hash Left Join (cost=279.36..367.30 rows=1,380 width=479) (actual time=0.036..7.417 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = feat_type.feat_type_id)
72. 15.064 214.861 ↑ 1.0 1,380 31

Hash Left Join (cost=274.91..359.21 rows=1,380 width=466) (actual time=0.034..6.931 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = fac_type.fac_type_id)
73. 14.071 199.795 ↑ 1.0 1,380 31

Hash Left Join (cost=250.96..331.63 rows=1,380 width=418) (actual time=0.033..6.445 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = exctv_mil_org_type.exctv_mil_org_type_id)
74. 19.461 185.721 ↑ 1.0 1,380 31

Hash Left Join (cost=227.01..304.05 rows=1,380 width=370) (actual time=0.032..5.991 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = eqpt_type.eqpt_type_id)
75. 14.831 165.912 ↑ 1.0 1,380 31

Hash Left Join (cost=187.36..260.76 rows=1,380 width=357) (actual time=0.020..5.352 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = eng_eqpt_type.eng_eqpt_type_id)
76. 14.801 151.032 ↑ 1.0 1,380 31

Hash Left Join (cost=182.39..252.16 rows=1,380 width=338) (actual time=0.018..4.872 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = elctrnc_eqpt_type.elctrnc_eqpt_type_id)
77. 14.332 136.214 ↑ 1.0 1,380 31

Hash Left Join (cost=180.85..246.99 rows=1,380 width=313) (actual time=0.017..4.394 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = ctrl_feat_type.ctrl_feat_type_id)
78. 12.863 121.830 ↑ 1.0 1,380 31

Hash Left Join (cost=176.40..238.90 rows=1,380 width=292) (actual time=0.014..3.930 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = cons_mat_type.cons_mat_type_id)
79. 12.364 108.965 ↑ 1.0 1,380 31

Hash Left Join (cost=161.00..219.87 rows=1,380 width=272) (actual time=0.013..3.515 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = civ_post_type.civ_post_type_id)
80. 13.080 96.596 ↑ 1.0 1,380 31

Hash Left Join (cost=137.05..192.28 rows=1,380 width=252) (actual time=0.013..3.116 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = chm_mat_type.chm_mat_type_id)
81. 13.359 83.514 ↑ 1.0 1,380 31

Hash Left Join (cost=117.37..168.97 rows=1,380 width=232) (actual time=0.012..2.694 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = cbrn_eqpt_type.cbrn_eqpt_type_id)
82. 13.514 70.153 ↑ 1.0 1,380 31

Hash Left Join (cost=93.42..141.39 rows=1,380 width=212) (actual time=0.011..2.263 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = bridge_type.bridge_type_id)
83. 11.871 56.637 ↑ 1.0 1,380 31

Hash Left Join (cost=69.47..113.81 rows=1,380 width=164) (actual time=0.010..1.827 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = bio_mat_type.bio_mat_type_id)
84. 12.397 44.764 ↑ 1.0 1,380 31

Hash Left Join (cost=49.80..90.50 rows=1,380 width=144) (actual time=0.010..1.444 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = ammo_type.ammo_type_id)
85. 12.487 32.364 ↑ 1.0 1,380 31

Hash Left Join (cost=32.15..69.21 rows=1,380 width=124) (actual time=0.009..1.044 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = airfield_type.airfield_type_id)
86. 14.388 19.871 ↑ 1.0 1,380 31

Hash Left Join (cost=8.20..41.63 rows=1,380 width=76) (actual time=0.007..0.641 rows=1,380 loops=31)

  • Hash Cond: (obj_type.obj_type_id = acft_type.acft_type_id)
87. 5.363 5.363 ↑ 1.0 1,380 31

Seq Scan on obj_type (cost=0.00..29.80 rows=1,380 width=24) (actual time=0.002..0.173 rows=1,380 loops=31)

88. 0.072 0.120 ↑ 1.0 231 1

Hash (cost=5.31..5.31 rows=231 width=52) (actual time=0.120..0.120 rows=231 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
89. 0.048 0.048 ↑ 1.0 231 1

Seq Scan on acft_type (cost=0.00..5.31 rows=231 width=52) (actual time=0.006..0.048 rows=231 loops=1)

90. 0.001 0.006 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=48) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
91. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on airfield_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.005..0.005 rows=0 loops=1)

92. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=13.40..13.40 rows=340 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
93. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on ammo_type (cost=0.00..13.40 rows=340 width=20) (actual time=0.002..0.002 rows=0 loops=1)

94. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
95. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on bio_mat_type (cost=0.00..14.30 rows=430 width=20) (actual time=0.002..0.002 rows=0 loops=1)

96. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
97. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on bridge_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.002..0.002 rows=0 loops=1)

98. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
99. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on cbrn_eqpt_type (cost=0.00..16.20 rows=620 width=20) (actual time=0.002..0.002 rows=0 loops=1)

100. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
101. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on chm_mat_type (cost=0.00..14.30 rows=430 width=20) (actual time=0.002..0.002 rows=0 loops=1)

102. 0.001 0.005 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
103. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on civ_post_type (cost=0.00..16.20 rows=620 width=20) (actual time=0.004..0.004 rows=0 loops=1)

104. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=12.40..12.40 rows=240 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
105. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on cons_mat_type (cost=0.00..12.40 rows=240 width=20) (actual time=0.002..0.002 rows=0 loops=1)

106. 0.030 0.052 ↑ 1.0 109 1

Hash (cost=3.09..3.09 rows=109 width=21) (actual time=0.052..0.052 rows=109 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
107. 0.022 0.022 ↑ 1.0 109 1

Seq Scan on ctrl_feat_type (cost=0.00..3.09 rows=109 width=21) (actual time=0.007..0.022 rows=109 loops=1)

108. 0.009 0.017 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=25) (actual time=0.017..0.017 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
109. 0.008 0.008 ↑ 1.0 24 1

Seq Scan on elctrnc_eqpt_type (cost=0.00..1.24 rows=24 width=25) (actual time=0.005..0.008 rows=24 loops=1)

110. 0.028 0.049 ↑ 1.0 132 1

Hash (cost=3.32..3.32 rows=132 width=19) (actual time=0.049..0.049 rows=132 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
111. 0.021 0.021 ↑ 1.0 132 1

Seq Scan on eng_eqpt_type (cost=0.00..3.32 rows=132 width=19) (actual time=0.006..0.021 rows=132 loops=1)

112. 0.203 0.348 ↑ 1.0 1,140 1

Hash (cost=25.40..25.40 rows=1,140 width=13) (actual time=0.348..0.348 rows=1,140 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 67kB
113. 0.145 0.145 ↑ 1.0 1,140 1

Seq Scan on eqpt_type (cost=0.00..25.40 rows=1,140 width=13) (actual time=0.005..0.145 rows=1,140 loops=1)

114. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
115. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on exctv_mil_org_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.002..0.002 rows=0 loops=1)

116. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
117. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on fac_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.002..0.002 rows=0 loops=1)

118. 0.022 0.039 ↑ 1.0 109 1

Hash (cost=3.09..3.09 rows=109 width=13) (actual time=0.039..0.039 rows=109 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
119. 0.017 0.017 ↑ 1.0 109 1

Seq Scan on feat_type (cost=0.00..3.09 rows=109 width=13) (actual time=0.005..0.017 rows=109 loops=1)

120. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=15.10..15.10 rows=510 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
121. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on geo_feat_type (cost=0.00..15.10 rows=510 width=20) (actual time=0.002..0.002 rows=0 loops=1)

122. 0.025 0.044 ↑ 1.0 131 1

Hash (cost=3.31..3.31 rows=131 width=13) (actual time=0.044..0.044 rows=131 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
123. 0.019 0.019 ↑ 1.0 131 1

Seq Scan on govt_org_type (cost=0.00..3.31 rows=131 width=13) (actual time=0.005..0.019 rows=131 loops=1)

124. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
125. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on group_org_type (cost=0.00..16.20 rows=620 width=20) (actual time=0.002..0.002 rows=0 loops=1)

126. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
127. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on hrbr_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.002..0.003 rows=0 loops=1)

128. 0.210 0.364 ↑ 1.0 1,140 1

Hash (cost=23.40..23.40 rows=1,140 width=13) (actual time=0.363..0.364 rows=1,140 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 67kB
129. 0.154 0.154 ↑ 1.0 1,140 1

Seq Scan on mat_type (cost=0.00..23.40 rows=1,140 width=13) (actual time=0.019..0.154 rows=1,140 loops=1)

130. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=15.10..15.10 rows=510 width=76) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
131. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on mil_obs_type (cost=0.00..15.10 rows=510 width=76) (actual time=0.005..0.005 rows=0 loops=1)

132. 0.026 0.045 ↑ 1.0 131 1

Hash (cost=3.31..3.31 rows=131 width=13) (actual time=0.045..0.045 rows=131 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
133. 0.019 0.019 ↑ 1.0 131 1

Seq Scan on mil_org_type (cost=0.00..3.31 rows=131 width=13) (actual time=0.006..0.019 rows=131 loops=1)

134. 0.003 0.007 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=13) (actual time=0.007..0.007 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
135. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on mil_post_type (cost=0.00..1.01 rows=1 width=13) (actual time=0.004..0.004 rows=1 loops=1)

136. 0.014 0.025 ↑ 1.0 55 1

Hash (cost=1.55..1.55 rows=55 width=45) (actual time=0.025..0.025 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
137. 0.011 0.011 ↑ 1.0 55 1

Seq Scan on misc_eqpt_type (cost=0.00..1.55 rows=55 width=45) (actual time=0.005..0.011 rows=55 loops=1)

138. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=15.10..15.10 rows=510 width=76) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
139. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on mrt_eqpt_type (cost=0.00..15.10 rows=510 width=76) (actual time=0.002..0.002 rows=0 loops=1)

140. 0.027 0.049 ↑ 1.0 131 1

Hash (cost=3.31..3.31 rows=131 width=16) (actual time=0.049..0.049 rows=131 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
141. 0.022 0.022 ↑ 1.0 131 1

Seq Scan on org_type (cost=0.00..3.31 rows=131 width=16) (actual time=0.005..0.022 rows=131 loops=1)

142. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=20) (actual time=0.002..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
143. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on pers_type (cost=0.00..14.30 rows=430 width=20) (actual time=0.002..0.002 rows=0 loops=1)

144. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=15.10..15.10 rows=510 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
145. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on prv_sctr_org_type (cost=0.00..15.10 rows=510 width=20) (actual time=0.002..0.002 rows=0 loops=1)

146. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=15.10..15.10 rows=510 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
147. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on radact_mat_type (cost=0.00..15.10 rows=510 width=20) (actual time=0.002..0.002 rows=0 loops=1)

148. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=14.60..14.60 rows=460 width=76) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
149. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on railcar_type (cost=0.00..14.60 rows=460 width=76) (actual time=0.002..0.002 rows=0 loops=1)

150. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
151. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on route_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.002..0.002 rows=0 loops=1)

152. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.40..14.40 rows=440 width=48) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
153. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on subsurf_vessel_type (cost=0.00..14.40 rows=440 width=48) (actual time=0.002..0.002 rows=0 loops=1)

154. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=15.10..15.10 rows=510 width=48) (actual time=0.002..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
155. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on surf_vessel_type (cost=0.00..15.10 rows=510 width=48) (actual time=0.002..0.002 rows=0 loops=1)

156. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
157. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on task_frmtn_type (cost=0.00..16.20 rows=620 width=20) (actual time=0.002..0.002 rows=0 loops=1)

158. 0.042 0.069 ↑ 1.0 130 1

Hash (cost=3.30..3.30 rows=130 width=52) (actual time=0.069..0.069 rows=130 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
159. 0.027 0.027 ↑ 1.0 130 1

Seq Scan on unit_type (cost=0.00..3.30 rows=130 width=52) (actual time=0.006..0.027 rows=130 loops=1)

160. 0.058 0.096 ↑ 1.0 276 1

Hash (cost=5.76..5.76 rows=276 width=19) (actual time=0.096..0.096 rows=276 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
161. 0.038 0.038 ↑ 1.0 276 1

Seq Scan on vehicle_type (cost=0.00..5.76 rows=276 width=19) (actual time=0.006..0.038 rows=276 loops=1)

162. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=12.70..12.70 rows=270 width=48) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
163. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on vessel_type (cost=0.00..12.70 rows=270 width=48) (actual time=0.002..0.002 rows=0 loops=1)

164. 0.095 0.157 ↑ 1.0 422 1

Hash (cost=10.22..10.22 rows=422 width=23) (actual time=0.157..0.157 rows=422 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
165. 0.062 0.062 ↑ 1.0 422 1

Seq Scan on weapon_type (cost=0.00..10.22 rows=422 width=23) (actual time=0.005..0.062 rows=422 loops=1)

166. 0.062 0.062 ↓ 0.0 0 31

Index Scan using contxt_oistat_contxt_id_obj_item_id_idx on contxt_oistat (cost=0.27..1.14 rows=1 width=47) (actual time=0.002..0.002 rows=0 loops=31)

  • Index Cond: ((contxt_coia.contxt_id = contxt_id) AND (contxt_id = '10321812000000601400'::numeric) AND (contxt_coia.obj_item_id = obj_item_id))
167. 0.062 0.062 ↑ 1.0 1 31

Index Scan using contxt_oicmt_contxt_id_obj_item_id_idx on contxt_oicmt (cost=0.27..1.14 rows=1 width=42) (actual time=0.002..0.002 rows=1 loops=31)

  • Index Cond: ((contxt_coia.contxt_id = contxt_id) AND (contxt_id = '10321812000000601400'::numeric) AND (contxt_coia.obj_item_id = obj_item_id))
168. 0.005 0.124 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.69..3.03 rows=2 width=125) (actual time=0.004..0.004 rows=0 loops=31)

169. 0.018 0.093 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.42..2.28 rows=2 width=110) (actual time=0.003..0.003 rows=0 loops=31)

170. 0.062 0.062 ↓ 0.0 0 31

Index Scan using obj_item_stat_obj_item_id_idx on obj_item_stat (cost=0.27..1.76 rows=2 width=26) (actual time=0.002..0.002 rows=0 loops=31)

  • Index Cond: (contxt_coia.obj_item_id = obj_item_id)
171. 0.013 0.013 ↓ 0.0 0 13

Index Scan using fac_stat_pkey on fac_stat (cost=0.14..0.26 rows=1 width=124) (actual time=0.001..0.001 rows=0 loops=13)

  • Index Cond: ((obj_item_stat.obj_item_id = fac_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
172. 0.026 0.026 ↑ 1.0 1 13

Index Scan using org_stat_pkey on org_stat (cost=0.27..0.38 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=13)

  • Index Cond: ((obj_item_stat.obj_item_id = org_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
173. 0.069 1.674 ↑ 1.0 1 31

Nested Loop (cost=0.83..846.41 rows=1 width=156) (actual time=0.034..0.054 rows=1 loops=31)

174. 0.279 0.279 ↑ 50.0 2 31

Function Scan on unnest selector (cost=0.41..1.41 rows=100 width=40) (actual time=0.009..0.009 rows=2 loops=31)

175. 1.326 1.326 ↑ 1.0 1 51

Index Scan using symbol_map_2525c_mir_sub_type_descr_txt_idx on symbol_map_2525c (cost=0.42..8.44 rows=1 width=200) (actual time=0.026..0.026 rows=1 loops=51)

  • Index Cond: ((mir_sub_type = CASE WHEN (surf_vessel_type.surf_vessel_type_id IS NOT NULL) THEN 'SURFACE-VESSEL-TYPE'::text WHEN (task_frmtn_type.task_frmtn_type_id IS NOT NULL) THEN 'TASK-FORMATION-TYPE'::text WHEN (mil_post_type.mil_post_type_id IS NOT NULL) THEN 'MILITARY-POST-TYPE'::text WHEN (exctv_mil_org_type.exctv_mil_org_type_id IS NOT NULL) THEN 'EXECUTIVE-MILITARY-ORGANISATION-TYPE'::text WHEN (unit_type.unit_type_id IS NOT NULL) THEN 'UNIT-TYPE'::text WHEN (subsurf_vessel_type.subsurf_vessel_type_id IS NOT NULL) THEN 'SUBSURFACE-VESSEL-TYPE'::text WHEN (railcar_type.railcar_type_id IS NOT NULL) THEN 'RAILCAR-TYPE'::text WHEN (bio_mat_type.bio_mat_type_id IS NOT NULL) THEN 'BIOLOGICAL-MATERIEL-TYPE'::text WHEN (chm_mat_type.chm_mat_type_id IS NOT NULL) THEN 'CHEMICAL-MATERIEL-TYPE'::text WHEN (radact_mat_type.radact_mat_type_id IS NOT NULL) THEN 'RADIOACTIVE-MATERIEL-TYPE'::text WHEN (ammo_type.ammo_type_id IS NOT NULL) THEN 'AMMUNITION-TYPE'::text WHEN (route_type.route_type_id IS NOT NULL) THEN 'ROUTE-TYPE'::text WHEN (acft_type.acft_type_id IS NOT NULL) THEN 'AIRCRAFT-TYPE'::text WHEN (elctrnc_eqpt_type.elctrnc_eqpt_type_id IS NOT NULL) THEN 'ELECTRONIC-EQUIPMENT-TYPE'::text WHEN (eng_eqpt_type.eng_eqpt_type_id IS NOT NULL) THEN 'ENGINEERING-EQUIPMENT-TYPE'::text WHEN (weapon_type.weapon_type_id IS NOT NULL) THEN 'WEAPON-TYPE'::text WHEN (misc_eqpt_type.misc_eqpt_type_id IS NOT NULL) THEN 'MISCELLANEOUS-EQUIPMENT-TYPE'::text WHEN (cbrn_eqpt_type.cbrn_eqpt_type_id IS NOT NULL) THEN 'CBRN-EQUIPMENT-TYPE'::text WHEN (vehicle_type.vehicle_type_id IS NOT NULL) THEN 'VEHICLE-TYPE'::text WHEN (vessel_type.vessel_type_id IS NOT NULL) THEN 'VESSEL-TYPE'::text WHEN (mrt_eqpt_type.mrt_eqpt_type_id IS NOT NULL) THEN 'MARITIME-EQUIPMENT-TYPE'::text WHEN (mil_org_type.mil_org_type_id IS NOT NULL) THEN 'MILITARY-ORGANISATION-TYPE'::text WHEN (mil_obs_type.mil_obs_type_id IS NOT NULL) THEN 'MILITARY-OBSTACLE-TYPE'::text WHEN (bridge_type.bridge_type_id IS NOT NULL) THEN 'BRIDGE-TYPE'::text WHEN (cons_mat_type.cons_mat_type_id IS NOT NULL) THEN 'CONSUMABLE-MATERIEL-TYPE'::text WHEN (eqpt_type.eqpt_type_id IS NOT NULL) THEN 'EQUIPMENT-TYPE'::text WHEN (civ_post_type.civ_post_type_id IS NOT NULL) THEN 'CIVILIAN-POST-TYPE'::text WHEN (govt_org_type.govt_org_type_id IS NOT NULL) THEN 'GOVERNMENT-ORGANISATION-TYPE'::text WHEN (group_org_type.group_org_type_id IS NOT NULL) THEN 'GROUP-ORGANISATION-TYPE'::text WHEN (prv_sctr_org_type.prv_sctr_org_type_id IS NOT NULL) THEN 'PRIVATE-SECTOR-ORGANISATION-TYPE'::text WHEN (geo_feat_type.geo_feat_type_id IS NOT NULL) THEN 'GEOGRAPHIC-FEATURE-TYPE'::text WHEN (ctrl_feat_type.ctrl_feat_type_id IS NOT NULL) THEN 'CONTROL-FEATURE-TYPE'::text WHEN (hrbr_type.hrbr_type_id IS NOT NULL) THEN 'HARBOUR-TYPE'::text WHEN (airfield_type.airfield_type_id IS NOT NULL) THEN 'AIRFIELD-TYPE'::text WHEN (mat_type.mat_type_id IS NOT NULL) THEN 'MATERIEL-TYPE'::text WHEN (pers_type.pers_type_id IS NOT NULL) THEN 'PERSON-TYPE'::text WHEN (fac_type.fac_type_id IS NOT NULL) THEN 'FACILITY-TYPE'::text WHEN (feat_type.feat_type_id IS NOT NULL) THEN 'FEATURE-TYPE'::text WHEN (org_type.org_type_id IS NOT NULL) THEN 'ORGANISATION-TYPE'::text WHEN (obj_type.obj_type_id IS NOT NULL) THEN 'OBJ_TYPE'::text ELSE NULL::text END) AND (descr_txt = selector.descr_txt))
  • Filter: (flags = ANY ('{10,11}'::""bit""[]))
Planning time : 50.211 ms
Execution time : 667.506 ms