explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OFgK

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=5,678,248.51..7,104,138.86 rows=1,460,506 width=36) (actual rows= loops=)

  • Group Key: fpe_default.feature_id, fpe_default.branch, fpe_default.property_type
  • Filter: (count(*) > 1)
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=5,678,248.51..6,961,739.53 rows=8,763,036 width=44) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=5,677,248.49..5,949,267.72 rows=4,381,518 width=44) (actual rows= loops=)

  • Group Key: fpe_default.feature_id, fpe_default.branch, fpe_default.property_type
4. 0.000 0.000 ↓ 0.0

Sort (cost=5,677,248.49..5,722,889.30 rows=18,256,324 width=36) (actual rows= loops=)

  • Sort Key: fpe_default.feature_id, fpe_default.branch, fpe_default.property_type
5. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..2,890,588.22 rows=18,256,324 width=36) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Index Scan using lidx_feature_property_entry_branch_version on fpe_default (cost=0.57..34,751.02 rows=14,053 width=36) (actual rows= loops=)

  • Index Cond: (branch = ANY ('{541d19f0-abf2-4e1e-8aea-67dcff02f173,510e6700-cabb-4dcd-b873-943c75831fba,6b2dd556-9756-4838-af77-282dba225dde,c9a60986-e31b-4942-beca-111b0d523f08,bc51d95c-0e7c-4cfe-a3ea-efb6b929e591,1755cdae-6c36-42d9-8c76-b6d3eadb4217,8eb568eb-bcf1-4568-83ed-58e7089cca87,efdc94a3-922f-43a4-a312-efc3f9e9086b,0a3ceb3b-ad8a-48bb-ae6e-b3702b587a6e,68631912-539f-42d2-af8d-098e0f98a6e8,0436d8d2-a325-46e1-bd8d-c3e087618c8e,1ee0f86a-a703-45ca-8853-c329a0c2ce1b,e500cdb8-8ced-4632-91c1-1a002b865c5c,499a0e6f-90f4-407c-bd1f-b867bdd6357e,35aab51a-2084-4ed6-9a4b-d7162f5d919d,019e55c7-a12f-478e-9c92-0a9da1e4d377,fc3d640d-7f5a-49ca-ab26-8096b2a27beb,5ebbe195-0a26-41ce-9477-183a2408f2f5,d69b33f5-1aeb-48ea-8130-69338b74437c,7e16171b-fb3c-492c-839f-9b44d66a74f3,5f49bf11-74f1-49bc-803a-cc4fe1f93544,6a890179-caa6-48f2-9636-b2e33529f1a3,24404c36-5b44-4119-81a7-c685725f18aa,c131595c-532d-4e52-bf21-623cd839a5b2,b5e21b62-fdce-41da-8bbd-703f1c66164f,f9e9bdef-6a0a-429d-b4a8-5f67e36b8dce,92cc2bf1-347c-4d96-a48a-a29425202c3f,163f4dde-b461-44a8-b594-d4c91584adb0,6ce4b63d-2a75-4b77-9a6f-f3f916504df4,7d76d4d3-919a-4c5b-bb11-96f8cff7b88b,9d9820be-ae54-4cc2-bc81-284b2004a621,f750b3ae-c8eb-44f4-a2b5-57ffc57974d2,7e990abe-e64c-4652-8297-0d2690dc7702,6e6553bd-eaea-4b18-9438-377edf7b90ba,95512d88-a103-4384-8151-bd38f6626a92,33993019-6b20-4366-b1dd-5908529d0c6f,2c293c4c-1164-43af-9052-7d035d40dc15,535d476c-662f-4865-8fea-f668da2e86fd,f7444171-a853-4202-b35a-986ff1e8e970,74c75b01-2d47-4c6c-8053-a38bfa3975a1,9552f718-c95d-47f1-8e2b-fa7249e4696f,ccebc7e7-d60c-4355-a841-6c854721e6e8,0c343a3d-0ff8-4f50-a9c1-95e99300c1a7,ad811089-6866-4e2f-9c05-46ebff59473d,c043ebe8-c592-490a-a135-d81c91baad02,685843d2-d5eb-4a2d-b368-40ee80914321,c5b9e3e0-a1e9-4acc-b06f-0a3d1783f25a,d4329226-177d-43fc-bbeb-fa91290b3145,aff96c44-e615-4c9b-9dfe-4891a2b6a478,eeace50c-5b2e-4150-a77e-cb248aa47b1b,06557064-9d6e-49c5-a482-aea5b63c028e,f530ba27-50f5-4c80-8c42-49aba9e31715,25a43231-a17a-4e5b-b493-3e1c4a496902,054bcc63-f006-4558-88d9-c27e7ce9b1a3,dac041bd-c07e-44a9-a299-052b14daaa1a,3c959f96-d81a-4e73-b278-3a8cfce5afe4,ec0ebeca-ba0c-4bb1-9a04-4ef73373fcab,c21b5ff2-f211-435d-aa11-9b23dda45d0e,089529db-ccc9-4572-bd9b-ae9e0626afda,9ecbb895-970b-4302-bf11-34917e8e662a,42501d48-e805-403e-97f4-4e237c617fa3}'::uuid[]))
  • Filter: added
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fpe_f9e9bdef_6a0a_429d_b4a8_5f67e36b8dce (cost=0.00..2,757,066.39 rows=18,212,834 width=36) (actual rows= loops=)

  • Filter: (added AND (branch = ANY ('{541d19f0-abf2-4e1e-8aea-67dcff02f173,510e6700-cabb-4dcd-b873-943c75831fba,6b2dd556-9756-4838-af77-282dba225dde,c9a60986-e31b-4942-beca-111b0d523f08,bc51d95c-0e7c-4cfe-a3ea-efb6b929e591,1755cdae-6c36-42d9-8c76-b6d3eadb4217,8eb568eb-bcf1-4568-83ed-58e7089cca87,efdc94a3-922f-43a4-a312-efc3f9e9086b,0a3ceb3b-ad8a-48bb-ae6e-b3702b587a6e,68631912-539f-42d2-af8d-098e0f98a6e8,0436d8d2-a325-46e1-bd8d-c3e087618c8e,1ee0f86a-a703-45ca-8853-c329a0c2ce1b,e500cdb8-8ced-4632-91c1-1a002b865c5c,499a0e6f-90f4-407c-bd1f-b867bdd6357e,35aab51a-2084-4ed6-9a4b-d7162f5d919d,019e55c7-a12f-478e-9c92-0a9da1e4d377,fc3d640d-7f5a-49ca-ab26-8096b2a27beb,5ebbe195-0a26-41ce-9477-183a2408f2f5,d69b33f5-1aeb-48ea-8130-69338b74437c,7e16171b-fb3c-492c-839f-9b44d66a74f3,5f49bf11-74f1-49bc-803a-cc4fe1f93544,6a890179-caa6-48f2-9636-b2e33529f1a3,24404c36-5b44-4119-81a7-c685725f18aa,c131595c-532d-4e52-bf21-623cd839a5b2,b5e21b62-fdce-41da-8bbd-703f1c66164f,f9e9bdef-6a0a-429d-b4a8-5f67e36b8dce,92cc2bf1-347c-4d96-a48a-a29425202c3f,163f4dde-b461-44a8-b594-d4c91584adb0,6ce4b63d-2a75-4b77-9a6f-f3f916504df4,7d76d4d3-919a-4c5b-bb11-96f8cff7b88b,9d9820be-ae54-4cc2-bc81-284b2004a621,f750b3ae-c8eb-44f4-a2b5-57ffc57974d2,7e990abe-e64c-4652-8297-0d2690dc7702,6e6553bd-eaea-4b18-9438-377edf7b90ba,95512d88-a103-4384-8151-bd38f6626a92,33993019-6b20-4366-b1dd-5908529d0c6f,2c293c4c-1164-43af-9052-7d035d40dc15,535d476c-662f-4865-8fea-f668da2e86fd,f7444171-a853-4202-b35a-986ff1e8e970,74c75b01-2d47-4c6c-8053-a38bfa3975a1,9552f718-c95d-47f1-8e2b-fa7249e4696f,ccebc7e7-d60c-4355-a841-6c854721e6e8,0c343a3d-0ff8-4f50-a9c1-95e99300c1a7,ad811089-6866-4e2f-9c05-46ebff59473d,c043ebe8-c592-490a-a135-d81c91baad02,685843d2-d5eb-4a2d-b368-40ee80914321,c5b9e3e0-a1e9-4acc-b06f-0a3d1783f25a,d4329226-177d-43fc-bbeb-fa91290b3145,aff96c44-e615-4c9b-9dfe-4891a2b6a478,eeace50c-5b2e-4150-a77e-cb248aa47b1b,06557064-9d6e-49c5-a482-aea5b63c028e,f530ba27-50f5-4c80-8c42-49aba9e31715,25a43231-a17a-4e5b-b493-3e1c4a496902,054bcc63-f006-4558-88d9-c27e7ce9b1a3,dac041bd-c07e-44a9-a299-052b14daaa1a,3c959f96-d81a-4e73-b278-3a8cfce5afe4,ec0ebeca-ba0c-4bb1-9a04-4ef73373fcab,c21b5ff2-f211-435d-aa11-9b23dda45d0e,089529db-ccc9-4572-bd9b-ae9e0626afda,9ecbb895-970b-4302-bf11-34917e8e662a,42501d48-e805-403e-97f4-4e237c617fa3}'::uuid[])))
8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fpe_d4329226_177d_43fc_bbeb_fa91290b3145 (cost=0.00..7,489.19 rows=47,345 width=36) (actual rows= loops=)

  • Filter: (added AND (branch = ANY ('{541d19f0-abf2-4e1e-8aea-67dcff02f173,510e6700-cabb-4dcd-b873-943c75831fba,6b2dd556-9756-4838-af77-282dba225dde,c9a60986-e31b-4942-beca-111b0d523f08,bc51d95c-0e7c-4cfe-a3ea-efb6b929e591,1755cdae-6c36-42d9-8c76-b6d3eadb4217,8eb568eb-bcf1-4568-83ed-58e7089cca87,efdc94a3-922f-43a4-a312-efc3f9e9086b,0a3ceb3b-ad8a-48bb-ae6e-b3702b587a6e,68631912-539f-42d2-af8d-098e0f98a6e8,0436d8d2-a325-46e1-bd8d-c3e087618c8e,1ee0f86a-a703-45ca-8853-c329a0c2ce1b,e500cdb8-8ced-4632-91c1-1a002b865c5c,499a0e6f-90f4-407c-bd1f-b867bdd6357e,35aab51a-2084-4ed6-9a4b-d7162f5d919d,019e55c7-a12f-478e-9c92-0a9da1e4d377,fc3d640d-7f5a-49ca-ab26-8096b2a27beb,5ebbe195-0a26-41ce-9477-183a2408f2f5,d69b33f5-1aeb-48ea-8130-69338b74437c,7e16171b-fb3c-492c-839f-9b44d66a74f3,5f49bf11-74f1-49bc-803a-cc4fe1f93544,6a890179-caa6-48f2-9636-b2e33529f1a3,24404c36-5b44-4119-81a7-c685725f18aa,c131595c-532d-4e52-bf21-623cd839a5b2,b5e21b62-fdce-41da-8bbd-703f1c66164f,f9e9bdef-6a0a-429d-b4a8-5f67e36b8dce,92cc2bf1-347c-4d96-a48a-a29425202c3f,163f4dde-b461-44a8-b594-d4c91584adb0,6ce4b63d-2a75-4b77-9a6f-f3f916504df4,7d76d4d3-919a-4c5b-bb11-96f8cff7b88b,9d9820be-ae54-4cc2-bc81-284b2004a621,f750b3ae-c8eb-44f4-a2b5-57ffc57974d2,7e990abe-e64c-4652-8297-0d2690dc7702,6e6553bd-eaea-4b18-9438-377edf7b90ba,95512d88-a103-4384-8151-bd38f6626a92,33993019-6b20-4366-b1dd-5908529d0c6f,2c293c4c-1164-43af-9052-7d035d40dc15,535d476c-662f-4865-8fea-f668da2e86fd,f7444171-a853-4202-b35a-986ff1e8e970,74c75b01-2d47-4c6c-8053-a38bfa3975a1,9552f718-c95d-47f1-8e2b-fa7249e4696f,ccebc7e7-d60c-4355-a841-6c854721e6e8,0c343a3d-0ff8-4f50-a9c1-95e99300c1a7,ad811089-6866-4e2f-9c05-46ebff59473d,c043ebe8-c592-490a-a135-d81c91baad02,685843d2-d5eb-4a2d-b368-40ee80914321,c5b9e3e0-a1e9-4acc-b06f-0a3d1783f25a,d4329226-177d-43fc-bbeb-fa91290b3145,aff96c44-e615-4c9b-9dfe-4891a2b6a478,eeace50c-5b2e-4150-a77e-cb248aa47b1b,06557064-9d6e-49c5-a482-aea5b63c028e,f530ba27-50f5-4c80-8c42-49aba9e31715,25a43231-a17a-4e5b-b493-3e1c4a496902,054bcc63-f006-4558-88d9-c27e7ce9b1a3,dac041bd-c07e-44a9-a299-052b14daaa1a,3c959f96-d81a-4e73-b278-3a8cfce5afe4,ec0ebeca-ba0c-4bb1-9a04-4ef73373fcab,c21b5ff2-f211-435d-aa11-9b23dda45d0e,089529db-ccc9-4572-bd9b-ae9e0626afda,9ecbb895-970b-4302-bf11-34917e8e662a,42501d48-e805-403e-97f4-4e237c617fa3}'::uuid[])))