explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9c4Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.127 9,738.078 ↑ 1.5 628 1

Append (cost=2.83..1,029,365.41 rows=916 width=452) (actual time=0.520..9,738.078 rows=628 loops=1)

2. 0.495 9,737.938 ↑ 1.5 628 1

Result (cost=2.83..1,029,340.19 rows=915 width=452) (actual time=0.520..9,737.938 rows=628 loops=1)

3. 0.165 9,737.443 ↑ 1.5 628 1

Append (cost=2.83..1,029,340.19 rows=915 width=452) (actual time=0.517..9,737.443 rows=628 loops=1)

4. 0.503 5.048 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.83..289.64 rows=1 width=452) (actual time=0.516..5.048 rows=11 loops=1)

5. 0.022 0.244 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.40..50.32 rows=1 width=396) (actual time=0.043..0.244 rows=11 loops=1)

6. 0.017 0.134 ↓ 11.0 11 1

Nested Loop Left Join (cost=1.98..41.87 rows=1 width=353) (actual time=0.031..0.134 rows=11 loops=1)

7. 0.019 0.117 ↓ 11.0 11 1

Nested Loop Left Join (cost=1.70..33.56 rows=1 width=353) (actual time=0.029..0.117 rows=11 loops=1)

8. 0.012 0.098 ↓ 11.0 11 1

Nested Loop Left Join (cost=1.42..26.62 rows=1 width=335) (actual time=0.026..0.098 rows=11 loops=1)

9. 0.015 0.086 ↓ 11.0 11 1

Nested Loop Left Join (cost=1.14..20.12 rows=1 width=320) (actual time=0.025..0.086 rows=11 loops=1)

10. 0.036 0.071 ↓ 11.0 11 1

Nested Loop Left Join (cost=0.72..12.77 rows=1 width=307) (actual time=0.023..0.071 rows=11 loops=1)

11. 0.035 0.035 ↓ 11.0 11 1

Index Scan using call_event_active_index on call_event (cost=0.43..4.45 rows=1 width=301) (actual time=0.017..0.035 rows=11 loops=1)

  • Index Cond: (is_active = 1::numeric)
12. 0.000 0.000 ↓ 0.0 0 11

Index Scan using full_adress_sys_c0042551 on full_adress (cost=0.29..8.31 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=11)

  • Index Cond: (id = call_event.id_full_adress)
13. 0.000 0.000 ↓ 0.0 0 11

Index Scan using base_adress_main_idx on base_adress (cost=0.42..7.34 rows=1 width=19) (actual time=0.000..0.000 rows=0 loops=11)

  • Index Cond: (full_adress.id_base_adress = id)
14. 0.000 0.000 ↓ 0.0 0 11

Index Scan using city_sys_c0042422 on city (cost=0.28..6.49 rows=1 width=25) (actual time=0.000..0.000 rows=0 loops=11)

  • Index Cond: (id = base_adress.id_city)
15. 0.000 0.000 ↓ 0.0 0 11

Index Scan using street_sys_c0042497 on street (cost=0.28..6.93 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=11)

  • Index Cond: (id = base_adress.id_street)
16. 0.000 0.000 ↓ 0.0 0 11

Index Scan using objects_sys_c0042470 on objects o (cost=0.28..8.30 rows=1 width=5) (actual time=0.000..0.000 rows=0 loops=11)

  • Index Cond: (call_event.id_object = id)
  • Filter: (deleted <> 1::numeric)
17. 0.088 0.088 ↑ 1.0 1 11

Index Scan using arm03_pat_ass_idx1 on arm03_patient_assistance apa (cost=0.42..8.44 rows=1 width=49) (actual time=0.008..0.008 rows=1 loops=11)

  • Index Cond: (call_event.id = id)
18. 0.088 0.088 ↑ 1.0 1 11

Index Scan using arm03_call_call_idx on arm03_call ac (cost=0.43..8.45 rows=1 width=62) (actual time=0.008..0.008 rows=1 loops=11)

  • Index Cond: (call_event.id = id_call)
19.          

SubPlan (forNested Loop Left Join)

20. 0.011 0.044 ↓ 0.0 0 11

Limit (cost=0.29..8.31 rows=1 width=6) (actual time=0.004..0.004 rows=0 loops=11)

21. 0.033 0.033 ↓ 0.0 0 11

Index Scan using history_events_idx_5 on history_events history_events_3 (cost=0.29..8.31 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=11)

  • Index Cond: (id_call = call_event.id)
22. 0.011 0.187 ↓ 0.0 0 11

Subquery Scan on rcv_time1_1 (cost=8.52..8.53 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=11)

23. 0.000 0.176 ↓ 0.0 0 11

Limit (cost=8.52..8.52 rows=1 width=20) (actual time=0.016..0.016 rows=0 loops=11)

24. 0.066 0.176 ↓ 0.0 0 11

Sort (cost=8.52..8.53 rows=2 width=20) (actual time=0.016..0.016 rows=0 loops=11)

  • Sort Key: call_tech_3.id
  • Sort Method: top-N heapsort Memory: 25kB
25. 0.110 0.110 ↑ 1.0 2 11

Index Scan using call_tech_idx on call_tech call_tech_3 (cost=0.42..8.51 rows=2 width=20) (actual time=0.007..0.010 rows=2 loops=11)

  • Index Cond: (id_call = call_event.id)
26. 0.011 0.066 ↑ 1.0 1 11

Aggregate (cost=8.52..8.53 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=11)

27. 0.055 0.055 ↑ 2.0 1 11

Index Scan using call_tech_idx on call_tech call_tech_4 (cost=0.42..8.51 rows=2 width=8) (actual time=0.004..0.005 rows=1 loops=11)

  • Index Cond: (id_call = call_event.id)
  • Filter: (at_place_time IS NOT NULL)
  • Rows Removed by Filter: 1
28. 0.000 0.022 ↓ 0.0 0 11

Limit (cost=0.29..8.31 rows=1 width=5) (actual time=0.002..0.002 rows=0 loops=11)

29. 0.022 0.022 ↓ 0.0 0 11

Index Scan using history_events_idx_5 on history_events history_events_4 (cost=0.29..8.31 rows=1 width=5) (actual time=0.002..0.002 rows=0 loops=11)

  • Index Cond: (id_call = call_event.id)
30. 0.011 0.550 ↓ 0.0 0 11

Limit (cost=0.42..13.04 rows=1 width=6) (actual time=0.050..0.050 rows=0 loops=11)

31. 0.094 0.539 ↓ 0.0 0 11

Index Only Scan using call_tech_idx on call_tech call_tech_5 (cost=0.42..25.66 rows=2 width=6) (actual time=0.049..0.049 rows=0 loops=11)

  • Index Cond: (id_call = call_event.id)
  • Heap Fetches: 5
32.          

SubPlan (forIndex Only Scan)

33. 0.395 0.445 ↑ 1.0 1 5

Aggregate (cost=8.57..8.58 rows=1 width=83) (actual time=0.089..0.089 rows=1 loops=5)

34. 0.050 0.050 ↓ 2.0 4 5

Index Scan using call_tech_idx on call_tech ct_1 (cost=0.42..8.52 rows=2 width=83) (actual time=0.006..0.010 rows=4 loops=5)

  • Index Cond: (id_call = call_tech_5.id_call)
  • Filter: (tech_deleted = 0::numeric)
35. 0.121 0.385 ↑ 1.0 1 11

Index Only Scan using arm03_call_call_idx on arm03_call arm03_call_1 (cost=8.89..16.91 rows=1 width=0) (actual time=0.035..0.035 rows=1 loops=11)

  • Index Cond: (id_call = call_event.id)
  • Heap Fetches: 11
36.          

Initplan (forIndex Only Scan)

37. 0.220 0.264 ↑ 1.0 1 11

Aggregate (cost=8.45..8.46 rows=1 width=53) (actual time=0.024..0.024 rows=1 loops=11)

38. 0.044 0.044 ↑ 1.0 1 11

Index Scan using arm03_call_call_idx on arm03_call a_data_1 (cost=0.43..8.45 rows=1 width=53) (actual time=0.004..0.004 rows=1 loops=11)

  • Index Cond: (id_call = call_event.id)
39. 0.022 0.088 ↑ 1.0 1 11

Limit (cost=0.00..1.34 rows=1 width=20) (actual time=0.008..0.008 rows=1 loops=11)

40. 0.066 0.066 ↑ 1.0 1 11

Seq Scan on event_type event_type_1 (cost=0.00..1.34 rows=1 width=20) (actual time=0.006..0.006 rows=1 loops=11)

  • Filter: (id = call_event.id_event_type)
  • Rows Removed by Filter: 12
41. 0.011 0.077 ↓ 0.0 0 11

Limit (cost=0.14..10.51 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=11)

42. 0.011 0.066 ↓ 0.0 0 11

Nested Loop Semi Join (cost=0.14..10.51 rows=1 width=20) (actual time=0.006..0.006 rows=0 loops=11)

43. 0.055 0.055 ↓ 0.0 0 11

Seq Scan on call_result_value call_result_value_1 (cost=0.00..1.16 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=11)

  • Filter: (id_call = call_event.id)
  • Rows Removed by Filter: 13
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using event_list_field_set_idx on event_list_field_set event_list_field_set_1 (cost=0.14..8.16 rows=1 width=20) (never executed)

  • Index Cond: (id_adv_field = call_result_value_1.id_field)
  • Heap Fetches: 0
45.          

SubPlan (forNested Loop Semi Join)

46. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=1.17..1.18 rows=1 width=536) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_result_value crv_1 (cost=0.00..1.16 rows=1 width=536) (never executed)

  • Filter: (id_call = call_result_value_1.id_call)
48. 0.011 0.099 ↓ 0.0 0 11

Limit (cost=0.43..2.53 rows=1 width=11) (actual time=0.009..0.009 rows=0 loops=11)

49. 0.088 0.088 ↓ 0.0 0 11

Index Scan using ref_call_event_sound_idx on ref_call_event_sound ref_call_event_sound_1 (cost=0.43..25.67 rows=12 width=11) (actual time=0.008..0.008 rows=0 loops=11)

  • Index Cond: (id_call_event = call_event.id)
  • Filter: (is_out <> 1::numeric)
  • Rows Removed by Filter: 0
50. 0.011 0.044 ↓ 0.0 0 11

Limit (cost=0.28..8.29 rows=1 width=6) (actual time=0.004..0.004 rows=0 loops=11)

51. 0.033 0.033 ↓ 0.0 0 11

Index Scan using linked_event_idx on linked_event linked_event_1 (cost=0.28..8.29 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=11)

  • Index Cond: (id = call_event.id)
52. 0.011 0.044 ↑ 1.0 1 11

Aggregate (cost=8.29..8.30 rows=1 width=35) (actual time=0.004..0.004 rows=1 loops=11)

53. 0.033 0.033 ↓ 0.0 0 11

Index Scan using linked_event_call_idx on linked_event l_event_1 (cost=0.28..8.29 rows=1 width=35) (actual time=0.003..0.003 rows=0 loops=11)

  • Index Cond: (id_call = call_event.id)
54. 0.011 0.033 ↑ 1.0 1 11

Aggregate (cost=12.65..12.66 rows=1 width=44) (actual time=0.003..0.003 rows=1 loops=11)

55. 0.011 0.022 ↓ 0.0 0 11

Bitmap Heap Scan on ref_call_staff ref_call_staff_1 (cost=4.18..12.64 rows=4 width=44) (actual time=0.002..0.002 rows=0 loops=11)

  • Recheck Cond: (id_call = call_event.id)
56. 0.011 0.011 ↓ 0.0 0 11

Bitmap Index Scan on ref_call_staff_pk (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=11)

  • Index Cond: (id_call = call_event.id)
57. 0.275 0.594 ↑ 1.0 1 11

Aggregate (cost=7.31..7.32 rows=1 width=147) (actual time=0.054..0.054 rows=1 loops=11)

58. 0.022 0.319 ↑ 1.0 1 11

Limit (cost=0.43..7.30 rows=1 width=188) (actual time=0.029..0.029 rows=1 loops=11)

59. 0.011 0.297 ↑ 2.0 1 11

Nested Loop (cost=0.43..14.16 rows=2 width=188) (actual time=0.027..0.027 rows=1 loops=11)

  • Join Filter: (call_info_1.id_oper = user_pult_1.id_user)
60. 0.044 0.044 ↑ 99.0 1 11

Seq Scan on user_pult user_pult_1 (cost=0.00..1.99 rows=99 width=8) (actual time=0.004..0.004 rows=1 loops=11)

61. 0.033 0.242 ↑ 2.0 1 11

Materialize (cost=0.43..9.21 rows=2 width=185) (actual time=0.022..0.022 rows=1 loops=11)

62. 0.209 0.209 ↑ 2.0 1 11

Index Scan using call_info_idx on call_info call_info_1 (cost=0.43..9.20 rows=2 width=185) (actual time=0.019..0.019 rows=1 loops=11)

  • Index Cond: (id_call = call_event.id)
  • Filter: (id_pult IS NULL)
  • Rows Removed by Filter: 1
63. 0.000 1.925 ↑ 1.0 1 11

Limit (cost=115.24..115.25 rows=1 width=151) (actual time=0.175..0.175 rows=1 loops=11)

64. 0.187 1.925 ↑ 1.0 1 11

Aggregate (cost=115.24..115.25 rows=1 width=151) (actual time=0.175..0.175 rows=1 loops=11)

65. 0.011 1.738 ↑ 1.0 1 11

Nested Loop (cost=0.72..115.23 rows=1 width=151) (actual time=0.047..0.158 rows=1 loops=11)

66. 1.672 1.672 ↑ 1.0 1 11

Index Scan using call_action_idx on call_action call_action_1 (cost=0.43..106.92 rows=1 width=77) (actual time=0.042..0.152 rows=1 loops=11)

  • Index Cond: (id_call = call_event.id)
  • Filter: ((id_pult IS NULL) AND (id_action = 65038::numeric) AND (action_deleted = 0::numeric))
  • Rows Removed by Filter: 208
67. 0.055 0.055 ↑ 1.0 1 11

Index Scan using standart_phrases_idx on standart_phrases standart_phrases_1 (cost=0.28..8.30 rows=1 width=80) (actual time=0.004..0.005 rows=1 loops=11)

  • Index Cond: (id = 65038::numeric)
68. 0.022 0.055 ↑ 1.0 1 11

Aggregate (cost=1.01..1.02 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=11)

69. 0.033 0.033 ↓ 0.0 0 11

Seq Scan on glonass_event_info glonass_event_info_1 (cost=0.00..1.01 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=11)

  • Filter: (id_call = call_event.id)
  • Rows Removed by Filter: 1
70. 257.478 9,732.230 ↑ 1.5 617 1

Hash Semi Join (cost=158,517.05..1,029,041.40 rows=914 width=452) (actual time=3,736.401..9,732.230 rows=617 loops=1)

  • Hash Cond: (call_event_1.id = ref_pult_event.id_call)
71. 2,803.766 9,398.223 ↓ 1.0 1,747,122 1

Hash Left Join (cost=157,652.59..812,302.32 rows=1,747,109 width=452) (actual time=2,264.098..9,398.223 rows=1,747,122 loops=1)

  • Hash Cond: (call_event_1.id = ac_1.id_call)
72. 410.351 5,215.753 ↓ 1.0 1,747,122 1

Hash Left Join (cost=56,236.57..484,117.75 rows=1,747,109 width=396) (actual time=885.367..5,215.753 rows=1,747,122 loops=1)

  • Hash Cond: (call_event_1.id_object = o_1.id)
73. 652.913 4,803.465 ↓ 1.0 1,747,122 1

Hash Left Join (cost=55,994.12..472,769.36 rows=1,747,109 width=396) (actual time=883.411..4,803.465 rows=1,747,122 loops=1)

  • Hash Cond: (call_event_1.id_full_adress = full_adress_1.id)
74. 2,327.044 3,807.402 ↓ 1.0 1,747,122 1

Hash Left Join (cost=38,590.88..284,834.57 rows=1,747,109 width=344) (actual time=540.240..3,807.402 rows=1,747,122 loops=1)

  • Hash Cond: (call_event_1.id = apa_1.id)
75. 941.743 941.743 ↓ 1.0 1,747,122 1

Seq Scan on call_event call_event_1 (cost=0.00..78,320.09 rows=1,747,109 width=301) (actual time=0.026..941.743 rows=1,747,122 loops=1)

76. 233.678 538.615 ↑ 1.0 861,664 1

Hash (cost=19,330.17..19,330.17 rows=865,017 width=49) (actual time=538.615..538.615 rows=861,664 loops=1)

  • Buckets: 2048 Batches: 128 Memory Usage: 264kB
77. 304.937 304.937 ↑ 1.0 861,664 1

Seq Scan on arm03_patient_assistance apa_1 (cost=0.00..19,330.17 rows=865,017 width=49) (actual time=0.005..304.937 rows=861,664 loops=1)

78. 40.960 343.150 ↑ 1.0 98,028 1

Hash (cost=15,118.56..15,118.56 rows=98,294 width=58) (actual time=343.150..343.150 rows=98,028 loops=1)

  • Buckets: 2048 Batches: 16 Memory Usage: 581kB
79. 53.604 302.190 ↑ 1.0 98,028 1

Hash Left Join (cost=6,784.79..15,118.56 rows=98,294 width=58) (actual time=84.530..302.190 rows=98,028 loops=1)

  • Hash Cond: (base_adress_1.id_street = street_1.id)
80. 45.901 247.464 ↑ 1.0 98,028 1

Hash Left Join (cost=6,702.23..13,438.72 rows=98,294 width=40) (actual time=83.399..247.464 rows=98,028 loops=1)

  • Hash Cond: (base_adress_1.id_city = city_1.id)
81. 103.812 201.282 ↑ 1.0 98,028 1

Hash Left Join (cost=6,681.91..12,066.86 rows=98,294 width=25) (actual time=83.105..201.282 rows=98,028 loops=1)

  • Hash Cond: (full_adress_1.id_base_adress = base_adress_1.id)
82. 14.554 14.554 ↑ 1.0 98,028 1

Seq Scan on full_adress full_adress_1 (cost=0.00..1,588.94 rows=98,294 width=12) (actual time=0.006..14.554 rows=98,028 loops=1)

83. 50.444 82.916 ↑ 1.0 169,418 1

Hash (cost=3,571.18..3,571.18 rows=169,418 width=19) (actual time=82.916..82.916 rows=169,418 loops=1)

  • Buckets: 2048 Batches: 16 Memory Usage: 545kB
84. 32.472 32.472 ↑ 1.0 169,418 1

Seq Scan on base_adress base_adress_1 (cost=0.00..3,571.18 rows=169,418 width=19) (actual time=0.004..32.472 rows=169,418 loops=1)

85. 0.163 0.281 ↑ 1.0 681 1

Hash (cost=11.81..11.81 rows=681 width=25) (actual time=0.281..0.281 rows=681 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
86. 0.118 0.118 ↑ 1.0 681 1

Seq Scan on city city_1 (cost=0.00..11.81 rows=681 width=25) (actual time=0.006..0.118 rows=681 loops=1)

87. 0.652 1.122 ↑ 1.0 2,736 1

Hash (cost=48.36..48.36 rows=2,736 width=28) (actual time=1.122..1.122 rows=2,736 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 162kB
88. 0.470 0.470 ↑ 1.0 2,736 1

Seq Scan on street street_1 (cost=0.00..48.36 rows=2,736 width=28) (actual time=0.005..0.470 rows=2,736 loops=1)

89. 0.624 1.937 ↑ 1.0 3,045 1

Hash (cost=203.91..203.91 rows=3,083 width=5) (actual time=1.937..1.937 rows=3,045 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 111kB
90. 1.313 1.313 ↑ 1.0 3,045 1

Seq Scan on objects o_1 (cost=0.00..203.91 rows=3,083 width=5) (actual time=0.019..1.313 rows=3,045 loops=1)

  • Filter: (deleted <> 1::numeric)
  • Rows Removed by Filter: 188
91. 500.478 1,378.704 ↑ 1.0 1,683,740 1

Hash (cost=62,203.12..62,203.12 rows=1,687,112 width=62) (actual time=1,378.704..1,378.704 rows=1,683,740 loops=1)

  • Buckets: 2048 Batches: 256 Memory Usage: 461kB
92. 878.226 878.226 ↑ 1.0 1,683,740 1

Seq Scan on arm03_call ac_1 (cost=0.00..62,203.12 rows=1,687,112 width=62) (actual time=0.018..878.226 rows=1,683,740 loops=1)

93. 0.350 1.255 ↑ 1.0 876 1

Hash (cost=853.03..853.03 rows=914 width=6) (actual time=1.255..1.255 rows=876 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
94. 0.905 0.905 ↑ 1.0 876 1

Index Scan using ref_pult_event_state_index on ref_pult_event (cost=0.28..853.03 rows=914 width=6) (actual time=0.015..0.905 rows=876 loops=1)

95.          

SubPlan (forHash Semi Join)

96. 0.000 1.851 ↓ 0.0 0 617

Limit (cost=0.29..8.31 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=617)

97. 1.851 1.851 ↓ 0.0 0 617

Index Scan using history_events_idx_5 on history_events history_events_1 (cost=0.29..8.31 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
98. 0.617 6.170 ↓ 0.0 0 617

Subquery Scan on rcv_time1 (cost=8.52..8.53 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=617)

99. 0.000 5.553 ↓ 0.0 0 617

Limit (cost=8.52..8.52 rows=1 width=20) (actual time=0.009..0.009 rows=0 loops=617)

100. 2.468 5.553 ↓ 0.0 0 617

Sort (cost=8.52..8.53 rows=2 width=20) (actual time=0.009..0.009 rows=0 loops=617)

  • Sort Key: call_tech.id
  • Sort Method: quicksort Memory: 25kB
101. 3.085 3.085 ↑ 2.0 1 617

Index Scan using call_tech_idx on call_tech (cost=0.42..8.51 rows=2 width=20) (actual time=0.004..0.005 rows=1 loops=617)

  • Index Cond: (id_call = call_event_1.id)
102. 0.617 1.851 ↑ 1.0 1 617

Aggregate (cost=8.52..8.53 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=617)

103. 1.234 1.234 ↓ 0.0 0 617

Index Scan using call_tech_idx on call_tech call_tech_1 (cost=0.42..8.51 rows=2 width=8) (actual time=0.002..0.002 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
  • Filter: (at_place_time IS NOT NULL)
  • Rows Removed by Filter: 0
104. 0.000 0.617 ↓ 0.0 0 617

Limit (cost=0.29..8.31 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=617)

105. 0.617 0.617 ↓ 0.0 0 617

Index Scan using history_events_idx_5 on history_events history_events_2 (cost=0.29..8.31 rows=1 width=5) (actual time=0.001..0.001 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
106. 0.617 7.404 ↓ 0.0 0 617

Limit (cost=0.42..13.04 rows=1 width=6) (actual time=0.012..0.012 rows=0 loops=617)

107. 1.973 6.787 ↓ 0.0 0 617

Index Only Scan using call_tech_idx on call_tech call_tech_2 (cost=0.42..25.66 rows=2 width=6) (actual time=0.011..0.011 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
  • Heap Fetches: 172
108.          

SubPlan (forIndex Only Scan)

109. 4.150 4.814 ↑ 1.0 1 166

Aggregate (cost=8.57..8.58 rows=1 width=83) (actual time=0.029..0.029 rows=1 loops=166)

110. 0.664 0.664 ↑ 1.0 2 166

Index Scan using call_tech_idx on call_tech ct (cost=0.42..8.52 rows=2 width=83) (actual time=0.003..0.004 rows=2 loops=166)

  • Index Cond: (id_call = call_tech_2.id_call)
  • Filter: (tech_deleted = 0::numeric)
111. 6.170 15.425 ↑ 1.0 1 617

Index Only Scan using arm03_call_call_idx on arm03_call (cost=8.89..16.91 rows=1 width=0) (actual time=0.025..0.025 rows=1 loops=617)

  • Index Cond: (id_call = call_event_1.id)
  • Heap Fetches: 617
112.          

Initplan (forIndex Only Scan)

113. 7.404 9.255 ↑ 1.0 1 617

Aggregate (cost=8.45..8.46 rows=1 width=53) (actual time=0.015..0.015 rows=1 loops=617)

114. 1.851 1.851 ↑ 1.0 1 617

Index Scan using arm03_call_call_idx on arm03_call a_data (cost=0.43..8.45 rows=1 width=53) (actual time=0.002..0.003 rows=1 loops=617)

  • Index Cond: (id_call = call_event_1.id)
115. 0.617 3.702 ↑ 1.0 1 617

Limit (cost=0.00..1.34 rows=1 width=20) (actual time=0.006..0.006 rows=1 loops=617)

116. 3.085 3.085 ↑ 1.0 1 617

Seq Scan on event_type (cost=0.00..1.34 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=617)

  • Filter: (id = call_event_1.id_event_type)
  • Rows Removed by Filter: 20
117. 0.617 2.468 ↓ 0.0 0 617

Limit (cost=0.14..10.51 rows=1 width=20) (actual time=0.004..0.004 rows=0 loops=617)

118. 0.000 1.851 ↓ 0.0 0 617

Nested Loop Semi Join (cost=0.14..10.51 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=617)

119. 1.851 1.851 ↓ 0.0 0 617

Seq Scan on call_result_value (cost=0.00..1.16 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=617)

  • Filter: (id_call = call_event_1.id)
  • Rows Removed by Filter: 13
120. 0.000 0.000 ↓ 0.0 0

Index Only Scan using event_list_field_set_idx on event_list_field_set (cost=0.14..8.16 rows=1 width=20) (never executed)

  • Index Cond: (id_adv_field = call_result_value.id_field)
  • Heap Fetches: 0
121.          

SubPlan (forNested Loop Semi Join)

122. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=1.17..1.18 rows=1 width=536) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on call_result_value crv (cost=0.00..1.16 rows=1 width=536) (never executed)

  • Filter: (id_call = call_result_value.id_call)
124. 0.617 3.085 ↓ 0.0 0 617

Limit (cost=0.43..2.53 rows=1 width=11) (actual time=0.005..0.005 rows=0 loops=617)

125. 2.468 2.468 ↓ 0.0 0 617

Index Scan using ref_call_event_sound_idx on ref_call_event_sound (cost=0.43..25.67 rows=12 width=11) (actual time=0.004..0.004 rows=0 loops=617)

  • Index Cond: (id_call_event = call_event_1.id)
  • Filter: (is_out <> 1::numeric)
  • Rows Removed by Filter: 0
126. 0.000 1.234 ↓ 0.0 0 617

Limit (cost=0.28..8.29 rows=1 width=6) (actual time=0.002..0.002 rows=0 loops=617)

127. 1.234 1.234 ↓ 0.0 0 617

Index Scan using linked_event_idx on linked_event (cost=0.28..8.29 rows=1 width=6) (actual time=0.002..0.002 rows=0 loops=617)

  • Index Cond: (id = call_event_1.id)
128. 0.000 1.234 ↑ 1.0 1 617

Aggregate (cost=8.29..8.30 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=617)

129. 1.234 1.234 ↓ 0.0 0 617

Index Scan using linked_event_call_idx on linked_event l_event (cost=0.28..8.29 rows=1 width=35) (actual time=0.002..0.002 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
130. 0.617 1.234 ↑ 1.0 1 617

Aggregate (cost=12.65..12.66 rows=1 width=44) (actual time=0.002..0.002 rows=1 loops=617)

131. 0.000 0.617 ↓ 0.0 0 617

Bitmap Heap Scan on ref_call_staff (cost=4.18..12.64 rows=4 width=44) (actual time=0.001..0.001 rows=0 loops=617)

  • Recheck Cond: (id_call = call_event_1.id)
132. 0.617 0.617 ↓ 0.0 0 617

Bitmap Index Scan on ref_call_staff_pk (cost=0.00..4.18 rows=4 width=0) (actual time=0.001..0.001 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
133. 3.085 19.127 ↑ 1.0 1 617

Aggregate (cost=7.31..7.32 rows=1 width=147) (actual time=0.031..0.031 rows=1 loops=617)

134. 0.617 16.042 ↓ 0.0 0 617

Limit (cost=0.43..7.30 rows=1 width=188) (actual time=0.026..0.026 rows=0 loops=617)

135. 11.106 15.425 ↓ 0.0 0 617

Nested Loop (cost=0.43..14.16 rows=2 width=188) (actual time=0.025..0.025 rows=0 loops=617)

  • Join Filter: (call_info.id_oper = user_pult.id_user)
  • Rows Removed by Join Filter: 1
136. 4.319 4.319 ↑ 1.1 87 617

Seq Scan on user_pult (cost=0.00..1.99 rows=99 width=8) (actual time=0.002..0.007 rows=87 loops=617)

137. 0.000 0.000 ↓ 0.0 0 53,520

Materialize (cost=0.43..9.21 rows=2 width=185) (actual time=0.000..0.000 rows=0 loops=53,520)

138. 3.085 3.085 ↓ 0.0 0 617

Index Scan using call_info_idx on call_info (cost=0.43..9.20 rows=2 width=185) (actual time=0.005..0.005 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
  • Filter: (id_pult IS NULL)
  • Rows Removed by Filter: 1
139. 0.617 8.638 ↑ 1.0 1 617

Limit (cost=115.24..115.25 rows=1 width=151) (actual time=0.014..0.014 rows=1 loops=617)

140. 0.617 8.021 ↑ 1.0 1 617

Aggregate (cost=115.24..115.25 rows=1 width=151) (actual time=0.013..0.013 rows=1 loops=617)

141. 0.371 7.404 ↓ 0.0 0 617

Nested Loop (cost=0.72..115.23 rows=1 width=151) (actual time=0.009..0.012 rows=0 loops=617)

142. 6.787 6.787 ↓ 0.0 0 617

Index Scan using call_action_idx on call_action (cost=0.43..106.92 rows=1 width=77) (actual time=0.009..0.011 rows=0 loops=617)

  • Index Cond: (id_call = call_event_1.id)
  • Filter: ((id_pult IS NULL) AND (id_action = 65038::numeric) AND (action_deleted = 0::numeric))
  • Rows Removed by Filter: 10
143. 0.246 0.246 ↑ 1.0 1 82

Index Scan using standart_phrases_idx on standart_phrases (cost=0.28..8.30 rows=1 width=80) (actual time=0.003..0.003 rows=1 loops=82)

  • Index Cond: (id = 65038::numeric)
144. 0.617 1.234 ↑ 1.0 1 617

Aggregate (cost=1.01..1.02 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=617)

145. 0.617 0.617 ↓ 0.0 0 617

Seq Scan on glonass_event_info (cost=0.00..1.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=617)

  • Filter: (id_call = call_event_1.id)
  • Rows Removed by Filter: 1
146. 0.001 0.013 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=2.11..25.22 rows=1 width=128) (actual time=0.013..0.013 rows=0 loops=1)

147. 0.000 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.11..25.21 rows=1 width=128) (actual time=0.012..0.012 rows=0 loops=1)

148. 0.001 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.84..16.91 rows=1 width=123) (actual time=0.012..0.012 rows=0 loops=1)

149. 0.000 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.56..16.60 rows=1 width=105) (actual time=0.011..0.011 rows=0 loops=1)

150. 0.001 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..16.30 rows=1 width=90) (actual time=0.011..0.011 rows=0 loops=1)

151. 0.000 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.86..15.76 rows=1 width=83) (actual time=0.010..0.010 rows=0 loops=1)

152. 0.000 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.57..14.37 rows=1 width=83) (actual time=0.010..0.010 rows=0 loops=1)

153. 0.010 0.010 ↓ 0.0 0 1

Index Scan using history_events_new_idx_call_i on history_events (cost=0.29..6.06 rows=1 width=77) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((is_active = 1::numeric) AND (id_call IS NULL))
154. 0.000 0.000 ↓ 0.0 0

Index Scan using objects_sys_c0042470 on objects (cost=0.28..8.30 rows=1 width=11) (never executed)

  • Index Cond: (history_events.id_object = id)
155. 0.000 0.000 ↓ 0.0 0

Index Scan using full_adress_sys_c0042551 on full_adress full_adress_2 (cost=0.29..1.38 rows=1 width=12) (never executed)

  • Index Cond: (id = objects.id_full_adress)
156. 0.000 0.000 ↓ 0.0 0

Index Scan using base_adress_main_idx on base_adress base_adress_2 (cost=0.42..0.53 rows=1 width=19) (never executed)

  • Index Cond: (full_adress_2.id_base_adress = id)
157. 0.000 0.000 ↓ 0.0 0

Index Scan using city_sys_c0042422 on city city_2 (cost=0.28..0.29 rows=1 width=25) (never executed)

  • Index Cond: (id = base_adress_2.id_city)
158. 0.000 0.000 ↓ 0.0 0

Index Scan using street_sys_c0042497 on street street_2 (cost=0.28..0.30 rows=1 width=28) (never executed)

  • Index Cond: (id = base_adress_2.id_street)
159. 0.000 0.000 ↓ 0.0 0

Index Scan using rank_sys_c0042610 on rank r (cost=0.28..8.29 rows=1 width=10) (never executed)

  • Index Cond: (history_events.id_rank = id)