explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0nzO

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

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

2. 0.486 663.343 ↓ 31.0 31 1

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

3. 0.018 662.857 ↓ 31.0 31 1

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

4. 0.117 662.839 ↓ 37.0 37 1

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

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

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

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

Nested Loop Left Join (cost=1,813.29..1,920.80 rows=1 width=1,710) (actual time=657.947..660.883 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.039 660.724 ↓ 31.0 31 1

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

8. 0.052 660.623 ↓ 31.0 31 1

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

9. 0.410 660.509 ↓ 31.0 31 1

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

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

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

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

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

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

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

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

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

14. 0.001 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.002 0.002 ↓ 0.0 0 1

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

16. 0.111 0.188 ↑ 1.0 575 1

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

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

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

18. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.10..13.10 rows=310 width=34) (actual time=0.002..0.002 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.101 657.559 ↓ 31.0 31 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
21. 7.971 657.458 ↓ 31.0 31 1

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

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

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

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

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

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

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

25. 0.055 19.711 ↓ 31.0 31 1

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

26. 2.737 19.470 ↓ 31.0 31 1

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

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

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

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

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

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

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

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

Seq Scan on loc (cost=0.00..461.77 rows=23,677 width=13) (actual time=0.005..2.316 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.001 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.002 0.002 ↓ 0.0 0 1

Seq Scan on fan_area (cost=0.00..14.40 rows=440 width=80) (actual time=0.002..0.002 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.073 ↓ 31.0 31 1

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

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

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

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

Bitmap Heap Scan on contxt_oiloca (cost=4.52..48.90 rows=31 width=72) (actual time=0.012..0.014 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.011 0.023 ↑ 1.0 33 1

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

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

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

  • Recheck Cond: (contxt_id = '10321812000000601400'::numeric)
  • Heap Blocks: exact=1
43. 0.005 0.005 ↑ 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.005..0.005 rows=33 loops=1)

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

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

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

Index Scan using geog__loc_id on geog (cost=0.29..7.79 rows=1 width=65) (actual time=0.004..0.004 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.124 0.124 ↑ 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.004..0.004 rows=1 loops=31)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Hash Cond: (obj_type.obj_type_id = acft_type.acft_type_id)
87. 5.394 5.394 ↑ 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.174 rows=1,380 loops=31)

88. 0.106 0.161 ↑ 1.0 231 1

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

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

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

90. 0.000 0.004 ↓ 0.0 0 1

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

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

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

92. 0.001 0.004 ↓ 0.0 0 1

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

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

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

94. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=20) (actual time=0.003..0.003 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.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
97. 0.003 0.003 ↓ 0.0 0 1

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

98. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=16.20..16.20 rows=620 width=20) (actual time=0.003..0.003 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.001 0.003 ↓ 0.0 0 1

Hash (cost=14.30..14.30 rows=430 width=20) (actual time=0.003..0.003 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.032 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.020 0.020 ↑ 1.0 109 1

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

108. 0.009 0.016 ↑ 1.0 24 1

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

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

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

110. 0.028 0.050 ↑ 1.0 132 1

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

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

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

112. 0.256 0.431 ↑ 1.0 1,140 1

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

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

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

114. 0.000 0.004 ↓ 0.0 0 1

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

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

Seq Scan on exctv_mil_org_type (cost=0.00..16.20 rows=620 width=48) (actual time=0.004..0.004 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.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
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.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
123. 0.020 0.020 ↑ 1.0 131 1

Seq Scan on govt_org_type (cost=0.00..3.31 rows=131 width=13) (actual time=0.006..0.020 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.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
127. 0.002 0.002 ↓ 0.0 0 1

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

128. 0.201 0.339 ↑ 1.0 1,140 1

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

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

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

130. 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
131. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on mil_obs_type (cost=0.00..15.10 rows=510 width=76) (actual time=0.002..0.002 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.005..0.019 rows=131 loops=1)

134. 0.004 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.003 0.003 ↑ 1.0 1 1

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

136. 0.014 0.024 ↑ 1.0 55 1

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

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

Seq Scan on misc_eqpt_type (cost=0.00..1.55 rows=55 width=45) (actual time=0.004..0.010 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.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
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.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
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.003..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.043 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.026 0.026 ↑ 1.0 130 1

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

160. 0.056 0.095 ↑ 1.0 276 1

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

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

Seq Scan on vehicle_type (cost=0.00..5.76 rows=276 width=19) (actual time=0.005..0.039 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.131 0.251 ↑ 1.0 422 1

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

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

Seq Scan on weapon_type (cost=0.00..10.22 rows=422 width=23) (actual time=0.044..0.120 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.002..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.058 1.612 ↑ 1.0 1 31

Nested Loop (cost=0.83..846.41 rows=1 width=156) (actual time=0.034..0.052 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.275 1.275 ↑ 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.025..0.025 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 : 42.159 ms
Execution time : 665.683 ms