explain.depesz.com

PostgreSQL's explain analyze made readable

Result: crMi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=723,530.01..723,530.02 rows=1 width=1,929) (actual rows= loops=)

  • Sort Key: dmv_timesheetday_facts34.entrydate3, ((ui.lastname)::character varying(50)) COLLATE "en_US", ((ui.firstname)::character varying(50)) COLLATE "en_US", dmv_timesheetday_facts34.userduplicatename5, ((login.loginname)::character varying(255)) COLLATE "en_US", ((ui.displayname)::text) COLLATE "en_US", ((pj.name)::character varying(255)) COLLATE "en_US", ((tk.name)::character varying(255)) COLLATE "en_US", ((userinfo39.displayname)::text) COLLATE "en_US", dmv_timesheetday_facts34.comments4 COLLATE "en_US
2.          

CTE dmv_timesheetday_facts0cte

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=723,520.82..723,520.86 rows=1 width=113) (actual rows= loops=)

  • Group Key: ts.userid, at.entrydate, (upper(at.comments)), ui_1.duplicatename, at.projectid, at.taskid
4. 0.000 0.000 ↓ 0.0

Sort (cost=723,520.82..723,520.82 rows=1 width=129) (actual rows= loops=)

  • Sort Key: ts.userid, at.entrydate, (upper(at.comments)), ui_1.duplicatename, at.projectid, at.taskid
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=608.21..723,520.81 rows=1 width=129) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=607.78..723,451.89 rows=1 width=113) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=607.49..723,451.58 rows=1 width=113) (actual rows= loops=)

  • Join Filter: (ts.id = at.timesheetid)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..1,407.39 rows=1 width=21) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on userinfo ui_1 (cost=0.00..22.11 rows=711 width=5) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsuseridstartdate on timesheet ts (cost=0.42..1.94 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((userid = ui_1.id) AND (startdate >= '2020-01-01'::date) AND (startdate <= '2020-09-14'::date))
  • Filter: ((enddate >= '2020-01-01'::date) AND (enddate <= '2020-09-14'::date))
11. 0.000 0.000 ↓ 0.0

Hash Join (cost=607.07..720,854.63 rows=95,165 width=124) (actual rows= loops=)

  • Hash Cond: (at.projectid = project3.id)
12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=437.00..704,923.41 rows=1,248,088 width=632) (actual rows= loops=)

  • Hash Cond: (at.projectid = pj_1.id)
  • Join Filter: ((at.entrydate >= pc.effectivedate) AND (at.entrydate <= pc.enddate))
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=170.73..41,798.29 rows=1,248,088 width=129) (actual rows= loops=)

  • Hash Cond: ((at.projectid = pj_2.id) AND (at.userspecifiedclientid = pc_1.clientid))
  • Join Filter: ((at.entrydate >= pc_1.effectivedate) AND (at.entrydate <= pc_1.enddate))
14. 0.000 0.000 ↓ 0.0

Seq Scan on dm_attendancetimeallocation_facts at (cost=0.00..32,266.88 rows=1,248,088 width=133) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=170.70..170.70 rows=2 width=16) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..170.70 rows=2 width=16) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on project pj_2 (cost=0.00..166.79 rows=3 width=4) (actual rows= loops=)

  • Filter: (clientbillingallocationmethod = 1)
18. 0.000 0.000 ↓ 0.0

Index Only Scan using uix4pc_projectclienteffectiveend on projectclient pc_1 (cost=0.28..1.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (projectid = pj_2.id)
19. 0.000 0.000 ↓ 0.0

Hash (cost=245.14..245.14 rows=1,690 width=44) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=203.54..245.14 rows=1,690 width=44) (actual rows= loops=)

  • Hash Cond: (pc.projectid = pj_1.id)
21. 0.000 0.000 ↓ 0.0

Seq Scan on projectclient pc (cost=0.00..37.15 rows=1,692 width=44) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=166.79..166.79 rows=2,940 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on project pj_1 (cost=0.00..166.79 rows=2,940 width=4) (actual rows= loops=)

  • Filter: (clientbillingallocationmethod = 0)
24. 0.000 0.000 ↓ 0.0

Hash (cost=166.79..166.79 rows=263 width=4) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on project project3 (cost=0.00..166.79 rows=263 width=4) (actual rows= loops=)

  • Filter: (projectstatuslabelid = 'f6918709-d5cf-436b-b0ff-2191cd2dd6a9'::uuid)
26. 0.000 0.000 ↓ 0.0

Index Scan using taskdenormalizedhierarchy_pkey on taskdenormalizedhierarchy taskdenormalizedhierarchy4 (cost=0.29..0.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (taskid = at.taskid)
  • Filter: (closedcount <= 0)
27. 0.000 0.000 ↓ 0.0

Index Scan using dm_attendancetimeallocation_facts_pkey on dm_attendancetimeallocation_facts ttendancetimeallocation_facts5 (cost=0.43..68.92 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = at.id)
  • Filter: ((userid = 582) OR (SubPlan 1) OR (SubPlan 2) OR (SubPlan 3) OR (SubPlan 4))
28.          

SubPlan (for Index Scan)

29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.53..22.92 rows=1 width=32) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..20.72 rows=6 width=84) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..7.08 rows=1 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..5.63 rows=1 width=20) (actual rows= loops=)

  • Join Filter: (timesheetapprovalnodes8.id = tsapprovalrequest9.nodeid)
33. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsar_nodeid_userid on tsapprovalrequest tsapprovalrequest9 (cost=0.28..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (userid = 582)
34. 0.000 0.000 ↓ 0.0

Index Scan using ixtantimesheetid on timesheetapprovalnodes timesheetapprovalnodes8 (cost=0.28..3.31 rows=2 width=32) (actual rows= loops=)

  • Index Cond: (timesheetid = ttendancetimeallocation_facts5.timesheetid)
35. 0.000 0.000 ↓ 0.0

Index Only Scan using timesheet_pkey on timesheet timesheet7 (cost=0.42..1.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = ttendancetimeallocation_facts5.timesheetid)
36. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue6 (cost=0.28..13.52 rows=12 width=88) (actual rows= loops=)

  • Index Cond: (tsapprovalrequestid = tsapprovalrequest9.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
37. 0.000 0.000 ↓ 0.0

Index Scan using tsapprovalrequestkeyvalue_pkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue10 (cost=0.28..0.37 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequestkeyvalue6.parentid)
  • Filter: (parentid IS NULL)
38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.26..30.83 rows=1 width=32) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.82..30.28 rows=1 width=16) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.39..27.50 rows=1 width=16) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.96..26.96 rows=1 width=16) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.53..25.73 rows=1 width=16) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.09..24.23 rows=1 width=16) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.66..21.78 rows=1 width=16) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..5.93 rows=1 width=16) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Index Only Scan using timesheet_pkey on timesheet timesheet12 (cost=0.42..1.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = ttendancetimeallocation_facts5.timesheetid)
47. 0.000 0.000 ↓ 0.0

Index Scan using ixtah2timesheetid on timesheetapprovalhistory timesheetapprovalhistory13 (cost=0.42..4.48 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (timesheetid = ttendancetimeallocation_facts5.timesheetid)
  • Filter: (userid = 582)
48. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue14 (cost=14.82..15.84 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory13.id) AND (upper(uri) = 'URN:REPLICON-TENANT:94,637B0A93D54761B05001A2D71697A8:USER:582'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
49. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=14.82..14.82 rows=1 width=0) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.58 rows=20 width=0) (actual rows= loops=)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory13.id)
51. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvuri (cost=0.00..12.86 rows=707 width=0) (actual rows= loops=)

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:94,637B0A93D54761B05001A2D71697A8:USER:582'::text)
52. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue15 (cost=0.43..2.45 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = sheetapprovalhistorykeyvalue14.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
53. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue16 (cost=0.43..1.49 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue15.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
54. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue17 (cost=0.43..1.20 rows=3 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue16.id)
55. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue18 (cost=0.43..0.53 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue17.id)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
56. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue19 (cost=0.43..2.75 rows=3 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue18.id)
57. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue11 (cost=0.43..0.52 rows=3 width=89) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue19.id)
58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.66..10.83 rows=1 width=32) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.38..8.51 rows=1 width=84) (actual rows= loops=)

  • Join Filter: (tsapprovalrequest23.id = tsapprovalrequestkeyvalue20.tsapprovalrequestid)
60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.97..7.08 rows=1 width=4) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..5.63 rows=1 width=20) (actual rows= loops=)

  • Join Filter: (timesheetapprovalnodes22.id = tsapprovalrequest23.nodeid)
62. 0.000 0.000 ↓ 0.0

Index Scan using uix2tsar_nodeid_userid on tsapprovalrequest tsapprovalrequest23 (cost=0.28..2.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (userid = 582)
63. 0.000 0.000 ↓ 0.0

Index Scan using ixtantimesheetid on timesheetapprovalnodes timesheetapprovalnodes22 (cost=0.28..3.31 rows=2 width=32) (actual rows= loops=)

  • Index Cond: (timesheetid = ttendancetimeallocation_facts5.timesheetid)
64. 0.000 0.000 ↓ 0.0

Index Only Scan using timesheet_pkey on timesheet timesheet21 (cost=0.42..1.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = ttendancetimeallocation_facts5.timesheetid)
65. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue20 (cost=0.41..1.42 rows=1 width=88) (actual rows= loops=)

  • Index Cond: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
66. 0.000 0.000 ↓ 0.0

Index Scan using tsapprovalrequestkeyvalue_pkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue24 (cost=0.28..2.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequestkeyvalue20.parentid)
  • Filter: (parentid IS NULL)
67. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.26..32.54 rows=1 width=32) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.82..31.99 rows=1 width=16) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.39..27.50 rows=1 width=16) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.96..26.96 rows=1 width=16) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.53..25.73 rows=1 width=16) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.09..24.23 rows=1 width=16) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.66..21.78 rows=1 width=16) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..5.93 rows=1 width=16) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Index Only Scan using timesheet_pkey on timesheet timesheet26 (cost=0.42..1.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = ttendancetimeallocation_facts5.timesheetid)
76. 0.000 0.000 ↓ 0.0

Index Scan using ixtah2timesheetid on timesheetapprovalhistory timesheetapprovalhistory27 (cost=0.42..4.48 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (timesheetid = ttendancetimeallocation_facts5.timesheetid)
  • Filter: (userid = 582)
77. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue28 (cost=14.82..15.84 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory27.id) AND (upper(uri) = 'URN:REPLICON-TENANT:94,637B0A93D54761B05001A2D71697A8:USER:582'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
78. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=14.82..14.82 rows=1 width=0) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvtimesheetapprovalhistoryid (cost=0.00..1.58 rows=20 width=0) (actual rows= loops=)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory27.id)
80. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ixtahkvuri (cost=0.00..12.86 rows=707 width=0) (actual rows= loops=)

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:94,637B0A93D54761B05001A2D71697A8:USER:582'::text)
81. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue29 (cost=0.43..2.45 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = sheetapprovalhistorykeyvalue28.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-EXPECTED-APPROVAL-AGENT-USER'::text)
82. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue30 (cost=0.43..1.49 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue29.parentid)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-METADATA'::text)
83. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue31 (cost=0.43..1.20 rows=3 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue30.id)
84. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=0.43..0.53 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue31.id)
  • Filter: (upper(uri) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-ACCESSIBLE-OBJECTS'::text)
85. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue33 (cost=0.43..4.45 rows=3 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue32.id)
86. 0.000 0.000 ↓ 0.0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue25 (cost=0.43..0.52 rows=3 width=89) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue33.id)
87.          

Initplan (for Sort)

88. 0.000 0.000 ↓ 0.0

Seq Scan on systeminformation (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.81..8.14 rows=1 width=1,929) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.53..7.81 rows=1 width=172) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.25..7.42 rows=1 width=172) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.12..7.24 rows=1 width=176) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.83..4.94 rows=1 width=150) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.55..2.64 rows=1 width=122) (actual rows= loops=)

  • Join Filter: (dmv_timesheetday_facts34.userid2 = login.userid)
95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..2.32 rows=1 width=114) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

CTE Scan on dmv_timesheetday_facts0cte dmv_timesheetday_facts34 (cost=0.00..0.02 rows=1 width=81) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Index Scan using userinfo_pkey on userinfo ui (cost=0.28..2.29 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (id = dmv_timesheetday_facts34.userid2)
98. 0.000 0.000 ↓ 0.0

Index Scan using login_pkey on login (cost=0.28..0.31 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (userid = ui.id)
99. 0.000 0.000 ↓ 0.0

Index Scan using project_pkey on project pj (cost=0.28..2.30 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (dmv_timesheetday_facts34.projectid6 = id)
100. 0.000 0.000 ↓ 0.0

Index Scan using task_pkey on task tk (cost=0.29..2.31 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (dmv_timesheetday_facts34.taskid7 = id)
101. 0.000 0.000 ↓ 0.0

Index Scan using uix3er_currencyideffectivedate on exchangerate (cost=0.14..0.17 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((variablecurrencyid = $30) AND (tk.estimatedcostcurrencyid = fixedcurrencyid) AND (('now'::cstring)::date >= effectivedate))
  • Filter: (('now'::cstring)::date <= enddate)
102. 0.000 0.000 ↓ 0.0

Index Scan using ix3uh_usersuperstart on userhierarchy userhierarchy40 (cost=0.28..0.39 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((ui.id = userid) AND ('2020-09-14'::date >= startdate))
  • Filter: ('2020-09-14'::date <= enddate)
103. 0.000 0.000 ↓ 0.0

Index Scan using userinfo_pkey on userinfo userinfo39 (cost=0.28..0.32 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (userhierarchy40.supervisorid = id)