explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXI9

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 28.249 ↓ 33.0 33 1

Nested Loop Left Join (cost=712.51..874.84 rows=1 width=2,283) (actual time=1.997..28.249 rows=33 loops=1)

2. 0.052 28.160 ↓ 33.0 33 1

Nested Loop Left Join (cost=712.24..874.51 rows=1 width=2,883) (actual time=1.977..28.160 rows=33 loops=1)

3. 0.040 28.108 ↓ 33.0 33 1

Nested Loop Left Join (cost=712.09..874.32 rows=1 width=2,663) (actual time=1.967..28.108 rows=33 loops=1)

4. 0.054 28.035 ↓ 33.0 33 1

Nested Loop Left Join (cost=711.94..874.14 rows=1 width=2,644) (actual time=1.956..28.035 rows=33 loops=1)

5. 0.308 27.948 ↓ 33.0 33 1

Hash Join (cost=711.80..873.96 rows=1 width=2,552) (actual time=1.943..27.948 rows=33 loops=1)

  • Hash Cond: (obj_type.obj_type_id = contxt_oitype.obj_type_id)
6. 0.924 27.578 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = task_frmtn_type.task_frmtn_type_id)
7. 0.916 26.652 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = surf_vessel_type.surf_vessel_type_id)
8. 0.882 25.734 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = subsurf_vessel_type.subsurf_vessel_type_id)
9. 0.857 24.849 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = route_type.route_type_id)
10. 0.851 23.989 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = railcar_type.railcar_type_id)
11. 0.844 23.136 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = radact_mat_type.radact_mat_type_id)
12. 0.821 22.289 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = prv_sctr_org_type.prv_sctr_org_type_id)
13. 0.823 21.465 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = pers_type.pers_type_id)
14. 0.845 20.639 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = org_type.org_type_id)
15. 0.787 19.732 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = mrt_eqpt_type.mrt_eqpt_type_id)
16. 0.823 18.942 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = misc_eqpt_type.misc_eqpt_type_id)
17. 0.770 18.092 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = mil_post_type.mil_post_type_id)
18. 0.809 17.313 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = mil_org_type.mil_org_type_id)
19. 0.801 16.446 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = mil_obs_type.mil_obs_type_id)
20. 1.075 15.642 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = mat_type.mat_type_id)
21. 0.717 14.069 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = hrbr_type.hrbr_type_id)
22. 0.769 13.350 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = group_org_type.group_org_type_id)
23. 0.796 12.579 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = govt_org_type.govt_org_type_id)
24. 0.762 11.727 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = geo_feat_type.geo_feat_type_id)
25. 0.714 10.963 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = feat_type.feat_type_id)
26. 0.731 10.203 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = fac_type.fac_type_id)
27. 0.657 9.470 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = exctv_mil_org_type.exctv_mil_org_type_id)
28. 0.948 8.810 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = eqpt_type.eqpt_type_id)
29. 0.650 7.329 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = eng_eqpt_type.eng_eqpt_type_id)
30. 0.644 6.621 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = elctrnc_eqpt_type.elctrnc_eqpt_type_id)
31. 0.650 5.956 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = ctrl_feat_type.ctrl_feat_type_id)
32. 0.603 5.248 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = cons_mat_type.cons_mat_type_id)
33. 0.535 4.643 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = civ_post_type.civ_post_type_id)
34. 0.538 4.106 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = chm_mat_type.chm_mat_type_id)
35. 0.563 3.566 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = cbrn_eqpt_type.cbrn_eqpt_type_id)
36. 0.576 3.000 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = bridge_type.bridge_type_id)
37. 0.503 2.422 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = bio_mat_type.bio_mat_type_id)
38. 0.453 1.917 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = ammo_type.ammo_type_id)
39. 0.475 1.462 ↑ 1.0 1,380 1

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

  • Hash Cond: (obj_type.obj_type_id = airfield_type.airfield_type_id)
40. 0.621 0.984 ↑ 1.0 1,380 1

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

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

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

42. 0.079 0.135 ↑ 1.0 231 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
43. 0.056 0.056 ↑ 1.0 231 1

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

44. 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
45. 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)

46. 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
47. 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)

48. 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
49. 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)

50. 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
51. 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)

52. 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
53. 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)

54. 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
55. 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)

56. 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
57. 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)

58. 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
59. 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)

60. 0.037 0.058 ↑ 1.0 109 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
61. 0.021 0.021 ↑ 1.0 109 1

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

62. 0.014 0.021 ↑ 1.0 24 1

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

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

64. 0.034 0.058 ↑ 1.0 132 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
65. 0.024 0.024 ↑ 1.0 132 1

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

66. 0.326 0.533 ↑ 1.0 1,140 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 77kB
67. 0.207 0.207 ↑ 1.0 1,140 1

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

68. 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
69. 0.003 0.003 ↓ 0.0 0 1

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

70. 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
71. 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)

72. 0.026 0.046 ↑ 1.0 109 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
73. 0.020 0.020 ↑ 1.0 109 1

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

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

76. 0.033 0.056 ↑ 1.0 131 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
77. 0.023 0.023 ↑ 1.0 131 1

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

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

80. 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
81. 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)

82. 0.296 0.498 ↑ 1.0 1,140 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
83. 0.202 0.202 ↑ 1.0 1,140 1

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

84. 0.000 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
85. 0.003 0.003 ↓ 0.0 0 1

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

86. 0.034 0.058 ↑ 1.0 131 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
87. 0.024 0.024 ↑ 1.0 131 1

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

88. 0.005 0.009 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
89. 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.004..0.004 rows=1 loops=1)

90. 0.016 0.027 ↑ 1.0 55 1

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

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

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

92. 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
93. 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)

94. 0.037 0.062 ↑ 1.0 131 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
95. 0.025 0.025 ↑ 1.0 131 1

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

96. 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
97. 0.003 0.003 ↓ 0.0 0 1

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

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

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

102. 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
103. 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)

104. 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
105. 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)

106. 0.001 0.003 ↓ 0.0 0 1

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

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

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

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

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

112. 0.008 0.062 ↓ 33.0 33 1

Hash (cost=92.10..92.10 rows=1 width=55) (actual time=0.062..0.062 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
113. 0.018 0.054 ↓ 33.0 33 1

Hash Join (cost=47.50..92.10 rows=1 width=55) (actual time=0.039..0.054 rows=33 loops=1)

  • Hash Cond: (contxt_oitype.obj_item_id = contxt_coia.obj_item_id)
114. 0.007 0.017 ↑ 1.0 33 1

Bitmap Heap Scan on contxt_oitype (cost=4.54..49.05 rows=33 width=47) (actual time=0.015..0.017 rows=33 loops=1)

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

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

  • Index Cond: (contxt_id = '10321812000000601400'::numeric)
116. 0.008 0.019 ↑ 1.0 33 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
117. 0.005 0.011 ↑ 1.0 33 1

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

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

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

  • Index Cond: (contxt_id = '10321812000000601400'::numeric)
119. 0.033 0.033 ↑ 1.0 1 33

Index Scan using unit_type_pkey on unit_type (cost=0.14..0.17 rows=1 width=92) (actual time=0.001..0.001 rows=1 loops=33)

  • Index Cond: (obj_type.obj_type_id = unit_type_id)
120. 0.033 0.033 ↓ 0.0 0 33

Index Scan using vehicle_type_pkey on vehicle_type (cost=0.15..0.18 rows=1 width=19) (actual time=0.001..0.001 rows=0 loops=33)

  • Index Cond: (obj_type.obj_type_id = vehicle_type_id)
121. 0.000 0.000 ↓ 0.0 0 33

Index Scan using vessel_type_pkey on vessel_type (cost=0.15..0.20 rows=1 width=220) (actual time=0.000..0.000 rows=0 loops=33)

  • Index Cond: (obj_type.obj_type_id = vessel_type_id)
122. 0.033 0.033 ↓ 0.0 0 33

Index Scan using weapon_type_pkey on weapon_type (cost=0.27..0.32 rows=1 width=56) (actual time=0.001..0.001 rows=0 loops=33)

  • Index Cond: (obj_type.obj_type_id = weapon_type_id)
Planning time : 19.452 ms
Execution time : 29.678 ms