explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I2ca

Settings
# exclusive inclusive rows x rows loops node
1. 2.339 377,998.702 ↑ 1.0 147 1

Sort (cost=1,345,589.30..1,345,589.68 rows=149 width=463) (actual time=377,998.010..377,998.702 rows=147 loops=1)

  • Sort Key: imd.department_cd, cqm.machine_code
  • Sort Method: quicksort Memory: 77kB
2. 2.999 377,996.363 ↑ 1.0 147 1

Hash Left Join (cost=1,345,458.94..1,345,583.93 rows=149 width=463) (actual time=377,955.427..377,996.363 rows=147 loops=1)

  • Hash Cond: (cqm.terminal_id = cqt.id)
3. 2.845 377,959.549 ↑ 1.0 147 1

Nested Loop Left Join (cost=1,345,424.53..1,345,535.18 rows=149 width=459) (actual time=377,921.489..377,959.549 rows=147 loops=1)

4. 1.842 377,924.217 ↑ 1.0 147 1

Merge Left Join (cost=1,345,424.26..1,345,425.36 rows=149 width=449) (actual time=377,921.395..377,924.217 rows=147 loops=1)

  • Merge Cond: (cqm.terminal_id = cqch.terminal_id)
5. 1.870 376,569.789 ↑ 1.0 147 1

Sort (cost=1,340,671.55..1,340,671.92 rows=149 width=441) (actual time=376,569.097..376,569.789 rows=147 loops=1)

  • Sort Key: cqm.terminal_id
  • Sort Method: quicksort Memory: 69kB
6. 1.829 376,567.919 ↑ 1.0 147 1

Merge Left Join (cost=1,340,635.84..1,340,666.17 rows=149 width=441) (actual time=376,528.336..376,567.919 rows=147 loops=1)

  • Merge Cond: (cqm.id = sub1.machine_id)
7. 5.602 374,022.061 ↑ 1.0 147 1

Merge Left Join (cost=1,334,728.27..1,334,739.39 rows=149 width=165) (actual time=373,984.409..374,022.061 rows=147 loops=1)

  • Merge Cond: (cqm.id = m.id)
8. 1.937 90.604 ↑ 1.0 147 1

Sort (cost=123.32..123.69 rows=149 width=133) (actual time=89.787..90.604 rows=147 loops=1)

  • Sort Key: cqm.id
  • Sort Method: quicksort Memory: 63kB
9. 1.726 88.667 ↑ 1.0 147 1

Hash Left Join (cost=84.44..117.94 rows=149 width=133) (actual time=69.514..88.667 rows=147 loops=1)

  • Hash Cond: (((cqm.company_code)::text = (imd.company_cd)::text) AND ((cqm.company_code)::text = (imd.department_set_cd)::text) AND ((cqm.company_code)::text = (imd.department_cd)::text))
10. 1.597 59.939 ↑ 1.0 147 1

Hash Left Join (cost=50.81..82.06 rows=149 width=93) (actual time=42.410..59.939 rows=147 loops=1)

  • Hash Cond: (cqm.model_id = cqmd.id)
11. 4.301 47.282 ↑ 1.0 147 1

Hash Right Join (cost=46.12..75.32 rows=149 width=95) (actual time=31.281..47.282 rows=147 loops=1)

  • Hash Cond: (cqmi.machine_id = cqm.id)
12. 11.798 11.798 ↓ 1.0 661 1

Seq Scan on cq_machines_international cqmi (cost=0.00..25.35 rows=654 width=19) (actual time=0.025..11.798 rows=661 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 661
13. 0.859 31.183 ↑ 1.0 147 1

Hash (cost=44.25..44.25 rows=149 width=84) (actual time=31.183..31.183 rows=147 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
14. 1.536 30.324 ↑ 1.0 147 1

Hash Left Join (cost=17.90..44.25 rows=149 width=84) (actual time=25.787..30.324 rows=147 loops=1)

  • Hash Cond: (cqm.id = mccs.machine_id)
15. 3.078 3.078 ↑ 1.0 147 1

Seq Scan on cq_machines cqm (cost=0.00..25.69 rows=149 width=68) (actual time=0.026..3.078 rows=147 loops=1)

  • Filter: ((operation_status)::text = '1'::text)
  • Rows Removed by Filter: 514
16. 0.269 25.710 ↑ 1.0 50 1

Hash (cost=17.27..17.27 rows=50 width=24) (actual time=25.710..25.710 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
17. 0.483 25.441 ↑ 1.0 50 1

Subquery Scan on mccs (cost=16.27..17.27 rows=50 width=24) (actual time=24.730..25.441 rows=50 loops=1)

18. 2.974 24.958 ↑ 1.0 50 1

HashAggregate (cost=16.27..16.77 rows=50 width=15) (actual time=24.721..24.958 rows=50 loops=1)

  • Group Key: mccssub.machine_id
19. 21.984 21.984 ↑ 1.0 501 1

Seq Scan on cq_maintenance_check_current_status mccssub (cost=0.00..10.01 rows=501 width=15) (actual time=7.552..21.984 rows=501 loops=1)

20. 0.259 11.060 ↓ 1.1 40 1

Hash (cost=4.23..4.23 rows=37 width=14) (actual time=11.060..11.060 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
21. 0.507 10.801 ↓ 1.1 40 1

Hash Right Join (cost=1.83..4.23 rows=37 width=14) (actual time=10.168..10.801 rows=40 loops=1)

  • Hash Cond: (cqmo.model_id = cqmd.id)
22. 9.791 9.791 ↓ 1.1 40 1

Seq Scan on cq_models_international cqmo (cost=0.00..1.90 rows=36 width=14) (actual time=9.574..9.791 rows=40 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 40
23. 0.254 0.503 ↓ 1.1 40 1

Hash (cost=1.37..1.37 rows=37 width=8) (actual time=0.503..0.503 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
24. 0.249 0.249 ↓ 1.1 40 1

Seq Scan on cq_models cqmd (cost=0.00..1.37 rows=37 width=8) (actual time=0.009..0.249 rows=40 loops=1)

25. 1.339 27.002 ↑ 1.0 207 1

Hash (cost=30.01..30.01 rows=207 width=67) (actual time=27.002..27.002 rows=207 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
26. 25.663 25.663 ↑ 1.0 207 1

Seq Scan on imm_department imd (cost=0.00..30.01 rows=207 width=67) (actual time=16.752..25.663 rows=207 loops=1)

  • Filter: (((locale_id)::text = 'ja'::text) AND (start_date <= ('now'::cstring)::date) AND (end_date > ('now'::cstring)::date))
  • Rows Removed by Filter: 48
27. 10.426 373,925.855 ↑ 1.1 661 1

Materialize (cost=1,334,604.95..1,334,612.10 rows=695 width=40) (actual time=373,894.602..373,925.855 rows=661 loops=1)

28. 7.391 373,915.429 ↑ 1.1 661 1

Merge Left Join (cost=1,334,604.95..1,334,610.36 rows=695 width=40) (actual time=373,894.569..373,915.429 rows=661 loops=1)

  • Merge Cond: (m.id = o_his.machine_id)
29. 9.584 369,474.350 ↑ 1.1 661 1

Merge Left Join (cost=1,319,717.06..1,319,720.72 rows=695 width=98) (actual time=369,460.883..369,474.350 rows=661 loops=1)

  • Merge Cond: (m.id = d_his.machine_id)
30. 7.366 26.495 ↑ 1.1 661 1

Sort (cost=99.72..101.46 rows=695 width=18) (actual time=22.904..26.495 rows=661 loops=1)

  • Sort Key: m.id
  • Sort Method: quicksort Memory: 67kB
31. 7.013 19.129 ↑ 1.1 661 1

Hash Right Join (cost=32.64..66.92 rows=695 width=18) (actual time=7.396..19.129 rows=661 loops=1)

  • Hash Cond: (m_loc.machine_id = m.id)
32. 4.814 4.814 ↓ 1.0 661 1

Seq Scan on cq_machines_location m_loc (cost=0.00..25.29 rows=654 width=18) (actual time=0.027..4.814 rows=661 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 656
33. 3.811 7.302 ↑ 1.1 661 1

Hash (cost=23.95..23.95 rows=695 width=8) (actual time=7.302..7.302 rows=661 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 26kB
34. 3.491 3.491 ↑ 1.1 661 1

Seq Scan on cq_machines m (cost=0.00..23.95 rows=695 width=8) (actual time=0.008..3.491 rows=661 loops=1)

35. 0.787 369,438.271 ↓ 4.7 56 1

Sort (cost=1,319,617.34..1,319,617.37 rows=12 width=88) (actual time=369,437.960..369,438.271 rows=56 loops=1)

  • Sort Key: d_his.machine_id
  • Sort Method: quicksort Memory: 33kB
36. 34.659 369,437.484 ↓ 4.7 56 1

Nested Loop (cost=1,316,504.42..1,319,617.12 rows=12 width=88) (actual time=367,443.512..369,437.484 rows=56 loops=1)

37. 33.707 369,243.205 ↓ 4.8 3,470 1

Nested Loop (cost=1,316,504.00..1,319,282.45 rows=723 width=24) (actual time=367,443.388..369,243.205 rows=3,470 loops=1)

38. 3,017.087 367,395.098 ↓ 1.0 56 1

HashAggregate (cost=1,316,503.43..1,316,503.98 rows=55 width=16) (actual time=367,394.776..367,395.098 rows=56 loops=1)

  • Group Key: d_his_1.machine_id
39. 166,931.511 364,378.011 ↓ 1.0 556,813 1

Merge Join (cost=63.25..1,313,740.71 rows=552,544 width=16) (actual time=14.216..364,378.011 rows=556,813 loops=1)

  • Merge Cond: (m_his_1.id = d_his_1.id)
40. 4,029.001 4,029.001 ↓ 1.0 556,813 1

Index Only Scan using cq_movement_history_index01 on cq_movement_history m_his_1 (cost=0.43..73,286.42 rows=552,544 width=8) (actual time=0.069..4,029.001 rows=556,813 loops=1)

  • Index Cond: (language_code = 'ja'::text)
  • Heap Fetches: 556813
41. 193,417.499 193,417.499 ↑ 1.0 32,102,131 1

Index Scan using pk_cq_operation_data_history on cq_operation_data_history d_his_1 (cost=0.44..1,174,329.55 rows=32,244,928 width=24) (actual time=0.023..193,417.499 rows=32,102,131 loops=1)

42. 1,814.400 1,814.400 ↓ 4.8 62 56

Index Scan using cq_operation_data_history_index02 on cq_operation_data_history d_his (cost=0.56..50.38 rows=13 width=24) (actual time=30.816..32.400 rows=62 loops=56)

  • Index Cond: ((machine_id = d_his_1.machine_id) AND (acquisition_time = (max(d_his_1.acquisition_time))))
43. 159.620 159.620 ↓ 0.0 0 3,470

Index Scan using cq_movement_history_index01 on cq_movement_history m_his (cost=0.43..0.45 rows=1 width=80) (actual time=0.046..0.046 rows=0 loops=3,470)

  • Index Cond: ((id = d_his.id) AND ((language_code)::text = 'ja'::text))
44. 0.124 4,433.688 ↓ 4.0 4 1

Sort (cost=14,887.89..14,887.90 rows=1 width=84) (actual time=4,433.667..4,433.688 rows=4 loops=1)

  • Sort Key: o_his.machine_id
  • Sort Method: quicksort Memory: 25kB
45. 0.108 4,433.564 ↓ 4.0 4 1

Nested Loop (cost=14,065.44..14,887.88 rows=1 width=84) (actual time=4,433.332..4,433.564 rows=4 loops=1)

  • Join Filter: ((min((eve_1.event_code)::text)) = (eve.event_code)::text)
46. 0.153 4,433.340 ↑ 3.0 4 1

Hash Join (cost=14,065.15..14,883.99 rows=12 width=124) (actual time=4,433.240..4,433.340 rows=4 loops=1)

  • Hash Cond: ((o_his_1.machine_id = o_his.machine_id) AND (o_his_1.acquisition_time = o_his.acquisition_time))
47. 0.135 2,801.990 ↑ 2,924.0 4 1

HashAggregate (cost=9,079.09..9,196.05 rows=11,696 width=25) (actual time=2,801.938..2,801.990 rows=4 loops=1)

  • Group Key: o_his_1.machine_id, o_his_1.acquisition_time
48. 0.143 2,801.855 ↑ 2,924.0 4 1

Hash Join (cost=7,234.62..8,991.37 rows=11,696 width=25) (actual time=2,427.528..2,801.855 rows=4 loops=1)

  • Hash Cond: (o_his_1.event_id = eve_1.id)
49. 96.738 2,689.823 ↑ 2,924.0 4 1

Hash Anti Join (cost=6,900.14..8,393.74 rows=11,696 width=24) (actual time=2,315.540..2,689.823 rows=4 loops=1)

  • Hash Cond: (o_his_1.machine_id = oh_sub.machine_id)
  • Join Filter: (o_his_1.acquisition_time < oh_sub.acquisition_time)
  • Rows Removed by Join Filter: 23086
50. 212.888 1,450.736 ↓ 1.0 17,558 1

Hash Join (cost=3,450.07..4,722.90 rows=17,544 width=24) (actual time=1,114.611..1,450.736 rows=17,558 loops=1)

  • Hash Cond: (o_loc_1.event_history_id = o_his_1.id)
51. 123.698 123.698 ↓ 1.0 17,558 1

Seq Scan on cq_occurrence_location o_loc_1 (cost=0.00..921.95 rows=17,544 width=8) (actual time=0.030..123.698 rows=17,558 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 17558
52. 566.769 1,114.150 ↓ 1.0 104,583 1

Hash (cost=2,142.81..2,142.81 rows=104,581 width=32) (actual time=1,114.150..1,114.150 rows=104,583 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 6537kB
53. 547.381 547.381 ↓ 1.0 104,583 1

Seq Scan on cq_occurrence_history o_his_1 (cost=0.00..2,142.81 rows=104,581 width=32) (actual time=0.012..547.381 rows=104,583 loops=1)

54. 592.670 1,142.349 ↓ 1.0 104,583 1

Hash (cost=2,142.81..2,142.81 rows=104,581 width=16) (actual time=1,142.349..1,142.349 rows=104,583 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 4903kB
55. 549.679 549.679 ↓ 1.0 104,583 1

Seq Scan on cq_occurrence_history oh_sub (cost=0.00..2,142.81 rows=104,581 width=16) (actual time=0.010..549.679 rows=104,583 loops=1)

56. 41.137 111.889 ↑ 1.1 7,741 1

Hash (cost=229.21..229.21 rows=8,421 width=17) (actual time=111.889..111.889 rows=7,741 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 405kB
57. 70.752 70.752 ↑ 1.1 7,741 1

Seq Scan on cq_events eve_1 (cost=0.00..229.21 rows=8,421 width=17) (actual time=0.027..70.752 rows=7,741 loops=1)

58. 102.724 1,631.197 ↓ 1.0 17,558 1

Hash (cost=4,722.90..4,722.90 rows=17,544 width=92) (actual time=1,631.197..1,631.197 rows=17,558 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2254kB
59. 196.535 1,528.473 ↓ 1.0 17,558 1

Hash Join (cost=3,450.07..4,722.90 rows=17,544 width=92) (actual time=1,215.670..1,528.473 rows=17,558 loops=1)

  • Hash Cond: (o_loc.event_history_id = o_his.id)
60. 116.736 116.736 ↓ 1.0 17,558 1

Seq Scan on cq_occurrence_location o_loc (cost=0.00..921.95 rows=17,544 width=76) (actual time=0.047..116.736 rows=17,558 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 17558
61. 593.858 1,215.202 ↓ 1.0 104,583 1

Hash (cost=2,142.81..2,142.81 rows=104,581 width=32) (actual time=1,215.202..1,215.202 rows=104,583 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 6537kB
62. 621.344 621.344 ↓ 1.0 104,583 1

Seq Scan on cq_occurrence_history o_his (cost=0.00..2,142.81 rows=104,581 width=32) (actual time=22.203..621.344 rows=104,583 loops=1)

63. 0.116 0.116 ↑ 1.0 1 4

Index Scan using cq_events_index01 on cq_events eve (cost=0.29..0.31 rows=1 width=17) (actual time=0.024..0.029 rows=1 loops=4)

  • Index Cond: (id = o_his.event_id)
64. 0.036 2,544.029 ↑ 1.0 1 1

Materialize (cost=5,907.57..5,926.40 rows=1 width=284) (actual time=2,543.909..2,544.029 rows=1 loops=1)

65. 0.100 2,543.993 ↑ 1.0 1 1

Nested Loop (cost=5,907.57..5,926.39 rows=1 width=284) (actual time=2,543.882..2,543.993 rows=1 loops=1)

  • Join Filter: ((unnest('{SYSTEMALERT,INFORMATION,CAUTION,CRITICAL}'::text[])) = (cqel.policy_attribute)::text)
  • Rows Removed by Join Filter: 3
66. 0.060 2,543.817 ↓ 4.0 4 1

Nested Loop (cost=5,907.44..5,926.23 rows=1 width=88) (actual time=2,543.680..2,543.817 rows=4 loops=1)

67. 0.031 2,543.698 ↑ 1.0 1 1

Nested Loop Left Join (cost=5,907.44..5,923.72 rows=1 width=56) (actual time=2,543.627..2,543.698 rows=1 loops=1)

68. 0.050 2,498.934 ↑ 1.0 1 1

Nested Loop (cost=5,907.15..5,923.26 rows=1 width=40) (actual time=2,498.881..2,498.934 rows=1 loops=1)

  • Join Filter: (((first_value(eve_2.event_code) OVER (?)))::text = (cqe.event_code)::text)
69. 0.767 2,498.871 ↑ 1.0 1 1

Nested Loop (cost=5,906.87..5,914.94 rows=1 width=56) (actual time=2,498.838..2,498.871 rows=1 loops=1)

70. 0.676 2,497.829 ↓ 55.0 55 1

WindowAgg (cost=5,906.43..5,906.46 rows=1 width=29) (actual time=2,496.979..2,497.829 rows=55 loops=1)

71. 0.735 2,497.153 ↓ 55.0 55 1

Sort (cost=5,906.43..5,906.44 rows=1 width=29) (actual time=2,496.901..2,497.153 rows=55 loops=1)

  • Sort Key: foreve_1.machine_id, (unnest('{0,1,2,3}'::integer[]))
  • Sort Method: quicksort Memory: 29kB
72. 1.971 2,496.418 ↓ 55.0 55 1

Nested Loop (cost=5,470.97..5,906.42 rows=1 width=29) (actual time=2,384.963..2,496.418 rows=55 loops=1)

  • Join Filter: ((cqel_1.policy_attribute)::text = (unnest('{SYSTEMALERT,INFORMATION,CAUTION,CRITICAL}'::text[])))
  • Rows Removed by Join Filter: 165
73. 1.113 2,492.797 ↓ 55.0 55 1

Nested Loop (cost=5,470.97..5,903.66 rows=1 width=143) (actual time=2,384.846..2,492.797 rows=55 loops=1)

74. 1.130 2,490.969 ↓ 55.0 55 1

Nested Loop (cost=5,470.84..5,903.50 rows=1 width=33) (actual time=2,384.757..2,490.969 rows=55 loops=1)

75. 1.095 2,472.789 ↓ 55.0 55 1

Nested Loop (cost=5,470.56..5,903.18 rows=1 width=24) (actual time=2,383.966..2,472.789 rows=55 loops=1)

76. 556.679 2,344.479 ↓ 1.0 55 1

HashAggregate (cost=5,470.14..5,470.67 rows=53 width=16) (actual time=2,344.190..2,344.479 rows=55 loops=1)

  • Group Key: foreve_1.machine_id
77. 1,076.710 1,787.800 ↓ 1.0 104,583 1

Hash Join (cost=451.35..4,947.23 rows=104,581 width=16) (actual time=180.110..1,787.800 rows=104,583 loops=1)

  • Hash Cond: (foreve_1.event_id = eve_3.id)
78. 531.045 531.045 ↓ 1.0 104,583 1

Seq Scan on cq_occurrence_history foreve_1 (cost=0.00..2,142.81 rows=104,581 width=24) (actual time=0.010..531.045 rows=104,583 loops=1)

79. 41.925 180.045 ↑ 1.1 7,741 1

Hash (cost=346.09..346.09 rows=8,421 width=8) (actual time=180.045..180.045 rows=7,741 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 303kB
80. 78.366 138.120 ↑ 1.1 7,741 1

Hash Join (cost=1.09..346.09 rows=8,421 width=8) (actual time=12.993..138.120 rows=7,741 loops=1)

  • Hash Cond: (eve_3.event_level_id = cqel_2.id)
81. 46.843 46.843 ↑ 1.1 7,741 1

Seq Scan on cq_events eve_3 (cost=0.00..229.21 rows=8,421 width=16) (actual time=0.009..46.843 rows=7,741 loops=1)

82. 0.032 12.911 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=8) (actual time=12.911..12.911 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
83. 12.879 12.879 ↑ 1.0 4 1

Seq Scan on cq_event_levels cqel_2 (cost=0.00..1.04 rows=4 width=8) (actual time=12.859..12.879 rows=4 loops=1)

84. 127.215 127.215 ↑ 1.0 1 55

Index Scan using cq_occurrence_history_index04 on cq_occurrence_history foreve (cost=0.42..8.14 rows=1 width=24) (actual time=2.308..2.313 rows=1 loops=55)

  • Index Cond: ((machine_id = foreve_1.machine_id) AND (acquisition_time = (max(foreve_1.acquisition_time))))
85. 17.050 17.050 ↑ 1.0 1 55

Index Scan using cq_events_index01 on cq_events eve_2 (cost=0.29..0.31 rows=1 width=25) (actual time=0.305..0.310 rows=1 loops=55)

  • Index Cond: (id = foreve.event_id)
86. 0.715 0.715 ↑ 1.0 1 55

Index Only Scan using cq_event_levels_index02 on cq_event_levels cqel_1 (cost=0.13..0.15 rows=1 width=126) (actual time=0.008..0.013 rows=1 loops=55)

  • Index Cond: (id = eve_2.event_level_id)
  • Heap Fetches: 55
87. 1.650 1.650 ↑ 25.0 4 55

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.009..0.030 rows=4 loops=55)

88. 0.275 0.275 ↓ 0.0 0 55

Index Scan using cq_occurrence_history_index04 on cq_occurrence_history sub1 (cost=0.43..8.46 rows=1 width=24) (actual time=0.005..0.005 rows=0 loops=55)

  • Index Cond: ((machine_id = foreve_1.machine_id) AND (acquisition_time = (max(foreve_1.acquisition_time))) AND (acquisition_time >= ((to_date(to_char(now(), 'yyyy/MM/dd'::text), 'yyyy/MM/dd'::text) - 30) + 1)) AND (acquisition_time <= now()))
89. 0.013 0.013 ↑ 1.0 1 1

Index Scan using cq_events_index01 on cq_events cqe (cost=0.29..8.30 rows=1 width=25) (actual time=0.008..0.013 rows=1 loops=1)

  • Index Cond: (id = sub1.event_id)
90. 44.733 44.733 ↑ 1.0 1 1

Index Scan using cq_events_international_index01 on cq_events_international cqei (cost=0.29..0.45 rows=1 width=32) (actual time=44.728..44.733 rows=1 loops=1)

  • Index Cond: ((cqe.id = event_id) AND ((language_code)::text = 'ja'::text))
91. 0.059 0.059 ↑ 25.0 4 1

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.037..0.059 rows=4 loops=1)

92. 0.076 0.076 ↑ 1.0 1 4

Index Scan using cq_event_levels_index02 on cq_event_levels cqel (cost=0.13..0.15 rows=1 width=244) (actual time=0.008..0.019 rows=1 loops=4)

  • Index Cond: (id = cqe.event_level_id)
93. 0.623 1,352.586 ↓ 1.3 65 1

Sort (cost=4,752.71..4,752.83 rows=50 width=16) (actual time=1,352.278..1,352.586 rows=65 loops=1)

  • Sort Key: cqch.terminal_id
  • Sort Method: quicksort Memory: 27kB
94. 0.486 1,351.963 ↓ 1.1 53 1

Subquery Scan on cqch (cost=4,750.29..4,751.29 rows=50 width=16) (actual time=1,351.222..1,351.963 rows=53 loops=1)

95. 614.388 1,351.477 ↓ 1.1 53 1

HashAggregate (cost=4,750.29..4,750.79 rows=50 width=16) (actual time=1,351.212..1,351.477 rows=53 loops=1)

  • Group Key: cq_communication_history.terminal_id
96. 737.089 737.089 ↑ 1.0 115,153 1

Seq Scan on cq_communication_history (cost=0.00..4,174.53 rows=115,153 width=16) (actual time=20.244..737.089 rows=115,153 loops=1)

97. 32.487 32.487 ↑ 1.0 1 147

Index Scan using pk_cq_machines_location on cq_machines_location cqml (cost=0.28..0.73 rows=1 width=18) (actual time=0.216..0.221 rows=1 loops=147)

  • Index Cond: ((cqm.id = machine_id) AND ((language_code)::text = 'ja'::text))
98. 4.330 33.815 ↓ 1.0 820 1

Hash (cost=24.18..24.18 rows=818 width=20) (actual time=33.815..33.815 rows=820 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
99. 29.485 29.485 ↓ 1.0 820 1

Seq Scan on cq_terminals cqt (cost=0.00..24.18 rows=818 width=20) (actual time=20.371..29.485 rows=820 loops=1)