explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XJDP

Settings
# exclusive inclusive rows x rows loops node
1. 322.809 107,771.384 ↑ 1.0 10,555 1

Sort (cost=5,570,110.60..5,570,137.31 rows=10,683 width=660) (actual time=107,681.992..107,771.384 rows=10,555 loops=1)

  • Sort Key: imd.department_cd, cqm.machine_code
  • Sort Method: quicksort Memory: 5812kB
2. 251.640 107,448.575 ↑ 1.0 10,555 1

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

  • Hash Cond: (cqml.machine_id = cqm.id)
3. 96.996 96.996 ↓ 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.033..96.996 rows=10,549 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 10552
4. 110.431 107,099.939 ↑ 1.0 10,555 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 2363kB
5. 187.887 106,989.508 ↑ 1.0 10,555 1

Hash Left Join (cost=5,567,395.17..5,567,744.64 rows=10,683 width=636) (actual time=106,515.355..106,989.508 rows=10,555 loops=1)

  • Hash Cond: (cqm.terminal_id = cqt.id)
6. 191.155 106,792.157 ↑ 1.0 10,555 1

Merge Left Join (cost=5,567,373.00..5,567,575.57 rows=10,683 width=634) (actual time=106,505.822..106,792.157 rows=10,555 loops=1)

  • Merge Cond: (cqm.terminal_id = cqch.terminal_id)
7. 203.513 88,472.413 ↑ 1.0 10,555 1

Sort (cost=5,528,110.35..5,528,137.06 rows=10,683 width=626) (actual time=88,381.751..88,472.413 rows=10,555 loops=1)

  • Sort Key: cqm.terminal_id
  • Sort Method: quicksort Memory: 3296kB
8. 182.092 88,268.900 ↑ 1.0 10,555 1

Merge Left Join (cost=5,527,059.86..5,527,395.50 rows=10,683 width=626) (actual time=87,066.372..88,268.900 rows=10,555 loops=1)

  • Merge Cond: (cqm.id = sub1.machine_id)
9. 282.359 77,388.986 ↑ 1.0 10,555 1

Merge Left Join (cost=5,506,951.79..5,507,245.94 rows=10,683 width=365) (actual time=76,368.523..77,388.986 rows=10,555 loops=1)

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

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

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

Hash Left Join (cost=1,125.41..2,017.89 rows=10,683 width=333) (actual time=643.332..1,305.518 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. 185.373 1,110.127 ↑ 1.0 10,553 1

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

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

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

  • Hash Cond: (cqmi.machine_id = cqm.id)
14. 96.697 96.697 ↓ 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.040..96.697 rows=10,570 loops=1)

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

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

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

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

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

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

  • Group Key: mccssub.machine_id
18. 114.869 114.869 ↓ 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..114.869 rows=13,398 loops=1)

19. 96.648 192.421 ↑ 1.0 10,553 1

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
22. 0.185 0.441 ↓ 1.6 8 1

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

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

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

24. 0.088 0.177 ↓ 8.0 8 1

Hash (cost=1.12..1.12 rows=1 width=226) (actual time=0.177..0.177 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.016..0.089 rows=8 loops=1)

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

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

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

Seq Scan on imm_department imd (cost=0.00..14.60 rows=235 width=46) (actual time=0.044..2.613 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. 183.449 75,599.404 ↑ 1.0 10,573 1

Materialize (cost=5,504,219.05..5,504,326.19 rows=10,701 width=40) (actual time=74,951.533..75,599.404 rows=10,573 loops=1)

29. 183.994 75,415.955 ↑ 1.0 10,573 1

Merge Left Join (cost=5,504,219.05..5,504,299.44 rows=10,701 width=40) (actual time=74,951.511..75,415.955 rows=10,573 loops=1)

  • Merge Cond: (m.id = o_his.machine_id)
30. 185.725 63,275.645 ↑ 1.0 10,572 1

Merge Left Join (cost=5,462,110.06..5,462,163.68 rows=10,701 width=98) (actual time=62,995.346..63,275.645 rows=10,572 loops=1)

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

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

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

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

  • Hash Cond: (m_loc.machine_id = m.id)
33. 96.445 96.445 ↓ 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.025..96.445 rows=10,549 loops=1)

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

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

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

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

36. 8.580 62,424.768 ↓ 59.8 478 1

Sort (cost=5,460,275.70..5,460,275.72 rows=8 width=74) (actual time=62,420.692..62,424.768 rows=478 loops=1)

  • Sort Key: d_his.machine_id
  • Sort Method: quicksort Memory: 93kB
37. 117.047 62,416.188 ↓ 59.8 478 1

Nested Loop (cost=5,438,317.24..5,460,275.58 rows=8 width=74) (actual time=62,014.602..62,416.188 rows=478 loops=1)

38. 113.990 62,224.597 ↓ 1.3 6,212 1

Nested Loop (cost=5,438,316.81..5,458,044.02 rows=4,849 width=24) (actual time=62,014.501..62,224.597 rows=6,212 loops=1)

39. 6,507.280 62,018.546 ↓ 1.1 477 1

HashAggregate (cost=5,438,316.24..5,438,320.50 rows=426 width=16) (actual time=62,014.353..62,018.546 rows=477 loops=1)

  • Group Key: d_his_1.machine_id
40. 24,951.368 55,511.266 ↓ 1.0 730,792 1

Nested Loop (cost=0.57..5,434,685.10 rows=726,229 width=16) (actual time=0.185..55,511.266 rows=730,792 loops=1)

41. 7,174.554 7,174.554 ↓ 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.039..7,174.554 rows=730,792 loops=1)

  • Filter: ((language_code)::text = 'ja'::text)
  • Rows Removed by Filter: 730562
42. 23,385.344 23,385.344 ↑ 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.023..0.032 rows=1 loops=730,792)

  • Index Cond: (id = m_his_1.id)
43. 92.061 92.061 ↓ 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.070..0.193 rows=13 loops=477)

  • Index Cond: ((machine_id = d_his_1.machine_id) AND (acquisition_time = (max(d_his_1.acquisition_time))))
44. 74.544 74.544 ↓ 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.012 rows=0 loops=6,212)

  • Index Cond: ((id = d_his.id) AND ((language_code)::text = 'ja'::text))
45. 0.500 11,956.316 ↓ 26.0 26 1

Sort (cost=42,108.99..42,108.99 rows=1 width=76) (actual time=11,956.099..11,956.316 rows=26 loops=1)

  • Sort Key: o_his.machine_id
  • Sort Method: quicksort Memory: 28kB
46. 0.894 11,955.816 ↓ 26.0 26 1

Nested Loop (cost=41,509.45..42,108.98 rows=1 width=76) (actual time=11,951.956..11,955.816 rows=26 loops=1)

47. 0.961 11,953.960 ↓ 26.0 26 1

Nested Loop (cost=41,509.16..42,108.65 rows=1 width=24) (actual time=11,951.843..11,953.960 rows=26 loops=1)

  • Join Filter: ((min((eve_1.event_code)::text)) = (eve.event_code)::text)
48. 2.384 11,952.505 ↑ 1.9 26 1

Hash Join (cost=41,508.88..42,092.98 rows=49 width=64) (actual time=11,951.782..11,952.505 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.608 6,737.540 ↑ 622.5 25 1

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

  • Group Key: o_his_1.machine_id, o_his_1.acquisition_time
50. 0.561 6,736.932 ↑ 598.6 26 1

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

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

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

52. 418.405 5,831.114 ↑ 1.0 22,981 1

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

  • Hash Cond: (o_loc_1.event_history_id = o_his_1.id)
53. 214.345 214.345 ↑ 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.081..214.345 rows=22,981 loops=1)

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

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

  • Buckets: 65536 Batches: 1 Memory Usage: 18246kB
55. 2,532.161 2,532.161 ↑ 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.013..2,532.161 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. 93.075 181.390 ↑ 1.0 10,187 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 479kB
58. 88.315 88.315 ↑ 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.015..88.315 rows=10,187 loops=1)

59. 2,679.859 5,212.581 ↑ 1.2 291,933 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 18246kB
60. 2,532.722 2,532.722 ↑ 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.014..2,532.722 rows=291,933 loops=1)

61. 0.494 0.494 ↑ 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.019 rows=1 loops=26)

  • Index Cond: (id = o_his.event_id)
62. 0.962 0.962 ↑ 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.027..0.037 rows=1 loops=26)

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

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

64. 0.017 10,697.790 ↓ 0.0 0 1

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

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

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

66. 0.017 10,697.756 ↓ 0.0 0 1

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

67. 0.017 10,697.739 ↓ 0.0 0 1

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

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

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

69. 8.331 10,684.634 ↓ 445.0 445 1

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

70. 8.237 10,676.303 ↓ 445.0 445 1

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

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

Nested Loop (cost=18,717.15..20,106.92 rows=1 width=25) (actual time=10,541.858..10,668.066 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.816 10,619.950 ↓ 445.0 445 1

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

73. 15.746 10,595.679 ↓ 445.0 445 1

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

74. 15.667 10,571.033 ↓ 445.0 445 1

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

75. 2,572.109 10,545.598 ↓ 1.4 444 1

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

  • Group Key: foreve_1.machine_id
76. 5,115.716 7,973.489 ↑ 1.2 291,933 1

Hash Join (cost=547.36..16,991.73 rows=344,917 width=16) (actual time=357.317..7,973.489 rows=291,933 loops=1)

  • Hash Cond: (foreve_1.event_id = eve_3.id)
77. 2,500.579 2,500.579 ↑ 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,500.579 rows=291,933 loops=1)

78. 92.046 357.194 ↑ 1.0 10,187 1

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

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

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

  • Hash Cond: (eve_3.event_level_id = cqel_2.id)
80. 87.428 87.428 ↑ 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.428 rows=10,187 loops=1)

81. 0.051 0.097 ↑ 1.0 4 1

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

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

Seq Scan on cq_event_levels cqel_2 (cost=0.00..1.04 rows=4 width=8) (actual time=0.010..0.046 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.013..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.900 8.900 ↑ 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.020 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.470 20.470 ↑ 25.0 4 445

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.010..0.046 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.577 18,128.589 ↓ 1.2 529 1

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

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

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

94. 9,216.350 18,112.232 ↓ 1.0 453 1

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

  • Group Key: cq_communication_history.terminal_id
95. 8,895.882 8,895.882 ↑ 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.019..8,895.882 rows=1,035,283 loops=1)

96. 4.776 9.464 ↑ 1.0 540 1

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

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

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