explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ceqx

Settings
# exclusive inclusive rows x rows loops node
1. 2.366 21,076.712 ↑ 2,721.6 321 1

Sort (cost=164,820,399.01..164,822,583.08 rows=873,627 width=4,201) (actual time=21,076.681..21,076.712 rows=321 loops=1)

  • Sort Key: "*SELECT* 1".id, "*SELECT* 1".id_call
  • Sort Method: quicksort Memory: 450kB
2. 2.853 21,074.346 ↑ 2,721.6 321 1

Hash Left Join (cost=419,614.70..156,836,121.62 rows=873,627 width=4,201) (actual time=19,947.412..21,074.346 rows=321 loops=1)

  • Hash Cond: ("*SELECT* 1".id_call = ese.id_call)
3. 1,145.966 21,060.135 ↑ 2,721.6 321 1

Hash Left Join (cost=419,608.31..130,315,380.65 rows=873,627 width=4,196) (actual time=19,947.217..21,060.135 rows=321 loops=1)

  • Hash Cond: ("*SELECT* 1".id_call = call_event.id)
4. 50.182 5,605.112 ↑ 2,721.6 321 1

Hash Left Join (cost=196,587.12..129,171,501.05 rows=873,627 width=3,653) (actual time=3,079.525..5,605.112 rows=321 loops=1)

  • Hash Cond: ("*SELECT* 1".id_address = ba.id)
5. 0.130 5,493.705 ↑ 2,721.6 321 1

Append (cost=190,070.22..128,355,845.37 rows=873,627 width=452) (actual time=3,018.288..5,493.705 rows=321 loops=1)

6. 0.496 5,493.554 ↑ 2,721.6 321 1

Subquery Scan on *SELECT* 1 (cost=190,070.22..128,355,820.14 rows=873,626 width=452) (actual time=3,018.286..5,493.554 rows=321 loops=1)

7. 14.400 5,493.058 ↑ 2,721.6 321 1

Hash Left Join (cost=190,070.22..128,347,083.88 rows=873,626 width=452) (actual time=3,018.284..5,493.058 rows=321 loops=1)

  • Hash Cond: (call_event_1.id_object = o.id)
8. 71.104 5,372.233 ↑ 2,721.6 321 1

Hash Left Join (cost=189,827.77..538,025.14 rows=873,626 width=452) (actual time=3,002.650..5,372.233 rows=321 loops=1)

  • Hash Cond: (call_event_1.id_full_adress = full_adress.id)
9. 554.771 5,047.366 ↑ 2,721.6 321 1

Hash Left Join (cost=172,424.53..422,877.61 rows=873,626 width=400) (actual time=2,748.842..5,047.366 rows=321 loops=1)

  • Hash Cond: (call_event_1.id = apa.id)
10. 2,260.068 4,095.910 ↑ 2,721.6 321 1

Hash Right Join (cost=133,819.36..284,130.57 rows=873,626 width=357) (actual time=2,352.138..4,095.910 rows=321 loops=1)

  • Hash Cond: (ac.id_call = call_event_1.id)
11. 866.853 866.853 ↑ 1.0 1,683,785 1

Seq Scan on arm03_call ac (cost=0.00..62,208.61 rows=1,687,261 width=62) (actual time=0.033..866.853 rows=1,683,785 loops=1)

12. 5.097 968.989 ↑ 2,721.6 321 1

Hash (cost=87,919.03..87,919.03 rows=873,626 width=301) (actual time=968.989..968.989 rows=321 loops=1)

  • Buckets: 1024 Batches: 512 Memory Usage: 2kB
13. 963.273 963.892 ↑ 2,721.6 321 1

Seq Scan on call_event call_event_1 (cost=856.24..87,919.03 rows=873,626 width=301) (actual time=561.330..963.892 rows=321 loops=1)

  • Filter: (((is_active = 1::numeric) AND (id_main_call IS NULL)) OR (hashed SubPlan 22))
  • Rows Removed by Filter: 1746846
14.          

SubPlan (forSeq Scan)

15. 0.619 0.619 ↑ 1.6 574 1

Index Scan using ref_pult_event_state_index on ref_pult_event (cost=0.28..853.95 rows=915 width=6) (actual time=0.020..0.619 rows=574 loops=1)

16. 173.286 396.685 ↑ 1.0 861,708 1

Hash (cost=19,337.41..19,337.41 rows=865,341 width=49) (actual time=396.685..396.685 rows=861,708 loops=1)

  • Buckets: 2048 Batches: 128 Memory Usage: 264kB
17. 223.399 223.399 ↑ 1.0 861,708 1

Seq Scan on arm03_patient_assistance apa (cost=0.00..19,337.41 rows=865,341 width=49) (actual time=0.011..223.399 rows=861,708 loops=1)

18. 28.122 253.763 ↑ 1.0 98,036 1

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

  • Buckets: 2048 Batches: 16 Memory Usage: 581kB
19. 36.898 225.641 ↑ 1.0 98,036 1

Hash Left Join (cost=6,784.79..15,118.56 rows=98,294 width=58) (actual time=67.743..225.641 rows=98,036 loops=1)

  • Hash Cond: (base_adress.id_street = street.id)
20. 31.964 187.860 ↑ 1.0 98,036 1

Hash Left Join (cost=6,702.23..13,438.72 rows=98,294 width=40) (actual time=66.855..187.860 rows=98,036 loops=1)

  • Hash Cond: (base_adress.id_city = city.id)
21. 76.823 155.575 ↑ 1.0 98,036 1

Hash Left Join (cost=6,681.91..12,066.86 rows=98,294 width=25) (actual time=66.523..155.575 rows=98,036 loops=1)

  • Hash Cond: (full_adress.id_base_adress = base_adress.id)
22. 12.639 12.639 ↑ 1.0 98,036 1

Seq Scan on full_adress (cost=0.00..1,588.94 rows=98,294 width=12) (actual time=0.021..12.639 rows=98,036 loops=1)

23. 39.921 66.113 ↑ 1.0 169,418 1

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

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

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

25. 0.180 0.321 ↑ 1.0 681 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
26. 0.141 0.141 ↑ 1.0 681 1

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

27. 0.497 0.883 ↑ 1.0 2,736 1

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

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

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

29. 0.488 1.458 ↑ 1.0 3,045 1

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

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

Seq Scan on objects o (cost=0.00..203.91 rows=3,083 width=5) (actual time=0.007..0.970 rows=3,045 loops=1)

  • Filter: (deleted <> 1::numeric)
  • Rows Removed by Filter: 188
31.          

SubPlan (forHash Left Join)

32. 0.642 2.568 ↓ 0.0 0 321

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

33. 1.926 1.926 ↓ 0.0 0 321

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.006..0.006 rows=0 loops=321)

  • Index Cond: (id_call = call_event_1.id)
34. 0.321 6.099 ↓ 0.0 0 321

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

35. 0.321 5.778 ↓ 0.0 0 321

Limit (cost=8.52..8.52 rows=1 width=20) (actual time=0.018..0.018 rows=0 loops=321)

36. 2.568 5.457 ↓ 0.0 0 321

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

  • Sort Key: call_tech.id
  • Sort Method: quicksort Memory: 25kB
37. 2.889 2.889 ↑ 2.0 1 321

Index Scan using call_tech_idx on call_tech (cost=0.42..8.51 rows=2 width=20) (actual time=0.008..0.009 rows=1 loops=321)

  • Index Cond: (id_call = call_event_1.id)
38. 0.321 1.926 ↑ 1.0 1 321

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

39. 1.605 1.605 ↓ 0.0 0 321

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

  • Index Cond: (id_call = call_event_1.id)
  • Filter: (at_place_time IS NOT NULL)
  • Rows Removed by Filter: 1
40. 0.321 0.963 ↓ 0.0 0 321

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

41. 0.642 0.642 ↓ 0.0 0 321

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.002..0.002 rows=0 loops=321)

  • Index Cond: (id_call = call_event_1.id)
42. 0.642 11.877 ↓ 0.0 0 321

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

43. 2.595 11.235 ↓ 0.0 0 321

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.035..0.035 rows=0 loops=321)

  • Index Cond: (id_call = call_event_1.id)
  • Heap Fetches: 160
44.          

SubPlan (forIndex Only Scan)

45. 7.520 8.640 ↑ 1.0 1 160

Aggregate (cost=8.57..8.58 rows=1 width=83) (actual time=0.054..0.054 rows=1 loops=160)

46. 1.120 1.120 ↑ 1.0 2 160

Index Scan using call_tech_idx on call_tech ct (cost=0.42..8.52 rows=2 width=83) (actual time=0.005..0.007 rows=2 loops=160)

  • Index Cond: (id_call = call_tech_2.id_call)
  • Filter: (tech_deleted = 0::numeric)
47. 5.457 14.766 ↑ 1.0 1 321

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

  • Index Cond: (id_call = call_event_1.id)
  • Heap Fetches: 321
48.          

Initplan (forIndex Only Scan)

49. 7.704 9.309 ↑ 1.0 1 321

Aggregate (cost=8.45..8.46 rows=1 width=53) (actual time=0.029..0.029 rows=1 loops=321)

50. 1.605 1.605 ↑ 1.0 1 321

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

  • Index Cond: (id_call = call_event_1.id)
51. 8.025 10.914 ↑ 1.0 1 321

Limit (cost=0.00..1.34 rows=1 width=20) (actual time=0.034..0.034 rows=1 loops=321)

52. 2.889 2.889 ↑ 1.0 1 321

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

  • Filter: (id = call_event_1.id_event_type)
  • Rows Removed by Filter: 18
53. 0.321 8.667 ↓ 0.0 0 321

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

54. 6.741 8.346 ↓ 0.0 0 321

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

55. 1.605 1.605 ↓ 0.0 0 321

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

  • Filter: (id_call = call_event_1.id)
  • Rows Removed by Filter: 13
56. 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
57.          

SubPlan (forNested Loop Semi Join)

58. 0.000 0.000 ↓ 0.0 0

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

59. 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)
60. 0.321 2.889 ↓ 0.0 0 321

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

61. 2.568 2.568 ↓ 0.0 0 321

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.008..0.008 rows=0 loops=321)

  • Index Cond: (id_call_event = call_event_1.id)
  • Filter: (is_out <> 1::numeric)
  • Rows Removed by Filter: 0
62. 0.321 1.284 ↓ 0.0 0 321

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

63. 0.963 0.963 ↓ 0.0 0 321

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

  • Index Cond: (id = call_event_1.id)
64. 0.321 1.284 ↑ 1.0 1 321

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

65. 0.963 0.963 ↓ 0.0 0 321

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

  • Index Cond: (id_call = call_event_1.id)
66. 0.642 1.605 ↑ 1.0 1 321

Aggregate (cost=12.65..12.66 rows=1 width=44) (actual time=0.005..0.005 rows=1 loops=321)

67. 0.321 0.963 ↓ 0.0 0 321

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

  • Recheck Cond: (id_call = call_event_1.id)
68. 0.642 0.642 ↓ 0.0 0 321

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

  • Index Cond: (id_call = call_event_1.id)
69. 3.852 24.717 ↑ 1.0 1 321

Aggregate (cost=7.31..7.32 rows=1 width=147) (actual time=0.077..0.077 rows=1 loops=321)

70. 6.420 20.865 ↓ 0.0 0 321

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

71. 10.593 14.445 ↓ 0.0 0 321

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

  • Join Filter: (call_info.id_oper = user_pult.id_user)
  • Rows Removed by Join Filter: 4
72. 3.852 3.852 ↑ 1.3 75 321

Seq Scan on user_pult (cost=0.00..1.99 rows=99 width=8) (actual time=0.004..0.012 rows=75 loops=321)

73. 0.000 0.000 ↓ 0.0 0 24,082

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

74. 2.889 2.889 ↓ 0.0 0 321

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

  • Index Cond: (id_call = call_event_1.id)
  • Filter: (id_pult IS NULL)
  • Rows Removed by Filter: 0
75. 0.321 7.704 ↑ 1.0 1 321

Limit (cost=30.66..30.67 rows=1 width=151) (actual time=0.024..0.024 rows=1 loops=321)

76. 1.605 7.383 ↑ 1.0 1 321

Aggregate (cost=30.66..30.67 rows=1 width=151) (actual time=0.023..0.023 rows=1 loops=321)

77. 0.518 5.778 ↓ 0.0 0 321

Nested Loop (cost=0.84..30.66 rows=1 width=151) (actual time=0.015..0.018 rows=0 loops=321)

78. 4.815 4.815 ↓ 0.0 0 321

Index Scan using call_action_callpult_index on call_action call_action_1 (cost=0.56..22.35 rows=1 width=77) (actual time=0.012..0.015 rows=0 loops=321)

  • Index Cond: ((id_call = call_event_1.id) AND (id_pult IS NULL))
  • Filter: ((id_action = 65038::numeric) AND (action_deleted = 0::numeric))
  • Rows Removed by Filter: 4
79. 0.445 0.445 ↑ 1.0 1 89

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

  • Index Cond: (id = 65038::numeric)
80. 6.741 7.704 ↑ 1.0 1 321

Aggregate (cost=1.01..1.02 rows=1 width=0) (actual time=0.024..0.024 rows=1 loops=321)

81. 0.963 0.963 ↓ 0.0 0 321

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

  • Filter: (id_call = call_event_1.id)
  • Rows Removed by Filter: 1
82. 0.002 0.021 ↓ 0.0 0 1

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

83. 0.001 0.019 ↓ 0.0 0 1

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

84. 0.000 0.018 ↓ 0.0 0 1

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

85. 0.001 0.018 ↓ 0.0 0 1

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

86. 0.001 0.017 ↓ 0.0 0 1

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

87. 0.001 0.016 ↓ 0.0 0 1

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

88. 0.001 0.015 ↓ 0.0 0 1

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

89. 0.014 0.014 ↓ 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.014..0.014 rows=0 loops=1)

  • Index Cond: ((is_active = 1::numeric) AND (id_call IS NULL))
90. 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)
91. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (full_adress_1.id_base_adress = id)
93. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = base_adress_1.id_city)
94. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = base_adress_1.id_street)
95. 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)
96. 34.596 61.225 ↑ 1.0 169,418 1

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

  • Buckets: 4096 Batches: 8 Memory Usage: 921kB
97. 26.629 26.629 ↑ 1.0 169,418 1

Seq Scan on base_adress ba (cost=0.00..3,571.18 rows=169,418 width=11) (actual time=0.006..26.629 rows=169,418 loops=1)

98. 12,392.544 14,309.057 ↑ 1.0 1,747,167 1

Hash (cost=78,326.53..78,326.53 rows=1,747,253 width=549) (actual time=14,309.057..14,309.057 rows=1,747,167 loops=1)

  • Buckets: 1024 Batches: 1024 Memory Usage: 109kB
99. 1,916.513 1,916.513 ↑ 1.0 1,747,167 1

Seq Scan on call_event (cost=0.00..78,326.53 rows=1,747,253 width=549) (actual time=0.037..1,916.513 rows=1,747,167 loops=1)

100. 0.052 0.123 ↑ 1.0 195 1

Hash (cost=3.95..3.95 rows=195 width=12) (actual time=0.123..0.123 rows=195 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
101. 0.071 0.071 ↑ 1.0 195 1

Seq Scan on ext_system_event ese (cost=0.00..3.95 rows=195 width=12) (actual time=0.015..0.071 rows=195 loops=1)

102.          

SubPlan (forHash Left Join)

103. 4.494 4.494 ↑ 1.0 1 321

Index Scan using arm03_call_call_idx on arm03_call (cost=0.43..8.45 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=321)

  • Index Cond: (id_call = "*SELECT* 1".id_call)
104. 1.926 1.926 ↑ 1.0 1 321

Index Scan using arm03_call_call_idx on arm03_call arm03_call_1 (cost=0.43..8.45 rows=1 width=3) (actual time=0.006..0.006 rows=1 loops=321)

  • Index Cond: (id_call = "*SELECT* 1".id_call)
105. 0.340 4.815 ↓ 0.0 0 321

Nested Loop (cost=0.84..63.90 rows=5 width=0) (actual time=0.015..0.015 rows=0 loops=321)

106. 3.852 3.852 ↓ 0.0 0 321

Index Scan using call_action_callpult_index on call_action (cost=0.56..22.32 rows=5 width=6) (actual time=0.012..0.012 rows=0 loops=321)

  • Index Cond: ((id_call = "*SELECT* 1".id_call) AND (id_pult IS NULL))
107. 0.623 0.623 ↑ 1.0 1 89

Index Scan using standart_phrases_idx on standart_phrases sp (cost=0.28..8.31 rows=1 width=6) (actual time=0.007..0.007 rows=1 loops=89)

  • Index Cond: (id = call_action.id_action)
  • Filter: ((caption)::text !~~ 'Приём КТС%'::text)