explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rILn

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

Sort (cost=105,382,558,185,250.88..105,382,558,185,252.61 rows=692 width=1,321) (actual rows= loops=)

  • Sort Key: ((ui.lastname)::character varying(50)) COLLATE "en_US", ((ui.firstname)::character varying(50)) COLLATE "en_US", ui.duplicatename, ((login.loginname)::character varying(255)) COLLATE "en_US", ((ui.displayname)::text) COLLATE "en_US", ((tk.name)::character varying(255)) COLLATE "en_US
2.          

Initplan (for Sort)

3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=120,272.20..105,382,558,185,217.22 rows=692 width=1,321) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=120,271.77..105,382,558,184,847.53 rows=692 width=73) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=120,271.48..105,382,558,184,633.00 rows=692 width=121) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=120,271.05..105,382,558,184,182.28 rows=692 width=85) (actual rows= loops=)

  • Hash Cond: ("*SELECT* 1".userid = ts.userid)
  • Join Filter: (("*SELECT* 1".entrydate >= ts.startdate) AND ("*SELECT* 1".entrydate <= ts.enddate))
8. 0.000 0.000 ↓ 0.0

Append (cost=119,461.95..105,382,558,175,939.00 rows=652,531 width=40) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=119,461.95..105,381,225,816,388.27 rows=652,523 width=40) (actual rows= loops=)

  • Filter: ((SubPlan 18) OR (hashed SubPlan 23))
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=118,738.48..288,301.27 rows=870,031 width=140) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on projectsysteminformation psi (cost=0.00..1.01 rows=1 width=0) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=118,738.48..264,374.41 rows=870,031 width=56) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

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

14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=118,738.48..255,673.09 rows=870,031 width=56) (actual rows= loops=)

  • Hash Cond: (te.id = temdbreaktype.timeentryid)
15. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=38,071.78..171,743.75 rows=870,031 width=56) (actual rows= loops=)

  • Hash Cond: (tembillingrate.timeentryid = te.id)
16. 0.000 0.000 ↓ 0.0

Seq Scan on timeentrymetadata tembillingrate (cost=0.00..114,418.26 rows=868,076 width=16) (actual rows= loops=)

  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BILLING-RATE'::text)
17. 0.000 0.000 ↓ 0.0

Hash (cost=18,699.39..18,699.39 rows=870,031 width=56) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on timeentry te (cost=0.00..18,699.39 rows=870,031 width=56) (actual rows= loops=)

  • Filter: ((timeallocationtype <> 2) OR (timeallocationtype IS NULL))
19. 0.000 0.000 ↓ 0.0

Hash (cost=80,666.70..80,666.70 rows=1 width=16) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using ixtem2timeentryid on timeentrymetadata temdbreaktype (cost=0.56..80,666.70 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:BREAK-TYPE'::text)
21.          

SubPlan (for Subquery Scan)

22. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..242,244,910.47 rows=859,601 width=16) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..242,236,414.47 rows=859,601 width=16) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on timeentryrevision timeentryrevision7 (cost=0.00..36,694.81 rows=870,203 width=32) (actual rows= loops=)

  • Filter: (totimestamputc IS NULL)
25. 0.000 0.000 ↓ 0.0

Index Scan using timeentryrevision_pkey on timeentryrevision timeentryrevision8 (cost=0.43..278.33 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timeentryrevision7.id)
  • Filter: ((userid = 492) OR (alternatives: SubPlan 2 or hashed SubPlan 3) OR (SubPlan 4) OR (SubPlan 5) OR (SubPlan 6) OR (SubPlan 7) OR ((SubPlan 10) AND ((SubPlan 11) OR (SubPlan 12))) OR ((SubPlan 15) AND ((SubPlan 16) OR (SubPlan 17))))
26.          

SubPlan (for Index Scan)

27. 0.000 0.000 ↓ 0.0

Index Scan using ix3uh_usersuperstart on userhierarchy userhierarchy9 (cost=0.28..2.30 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision8.userid) AND (supervisorid = 492) AND (startdate <= '2020-07-28'::date))
  • Filter: (enddate >= '2020-07-28'::date)
28. 0.000 0.000 ↓ 0.0

Index Scan using ixuhsupervisorid on userhierarchy userhierarchy9_1 (cost=0.28..4.33 rows=2 width=4) (actual rows= loops=)

  • Index Cond: (supervisorid = 492)
  • Filter: ((startdate <= '2020-07-28'::date) AND (enddate >= '2020-07-28'::date))
29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..23.04 rows=1 width=32) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.11..18.92 rows=11 width=84) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..6.28 rows=1 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

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

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

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes12 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest13.nodeid)
35. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet11 (cost=0.29..1.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes12.timesheetid)
  • Filter: ((startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate) AND (userid = timeentryrevision8.userid))
36. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue10 (cost=0.28..12.53 rows=11 width=88) (actual rows= loops=)

  • Index Cond: (tsapprovalrequestid = tsapprovalrequest13.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 tsapprovalrequestkeyvalue14 (cost=0.28..0.37 rows=1 width=16) (actual rows= loops=)

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

Nested Loop (cost=10.20..50.79 rows=1 width=32) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.78..50.25 rows=1 width=16) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.35..48.15 rows=1 width=16) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.92..47.61 rows=1 width=16) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.49..46.31 rows=1 width=16) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.07..44.66 rows=1 width=16) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.64..42.22 rows=1 width=16) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..34.26 rows=1 width=16) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet16 (cost=0.29..7.33 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision8.userid) AND (startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate))
47. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetid = timesheet16.id)
  • Filter: (userid = 492)
48. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue18 (cost=6.93..7.95 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory17.id) AND (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::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=6.93..6.93 rows=1 width=0) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text)
52. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = sheetapprovalhistorykeyvalue18.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 sheetapprovalhistorykeyvalue20 (cost=0.43..1.63 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue19.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 sheetapprovalhistorykeyvalue21 (cost=0.43..1.27 rows=3 width=32) (actual rows= loops=)

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue21.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 sheetapprovalhistorykeyvalue23 (cost=0.43..2.07 rows=3 width=32) (actual rows= loops=)

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

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

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

Nested Loop (cost=1.52..10.03 rows=1 width=32) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.24..7.71 rows=1 width=84) (actual rows= loops=)

  • Join Filter: (tsapprovalrequest27.id = tsapprovalrequestkeyvalue24.tsapprovalrequestid)
60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..6.28 rows=1 width=4) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

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

62. 0.000 0.000 ↓ 0.0

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

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

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes26 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest27.nodeid)
64. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet25 (cost=0.29..1.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes26.timesheetid)
  • Filter: ((startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate) AND (userid = timeentryrevision8.userid))
65. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue24 (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 tsapprovalrequestkeyvalue28 (cost=0.28..2.30 rows=1 width=16) (actual rows= loops=)

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

Nested Loop (cost=10.20..53.17 rows=1 width=32) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.78..52.63 rows=1 width=16) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.35..48.15 rows=1 width=16) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.92..47.61 rows=1 width=16) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.49..46.31 rows=1 width=16) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.07..44.66 rows=1 width=16) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.64..42.22 rows=1 width=16) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..34.26 rows=1 width=16) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet30 (cost=0.29..7.33 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision8.userid) AND (startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate))
76. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetid = timesheet30.id)
  • Filter: (userid = 492)
77. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue32 (cost=6.93..7.95 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory31.id) AND (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::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=6.93..6.93 rows=1 width=0) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text)
81. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = sheetapprovalhistorykeyvalue32.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 sheetapprovalhistorykeyvalue34 (cost=0.43..1.63 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue33.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 sheetapprovalhistorykeyvalue35 (cost=0.43..1.27 rows=3 width=32) (actual rows= loops=)

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue35.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 sheetapprovalhistorykeyvalue37 (cost=0.43..4.45 rows=3 width=32) (actual rows= loops=)

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue37.id)
87. 0.000 0.000 ↓ 0.0

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision38 (cost=18.70..26.99 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (timeentryid = timeentryrevision8.timeentryid)
  • Filter: ((fromtimestamputc <= timeentryrevision8.fromtimestamputc) AND ((totimestamputc > timeentryrevision8.fromtimestamputc) OR (totimestamputc IS NULL)) AND (((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 8)) OR ((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 9))))
88.          

SubPlan (for Index Scan)

89. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (projectleaderapproverid = 492)
90. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..15.95 rows=5 width=32) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Index Scan using ixprjprojectleaderapproverid on project project41 (cost=0.28..2.29 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (projectleaderapproverid = 492)
92. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task40 (cost=0.28..13.48 rows=12 width=8) (actual rows= loops=)

  • Index Cond: (projectid = project41.id)
93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..23.04 rows=1 width=32) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.11..18.92 rows=11 width=84) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..6.28 rows=1 width=4) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

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

97. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 492)
98. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes44 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest45.nodeid)
99. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet43 (cost=0.29..1.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes44.timesheetid)
  • Filter: ((startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate) AND (userid = timeentryrevision8.userid))
100. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue42 (cost=0.28..12.53 rows=11 width=88) (actual rows= loops=)

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

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

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

Nested Loop (cost=10.20..50.79 rows=1 width=32) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.78..50.25 rows=1 width=16) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.35..48.15 rows=1 width=16) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.92..47.61 rows=1 width=16) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.49..46.31 rows=1 width=16) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.07..44.66 rows=1 width=16) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.64..42.22 rows=1 width=16) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..34.26 rows=1 width=16) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet48 (cost=0.29..7.33 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision8.userid) AND (startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate))
111. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetid = timesheet48.id)
  • Filter: (userid = 492)
112. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue50 (cost=6.93..7.95 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory49.id) AND (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
113. 0.000 0.000 ↓ 0.0

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

114. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory49.id)
115. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text)
116. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue52.id)
119. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue54.id)
121. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue55.id)
122. 0.000 0.000 ↓ 0.0

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision56 (cost=74.59..82.89 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (timeentryid = timeentryrevision8.timeentryid)
  • Filter: ((fromtimestamputc <= timeentryrevision8.fromtimestamputc) AND ((totimestamputc > timeentryrevision8.fromtimestamputc) OR (totimestamputc IS NULL)) AND (((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 13)) OR ((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 14))))
123.          

SubPlan (for Index Scan)

124. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32.84..34.46 rows=6 width=32) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual rows= loops=)

  • Group Key: resentativeprojectassignment58.projectid
126. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Index Scan using uix2cr_clientuser on clientrepresentative clientrepresentative59 (cost=0.15..19.01 rows=8 width=16) (actual rows= loops=)

  • Index Cond: (userid = 492)
128. 0.000 0.000 ↓ 0.0

Index Scan using ixcrpaclientrepresentativeid on clientrepresentativeprojectassignment resentativeprojectassignment58 (cost=0.15..1.63 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (clientrepresentativeid = clientrepresentative59.id)
129. 0.000 0.000 ↓ 0.0

Index Only Scan using project_pkey on project project57 (cost=0.28..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = resentativeprojectassignment58.projectid)
130. 0.000 0.000 ↓ 0.0

Nested Loop (cost=33.12..39.50 rows=74 width=32) (actual rows= loops=)

  • Join Filter: (project61.id = task60.projectid)
131. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32.84..34.40 rows=6 width=8) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual rows= loops=)

  • Group Key: resentativeprojectassignment58_1.projectid
133. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Index Scan using uix2cr_clientuser on clientrepresentative clientrepresentative59_1 (cost=0.15..19.01 rows=8 width=16) (actual rows= loops=)

  • Index Cond: (userid = 492)
135. 0.000 0.000 ↓ 0.0

Index Scan using ixcrpaclientrepresentativeid on clientrepresentativeprojectassignment resentativeprojectassignment58_1 (cost=0.15..1.63 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (clientrepresentativeid = clientrepresentative59_1.id)
136. 0.000 0.000 ↓ 0.0

Index Only Scan using project_pkey on project project61 (cost=0.28..0.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = resentativeprojectassignment58_1.projectid)
137. 0.000 0.000 ↓ 0.0

Index Scan using ixtkprojectid on task task60 (cost=0.28..0.58 rows=12 width=8) (actual rows= loops=)

  • Index Cond: (projectid = resentativeprojectassignment58_1.projectid)
138. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..23.04 rows=1 width=32) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.11..18.92 rows=11 width=84) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..6.28 rows=1 width=4) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

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

142. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 492)
143. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes64 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest65.nodeid)
144. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet63 (cost=0.29..1.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes64.timesheetid)
  • Filter: ((startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate) AND (userid = timeentryrevision8.userid))
145. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue62 (cost=0.28..12.53 rows=11 width=88) (actual rows= loops=)

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

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

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

Nested Loop (cost=10.20..50.79 rows=1 width=32) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.78..50.25 rows=1 width=16) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.35..48.15 rows=1 width=16) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.92..47.61 rows=1 width=16) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.49..46.31 rows=1 width=16) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.07..44.66 rows=1 width=16) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.64..42.22 rows=1 width=16) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..34.26 rows=1 width=16) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet68 (cost=0.29..7.33 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeentryrevision8.userid) AND (startdate <= timeentryrevision8.entrydate) AND (enddate >= timeentryrevision8.entrydate))
156. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetid = timesheet68.id)
  • Filter: (userid = 492)
157. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue70 (cost=6.93..7.95 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory69.id) AND (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
158. 0.000 0.000 ↓ 0.0

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

159. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory69.id)
160. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text)
161. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue72.id)
164. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue74.id)
166. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue75.id)
167. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs timeoffs76 (cost=0.00..723.01 rows=8 width=4) (actual rows= loops=)

  • Filter: ((SubPlan 19) OR (SubPlan 20) OR (SubPlan 21) OR (SubPlan 22))
168.          

SubPlan (for Seq Scan)

169. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.40..23.04 rows=1 width=32) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.11..18.92 rows=11 width=84) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..6.28 rows=1 width=4) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

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

173. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 492)
174. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes79 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest80.nodeid)
175. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet78 (cost=0.29..1.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes79.timesheetid)
  • Filter: ((timeoffs76.startdate <= enddate) AND (timeoffs76.enddate >= startdate) AND (userid = timeoffs76.userid))
176. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvtsapprovalrequestid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue77 (cost=0.28..12.53 rows=11 width=88) (actual rows= loops=)

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

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

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

Nested Loop (cost=10.20..50.79 rows=1 width=32) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.78..50.25 rows=1 width=16) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.35..48.15 rows=1 width=16) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.92..47.61 rows=1 width=16) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.49..46.31 rows=1 width=16) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.07..44.66 rows=1 width=16) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.64..42.22 rows=1 width=16) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..34.26 rows=1 width=16) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet83 (cost=0.29..7.33 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeoffs76.userid) AND (timeoffs76.enddate >= startdate) AND (timeoffs76.startdate <= enddate))
187. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetid = timesheet83.id)
  • Filter: (userid = 492)
188. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue85 (cost=6.93..7.95 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory84.id) AND (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
189. 0.000 0.000 ↓ 0.0

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

190. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory84.id)
191. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text)
192. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue87.id)
195. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue89.id)
197. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue90.id)
198. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.52..10.03 rows=1 width=32) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.24..7.71 rows=1 width=84) (actual rows= loops=)

  • Join Filter: (tsapprovalrequest94.id = tsapprovalrequestkeyvalue91.tsapprovalrequestid)
200. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..6.28 rows=1 width=4) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

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

202. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = 492)
203. 0.000 0.000 ↓ 0.0

Index Scan using timesheetapprovalnodes_pkey on timesheetapprovalnodes timesheetapprovalnodes93 (cost=0.28..2.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (id = tsapprovalrequest94.nodeid)
204. 0.000 0.000 ↓ 0.0

Index Scan using timesheet_pkey on timesheet timesheet92 (cost=0.29..1.38 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = timesheetapprovalnodes93.timesheetid)
  • Filter: ((timeoffs76.startdate <= enddate) AND (timeoffs76.enddate >= startdate) AND (userid = timeoffs76.userid))
205. 0.000 0.000 ↓ 0.0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue91 (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)
206. 0.000 0.000 ↓ 0.0

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

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

Nested Loop (cost=10.20..53.17 rows=1 width=32) (actual rows= loops=)

208. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.78..52.63 rows=1 width=16) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.35..48.15 rows=1 width=16) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.92..47.61 rows=1 width=16) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.49..46.31 rows=1 width=16) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.07..44.66 rows=1 width=16) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.64..42.22 rows=1 width=16) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..34.26 rows=1 width=16) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet97 (cost=0.29..7.33 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((userid = timeoffs76.userid) AND (timeoffs76.enddate >= startdate) AND (timeoffs76.startdate <= enddate))
216. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetid = timesheet97.id)
  • Filter: (userid = 492)
217. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue99 (cost=6.93..7.95 rows=1 width=32) (actual rows= loops=)

  • Recheck Cond: ((timesheetapprovalhistoryid = timesheetapprovalhistory98.id) AND (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text))
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text)
218. 0.000 0.000 ↓ 0.0

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

219. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory98.id)
220. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (upper(uri) = 'URN:REPLICON-TENANT:FB4FFDC33B6B40529C88F1EBE6CDBB93:USER:492'::text)
221. 0.000 0.000 ↓ 0.0

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

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

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

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

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue101.id)
224. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue103.id)
226. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (parentid = heetapprovalhistorykeyvalue104.id)
227. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=724.66..1,332,359,550.73 rows=8 width=40) (actual rows= loops=)

  • Filter: ((SubPlan 18) OR (hashed SubPlan 23))
228. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.20..2.35 rows=11 width=140) (actual rows= loops=)

  • Hash Cond: (toe.timeoffid = toff.id)
229. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffentries toe (cost=0.00..1.11 rows=11 width=24) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=8) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Seq Scan on timeoffs toff (cost=0.00..1.09 rows=9 width=8) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Hash (cost=809.02..809.02 rows=7 width=69) (actual rows= loops=)

233. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.13..809.02 rows=7 width=69) (actual rows= loops=)

  • Join Filter: (ts.userid = ui.id)
234. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..806.61 rows=7 width=20) (actual rows= loops=)

235. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..793.56 rows=7 width=12) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

Index Scan using ixtsuseridstartdateenddate on timesheet ts (cost=0.29..780.41 rows=7 width=28) (actual rows= loops=)

  • Index Cond: ((startdate >= '2020-06-01'::date) AND (startdate <= '2020-06-30'::date) AND (enddate >= '2020-06-01'::date) AND (enddate <= '2020-06-30'::date))
237. 0.000 0.000 ↓ 0.0

Index Only Scan using ixdtslsftimesheetid on dm_timesheetlist_facts tslist (cost=0.29..1.88 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (timesheetid = ts.id)
238. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (userid = ts.userid)
239. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = login.userid)
240. 0.000 0.000 ↓ 0.0

Index Scan using ixtemtimeentryid on timeentrymetadata timeentrymetadata5 (cost=0.43..0.64 rows=1 width=68) (actual rows= loops=)

  • Index Cond: ("*SELECT* 1".timeentryid = timeentryid)
  • Filter: (upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text)
241. 0.000 0.000 ↓ 0.0

Index Only Scan using task_pkey on task task6 (cost=0.29..0.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = CASE WHEN ("substring"(timeentrymetadata5.uri, '^urn:replicon-tenant:fb4ffdc33b6b40529c88f1ebe6cdbb93:task:(.*)$'::text) ~ '^\s*[-]?[0-9]+\s*$'::text) THEN ("substring"(timeentrymetadata5.uri, '^urn:replicon-tenant:fb4ffdc33b6b40529c88f1ebe6cdbb93:task:(.*)$'::text))::integer ELSE NULL::integer END)
242. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..0.52 rows=1 width=25) (actual rows= loops=)

243. 0.000 0.000 ↓ 0.0

Index Scan using task_pkey on task tk (cost=0.28..0.34 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (task6.id = id)
244. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((variablecurrencyid = $0) AND (tk.estimatedcostcurrencyid = fixedcurrencyid) AND (('now'::cstring)::date >= effectivedate))
  • Filter: (('now'::cstring)::date <= enddate)