explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HGDg

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 17,585.552 ↑ 1.0 1 1

Aggregate (cost=796,830.82..796,830.83 rows=1 width=8) (actual time=17,585.552..17,585.552 rows=1 loops=1)

2. 0.087 17,585.521 ↓ 1.7 341 1

Unique (cost=796,728.70..796,828.32 rows=200 width=326) (actual time=17,584.654..17,585.521 rows=341 loops=1)

3. 0.143 17,585.434 ↓ 1.7 341 1

Nested Loop Left Join (cost=796,728.70..796,827.82 rows=200 width=326) (actual time=17,584.652..17,585.434 rows=341 loops=1)

  • Join Filter: ((((sh.contractor_id)::text = (mi.contractor_id)::text) OR ((sh.contractor_id IS NULL) AND (mi.contractor_id IS NULL))) AND ((sh.machine_key)::text = (mi.machine_key)::text))
4. 0.264 17,578.812 ↓ 1.7 341 1

Nested Loop Left Join (cost=794,970.78..795,052.32 rows=200 width=31) (actual time=17,578.214..17,578.812 rows=341 loops=1)

  • Join Filter: (((sh.machine_key)::text = (s.machine_key)::text) AND (sh.species_group_key = s.species_group_key))
  • Rows Removed by Join Filter: 1023
5. 0.078 17,578.207 ↓ 1.7 341 1

Unique (cost=794,952.08..794,964.73 rows=200 width=183) (actual time=17,577.903..17,578.207 rows=341 loops=1)

6. 0.102 17,578.129 ↑ 2.1 341 1

Subquery Scan on sh (cost=794,952.08..794,962.92 rows=723 width=183) (actual time=17,577.901..17,578.129 rows=341 loops=1)

7. 0.077 17,578.027 ↑ 2.1 341 1

Unique (cost=794,952.08..794,955.69 rows=723 width=183) (actual time=17,577.897..17,578.027 rows=341 loops=1)

8. 0.446 17,577.950 ↑ 2.1 341 1

Sort (cost=794,952.08..794,953.88 rows=723 width=183) (actual time=17,577.894..17,577.950 rows=341 loops=1)

  • Sort Key: st.stem_key, mdt.value_item DESC NULLS LAST
  • Sort Method: quicksort Memory: 72kB
9. 0.182 17,577.504 ↑ 2.1 341 1

Nested Loop Left Join (cost=758,618.78..794,917.74 rows=723 width=183) (actual time=17,050.577..17,577.504 rows=341 loops=1)

10. 0.452 17,576.299 ↑ 2.1 341 1

Nested Loop (cost=758,618.35..794,580.62 rows=715 width=55) (actual time=17,050.553..17,576.299 rows=341 loops=1)

11. 0.473 17,575.165 ↑ 2.1 341 1

Nested Loop (cost=758,617.93..794,253.47 rows=715 width=35) (actual time=17,050.520..17,575.165 rows=341 loops=1)

12. 117.900 17,572.987 ↑ 2.1 341 1

Hash Join (cost=758,617.50..793,930.16 rows=715 width=43) (actual time=17,050.444..17,572.987 rows=341 loops=1)

  • Hash Cond: (lhpt.log_single_tree_processed_st_0 = shp.single_tree_processed_stem_s_0)
13. 2,353.203 17,453.595 ↓ 1.4 2,019,539 1

HashAggregate (cost=758,386.89..773,252.37 rows=1,486,548 width=28) (actual time=17,047.584..17,453.595 rows=2,019,539 loops=1)

  • Group Key: lhpt.log_single_tree_processed_st_0
14. 3,261.724 15,100.392 ↓ 1.1 5,257,400 1

Hash Join (cost=487,275.47..746,838.38 rows=4,619,404 width=4) (actual time=4,803.656..15,100.392 rows=5,257,400 loops=1)

  • Hash Cond: (lhpt.log_measurement_log_harveste_0 = lmt.hjid)
15. 3,139.585 10,359.420 ↓ 1.1 5,257,400 1

Hash Join (cost=347,130.58..566,286.04 rows=4,619,404 width=8) (actual time=3,314.682..10,359.420 rows=5,257,400 loops=1)

  • Hash Cond: (lt.hjid = lhpt.hjid)
16. 2,805.052 5,570.947 ↓ 1.0 5,257,400 1

Hash Join (cost=211,868.04..386,133.99 rows=5,091,236 width=8) (actual time=1,659.298..5,570.947 rows=5,257,400 loops=1)

  • Hash Cond: (log_volume_type.log_volume_log_type_hjid = lt.hjid)
17. 1,162.979 1,394.918 ↓ 1.0 5,257,400 1

Bitmap Heap Scan on log_volume_type (cost=69,194.64..199,947.59 rows=5,091,236 width=4) (actual time=249.813..1,394.918 rows=5,257,400 loops=1)

  • Recheck Cond: ((log_volume_category)::text = 'M_3_SUB'::text)
  • Heap Blocks: exact=123090
18. 231.939 231.939 ↓ 1.1 5,495,903 1

Bitmap Index Scan on log_volume_type_log_volume_category_idx (cost=0.00..67,921.83 rows=5,091,236 width=0) (actual time=231.939..231.939 rows=5,495,903 loops=1)

  • Index Cond: ((log_volume_category)::text = 'M_3_SUB'::text)
19. 854.394 1,370.977 ↓ 1.0 5,257,400 1

Hash (cost=66,748.51..66,748.51 rows=5,253,151 width=4) (actual time=1,370.977..1,370.977 rows=5,257,400 loops=1)

  • Buckets: 8388608 Batches: 2 Memory Usage: 157880kB
20. 516.583 516.583 ↓ 1.0 5,257,400 1

Seq Scan on log_type lt (cost=0.00..66,748.51 rows=5,253,151 width=4) (actual time=0.038..516.583 rows=5,257,400 loops=1)

21. 1,009.556 1,648.888 ↓ 1.1 5,257,400 1

Hash (cost=64,046.63..64,046.63 rows=4,766,313 width=12) (actual time=1,648.888..1,648.888 rows=5,257,400 loops=1)

  • Buckets: 4194304 Batches: 2 Memory Usage: 145777kB
22. 639.332 639.332 ↓ 1.1 5,257,400 1

Seq Scan on log_harvested_production_type lhpt (cost=0.00..64,046.63 rows=4,766,313 width=12) (actual time=0.020..639.332 rows=5,257,400 loops=1)

23. 959.479 1,479.248 ↓ 1.0 5,257,400 1

Hash (cost=64,397.62..64,397.62 rows=5,240,862 width=4) (actual time=1,479.248..1,479.248 rows=5,257,400 loops=1)

  • Buckets: 8388608 Batches: 2 Memory Usage: 157896kB
24. 519.769 519.769 ↓ 1.0 5,257,400 1

Seq Scan on log_measurement_type lmt (cost=0.00..64,397.62 rows=5,240,862 width=4) (actual time=0.022..519.769 rows=5,257,400 loops=1)

25. 0.044 1.492 ↑ 2.9 341 1

Hash (cost=218.22..218.22 rows=991 width=39) (actual time=1.492..1.492 rows=341 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
26. 0.044 1.448 ↑ 2.9 341 1

Nested Loop (cost=6.16..218.22 rows=991 width=39) (actual time=0.200..1.448 rows=341 loops=1)

  • Join Filter: (mt.hjid = shp.stem_machine_harvested_produ_0)
27. 0.001 1.347 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.74..176.61 rows=1 width=39) (actual time=0.191..1.347 rows=1 loops=1)

28. 0.001 1.340 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.45..174.30 rows=1 width=42) (actual time=0.184..1.340 rows=1 loops=1)

29. 0.000 1.334 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.17..173.97 rows=1 width=38) (actual time=0.179..1.334 rows=1 loops=1)

30. 0.001 1.329 ↑ 1.0 1 1

Nested Loop (cost=4.89..173.65 rows=1 width=38) (actual time=0.173..1.329 rows=1 loops=1)

31. 0.228 1.322 ↑ 1.0 1 1

Hash Join (cost=4.61..173.35 rows=1 width=42) (actual time=0.167..1.322 rows=1 loops=1)

  • Hash Cond: (xfl.hjid = mhp.machine_harvested_production_0)
32. 1.056 1.056 ↓ 1.0 4,693 1

Seq Scan on xml_file_list xfl (cost=0.00..151.34 rows=4,639 width=4) (actual time=0.020..1.056 rows=4,693 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hpr.harvested_production_type'::text)
  • Rows Removed by Filter: 334
33. 0.003 0.038 ↑ 1.0 1 1

Hash (cost=4.59..4.59 rows=1 width=38) (actual time=0.038..0.038 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.003 0.035 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.59 rows=1 width=38) (actual time=0.034..0.035 rows=1 loops=1)

35. 0.025 0.025 ↑ 1.0 1 1

Index Scan using machine_type_machine_key_idx on machine_type mt (cost=0.28..2.30 rows=1 width=30) (actual time=0.024..0.025 rows=1 loops=1)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00077'::text)
36. 0.007 0.007 ↑ 1.0 1 1

Index Scan using machine_harvested_production_1_pkey on machine_harvested_production_1 mhp (cost=0.28..2.29 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (hjid = mt.hjid)
37. 0.006 0.006 ↑ 1.0 1 1

Index Scan using harvested_production_type_pkey on harvested_production_type hpt (cost=0.28..0.30 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (hjid = xfl.hjid)
38. 0.005 0.005 ↑ 1.0 1 1

Index Scan using message_header_type_pkey on message_header_type mht (cost=0.28..0.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (hpt.harvested_production_header__0 = hjid)
39. 0.005 0.005 ↑ 1.0 1 1

Index Scan using modification_date_type_pkey on modification_date_type mdt (cost=0.29..0.34 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (mht.modification_date_message_he_0 = hjid)
40. 0.006 0.006 ↑ 1.0 1 1

Index Scan using contact_information_type_pkey on contact_information_type cit (cost=0.29..2.30 rows=1 width=5) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (hjid = mt.logging_contractor_machine_t_0)
41. 0.057 0.057 ↑ 3.2 341 1

Index Scan using stem_harvested_production_ty_0_stem_machine_harvested_produ_0_i on stem_harvested_production_ty_0 shp (cost=0.43..27.88 rows=1,099 width=12) (actual time=0.008..0.057 rows=341 loops=1)

  • Index Cond: (stem_machine_harvested_produ_0 = mhp.hjid)
42. 1.705 1.705 ↑ 1.0 1 341

Index Only Scan using single_tree_processed_stem_t_0_pkey on single_tree_processed_stem_t_0 stps (cost=0.43..0.45 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=341)

  • Index Cond: (hjid = shp.single_tree_processed_stem_s_0)
  • Heap Fetches: 341
43. 0.682 0.682 ↑ 1.0 1 341

Index Scan using stem_type_pkey on stem_type st (cost=0.43..0.46 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=341)

  • Index Cond: (hjid = shp.hjid)
44. 1.023 1.023 ↑ 1.0 1 341

Index Scan using coordinates_type_stem_coordinates_stem_type_h_0_idx on coordinates_type ct (cost=0.43..0.46 rows=1 width=12) (actual time=0.002..0.003 rows=1 loops=341)

  • Index Cond: (st.hjid = stem_coordinates_stem_type_h_0)
45. 0.054 0.341 ↑ 4.8 4 341

Materialize (cost=18.71..19.13 rows=19 width=38) (actual time=0.001..0.001 rows=4 loops=341)

46. 0.001 0.287 ↑ 4.8 4 1

Subquery Scan on s (cost=18.71..19.04 rows=19 width=38) (actual time=0.285..0.287 rows=4 loops=1)

47. 0.003 0.286 ↑ 4.8 4 1

Unique (cost=18.71..18.85 rows=19 width=188) (actual time=0.284..0.286 rows=4 loops=1)

48. 0.044 0.283 ↑ 4.8 4 1

Sort (cost=18.71..18.75 rows=19 width=188) (actual time=0.283..0.283 rows=4 loops=1)

  • Sort Key: "*SELECT* 1".contractor_id, "*SELECT* 1".species_group_key, "*SELECT* 1".doc_modification_time DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
49. 0.003 0.239 ↑ 4.8 4 1

Result (cost=2.25..18.30 rows=19 width=188) (actual time=0.204..0.239 rows=4 loops=1)

50. 0.003 0.236 ↑ 4.8 4 1

Append (cost=2.25..18.11 rows=19 width=60) (actual time=0.202..0.236 rows=4 loops=1)

51. 0.002 0.208 ↑ 1.0 4 1

Subquery Scan on *SELECT* 1 (cost=2.25..9.55 rows=4 width=35) (actual time=0.200..0.208 rows=4 loops=1)

52. 0.009 0.206 ↑ 1.0 4 1

Nested Loop (cost=2.25..9.51 rows=4 width=163) (actual time=0.198..0.206 rows=4 loops=1)

53. 0.006 0.177 ↑ 1.0 4 1

Nested Loop (cost=1.97..8.27 rows=4 width=39) (actual time=0.175..0.177 rows=4 loops=1)

54. 0.006 0.159 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..7.86 rows=1 width=39) (actual time=0.158..0.159 rows=1 loops=1)

55. 0.006 0.130 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.40..5.55 rows=1 width=42) (actual time=0.130..0.130 rows=1 loops=1)

56. 0.006 0.114 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..5.22 rows=1 width=38) (actual time=0.114..0.114 rows=1 loops=1)

57. 0.006 0.099 ↑ 1.0 1 1

Nested Loop (cost=0.84..4.90 rows=1 width=38) (actual time=0.098..0.099 rows=1 loops=1)

58. 0.019 0.066 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.59 rows=1 width=38) (actual time=0.066..0.066 rows=1 loops=1)

59. 0.034 0.034 ↑ 1.0 1 1

Index Scan using machine_type_machine_key_idx on machine_type mt_1 (cost=0.28..2.30 rows=1 width=30) (actual time=0.034..0.034 rows=1 loops=1)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00077'::text)
60. 0.013 0.013 ↑ 1.0 1 1

Index Scan using machine_harvested_production_1_pkey on machine_harvested_production_1 mhp_1 (cost=0.28..2.29 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (hjid = mt_1.hjid)
61. 0.027 0.027 ↑ 1.0 1 1

Index Scan using harvested_production_type_pkey on harvested_production_type hpt_1 (cost=0.28..0.31 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Index Cond: (hjid = mhp_1.machine_harvested_production_0)
62. 0.009 0.009 ↑ 1.0 1 1

Index Scan using message_header_type_pkey on message_header_type mht_1 (cost=0.28..0.31 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (hpt_1.harvested_production_header__0 = hjid)
63. 0.010 0.010 ↑ 1.0 1 1

Index Scan using modification_date_type_pkey on modification_date_type mdt_1 (cost=0.29..0.34 rows=1 width=12) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (mht_1.modification_date_message_he_0 = hjid)
64. 0.023 0.023 ↑ 1.0 1 1

Index Scan using contact_information_type_pkey on contact_information_type cit_1 (cost=0.29..2.30 rows=1 width=5) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (mt_1.logging_contractor_machine_t_0 = hjid)
65. 0.012 0.012 ↓ 1.3 4 1

Index Scan using species_group_definition_mac_0_species_group_definition_mac_1_i on species_group_definition_mac_0 sgdm (cost=0.28..0.39 rows=3 width=12) (actual time=0.011..0.012 rows=4 loops=1)

  • Index Cond: (species_group_definition_mac_1 = mhp_1.hjid)
66. 0.020 0.020 ↑ 1.0 1 4

Index Only Scan using species_group_definition_type_pkey on species_group_definition_type sgdt (cost=0.28..0.31 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: (hjid = sgdm.hjid)
  • Heap Fetches: 4
67. 0.001 0.025 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.74..8.56 rows=15 width=67) (actual time=0.025..0.025 rows=0 loops=1)

68. 0.002 0.024 ↓ 0.0 0 1

Nested Loop (cost=0.74..8.41 rows=15 width=195) (actual time=0.024..0.024 rows=0 loops=1)

69. 0.001 0.022 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.59..6.21 rows=1 width=67) (actual time=0.022..0.022 rows=0 loops=1)

70. 0.001 0.021 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.44..4.02 rows=1 width=53) (actual time=0.021..0.021 rows=0 loops=1)

71. 0.001 0.020 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.30..3.85 rows=1 width=49) (actual time=0.020..0.020 rows=0 loops=1)

72. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.67 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=1)

73. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on machine_forwarded_production_1 mhp_2 (cost=0.00..1.50 rows=1 width=49) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 40
74. 0.000 0.000 ↓ 0.0 0

Index Scan using forwarded_production_type_pkey on forwarded_production_type hpt_2 (cost=0.15..2.17 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mhp_2.machine_forwarded_production_0)
75. 0.000 0.000 ↓ 0.0 0

Index Scan using message_header_type_pkey on message_header_type mht_2 (cost=0.15..0.18 rows=1 width=8) (never executed)

  • Index Cond: (hpt_2.forwarded_production_header__0 = hjid)
76. 0.000 0.000 ↓ 0.0 0

Index Scan using modification_date_type_pkey on modification_date_type mdt_2 (cost=0.14..0.17 rows=1 width=12) (never executed)

  • Index Cond: (mht_2.modification_date_message_he_0 = hjid)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type cit_2 (cost=0.14..2.16 rows=1 width=22) (never executed)

  • Index Cond: (mhp_2.logging_contractor_machine_f_0 = hjid)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using species_group_definition_mac_2_species_group_definition_mac_1_i on species_group_definition_mac_2 sgdm_1 (cost=0.15..2.18 rows=2 width=8) (never executed)

  • Index Cond: (species_group_definition_mac_1 = mhp_2.hjid)
79. 0.050 6.479 ↑ 5.0 1 341

Materialize (cost=1,757.91..1,758.01 rows=5 width=43) (actual time=0.019..0.019 rows=1 loops=341)

80. 0.004 6.429 ↑ 5.0 1 1

Subquery Scan on mi (cost=1,757.91..1,757.99 rows=5 width=43) (actual time=6.428..6.429 rows=1 loops=1)

81. 0.001 6.425 ↑ 5.0 1 1

Unique (cost=1,757.91..1,757.94 rows=5 width=299) (actual time=6.425..6.425 rows=1 loops=1)

82. 0.012 6.424 ↑ 5.0 1 1

Sort (cost=1,757.91..1,757.93 rows=5 width=299) (actual time=6.424..6.424 rows=1 loops=1)

  • Sort Key: "*SELECT* 1_1".contractor_id, "*SELECT* 1_1".doc_mod_date DESC
  • Sort Method: quicksort Memory: 25kB
83. 0.018 6.412 ↑ 5.0 1 1

Nested Loop (cost=883.08..1,757.86 rows=5 width=299) (actual time=3.558..6.412 rows=1 loops=1)

  • Join Filter: ((("*SELECT* 1_1".contractor_id)::text = (a.contractor_id)::text) OR ((a.contractor_id IS NULL) AND ("*SELECT* 1_1".contractor_id IS NULL)))
84. 0.005 3.103 ↑ 5.0 1 1

Append (cost=7.87..882.12 rows=5 width=51) (actual time=0.262..3.103 rows=1 loops=1)

85. 0.002 1.334 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1_1 (cost=7.87..176.62 rows=1 width=31) (actual time=0.261..1.334 rows=1 loops=1)

86. 0.270 1.332 ↑ 1.0 1 1

Hash Join (cost=7.87..176.61 rows=1 width=400) (actual time=0.260..1.332 rows=1 loops=1)

  • Hash Cond: (xfl_1.hjid = hpt_3.hjid)
87. 0.971 0.971 ↓ 1.0 4,693 1

Seq Scan on xml_file_list xfl_1 (cost=0.00..151.34 rows=4,639 width=4) (actual time=0.026..0.971 rows=4,693 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hpr.harvested_production_type'::text)
  • Rows Removed by Filter: 334
88. 0.011 0.091 ↑ 1.0 1 1

Hash (cost=7.86..7.86 rows=1 width=39) (actual time=0.091..0.091 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
89. 0.003 0.080 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..7.86 rows=1 width=39) (actual time=0.079..0.080 rows=1 loops=1)

90. 0.005 0.072 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.40..5.55 rows=1 width=42) (actual time=0.071..0.072 rows=1 loops=1)

91. 0.005 0.062 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..5.22 rows=1 width=38) (actual time=0.061..0.062 rows=1 loops=1)

92. 0.005 0.052 ↑ 1.0 1 1

Nested Loop (cost=0.84..4.90 rows=1 width=38) (actual time=0.051..0.052 rows=1 loops=1)

93. 0.007 0.042 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.59 rows=1 width=30) (actual time=0.041..0.042 rows=1 loops=1)

94. 0.016 0.016 ↑ 1.0 1 1

Index Scan using machine_type_machine_key_idx on machine_type mt_2 (cost=0.28..2.30 rows=1 width=38) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00077'::text)
95. 0.019 0.019 ↑ 1.0 1 1

Index Scan using machine_harvested_production_1_pkey on machine_harvested_production_1 mhp_3 (cost=0.28..2.29 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (hjid = mt_2.hjid)
96. 0.005 0.005 ↑ 1.0 1 1

Index Scan using harvested_production_type_pkey on harvested_production_type hpt_3 (cost=0.28..0.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (hjid = mhp_3.machine_harvested_production_0)
97. 0.005 0.005 ↑ 1.0 1 1

Index Scan using message_header_type_pkey on message_header_type mht_3 (cost=0.28..0.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (hpt_3.harvested_production_header__0 = hjid)
98. 0.005 0.005 ↑ 1.0 1 1

Index Scan using modification_date_type_pkey on modification_date_type mdt_3 (cost=0.29..0.34 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (mht_3.modification_date_message_he_0 = hjid)
99. 0.005 0.005 ↑ 1.0 1 1

Index Scan using contact_information_type_pkey on contact_information_type lcc (cost=0.29..2.30 rows=1 width=5) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (mt_2.logging_contractor_machine_t_0 = hjid)
100. 0.001 0.015 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=0.59..156.36 rows=1 width=63) (actual time=0.015..0.015 rows=0 loops=1)

101. 0.001 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.59..156.35 rows=1 width=432) (actual time=0.014..0.014 rows=0 loops=1)

102. 0.002 0.013 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.44..154.17 rows=1 width=49) (actual time=0.013..0.013 rows=0 loops=1)

103. 0.001 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.30..154.00 rows=1 width=45) (actual time=0.011..0.011 rows=0 loops=1)

104. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.15..153.82 rows=1 width=45) (actual time=0.010..0.010 rows=0 loops=1)

  • Join Filter: (mfp.machine_forwarded_production_0 = fpt.hjid)
105. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.00..153.34 rows=1 width=49) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (xfl_2.hjid = mfp.machine_forwarded_production_0)
106. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on machine_forwarded_production_1 mfp (cost=0.00..1.50 rows=1 width=53) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 40
107. 0.000 0.000 ↓ 0.0 0

Seq Scan on xml_file_list xfl_2 (cost=0.00..151.34 rows=40 width=4) (never executed)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_fpr.forwarded_production_type'::text)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using forwarded_production_type_pkey on forwarded_production_type fpt (cost=0.15..0.47 rows=1 width=8) (never executed)

  • Index Cond: (hjid = xfl_2.hjid)
109. 0.000 0.000 ↓ 0.0 0

Index Scan using message_header_type_pkey on message_header_type mht_4 (cost=0.15..0.18 rows=1 width=8) (never executed)

  • Index Cond: (fpt.forwarded_production_header__0 = hjid)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using modification_date_type_pkey on modification_date_type mdt_4 (cost=0.14..0.17 rows=1 width=12) (never executed)

  • Index Cond: (mht_4.modification_date_message_he_0 = hjid)
111. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type lcc_1 (cost=0.14..2.16 rows=1 width=22) (never executed)

  • Index Cond: (mfp.logging_contractor_machine_f_0 = hjid)
112. 0.002 0.562 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=9.57..161.75 rows=1 width=46) (actual time=0.562..0.562 rows=0 loops=1)

113. 0.013 0.560 ↓ 0.0 0 1

Hash Join (cost=9.57..161.74 rows=1 width=415) (actual time=0.560..0.560 rows=0 loops=1)

  • Hash Cond: (xfl_3.hjid = hqt.hjid)
114. 0.504 0.504 ↑ 219.0 1 1

Seq Scan on xml_file_list xfl_3 (cost=0.00..151.34 rows=219 width=4) (actual time=0.504..0.504 rows=1 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hqc.harvesting_quality_control_t_0'::text)
  • Rows Removed by Filter: 3398
115. 0.001 0.043 ↓ 0.0 0 1

Hash (cost=9.56..9.56 rows=1 width=54) (actual time=0.043..0.043 rows=0 loops=1)

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

Nested Loop Left Join (cost=0.99..9.56 rows=1 width=54) (actual time=0.042..0.042 rows=0 loops=1)

117. 0.001 0.040 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.71..7.26 rows=1 width=57) (actual time=0.040..0.040 rows=0 loops=1)

118. 0.001 0.039 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.43..6.92 rows=1 width=53) (actual time=0.039..0.039 rows=0 loops=1)

119. 0.001 0.038 ↓ 0.0 0 1

Nested Loop (cost=0.29..6.73 rows=1 width=53) (actual time=0.038..0.038 rows=0 loops=1)

120. 0.000 0.037 ↓ 0.0 0 1

Nested Loop (cost=0.14..6.55 rows=1 width=45) (actual time=0.037..0.037 rows=0 loops=1)

121. 0.037 0.037 ↓ 0.0 0 1

Seq Scan on machine_type mt_3 (cost=0.00..4.36 rows=1 width=53) (actual time=0.037..0.037 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 219
122. 0.000 0.000 ↓ 0.0 0

Index Scan using machine_harvesting_quality_c_1_pkey on machine_harvesting_quality_c_1 mhq (cost=0.14..2.16 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mt_3.hjid)
123. 0.000 0.000 ↓ 0.0 0

Index Scan using harvesting_quality_control_t_0_pkey on harvesting_quality_control_t_0 hqt (cost=0.14..0.18 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mhq.machine_harvesting_quality_c_0)
124. 0.000 0.000 ↓ 0.0 0

Index Scan using message_header_type_pkey on message_header_type mht_5 (cost=0.14..0.19 rows=1 width=8) (never executed)

  • Index Cond: (hqt.harvesting_quality_control_h_1 = hjid)
125. 0.000 0.000 ↓ 0.0 0

Index Scan using modification_date_type_pkey on modification_date_type mdt_5 (cost=0.28..0.34 rows=1 width=12) (never executed)

  • Index Cond: (mht_5.modification_date_message_he_0 = hjid)
126. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type lcc_2 (cost=0.28..2.30 rows=1 width=5) (never executed)

  • Index Cond: (mt_3.logging_contractor_machine_t_0 = hjid)
127. 0.001 0.012 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=0.30..156.19 rows=1 width=63) (actual time=0.012..0.012 rows=0 loops=1)

128. 0.002 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.30..156.18 rows=1 width=432) (actual time=0.011..0.011 rows=0 loops=1)

  • Join Filter: (mfq.logging_contractor_machine_f_0 = lcc_3.hjid)
129. 0.002 0.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.30..154.28 rows=1 width=49) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (mht_6.modification_date_message_he_0 = mdt_6.hjid)
130. 0.001 0.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.30..153.33 rows=1 width=45) (actual time=0.007..0.007 rows=0 loops=1)

131. 0.002 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.15..153.15 rows=1 width=45) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (mfq.machine_forwarding_quality_c_0 = fqt.hjid)
132. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.00..152.14 rows=1 width=49) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: (xfl_4.hjid = mfq.machine_forwarding_quality_c_0)
133. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on machine_forwarding_quality_c_1 mfq (cost=0.00..0.65 rows=1 width=53) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 12
134. 0.000 0.000 ↓ 0.0 0

Seq Scan on xml_file_list xfl_4 (cost=0.00..151.34 rows=12 width=4) (never executed)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_fqc.forwarding_quality_control_t_0'::text)
135. 0.000 0.000 ↓ 0.0 0

Index Scan using forwarding_quality_control_t_0_pkey on forwarding_quality_control_t_0 fqt (cost=0.15..1.00 rows=1 width=8) (never executed)

  • Index Cond: (hjid = xfl_4.hjid)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using message_header_type_pkey on message_header_type mht_6 (cost=0.15..0.18 rows=1 width=8) (never executed)

  • Index Cond: (fqt.forwarding_quality_control_h_1 = hjid)
137. 0.000 0.000 ↓ 0.0 0

Seq Scan on modification_date_type mdt_6 (cost=0.00..0.70 rows=20 width=12) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_information_type lcc_3 (cost=0.00..1.12 rows=62 width=22) (never executed)

139. 0.003 1.175 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=1.40..231.20 rows=1 width=54) (actual time=1.175..1.175 rows=0 loops=1)

140. 0.010 1.172 ↓ 0.0 0 1

Nested Loop (cost=1.40..231.19 rows=1 width=423) (actual time=1.172..1.172 rows=0 loops=1)

  • Join Filter: (xfl_5.hjid = omt.hjid)
  • Rows Removed by Join Filter: 6
141. 0.794 0.794 ↑ 1.0 1 1

Seq Scan on xml_file_list xfl_5 (cost=0.00..151.34 rows=1 width=4) (actual time=0.594..0.794 rows=1 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_mom.operational_monitoring_type'::text)
  • Rows Removed by Filter: 5026
142. 0.004 0.368 ↑ 1.2 6 1

Nested Loop Left Join (cost=1.40..79.77 rows=7 width=62) (actual time=0.147..0.368 rows=6 loops=1)

143. 0.008 0.352 ↑ 1.2 6 1

Nested Loop Left Join (cost=1.12..64.67 rows=7 width=34) (actual time=0.137..0.352 rows=6 loops=1)

144. 0.006 0.332 ↑ 1.2 6 1

Nested Loop Left Join (cost=0.84..62.52 rows=7 width=30) (actual time=0.125..0.332 rows=6 loops=1)

145. 0.005 0.302 ↑ 1.2 6 1

Nested Loop (cost=0.56..60.36 rows=7 width=30) (actual time=0.108..0.302 rows=6 loops=1)

146. 0.007 0.279 ↑ 1.2 6 1

Nested Loop (cost=0.28..58.18 rows=7 width=22) (actual time=0.093..0.279 rows=6 loops=1)

147. 0.260 0.260 ↑ 1.2 6 1

Seq Scan on machine_type mt_4 (cost=0.00..44.10 rows=7 width=30) (actual time=0.081..0.260 rows=6 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 2427
148. 0.012 0.012 ↑ 1.0 1 6

Index Scan using machine_operational_monitori_1_pkey on machine_operational_monitori_1 mo (cost=0.28..2.01 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (hjid = mt_4.hjid)
149. 0.018 0.018 ↑ 1.0 1 6

Index Scan using operational_monitoring_type_pkey on operational_monitoring_type omt (cost=0.28..0.31 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=6)

  • Index Cond: (hjid = mo.machine_operational_monitori_0)
150. 0.024 0.024 ↑ 1.0 1 6

Index Scan using message_header_type_pkey on message_header_type mht_7 (cost=0.28..0.31 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (omt.operational_monitoring_heade_0 = hjid)
151. 0.012 0.012 ↑ 1.0 1 6

Index Scan using modification_date_type_pkey on modification_date_type mdt_7 (cost=0.28..0.31 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (mht_7.modification_date_message_he_0 = hjid)
152. 0.012 0.012 ↑ 1.0 1 6

Index Scan using contact_information_type_pkey on contact_information_type lcc_4 (cost=0.28..2.16 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (mt_4.logging_contractor_machine_t_0 = hjid)
153. 0.004 3.291 ↑ 5.0 1 1

Materialize (cost=875.21..875.37 rows=5 width=43) (actual time=3.290..3.291 rows=1 loops=1)

154. 0.002 3.287 ↑ 5.0 1 1

Subquery Scan on a (cost=875.21..875.35 rows=5 width=43) (actual time=3.287..3.287 rows=1 loops=1)

155. 0.004 3.285 ↑ 5.0 1 1

GroupAggregate (cost=875.21..875.30 rows=5 width=91) (actual time=3.285..3.285 rows=1 loops=1)

  • Group Key: "*SELECT* 1_2".machine_key, "*SELECT* 1_2".contractor_id
156. 0.011 3.281 ↑ 5.0 1 1

Sort (cost=875.21..875.22 rows=5 width=43) (actual time=3.281..3.281 rows=1 loops=1)

  • Sort Key: "*SELECT* 1_2".contractor_id
  • Sort Method: quicksort Memory: 25kB
157. 0.019 3.270 ↑ 5.0 1 1

Append (cost=7.22..875.15 rows=5 width=43) (actual time=0.155..3.270 rows=1 loops=1)

158. 0.002 1.478 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1_2 (cost=7.22..175.97 rows=1 width=23) (actual time=0.154..1.478 rows=1 loops=1)

159. 0.260 1.476 ↑ 1.0 1 1

Hash Join (cost=7.22..175.96 rows=1 width=400) (actual time=0.153..1.476 rows=1 loops=1)

  • Hash Cond: (xfl_6.hjid = hpt_4.hjid)
160. 1.170 1.170 ↓ 1.0 4,693 1

Seq Scan on xml_file_list xfl_6 (cost=0.00..151.34 rows=4,639 width=4) (actual time=0.004..1.170 rows=4,693 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hpr.harvested_production_type'::text)
  • Rows Removed by Filter: 334
161. 0.004 0.046 ↑ 1.0 1 1

Hash (cost=7.21..7.21 rows=1 width=31) (actual time=0.046..0.046 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
162. 0.003 0.042 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.12..7.21 rows=1 width=31) (actual time=0.042..0.042 rows=1 loops=1)

163. 0.005 0.033 ↑ 1.0 1 1

Nested Loop (cost=0.84..4.90 rows=1 width=34) (actual time=0.033..0.033 rows=1 loops=1)

164. 0.006 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.59 rows=1 width=30) (actual time=0.022..0.023 rows=1 loops=1)

165. 0.012 0.012 ↑ 1.0 1 1

Index Scan using machine_type_machine_key_idx on machine_type mt_5 (cost=0.28..2.30 rows=1 width=38) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((machine_key)::text = 'FeltGIS_00077'::text)
166. 0.005 0.005 ↑ 1.0 1 1

Index Scan using machine_harvested_production_1_pkey on machine_harvested_production_1 mhp_4 (cost=0.28..2.29 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (hjid = mt_5.hjid)
167. 0.005 0.005 ↑ 1.0 1 1

Index Scan using harvested_production_type_pkey on harvested_production_type hpt_4 (cost=0.28..0.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (hjid = mhp_4.machine_harvested_production_0)
168. 0.006 0.006 ↑ 1.0 1 1

Index Scan using contact_information_type_pkey on contact_information_type lcc_5 (cost=0.29..2.30 rows=1 width=5) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (mt_5.logging_contractor_machine_t_0 = hjid)
169. 0.001 0.013 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=0.29..156.01 rows=1 width=55) (actual time=0.013..0.013 rows=0 loops=1)

170. 0.001 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..156.00 rows=1 width=432) (actual time=0.012..0.012 rows=0 loops=1)

171. 0.002 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.15..153.82 rows=1 width=41) (actual time=0.011..0.011 rows=0 loops=1)

  • Join Filter: (mfp_1.machine_forwarded_production_0 = fpt_1.hjid)
172. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.00..153.34 rows=1 width=49) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (xfl_7.hjid = mfp_1.machine_forwarded_production_0)
173. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on machine_forwarded_production_1 mfp_1 (cost=0.00..1.50 rows=1 width=53) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 40
174. 0.000 0.000 ↓ 0.0 0

Seq Scan on xml_file_list xfl_7 (cost=0.00..151.34 rows=40 width=4) (never executed)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_fpr.forwarded_production_type'::text)
175. 0.000 0.000 ↓ 0.0 0

Index Scan using forwarded_production_type_pkey on forwarded_production_type fpt_1 (cost=0.15..0.47 rows=1 width=8) (never executed)

  • Index Cond: (hjid = xfl_7.hjid)
176. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type lcc_6 (cost=0.14..2.16 rows=1 width=22) (never executed)

  • Index Cond: (mfp_1.logging_contractor_machine_f_0 = hjid)
177. 0.002 0.585 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3_1 (cost=9.04..161.22 rows=1 width=38) (actual time=0.585..0.585 rows=0 loops=1)

178. 0.013 0.583 ↓ 0.0 0 1

Hash Join (cost=9.04..161.21 rows=1 width=415) (actual time=0.583..0.583 rows=0 loops=1)

  • Hash Cond: (xfl_8.hjid = hqt_1.hjid)
179. 0.533 0.533 ↑ 219.0 1 1

Seq Scan on xml_file_list xfl_8 (cost=0.00..151.34 rows=219 width=4) (actual time=0.532..0.533 rows=1 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_hqc.harvesting_quality_control_t_0'::text)
  • Rows Removed by Filter: 3398
180. 0.001 0.037 ↓ 0.0 0 1

Hash (cost=9.03..9.03 rows=1 width=46) (actual time=0.037..0.037 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
181. 0.001 0.036 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.57..9.03 rows=1 width=46) (actual time=0.036..0.036 rows=0 loops=1)

182. 0.001 0.035 ↓ 0.0 0 1

Nested Loop (cost=0.29..6.73 rows=1 width=49) (actual time=0.035..0.035 rows=0 loops=1)

183. 0.001 0.034 ↓ 0.0 0 1

Nested Loop (cost=0.14..6.55 rows=1 width=45) (actual time=0.034..0.034 rows=0 loops=1)

184. 0.033 0.033 ↓ 0.0 0 1

Seq Scan on machine_type mt_6 (cost=0.00..4.36 rows=1 width=53) (actual time=0.033..0.033 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 219
185. 0.000 0.000 ↓ 0.0 0

Index Scan using machine_harvesting_quality_c_1_pkey on machine_harvesting_quality_c_1 mhq_1 (cost=0.14..2.16 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mt_6.hjid)
186. 0.000 0.000 ↓ 0.0 0

Index Scan using harvesting_quality_control_t_0_pkey on harvesting_quality_control_t_0 hqt_1 (cost=0.14..0.18 rows=1 width=8) (never executed)

  • Index Cond: (hjid = mhq_1.machine_harvesting_quality_c_0)
187. 0.000 0.000 ↓ 0.0 0

Index Scan using contact_information_type_pkey on contact_information_type lcc_7 (cost=0.28..2.30 rows=1 width=5) (never executed)

  • Index Cond: (mt_6.logging_contractor_machine_t_0 = hjid)
188. 0.000 0.012 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4_1 (cost=0.15..155.06 rows=1 width=55) (actual time=0.012..0.012 rows=0 loops=1)

189. 0.002 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.15..155.05 rows=1 width=432) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: (mfq_1.logging_contractor_machine_f_0 = lcc_8.hjid)
190. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.15..153.15 rows=1 width=41) (actual time=0.010..0.010 rows=0 loops=1)

  • Join Filter: (mfq_1.machine_forwarding_quality_c_0 = fqt_1.hjid)
191. 0.002 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.00..152.14 rows=1 width=49) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (xfl_9.hjid = mfq_1.machine_forwarding_quality_c_0)
192. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on machine_forwarding_quality_c_1 mfq_1 (cost=0.00..0.65 rows=1 width=53) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 12
193. 0.000 0.000 ↓ 0.0 0

Seq Scan on xml_file_list xfl_9 (cost=0.00..151.34 rows=12 width=4) (never executed)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_fqc.forwarding_quality_control_t_0'::text)
194. 0.000 0.000 ↓ 0.0 0

Index Scan using forwarding_quality_control_t_0_pkey on forwarding_quality_control_t_0 fqt_1 (cost=0.15..1.00 rows=1 width=8) (never executed)

  • Index Cond: (hjid = xfl_9.hjid)
195. 0.000 0.000 ↓ 0.0 0

Seq Scan on contact_information_type lcc_8 (cost=0.00..1.12 rows=62 width=22) (never executed)

196. 0.001 1.163 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5_1 (cost=0.84..226.89 rows=1 width=46) (actual time=1.163..1.163 rows=0 loops=1)

197. 0.009 1.162 ↓ 0.0 0 1

Nested Loop (cost=0.84..226.88 rows=1 width=423) (actual time=1.162..1.162 rows=0 loops=1)

  • Join Filter: (xfl_10.hjid = omt_1.hjid)
  • Rows Removed by Join Filter: 6
198. 0.783 0.783 ↑ 1.0 1 1

Seq Scan on xml_file_list xfl_10 (cost=0.00..151.34 rows=1 width=4) (actual time=0.591..0.783 rows=1 loops=1)

  • Filter: ((hjid_tablename)::text = 'sf2010_v2_mom.operational_monitoring_type'::text)
  • Rows Removed by Filter: 5026
199. 0.004 0.370 ↑ 1.2 6 1

Nested Loop Left Join (cost=0.84..75.46 rows=7 width=54) (actual time=0.176..0.370 rows=6 loops=1)

200. 0.004 0.342 ↑ 1.2 6 1

Nested Loop (cost=0.56..60.36 rows=7 width=26) (actual time=0.155..0.342 rows=6 loops=1)

201. 0.005 0.314 ↑ 1.2 6 1

Nested Loop (cost=0.28..58.18 rows=7 width=22) (actual time=0.135..0.314 rows=6 loops=1)

202. 0.279 0.279 ↑ 1.2 6 1

Seq Scan on machine_type mt_7 (cost=0.00..44.10 rows=7 width=30) (actual time=0.108..0.279 rows=6 loops=1)

  • Filter: ((machine_key)::text = 'FeltGIS_00077'::text)
  • Rows Removed by Filter: 2427
203. 0.030 0.030 ↑ 1.0 1 6

Index Scan using machine_operational_monitori_1_pkey on machine_operational_monitori_1 mo_1 (cost=0.28..2.01 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=6)

  • Index Cond: (hjid = mt_7.hjid)
204. 0.024 0.024 ↑ 1.0 1 6

Index Scan using operational_monitoring_type_pkey on operational_monitoring_type omt_1 (cost=0.28..0.31 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (hjid = mo_1.machine_operational_monitori_0)
205. 0.024 0.024 ↑ 1.0 1 6

Index Scan using contact_information_type_pkey on contact_information_type lcc_9 (cost=0.28..2.16 rows=1 width=36) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: (mt_7.logging_contractor_machine_t_0 = hjid)