explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9KCl

Settings
# 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)

  • Sort Key: c.claim_date
  • Sort Method: external merge Disk: 28616kB
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)

  • Hash Cond: (claims_1.staffing_users_id = staffing_users.id)
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)

  • Hash Cond: (events_staffing_days_positions.staffing_positions_id = staffing_positions_1.id)
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)

  • Hash Cond: (events_venues.venues_profiles_id = venues_profiles.id)
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)

  • Hash Cond: ((claims_1.claim_types_id = claim_types_programs.claim_types_id) AND (events.programs_id = claim_types_programs.programs_id))
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)

  • Hash Cond: (events.programs_id = programs.id)
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)

  • Hash Cond: (claims_1.payroll_periods_id = payroll_periods.id)
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)

  • Hash Cond: (claims_1.claim_statuses_id = claim_statuses.id)
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)

  • Hash Cond: (claims_1.claim_types_id = claim_types.id)
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)

  • Merge Cond: (claims_1.events_id = events_venues.events_id)
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)

  • Merge Cond: (claims_1.events_id = events.id)
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)

  • Filter: (clients_id = 10)
  • Rows Removed by Filter: 792391
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
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)

  • Hash Cond: (claim_types.claim_categories_id = claim_categories.id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 56kB
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)

  • Buckets: 8192 Batches: 1 Memory Usage: 438kB
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)

  • Buckets: 65536 Batches: 4 Memory Usage: 2735kB
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)

  • Hash Cond: (venues.id = venues_profiles.venues_id)
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)

  • Buckets: 131072 Batches: 4 Memory Usage: 2655kB
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)

  • Index Cond: (claims_1.events_staffing_days_positions_id = id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
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)

  • Buckets: 65536 Batches: 1 Memory Usage: 2667kB
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)

  • Join Filter: (claim_types_1.claim_categories_id = claim_categories_1.id)
  • Rows Removed by Join Filter: 13902
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)

  • Join Filter: (adjustments.claim_statuses_id = claim_statuses_1.id)
  • Rows Removed by Join Filter: 34755
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)

  • Hash Cond: (adjustments.claim_types_id = claim_types_1.id)
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)

  • Join Filter: (programs_1.id = adjustments.programs_id)
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)

  • Hash Cond: (claim_types_programs_1.programs_id = programs_1.id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

  • Recheck Cond: (clients_id = 10)
  • Heap Blocks: exact=5
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)

  • Index Cond: (clients_id = 10)
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)

  • Index Cond: (programs_id = claim_types_programs_1.programs_id)
  • Filter: (claim_types_programs_1.claim_types_id = claim_types_id)
  • Rows Removed by Filter: 2468
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
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)

  • Index Cond: (adjustments.events_id = id)
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)

  • Index Cond: (events_1.id = events_id)
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)

  • Index Cond: (events_venues_1.venues_profiles_id = id)
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)

  • Index Cond: (venues_profiles_1.venues_id = id)
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)

  • Sort Key: t1.id
  • Sort Method: quicksort Memory: 25kB
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)

  • Hash Cond: (staffing_positions.id = t1.staffing_positions_id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
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)

  • Index Cond: ((real_events_id = adjustments.events_id) AND (staffing_users_id = adjustments.staffing_users_id))
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)

  • Filter: (id = 10)
  • Rows Removed by Filter: 76
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)

  • Hash Cond: (manual_claims.claim_statuses_id = claim_statuses_2.id)
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)

  • Hash Cond: (manual_claims.claim_types_id = claim_types_2.id)
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)

  • Hash Cond: ((manual_claims.claim_types_id = claim_types_programs_2.claim_types_id) AND (manual_claims.programs_id = claim_types_programs_2.programs_id))
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)

  • Hash Cond: (manual_claims.programs_id = programs_2.id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

  • Recheck Cond: (clients_id = 10)
  • Heap Blocks: exact=5
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)

  • Index Cond: (clients_id = 10)
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)

  • Buckets: 8192 Batches: 1 Memory Usage: 438kB
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
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)

  • Hash Cond: (claim_types_2.claim_categories_id = claim_categories_2.id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

  • Index Cond: (id = manual_claims.staffing_positions_id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
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)

  • Index Cond: (id = manual_claims.venues_profiles_id)
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)

  • Index Cond: (id = venues_profiles_2.venues_id)
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)

  • Index Cond: (id = manual_claims.payroll_periods_id)
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)

  • Index Cond: (user_id = manual_claims.submitted_by)
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)