explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6jPU : Optimization for: plan #8meT

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 13,060.161 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,269,199.50..1,270,383.51 rows=195 width=486) (actual time=13,058.086..13,060.161 rows=1 loops=1)

2. 12,940.823 12,940.823 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,262,786.68..1,263,961.42 rows=195 width=478) (actual time=12,938.749..12,940.823 rows=1 loops=1)

3. 12,844.915 12,844.915 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,256,345.48..1,257,519.43 rows=195 width=438) (actual time=12,842.844..12,844.915 rows=1 loops=1)

4. 12,715.874 12,715.874 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,245,308.70..1,246,474.52 rows=195 width=430) (actual time=12,713.804..12,715.874 rows=1 loops=1)

5. 12,587.509 12,587.509 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,234,115.55..1,235,272.77 rows=195 width=422) (actual time=12,585.439..12,587.509 rows=1 loops=1)

6. 10,113.939 10,113.939 ↑ 195.0 1 1

Nested Loop Left Join (cost=1,106,983.06..1,108,139.49 rows=195 width=418) (actual time=10,112.056..10,113.939 rows=1 loops=1)

7. 7,626.547 7,626.547 ↑ 195.0 1 1

Nested Loop Left Join (cost=979,786.88..980,941.73 rows=195 width=390) (actual time=7,624.881..7,626.547 rows=1 loops=1)

8. 6,489.230 6,489.230 ↑ 195.0 1 1

Nested Loop Left Join (cost=665,087.01..666,237.91 rows=195 width=370) (actual time=6,487.564..6,489.230 rows=1 loops=1)

9. 5,245.298 5,245.298 ↑ 195.0 1 1

Nested Loop Left Join (cost=243,030.66..244,173.65 rows=195 width=342) (actual time=5,243.633..5,245.298 rows=1 loops=1)

10. 2,894.260 2,894.260 ↑ 195.0 1 1

Nested Loop Left Join (cost=127,970.46..129,111.87 rows=195 width=322) (actual time=2,892.701..2,894.260 rows=1 loops=1)

11. 2,889.400 2,889.400 ↑ 1.0 1 1

Nested Loop Left Join (cost=127,964.56..129,069.31 rows=1 width=130) (actual time=2,887.843..2,889.400 rows=1 loops=1)

12. 394.665 394.665 ↑ 1.0 1 1

Nested Loop Left Join (cost=12,823.97..13,928.68 rows=1 width=102) (actual time=393.227..394.665 rows=1 loops=1)

13. 245.177 245.177 ↑ 1.0 1 1

Nested Loop Left Join (cost=6,410.59..7,515.28 rows=1 width=86) (actual time=243.741..245.177 rows=1 loops=1)

14. 5.965 5.965 ↑ 1.0 1 1

Nested Loop (cost=0.06..1,104.74 rows=1 width=54) (actual time=4.530..5.965 rows=1 loops=1)

15. 2.295 2.295 ↑ 1.0 1 1

Index Scan using v_call_center_agents_agent_friendly_name on v_call_center_agents (cost=0.06..210.19 rows=1 width=38) (actual time=2.141..2.295 rows=1 loops=1)

16. 3.647 3.647 ↓ 1.0 135 1

Seq Scan on v_extensions (cost=0.00..894.08 rows=133 width=20) (actual time=0.771..3.647 rows=135 loops=1)

17. 239.207 239.207 ↑ 1.0 1 1

HashAggregate (cost=6,410.53..6,410.54 rows=1 width=68) (actual time=239.206..239.207 rows=1 loops=1)

18. 239.096 239.096 ↓ 4.0 16 1

Nested Loop (cost=67.85..6,410.51 rows=4 width=68) (actual time=148.417..239.096 rows=16 loops=1)

19. 0.053 0.053 ↑ 1.0 1 1

Nested Loop (cost=0.11..4.52 rows=1 width=53) (actual time=0.036..0.053 rows=1 loops=1)

20. 0.028 0.028 ↑ 1.0 1 1

Index Scan using v_domains_pkey on v_domains (cost=0.05..2.26 rows=1 width=30) (actual time=0.017..0.028 rows=1 loops=1)

21. 0.022 0.022 ↑ 1.0 1 1

Index Scan using v_call_center_agents_pkey on v_call_center_agents v_call_center_agents_2 (cost=0.06..2.26 rows=1 width=23) (actual time=0.017..0.022 rows=1 loops=1)

22. 239.027 239.027 ↓ 4.0 16 1

Bitmap Heap Scan on v_xml_cdr (cost=67.74..6,405.97 rows=4 width=45) (actual time=148.375..239.027 rows=16 loops=1)

23. 20.929 20.929 ↓ 10.8 62,096 1

Bitmap Index Scan on index_cc_agent (cost=0.00..67.74 rows=5,765 width=0) (actual time=20.929..20.929 rows=62,096 loops=1)

24. 149.481 149.481 ↑ 1.0 1 1

HashAggregate (cost=6,413.38..6,413.39 rows=1 width=65) (actual time=149.480..149.481 rows=1 loops=1)

25. 149.436 149.436 ↑ 1.0 1 1

Nested Loop (cost=67.85..6,413.38 rows=1 width=65) (actual time=81.746..149.436 rows=1 loops=1)

26. 0.018 0.018 ↑ 1.0 1 1

Index Scan using v_call_center_agents_pkey on v_call_center_agents v_call_center_agents_3 (cost=0.06..2.26 rows=1 width=23) (actual time=0.016..0.018 rows=1 loops=1)

27. 149.412 149.412 ↑ 1.0 1 1

Nested Loop (cost=67.80..6,411.12 rows=1 width=72) (actual time=81.724..149.412 rows=1 loops=1)

28. 0.013 0.013 ↑ 1.0 1 1

Index Scan using v_domains_pkey on v_domains v_domains_1 (cost=0.05..2.26 rows=1 width=30) (actual time=0.008..0.013 rows=1 loops=1)

29. 149.387 149.387 ↑ 1.0 1 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_1 (cost=67.74..6,408.85 rows=1 width=42) (actual time=81.707..149.387 rows=1 loops=1)

30. 13.307 13.307 ↓ 10.8 62,096 1

Bitmap Index Scan on index_cc_agent (cost=0.00..67.74 rows=5,765 width=0) (actual time=13.307..13.307 rows=62,096 loops=1)

31. 2,494.718 2,494.718 ↓ 27.0 81 1

HashAggregate (cost=115,140.59..115,140.61 rows=3 width=23) (actual time=2,494.591..2,494.718 rows=81 loops=1)

32. 2,486.589 2,486.589 ↑ 4.4 6,272 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_2 (cost=85,304.72..115,017.36 rows=27,384 width=23) (actual time=2,477.423..2,486.589 rows=6,272 loops=1)

33. 2,474.985 2,474.985 ↓ 0.0 0 1

BitmapAnd (cost=85,304.72..85,304.72 rows=27,384 width=0) (actual time=2,474.985..2,474.985 rows=0 loops=1)

34. 347.687 347.687 ↑ 1.0 1,390,436 1

Bitmap Index Scan on index_domain_uuid (cost=0.00..14,262.27 rows=1,391,569 width=0) (actual time=347.687..347.687 rows=1,390,436 loops=1)

35. 471.925 471.925 ↑ 1.0 3,069,920 1

Bitmap Index Scan on index_start_stamp (cost=0.00..29,312.46 rows=3,201,873 width=0) (actual time=471.925..471.925 rows=3,069,920 loops=1)

36. 1,386.874 1,386.874 ↑ 1.0 4,915,327 1

Bitmap Index Scan on index_direction (cost=0.00..41,725.79 rows=4,990,651 width=0) (actual time=1,386.874..1,386.874 rows=4,915,327 loops=1)

37. 4.841 4.841 ↑ 250.0 1 1

Hash Right Join (cost=5.90..41.69 rows=250 width=192) (actual time=4.839..4.841 rows=1 loops=1)

38. 2.232 2.232 ↓ 0.0 0 1

Function Scan on agent_customstatus_all_activity_report_singlerow customstatus (cost=0.05..35.05 rows=50 width=112) (actual time=2.232..2.232 rows=0 loops=1)

39. 2.589 2.589 ↑ 5.0 1 1

Hash (cost=5.83..5.83 rows=5 width=96) (actual time=2.589..2.589 rows=1 loops=1)

40. 2.586 2.586 ↑ 5.0 1 1

Nested Loop Left Join (cost=0.11..5.83 rows=5 width=96) (actual time=2.585..2.586 rows=1 loops=1)

41. 2.575 2.575 ↑ 5.0 1 1

Function Scan on agent_activity_report_singlerow activityquery (cost=0.05..3.55 rows=5 width=64) (actual time=2.574..2.575 rows=1 loops=1)

42. 0.007 0.007 ↑ 1.0 1 1

Materialize (cost=0.06..2.26 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=1)

43. 0.006 0.006 ↑ 1.0 1 1

Index Scan using v_call_center_agents_pkey on v_call_center_agents v_call_center_agents_1 (cost=0.06..2.26 rows=1 width=19) (actual time=0.006..0.006 rows=1 loops=1)

44. 2,351.028 2,351.028 ↓ 36.5 73 1

Materialize (cost=115,060.21..115,060.23 rows=2 width=36) (actual time=2,350.900..2,351.028 rows=73 loops=1)

45. 2,351.002 2,351.002 ↓ 36.5 73 1

Subquery Scan on agentoutans (cost=115,060.21..115,060.22 rows=2 width=36) (actual time=2,350.897..2,351.002 rows=73 loops=1)

46. 2,350.992 2,350.992 ↓ 36.5 73 1

HashAggregate (cost=115,060.21..115,060.22 rows=2 width=23) (actual time=2,350.897..2,350.992 rows=73 loops=1)

47. 2,347.708 2,347.708 ↑ 3.6 3,598 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_3 (cost=85,302.54..115,015.19 rows=12,863 width=23) (actual time=2,339.608..2,347.708 rows=3,598 loops=1)

48. 2,336.653 2,336.653 ↓ 0.0 0 1

BitmapAnd (cost=85,302.54..85,302.54 rows=27,384 width=0) (actual time=2,336.653..2,336.653 rows=0 loops=1)

49. 328.354 328.354 ↑ 1.0 1,390,436 1

Bitmap Index Scan on index_domain_uuid (cost=0.00..14,262.27 rows=1,391,569 width=0) (actual time=328.354..328.354 rows=1,390,436 loops=1)

50. 444.469 444.469 ↑ 1.0 3,069,920 1

Bitmap Index Scan on index_start_stamp (cost=0.00..29,312.46 rows=3,201,873 width=0) (actual time=444.469..444.469 rows=3,069,920 loops=1)

51. 1,304.547 1,304.547 ↑ 1.0 4,915,327 1

Bitmap Index Scan on index_direction (cost=0.00..41,725.79 rows=4,990,651 width=0) (actual time=1,304.547..1,304.547 rows=4,915,327 loops=1)

52. 1,243.926 1,243.926 ↑ 2.5 4 1

Materialize (cost=422,056.35..422,056.46 rows=10 width=44) (actual time=1,243.918..1,243.926 rows=4 loops=1)

53. 1,243.920 1,243.920 ↑ 2.5 4 1

Subquery Scan on agentin (cost=422,056.35..422,056.45 rows=10 width=44) (actual time=1,243.914..1,243.920 rows=4 loops=1)

54. 1,243.919 1,243.919 ↑ 2.5 4 1

HashAggregate (cost=422,056.35..422,056.42 rows=10 width=23) (actual time=1,243.913..1,243.919 rows=4 loops=1)

55. 1,243.811 1,243.811 ↑ 24.3 28 1

Nested Loop (cost=43,585.77..422,053.29 rows=680 width=23) (actual time=1,097.904..1,243.811 rows=28 loops=1)

56. 1,183.127 1,183.127 ↑ 1.7 62,850 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_5 (cost=43,585.65..205,129.73 rows=108,789 width=39) (actual time=1,091.270..1,183.127 rows=62,850 loops=1)

57. 1,077.623 1,077.623 ↓ 0.0 0 1

BitmapAnd (cost=43,585.65..43,585.65 rows=156,358 width=0) (actual time=1,077.623..1,077.623 rows=0 loops=1)

58. 342.326 342.326 ↑ 1.0 1,390,436 1

Bitmap Index Scan on index_domain_uuid (cost=0.00..14,262.27 rows=1,391,569 width=0) (actual time=342.326..342.326 rows=1,390,436 loops=1)

59. 492.834 492.834 ↑ 1.0 3,069,920 1

Bitmap Index Scan on index_start_stamp (cost=0.00..29,312.46 rows=3,201,873 width=0) (actual time=492.834..492.834 rows=3,069,920 loops=1)

60. 62.850 62.850 ↓ 0.0 0 62,850

Index Scan using v_xml_cdr_pkey on v_xml_cdr v_xml_cdr_4 (cost=0.11..1.99 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=62,850)

61. 1,137.310 1,137.310 ↑ 1.2 4 1

Materialize (cost=314,699.87..314,699.92 rows=5 width=36) (actual time=1,137.303..1,137.310 rows=4 loops=1)

62. 1,137.299 1,137.299 ↑ 1.2 4 1

Subquery Scan on agentinans (cost=314,699.87..314,699.91 rows=5 width=36) (actual time=1,137.295..1,137.299 rows=4 loops=1)

63. 1,137.299 1,137.299 ↑ 1.2 4 1

HashAggregate (cost=314,699.87..314,699.90 rows=5 width=23) (actual time=1,137.295..1,137.299 rows=4 loops=1)

64. 1,137.199 1,137.199 ↑ 11.4 28 1

Nested Loop (cost=43,580.00..314,698.75 rows=320 width=23) (actual time=1,039.948..1,137.199 rows=28 loops=1)

65. 1,108.127 1,108.127 ↑ 2.8 18,576 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_7 (cost=43,579.88..205,123.96 rows=51,102 width=39) (actual time=1,036.360..1,108.127 rows=18,576 loops=1)

66. 1,022.926 1,022.926 ↓ 0.0 0 1

BitmapAnd (cost=43,579.88..43,579.88 rows=156,358 width=0) (actual time=1,022.926..1,022.926 rows=0 loops=1)

67. 328.518 328.518 ↑ 1.0 1,390,436 1

Bitmap Index Scan on index_domain_uuid (cost=0.00..14,262.27 rows=1,391,569 width=0) (actual time=328.518..328.518 rows=1,390,436 loops=1)

68. 445.405 445.405 ↑ 1.0 3,069,920 1

Bitmap Index Scan on index_start_stamp (cost=0.00..29,312.46 rows=3,201,873 width=0) (actual time=445.405..445.405 rows=3,069,920 loops=1)

69. 18.576 18.576 ↓ 0.0 0 18,576

Index Scan using v_xml_cdr_pkey on v_xml_cdr v_xml_cdr_6 (cost=0.11..2.14 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=18,576)

70. 2,487.373 2,487.373 ↓ 57.0 114 1

Materialize (cost=127,196.18..127,196.20 rows=2 width=44) (actual time=2,487.141..2,487.373 rows=114 loops=1)

71. 2,487.337 2,487.337 ↓ 57.0 114 1

Subquery Scan on agentlocal (cost=127,196.18..127,196.20 rows=2 width=44) (actual time=2,487.126..2,487.337 rows=114 loops=1)

72. 2,487.327 2,487.327 ↓ 57.0 114 1

HashAggregate (cost=127,196.18..127,196.19 rows=2 width=23) (actual time=2,487.125..2,487.327 rows=114 loops=1)

73. 2,468.314 2,468.314 ↑ 1.5 14,782 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_8 (cost=92,404.35..127,098.54 rows=21,697 width=23) (actual time=2,396.973..2,468.314 rows=14,782 loops=1)

74. 2,388.113 2,388.113 ↓ 0.0 0 1

BitmapAnd (cost=92,404.35..92,404.35 rows=32,043 width=0) (actual time=2,388.113..2,388.113 rows=0 loops=1)

75. 339.219 339.219 ↑ 1.0 1,390,436 1

Bitmap Index Scan on index_domain_uuid (cost=0.00..14,262.27 rows=1,391,569 width=0) (actual time=339.219..339.219 rows=1,390,436 loops=1)

76. 465.216 465.216 ↑ 1.0 3,069,920 1

Bitmap Index Scan on index_start_stamp (cost=0.00..29,312.46 rows=3,201,873 width=0) (actual time=465.216..465.216 rows=3,069,920 loops=1)

77. 1,321.251 1,321.251 ↑ 1.0 5,771,732 1

Bitmap Index Scan on index_direction (cost=0.00..48,826.27 rows=5,839,840 width=0) (actual time=1,321.251..1,321.251 rows=5,771,732 loops=1)

78. 2,473.553 2,473.553 ↓ 110.0 110 1

Materialize (cost=127,132.49..127,132.50 rows=1 width=36) (actual time=2,473.354..2,473.553 rows=110 loops=1)

79. 2,473.512 2,473.512 ↓ 110.0 110 1

Subquery Scan on agentlocalans (cost=127,132.49..127,132.50 rows=1 width=36) (actual time=2,473.346..2,473.512 rows=110 loops=1)

80. 2,473.499 2,473.499 ↓ 110.0 110 1

HashAggregate (cost=127,132.49..127,132.49 rows=1 width=23) (actual time=2,473.345..2,473.499 rows=110 loops=1)

81. 2,465.082 2,465.082 ↑ 1.0 9,744 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_9 (cost=92,402.63..127,096.82 rows=10,192 width=23) (actual time=2,391.413..2,465.082 rows=9,744 loops=1)

82. 2,382.295 2,382.295 ↓ 0.0 0 1

BitmapAnd (cost=92,402.63..92,402.63 rows=32,043 width=0) (actual time=2,382.295..2,382.295 rows=0 loops=1)

83. 335.750 335.750 ↑ 1.0 1,390,436 1

Bitmap Index Scan on index_domain_uuid (cost=0.00..14,262.27 rows=1,391,569 width=0) (actual time=335.750..335.750 rows=1,390,436 loops=1)

84. 487.696 487.696 ↑ 1.0 3,069,920 1

Bitmap Index Scan on index_start_stamp (cost=0.00..29,312.46 rows=3,201,873 width=0) (actual time=487.696..487.696 rows=3,069,920 loops=1)

85. 1,293.373 1,293.373 ↑ 1.0 5,771,732 1

Bitmap Index Scan on index_direction (cost=0.00..48,826.27 rows=5,839,840 width=0) (actual time=1,293.373..1,293.373 rows=5,771,732 loops=1)

86. 128.362 128.362 ↓ 0.0 0 1

Materialize (cost=11,193.16..11,200.98 rows=1 width=24) (actual time=128.362..128.362 rows=0 loops=1)

87. 128.347 128.347 ↓ 0.0 0 1

Subquery Scan on innerquery (cost=11,193.16..11,200.98 rows=1 width=24) (actual time=128.347..128.347 rows=0 loops=1)

88. 127.202 127.202 ↓ 20.6 17,886 1

WindowAgg (cost=11,193.16..11,197.50 rows=869 width=24) (actual time=121.185..127.202 rows=17,886 loops=1)

89. 122.269 122.269 ↓ 20.6 17,886 1

Sort (cost=11,193.16..11,193.59 rows=869 width=24) (actual time=121.177..122.269 rows=17,886 loops=1)

90. 111.371 111.371 ↓ 20.6 17,886 1

Nested Loop (cost=0.05..11,184.67 rows=869 width=24) (actual time=63.793..111.371 rows=17,886 loops=1)

91. 0.043 0.043 ↑ 1.0 1 1

Index Only Scan using v_domains_pkey on v_domains v_domains_2 (cost=0.05..2.26 rows=1 width=0) (actual time=0.040..0.043 rows=1 loops=1)

92. 109.695 109.695 ↓ 20.6 17,886 1

Seq Scan on v_call_center_agent_records (cost=0.00..11,179.81 rows=869 width=24) (actual time=63.747..109.695 rows=17,886 loops=1)

93. 129.036 129.036 ↓ 0.0 0 1

Materialize (cost=11,036.78..11,044.12 rows=1 width=24) (actual time=129.036..129.036 rows=0 loops=1)

94. 129.035 129.035 ↓ 0.0 0 1

Subquery Scan on innerquery_1 (cost=11,036.78..11,044.12 rows=1 width=24) (actual time=129.035..129.035 rows=0 loops=1)

95. 127.918 127.918 ↓ 21.4 17,500 1

WindowAgg (cost=11,036.78..11,040.86 rows=816 width=24) (actual time=122.031..127.918 rows=17,500 loops=1)

96. 123.023 123.023 ↓ 21.4 17,500 1

Sort (cost=11,036.78..11,037.19 rows=816 width=24) (actual time=122.022..123.023 rows=17,500 loops=1)

97. 112.690 112.690 ↓ 21.4 17,500 1

Nested Loop (cost=0.14..11,028.88 rows=816 width=24) (actual time=14.025..112.690 rows=17,500 loops=1)

98. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using v_domains_pkey on v_domains v_domains_3 (cost=0.05..2.26 rows=1 width=0) (actual time=0.012..0.014 rows=1 loops=1)

99. 110.842 110.842 ↓ 21.4 17,500 1

Index Scan using v_call_center_agent_records_call_center_agent_record_status on v_call_center_agent_records v_call_center_agent_records_1 (cost=0.08..11,024.18 rows=816 width=24) (actual time=14.010..110.842 rows=17,500 loops=1)

100. 95.902 95.902 ↑ 1.0 1 1

Materialize (cost=6,441.20..6,441.21 rows=1 width=56) (actual time=95.900..95.902 rows=1 loops=1)

101. 95.898 95.898 ↑ 1.0 1 1

Subquery Scan on agentcclocalans (cost=6,441.20..6,441.21 rows=1 width=56) (actual time=95.897..95.898 rows=1 loops=1)

102. 95.898 95.898 ↑ 1.0 1 1

HashAggregate (cost=6,441.20..6,441.21 rows=1 width=30) (actual time=95.897..95.898 rows=1 loops=1)

103. 95.861 95.861 ↑ 1.0 1 1

Nested Loop (cost=67.97..6,441.19 rows=1 width=30) (actual time=95.341..95.861 rows=1 loops=1)

104. 95.690 95.690 ↓ 2.1 31 1

Nested Loop (cost=67.85..6,407.66 rows=15 width=46) (actual time=54.984..95.690 rows=31 loops=1)

105. 0.028 0.028 ↑ 1.0 1 1

Nested Loop (cost=0.11..4.52 rows=1 width=53) (actual time=0.024..0.028 rows=1 loops=1)

106. 0.013 0.013 ↑ 1.0 1 1

Index Scan using v_domains_pkey on v_domains v_domains_4 (cost=0.05..2.26 rows=1 width=30) (actual time=0.011..0.013 rows=1 loops=1)

107. 0.011 0.011 ↑ 1.0 1 1

Index Scan using v_call_center_agents_pkey on v_call_center_agents v_call_center_agents_4 (cost=0.06..2.26 rows=1 width=23) (actual time=0.009..0.011 rows=1 loops=1)

108. 95.638 95.638 ↓ 2.1 31 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_11 (cost=67.74..6,403.09 rows=15 width=61) (actual time=54.951..95.638 rows=31 loops=1)

109. 12.464 12.464 ↓ 10.8 62,096 1

Bitmap Index Scan on index_cc_agent (cost=0.00..67.74 rows=5,765 width=0) (actual time=12.464..12.464 rows=62,096 loops=1)

110. 0.155 0.155 ↓ 0.0 0 31

Index Scan using v_xml_cdr_pkey on v_xml_cdr v_xml_cdr_10 (cost=0.11..2.23 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=31)

111. 119.244 119.244 ↓ 0.0 0 1

Materialize (cost=6,412.82..6,412.83 rows=1 width=40) (actual time=119.244..119.244 rows=0 loops=1)

112. 119.241 119.241 ↓ 0.0 0 1

Subquery Scan on agentcclocaldrop (cost=6,412.82..6,412.83 rows=1 width=40) (actual time=119.241..119.241 rows=0 loops=1)

113. 119.240 119.240 ↓ 0.0 0 1

HashAggregate (cost=6,412.82..6,412.83 rows=1 width=991) (actual time=119.240..119.240 rows=0 loops=1)

114. 119.238 119.238 ↓ 0.0 0 1

Nested Loop (cost=67.97..6,412.82 rows=1 width=991) (actual time=119.238..119.238 rows=0 loops=1)

115. 119.213 119.213 ↑ 1.0 1 1

Nested Loop (cost=67.85..6,410.50 rows=1 width=991) (actual time=64.573..119.213 rows=1 loops=1)

116. 0.010 0.010 ↑ 1.0 1 1

Index Scan using v_call_center_agents_pkey on v_call_center_agents v_call_center_agents_5 (cost=0.06..2.26 rows=1 width=23) (actual time=0.008..0.010 rows=1 loops=1)

117. 119.192 119.192 ↑ 1.0 1 1

Nested Loop (cost=67.80..6,408.23 rows=1 width=998) (actual time=64.555..119.192 rows=1 loops=1)

118. 0.010 0.010 ↑ 1.0 1 1

Index Scan using v_domains_pkey on v_domains v_domains_5 (cost=0.05..2.26 rows=1 width=30) (actual time=0.006..0.010 rows=1 loops=1)

119. 119.172 119.172 ↑ 1.0 1 1

Bitmap Heap Scan on v_xml_cdr v_xml_cdr_13 (cost=67.74..6,405.97 rows=1 width=968) (actual time=64.540..119.172 rows=1 loops=1)

120. 12.426 12.426 ↓ 10.8 62,096 1

Bitmap Index Scan on index_cc_agent (cost=0.00..67.74 rows=5,765 width=0) (actual time=12.426..12.426 rows=62,096 loops=1)

121. 0.019 0.019 ↓ 0.0 0 1

Index Scan using v_xml_cdr_pkey on v_xml_cdr v_xml_cdr_12 (cost=0.11..2.32 rows=1 width=16) (actual time=0.019..0.019 rows=0 loops=1)

Planning time : 24.185 ms
Execution time : 13,068.595 ms