explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5S4j

Settings
# exclusive inclusive rows x rows loops node
1. 0.260 12.843 ↑ 1.0 100 1

Hash Join (cost=9,951.57..10,038.57 rows=100 width=284) (actual time=12.575..12.843 rows=100 loops=1)

  • Buffers: shared hit=2617 read=267 dirtied=107
2. 0.043 9.446 ↑ 1.0 100 1

Hash Join (cost=9,705.8..9,788.8 rows=100 width=160) (actual time=9.413..9.446 rows=100 loops=1)

  • Buffers: shared hit=2460 read=267 dirtied=107
3. 0.022 6.404 ↓ 0.0 0 1

Aggregate (cost=9,336.91..9,380.2 rows=2,886 width=120) (actual time=6.404..6.404 rows=0 loops=1)

  • Buffers: shared hit=2076 read=267 dirtied=107
4. 0.119 6.382 ↓ 0.0 0 1

Nested Loop (cost=2.62..9,293.62 rows=2,886 width=55) (actual time=6.382..6.382 rows=0 loops=1)

  • Buffers: shared hit=2076 read=267 dirtied=107
5. 0.225 3.053 ↑ 26.2 642 1

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

  • Buffers: shared hit=144 read=267 dirtied=107
6. 0.102 0.128 ↑ 1.0 100 1

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

7. 0.025 0.026 ↑ 1.0 100 1

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

8. 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)

9. 2.700 2.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.021..0.027 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=144 read=267 dirtied=107
10. 3.210 3.210 ↓ 0.0 0 642

Index Only Scan using claim_product_reason_code_active_idx on claim_product_reason_code claim_product_reason_code (cost=0.42..0.45 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=642)

  • Index Cond: ((claim_product_reason_code.claim_product_id = claim_product.claim_product_id) AND (claim_product_reason_code.claim_reason_type = 'PEND'::enum.claim_reason_type))
  • Buffers: shared hit=1932
11. 0.044 2.999 ↑ 1.0 100 1

Hash (cost=367.64..367.64 rows=100 width=88) (actual time=2.999..2.999 rows=100 loops=1)

  • Buffers: shared hit=384
12. 0.049 2.955 ↑ 1.0 100 1

Hash Join (cost=182.05..367.64 rows=100 width=88) (actual time=2.404..2.955 rows=100 loops=1)

  • Buffers: shared hit=384
13. 0.098 0.601 ↑ 1.0 100 1

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

  • Buffers: shared hit=301
14. 0.080 0.103 ↑ 1.0 100 1

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

15. 0.022 0.023 ↑ 1.0 100 1

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

16. 0.001 0.001 ↑ 1.0 1 1

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

17. 0.400 0.400 ↑ 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.004..0.004 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
18. 0.000 2.305 ↓ 0.0 0 1

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

  • Buffers: shared hit=83
19. 0.001 2.305 ↓ 0.0 0 1

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

  • Buffers: shared hit=83
20. 0.005 2.304 ↓ 0.0 0 1

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

  • Buffers: shared hit=83
21. 1.408 2.299 ↓ 0.0 0 1

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

  • Buffers: shared hit=83
22. 0.833 0.833 ↑ 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.008..0.833 rows=4,938 loops=1)

  • Buffers: shared hit=83
23. 0.037 0.058 ↑ 1.0 100 1

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

24. 0.021 0.021 ↑ 1.0 100 1

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

25. 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)

26. 0.005 3.137 ↑ 52.5 2 1

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

  • Buffers: shared hit=157
27. 0.002 3.132 ↑ 52.5 2 1

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

  • Buffers: shared hit=157
28. 0.027 3.130 ↑ 52.5 2 1

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

  • Buffers: shared hit=157
29. 1.875 3.103 ↑ 52.5 2 1

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

  • Buffers: shared hit=157
30. 1.147 1.147 ↑ 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.008..1.147 rows=6,324 loops=1)

  • Buffers: shared hit=157
31. 0.054 0.081 ↑ 1.0 100 1

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

32. 0.026 0.027 ↑ 1.0 100 1

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

33. 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)