explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rUaB : PWC_query3

Settings
# exclusive inclusive rows x rows loops node
1. 0.918 6.580 ↓ 0.0 0 1

Index Scan using timeentryrevision_pkey on timeentryrevision timeentryrevision0 (cost=0.43..130,502.88 rows=145 width=16) (actual time=6.580..6.580 rows=0 loops=1)

  • Index Cond: (id = ANY ('{f848a403-6b6f-48cf-a5a8-cb8f9db13372,fbdc7e57-849c-4c7d-b38d-8683f40aa8cd,5af62bed-de04-4004-84ca-9c149df54bb2,7f5b374f-59de-4742-bd54-718b2cfc326f,bd91a843-010a-4b41-b062-a29adfdc7dc1,8ce647db-9852-4571-a2c7-807f70dabe6a,d46b9fe3-2133-4491-ac32-a789977e65c0,7330b8c7-2809-432b-b057-2a4009568e4e,0003fd29-bb5b-424d-bb27-6a707d24570b,feff3b9e-f74a-45b7-aedd-40d7452b3c66,43f9af3f-75a7-49a3-96a6-54959dbec69b,90817324-7481-4149-84f8-7abcda5640a8,7d25fc16-f169-44df-a5d2-13eeac2e5c07,6fc19de1-9160-461d-b855-4aa8e6d38136,7b10b342-04e1-4a1a-881b-200b32ae0c24,7362bbb3-df54-4919-a6ea-840d94aa047f,9f5ccd73-c887-4be7-99e8-7d2518d47ecf,b171c2d2-7c19-4246-bff7-36a046213667,d4e9d46b-a133-4159-945f-d9dd7cea729f,0d4c1f90-2e24-455c-b8f6-13f11a6f1177,c35d971b-1580-4808-8254-4c4fe4b08322,670d5500-674d-4ac5-af6d-32d9feab35c3,703ad832-4aac-4d5f-a363-1bbcd4414111,e54268da-65cf-492b-9009-f8342b8c0459,a8a1fb19-258b-42bf-8b8d-fb8ff5fe06c9,7ae13605-d6cd-46f7-a32b-c3b10c36f367,ebb9252c-2140-4bf3-8e9f-7045f6c8c716,bf5a5bff-8410-4765-8d98-6fa9ac71107a,b1b8a7e4-f97d-4d80-b0f1-92eaf66305d8,6fb6b44c-e625-41ac-9f43-c3413ce57eb3,1fa0d420-c9e9-489e-b959-d912845b690c,3092978b-c8a4-4958-a8d1-ca16d7250243,ee452dbd-25ec-409a-a364-55137a26c49f,e7a2e7fc-76e2-44f7-b116-1ea3f357742c,a5a407c8-d20e-43b7-b3a2-7e2c91d514d7,c1317518-80e0-4cfe-96c0-0e150d9c67c0,868d6b83-f7fc-4333-96ed-1008f1cf82bd,395793a9-8e10-4c4c-82f8-5705132dbb1d,bcce95e8-29e4-49e4-996b-03995524cec4,80338000-6406-492f-b96a-93e7ab40c492,8ecf04c0-5183-47b8-b0c9-d230da72497f,23bef3d0-7e03-49c8-b7ae-45362f70f140,8f4fa895-c5f4-4fa8-aa2b-bb9207fa4e22,03a0bec7-61a8-45d5-8279-e19744c8ecd2,4ecc2043-9ebb-4c8d-9c31-4ab7d03d5b46,423bcdbc-7e1c-487b-a681-0ddd686eca3a,26610a8a-7707-417a-be6b-ba4307bfad2f,9010c438-6c5b-4c1c-90b7-27f16e2300f2,9c1bac58-4cea-41e8-91f0-f458d8c5ce0e,c9b197c7-30a5-4353-8541-85e9658696cc,03bb32d7-1f3a-45c2-9e1d-40eadc643c3e,92aa54c2-63a8-4db1-b95a-3478bef30343,11649295-113e-49af-9a4c-9796bf91d015,8e7c77fc-81e0-41fc-b198-3fd13b31fcec,45930ef2-885f-4efc-95e9-104d48f5dde4,cea46c64-60d2-49f5-abba-08b5db09ff20,9970e6d2-a4a6-4f12-b9ae-52378f3ff6f5,a0276526-c7fe-42cd-9fb1-d1710b5bb1c5,980eea3f-3bd6-493b-8ab0-674ea36edf78,a7fbf23c-9468-4391-8574-3877feea11be,351f623e-102c-4ef7-93db-98f32bc1b613,e34dc342-d351-4489-a1e8-2a6ee435de6d,7b69f126-439d-42f1-914c-99fa6eba3017,b8d58fce-073c-456c-bd83-a38415c710b7,3fc34173-430c-4f7a-bc8e-9d418bf609c4,2a5f741d-48c3-47ab-8d54-84162a21c7d4,6fcf197d-1eac-4aa3-9224-4a864d3eb236,cdb97004-5c82-49d8-90b3-d687984d08aa,673327cc-0963-43ff-a7ee-ea5878732efc,73b1c962-eb9d-47b9-9de0-6927d2e50d61,8c4d5a46-e2ba-45ee-9ada-30aa584f0855,4a830068-299a-4a99-be6e-9ae85fa07e82,10e2fab8-c501-4a70-a779-ec2dfd451e2e,1286049d-5077-4cbb-8ae7-ff302ef2c01c,d59be246-0df3-4b2f-b6b4-8f53524406f1,47222b4b-0506-48c0-a66a-8384c6a0731f,b978e14c-b58f-4539-a6d2-c58a09c22453,f333abe6-92b8-4cb0-b25b-e255c6bcbbf0,ad4d1459-90b5-486e-a233-8339c2ef85bf,3defdc6c-932d-428d-81c0-3f2b001f7d2b,37caf46e-8c9e-4c8b-8e65-4e742655cc81,16e8ca60-1538-4b6a-a746-89f8e7b9a7f4,8d379271-aa69-4e63-ba56-f2dc40977b86,c2b2b973-c652-4905-bc30-6833912bec7f,5a91c631-4b2d-474b-9db2-b66d6fb7ca0f,e4444865-13fe-463a-80c4-032f17fbd754,138fa3d3-bc62-47ac-bf40-860174200e6e,9781f38b-a681-469d-bc60-acfe85e2d2b0,c3890ea3-7b77-41aa-9b27-f557b1fb7ac0,56a2cd86-3617-4da8-82cb-07219e81a267,f8d4d1ce-b6c3-45ee-a560-2d08d366c0f6,ed08142a-2fb5-4c75-ad3b-84faefcf7da2,e151d7d3-c6b1-4745-b67b-a15d810c3e2d,8c2ef23a-0a1a-435f-8a8e-93f423b4faf6,fbe94099-23de-4a2a-a87f-ffbed355e7a3,c78487b1-4059-465e-a8f1-e57205fec018,5b02dde3-d5f4-4edd-9292-96dbf9de589a,33c7e331-1282-4d43-be52-79c22d6d8345,0b667fb7-dd67-4aff-a632-803a5aab9569,db62d669-99fb-4573-be11-4ec70b7b94c1,eed59649-244b-4676-a18c-3f8402ec6eaa,75490890-5d17-4940-87ff-87fe5b61a262,e7a3f4fb-a58c-4d54-95d1-d44a6e8307f3,4a0ccccd-d246-4d1f-995b-a5616f9bf8cd,2ee91945-1bc7-4337-a97c-55fea9a69895,eca0aef5-e3f1-4e85-b048-fa751f55c6e1,dd7e07da-f407-4928-8733-95f9e6d680a5,9b13364a-cd60-4fc3-a665-52220b9105c8,b9902b48-fefd-4243-9f4e-67488461094f,3846ee3a-4eef-4485-ad3b-03a9ac1fb44d,d070dd9c-4ce2-4ca3-b35c-2509c5844559,1ffc67e0-67d5-4032-ab09-ed2bea5f9d24,5939e0c2-41c2-4a1a-b4ae-fac977c4c96b,7bb75fd1-60f7-417e-a060-7201b62ddf2c,3fdbb282-1895-4a8d-8722-f77c32301a0f,b1c0db14-29a3-45a8-84b0-a14c9f12f1fc,87c8083d-a564-4a4b-ac61-c6ee5836d0b4,2ccf3667-7263-41bf-868a-a0f645bc052a,02d8dbda-28e9-405b-97ab-bd69d2f60718,d02ce13f-49f4-4329-be51-61f11b970c68,1d712f24-7131-489b-83c4-03e057e92776,88861a6c-0bb5-4c3f-b797-eea6f8189039,5d446bea-2993-4f55-a043-e8aee4453333,518f70b6-b45b-4019-8852-c12dd5ab19b5,4eec0a9f-6f80-4b4d-8891-4367df993e21,f6f6e7db-e7df-4fc0-833f-d1e5d43de71a,41aa4c59-f1c2-475d-b969-b4be4cfcb8d9,fc8a2125-76a3-4d4b-a9ce-12d7afe0e31e,48e86fd0-9531-43d0-899d-21002b755d1b,c2dc9e35-1165-4228-8c16-6ae709dfd472,653dbbd1-4643-49f5-8ac9-c1161a48d341,333d94e6-b21d-4f43-be34-ceb92d716d47,8fc0d632-a05e-4e45-9832-7ce9012718dc,9fc058a8-d633-4e9d-bcf9-ecd00d9d592e,001d6c71-72fe-44d9-8a22-84095112084e,3af0c6b3-f7e4-4b9a-b4e8-5db3c70d4aa7,2f1d1d2d-1e1b-4db1-9938-19da99c86fe3,e4d74262-dfa2-4a33-b35e-6810c23813ca,2fd88726-6f59-44d2-a6b0-9fd5f7967226,ba020c30-c46c-4f82-918d-639708db9a32,bc02daf1-6be0-4b44-8a3c-6bd406472186,95dbf102-e216-42d9-867a-423337b59b11,1627b553-91f9-4129-a803-35617939c368,a6402874-3608-499a-837c-34077e1e079c,bc1a2a6e-2e4c-4714-887a-290cb08e5d94,d73e625c-bc6f-4d66-bf76-e1120d8fbb43,bc2cc316-df72-4721-8d30-ae1f3be29e48,5e837c94-922a-407b-9bbb-b9071117f603,c7c536bf-11d7-4f7d-90ee-0d64be9180fa}'::uuid[]))
  • Filter: ((SubPlan 1) OR (SubPlan 2) OR (SubPlan 3) OR (SubPlan 4) OR ((SubPlan 7) AND ((SubPlan 8) OR (SubPlan 9))) OR ((SubPlan 12) AND ((SubPlan 13) OR (SubPlan 14))))
  • Rows Removed by Filter: 149
  • Buffers: shared hit=5,524
2.          

SubPlan (for Index Scan)

3. 0.000 0.298 ↓ 0.0 0 149

Nested Loop (cost=0.71..11.82 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=149)

  • Join Filter: (tsapprovalrequestkeyvalue1.parentid = tsapprovalrequestkeyvalue5.id)
  • Buffers: shared hit=298
4. 0.000 0.298 ↓ 0.0 0 149

Nested Loop (cost=0.56..9.64 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=149)

  • Join Filter: (tsapprovalrequest4.id = tsapprovalrequestkeyvalue1.tsapprovalrequestid)
  • Buffers: shared hit=298
5. 0.149 0.298 ↓ 0.0 0 149

Nested Loop (cost=0.42..7.47 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=149)

  • Join Filter: (timesheetapprovalnodes3.id = tsapprovalrequest4.nodeid)
  • Buffers: shared hit=298
6. 0.000 0.149 ↓ 0.0 0 149

Nested Loop (cost=0.42..5.46 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=149)

  • Buffers: shared hit=298
7. 0.149 0.149 ↓ 0.0 0 149

Seq Scan on timesheetapprovalnodes timesheetapprovalnodes3 (cost=0.00..2.00 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=149)

  • Buffers: shared hit=298
8. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on timesheet timesheet2 (cost=0.42..2.45 rows=1 width=16) (never executed)

  • Index Cond: (id = timesheetapprovalnodes3.timesheetid)
  • Filter: ((startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate) AND (userid = timeentryrevision0.userid))
9. 0.000 0.000 ↓ 0.0 0

Seq Scan on tsapprovalrequest tsapprovalrequest4 (cost=0.00..2.00 rows=1 width=20) (never executed)

  • Filter: (userid = 2)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue1 (cost=0.14..2.16 rows=1 width=52) (never executed)

  • Index Cond: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvparentid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue5 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Index Cond: (parentid IS NULL)
12. 0.000 1.192 ↓ 0.0 0 149

Nested Loop (cost=3.87..54.52 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=149)

  • Buffers: shared hit=1,363
13. 0.149 1.192 ↓ 0.0 0 149

Nested Loop (cost=3.44..54.00 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=149)

  • Buffers: shared hit=1,363
14. 0.000 1.043 ↓ 0.0 0 149

Nested Loop (cost=3.01..50.51 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
15. 0.000 1.043 ↓ 0.0 0 149

Nested Loop (cost=2.58..49.99 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
16. 0.000 1.043 ↓ 0.0 0 149

Nested Loop (cost=2.14..48.72 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
17. 0.000 1.043 ↓ 0.0 0 149

Nested Loop (cost=1.71..45.23 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
18. 0.000 1.043 ↓ 0.0 0 149

Nested Loop (cost=1.28..42.78 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
19. 0.149 1.043 ↓ 0.0 0 149

Nested Loop (cost=0.84..24.13 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
20. 0.447 0.447 ↑ 3.0 1 149

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet7 (cost=0.42..4.53 rows=3 width=16) (actual time=0.003..0.003 rows=1 loops=149)

  • Index Cond: ((userid = timeentryrevision0.userid) AND (startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate))
  • Buffers: shared hit=608
21. 0.447 0.447 ↓ 0.0 0 149

Index Scan using ixtah2timesheetid on timesheetapprovalhistory timesheetapprovalhistory8 (cost=0.42..6.52 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=149)

  • Index Cond: (timesheetid = timesheet7.id)
  • Filter: (userid = 2)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=755
22. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue9 (cost=0.43..18.64 rows=1 width=32) (never executed)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory8.id)
  • Filter: ((upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(uri) = 'URN:REPLICON-TENANT:1B8A55AA5F704DEA918923FE2DAF8CDA:USER:2'::text))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue10 (cost=0.43..2.42 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue11 (cost=0.43..3.48 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue12 (cost=0.43..1.25 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue11.id)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue13 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue14 (cost=0.43..3.47 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue13.id)
28. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue esheetapprovalhistorykeyvalue6 (cost=0.43..0.50 rows=2 width=94) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue14.id)
29. 0.000 0.298 ↓ 0.0 0 149

Nested Loop (cost=0.71..11.82 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=149)

  • Join Filter: (tsapprovalrequestkeyvalue15.parentid = tsapprovalrequestkeyvalue19.id)
  • Buffers: shared hit=298
30. 0.149 0.298 ↓ 0.0 0 149

Nested Loop (cost=0.56..9.64 rows=1 width=48) (actual time=0.002..0.002 rows=0 loops=149)

  • Join Filter: (tsapprovalrequest18.id = tsapprovalrequestkeyvalue15.tsapprovalrequestid)
  • Buffers: shared hit=298
31. 0.000 0.149 ↓ 0.0 0 149

Nested Loop (cost=0.42..7.47 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=149)

  • Join Filter: (timesheetapprovalnodes17.id = tsapprovalrequest18.nodeid)
  • Buffers: shared hit=298
32. 0.000 0.149 ↓ 0.0 0 149

Nested Loop (cost=0.42..5.46 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=149)

  • Buffers: shared hit=298
33. 0.149 0.149 ↓ 0.0 0 149

Seq Scan on timesheetapprovalnodes timesheetapprovalnodes17 (cost=0.00..2.00 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=149)

  • Buffers: shared hit=298
34. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on timesheet timesheet16 (cost=0.42..2.45 rows=1 width=16) (never executed)

  • Index Cond: (id = timesheetapprovalnodes17.timesheetid)
  • Filter: ((startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate) AND (userid = timeentryrevision0.userid))
35. 0.000 0.000 ↓ 0.0 0

Seq Scan on tsapprovalrequest tsapprovalrequest18 (cost=0.00..2.00 rows=1 width=20) (never executed)

  • Filter: (userid = 2)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue15 (cost=0.14..2.16 rows=1 width=52) (never executed)

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

Index Scan using ixtsarkvparentid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue19 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Index Cond: (parentid IS NULL)
38. 0.149 1.043 ↓ 0.0 0 149

Nested Loop (cost=3.87..54.52 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=149)

  • Buffers: shared hit=1,363
39. 0.000 0.894 ↓ 0.0 0 149

Nested Loop (cost=3.44..54.00 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=1,363
40. 0.000 0.894 ↓ 0.0 0 149

Nested Loop (cost=3.01..50.51 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=1,363
41. 0.000 0.894 ↓ 0.0 0 149

Nested Loop (cost=2.58..49.99 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=1,363
42. 0.000 0.894 ↓ 0.0 0 149

Nested Loop (cost=2.14..48.72 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=1,363
43. 0.000 0.894 ↓ 0.0 0 149

Nested Loop (cost=1.71..45.23 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=1,363
44. 0.149 0.894 ↓ 0.0 0 149

Nested Loop (cost=1.28..42.78 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=1,363
45. 0.000 0.745 ↓ 0.0 0 149

Nested Loop (cost=0.84..24.13 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=149)

  • Buffers: shared hit=1,363
46. 0.447 0.447 ↑ 3.0 1 149

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet21 (cost=0.42..4.53 rows=3 width=16) (actual time=0.002..0.003 rows=1 loops=149)

  • Index Cond: ((userid = timeentryrevision0.userid) AND (startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate))
  • Buffers: shared hit=608
47. 0.298 0.298 ↓ 0.0 0 149

Index Scan using ixtah2timesheetid on timesheetapprovalhistory timesheetapprovalhistory22 (cost=0.42..6.52 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=149)

  • Index Cond: (timesheetid = timesheet21.id)
  • Filter: (userid = 2)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=755
48. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue23 (cost=0.43..18.64 rows=1 width=32) (never executed)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory22.id)
  • Filter: ((upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(uri) = 'URN:REPLICON-TENANT:1B8A55AA5F704DEA918923FE2DAF8CDA:USER:2'::text))
49. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue24 (cost=0.43..2.42 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue25 (cost=0.43..3.48 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue26 (cost=0.43..1.25 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue25.id)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue27 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue28 (cost=0.43..3.47 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue27.id)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue20 (cost=0.43..0.50 rows=2 width=94) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue28.id)
55. 0.000 1.937 ↓ 0.0 0 149

Nested Loop Semi Join (cost=600.49..624.88 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=149)

  • Buffers: shared hit=826
56. 1.751 1.937 ↓ 0.0 0 149

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision29 (cost=600.06..619.82 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=149)

  • Index Cond: (timeentryid = timeentryrevision0.timeentryid)
  • Filter: ((fromtimestamputc <= timeentryrevision0.fromtimestamputc) AND ((totimestamputc > timeentryrevision0.fromtimestamputc) OR (totimestamputc IS NULL)) AND (((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 5)) OR ((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 6))))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=826
57.          

SubPlan (for Index Scan)

58. 0.024 0.024 ↑ 6.7 6 1

Index Scan using ixprjprojectleaderapproverid on project project31 (cost=0.42..42.49 rows=40 width=32) (actual time=0.015..0.024 rows=6 loops=1)

  • Index Cond: (projectleaderapproverid = 2)
  • Buffers: shared hit=7
59. 0.083 0.162 ↑ 2.6 85 1

Nested Loop (cost=0.84..556.34 rows=223 width=32) (actual time=0.032..0.162 rows=85 loops=1)

  • Buffers: shared hit=39
60. 0.013 0.013 ↑ 6.7 6 1

Index Scan using ixprjprojectleaderapproverid on project project33 (cost=0.42..42.09 rows=40 width=4) (actual time=0.011..0.013 rows=6 loops=1)

  • Index Cond: (projectleaderapproverid = 2)
  • Buffers: shared hit=7
61. 0.066 0.066 ↑ 1.0 14 6

Index Scan using ixtkprojectid on task task32 (cost=0.42..12.66 rows=14 width=8) (actual time=0.007..0.011 rows=14 loops=6)

  • Index Cond: (projectid = project33.id)
  • Buffers: shared hit=32
62. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtertimeentryid on timeentryrevision timeentryrevision30 (cost=0.43..5.04 rows=1 width=16) (never executed)

  • Index Cond: (timeentryid = timeentryrevision0.timeentryid)
  • Filter: (id = ANY ('{f848a403-6b6f-48cf-a5a8-cb8f9db13372,fbdc7e57-849c-4c7d-b38d-8683f40aa8cd,5af62bed-de04-4004-84ca-9c149df54bb2,7f5b374f-59de-4742-bd54-718b2cfc326f,bd91a843-010a-4b41-b062-a29adfdc7dc1,8ce647db-9852-4571-a2c7-807f70dabe6a,d46b9fe3-2133-4491-ac32-a789977e65c0,7330b8c7-2809-432b-b057-2a4009568e4e,0003fd29-bb5b-424d-bb27-6a707d24570b,feff3b9e-f74a-45b7-aedd-40d7452b3c66,43f9af3f-75a7-49a3-96a6-54959dbec69b,90817324-7481-4149-84f8-7abcda5640a8,7d25fc16-f169-44df-a5d2-13eeac2e5c07,6fc19de1-9160-461d-b855-4aa8e6d38136,7b10b342-04e1-4a1a-881b-200b32ae0c24,7362bbb3-df54-4919-a6ea-840d94aa047f,9f5ccd73-c887-4be7-99e8-7d2518d47ecf,b171c2d2-7c19-4246-bff7-36a046213667,d4e9d46b-a133-4159-945f-d9dd7cea729f,0d4c1f90-2e24-455c-b8f6-13f11a6f1177,c35d971b-1580-4808-8254-4c4fe4b08322,670d5500-674d-4ac5-af6d-32d9feab35c3,703ad832-4aac-4d5f-a363-1bbcd4414111,e54268da-65cf-492b-9009-f8342b8c0459,a8a1fb19-258b-42bf-8b8d-fb8ff5fe06c9,7ae13605-d6cd-46f7-a32b-c3b10c36f367,ebb9252c-2140-4bf3-8e9f-7045f6c8c716,bf5a5bff-8410-4765-8d98-6fa9ac71107a,b1b8a7e4-f97d-4d80-b0f1-92eaf66305d8,6fb6b44c-e625-41ac-9f43-c3413ce57eb3,1fa0d420-c9e9-489e-b959-d912845b690c,3092978b-c8a4-4958-a8d1-ca16d7250243,ee452dbd-25ec-409a-a364-55137a26c49f,e7a2e7fc-76e2-44f7-b116-1ea3f357742c,a5a407c8-d20e-43b7-b3a2-7e2c91d514d7,c1317518-80e0-4cfe-96c0-0e150d9c67c0,868d6b83-f7fc-4333-96ed-1008f1cf82bd,395793a9-8e10-4c4c-82f8-5705132dbb1d,bcce95e8-29e4-49e4-996b-03995524cec4,80338000-6406-492f-b96a-93e7ab40c492,8ecf04c0-5183-47b8-b0c9-d230da72497f,23bef3d0-7e03-49c8-b7ae-45362f70f140,8f4fa895-c5f4-4fa8-aa2b-bb9207fa4e22,03a0bec7-61a8-45d5-8279-e19744c8ecd2,4ecc2043-9ebb-4c8d-9c31-4ab7d03d5b46,423bcdbc-7e1c-487b-a681-0ddd686eca3a,26610a8a-7707-417a-be6b-ba4307bfad2f,9010c438-6c5b-4c1c-90b7-27f16e2300f2,9c1bac58-4cea-41e8-91f0-f458d8c5ce0e,c9b197c7-30a5-4353-8541-85e9658696cc,03bb32d7-1f3a-45c2-9e1d-40eadc643c3e,92aa54c2-63a8-4db1-b95a-3478bef30343,11649295-113e-49af-9a4c-9796bf91d015,8e7c77fc-81e0-41fc-b198-3fd13b31fcec,45930ef2-885f-4efc-95e9-104d48f5dde4,cea46c64-60d2-49f5-abba-08b5db09ff20,9970e6d2-a4a6-4f12-b9ae-52378f3ff6f5,a0276526-c7fe-42cd-9fb1-d1710b5bb1c5,980eea3f-3bd6-493b-8ab0-674ea36edf78,a7fbf23c-9468-4391-8574-3877feea11be,351f623e-102c-4ef7-93db-98f32bc1b613,e34dc342-d351-4489-a1e8-2a6ee435de6d,7b69f126-439d-42f1-914c-99fa6eba3017,b8d58fce-073c-456c-bd83-a38415c710b7,3fc34173-430c-4f7a-bc8e-9d418bf609c4,2a5f741d-48c3-47ab-8d54-84162a21c7d4,6fcf197d-1eac-4aa3-9224-4a864d3eb236,cdb97004-5c82-49d8-90b3-d687984d08aa,673327cc-0963-43ff-a7ee-ea5878732efc,73b1c962-eb9d-47b9-9de0-6927d2e50d61,8c4d5a46-e2ba-45ee-9ada-30aa584f0855,4a830068-299a-4a99-be6e-9ae85fa07e82,10e2fab8-c501-4a70-a779-ec2dfd451e2e,1286049d-5077-4cbb-8ae7-ff302ef2c01c,d59be246-0df3-4b2f-b6b4-8f53524406f1,47222b4b-0506-48c0-a66a-8384c6a0731f,b978e14c-b58f-4539-a6d2-c58a09c22453,f333abe6-92b8-4cb0-b25b-e255c6bcbbf0,ad4d1459-90b5-486e-a233-8339c2ef85bf,3defdc6c-932d-428d-81c0-3f2b001f7d2b,37caf46e-8c9e-4c8b-8e65-4e742655cc81,16e8ca60-1538-4b6a-a746-89f8e7b9a7f4,8d379271-aa69-4e63-ba56-f2dc40977b86,c2b2b973-c652-4905-bc30-6833912bec7f,5a91c631-4b2d-474b-9db2-b66d6fb7ca0f,e4444865-13fe-463a-80c4-032f17fbd754,138fa3d3-bc62-47ac-bf40-860174200e6e,9781f38b-a681-469d-bc60-acfe85e2d2b0,c3890ea3-7b77-41aa-9b27-f557b1fb7ac0,56a2cd86-3617-4da8-82cb-07219e81a267,f8d4d1ce-b6c3-45ee-a560-2d08d366c0f6,ed08142a-2fb5-4c75-ad3b-84faefcf7da2,e151d7d3-c6b1-4745-b67b-a15d810c3e2d,8c2ef23a-0a1a-435f-8a8e-93f423b4faf6,fbe94099-23de-4a2a-a87f-ffbed355e7a3,c78487b1-4059-465e-a8f1-e57205fec018,5b02dde3-d5f4-4edd-9292-96dbf9de589a,33c7e331-1282-4d43-be52-79c22d6d8345,0b667fb7-dd67-4aff-a632-803a5aab9569,db62d669-99fb-4573-be11-4ec70b7b94c1,eed59649-244b-4676-a18c-3f8402ec6eaa,75490890-5d17-4940-87ff-87fe5b61a262,e7a3f4fb-a58c-4d54-95d1-d44a6e8307f3,4a0ccccd-d246-4d1f-995b-a5616f9bf8cd,2ee91945-1bc7-4337-a97c-55fea9a69895,eca0aef5-e3f1-4e85-b048-fa751f55c6e1,dd7e07da-f407-4928-8733-95f9e6d680a5,9b13364a-cd60-4fc3-a665-52220b9105c8,b9902b48-fefd-4243-9f4e-67488461094f,3846ee3a-4eef-4485-ad3b-03a9ac1fb44d,d070dd9c-4ce2-4ca3-b35c-2509c5844559,1ffc67e0-67d5-4032-ab09-ed2bea5f9d24,5939e0c2-41c2-4a1a-b4ae-fac977c4c96b,7bb75fd1-60f7-417e-a060-7201b62ddf2c,3fdbb282-1895-4a8d-8722-f77c32301a0f,b1c0db14-29a3-45a8-84b0-a14c9f12f1fc,87c8083d-a564-4a4b-ac61-c6ee5836d0b4,2ccf3667-7263-41bf-868a-a0f645bc052a,02d8dbda-28e9-405b-97ab-bd69d2f60718,d02ce13f-49f4-4329-be51-61f11b970c68,1d712f24-7131-489b-83c4-03e057e92776,88861a6c-0bb5-4c3f-b797-eea6f8189039,5d446bea-2993-4f55-a043-e8aee4453333,518f70b6-b45b-4019-8852-c12dd5ab19b5,4eec0a9f-6f80-4b4d-8891-4367df993e21,f6f6e7db-e7df-4fc0-833f-d1e5d43de71a,41aa4c59-f1c2-475d-b969-b4be4cfcb8d9,fc8a2125-76a3-4d4b-a9ce-12d7afe0e31e,48e86fd0-9531-43d0-899d-21002b755d1b,c2dc9e35-1165-4228-8c16-6ae709dfd472,653dbbd1-4643-49f5-8ac9-c1161a48d341,333d94e6-b21d-4f43-be34-ceb92d716d47,8fc0d632-a05e-4e45-9832-7ce9012718dc,9fc058a8-d633-4e9d-bcf9-ecd00d9d592e,001d6c71-72fe-44d9-8a22-84095112084e,3af0c6b3-f7e4-4b9a-b4e8-5db3c70d4aa7,2f1d1d2d-1e1b-4db1-9938-19da99c86fe3,e4d74262-dfa2-4a33-b35e-6810c23813ca,2fd88726-6f59-44d2-a6b0-9fd5f7967226,ba020c30-c46c-4f82-918d-639708db9a32,bc02daf1-6be0-4b44-8a3c-6bd406472186,95dbf102-e216-42d9-867a-423337b59b11,1627b553-91f9-4129-a803-35617939c368,a6402874-3608-499a-837c-34077e1e079c,bc1a2a6e-2e4c-4714-887a-290cb08e5d94,d73e625c-bc6f-4d66-bf76-e1120d8fbb43,bc2cc316-df72-4721-8d30-ae1f3be29e48,5e837c94-922a-407b-9bbb-b9071117f603,c7c536bf-11d7-4f7d-90ee-0d64be9180fa}'::uuid[]))
63. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..11.82 rows=1 width=32) (never executed)

  • Join Filter: (tsapprovalrequestkeyvalue34.parentid = tsapprovalrequestkeyvalue38.id)
64. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..9.64 rows=1 width=48) (never executed)

  • Join Filter: (tsapprovalrequest37.id = tsapprovalrequestkeyvalue34.tsapprovalrequestid)
65. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..7.47 rows=1 width=4) (never executed)

  • Join Filter: (timesheetapprovalnodes36.id = tsapprovalrequest37.nodeid)
66. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..5.46 rows=1 width=16) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Seq Scan on timesheetapprovalnodes timesheetapprovalnodes36 (cost=0.00..2.00 rows=1 width=32) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on timesheet timesheet35 (cost=0.42..2.45 rows=1 width=16) (never executed)

  • Index Cond: (id = timesheetapprovalnodes36.timesheetid)
  • Filter: ((startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate) AND (userid = timeentryrevision0.userid))
69. 0.000 0.000 ↓ 0.0 0

Seq Scan on tsapprovalrequest tsapprovalrequest37 (cost=0.00..2.00 rows=1 width=20) (never executed)

  • Filter: (userid = 2)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue34 (cost=0.14..2.16 rows=1 width=52) (never executed)

  • Index Cond: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvparentid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue38 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Index Cond: (parentid IS NULL)
72. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.87..54.52 rows=1 width=32) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.44..54.00 rows=1 width=16) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.01..50.51 rows=1 width=16) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.58..49.99 rows=1 width=16) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.14..48.72 rows=1 width=16) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..45.23 rows=1 width=16) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..42.78 rows=1 width=16) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..24.13 rows=1 width=16) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet40 (cost=0.42..4.53 rows=3 width=16) (never executed)

  • Index Cond: ((userid = timeentryrevision0.userid) AND (startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate))
81. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtah2timesheetid on timesheetapprovalhistory timesheetapprovalhistory41 (cost=0.42..6.52 rows=1 width=32) (never executed)

  • Index Cond: (timesheetid = timesheet40.id)
  • Filter: (userid = 2)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue42 (cost=0.43..18.64 rows=1 width=32) (never executed)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory41.id)
  • Filter: ((upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(uri) = 'URN:REPLICON-TENANT:1B8A55AA5F704DEA918923FE2DAF8CDA:USER:2'::text))
83. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue43 (cost=0.43..2.42 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue44 (cost=0.43..3.48 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue45 (cost=0.43..1.25 rows=2 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue46 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue47 (cost=0.43..3.47 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue46.id)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue39 (cost=0.43..0.50 rows=2 width=94) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue47.id)
89. 0.000 0.894 ↓ 0.0 0 149

Nested Loop Semi Join (cost=82.24..106.63 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=149)

  • Buffers: shared hit=782
90. 0.874 0.894 ↓ 0.0 0 149

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision timeentrymetadatarevision48 (cost=81.81..101.57 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=149)

  • Index Cond: (timeentryid = timeentryrevision0.timeentryid)
  • Filter: ((fromtimestamputc <= timeentryrevision0.fromtimestamputc) AND ((totimestamputc > timeentryrevision0.fromtimestamputc) OR (totimestamputc IS NULL)) AND (((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:PROJECT'::text) AND (hashed SubPlan 10)) OR ((upper(key) = 'URN:REPLICON:TIME-ENTRY-METADATA-KEY:TASK'::text) AND (hashed SubPlan 11))))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=782
91.          

SubPlan (for Index Scan)

92. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=32.98..37.38 rows=6 width=32) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=1
93. 0.001 0.012 ↓ 0.0 0 1

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Group Key: resentativeprojectassignment51.projectid
  • Buffers: shared hit=1
94. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
95. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on clientrepresentative clientrepresentative52 (cost=0.15..19.01 rows=8 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (userid = 2)
  • Buffers: shared hit=1
96. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcrpaclientrepresentativeid on clientrepresentativeprojectassignment resentativeprojectassignment51 (cost=0.15..1.63 rows=6 width=20) (never executed)

  • Index Cond: (clientrepresentativeid = clientrepresentative52.id)
97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project50 (cost=0.42..0.78 rows=1 width=4) (never executed)

  • Index Cond: (id = resentativeprojectassignment51.projectid)
  • Heap Fetches: 0
98. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=33.41..43.64 rows=86 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Buffers: shared hit=1
99. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=32.98..37.32 rows=6 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Buffers: shared hit=1
100. 0.001 0.008 ↓ 0.0 0 1

HashAggregate (cost=32.56..32.62 rows=6 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: resentativeprojectassignment51_1.projectid
  • Buffers: shared hit=1
101. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.30..32.55 rows=6 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Buffers: shared hit=1
102. 0.007 0.007 ↓ 0.0 0 1

Index Scan using uix2cr_clientuser on clientrepresentative clientrepresentative52_1 (cost=0.15..19.01 rows=8 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (userid = 2)
  • Buffers: shared hit=1
103. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcrpaclientrepresentativeid on clientrepresentativeprojectassignment resentativeprojectassignment51_1 (cost=0.15..1.63 rows=6 width=20) (never executed)

  • Index Cond: (clientrepresentativeid = clientrepresentative52_1.id)
104. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on project project54 (cost=0.42..0.78 rows=1 width=4) (never executed)

  • Index Cond: (id = resentativeprojectassignment51_1.projectid)
  • Heap Fetches: 0
105. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtkprojectid on task task53 (cost=0.42..0.77 rows=14 width=8) (never executed)

  • Index Cond: (projectid = project54.id)
106. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtertimeentryid on timeentryrevision timeentryrevision49 (cost=0.43..5.04 rows=1 width=16) (never executed)

  • Index Cond: (timeentryid = timeentryrevision0.timeentryid)
  • Filter: (id = ANY ('{f848a403-6b6f-48cf-a5a8-cb8f9db13372,fbdc7e57-849c-4c7d-b38d-8683f40aa8cd,5af62bed-de04-4004-84ca-9c149df54bb2,7f5b374f-59de-4742-bd54-718b2cfc326f,bd91a843-010a-4b41-b062-a29adfdc7dc1,8ce647db-9852-4571-a2c7-807f70dabe6a,d46b9fe3-2133-4491-ac32-a789977e65c0,7330b8c7-2809-432b-b057-2a4009568e4e,0003fd29-bb5b-424d-bb27-6a707d24570b,feff3b9e-f74a-45b7-aedd-40d7452b3c66,43f9af3f-75a7-49a3-96a6-54959dbec69b,90817324-7481-4149-84f8-7abcda5640a8,7d25fc16-f169-44df-a5d2-13eeac2e5c07,6fc19de1-9160-461d-b855-4aa8e6d38136,7b10b342-04e1-4a1a-881b-200b32ae0c24,7362bbb3-df54-4919-a6ea-840d94aa047f,9f5ccd73-c887-4be7-99e8-7d2518d47ecf,b171c2d2-7c19-4246-bff7-36a046213667,d4e9d46b-a133-4159-945f-d9dd7cea729f,0d4c1f90-2e24-455c-b8f6-13f11a6f1177,c35d971b-1580-4808-8254-4c4fe4b08322,670d5500-674d-4ac5-af6d-32d9feab35c3,703ad832-4aac-4d5f-a363-1bbcd4414111,e54268da-65cf-492b-9009-f8342b8c0459,a8a1fb19-258b-42bf-8b8d-fb8ff5fe06c9,7ae13605-d6cd-46f7-a32b-c3b10c36f367,ebb9252c-2140-4bf3-8e9f-7045f6c8c716,bf5a5bff-8410-4765-8d98-6fa9ac71107a,b1b8a7e4-f97d-4d80-b0f1-92eaf66305d8,6fb6b44c-e625-41ac-9f43-c3413ce57eb3,1fa0d420-c9e9-489e-b959-d912845b690c,3092978b-c8a4-4958-a8d1-ca16d7250243,ee452dbd-25ec-409a-a364-55137a26c49f,e7a2e7fc-76e2-44f7-b116-1ea3f357742c,a5a407c8-d20e-43b7-b3a2-7e2c91d514d7,c1317518-80e0-4cfe-96c0-0e150d9c67c0,868d6b83-f7fc-4333-96ed-1008f1cf82bd,395793a9-8e10-4c4c-82f8-5705132dbb1d,bcce95e8-29e4-49e4-996b-03995524cec4,80338000-6406-492f-b96a-93e7ab40c492,8ecf04c0-5183-47b8-b0c9-d230da72497f,23bef3d0-7e03-49c8-b7ae-45362f70f140,8f4fa895-c5f4-4fa8-aa2b-bb9207fa4e22,03a0bec7-61a8-45d5-8279-e19744c8ecd2,4ecc2043-9ebb-4c8d-9c31-4ab7d03d5b46,423bcdbc-7e1c-487b-a681-0ddd686eca3a,26610a8a-7707-417a-be6b-ba4307bfad2f,9010c438-6c5b-4c1c-90b7-27f16e2300f2,9c1bac58-4cea-41e8-91f0-f458d8c5ce0e,c9b197c7-30a5-4353-8541-85e9658696cc,03bb32d7-1f3a-45c2-9e1d-40eadc643c3e,92aa54c2-63a8-4db1-b95a-3478bef30343,11649295-113e-49af-9a4c-9796bf91d015,8e7c77fc-81e0-41fc-b198-3fd13b31fcec,45930ef2-885f-4efc-95e9-104d48f5dde4,cea46c64-60d2-49f5-abba-08b5db09ff20,9970e6d2-a4a6-4f12-b9ae-52378f3ff6f5,a0276526-c7fe-42cd-9fb1-d1710b5bb1c5,980eea3f-3bd6-493b-8ab0-674ea36edf78,a7fbf23c-9468-4391-8574-3877feea11be,351f623e-102c-4ef7-93db-98f32bc1b613,e34dc342-d351-4489-a1e8-2a6ee435de6d,7b69f126-439d-42f1-914c-99fa6eba3017,b8d58fce-073c-456c-bd83-a38415c710b7,3fc34173-430c-4f7a-bc8e-9d418bf609c4,2a5f741d-48c3-47ab-8d54-84162a21c7d4,6fcf197d-1eac-4aa3-9224-4a864d3eb236,cdb97004-5c82-49d8-90b3-d687984d08aa,673327cc-0963-43ff-a7ee-ea5878732efc,73b1c962-eb9d-47b9-9de0-6927d2e50d61,8c4d5a46-e2ba-45ee-9ada-30aa584f0855,4a830068-299a-4a99-be6e-9ae85fa07e82,10e2fab8-c501-4a70-a779-ec2dfd451e2e,1286049d-5077-4cbb-8ae7-ff302ef2c01c,d59be246-0df3-4b2f-b6b4-8f53524406f1,47222b4b-0506-48c0-a66a-8384c6a0731f,b978e14c-b58f-4539-a6d2-c58a09c22453,f333abe6-92b8-4cb0-b25b-e255c6bcbbf0,ad4d1459-90b5-486e-a233-8339c2ef85bf,3defdc6c-932d-428d-81c0-3f2b001f7d2b,37caf46e-8c9e-4c8b-8e65-4e742655cc81,16e8ca60-1538-4b6a-a746-89f8e7b9a7f4,8d379271-aa69-4e63-ba56-f2dc40977b86,c2b2b973-c652-4905-bc30-6833912bec7f,5a91c631-4b2d-474b-9db2-b66d6fb7ca0f,e4444865-13fe-463a-80c4-032f17fbd754,138fa3d3-bc62-47ac-bf40-860174200e6e,9781f38b-a681-469d-bc60-acfe85e2d2b0,c3890ea3-7b77-41aa-9b27-f557b1fb7ac0,56a2cd86-3617-4da8-82cb-07219e81a267,f8d4d1ce-b6c3-45ee-a560-2d08d366c0f6,ed08142a-2fb5-4c75-ad3b-84faefcf7da2,e151d7d3-c6b1-4745-b67b-a15d810c3e2d,8c2ef23a-0a1a-435f-8a8e-93f423b4faf6,fbe94099-23de-4a2a-a87f-ffbed355e7a3,c78487b1-4059-465e-a8f1-e57205fec018,5b02dde3-d5f4-4edd-9292-96dbf9de589a,33c7e331-1282-4d43-be52-79c22d6d8345,0b667fb7-dd67-4aff-a632-803a5aab9569,db62d669-99fb-4573-be11-4ec70b7b94c1,eed59649-244b-4676-a18c-3f8402ec6eaa,75490890-5d17-4940-87ff-87fe5b61a262,e7a3f4fb-a58c-4d54-95d1-d44a6e8307f3,4a0ccccd-d246-4d1f-995b-a5616f9bf8cd,2ee91945-1bc7-4337-a97c-55fea9a69895,eca0aef5-e3f1-4e85-b048-fa751f55c6e1,dd7e07da-f407-4928-8733-95f9e6d680a5,9b13364a-cd60-4fc3-a665-52220b9105c8,b9902b48-fefd-4243-9f4e-67488461094f,3846ee3a-4eef-4485-ad3b-03a9ac1fb44d,d070dd9c-4ce2-4ca3-b35c-2509c5844559,1ffc67e0-67d5-4032-ab09-ed2bea5f9d24,5939e0c2-41c2-4a1a-b4ae-fac977c4c96b,7bb75fd1-60f7-417e-a060-7201b62ddf2c,3fdbb282-1895-4a8d-8722-f77c32301a0f,b1c0db14-29a3-45a8-84b0-a14c9f12f1fc,87c8083d-a564-4a4b-ac61-c6ee5836d0b4,2ccf3667-7263-41bf-868a-a0f645bc052a,02d8dbda-28e9-405b-97ab-bd69d2f60718,d02ce13f-49f4-4329-be51-61f11b970c68,1d712f24-7131-489b-83c4-03e057e92776,88861a6c-0bb5-4c3f-b797-eea6f8189039,5d446bea-2993-4f55-a043-e8aee4453333,518f70b6-b45b-4019-8852-c12dd5ab19b5,4eec0a9f-6f80-4b4d-8891-4367df993e21,f6f6e7db-e7df-4fc0-833f-d1e5d43de71a,41aa4c59-f1c2-475d-b969-b4be4cfcb8d9,fc8a2125-76a3-4d4b-a9ce-12d7afe0e31e,48e86fd0-9531-43d0-899d-21002b755d1b,c2dc9e35-1165-4228-8c16-6ae709dfd472,653dbbd1-4643-49f5-8ac9-c1161a48d341,333d94e6-b21d-4f43-be34-ceb92d716d47,8fc0d632-a05e-4e45-9832-7ce9012718dc,9fc058a8-d633-4e9d-bcf9-ecd00d9d592e,001d6c71-72fe-44d9-8a22-84095112084e,3af0c6b3-f7e4-4b9a-b4e8-5db3c70d4aa7,2f1d1d2d-1e1b-4db1-9938-19da99c86fe3,e4d74262-dfa2-4a33-b35e-6810c23813ca,2fd88726-6f59-44d2-a6b0-9fd5f7967226,ba020c30-c46c-4f82-918d-639708db9a32,bc02daf1-6be0-4b44-8a3c-6bd406472186,95dbf102-e216-42d9-867a-423337b59b11,1627b553-91f9-4129-a803-35617939c368,a6402874-3608-499a-837c-34077e1e079c,bc1a2a6e-2e4c-4714-887a-290cb08e5d94,d73e625c-bc6f-4d66-bf76-e1120d8fbb43,bc2cc316-df72-4721-8d30-ae1f3be29e48,5e837c94-922a-407b-9bbb-b9071117f603,c7c536bf-11d7-4f7d-90ee-0d64be9180fa}'::uuid[]))
107. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..11.82 rows=1 width=32) (never executed)

  • Join Filter: (tsapprovalrequestkeyvalue55.parentid = tsapprovalrequestkeyvalue59.id)
108. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..9.64 rows=1 width=48) (never executed)

  • Join Filter: (tsapprovalrequest58.id = tsapprovalrequestkeyvalue55.tsapprovalrequestid)
109. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..7.47 rows=1 width=4) (never executed)

  • Join Filter: (timesheetapprovalnodes57.id = tsapprovalrequest58.nodeid)
110. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..5.46 rows=1 width=16) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on timesheetapprovalnodes timesheetapprovalnodes57 (cost=0.00..2.00 rows=1 width=32) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on timesheet timesheet56 (cost=0.42..2.45 rows=1 width=16) (never executed)

  • Index Cond: (id = timesheetapprovalnodes57.timesheetid)
  • Filter: ((startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate) AND (userid = timeentryrevision0.userid))
113. 0.000 0.000 ↓ 0.0 0

Seq Scan on tsapprovalrequest tsapprovalrequest58 (cost=0.00..2.00 rows=1 width=20) (never executed)

  • Filter: (userid = 2)
114. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvkey on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue55 (cost=0.14..2.16 rows=1 width=52) (never executed)

  • Index Cond: (upper(key) = 'URN:REPLICON:APPROVAL-REQUEST-METADATA-KEY:ADDITIONAL-APPROVER-DATA-ACCESS-LEVELS'::text)
115. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsarkvparentid on tsapprovalrequestkeyvalue tsapprovalrequestkeyvalue59 (cost=0.14..2.16 rows=1 width=16) (never executed)

  • Index Cond: (parentid IS NULL)
116. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.87..54.52 rows=1 width=32) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.44..54.00 rows=1 width=16) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.01..50.51 rows=1 width=16) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.58..49.99 rows=1 width=16) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.14..48.72 rows=1 width=16) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..45.23 rows=1 width=16) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..42.78 rows=1 width=16) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..24.13 rows=1 width=16) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on timesheet timesheet61 (cost=0.42..4.53 rows=3 width=16) (never executed)

  • Index Cond: ((userid = timeentryrevision0.userid) AND (startdate <= timeentryrevision0.entrydate) AND (enddate >= timeentryrevision0.entrydate))
125. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtah2timesheetid on timesheetapprovalhistory timesheetapprovalhistory62 (cost=0.42..6.52 rows=1 width=32) (never executed)

  • Index Cond: (timesheetid = timesheet61.id)
  • Filter: (userid = 2)
126. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue63 (cost=0.43..18.64 rows=1 width=32) (never executed)

  • Index Cond: (timesheetapprovalhistoryid = timesheetapprovalhistory62.id)
  • Filter: ((upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:REMOVED-APPROVAL-REQUEST-NODES'::text) AND (upper(uri) = 'URN:REPLICON-TENANT:1B8A55AA5F704DEA918923FE2DAF8CDA:USER:2'::text))
127. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheetapprovalhistorykeyvalue_pkey on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue64 (cost=0.43..2.42 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue65 (cost=0.43..3.48 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue66 (cost=0.43..1.25 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue65.id)
130. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue67 (cost=0.43..0.51 rows=1 width=32) (never executed)

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

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue68 (cost=0.43..3.47 rows=2 width=32) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue67.id)
132. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvparentid on timesheetapprovalhistorykeyvalue sheetapprovalhistorykeyvalue60 (cost=0.43..0.50 rows=2 width=94) (never executed)

  • Index Cond: (parentid = sheetapprovalhistorykeyvalue68.id)
Planning time : 22.172 ms
Execution time : 7.615 ms