# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 148.320 | 4,975.587 | ↓ 1.2 | 62,452 | 1 |
→
Sort (cost=414,271.58..414,402.78 rows=52,482 width=3,029) (actual time=4,944.930..4,975.587 rows=62,452 loops=1)
|
2. |
CTE claims |
|||||
3. | 11.868 | 4,665.195 | ↓ 1.2 | 62,452 | 1 |
→
Append (cost=36,547.32..272,054.47 rows=52,482 width=2,504) (actual time=566.601..4,665.195 rows=62,452 loops=1) |
4. | 68.339 | 3,235.650 | ↑ 1.4 | 36,779 | 1 |
→
Hash Join (cost=36,547.32..267,769.66 rows=52,401 width=928) (actual time=566.600..3,235.650 rows=36,779 loops=1)
|
5. | 20.415 | 3,143.307 | ↑ 1.4 | 36,779 | 1 |
→
Hash Left Join (cost=33,706.23..263,160.03 rows=52,401 width=774) (actual time=542.553..3,143.307 rows=36,779 loops=1)
|
6. | 11.836 | 3,122.769 | ↑ 1.4 | 36,779 | 1 |
→
Nested Loop Left Join (cost=33,695.72..262,431.13 rows=52,401 width=752) (actual time=542.418..3,122.769 rows=36,779 loops=1) |
7. | 83.995 | 2,963.817 | ↑ 1.4 | 36,779 | 1 |
→
Hash Join (cost=33,695.30..226,845.83 rows=52,401 width=748) (actual time=542.403..2,963.817 rows=36,779 loops=1)
|
8. | 26.929 | 2,347.925 | ↑ 1.4 | 36,779 | 1 |
→
Hash Join (cost=495.43..182,218.45 rows=52,401 width=732) (actual time=10.222..2,347.925 rows=36,779 loops=1)
|
9. | 41.677 | 2,317.669 | ↑ 4.4 | 36,779 | 1 |
→
Hash Join (cost=237.28..167,460.79 rows=161,078 width=703) (actual time=6.867..2,317.669 rows=36,779 loops=1)
|
10. | 20.221 | 2,275.616 | ↑ 4.4 | 36,779 | 1 |
→
Hash Join (cost=196.14..165,204.82 rows=161,078 width=667) (actual time=6.478..2,275.616 rows=36,779 loops=1)
|
11. | 18.686 | 2,255.339 | ↑ 4.4 | 36,779 | 1 |
→
Hash Join (cost=190.44..162,984.30 rows=161,078 width=659) (actual time=6.414..2,255.339 rows=36,779 loops=1)
|
12. | 19.960 | 2,236.646 | ↑ 4.4 | 36,779 | 1 |
→
Hash Join (cost=189.30..160,768.34 rows=161,078 width=595) (actual time=6.400..2,236.646 rows=36,779 loops=1)
|
13. | 159.493 | 2,216.644 | ↑ 4.4 | 36,779 | 1 |
→
Merge Join (cost=186.37..158,550.58 rows=161,078 width=527) (actual time=6.348..2,216.644 rows=36,779 loops=1)
|
14. | 164.702 | 1,514.774 | ↑ 4.4 | 36,779 | 1 |
→
Merge Join (cost=73.89..115,620.31 rows=161,078 width=523) (actual time=5.006..1,514.774 rows=36,779 loops=1)
|
15. | 444.003 | 444.003 | ↑ 1.0 | 423,440 | 1 |
→
Index Scan using claims_events_id_idx on claims claims_1 (cost=0.42..43,146.11 rows=423,444 width=466) (actual time=0.011..444.003 rows=423,440 loops=1) |
16. | 906.069 | 906.069 | ↓ 1.0 | 420,087 | 1 |
→
Index Scan using events_pkey on events (cost=0.43..68,868.11 rows=402,781 width=57) (actual time=1.844..906.069 rows=420,087 loops=1)
|
17. | 542.377 | 542.377 | ↓ 1.0 | 1,077,370 | 1 |
→
Index Scan using events_venues_events_id_key on events_venues (cost=0.43..38,307.36 rows=1,059,210 width=8) (actual time=0.008..542.377 rows=1,077,370 loops=1) |
18. | 0.009 | 0.042 | ↑ 1.0 | 32 | 1 |
→
Hash (cost=2.54..2.54 rows=32 width=68) (actual time=0.041..0.042 rows=32 loops=1)
|
19. | 0.023 | 0.033 | ↑ 1.0 | 32 | 1 |
→
Hash Join (cost=1.07..2.54 rows=32 width=68) (actual time=0.016..0.033 rows=32 loops=1)
|
20. | 0.005 | 0.005 | ↑ 1.0 | 32 | 1 |
→
Seq Scan on claim_types (cost=0.00..1.32 rows=32 width=40) (actual time=0.003..0.005 rows=32 loops=1) |
21. | 0.002 | 0.005 | ↑ 1.0 | 3 | 1 |
→
Hash (cost=1.03..1.03 rows=3 width=36) (actual time=0.005..0.005 rows=3 loops=1)
|
22. | 0.003 | 0.003 | ↑ 1.0 | 3 | 1 |
→
Seq Scan on claim_categories (cost=0.00..1.03 rows=3 width=36) (actual time=0.002..0.003 rows=3 loops=1) |
23. | 0.002 | 0.007 | ↑ 1.0 | 6 | 1 |
→
Hash (cost=1.06..1.06 rows=6 width=68) (actual time=0.007..0.007 rows=6 loops=1)
|
24. | 0.005 | 0.005 | ↑ 1.0 | 6 | 1 |
→
Seq Scan on claim_statuses (cost=0.00..1.06 rows=6 width=68) (actual time=0.003..0.005 rows=6 loops=1) |
25. | 0.025 | 0.056 | ↑ 1.0 | 120 | 1 |
→
Hash (cost=4.20..4.20 rows=120 width=12) (actual time=0.055..0.056 rows=120 loops=1)
|
26. | 0.031 | 0.031 | ↑ 1.0 | 120 | 1 |
→
Seq Scan on payroll_periods (cost=0.00..4.20 rows=120 width=12) (actual time=0.006..0.031 rows=120 loops=1) |
27. | 0.149 | 0.376 | ↑ 1.0 | 673 | 1 |
→
Hash (cost=32.73..32.73 rows=673 width=36) (actual time=0.376..0.376 rows=673 loops=1)
|
28. | 0.227 | 0.227 | ↑ 1.0 | 673 | 1 |
→
Seq Scan on programs (cost=0.00..32.73 rows=673 width=36) (actual time=0.013..0.227 rows=673 loops=1) |
29. | 1.842 | 3.327 | ↑ 1.0 | 7,006 | 1 |
→
Hash (cost=153.06..153.06 rows=7,006 width=45) (actual time=3.327..3.327 rows=7,006 loops=1)
|
30. | 1.485 | 1.485 | ↑ 1.0 | 7,006 | 1 |
→
Seq Scan on claim_types_programs (cost=0.00..153.06 rows=7,006 width=45) (actual time=0.007..1.485 rows=7,006 loops=1) |
31. | 56.727 | 531.897 | ↑ 1.0 | 167,589 | 1 |
→
Hash (cost=30,120.27..30,120.27 rows=167,728 width=20) (actual time=531.897..531.897 rows=167,589 loops=1)
|
32. | 294.685 | 475.170 | ↑ 1.0 | 167,589 | 1 |
→
Hash Join (cost=5,875.88..30,120.27 rows=167,728 width=20) (actual time=76.216..475.170 rows=167,589 loops=1)
|
33. | 104.554 | 104.554 | ↑ 1.0 | 415,935 | 1 |
→
Seq Scan on venues (cost=0.00..15,475.35 rows=415,935 width=20) (actual time=0.009..104.554 rows=415,935 loops=1) |
34. | 41.145 | 75.931 | ↑ 1.0 | 167,728 | 1 |
→
Hash (cost=3,123.28..3,123.28 rows=167,728 width=8) (actual time=75.931..75.931 rows=167,728 loops=1)
|
35. | 34.786 | 34.786 | ↑ 1.0 | 167,728 | 1 |
→
Seq Scan on venues_profiles (cost=0.00..3,123.28 rows=167,728 width=8) (actual time=0.008..34.786 rows=167,728 loops=1) |
36. | 147.116 | 147.116 | ↑ 1.0 | 1 | 36,779 |
→
Index Scan using events_staffing_days_positions_pkey on events_staffing_days_positions (cost=0.43..0.67 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=36,779)
|
37. | 0.067 | 0.123 | ↑ 1.0 | 289 | 1 |
→
Hash (cost=6.89..6.89 rows=289 width=26) (actual time=0.123..0.123 rows=289 loops=1)
|
38. | 0.056 | 0.056 | ↑ 1.0 | 289 | 1 |
→
Seq Scan on staffing_positions staffing_positions_1 (cost=0.00..6.89 rows=289 width=26) (actual time=0.007..0.056 rows=289 loops=1) |
39. | 11.631 | 24.004 | ↑ 1.0 | 42,004 | 1 |
→
Hash (cost=2,316.04..2,316.04 rows=42,004 width=18) (actual time=24.004..24.004 rows=42,004 loops=1)
|
40. | 12.373 | 12.373 | ↑ 1.0 | 42,004 | 1 |
→
Seq Scan on staffing_users (cost=0.00..2,316.04 rows=42,004 width=18) (actual time=0.011..12.373 rows=42,004 loops=1) |
41. | 9.759 | 1,018.508 | ↓ 178.2 | 6,951 | 1 |
→
Subquery Scan on *SELECT* 2 (cost=14.38..1,142.07 rows=39 width=1,460) (actual time=4.125..1,018.508 rows=6,951 loops=1) |
42. | 59.939 | 1,008.749 | ↓ 178.2 | 6,951 | 1 |
→
Nested Loop Left Join (cost=14.38..1,141.39 rows=39 width=1,448) (actual time=4.119..1,008.749 rows=6,951 loops=1) |
43. | 3.331 | 205.053 | ↓ 178.2 | 6,951 | 1 |
→
Nested Loop Left Join (cost=13.96..469.77 rows=39 width=411) (actual time=3.967..205.053 rows=6,951 loops=1) |
44. | 4.677 | 180.869 | ↓ 178.2 | 6,951 | 1 |
→
Nested Loop Left Join (cost=13.54..452.04 rows=39 width=411) (actual time=3.949..180.869 rows=6,951 loops=1) |
45. | 9.924 | 148.388 | ↓ 178.2 | 6,951 | 1 |
→
Nested Loop (cost=13.11..432.88 rows=39 width=407) (actual time=3.904..148.388 rows=6,951 loops=1)
|
46. | 4.667 | 138.464 | ↓ 178.2 | 6,951 | 1 |
→
Nested Loop Left Join (cost=13.11..430.09 rows=39 width=375) (actual time=3.895..138.464 rows=6,951 loops=1) |
47. | 7.503 | 99.042 | ↓ 178.2 | 6,951 | 1 |
→
Nested Loop (cost=12.69..315.97 rows=39 width=326) (actual time=3.879..99.042 rows=6,951 loops=1)
|
48. | 4.324 | 84.588 | ↓ 178.2 | 6,951 | 1 |
→
Hash Join (cost=12.69..311.38 rows=39 width=262) (actual time=3.863..84.588 rows=6,951 loops=1)
|
49. | 3.256 | 80.238 | ↓ 58.9 | 6,951 | 1 |
→
Nested Loop (cost=10.97..308.04 rows=118 width=230) (actual time=3.809..80.238 rows=6,951 loops=1)
|
50. | 1.146 | 2.336 | ↓ 3.7 | 78 | 1 |
→
Hash Join (cost=10.68..190.22 rows=21 width=85) (actual time=0.050..2.336 rows=78 loops=1)
|
51. | 1.157 | 1.157 | ↑ 1.0 | 7,006 | 1 |
→
Seq Scan on claim_types_programs claim_types_programs_1 (cost=0.00..153.06 rows=7,006 width=45) (actual time=0.007..1.157 rows=7,006 loops=1) |
52. | 0.003 | 0.033 | ↓ 2.5 | 5 | 1 |
→
Hash (cost=10.65..10.65 rows=2 width=40) (actual time=0.033..0.033 rows=5 loops=1)
|
53. | 0.019 | 0.030 | ↓ 2.5 | 5 | 1 |
→
Bitmap Heap Scan on programs programs_1 (cost=4.29..10.65 rows=2 width=40) (actual time=0.018..0.030 rows=5 loops=1)
|
54. | 0.011 | 0.011 | ↓ 2.5 | 5 | 1 |
→
Bitmap Index Scan on programs_clients_id_idx (cost=0.00..4.29 rows=2 width=0) (actual time=0.011..0.011 rows=5 loops=1)
|
55. | 74.646 | 74.646 | ↓ 1.4 | 89 | 78 |
→
Index Scan using adjustments_programs_id on adjustments (cost=0.29..4.81 rows=64 width=153) (actual time=0.855..0.957 rows=89 loops=78)
|
56. | 0.009 | 0.026 | ↑ 1.0 | 32 | 1 |
→
Hash (cost=1.32..1.32 rows=32 width=40) (actual time=0.026..0.026 rows=32 loops=1)
|
57. | 0.017 | 0.017 | ↑ 1.0 | 32 | 1 |
→
Seq Scan on claim_types claim_types_1 (cost=0.00..1.32 rows=32 width=40) (actual time=0.012..0.017 rows=32 loops=1) |
58. | 6.942 | 6.951 | ↑ 1.0 | 6 | 6,951 |
→
Materialize (cost=0.00..1.09 rows=6 width=68) (actual time=0.000..0.001 rows=6 loops=6,951) |
59. | 0.009 | 0.009 | ↑ 1.0 | 6 | 1 |
→
Seq Scan on claim_statuses claim_statuses_1 (cost=0.00..1.06 rows=6 width=68) (actual time=0.008..0.009 rows=6 loops=1) |
60. | 34.755 | 34.755 | ↑ 1.0 | 1 | 6,951 |
→
Index Scan using events_pkey on events events_1 (cost=0.43..2.92 rows=1 width=49) (actual time=0.004..0.005 rows=1 loops=6,951)
|
61. | 0.000 | 0.000 | ↑ 1.0 | 3 | 6,951 |
→
Materialize (cost=0.00..1.04 rows=3 width=36) (actual time=0.000..0.000 rows=3 loops=6,951) |
62. | 0.007 | 0.007 | ↑ 1.0 | 3 | 1 |
→
Seq Scan on claim_categories claim_categories_1 (cost=0.00..1.03 rows=3 width=36) (actual time=0.004..0.007 rows=3 loops=1) |
63. | 27.804 | 27.804 | ↑ 1.0 | 1 | 6,951 |
→
Index Scan using events_venues_events_id_key on events_venues events_venues_1 (cost=0.43..0.48 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6,951)
|
64. | 20.853 | 20.853 | ↑ 1.0 | 1 | 6,951 |
→
Index Scan using venues_profiles_pkey on venues_profiles venues_profiles_1 (cost=0.42..0.44 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=6,951)
|
65. | 20.853 | 20.853 | ↑ 1.0 | 1 | 6,951 |
→
Index Scan using venues_pkey on venues venues_1 (cost=0.42..0.74 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=6,951)
|
66. |
SubPlan (forNested Loop Left Join) |
|||||
67. | 6.951 | 722.904 | ↑ 1.0 | 1 | 6,951 |
→
Limit (cost=16.45..16.46 rows=1 width=26) (actual time=0.104..0.104 rows=1 loops=6,951) |
68. | 41.706 | 715.953 | ↑ 1.0 | 1 | 6,951 |
→
Sort (cost=16.45..16.46 rows=1 width=26) (actual time=0.103..0.103 rows=1 loops=6,951)
|
69. | 350.952 | 674.247 | ↑ 1.0 | 1 | 6,951 |
→
Hash Join (cost=8.46..16.44 rows=1 width=26) (actual time=0.051..0.097 rows=1 loops=6,951)
|
70. | 288.540 | 288.540 | ↑ 1.0 | 289 | 6,870 |
→
Seq Scan on staffing_positions (cost=0.00..6.89 rows=289 width=26) (actual time=0.003..0.042 rows=289 loops=6,870) |
71. | 6.951 | 34.755 | ↑ 1.0 | 1 | 6,951 |
→
Hash (cost=8.45..8.45 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=6,951)
|
72. | 27.804 | 27.804 | ↑ 1.0 | 1 | 6,951 |
→
Index Scan using events_staffing_days_positions_real_events_id_staffing_users_id on events_staffing_days_positions t1 (cost=0.43..8.45 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6,951)
|
73. | 30.106 | 399.169 | ↓ 445.8 | 18,722 | 1 |
→
Subquery Scan on *SELECT* 3 (cost=274.31..2,618.74 rows=42 width=1,057) (actual time=3.397..399.169 rows=18,722 loops=1) |
74. | 31.810 | 369.063 | ↓ 445.8 | 18,722 | 1 |
→
Nested Loop Left Join (cost=274.31..2,618.00 rows=42 width=1,020) (actual time=3.392..369.063 rows=18,722 loops=1) |
75. | 17.642 | 299.809 | ↓ 445.8 | 18,722 | 1 |
→
Nested Loop (cost=274.03..2,604.61 rows=42 width=633) (actual time=3.375..299.809 rows=18,722 loops=1) |
76. | 17.061 | 263.445 | ↓ 445.8 | 18,722 | 1 |
→
Nested Loop (cost=273.89..2,597.45 rows=42 width=625) (actual time=3.365..263.445 rows=18,722 loops=1) |
77. | 37.515 | 208.940 | ↓ 445.8 | 18,722 | 1 |
→
Nested Loop (cost=273.47..2,566.07 rows=42 width=613) (actual time=3.357..208.940 rows=18,722 loops=1) |
78. | 4.816 | 115.238 | ↓ 445.9 | 18,729 | 1 |
→
Nested Loop (cost=273.05..2,539.85 rows=42 width=609) (actual time=3.349..115.238 rows=18,729 loops=1) |
79. | 0.020 | 0.020 | ↑ 1.0 | 1 | 1 |
→
Seq Scan on clients (cost=0.00..1.96 rows=1 width=4) (actual time=0.017..0.020 rows=1 loops=1)
|
80. | 10.346 | 110.402 | ↓ 445.9 | 18,729 | 1 |
→
Hash Join (cost=273.05..2,537.47 rows=42 width=609) (actual time=3.328..110.402 rows=18,729 loops=1)
|
81. | 13.385 | 100.049 | ↓ 445.9 | 18,729 | 1 |
→
Nested Loop (cost=271.91..2,535.76 rows=42 width=545) (actual time=3.309..100.049 rows=18,729 loops=1) |
82. | 8.376 | 49.206 | ↓ 445.9 | 18,729 | 1 |
→
Hash Join (cost=271.76..2,528.38 rows=42 width=523) (actual time=3.292..49.206 rows=18,729 loops=1)
|
83. | 11.196 | 40.795 | ↓ 185.4 | 18,729 | 1 |
→
Hash Join (cost=268.83..2,524.06 rows=101 width=459) (actual time=3.252..40.795 rows=18,729 loops=1)
|
84. | 15.688 | 26.401 | ↓ 146.3 | 18,729 | 1 |
→
Hash Join (cost=10.68..2,254.00 rows=128 width=422) (actual time=0.043..26.401 rows=18,729 loops=1)
|
85. | 10.696 | 10.696 | ↑ 1.0 | 43,203 | 1 |
→
Seq Scan on manual_claims (cost=0.00..2,080.03 rows=43,203 width=382) (actual time=0.005..10.696 rows=43,203 loops=1) |
86. | 0.001 | 0.017 | ↓ 2.5 | 5 | 1 |
→
Hash (cost=10.65..10.65 rows=2 width=40) (actual time=0.017..0.017 rows=5 loops=1)
|
87. | 0.009 | 0.016 | ↓ 2.5 | 5 | 1 |
→
Bitmap Heap Scan on programs programs_2 (cost=4.29..10.65 rows=2 width=40) (actual time=0.010..0.016 rows=5 loops=1)
|
88. | 0.007 | 0.007 | ↓ 2.5 | 5 | 1 |
→
Bitmap Index Scan on programs_clients_id_idx (cost=0.00..4.29 rows=2 width=0) (actual time=0.007..0.007 rows=5 loops=1)
|
89. | 1.693 | 3.198 | ↑ 1.0 | 7,006 | 1 |
→
Hash (cost=153.06..153.06 rows=7,006 width=45) (actual time=3.198..3.198 rows=7,006 loops=1)
|
90. | 1.505 | 1.505 | ↑ 1.0 | 7,006 | 1 |
→
Seq Scan on claim_types_programs claim_types_programs_2 (cost=0.00..153.06 rows=7,006 width=45) (actual time=0.004..1.505 rows=7,006 loops=1) |
91. | 0.010 | 0.035 | ↑ 1.0 | 32 | 1 |
→
Hash (cost=2.54..2.54 rows=32 width=72) (actual time=0.035..0.035 rows=32 loops=1)
|
92. | 0.012 | 0.025 | ↑ 1.0 | 32 | 1 |
→
Hash Join (cost=1.07..2.54 rows=32 width=72) (actual time=0.011..0.025 rows=32 loops=1)
|
93. | 0.009 | 0.009 | ↑ 1.0 | 32 | 1 |
→
Seq Scan on claim_types claim_types_2 (cost=0.00..1.32 rows=32 width=40) (actual time=0.003..0.009 rows=32 loops=1) |
94. | 0.000 | 0.004 | ↑ 1.0 | 3 | 1 |
→
Hash (cost=1.03..1.03 rows=3 width=36) (actual time=0.004..0.004 rows=3 loops=1)
|
95. | 0.004 | 0.004 | ↑ 1.0 | 3 | 1 |
→
Seq Scan on claim_categories claim_categories_2 (cost=0.00..1.03 rows=3 width=36) (actual time=0.003..0.004 rows=3 loops=1) |
96. | 37.458 | 37.458 | ↑ 1.0 | 1 | 18,729 |
→
Index Scan using staffing_positions_pkey on staffing_positions staffing_positions_2 (cost=0.15..0.17 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=18,729)
|
97. | 0.002 | 0.007 | ↑ 1.0 | 6 | 1 |
→
Hash (cost=1.06..1.06 rows=6 width=68) (actual time=0.007..0.007 rows=6 loops=1)
|
98. | 0.005 | 0.005 | ↑ 1.0 | 6 | 1 |
→
Seq Scan on claim_statuses claim_statuses_2 (cost=0.00..1.06 rows=6 width=68) (actual time=0.003..0.005 rows=6 loops=1) |
99. | 56.187 | 56.187 | ↑ 1.0 | 1 | 18,729 |
→
Index Scan using venues_profiles_pkey on venues_profiles venues_profiles_2 (cost=0.42..0.61 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=18,729)
|
100. | 37.444 | 37.444 | ↑ 1.0 | 1 | 18,722 |
→
Index Scan using venues_pkey on venues venues_2 (cost=0.42..0.74 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=18,722)
|
101. | 18.722 | 18.722 | ↑ 1.0 | 1 | 18,722 |
→
Index Scan using payroll_periods_pkey on payroll_periods payroll_periods_1 (cost=0.14..0.16 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=18,722)
|
102. | 37.444 | 37.444 | ↑ 1.0 | 1 | 18,722 |
→
Index Scan using contact_info_user_id on contact_info (cost=0.28..0.29 rows=1 width=17) (actual time=0.001..0.002 rows=1 loops=18,722)
|
103. | 4,827.267 | 4,827.267 | ↓ 1.2 | 62,452 | 1 |
→
CTE Scan on claims c (cost=0.00..1,049.64 rows=52,482 width=3,029) (actual time=566.606..4,827.267 rows=62,452 loops=1) |