explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c1Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.760 22.184 ↑ 184.9 91 1

Aggregate (cost=32,904.6..33,787.81 rows=16,823 width=120) (actual time=21.398..22.184 rows=91 loops=1)

  • Buffers: shared hit=4419
2. 0.287 21.424 ↑ 26.2 642 1

Sort (cost=32,904.6..32,946.66 rows=16,823 width=79) (actual time=21.378..21.424 rows=642 loops=1)

  • Sort Key: claim_product.claim_id
  • Sort Method: quicksort Memory: 115kB
  • Buffers: shared hit=4419
3. 0.609 21.137 ↑ 26.2 642 1

Hash Join (cost=1,967.13..31,723.78 rows=16,823 width=79) (actual time=20.9..21.137 rows=642 loops=1)

  • Buffers: shared hit=4419
4. 0.332 19.346 ↑ 417.2 1,409 1

Unique (cost=0.42..21,651.63 rows=587,898 width=16) (actual time=0.05..19.346 rows=1,409 loops=1)

  • Buffers: shared hit=4008
5. 19.014 19.014 ↑ 511.2 1,519 1

Index Only Scan using claim_product_reason_code_active_idx on claim_product_reason_code claim_product_reason_code (cost=0.42..19,710.52 rows=776,443 width=16) (actual time=0.05..19.014 rows=1,519 loops=1)

  • Index Cond: (claim_product_reason_code.claim_reason_type = 'PEND'::enum.claim_reason_type)
  • Buffers: shared hit=4008
6. 0.192 1.182 ↑ 26.2 642 1

Hash (cost=1,756.42..1,756.42 rows=16,823 width=63) (actual time=1.182..1.182 rows=642 loops=1)

  • Buffers: shared hit=411
7. 0.227 0.990 ↑ 26.2 642 1

Nested Loop (cost=2.2..1,756.42 rows=16,823 width=63) (actual time=0.067..0.99 rows=642 loops=1)

  • Buffers: shared hit=411
8. 0.047 0.063 ↑ 1.0 100 1

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

9. 0.015 0.016 ↑ 1.0 100 1

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

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

11. 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=63) (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