[
{
"Plan": {
"Node Type": "Hash Join",
"Parallel Aware": false,
"Join Type": "Left",
"Startup Cost": 2623.15,
"Total Cost": 3111.18,
"Plan Rows": 100,
"Plan Width": 284,
"Actual Startup Time": 4.572,
"Actual Total Time": 4.972,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"claim.claim_id",
"(COALESCE(claim_lumpsum.lumpsum_count, '0'::bigint))::integer",
"round(COALESCE(claim_lumpsum.requested_amount, '0'::numeric), 2)",
"round(COALESCE(claim_lumpsum.allowed_amount, '0'::numeric), 2)",
"(COALESCE((count(claim_product.claim_product_id)), '0'::bigint))::integer",
"round(COALESCE((sum((claim_product.rebate_requested_quantity * claim_product.rebate_requested_rate))), '0'::numeric), 2)",
"round(COALESCE((sum((claim_product.rebate_allowed_quantity * claim_product.rebate_allowed_rate))), '0'::numeric), 2)",
"(COALESCE(claim_adhoc_product.adhoc_product_count, '0'::bigint))::integer",
"round(COALESCE(claim_adhoc_product.requested_amount, '0'::numeric), 2)",
"round(COALESCE(claim_adhoc_product.allowed_amount, '0'::numeric), 2)",
"round(((COALESCE((sum((claim_product.rebate_requested_quantity * claim_product.rebate_requested_rate))), '0'::numeric) + COALESCE(claim_adhoc_product.requested_amount, '0'::numeric)) + COALESCE(claim_lumpsum.requested_amount, '0'::numeric)), 2)",
"round(((COALESCE((sum((claim_product.rebate_allowed_quantity * claim_product.rebate_allowed_rate))), '0'::numeric) + COALESCE(claim_adhoc_product.allowed_amount, '0'::numeric)) + COALESCE(claim_lumpsum.allowed_amount, '0'::numeric)), 2)"
],
"Inner Unique": true,
"Hash Cond": "(claim.claim_id = claim_adhoc_product.claim_id)",
"Shared Hit Blocks": 952,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Left",
"Startup Cost": 2443.29,
"Total Cost": 2927.31,
"Plan Rows": 100,
"Plan Width": 160,
"Actual Startup Time": 3.418,
"Actual Total Time": 3.657,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"claim.claim_id",
"claim_lumpsum.lumpsum_count",
"claim_lumpsum.requested_amount",
"claim_lumpsum.allowed_amount",
"(count(claim_product.claim_product_id))",
"(sum((claim_product.rebate_requested_quantity * claim_product.rebate_requested_rate)))",
"(sum((claim_product.rebate_allowed_quantity * claim_product.rebate_allowed_rate)))"
],
"Inner Unique": true,
"Hash Cond": "(claim.claim_id = claim_lumpsum.claim_id)",
"Shared Hit Blocks": 869,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Right",
"Startup Cost": 2197.53,
"Total Cost": 2681.28,
"Plan Rows": 100,
"Plan Width": 88,
"Actual Startup Time": 1.873,
"Actual Total Time": 2.086,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"claim.claim_id",
"(count(claim_product.claim_product_id))",
"(sum((claim_product.rebate_requested_quantity * claim_product.rebate_requested_rate)))",
"(sum((claim_product.rebate_allowed_quantity * claim_product.rebate_allowed_rate)))"
],
"Inner Unique": false,
"Hash Cond": "(claim_product.claim_id = claim.claim_id)",
"Shared Hit Blocks": 712,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Hashed",
"Partial Mode": "Simple",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 2008.76,
"Total Cost": 2261.11,
"Plan Rows": 16823,
"Plan Width": 120,
"Actual Startup Time": 1.466,
"Actual Total Time": 1.641,
"Actual Rows": 91,
"Actual Loops": 1,
"Output": [
"claim_product.claim_id",
"count(claim_product.claim_product_id)",
"sum((claim_product.rebate_requested_quantity * claim_product.rebate_requested_rate))",
"sum((claim_product.rebate_allowed_quantity * claim_product.rebate_allowed_rate))",
"NULL::numeric"
],
"Group Key": [
"claim_product.claim_id"
],
"Shared Hit Blocks": 411,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2.2,
"Total Cost": 1756.42,
"Plan Rows": 16823,
"Plan Width": 55,
"Actual Startup Time": 0.052,
"Actual Total Time": 0.896,
"Actual Rows": 642,
"Actual Loops": 1,
"Output": [
"claim_product.claim_id",
"claim_product.claim_product_id",
"claim_product.rebate_requested_quantity",
"claim_product.rebate_requested_rate",
"claim_product.rebate_allowed_quantity",
"claim_product.rebate_allowed_rate"
],
"Inner Unique": false,
"Shared Hit Blocks": 411,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Hashed",
"Partial Mode": "Simple",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 1.77,
"Total Cost": 2.77,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.04,
"Actual Total Time": 0.056,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"(unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[]))"
],
"Group Key": [
"unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "ProjectSet",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.013,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0,
"Actual Total Time": 0,
"Actual Rows": 1,
"Actual Loops": 1,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "claim_product_claim_id_idx",
"Relation Name": "claim_product",
"Schema": "client_pinnacle",
"Alias": "claim_product",
"Startup Cost": 0.43,
"Total Cost": 15.86,
"Plan Rows": 168,
"Plan Width": 55,
"Actual Startup Time": 0.005,
"Actual Total Time": 0.007,
"Actual Rows": 6,
"Actual Loops": 100,
"Output": [
"claim_product.claim_id",
"claim_product.claim_product_id",
"claim_product.rebate_requested_quantity",
"claim_product.rebate_requested_rate",
"claim_product.rebate_allowed_quantity",
"claim_product.rebate_allowed_rate"
],
"Index Cond": "(claim_product.claim_id = (unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])))",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 411,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 187.52,
"Total Cost": 187.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.398,
"Actual Total Time": 0.398,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"claim.claim_id"
],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 13,
"Shared Hit Blocks": 301,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2.19,
"Total Cost": 187.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.066,
"Actual Total Time": 0.378,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"claim.claim_id"
],
"Inner Unique": true,
"Shared Hit Blocks": 301,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Hashed",
"Partial Mode": "Simple",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 1.77,
"Total Cost": 2.77,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.046,
"Actual Total Time": 0.06,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"(unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[]))"
],
"Group Key": [
"unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "ProjectSet",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.015,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0,
"Actual Total Time": 0.001,
"Actual Rows": 1,
"Actual Loops": 1,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
},
{
"Node Type": "Index Only Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "claim_pkey",
"Relation Name": "claim",
"Schema": "client_pinnacle",
"Alias": "claim",
"Startup Cost": 0.42,
"Total Cost": 1.85,
"Plan Rows": 1,
"Plan Width": 16,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.003,
"Actual Rows": 1,
"Actual Loops": 100,
"Output": [
"claim.claim_id"
],
"Index Cond": "(claim.claim_id = (unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])))",
"Rows Removed by Index Recheck": 0,
"Heap Fetches": 0,
"Shared Hit Blocks": 301,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 244.45,
"Total Cost": 244.45,
"Plan Rows": 105,
"Plan Width": 88,
"Actual Startup Time": 1.539,
"Actual Total Time": 1.539,
"Actual Rows": 2,
"Actual Loops": 1,
"Output": [
"claim_lumpsum.lumpsum_count",
"claim_lumpsum.requested_amount",
"claim_lumpsum.allowed_amount",
"claim_lumpsum.claim_id"
],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 9,
"Shared Hit Blocks": 157,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Alias": "claim_lumpsum",
"Startup Cost": 241.83,
"Total Cost": 244.45,
"Plan Rows": 105,
"Plan Width": 88,
"Actual Startup Time": 1.535,
"Actual Total Time": 1.537,
"Actual Rows": 2,
"Actual Loops": 1,
"Output": [
"claim_lumpsum.lumpsum_count",
"claim_lumpsum.requested_amount",
"claim_lumpsum.allowed_amount",
"claim_lumpsum.claim_id"
],
"Shared Hit Blocks": 157,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Hashed",
"Partial Mode": "Simple",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Startup Cost": 241.83,
"Total Cost": 243.4,
"Plan Rows": 105,
"Plan Width": 88,
"Actual Startup Time": 1.534,
"Actual Total Time": 1.535,
"Actual Rows": 2,
"Actual Loops": 1,
"Output": [
"claim_lumpsum_1.claim_id",
"count(claim_lumpsum_1.claim_lumpsum_id)",
"sum(claim_lumpsum_1.requested_amount)",
"sum(claim_lumpsum_1.allowed_amount)"
],
"Group Key": [
"claim_lumpsum_1.claim_id"
],
"Shared Hit Blocks": 157,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Semi",
"Startup Cost": 2.77,
"Total Cost": 240.78,
"Plan Rows": 105,
"Plan Width": 44,
"Actual Startup Time": 0.237,
"Actual Total Time": 1.528,
"Actual Rows": 2,
"Actual Loops": 1,
"Output": [
"claim_lumpsum_1.claim_id",
"claim_lumpsum_1.claim_lumpsum_id",
"claim_lumpsum_1.requested_amount",
"claim_lumpsum_1.allowed_amount"
],
"Inner Unique": false,
"Hash Cond": "(claim_lumpsum_1.claim_id = (unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])))",
"Shared Hit Blocks": 157,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "claim_lumpsum",
"Schema": "client_pinnacle",
"Alias": "claim_lumpsum_1",
"Startup Cost": 0,
"Total Cost": 220.24,
"Plan Rows": 6324,
"Plan Width": 44,
"Actual Startup Time": 0.006,
"Actual Total Time": 0.575,
"Actual Rows": 6324,
"Actual Loops": 1,
"Output": [
"claim_lumpsum_1.claim_lumpsum_id",
"claim_lumpsum_1.claim_id",
"claim_lumpsum_1.lumpsum_id",
"claim_lumpsum_1.requested_amount",
"claim_lumpsum_1.allowed_amount",
"claim_lumpsum_1.contract_lumpsum_id",
"claim_lumpsum_1.event_date_range",
"claim_lumpsum_1.claimant_contract_name",
"claim_lumpsum_1.hint_contract_lumpsum_description"
],
"Shared Hit Blocks": 157,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.52,
"Total Cost": 1.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.032,
"Actual Total Time": 0.032,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"(unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[]))"
],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 13,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "ProjectSet",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.015,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0,
"Actual Total Time": 0,
"Actual Rows": 1,
"Actual Loops": 1,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 173.62,
"Total Cost": 173.62,
"Plan Rows": 499,
"Plan Width": 88,
"Actual Startup Time": 1.141,
"Actual Total Time": 1.141,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": [
"claim_adhoc_product.adhoc_product_count",
"claim_adhoc_product.requested_amount",
"claim_adhoc_product.allowed_amount",
"claim_adhoc_product.claim_id"
],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 8,
"Shared Hit Blocks": 83,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Alias": "claim_adhoc_product",
"Startup Cost": 161.15,
"Total Cost": 173.62,
"Plan Rows": 499,
"Plan Width": 88,
"Actual Startup Time": 1.14,
"Actual Total Time": 1.14,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": [
"claim_adhoc_product.adhoc_product_count",
"claim_adhoc_product.requested_amount",
"claim_adhoc_product.allowed_amount",
"claim_adhoc_product.claim_id"
],
"Shared Hit Blocks": 83,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Aggregate",
"Strategy": "Hashed",
"Partial Mode": "Simple",
"Parent Relationship": "Subquery",
"Parallel Aware": false,
"Startup Cost": 161.15,
"Total Cost": 168.63,
"Plan Rows": 499,
"Plan Width": 88,
"Actual Startup Time": 1.14,
"Actual Total Time": 1.14,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": [
"claim_adhoc_product_1.claim_id",
"count(claim_adhoc_product_1.claim_adhoc_product_id)",
"sum((claim_adhoc_product_1.rebate_requested_quantity * claim_adhoc_product_1.rebate_requested_rate))",
"sum((claim_adhoc_product_1.rebate_allowed_quantity * claim_adhoc_product_1.rebate_allowed_rate))"
],
"Group Key": [
"claim_adhoc_product_1.claim_id"
],
"Shared Hit Blocks": 83,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Semi",
"Startup Cost": 2.77,
"Total Cost": 153.66,
"Plan Rows": 499,
"Plan Width": 49,
"Actual Startup Time": 1.136,
"Actual Total Time": 1.136,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": [
"claim_adhoc_product_1.claim_id",
"claim_adhoc_product_1.claim_adhoc_product_id",
"claim_adhoc_product_1.rebate_requested_quantity",
"claim_adhoc_product_1.rebate_requested_rate",
"claim_adhoc_product_1.rebate_allowed_quantity",
"claim_adhoc_product_1.rebate_allowed_rate"
],
"Inner Unique": false,
"Hash Cond": "(claim_adhoc_product_1.claim_id = (unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])))",
"Shared Hit Blocks": 83,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "claim_adhoc_product",
"Schema": "client_pinnacle",
"Alias": "claim_adhoc_product_1",
"Startup Cost": 0,
"Total Cost": 132.38,
"Plan Rows": 4938,
"Plan Width": 49,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.419,
"Actual Rows": 4938,
"Actual Loops": 1,
"Output": [
"claim_adhoc_product_1.claim_adhoc_product_id",
"claim_adhoc_product_1.claim_id",
"claim_adhoc_product_1.product_name",
"claim_adhoc_product_1.product_number",
"claim_adhoc_product_1.uom_type_description",
"claim_adhoc_product_1.rebate_requested_quantity",
"claim_adhoc_product_1.rebate_requested_rate",
"claim_adhoc_product_1.rebate_allowed_quantity",
"claim_adhoc_product_1.rebate_allowed_rate",
"claim_adhoc_product_1.claimant_contract_name",
"claim_adhoc_product_1.resolve_date",
"claim_adhoc_product_1.distributor_invoice_number",
"claim_adhoc_product_1.distributor_company_id"
],
"Shared Hit Blocks": 83,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 1.52,
"Total Cost": 1.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.032,
"Actual Total Time": 0.032,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"(unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[]))"
],
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 13,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "ProjectSet",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.52,
"Plan Rows": 100,
"Plan Width": 16,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.014,
"Actual Rows": 100,
"Actual Loops": 1,
"Output": [
"unnest('{e6eb06bb-3d62-4dce-916e-54362a7a8916,3be90fb1-d47c-4263-b7e3-2187af1027a0,a3a4bd1a-d685-4155-bb25-657f66a973f9,1a90caf5-e9ed-4bea-a175-26b179dd0eb2,4f4d28d4-f945-4d30-af16-a2e445555a17,c3f06b28-5f45-4d35-a402-73ceaefe4505,3cdee973-3b3c-41d5-a424-9a06bc29afe0,437982a5-0dcc-49c0-9eae-b1055a338787,8392ff24-4f03-48f0-b927-acf5ffd45c97,407e3075-618a-4518-a14c-338fde610e18,f4d8b7bd-4fbf-486a-8a86-50314da7a675,1690a70b-bc3f-41b4-87cf-8ad1daa20e01,8a38c2f1-2227-40df-9fcb-32abf85d7bfc,401dd5dc-80b1-40d9-aeb5-ea82632bb379,53f21cd2-eb31-400b-b26b-fb3b1cdd1d54,1765757c-e813-4552-b4b6-0bbabc3f31ca,d7261d6e-ee10-4597-a8c0-1371aba7382e,c66903f6-8b22-40a4-a17b-a748eb328b15,a18cef90-a44a-4ac3-8b75-4b2e9ef9b1e1,55590f3c-7bf5-4685-8f01-fb25ac08f68d,92e45bd4-83f8-4ac3-b7b8-d28a70848c8e,eb804336-8d6e-4412-a4a4-02729c40db17,9cb419d9-ca17-45e8-a002-94ad8e42d4db,b3efac04-e98f-4bc9-93f9-00703435e981,09d0b88f-1e87-48d0-b172-e21638cdd0e1,7ed1bb24-0a59-44f1-b19c-599801cf60ee,b0341085-9e11-42ef-981e-722e9d4677dc,10d0f344-8471-493c-92a0-382973661f8e,1eba5ecd-09a0-439c-a697-06669248089d,f7b1709e-c843-4bc8-8911-0ed12139ca58,dd0090e9-caeb-4d6a-8c5d-540301f54f42,e7db193b-d3ef-41eb-8961-c79dd7b52684,97d5ac53-84ad-4cd6-9b6f-ebc388ea232a,f6254735-6961-472c-b0c5-2b50aec5ce7f,377c7cf4-9a1d-49c1-84bf-4bae9b84bede,a3ef18af-eb97-4ed1-a30f-dd764e053c0d,1123fcd3-204b-440a-b60e-e4b5573fce02,aabd905e-db80-4257-8457-d8c0b2e8fa8b,01a22073-45c7-4b9c-a614-18a759e47e55,64a52aba-205e-453e-816e-0b9dc8898334,c703e1ba-e8b5-4a86-8021-e1cfc7d0c28d,34d183ff-fb8b-4088-8255-d3c0f7e24c35,3f2c9322-798f-4fef-a607-361b04d87ea1,724eb24d-5a86-4bc7-8068-a9d74c703411,db19568b-8c52-44ba-883f-330dac155d4a,5bef3330-df1c-4f5c-877e-b082d375109a,6c046e27-9027-4dc2-b2ec-702c98b4ea72,4061f810-d1e7-44fa-8cca-a41d4359f84b,b426efc7-52ad-4598-9279-6618da0e104b,ab72a077-1b03-465f-8ff3-386a76e7a75d,94d9c1bf-372b-44db-b44c-05aa4b9a8c64,14ed53a4-e9ad-4070-b243-7a3c330becac,40526b66-6d16-4a9a-bc30-c5b21b681df5,b755309b-9312-47fa-8733-2dc698b670e2,400a50c1-3c08-4b99-b4f0-a61c32bac758,11c7485c-f498-479d-9c50-f7d7e2498217,e41ac3e0-08f6-4cc4-9e08-3924c19eae2f,a8e432b9-169e-4718-a9ca-f347750c95bd,7d492364-eac0-4e7f-9f1c-7145171f663b,37cac2e7-0b3e-4985-a0a8-ba3de1deecc3,3c9260b6-d43c-42ac-82ea-3beed6aa1027,818a64d8-53f6-497d-b78e-505f13da84ec,19d28589-374d-4054-9e5f-0db714ea8241,36643ccc-0586-474f-acff-f1b4f08991ee,9b26cb21-72f5-4c2b-a220-2ee7941bd8c9,fb2dd4c4-0016-46c3-91ba-98d5bcb053c9,3d8880b6-e6c0-430d-9d77-7eede9c6c15f,bd43059a-5150-4d67-bb12-3844136481f3,19869c72-8815-4add-9487-eed70dd7e32d,01ea5b60-c8f8-4763-b21d-389d9902ec39,f86481ea-1c59-4e86-8dc2-db199a2d2690,03603e6b-6c79-43c8-9abb-af573a8bc6ba,3a4a2e48-bfa2-4b10-b1f1-9b1ee3321bfa,345d76b9-3465-4e8e-9cd5-01742eb51cee,8b31ebde-ae61-47aa-9f50-9e4d9f3efcca,1d6b098b-1e85-4ef9-ada4-c159740f27c3,162e95d3-e555-4866-99de-6008863ac5dc,9cb0e4b4-353b-4fa3-a832-763b05c78590,1eda9988-77a5-4875-bf42-7cf8aecc615c,1587188d-2b07-4373-bea9-f0d0924394e9,a28834c0-741c-4e49-9672-9cb767399d13,8de0fc96-bbbc-4c74-829d-56710386aabe,7827e49e-4b6f-4057-b03b-bd97a5844f97,4bd1a147-ad30-4a2e-b5e5-f37df5d7fb42,997adc3b-2c0a-403c-83ab-e723b153c45e,36bb767f-04f8-4acf-901c-388a2cb180e8,737dd9f2-df1b-42b3-b194-a2cccca5c998,872b64d6-12c6-4c2a-995b-59f46fc3f4a2,95801863-3e3e-4c63-9e3b-2a9d14ec5ada,5fc8b62d-3a8c-4420-bb5b-21e5c06d54f8,f8a4da32-b19e-4550-b6ef-a31ffaa288b7,7214db8b-be91-41f4-934b-7dcd8ca83c2e,3f3613b6-3e4c-4d01-b01e-0fce5d00bb02,0e1a227f-c20e-4f20-9ef8-11bcbea4ba69,d7bb4767-ed52-4de3-b139-407bc336b2bb,64874356-789d-4aac-bb56-ff019a4736cb,0da6490d-3add-432d-bbcf-05fb07a0a1ef,a5bd3a4f-da80-45d3-b757-83a06775c77b,0cb672d5-7b12-4a0d-a085-e73193dcb4e9,87f7a893-98f7-4540-9d88-0b394f992f48}'::uuid[])"
],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Result",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 0,
"Total Cost": 0.01,
"Plan Rows": 1,
"Plan Width": 0,
"Actual Startup Time": 0,
"Actual Total Time": 0,
"Actual Rows": 1,
"Actual Loops": 1,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
}
]
}
]
},
"Triggers": []
}
]