explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hBhD

Settings
# exclusive inclusive rows x rows loops node
1. 0.174 4.972 ↑ 1.0 100 1

Hash Join (cost=2,623.15..3,111.18 rows=100 width=284) (actual time=4.572..4.972 rows=100 loops=1)

  • Buffers: shared hit=952
2. 0.032 3.657 ↑ 1.0 100 1

Hash Join (cost=2,443.29..2,927.31 rows=100 width=160) (actual time=3.418..3.657 rows=100 loops=1)

  • Buffers: shared hit=869
3. 0.047 2.086 ↑ 1.0 100 1

Hash Join (cost=2,197.53..2,681.28 rows=100 width=88) (actual time=1.873..2.086 rows=100 loops=1)

  • Buffers: shared hit=712
4. 0.745 1.641 ↑ 184.9 91 1

Aggregate (cost=2,008.76..2,261.11 rows=16,823 width=120) (actual time=1.466..1.641 rows=91 loops=1)

  • Buffers: shared hit=411
5. 0.140 0.896 ↑ 26.2 642 1

Nested Loop (cost=2.2..1,756.42 rows=16,823 width=55) (actual time=0.052..0.896 rows=642 loops=1)

  • Buffers: shared hit=411
6. 0.043 0.056 ↑ 1.0 100 1

Aggregate (cost=1.77..2.77 rows=100 width=16) (actual time=0.04..0.056 rows=100 loops=1)

7. 0.013 0.013 ↑ 1.0 100 1

ProjectSet (cost=0..0.52 rows=100 width=16) (actual time=0.002..0.013 rows=100 loops=1)

8. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=1)

9. 0.700 0.700 ↑ 28.0 6 100

Index Scan using claim_product_claim_id_idx on claim_product claim_product (cost=0.43..15.86 rows=168 width=55) (actual time=0.005..0.007 rows=6 loops=100)

  • 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[])))
  • Buffers: shared hit=411
10. 0.020 0.398 ↑ 1.0 100 1

Hash (cost=187.52..187.52 rows=100 width=16) (actual time=0.398..0.398 rows=100 loops=1)

  • Buffers: shared hit=301
11. 0.018 0.378 ↑ 1.0 100 1

Nested Loop (cost=2.19..187.52 rows=100 width=16) (actual time=0.066..0.378 rows=100 loops=1)

  • Buffers: shared hit=301
12. 0.045 0.060 ↑ 1.0 100 1

Aggregate (cost=1.77..2.77 rows=100 width=16) (actual time=0.046..0.06 rows=100 loops=1)

13. 0.014 0.015 ↑ 1.0 100 1

ProjectSet (cost=0..0.52 rows=100 width=16) (actual time=0.004..0.015 rows=100 loops=1)

14. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0.001 rows=1 loops=1)

15. 0.300 0.300 ↑ 1.0 1 100

Index Only Scan using claim_pkey on claim claim (cost=0.42..1.85 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=100)

  • 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[])))
  • Buffers: shared hit=301
16. 0.002 1.539 ↑ 52.5 2 1

Hash (cost=244.45..244.45 rows=105 width=88) (actual time=1.539..1.539 rows=2 loops=1)

  • Buffers: shared hit=157
17. 0.002 1.537 ↑ 52.5 2 1

Subquery Scan on claim_lumpsum (cost=241.83..244.45 rows=105 width=88) (actual time=1.535..1.537 rows=2 loops=1)

  • Buffers: shared hit=157
18. 0.007 1.535 ↑ 52.5 2 1

Aggregate (cost=241.83..243.4 rows=105 width=88) (actual time=1.534..1.535 rows=2 loops=1)

  • Buffers: shared hit=157
19. 0.921 1.528 ↑ 52.5 2 1

Hash Join (cost=2.77..240.78 rows=105 width=44) (actual time=0.237..1.528 rows=2 loops=1)

  • Buffers: shared hit=157
20. 0.575 0.575 ↑ 1.0 6,324 1

Seq Scan on claim_lumpsum claim_lumpsum_1 (cost=0..220.24 rows=6,324 width=44) (actual time=0.006..0.575 rows=6,324 loops=1)

  • Buffers: shared hit=157
21. 0.017 0.032 ↑ 1.0 100 1

Hash (cost=1.52..1.52 rows=100 width=16) (actual time=0.032..0.032 rows=100 loops=1)

22. 0.015 0.015 ↑ 1.0 100 1

ProjectSet (cost=0..0.52 rows=100 width=16) (actual time=0.002..0.015 rows=100 loops=1)

23. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=1)

24. 0.001 1.141 ↓ 0.0 0 1

Hash (cost=173.62..173.62 rows=499 width=88) (actual time=1.141..1.141 rows=0 loops=1)

  • Buffers: shared hit=83
25. 0.000 1.140 ↓ 0.0 0 1

Subquery Scan on claim_adhoc_product (cost=161.15..173.62 rows=499 width=88) (actual time=1.14..1.14 rows=0 loops=1)

  • Buffers: shared hit=83
26. 0.004 1.140 ↓ 0.0 0 1

Aggregate (cost=161.15..168.63 rows=499 width=88) (actual time=1.14..1.14 rows=0 loops=1)

  • Buffers: shared hit=83
27. 0.685 1.136 ↓ 0.0 0 1

Hash Join (cost=2.77..153.66 rows=499 width=49) (actual time=1.136..1.136 rows=0 loops=1)

  • Buffers: shared hit=83
28. 0.419 0.419 ↑ 1.0 4,938 1

Seq Scan on claim_adhoc_product claim_adhoc_product_1 (cost=0..132.38 rows=4,938 width=49) (actual time=0.004..0.419 rows=4,938 loops=1)

  • Buffers: shared hit=83
29. 0.018 0.032 ↑ 1.0 100 1

Hash (cost=1.52..1.52 rows=100 width=16) (actual time=0.032..0.032 rows=100 loops=1)

30. 0.014 0.014 ↑ 1.0 100 1

ProjectSet (cost=0..0.52 rows=100 width=16) (actual time=0.002..0.014 rows=100 loops=1)

31. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=1)