explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lEjF

Settings
# exclusive inclusive rows x rows loops node
1. 328.993 100,291.865 ↑ 1.0 10,555 1

Sort (cost=5,570,110.60..5,570,137.31 rows=10,683 width=660) (actual time=100,201.476..100,291.865 rows=10,555 loops=1)

  • Sort Key: imd.department_cd, cqm.machine_code
  • Sort Method: quicksort Memory: 5812kB
2. 252.745 99,962.872 ↑ 1.0 10,555 1

Hash Right Join (cost=5,567,878.18..5,569,395.74 rows=10,683 width=660) (actual time=99,612.277..99,962.872 rows=10,555 loops=1)

  • Hash Cond: (cqml.machine_id = cqm.id)
3. 97.975 97.975 ↓ 1.0 10,549 1

Seq Scan on cq_machines_location cqml (cost=0.00..438.66 rows=10,546 width=32) (actual time=0.031..97.975 rows=10,549 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 10552
4. 109.325 99,612.152 ↑ 1.0 10,555 1

Hash (cost=5,567,744.64..5,567,744.64 rows=10,683 width=636) (actual time=99,612.152..99,612.152 rows=10,555 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2363kB
5. 185.746 99,502.827 ↑ 1.0 10,555 1

Hash Left Join (cost=5,567,395.17..5,567,744.64 rows=10,683 width=636) (actual time=99,034.472..99,502.827 rows=10,555 loops=1)

  • Hash Cond: (cqm.terminal_id = cqt.id)
6. 188.815 99,307.636 ↑ 1.0 10,555 1

Merge Left Join (cost=5,567,373.00..5,567,575.57 rows=10,683 width=634) (actual time=99,024.979..99,307.636 rows=10,555 loops=1)

  • Merge Cond: (cqm.terminal_id = cqch.terminal_id)
7. 201.468 80,904.120 ↑ 1.0 10,555 1

Sort (cost=5,528,110.35..5,528,137.06 rows=10,683 width=626) (actual time=80,814.687..80,904.120 rows=10,555 loops=1)

  • Sort Key: cqm.terminal_id
  • Sort Method: quicksort Memory: 3296kB
8. 181.676 80,702.652 ↑ 1.0 10,555 1

Merge Left Join (cost=5,527,059.86..5,527,395.50 rows=10,683 width=626) (actual time=79,503.956..80,702.652 rows=10,555 loops=1)

  • Merge Cond: (cqm.id = sub1.machine_id)
9. 281.496 69,576.611 ↑ 1.0 10,555 1

Merge Left Join (cost=5,506,951.79..5,507,245.94 rows=10,683 width=365) (actual time=68,559.564..69,576.611 rows=10,555 loops=1)

  • Merge Cond: (cqm.id = m.id)
10. 200.403 1,516.146 ↑ 1.0 10,553 1

Sort (cost=2,732.74..2,759.45 rows=10,683 width=333) (actual time=1,426.105..1,516.146 rows=10,553 loops=1)

  • Sort Key: cqm.id
  • Sort Method: quicksort Memory: 3206kB
11. 193.616 1,315.743 ↑ 1.0 10,553 1

Hash Left Join (cost=1,125.41..2,017.89 rows=10,683 width=333) (actual time=644.659..1,315.743 rows=10,553 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))
12. 186.562 1,117.260 ↑ 1.0 10,553 1

Hash Left Join (cost=1,106.70..1,838.92 rows=10,683 width=305) (actual time=639.754..1,117.260 rows=10,553 loops=1)

  • Hash Cond: (cqm.model_id = cqmd.id)
13. 193.659 930.186 ↑ 1.0 10,553 1

Hash Right Join (cost=1,104.42..1,707.56 rows=10,683 width=95) (actual time=639.203..930.186 rows=10,553 loops=1)

  • Hash Cond: (cqmi.machine_id = cqm.id)
14. 97.383 97.383 ↓ 1.0 10,570 1

Seq Scan on cq_machines_international cqmi (cost=0.00..405.19 rows=10,567 width=18) (actual time=0.022..97.383 rows=10,570 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 10573
15. 94.304 639.144 ↑ 1.0 10,553 1

Hash (cost=970.89..970.89 rows=10,683 width=85) (actual time=639.144..639.144 rows=10,553 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1156kB
16. 96.759 544.840 ↑ 1.0 10,553 1

Hash Right Join (cost=953.58..970.89 rows=10,683 width=85) (actual time=444.239..544.840 rows=10,553 loops=1)

  • Hash Cond: (mccssub.machine_id = cqm.id)
17. 131.876 249.359 ↓ 1.0 452 1

HashAggregate (cost=445.27..449.75 rows=447 width=15) (actual time=245.473..249.359 rows=452 loops=1)

  • Group Key: mccssub.machine_id
18. 117.483 117.483 ↓ 1.0 13,398 1

Seq Scan on cq_maintenance_check_current_status mccssub (cost=0.00..277.90 rows=13,390 width=15) (actual time=0.015..117.483 rows=13,398 loops=1)

19. 99.409 198.722 ↑ 1.0 10,553 1

Hash (cost=374.76..374.76 rows=10,683 width=69) (actual time=198.722..198.722 rows=10,553 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1070kB
20. 99.313 99.313 ↑ 1.0 10,553 1

Seq Scan on cq_machines cqm (cost=0.00..374.76 rows=10,683 width=69) (actual time=0.018..99.313 rows=10,553 loops=1)

  • Filter: ((operation_status)::text = '1'::text)
  • Rows Removed by Filter: 18
21. 0.091 0.512 ↓ 1.6 8 1

Hash (cost=2.22..2.22 rows=5 width=226) (actual time=0.512..0.512 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
22. 0.163 0.421 ↓ 1.6 8 1

Hash Left Join (cost=1.14..2.22 rows=5 width=226) (actual time=0.220..0.421 rows=8 loops=1)

  • Hash Cond: (cqmd.id = cqmo.model_id)
23. 0.082 0.082 ↓ 1.6 8 1

Seq Scan on cq_models cqmd (cost=0.00..1.05 rows=5 width=8) (actual time=0.012..0.082 rows=8 loops=1)

24. 0.087 0.176 ↓ 8.0 8 1

Hash (cost=1.12..1.12 rows=1 width=226) (actual time=0.176..0.176 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
25. 0.089 0.089 ↓ 8.0 8 1

Seq Scan on cq_models_international cqmo (cost=0.00..1.12 rows=1 width=226) (actual time=0.015..0.089 rows=8 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 9
26. 2.286 4.867 ↓ 1.1 247 1

Hash (cost=14.60..14.60 rows=235 width=46) (actual time=4.867..4.867 rows=247 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
27. 2.581 2.581 ↓ 1.1 247 1

Seq Scan on imm_department imd (cost=0.00..14.60 rows=235 width=46) (actual time=0.030..2.581 rows=247 loops=1)

  • Filter: (((locale_id)::text = 'ja'::text) AND (start_date <= ('now'::cstring)::date) AND (end_date > ('now'::cstring)::date))
  • Rows Removed by Filter: 15
28. 182.471 67,778.969 ↑ 1.0 10,573 1

Materialize (cost=5,504,219.05..5,504,326.19 rows=10,701 width=40) (actual time=67,133.321..67,778.969 rows=10,573 loops=1)

29. 183.032 67,596.498 ↑ 1.0 10,573 1

Merge Left Join (cost=5,504,219.05..5,504,299.44 rows=10,701 width=40) (actual time=67,133.299..67,596.498 rows=10,573 loops=1)

  • Merge Cond: (m.id = o_his.machine_id)
30. 185.452 55,193.797 ↑ 1.0 10,572 1

Merge Left Join (cost=5,462,110.06..5,462,163.68 rows=10,701 width=98) (actual time=54,913.795..55,193.797 rows=10,572 loops=1)

  • Merge Cond: (m.id = d_his.machine_id)
31. 192.142 665.941 ↑ 1.0 10,571 1

Sort (cost=1,834.36..1,861.11 rows=10,701 width=32) (actual time=575.431..665.941 rows=10,571 loops=1)

  • Sort Key: m.id
  • Sort Method: quicksort Memory: 1825kB
32. 189.120 473.799 ↑ 1.0 10,571 1

Hash Right Join (cost=481.77..1,118.17 rows=10,701 width=32) (actual time=188.813..473.799 rows=10,571 loops=1)

  • Hash Cond: (m_loc.machine_id = m.id)
33. 95.957 95.957 ↓ 1.0 10,549 1

Seq Scan on cq_machines_location m_loc (cost=0.00..438.66 rows=10,546 width=32) (actual time=0.030..95.957 rows=10,549 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 10552
34. 95.900 188.722 ↑ 1.0 10,571 1

Hash (cost=348.01..348.01 rows=10,701 width=8) (actual time=188.722..188.722 rows=10,571 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 413kB
35. 92.822 92.822 ↑ 1.0 10,571 1

Seq Scan on cq_machines m (cost=0.00..348.01 rows=10,701 width=8) (actual time=0.014..92.822 rows=10,571 loops=1)

36. 8.540 54,342.404 ↓ 59.8 478 1

Sort (cost=5,460,275.70..5,460,275.72 rows=8 width=74) (actual time=54,338.331..54,342.404 rows=478 loops=1)

  • Sort Key: d_his.machine_id
  • Sort Method: quicksort Memory: 93kB
37. 119.248 54,333.864 ↓ 59.8 478 1

Nested Loop (cost=5,438,317.24..5,460,275.58 rows=8 width=74) (actual time=53,964.384..54,333.864 rows=478 loops=1)

38. 114.324 54,146.284 ↓ 1.3 6,212 1

Nested Loop (cost=5,438,316.81..5,458,044.02 rows=4,849 width=24) (actual time=53,964.333..54,146.284 rows=6,212 loops=1)

39. 6,548.855 53,968.519 ↓ 1.1 477 1

HashAggregate (cost=5,438,316.24..5,438,320.50 rows=426 width=16) (actual time=53,964.284..53,968.519 rows=477 loops=1)

  • Group Key: d_his_1.machine_id
40. 25,348.414 47,419.664 ↓ 1.0 730,792 1

Nested Loop (cost=0.57..5,434,685.10 rows=726,229 width=16) (actual time=0.083..47,419.664 rows=730,792 loops=1)

41. 6,724.618 6,724.618 ↓ 1.0 730,792 1

Seq Scan on cq_movement_history m_his_1 (cost=0.00..36,700.12 rows=726,229 width=8) (actual time=0.021..6,724.618 rows=730,792 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 730562
42. 15,346.632 15,346.632 ↑ 1.0 1 730,792

Index Scan using pk_cq_operation_data_history on cq_operation_data_history d_his_1 (cost=0.57..7.42 rows=1 width=24) (actual time=0.012..0.021 rows=1 loops=730,792)

  • Index Cond: (id = m_his_1.id)
43. 63.441 63.441 ↓ 1.2 13 477

Index Scan using cq_operation_data_history_index02 on cq_operation_data_history d_his (cost=0.57..46.18 rows=11 width=24) (actual time=0.017..0.133 rows=13 loops=477)

  • Index Cond: ((machine_id = d_his_1.machine_id) AND (acquisition_time = (max(d_his_1.acquisition_time))))
44. 68.332 68.332 ↓ 0.0 0 6,212

Index Scan using cq_movement_history_index01 on cq_movement_history m_his (cost=0.43..0.45 rows=1 width=66) (actual time=0.011..0.011 rows=0 loops=6,212)

  • Index Cond: ((id = d_his.id) AND ((language_code)::text = 'ja'::text))
45. 0.475 12,219.669 ↓ 26.0 26 1

Sort (cost=42,108.99..42,108.99 rows=1 width=76) (actual time=12,219.454..12,219.669 rows=26 loops=1)

  • Sort Key: o_his.machine_id
  • Sort Method: quicksort Memory: 28kB
46. 0.902 12,219.194 ↓ 26.0 26 1

Nested Loop (cost=41,509.45..42,108.98 rows=1 width=76) (actual time=12,215.597..12,219.194 rows=26 loops=1)

47. 0.943 12,217.694 ↓ 26.0 26 1

Nested Loop (cost=41,509.16..42,108.65 rows=1 width=24) (actual time=12,215.550..12,217.694 rows=26 loops=1)

  • Join Filter: ((min((eve_1.event_code)::text)) = (eve.event_code)::text)
48. 2.486 12,216.231 ↑ 1.9 26 1

Hash Join (cost=41,508.88..42,092.98 rows=49 width=64) (actual time=12,215.483..12,216.231 rows=26 loops=1)

  • Hash Cond: ((o_his_1.machine_id = o_his.machine_id) AND (o_his_1.acquisition_time = o_his.acquisition_time))
49. 0.562 6,937.346 ↑ 622.5 25 1

HashAggregate (cost=26,357.95..26,513.58 rows=15,563 width=21) (actual time=6,937.093..6,937.346 rows=25 loops=1)

  • Group Key: o_his_1.machine_id, o_his_1.acquisition_time
50. 0.560 6,936.784 ↑ 598.6 26 1

Hash Join (cost=14,694.50..26,241.23 rows=15,563 width=21) (actual time=5,648.898..6,936.784 rows=26 loops=1)

  • Hash Cond: (o_his_1.event_id = eve_1.id)
51. 393.904 6,740.204 ↑ 598.6 26 1

Nested Loop Anti Join (cost=14,289.06..25,543.98 rows=15,563 width=24) (actual time=5,452.807..6,740.204 rows=26 loops=1)

52. 420.674 6,024.566 ↑ 1.0 22,981 1

Hash Join (cost=14,288.63..15,352.86 rows=23,344 width=24) (actual time=5,399.977..6,024.566 rows=22,981 loops=1)

  • Hash Cond: (o_loc_1.event_history_id = o_his_1.id)
53. 205.974 205.974 ↑ 1.0 22,981 1

Seq Scan on cq_occurrence_location o_loc_1 (cost=0.00..626.53 rows=23,344 width=8) (actual time=0.028..205.974 rows=22,981 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 2880
54. 2,769.714 5,397.918 ↑ 1.2 291,933 1

Hash (cost=9,977.17..9,977.17 rows=344,917 width=32) (actual time=5,397.918..5,397.918 rows=291,933 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 18246kB
55. 2,628.204 2,628.204 ↑ 1.2 291,933 1

Seq Scan on cq_occurrence_history o_his_1 (cost=0.00..9,977.17 rows=344,917 width=32) (actual time=0.014..2,628.204 rows=291,933 loops=1)

56. 321.734 321.734 ↑ 363.0 1 22,981

Index Only Scan using cq_occurrence_history_index04 on cq_occurrence_history oh_sub (cost=0.42..7.74 rows=363 width=16) (actual time=0.014..0.014 rows=1 loops=22,981)

  • Index Cond: ((machine_id = o_his_1.machine_id) AND (acquisition_time > o_his_1.acquisition_time))
  • Heap Fetches: 284
57. 100.467 196.020 ↑ 1.0 10,187 1

Hash (cost=277.42..277.42 rows=10,242 width=13) (actual time=196.020..196.020 rows=10,187 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 479kB
58. 95.553 95.553 ↑ 1.0 10,187 1

Seq Scan on cq_events eve_1 (cost=0.00..277.42 rows=10,242 width=13) (actual time=0.017..95.553 rows=10,187 loops=1)

59. 2,709.090 5,276.399 ↑ 1.2 291,933 1

Hash (cost=9,977.17..9,977.17 rows=344,917 width=32) (actual time=5,276.399..5,276.399 rows=291,933 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 18246kB
60. 2,567.309 2,567.309 ↑ 1.2 291,933 1

Seq Scan on cq_occurrence_history o_his (cost=0.00..9,977.17 rows=344,917 width=32) (actual time=0.013..2,567.309 rows=291,933 loops=1)

61. 0.520 0.520 ↑ 1.0 1 26

Index Scan using cq_events_index01 on cq_events eve (cost=0.29..0.31 rows=1 width=13) (actual time=0.011..0.020 rows=1 loops=26)

  • Index Cond: (id = o_his.event_id)
62. 0.598 0.598 ↑ 1.0 1 26

Index Scan using pk_cq_occurrence_location on cq_occurrence_location o_loc (cost=0.29..0.31 rows=1 width=68) (actual time=0.014..0.023 rows=1 loops=26)

  • Index Cond: ((event_history_id = o_his.id) AND ((language_code)::text = 'ja'::text))
63. 0.033 10,944.365 ↓ 0.0 0 1

Materialize (cost=20,108.07..20,122.84 rows=1 width=269) (actual time=10,944.365..10,944.365 rows=0 loops=1)

64. 0.017 10,944.332 ↓ 0.0 0 1

Nested Loop (cost=20,108.07..20,122.84 rows=1 width=269) (actual time=10,944.332..10,944.332 rows=0 loops=1)

  • Join Filter: ((unnest('{SYSTEMALERT,INFORMATION,CAUTION,CRITICAL}'::text[])) = (cqel.policy_attribute)::text)
65. 0.017 10,944.315 ↓ 0.0 0 1

Nested Loop (cost=20,107.94..20,122.67 rows=1 width=73) (actual time=10,944.315..10,944.315 rows=0 loops=1)

66. 0.018 10,944.298 ↓ 0.0 0 1

Nested Loop Left Join (cost=20,107.94..20,120.16 rows=1 width=41) (actual time=10,944.298..10,944.298 rows=0 loops=1)

67. 0.016 10,944.280 ↓ 0.0 0 1

Nested Loop (cost=20,107.65..20,119.75 rows=1 width=40) (actual time=10,944.280..10,944.280 rows=0 loops=1)

  • Join Filter: (((first_value(eve_2.event_code) OVER (?)))::text = (cqe.event_code)::text)
68. 8.890 10,944.264 ↓ 0.0 0 1

Nested Loop (cost=20,107.36..20,111.44 rows=1 width=56) (actual time=10,944.264..10,944.264 rows=0 loops=1)

69. 8.192 10,931.369 ↓ 445.0 445 1

WindowAgg (cost=20,106.93..20,106.95 rows=1 width=25) (actual time=10,919.473..10,931.369 rows=445 loops=1)

70. 8.048 10,923.177 ↓ 445.0 445 1

Sort (cost=20,106.93..20,106.93 rows=1 width=25) (actual time=10,919.416..10,923.177 rows=445 loops=1)

  • Sort Key: foreve_1.machine_id, (unnest('{0,1,2,3}'::integer[]))
  • Sort Method: quicksort Memory: 59kB
71. 27.337 10,915.129 ↓ 445.0 445 1

Nested Loop (cost=18,717.15..20,106.92 rows=1 width=25) (actual time=10,791.251..10,915.129 rows=445 loops=1)

  • Join Filter: ((cqel_1.policy_attribute)::text = (unnest('{SYSTEMALERT,INFORMATION,CAUTION,CRITICAL}'::text[])))
  • Rows Removed by Join Filter: 1335
72. 15.425 10,867.767 ↓ 445.0 445 1

Nested Loop (cost=18,717.15..20,104.16 rows=1 width=139) (actual time=10,791.167..10,867.767 rows=445 loops=1)

73. 15.602 10,843.887 ↓ 445.0 445 1

Nested Loop (cost=18,717.02..20,104.00 rows=1 width=29) (actual time=10,791.110..10,843.887 rows=445 loops=1)

74. 15.170 10,819.830 ↓ 445.0 445 1

Nested Loop (cost=18,716.73..20,103.68 rows=1 width=24) (actual time=10,791.065..10,819.830 rows=445 loops=1)

75. 2,641.197 10,794.892 ↓ 1.4 444 1

HashAggregate (cost=18,716.31..18,719.48 rows=317 width=16) (actual time=10,790.973..10,794.892 rows=444 loops=1)

  • Group Key: foreve_1.machine_id
76. 5,237.934 8,153.695 ↑ 1.2 291,933 1

Hash Join (cost=547.36..16,991.73 rows=344,917 width=16) (actual time=359.556..8,153.695 rows=291,933 loops=1)

  • Hash Cond: (foreve_1.event_id = eve_3.id)
77. 2,556.334 2,556.334 ↑ 1.2 291,933 1

Seq Scan on cq_occurrence_history foreve_1 (cost=0.00..9,977.17 rows=344,917 width=24) (actual time=0.012..2,556.334 rows=291,933 loops=1)

78. 92.848 359.427 ↑ 1.0 10,187 1

Hash (cost=419.34..419.34 rows=10,242 width=8) (actual time=359.427..359.427 rows=10,187 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 398kB
79. 178.552 266.579 ↑ 1.0 10,187 1

Hash Join (cost=1.09..419.34 rows=10,242 width=8) (actual time=0.245..266.579 rows=10,187 loops=1)

  • Hash Cond: (eve_3.event_level_id = cqel_2.id)
80. 87.906 87.906 ↑ 1.0 10,187 1

Seq Scan on cq_events eve_3 (cost=0.00..277.42 rows=10,242 width=16) (actual time=0.012..87.906 rows=10,187 loops=1)

81. 0.053 0.121 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
82. 0.068 0.068 ↑ 1.0 4 1

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

83. 9.768 9.768 ↑ 1.0 1 444

Index Only Scan using cq_occurrence_history_index02 on cq_occurrence_history foreve (cost=0.42..4.35 rows=1 width=24) (actual time=0.012..0.022 rows=1 loops=444)

  • Index Cond: ((machine_id = foreve_1.machine_id) AND (acquisition_time = (max(foreve_1.acquisition_time))))
  • Heap Fetches: 2
84. 8.455 8.455 ↑ 1.0 1 445

Index Scan using cq_events_index01 on cq_events eve_2 (cost=0.29..0.31 rows=1 width=21) (actual time=0.011..0.019 rows=1 loops=445)

  • Index Cond: (id = foreve.event_id)
85. 8.455 8.455 ↑ 1.0 1 445

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.010..0.019 rows=1 loops=445)

  • Index Cond: (id = eve_2.event_level_id)
  • Heap Fetches: 445
86. 20.025 20.025 ↑ 25.0 4 445

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.010..0.045 rows=4 loops=445)

87. 4.005 4.005 ↓ 0.0 0 445

Index Only Scan using cq_occurrence_history_index02 on cq_occurrence_history sub1 (cost=0.44..4.47 rows=1 width=24) (actual time=0.009..0.009 rows=0 loops=445)

  • 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()))
  • Heap Fetches: 0
88. 0.000 0.000 ↓ 0.0 0

Index Scan using cq_events_index01 on cq_events cqe (cost=0.29..8.30 rows=1 width=21) (never executed)

  • Index Cond: (id = sub1.event_id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using cq_events_international_index01 on cq_events_international cqei (cost=0.29..0.40 rows=1 width=17) (never executed)

  • Index Cond: ((cqe.id = event_id) AND ((language_code)::text = 'ja'::text))
90. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.51 rows=100 width=0) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Index Scan using cq_event_levels_index02 on cq_event_levels cqel (cost=0.13..0.15 rows=1 width=244) (never executed)

  • Index Cond: (id = cqe.event_level_id)
92. 8.441 18,214.701 ↓ 1.2 529 1

Sort (cost=39,262.65..39,263.76 rows=444 width=16) (actual time=18,210.259..18,214.701 rows=529 loops=1)

  • Sort Key: cqch.terminal_id
  • Sort Method: quicksort Memory: 46kB
93. 7.646 18,206.260 ↓ 1.0 453 1

Subquery Scan on cqch (cost=39,234.24..39,243.12 rows=444 width=16) (actual time=18,194.699..18,206.260 rows=453 loops=1)

94. 9,263.551 18,198.614 ↓ 1.0 453 1

HashAggregate (cost=39,234.24..39,238.68 rows=444 width=16) (actual time=18,194.680..18,198.614 rows=453 loops=1)

  • Group Key: cq_communication_history.terminal_id
95. 8,935.063 8,935.063 ↑ 1.0 1,035,283 1

Seq Scan on cq_communication_history (cost=0.00..34,057.83 rows=1,035,283 width=16) (actual time=0.017..8,935.063 rows=1,035,283 loops=1)

96. 4.759 9.445 ↑ 1.0 540 1

Hash (cost=15.41..15.41 rows=541 width=18) (actual time=9.445..9.445 rows=540 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
97. 4.686 4.686 ↑ 1.0 540 1

Seq Scan on cq_terminals cqt (cost=0.00..15.41 rows=541 width=18) (actual time=0.015..4.686 rows=540 loops=1)