explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PfZS

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

Unique (cost=781,266.70..781,270.56 rows=514 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=781,266.70..781,267.99 rows=514 width=8) (actual rows= loops=)

  • Sort Key: po_revision_branch_assoc.id_instan_branch, mv_scr_activity_stats.id_employee
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,133.26..781,243.56 rows=514 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on mv_scr_activity_stats (cost=1,133.26..158,093.82 rows=45,526 width=51) (actual rows= loops=)

  • Recheck Cond: (id_project_sub = 81,873)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_mv_scr_activity_stats_id_project_sub (cost=0.00..1,121.88 rows=45,526 width=0) (actual rows= loops=)

  • Index Cond: (id_project_sub = 81,873)
6. 0.000 0.000 ↓ 0.0

Append (cost=0.00..13.67 rows=2 width=50) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on po_revision_branch_assoc (cost=0.00..0.00 rows=1 width=40) (actual rows= loops=)

  • Filter: (bl_is_optimized AND (id_enterprise = 121) AND (mv_scr_activity_stats.id_infra_instan = id_infra_instan) AND (mv_scr_activity_stats.tx_revision = (tx_revision)::text) AND (id_instan_branch = ANY ('{1214513,954401,1033279,2203665,2203667,2203666,2203669,2203668,2203671,1421347,2203670,2203673,2203672,2203675,2203674,2203677,2203676,2203678,2253986,2244770,2253987,2244771,2253984,2244768,2253985,2244769,2253990,2244774,2253991,2244775,2253988,2244772,2253989,2244773,2244778,2244779,2253992,2244776,2244777,2244780,2257074,2257075,2257073,2257078,2257079,2257076,2257077,2257082,2257083,2257080,2257081,2257086,2257084,2257085,1177787,1177788,2253979,2253982,2253983,2244767,1244332,2253980,2253981,1316052,2268386,2268387,2268385,2268390,2268391,2268388,1316051,2268389,2268394,2268395,2268392,2268393,2268398,2268396,2268397,1143016,2221345,2221344,2221347,2221346,2221348,2226473,2226475,2226474,2226477,2226476,2226479,2226478,2226481,2226480,2226483,2226482,2226485,2226484,1214727,2226486,923936,2221335,2221337,2221336,2221339,2221338,2221341,2221340,2221343,2221342,1165649,2219360,1165648,1165651,1165650,1165653,1165652,1165655,1165654,1165657,1165656,1165659,1165658,1165661,1165660,1165663,1165662,1165637,1118535,1165639,1118534,1165638,1118537,1165641,1118536,1165640,1165643,1165642,1165645,1165644,1165647,1165646,2255170,1165681,2255171,1165680,865647,1165683,2255169,1165682,2255174,1165685,2255175,1165684,2255172,1165687,2255173,1165686,2255178,1165689,2255179,1165688,2255176,1165691,2255177,1165690,2255182,1165693,1165692,2255180,1165695,2255181,1165694,1165665,1165664,2219347,871807,1165667,1165666,2219349,1165669,2219348,1165668,2219351,1165671,2219350,1165670,2219353,1165673,2219352,1165672,2219355,1165675,2219354,1165674,2219357,1165677,2219356,1165676,2219359,1165679,2219358,1165678,1165713,1165712,1165715,1165714,1165717,1165716,1165719,1165718,1165721,1165720,1165723,1165722,1165725,1165724,2222511,1165727,1165726,2222513,1165697,2222512,1165696,2222515,1165699,2222514,1165698,2222517,1165701,2222516,1165700,2222519,1165703,2222518,1165702,2222521,1165705,881044,2222520,1165704,2222523,1165707,2222522,1165706,1165709,2222524,1165708,1165711,1165710,1165745,1165744,1165747,1165746,1165749,1165748,1165751,1165750,2227593,1157561,1165753,1165752,2227595,2227594,1165754,2227597,2227596,2227599,2227598,2227601,1165729,2227600,1165728,1201568,2227603,1165731,2227602,1165730,2227605,1165733,2227604,1165732,1165735,2227606,1165734,1165737,1165736,1165739,1165738,1187246,1165741,1165740,934320,1165743,934321,1165742,1200591,2266566,2266567,1354226,1354227,2266565,2266570,2266571,2266568,2266569,2266574,2266575,2266572,2266573,2266578,2266576,2266577,2211361,2211360,2211363,1186320,2211362,1186321,2211365,2211364,2211367,2211366,869916,2205235,2205237,2205236,2205239,2205238,2205241,2205240,2205243,2205242,2205245,2205244,2205247,2205246,861737,861736,2211355,2211354,2211357,2211356,2211359,2211358,2205248,1017461,1017460,2259622,2259623,2258599,2259621,2259626,2258602,2259627,2258603,2259624,2258600,2259625,2258601,2259630,2258606,2259631,2258607,2259628,2258604,2259629,2258605,2259634,2258610,2258611,2259632,2258608,2259633,2258609,2250423,2258612,2250426,2250427,2250424,2250425,2250430,2250431,2250428,2250429,2249346,2249347,1093298,2249345,1122994,2249350,2249351,2249348,2249349,2249354,2249355,1123003,2249352,2249353,2249358,1123004,2249356,2249357,1177250,2253546,2253547,2253545,1015492,2253550,2253551,2253548,2253549,2253554,2253555,2253552,2253553,2253558,2253559,2253556,2253557,2253562,2253563,2253560,2253561,2253566,2253567,2253564,2253565,2250434,2250435,2250432,2250433,2250436,1212158,1212159,1160981,2215723,2215722,2215725,2215724,2215727,2215726,1212162,2215729,1209091,1212163,2215728,1212160,2215731,1212161,2215730,1212166,2215733,1212167,2215732,1212164,2215735,1212165,2215734,1212170,1212168,1212169,2253570,2253571,2253568,2253569,2253572,2211649,2211648,2211651,2211650,2211653,2211652,2211655,2211654,2211657,2211656,2211659,2211658,2211661,2211660,1184609,869285,2261986,2261984,2261985,1228758,1228759,1224693,2261974,2261975,2261973,2261978,2261979,2261976,2261977,2261982,2261983,2261980,2261981}'::integer[])))
8. 0.000 0.000 ↓ 0.0

Index Scan using idx_po_revision_branch_assoc_121_infra_revision on po_revision_branch_assoc_121 (cost=0.69..13.67 rows=1 width=50) (actual rows= loops=)

  • Index Cond: ((id_infra_instan = mv_scr_activity_stats.id_infra_instan) AND ((tx_revision)::text = mv_scr_activity_stats.tx_revision) AND (bl_is_optimized = true))
  • Filter: (bl_is_optimized AND (id_enterprise = 121) AND (id_instan_branch = ANY ('{1214513,954401,1033279,2203665,2203667,2203666,2203669,2203668,2203671,1421347,2203670,2203673,2203672,2203675,2203674,2203677,2203676,2203678,2253986,2244770,2253987,2244771,2253984,2244768,2253985,2244769,2253990,2244774,2253991,2244775,2253988,2244772,2253989,2244773,2244778,2244779,2253992,2244776,2244777,2244780,2257074,2257075,2257073,2257078,2257079,2257076,2257077,2257082,2257083,2257080,2257081,2257086,2257084,2257085,1177787,1177788,2253979,2253982,2253983,2244767,1244332,2253980,2253981,1316052,2268386,2268387,2268385,2268390,2268391,2268388,1316051,2268389,2268394,2268395,2268392,2268393,2268398,2268396,2268397,1143016,2221345,2221344,2221347,2221346,2221348,2226473,2226475,2226474,2226477,2226476,2226479,2226478,2226481,2226480,2226483,2226482,2226485,2226484,1214727,2226486,923936,2221335,2221337,2221336,2221339,2221338,2221341,2221340,2221343,2221342,1165649,2219360,1165648,1165651,1165650,1165653,1165652,1165655,1165654,1165657,1165656,1165659,1165658,1165661,1165660,1165663,1165662,1165637,1118535,1165639,1118534,1165638,1118537,1165641,1118536,1165640,1165643,1165642,1165645,1165644,1165647,1165646,2255170,1165681,2255171,1165680,865647,1165683,2255169,1165682,2255174,1165685,2255175,1165684,2255172,1165687,2255173,1165686,2255178,1165689,2255179,1165688,2255176,1165691,2255177,1165690,2255182,1165693,1165692,2255180,1165695,2255181,1165694,1165665,1165664,2219347,871807,1165667,1165666,2219349,1165669,2219348,1165668,2219351,1165671,2219350,1165670,2219353,1165673,2219352,1165672,2219355,1165675,2219354,1165674,2219357,1165677,2219356,1165676,2219359,1165679,2219358,1165678,1165713,1165712,1165715,1165714,1165717,1165716,1165719,1165718,1165721,1165720,1165723,1165722,1165725,1165724,2222511,1165727,1165726,2222513,1165697,2222512,1165696,2222515,1165699,2222514,1165698,2222517,1165701,2222516,1165700,2222519,1165703,2222518,1165702,2222521,1165705,881044,2222520,1165704,2222523,1165707,2222522,1165706,1165709,2222524,1165708,1165711,1165710,1165745,1165744,1165747,1165746,1165749,1165748,1165751,1165750,2227593,1157561,1165753,1165752,2227595,2227594,1165754,2227597,2227596,2227599,2227598,2227601,1165729,2227600,1165728,1201568,2227603,1165731,2227602,1165730,2227605,1165733,2227604,1165732,1165735,2227606,1165734,1165737,1165736,1165739,1165738,1187246,1165741,1165740,934320,1165743,934321,1165742,1200591,2266566,2266567,1354226,1354227,2266565,2266570,2266571,2266568,2266569,2266574,2266575,2266572,2266573,2266578,2266576,2266577,2211361,2211360,2211363,1186320,2211362,1186321,2211365,2211364,2211367,2211366,869916,2205235,2205237,2205236,2205239,2205238,2205241,2205240,2205243,2205242,2205245,2205244,2205247,2205246,861737,861736,2211355,2211354,2211357,2211356,2211359,2211358,2205248,1017461,1017460,2259622,2259623,2258599,2259621,2259626,2258602,2259627,2258603,2259624,2258600,2259625,2258601,2259630,2258606,2259631,2258607,2259628,2258604,2259629,2258605,2259634,2258610,2258611,2259632,2258608,2259633,2258609,2250423,2258612,2250426,2250427,2250424,2250425,2250430,2250431,2250428,2250429,2249346,2249347,1093298,2249345,1122994,2249350,2249351,2249348,2249349,2249354,2249355,1123003,2249352,2249353,2249358,1123004,2249356,2249357,1177250,2253546,2253547,2253545,1015492,2253550,2253551,2253548,2253549,2253554,2253555,2253552,2253553,2253558,2253559,2253556,2253557,2253562,2253563,2253560,2253561,2253566,2253567,2253564,2253565,2250434,2250435,2250432,2250433,2250436,1212158,1212159,1160981,2215723,2215722,2215725,2215724,2215727,2215726,1212162,2215729,1209091,1212163,2215728,1212160,2215731,1212161,2215730,1212166,2215733,1212167,2215732,1212164,2215735,1212165,2215734,1212170,1212168,1212169,2253570,2253571,2253568,2253569,2253572,2211649,2211648,2211651,2211650,2211653,2211652,2211655,2211654,2211657,2211656,2211659,2211658,2211661,2211660,1184609,869285,2261986,2261984,2261985,1228758,1228759,1224693,2261974,2261975,2261973,2261978,2261979,2261976,2261977,2261982,2261983,2261980,2261981}'::integer[])))