explain.depesz.com

PostgreSQL's explain analyze made readable

Result: snIX

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 2,887.762 ↓ 31.0 31 1

Unique (cost=6,639.38..6,639.39 rows=1 width=16,143) (actual time=2,887.748..2,887.762 rows=31 loops=1)

2. 0.329 2,887.749 ↓ 37.0 37 1

Sort (cost=6,639.38..6,639.39 rows=1 width=16,143) (actual time=2,887.747..2,887.749 rows=37 loops=1)

  • Sort Key: contxt_coia.obj_item_id, selector.idx
  • Sort Method: quicksort Memory: 62kB
3. 0.495 2,887.420 ↓ 37.0 37 1

Nested Loop (cost=5,155.48..6,639.37 rows=1 width=16,143) (actual time=147.070..2,887.420 rows=37 loops=1)

  • Join Filter: ((symbol_map_2525c.geometry IS NULL) OR (geog.cat_code = ANY (symbol_map_2525c.geometry)))
4. 0.191 2,884.631 ↓ 31.0 31 1

Nested Loop Left Join (cost=5,154.65..5,792.94 rows=1 width=17,620) (actual time=146.801..2,884.631 rows=31 loops=1)

5. 0.184 2,883.572 ↓ 31.0 31 1

Nested Loop Left Join (cost=5,152.20..5,784.62 rows=1 width=15,516) (actual time=146.756..2,883.572 rows=31 loops=1)

6. 20.098 2,883.233 ↓ 31.0 31 1

Nested Loop (cost=5,151.93..5,783.42 rows=1 width=15,487) (actual time=146.722..2,883.233 rows=31 loops=1)

  • Join Filter: (contxt_coia.obj_item_id = obj_item.obj_item_id)
  • Rows Removed by Join Filter: 97650
7. 0.143 166.197 ↓ 31.0 31 1

Nested Loop Left Join (cost=4,355.17..4,532.89 rows=1 width=4,625) (actual time=137.943..166.197 rows=31 loops=1)

8. 0.394 165.837 ↓ 31.0 31 1

Hash Join (cost=4,354.89..4,531.59 rows=1 width=4,604) (actual time=137.911..165.837 rows=31 loops=1)

  • Hash Cond: (obj_type.obj_type_id = contxt_oitype.obj_type_id)
9. 1.041 30.071 ↑ 1.0 1,380 1

Hash Left Join (cost=665.40..836.91 rows=1,380 width=2,884) (actual time=2.317..30.071 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = weapon_type.weapon_type_id)
10. 0.949 28.861 ↑ 1.0 1,380 1

Hash Left Join (cost=649.90..817.78 rows=1,380 width=2,828) (actual time=2.130..28.861 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = vessel_type.vessel_type_id)
11. 0.953 27.909 ↑ 1.0 1,380 1

Hash Left Join (cost=633.83..798.07 rows=1,380 width=2,608) (actual time=2.109..27.909 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = vehicle_type.vehicle_type_id)
12. 0.952 26.862 ↑ 1.0 1,380 1

Hash Left Join (cost=624.62..785.23 rows=1,380 width=2,589) (actual time=1.997..26.862 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = unit_type.unit_type_id)
13. 0.881 25.839 ↑ 1.0 1,380 1

Hash Left Join (cost=619.69..776.67 rows=1,380 width=2,497) (actual time=1.911..25.839 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = task_frmtn_type.task_frmtn_type_id)
14. 0.856 24.956 ↑ 1.0 1,380 1

Hash Left Join (cost=595.74..749.08 rows=1,380 width=2,449) (actual time=1.893..24.956 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = surf_vessel_type.surf_vessel_type_id)
15. 0.844 24.094 ↑ 1.0 1,380 1

Hash Left Join (cost=574.27..723.97 rows=1,380 width=2,373) (actual time=1.872..24.094 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = subsurf_vessel_type.subsurf_vessel_type_id)
16. 0.852 23.248 ↑ 1.0 1,380 1

Hash Left Join (cost=554.37..700.44 rows=1,380 width=2,271) (actual time=1.855..23.248 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = route_type.route_type_id)
17. 0.873 22.394 ↑ 1.0 1,380 1

Hash Left Join (cost=530.42..672.86 rows=1,380 width=2,223) (actual time=1.835..22.394 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = railcar_type.railcar_type_id)
18. 0.824 21.519 ↑ 1.0 1,380 1

Hash Left Join (cost=510.07..648.87 rows=1,380 width=2,131) (actual time=1.818..21.519 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = radact_mat_type.radact_mat_type_id)
19. 0.795 20.693 ↑ 1.0 1,380 1

Hash Left Join (cost=488.59..623.77 rows=1,380 width=2,055) (actual time=1.802..20.693 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = prv_sctr_org_type.prv_sctr_org_type_id)
20. 0.797 19.896 ↑ 1.0 1,380 1

Hash Left Join (cost=467.12..598.66 rows=1,380 width=1,979) (actual time=1.786..19.896 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = pers_type.pers_type_id)
21. 0.815 19.097 ↑ 1.0 1,380 1

Hash Left Join (cost=447.44..575.35 rows=1,380 width=1,875) (actual time=1.770..19.097 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = org_type.org_type_id)
22. 0.756 18.227 ↑ 1.0 1,380 1

Hash Left Join (cost=442.49..566.77 rows=1,380 width=1,842) (actual time=1.702..18.227 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = mrt_eqpt_type.mrt_eqpt_type_id)
23. 0.754 17.469 ↑ 1.0 1,380 1

Hash Left Join (cost=421.02..541.66 rows=1,380 width=1,766) (actual time=1.686..17.469 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = misc_eqpt_type.misc_eqpt_type_id)
24. 0.730 16.692 ↑ 1.0 1,380 1

Hash Left Join (cost=418.78..535.79 rows=1,380 width=1,721) (actual time=1.649..16.692 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = mil_post_type.mil_post_type_id)
25. 0.764 15.955 ↑ 1.0 1,380 1

Hash Left Join (cost=417.76..531.13 rows=1,380 width=1,700) (actual time=1.629..15.955 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = mil_org_type.mil_org_type_id)
26. 0.711 15.141 ↑ 1.0 1,380 1

Hash Left Join (cost=412.81..522.55 rows=1,380 width=1,677) (actual time=1.565..15.141 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = mil_obs_type.mil_obs_type_id)
27. 0.930 14.427 ↑ 1.0 1,380 1

Hash Left Join (cost=391.33..497.44 rows=1,380 width=1,601) (actual time=1.551..14.427 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = mat_type.mat_type_id)
28. 0.671 13.061 ↑ 1.0 1,380 1

Hash Left Join (cost=353.69..456.16 rows=1,380 width=1,433) (actual time=1.101..13.061 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = hrbr_type.hrbr_type_id)
29. 0.661 12.388 ↑ 1.0 1,380 1

Hash Left Join (cost=329.74..428.57 rows=1,380 width=1,385) (actual time=1.084..12.388 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = group_org_type.group_org_type_id)
30. 0.730 11.724 ↑ 1.0 1,380 1

Hash Left Join (cost=305.79..400.99 rows=1,380 width=1,337) (actual time=1.067..11.724 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = govt_org_type.govt_org_type_id)
31. 0.681 10.945 ↑ 1.0 1,380 1

Hash Left Join (cost=300.84..392.41 rows=1,380 width=1,289) (actual time=1.003..10.945 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = geo_feat_type.geo_feat_type_id)
32. 0.710 10.261 ↑ 1.0 1,380 1

Hash Left Join (cost=279.36..367.30 rows=1,380 width=1,213) (actual time=0.986..10.261 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = feat_type.feat_type_id)
33. 0.620 9.509 ↑ 1.0 1,380 1

Hash Left Join (cost=274.91..359.21 rows=1,380 width=1,197) (actual time=0.931..9.509 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = fac_type.fac_type_id)
34. 0.640 8.887 ↑ 1.0 1,380 1

Hash Left Join (cost=250.96..331.63 rows=1,380 width=1,149) (actual time=0.912..8.887 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = exctv_mil_org_type.exctv_mil_org_type_id)
35. 0.871 8.245 ↑ 1.0 1,380 1

Hash Left Join (cost=227.01..304.05 rows=1,380 width=1,101) (actual time=0.896..8.245 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = eqpt_type.eqpt_type_id)
36. 0.630 6.902 ↑ 1.0 1,380 1

Hash Left Join (cost=187.36..260.76 rows=1,380 width=1,047) (actual time=0.416..6.902 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = eng_eqpt_type.eng_eqpt_type_id)
37. 0.608 6.224 ↑ 1.0 1,380 1

Hash Left Join (cost=182.39..252.16 rows=1,380 width=1,028) (actual time=0.356..6.224 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = elctrnc_eqpt_type.elctrnc_eqpt_type_id)
38. 0.572 5.601 ↑ 1.0 1,380 1

Hash Left Join (cost=180.85..246.99 rows=1,380 width=1,003) (actual time=0.328..5.601 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = ctrl_feat_type.ctrl_feat_type_id)
39. 0.556 4.982 ↑ 1.0 1,380 1

Hash Left Join (cost=176.40..238.90 rows=1,380 width=982) (actual time=0.270..4.982 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = cons_mat_type.cons_mat_type_id)
40. 0.531 4.424 ↑ 1.0 1,380 1

Hash Left Join (cost=161.00..219.87 rows=1,380 width=736) (actual time=0.256..4.424 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = civ_post_type.civ_post_type_id)
41. 0.542 3.891 ↑ 1.0 1,380 1

Hash Left Join (cost=137.05..192.28 rows=1,380 width=688) (actual time=0.243..3.891 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = chm_mat_type.chm_mat_type_id)
42. 0.513 3.347 ↑ 1.0 1,380 1

Hash Left Join (cost=117.37..168.97 rows=1,380 width=584) (actual time=0.230..3.347 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = cbrn_eqpt_type.cbrn_eqpt_type_id)
43. 0.490 2.831 ↑ 1.0 1,380 1

Hash Left Join (cost=93.42..141.39 rows=1,380 width=536) (actual time=0.217..2.831 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = bridge_type.bridge_type_id)
44. 0.479 2.338 ↑ 1.0 1,380 1

Hash Left Join (cost=69.47..113.81 rows=1,380 width=488) (actual time=0.202..2.338 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = bio_mat_type.bio_mat_type_id)
45. 0.486 1.856 ↑ 1.0 1,380 1

Hash Left Join (cost=49.80..90.50 rows=1,380 width=384) (actual time=0.189..1.856 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = ammo_type.ammo_type_id)
46. 0.466 1.368 ↑ 1.0 1,380 1

Hash Left Join (cost=32.15..69.21 rows=1,380 width=232) (actual time=0.176..1.368 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = airfield_type.airfield_type_id)
47. 0.568 0.900 ↑ 1.0 1,380 1

Hash Left Join (cost=8.20..41.63 rows=1,380 width=184) (actual time=0.162..0.900 rows=1,380 loops=1)

  • Hash Cond: (obj_type.obj_type_id = acft_type.acft_type_id)
48. 0.200 0.200 ↑ 1.0 1,380 1

Seq Scan on obj_type (cost=0.00..29.80 rows=1,380 width=27) (actual time=0.010..0.200 rows=1,380 loops=1)

49. 0.080 0.132 ↑ 1.0 231 1

Hash (cost=5.31..5.31 rows=231 width=157) (actual time=0.132..0.132 rows=231 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
50. 0.052 0.052 ↑ 1.0 231 1

Seq Scan on acft_type (cost=0.00..5.31 rows=231 width=157) (actual time=0.007..0.052 rows=231 loops=1)

51. 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
52. 0.002 0.002 ↓ 0.0 0 1

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

53. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.40..13.40 rows=340 width=152) (actual time=0.002..0.002 rows=0 loops=1)

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

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

55. 0.001 0.003 ↓ 0.0 0 1

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

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

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

57. 0.001 0.003 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
58. 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)

59. 0.001 0.003 ↓ 0.0 0 1

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

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

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

61. 0.000 0.002 ↓ 0.0 0 1

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

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

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

63. 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
64. 0.002 0.002 ↓ 0.0 0 1

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

65. 0.000 0.002 ↓ 0.0 0 1

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

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

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

67. 0.028 0.047 ↑ 1.0 109 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
68. 0.019 0.019 ↑ 1.0 109 1

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

69. 0.008 0.015 ↑ 1.0 24 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
70. 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)

71. 0.028 0.048 ↑ 1.0 132 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
72. 0.020 0.020 ↑ 1.0 132 1

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

73. 0.290 0.472 ↑ 1.0 1,140 1

Hash (cost=25.40..25.40 rows=1,140 width=54) (actual time=0.472..0.472 rows=1,140 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 77kB
74. 0.182 0.182 ↑ 1.0 1,140 1

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

75. 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
76. 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)

77. 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
78. 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)

79. 0.025 0.042 ↑ 1.0 109 1

Hash (cost=3.09..3.09 rows=109 width=16) (actual time=0.041..0.042 rows=109 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
80. 0.017 0.017 ↑ 1.0 109 1

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

81. 0.001 0.003 ↓ 0.0 0 1

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

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

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

83. 0.028 0.049 ↑ 1.0 131 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
84. 0.021 0.021 ↑ 1.0 131 1

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

85. 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
86. 0.002 0.002 ↓ 0.0 0 1

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

87. 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
88. 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)

89. 0.260 0.436 ↑ 1.0 1,140 1

Hash (cost=23.40..23.40 rows=1,140 width=168) (actual time=0.435..0.436 rows=1,140 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
90. 0.176 0.176 ↑ 1.0 1,140 1

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

91. 0.001 0.003 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
92. 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)

93. 0.029 0.050 ↑ 1.0 131 1

Hash (cost=3.31..3.31 rows=131 width=23) (actual time=0.050..0.050 rows=131 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
94. 0.021 0.021 ↑ 1.0 131 1

Seq Scan on mil_org_type (cost=0.00..3.31 rows=131 width=23) (actual time=0.005..0.021 rows=131 loops=1)

95. 0.003 0.007 ↑ 1.0 1 1

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

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

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

97. 0.013 0.023 ↑ 1.0 55 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
98. 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)

99. 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
100. 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)

101. 0.033 0.055 ↑ 1.0 131 1

Hash (cost=3.31..3.31 rows=131 width=33) (actual time=0.055..0.055 rows=131 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
102. 0.022 0.022 ↑ 1.0 131 1

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

103. 0.000 0.002 ↓ 0.0 0 1

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

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

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

105. 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
106. 0.002 0.002 ↓ 0.0 0 1

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

107. 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
108. 0.002 0.002 ↓ 0.0 0 1

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

109. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.60..14.60 rows=460 width=92) (actual time=0.002..0.002 rows=0 loops=1)

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

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

111. 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
112. 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)

113. 0.000 0.002 ↓ 0.0 0 1

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

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

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

115. 0.000 0.006 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
116. 0.006 0.006 ↓ 0.0 0 1

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

117. 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
118. 0.002 0.002 ↓ 0.0 0 1

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

119. 0.044 0.071 ↑ 1.0 130 1

Hash (cost=3.30..3.30 rows=130 width=92) (actual time=0.070..0.071 rows=130 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
120. 0.027 0.027 ↑ 1.0 130 1

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

121. 0.056 0.094 ↑ 1.0 276 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
122. 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.005..0.038 rows=276 loops=1)

123. 0.001 0.003 ↓ 0.0 0 1

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

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

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

125. 0.103 0.169 ↑ 1.0 422 1

Hash (cost=10.22..10.22 rows=422 width=56) (actual time=0.169..0.169 rows=422 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
126. 0.066 0.066 ↑ 1.0 422 1

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

127. 0.056 135.372 ↓ 31.0 31 1

Hash (cost=3,689.49..3,689.49 rows=1 width=1,720) (actual time=135.372..135.372 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
128. 0.049 135.316 ↓ 31.0 31 1

Nested Loop (cost=2,241.61..3,689.49 rows=1 width=1,720) (actual time=25.798..135.316 rows=31 loops=1)

  • Join Filter: (contxt_coia.obj_item_id = contxt_oitype.obj_item_id)
129. 0.049 135.205 ↓ 31.0 31 1

Nested Loop (cost=2,241.33..3,683.23 rows=1 width=1,686) (actual time=25.782..135.205 rows=31 loops=1)

  • Join Filter: (contxt_coia.obj_item_id = contxt_oihsts.obj_item_id)
130. 0.032 135.094 ↓ 31.0 31 1

Nested Loop Left Join (cost=2,241.04..3,676.98 rows=1 width=1,662) (actual time=25.765..135.094 rows=31 loops=1)

131. 0.041 135.000 ↓ 31.0 31 1

Nested Loop Left Join (cost=2,240.76..3,669.19 rows=1 width=1,610) (actual time=25.750..135.000 rows=31 loops=1)

132. 0.043 134.959 ↓ 31.0 31 1

Nested Loop Left Join (cost=2,240.61..3,669.02 rows=1 width=1,518) (actual time=25.739..134.959 rows=31 loops=1)

133. 0.039 134.916 ↓ 31.0 31 1

Nested Loop Left Join (cost=2,240.46..3,668.85 rows=1 width=1,478) (actual time=25.727..134.916 rows=31 loops=1)

134. 0.015 134.846 ↓ 31.0 31 1

Nested Loop Left Join (cost=2,240.18..3,668.56 rows=1 width=1,458) (actual time=25.714..134.846 rows=31 loops=1)

135. 0.027 134.800 ↓ 31.0 31 1

Nested Loop (cost=2,240.03..3,668.39 rows=1 width=1,402) (actual time=25.702..134.800 rows=31 loops=1)

136. 3.038 134.680 ↓ 31.0 31 1

Hash Join (cost=2,239.75..3,660.60 rows=1 width=1,181) (actual time=25.677..134.680 rows=31 loops=1)

  • Hash Cond: (loc.loc_id = contxt_oiloca.loc_id)
137. 8.262 131.569 ↑ 1.0 23,677 1

Hash Left Join (cost=2,147.79..3,479.85 rows=23,677 width=1,088) (actual time=21.519..131.569 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = rel_point.rel_point_id)
138. 8.277 123.284 ↑ 1.0 23,677 1

Hash Left Join (cost=2,130.59..3,400.48 rows=23,677 width=916) (actual time=21.447..123.284 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = polygon_area.polygon_area_id)
139. 11.497 114.652 ↑ 1.0 23,677 1

Hash Left Join (cost=2,108.21..3,315.94 rows=23,677 width=890) (actual time=21.082..114.652 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = point.point_id)
140. 8.057 96.879 ↑ 1.0 23,677 1

Hash Left Join (cost=1,484.58..2,630.14 rows=23,677 width=873) (actual time=14.696..96.879 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = plyrc_area.plyrc_area_id)
141. 7.336 88.819 ↑ 1.0 23,677 1

Hash Left Join (cost=1,464.90..2,548.31 rows=23,677 width=769) (actual time=14.687..88.819 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = orbit_area.orbit_area_id)
142. 8.077 81.480 ↑ 1.0 23,677 1

Hash Left Join (cost=1,445.23..2,466.47 rows=23,677 width=665) (actual time=14.678..81.480 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = line.line_id)
143. 11.317 72.915 ↑ 1.0 23,677 1

Hash Left Join (cost=1,394.32..2,353.39 rows=23,677 width=652) (actual time=14.180..72.915 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = geo_point.geo_point_id)
144. 6.739 54.315 ↑ 1.0 23,677 1

Hash Left Join (cost=731.68..1,628.60 rows=23,677 width=567) (actual time=6.780..54.315 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = geom_vol.geom_vol_id)
145. 6.374 47.574 ↑ 1.0 23,677 1

Hash Left Join (cost=710.88..1,545.63 rows=23,677 width=479) (actual time=6.765..47.574 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = fan_area.fan_area_id)
146. 6.117 41.198 ↑ 1.0 23,677 1

Hash Left Join (cost=690.98..1,463.57 rows=23,677 width=379) (actual time=6.751..41.198 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = elps.elps_id)
147. 5.805 35.078 ↑ 1.0 23,677 1

Hash Left Join (cost=669.73..1,380.16 rows=23,677 width=299) (actual time=6.737..35.078 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = crts_point.crts_point_id)
148. 5.577 29.270 ↑ 1.0 23,677 1

Hash Left Join (cost=652.08..1,300.34 rows=23,677 width=147) (actual time=6.722..29.270 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = corridor_area.corridor_area_id)
149. 5.160 23.631 ↑ 1.0 23,677 1

Hash Left Join (cost=646.46..1,232.56 rows=23,677 width=116) (actual time=6.648..23.631 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = cone_vol.cone_vol_id)
150. 9.211 18.468 ↑ 1.0 23,677 1

Hash Left Join (cost=623.63..1,147.57 rows=23,677 width=56) (actual time=6.632..18.468 rows=23,677 loops=1)

  • Hash Cond: (loc.loc_id = abs_point.abs_point_id)
151. 2.754 2.754 ↑ 1.0 23,677 1

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

152. 4.014 6.503 ↑ 1.0 19,006 1

Hash (cost=386.06..386.06 rows=19,006 width=40) (actual time=6.503..6.503 rows=19,006 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1222kB
153. 2.489 2.489 ↑ 1.0 19,006 1

Seq Scan on abs_point (cost=0.00..386.06 rows=19,006 width=40) (actual time=0.005..2.489 rows=19,006 loops=1)

154. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=15.70..15.70 rows=570 width=60) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on cone_vol (cost=0.00..15.70 rows=570 width=60) (actual time=0.003..0.003 rows=0 loops=1)

156. 0.037 0.062 ↑ 1.0 161 1

Hash (cost=3.61..3.61 rows=161 width=31) (actual time=0.062..0.062 rows=161 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
157. 0.025 0.025 ↑ 1.0 161 1

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

158. 0.001 0.003 ↓ 0.0 0 1

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

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

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

160. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=15.00..15.00 rows=500 width=80) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on elps (cost=0.00..15.00 rows=500 width=80) (actual time=0.002..0.002 rows=0 loops=1)

162. 0.000 0.002 ↓ 0.0 0 1

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

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

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

164. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.80..14.80 rows=480 width=88) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on geom_vol (cost=0.00..14.80 rows=480 width=88) (actual time=0.002..0.002 rows=0 loops=1)

166. 4.487 7.283 ↑ 1.0 19,006 1

Hash (cost=425.06..425.06 rows=19,006 width=85) (actual time=7.283..7.283 rows=19,006 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1425kB
167. 2.796 2.796 ↑ 1.0 19,006 1

Seq Scan on geo_point (cost=0.00..425.06 rows=19,006 width=85) (actual time=0.005..2.796 rows=19,006 loops=1)

168. 0.300 0.488 ↑ 1.0 1,596 1

Hash (cost=30.96..30.96 rows=1,596 width=13) (actual time=0.488..0.488 rows=1,596 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 87kB
169. 0.188 0.188 ↑ 1.0 1,596 1

Seq Scan on line (cost=0.00..30.96 rows=1,596 width=13) (actual time=0.008..0.188 rows=1,596 loops=1)

170. 0.001 0.003 ↓ 0.0 0 1

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

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

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

172. 0.001 0.003 ↓ 0.0 0 1

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

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

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

174. 3.859 6.276 ↑ 1.0 19,006 1

Hash (cost=386.06..386.06 rows=19,006 width=17) (actual time=6.276..6.276 rows=19,006 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1166kB
175. 2.417 2.417 ↑ 1.0 19,006 1

Seq Scan on point (cost=0.00..386.06 rows=19,006 width=17) (actual time=0.006..2.417 rows=19,006 loops=1)

176. 0.204 0.355 ↑ 1.0 639 1

Hash (cost=14.39..14.39 rows=639 width=26) (actual time=0.355..0.355 rows=639 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
177. 0.151 0.151 ↑ 1.0 639 1

Seq Scan on polygon_area (cost=0.00..14.39 rows=639 width=26) (actual time=0.007..0.151 rows=639 loops=1)

178. 0.000 0.023 ↓ 0.0 0 1

Hash (cost=13.20..13.20 rows=320 width=172) (actual time=0.023..0.023 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
179. 0.023 0.023 ↓ 0.0 0 1

Seq Scan on rel_point (cost=0.00..13.20 rows=320 width=172) (actual time=0.023..0.023 rows=0 loops=1)

180. 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: 13kB
181. 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)
182. 0.005 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
183. 0.010 0.010 ↑ 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.010..0.010 rows=31 loops=1)

  • Index Cond: (contxt_id = '10321812000000601400'::numeric)
184. 0.010 0.022 ↑ 1.0 33 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
185. 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
186. 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)
187. 0.093 0.093 ↑ 1.0 1 31

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

  • Index Cond: (rptd_id = contxt_oiloca.rptd_id)
188. 0.031 0.031 ↓ 0.0 0 31

Index Scan using sphere_vol_pkey on sphere_vol (cost=0.15..0.17 rows=1 width=56) (actual time=0.001..0.001 rows=0 loops=31)

  • Index Cond: (loc.loc_id = sphere_vol_id)
189. 0.031 0.031 ↓ 0.0 0 31

Index Scan using surf_pkey on surf (cost=0.28..0.30 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=31)

  • Index Cond: (loc.loc_id = surf_id)
190. 0.000 0.000 ↓ 0.0 0 31

Index Scan using surf_vol_pkey on surf_vol (cost=0.15..0.17 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=31)

  • Index Cond: (loc.loc_id = surf_vol_id)
191. 0.000 0.000 ↓ 0.0 0 31

Index Scan using track_area_pkey on track_area (cost=0.15..0.17 rows=1 width=92) (actual time=0.000..0.000 rows=0 loops=31)

  • Index Cond: (loc.loc_id = track_area_id)
192. 0.062 0.062 ↑ 1.0 1 31

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

  • Index Cond: (contxt_oiloca.loc_id = loc_id)
193. 0.062 0.062 ↑ 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.002..0.002 rows=1 loops=31)

  • Index Cond: ((contxt_id = '10321812000000601400'::numeric) AND (obj_item_id = contxt_oiloca.obj_item_id))
194. 0.062 0.062 ↑ 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.002..0.002 rows=1 loops=31)

  • Index Cond: ((contxt_id = '10321812000000601400'::numeric) AND (obj_item_id = contxt_oihsts.obj_item_id))
195. 0.217 0.217 ↓ 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.007..0.007 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))
196. 94.175 2,696.938 ↑ 1.0 3,151 31

Hash Left Join (cost=796.76..1,211.14 rows=3,151 width=10,901) (actual time=0.108..86.998 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = wind.wind_id)
197. 94.579 2,602.760 ↑ 1.0 3,151 31

Hash Left Join (cost=779.79..1,185.88 rows=3,151 width=10,727) (actual time=0.106..83.960 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = visibility.visibility_id)
198. 95.434 2,508.179 ↑ 1.0 3,151 31

Hash Left Join (cost=759.44..1,157.25 rows=3,151 width=10,635) (actual time=0.104..80.909 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = unit.unit_id)
199. 92.656 2,412.544 ↑ 1.0 3,151 31

Hash Left Join (cost=740.50..1,130.03 rows=3,151 width=10,612) (actual time=0.096..77.824 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = slpway.slpway_id)
200. 92.036 2,319.885 ↑ 1.0 3,151 31

Hash Left Join (cost=727.80..1,109.05 rows=3,151 width=10,062) (actual time=0.094..74.835 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = runway.runway_id)
201. 90.052 2,227.846 ↑ 1.0 3,151 31

Hash Left Join (cost=711.05..1,084.01 rows=3,151 width=9,874) (actual time=0.093..71.866 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = route_sgmnt.route_sgmnt_id)
202. 88.099 2,137.791 ↑ 1.0 3,151 31

Hash Left Join (cost=691.38..1,056.06 rows=3,151 width=9,770) (actual time=0.091..68.961 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = route.route_id)
203. 89.742 2,049.689 ↑ 1.0 3,151 31

Hash Left Join (cost=671.70..1,028.10 rows=3,151 width=9,666) (actual time=0.089..66.119 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = road.road_id)
204. 86.797 1,959.944 ↑ 1.0 3,151 31

Hash Left Join (cost=653.60..1,001.72 rows=3,151 width=9,522) (actual time=0.088..63.224 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = railway.railway_id)
205. 89.153 1,873.144 ↑ 1.0 3,151 31

Hash Left Join (cost=637.53..977.36 rows=3,151 width=9,308) (actual time=0.086..60.424 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = quay.quay_id)
206. 80.535 1,783.988 ↑ 1.0 3,151 31

Hash Left Join (cost=622.35..953.90 rows=3,151 width=9,044) (actual time=0.084..57.548 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = precipitation.precipitation_id)
207. 79.978 1,703.450 ↑ 1.0 3,151 31

Hash Left Join (cost=599.53..922.79 rows=3,151 width=8,984) (actual time=0.082..54.950 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = pers.pers_id)
208. 86.504 1,623.470 ↑ 1.0 3,151 31

Hash Left Join (cost=582.55..897.54 rows=3,151 width=8,804) (actual time=0.081..52.370 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = org.org_id)
209. 77.498 1,536.763 ↑ 1.0 3,151 31

Hash Left Join (cost=562.29..868.99 rows=3,151 width=8,788) (actual time=0.073..49.573 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = netwrk.netwrk_id)
210. 76.226 1,459.263 ↑ 1.0 3,151 31

Hash Left Join (cost=545.54..843.96 rows=3,151 width=8,600) (actual time=0.071..47.073 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = mnfld_mrt.mnfld_mrt_id)
211. 74.987 1,383.034 ↑ 1.0 3,151 31

Hash Left Join (cost=531.04..821.17 rows=3,151 width=8,274) (actual time=0.070..44.614 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = mnfld_land.mnfld_land_id)
212. 71.918 1,308.045 ↑ 1.0 3,151 31

Hash Left Join (cost=513.61..795.47 rows=3,151 width=8,114) (actual time=0.069..42.195 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = mnfld.mnfld_id)
213. 70.058 1,236.125 ↑ 1.0 3,151 31

Hash Left Join (cost=496.86..770.43 rows=3,151 width=7,926) (actual time=0.067..39.875 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = mil_obs.mil_obs_id)
214. 68.693 1,166.065 ↑ 1.0 3,151 31

Hash Left Join (cost=472.91..738.20 rows=3,151 width=7,878) (actual time=0.066..37.615 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = met_feat.met_feat_id)
215. 78.385 1,097.369 ↑ 1.0 3,151 31

Hash Left Join (cost=453.91..710.92 rows=3,151 width=7,760) (actual time=0.065..35.399 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = mat.mat_id)
216. 67.887 1,018.381 ↑ 1.0 3,151 31

Hash Left Join (cost=398.51..647.23 rows=3,151 width=7,633) (actual time=0.044..32.851 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = light.light_id)
217. 66.926 950.491 ↑ 1.0 3,151 31

Hash Left Join (cost=382.66..623.10 rows=3,151 width=7,405) (actual time=0.042..30.661 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = jetty.jetty_id)
218. 63.733 883.562 ↑ 1.0 3,151 31

Hash Left Join (cost=364.33..596.49 rows=3,151 width=7,269) (actual time=0.041..28.502 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = inst_lndg_sys.inst_lndg_sys_id)
219. 61.471 819.826 ↑ 1.0 3,151 31

Hash Left Join (cost=346.23..570.11 rows=3,151 width=7,129) (actual time=0.040..26.446 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = icing.icing_id)
220. 63.423 758.353 ↑ 1.0 3,151 31

Hash Left Join (cost=324.75..540.35 rows=3,151 width=7,053) (actual time=0.039..24.463 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = hrbr.hrbr_id)
221. 50.279 694.927 ↑ 1.0 3,151 31

Hash Left Join (cost=314.31..521.62 rows=3,151 width=4,305) (actual time=0.037..22.417 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = geo_feat.geo_feat_id)
222. 53.375 644.645 ↑ 1.0 3,151 31

Hash Left Join (cost=298.00..497.03 rows=3,151 width=4,105) (actual time=0.036..20.795 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = feat.feat_id)
223. 48.234 590.984 ↑ 1.0 3,151 31

Hash Left Join (cost=268.78..459.52 rows=3,151 width=4,089) (actual time=0.026..19.064 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = fac.fac_id)
224. 47.024 542.748 ↑ 1.0 3,151 31

Hash Left Join (cost=252.25..434.72 rows=3,151 width=3,897) (actual time=0.025..17.508 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = dry_dock.dry_dock_id)
225. 50.354 495.721 ↑ 1.0 3,151 31

Hash Left Join (cost=239.55..413.73 rows=3,151 width=3,303) (actual time=0.024..15.991 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = ctrl_feat.ctrl_feat_id)
226. 42.344 445.067 ↑ 1.0 3,151 31

Hash Left Join (cost=209.32..375.22 rows=3,151 width=3,286) (actual time=0.013..14.357 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = convoy.convoy_id)
227. 42.591 402.721 ↑ 1.0 3,151 31

Hash Left Join (cost=190.77..348.39 rows=3,151 width=3,156) (actual time=0.012..12.991 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = cloud_cover.cloud_cover_id)
228. 40.948 360.127 ↑ 1.0 3,151 31

Hash Left Join (cost=171.77..321.11 rows=3,151 width=3,034) (actual time=0.011..11.617 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = bridge.bridge_id)
229. 42.064 319.176 ↑ 1.0 3,151 31

Hash Left Join (cost=150.30..291.35 rows=3,151 width=2,958) (actual time=0.010..10.296 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = berth.berth_id)
230. 36.516 277.109 ↑ 1.0 3,151 31

Hash Left Join (cost=138.27..271.04 rows=3,151 width=2,218) (actual time=0.009..8.939 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = basin.basin_id)
231. 35.306 240.591 ↑ 1.0 3,151 31

Hash Left Join (cost=125.57..250.06 rows=3,151 width=1,652) (actual time=0.008..7.761 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = atmosphere.atmosphere_id)
232. 34.346 205.282 ↑ 1.0 3,151 31

Hash Left Join (cost=107.47..223.68 rows=3,151 width=1,508) (actual time=0.008..6.622 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = arsp_ctrl_means.arsp_ctrl_means_id)
233. 32.826 170.934 ↑ 1.0 3,151 31

Hash Left Join (cost=91.85..199.77 rows=3,151 width=1,270) (actual time=0.007..5.514 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = apron.apron_id)
234. 33.447 138.105 ↑ 1.0 3,151 31

Hash Left Join (cost=66.10..165.74 rows=3,151 width=1,236) (actual time=0.006..4.455 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = appr_dir.appr_dir_id)
235. 32.516 104.656 ↑ 1.0 3,151 31

Hash Left Join (cost=43.73..135.08 rows=3,151 width=1,172) (actual time=0.005..3.376 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = anchr.anchr_id)
236. 30.253 72.137 ↑ 1.0 3,151 31

Hash Left Join (cost=26.75..109.83 rows=3,151 width=994) (actual time=0.004..2.327 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = air_route_sgmnt.air_route_sgmnt_id)
237. 28.889 41.881 ↑ 1.0 3,151 31

Hash Left Join (cost=14.28..89.07 rows=3,151 width=360) (actual time=0.004..1.351 rows=3,151 loops=31)

  • Hash Cond: (obj_item.obj_item_id = airfield.airfield_id)
238. 12.989 12.989 ↑ 1.0 3,151 31

Seq Scan on obj_item (cost=0.00..66.51 rows=3,151 width=24) (actual time=0.002..0.419 rows=3,151 loops=31)

239. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=11.90..11.90 rows=190 width=336) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on airfield (cost=0.00..11.90 rows=190 width=336) (actual time=0.003..0.003 rows=0 loops=1)

241. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=11.10..11.10 rows=110 width=634) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on air_route_sgmnt (cost=0.00..11.10 rows=110 width=634) (actual time=0.002..0.002 rows=0 loops=1)

243. 0.001 0.003 ↓ 0.0 0 1

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

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

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

245. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=15.50..15.50 rows=550 width=64) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on appr_dir (cost=0.00..15.50 rows=550 width=64) (actual time=0.002..0.002 rows=0 loops=1)

247. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=17.00..17.00 rows=700 width=34) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on apron (cost=0.00..17.00 rows=700 width=34) (actual time=0.002..0.002 rows=0 loops=1)

249. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=12.50..12.50 rows=250 width=238) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on arsp_ctrl_means (cost=0.00..12.50 rows=250 width=238) (actual time=0.002..0.002 rows=0 loops=1)

251. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=13.60..13.60 rows=360 width=144) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on atmosphere (cost=0.00..13.60 rows=360 width=144) (actual time=0.002..0.002 rows=0 loops=1)

253. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=11.20..11.20 rows=120 width=566) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on basin (cost=0.00..11.20 rows=120 width=566) (actual time=0.002..0.002 rows=0 loops=1)

255. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=10.90..10.90 rows=90 width=740) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on berth (cost=0.00..10.90 rows=90 width=740) (actual time=0.002..0.002 rows=0 loops=1)

257. 0.001 0.003 ↓ 0.0 0 1

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

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

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

259. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=14.00..14.00 rows=400 width=122) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on cloud_cover (cost=0.00..14.00 rows=400 width=122) (actual time=0.002..0.002 rows=0 loops=1)

261. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.80..13.80 rows=380 width=130) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on convoy (cost=0.00..13.80 rows=380 width=130) (actual time=0.002..0.002 rows=0 loops=1)

263. 0.181 0.300 ↑ 1.0 899 1

Hash (cost=18.99..18.99 rows=899 width=17) (actual time=0.300..0.300 rows=899 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
264. 0.119 0.119 ↑ 1.0 899 1

Seq Scan on ctrl_feat (cost=0.00..18.99 rows=899 width=17) (actual time=0.005..0.119 rows=899 loops=1)

265. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=11.20..11.20 rows=120 width=594) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on dry_dock (cost=0.00..11.20 rows=120 width=594) (actual time=0.003..0.003 rows=0 loops=1)

267. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=12.90..12.90 rows=290 width=192) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on fac (cost=0.00..12.90 rows=290 width=192) (actual time=0.002..0.002 rows=0 loops=1)

269. 0.170 0.286 ↑ 1.0 899 1

Hash (cost=17.99..17.99 rows=899 width=16) (actual time=0.286..0.286 rows=899 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
270. 0.116 0.116 ↑ 1.0 899 1

Seq Scan on feat (cost=0.00..17.99 rows=899 width=16) (actual time=0.006..0.116 rows=899 loops=1)

271. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=12.80..12.80 rows=280 width=200) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on geo_feat (cost=0.00..12.80 rows=280 width=200) (actual time=0.002..0.002 rows=0 loops=1)

273. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=10.20..10.20 rows=20 width=2,748) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on hrbr (cost=0.00..10.20 rows=20 width=2,748) (actual time=0.002..0.002 rows=0 loops=1)

275. 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
276. 0.002 0.002 ↓ 0.0 0 1

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

277. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=13.60..13.60 rows=360 width=140) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on inst_lndg_sys (cost=0.00..13.60 rows=360 width=140) (actual time=0.002..0.002 rows=0 loops=1)

279. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=13.70..13.70 rows=370 width=136) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on jetty (cost=0.00..13.70 rows=370 width=136) (actual time=0.002..0.003 rows=0 loops=1)

281. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=12.60..12.60 rows=260 width=228) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on light (cost=0.00..12.60 rows=260 width=228) (actual time=0.002..0.002 rows=0 loops=1)

283. 0.363 0.603 ↑ 1.0 1,618 1

Hash (cost=35.18..35.18 rows=1,618 width=127) (actual time=0.603..0.603 rows=1,618 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 95kB
284. 0.240 0.240 ↑ 1.0 1,618 1

Seq Scan on mat (cost=0.00..35.18 rows=1,618 width=127) (actual time=0.005..0.240 rows=1,618 loops=1)

285. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=14.00..14.00 rows=400 width=118) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on met_feat (cost=0.00..14.00 rows=400 width=118) (actual time=0.002..0.002 rows=0 loops=1)

287. 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
288. 0.002 0.002 ↓ 0.0 0 1

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

289. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.00..13.00 rows=300 width=188) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on mnfld (cost=0.00..13.00 rows=300 width=188) (actual time=0.002..0.002 rows=0 loops=1)

291. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.30..13.30 rows=330 width=160) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on mnfld_land (cost=0.00..13.30 rows=330 width=160) (actual time=0.002..0.002 rows=0 loops=1)

293. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=12.00..12.00 rows=200 width=326) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on mnfld_mrt (cost=0.00..12.00 rows=200 width=326) (actual time=0.002..0.002 rows=0 loops=1)

295. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.00..13.00 rows=300 width=188) (actual time=0.002..0.002 rows=0 loops=1)

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

Seq Scan on netwrk (cost=0.00..13.00 rows=300 width=188) (actual time=0.002..0.002 rows=0 loops=1)

297. 0.120 0.203 ↑ 1.0 634 1

Hash (cost=12.34..12.34 rows=634 width=16) (actual time=0.203..0.203 rows=634 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
298. 0.083 0.083 ↑ 1.0 634 1

Seq Scan on org (cost=0.00..12.34 rows=634 width=16) (actual time=0.006..0.083 rows=634 loops=1)

299. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=13.10..13.10 rows=310 width=180) (actual time=0.002..0.002 rows=0 loops=1)

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

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

301. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=15.70..15.70 rows=570 width=60) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on precipitation (cost=0.00..15.70 rows=570 width=60) (actual time=0.002..0.002 rows=0 loops=1)

303. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=12.30..12.30 rows=230 width=264) (actual time=0.002..0.003 rows=0 loops=1)

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

Seq Scan on quay (cost=0.00..12.30 rows=230 width=264) (actual time=0.002..0.002 rows=0 loops=1)

305. 0.001 0.003 ↓ 0.0 0 1

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

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

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

307. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=13.60..13.60 rows=360 width=144) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on road (cost=0.00..13.60 rows=360 width=144) (actual time=0.002..0.002 rows=0 loops=1)

309. 0.001 0.003 ↓ 0.0 0 1

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

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

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

311. 0.000 0.003 ↓ 0.0 0 1

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

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

Seq Scan on route_sgmnt (cost=0.00..14.30 rows=430 width=104) (actual time=0.003..0.003 rows=0 loops=1)

313. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=13.00..13.00 rows=300 width=188) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on runway (cost=0.00..13.00 rows=300 width=188) (actual time=0.002..0.002 rows=0 loops=1)

315. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=11.20..11.20 rows=120 width=550) (actual time=0.003..0.003 rows=0 loops=1)

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

Seq Scan on slpway (cost=0.00..11.20 rows=120 width=550) (actual time=0.003..0.003 rows=0 loops=1)

317. 0.122 0.201 ↑ 1.0 575 1

Hash (cost=11.75..11.75 rows=575 width=23) (actual time=0.201..0.201 rows=575 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
318. 0.079 0.079 ↑ 1.0 575 1

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

319. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.60..14.60 rows=460 width=92) (actual time=0.002..0.002 rows=0 loops=1)

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

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

321. 0.001 0.003 ↓ 0.0 0 1

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

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

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

323. 0.155 0.155 ↑ 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=55) (actual time=0.005..0.005 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))
324. 0.052 0.868 ↓ 0.0 0 31

Nested Loop Left Join (cost=2.45..8.30 rows=1 width=2,130) (actual time=0.028..0.028 rows=0 loops=31)

325. 0.052 0.806 ↓ 0.0 0 31

Nested Loop Left Join (cost=2.30..8.04 rows=1 width=2,520) (actual time=0.025..0.026 rows=0 loops=31)

326. 0.052 0.744 ↓ 0.0 0 31

Nested Loop Left Join (cost=2.15..7.78 rows=1 width=2,312) (actual time=0.023..0.024 rows=0 loops=31)

327. 0.032 0.682 ↓ 0.0 0 31

Nested Loop Left Join (cost=2.00..7.52 rows=1 width=2,146) (actual time=0.022..0.022 rows=0 loops=31)

328. 0.052 0.620 ↓ 0.0 0 31

Nested Loop Left Join (cost=1.73..7.15 rows=1 width=1,842) (actual time=0.019..0.020 rows=0 loops=31)

329. 0.052 0.558 ↓ 0.0 0 31

Nested Loop Left Join (cost=1.59..6.89 rows=1 width=1,562) (actual time=0.018..0.018 rows=0 loops=31)

330. 0.021 0.496 ↓ 0.0 0 31

Nested Loop Left Join (cost=1.44..6.63 rows=1 width=1,424) (actual time=0.016..0.016 rows=0 loops=31)

331. 0.073 0.465 ↓ 0.0 0 31

Nested Loop Left Join (cost=1.29..6.37 rows=1 width=1,364) (actual time=0.014..0.015 rows=0 loops=31)

332. 0.021 0.372 ↓ 0.0 0 31

Nested Loop Left Join (cost=1.15..6.18 rows=1 width=1,043) (actual time=0.012..0.012 rows=0 loops=31)

333. 0.052 0.341 ↓ 0.0 0 31

Nested Loop Left Join (cost=1.00..5.92 rows=1 width=919) (actual time=0.011..0.011 rows=0 loops=31)

334. 0.021 0.279 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.85..5.66 rows=1 width=831) (actual time=0.009..0.009 rows=0 loops=31)

335. 0.052 0.248 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.71..5.40 rows=1 width=707) (actual time=0.007..0.008 rows=0 loops=31)

336. 0.042 0.186 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.56..5.14 rows=1 width=387) (actual time=0.006..0.006 rows=0 loops=31)

337. 0.042 0.124 ↓ 0.0 0 31

Nested Loop Left Join (cost=0.42..4.95 rows=1 width=270) (actual time=0.004..0.004 rows=0 loops=31)

338. 0.062 0.062 ↓ 0.0 0 31

Index Scan using obj_item_stat_pkey on obj_item_stat (cost=0.27..4.69 rows=1 width=98) (actual time=0.002..0.002 rows=0 loops=31)

  • Index Cond: ((contxt_coia.obj_item_id = obj_item_id) AND (contxt_oistat.obj_item_stat_ix = obj_item_stat_ix))
339. 0.020 0.020 ↓ 0.0 0 10

Index Scan using airfield_stat_pkey on airfield_stat (cost=0.15..0.26 rows=1 width=172) (actual time=0.002..0.002 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = airfield_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
340. 0.020 0.020 ↓ 0.0 0 10

Index Scan using cfeat_stat_pkey on cfeat_stat (cost=0.14..0.19 rows=1 width=117) (actual time=0.002..0.002 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = cfeat_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
341. 0.010 0.010 ↓ 0.0 0 10

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

  • Index Cond: ((obj_item_stat.obj_item_id = fac_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
342. 0.010 0.010 ↓ 0.0 0 10

Index Scan using gfeat_stat_pkey on gfeat_stat (cost=0.15..0.26 rows=1 width=124) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = gfeat_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
343. 0.010 0.010 ↓ 0.0 0 10

Index Scan using lqd_body_stat_pkey on lqd_body_stat (cost=0.15..0.26 rows=1 width=88) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = lqd_body_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
344. 0.010 0.010 ↓ 0.0 0 10

Index Scan using lqd_surf_stat_pkey on lqd_surf_stat (cost=0.15..0.26 rows=1 width=124) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = lqd_surf_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
345. 0.020 0.020 ↑ 1.0 1 10

Index Scan using mat_stat_pkey on mat_stat (cost=0.14..0.19 rows=1 width=321) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = mat_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
346. 0.010 0.010 ↓ 0.0 0 10

Index Scan using mfs_pkey on mfs (cost=0.15..0.26 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = mfs_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
347. 0.010 0.010 ↓ 0.0 0 10

Index Scan using mine_stat_pkey on mine_stat (cost=0.15..0.26 rows=1 width=138) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = mine_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
348. 0.010 0.010 ↓ 0.0 0 10

Index Scan using mnfld_mrt_stat_pkey on mnfld_mrt_stat (cost=0.14..0.26 rows=1 width=280) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = mnfld_mrt_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
349. 0.030 0.030 ↓ 0.0 0 10

Index Scan using org_stat_pkey on org_stat (cost=0.27..0.38 rows=1 width=304) (actual time=0.003..0.003 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = org_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
350. 0.010 0.010 ↓ 0.0 0 10

Index Scan using pers_stat_pkey on pers_stat (cost=0.15..0.26 rows=1 width=166) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = pers_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
351. 0.010 0.010 ↓ 0.0 0 10

Index Scan using sld_surf_stat_pkey on sld_surf_stat (cost=0.15..0.26 rows=1 width=208) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = sld_surf_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
352. 0.010 0.010 ↓ 0.0 0 10

Index Scan using uxo_stat_pkey on uxo_stat (cost=0.15..0.26 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: ((obj_item_stat.obj_item_id = uxo_stat_id) AND (obj_item_stat.obj_item_stat_ix = obj_item_stat_ix))
353. 0.144 2.294 ↑ 1.0 1 31

Nested Loop (cost=0.83..846.41 rows=1 width=257) (actual time=0.055..0.074 rows=1 loops=31)

354. 0.620 0.620 ↑ 50.0 2 31

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

355. 1.530 1.530 ↑ 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=217) (actual time=0.030..0.030 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 : 160.829 ms
Execution time : 2,895.307 ms