explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 33wa

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 10,734.639 ↓ 4.1 236 1

Unique (cost=118,292.90..118,293.18 rows=57 width=65) (actual time=10,734.508..10,734.639 rows=236 loops=1)

2. 0.899 10,734.569 ↓ 12.4 705 1

Sort (cost=118,292.90..118,293.04 rows=57 width=65) (actual time=10,734.508..10,734.569 rows=705 loops=1)

  • Sort Key: pd.suborderid
  • Sort Method: quicksort Memory: 124kB
3. 0.552 10,733.670 ↓ 12.4 705 1

Nested Loop Left Join (cost=110,889.39..118,291.24 rows=57 width=65) (actual time=7,132.491..10,733.670 rows=705 loops=1)

4. 0.990 10,731.003 ↓ 12.4 705 1

Nested Loop (cost=110,888.97..118,229.18 rows=57 width=59) (actual time=7,132.482..10,731.003 rows=705 loops=1)

5. 730.753 10,725.783 ↓ 4.4 705 1

Hash Join (cost=110,888.54..117,016.25 rows=161 width=52) (actual time=7,132.463..10,725.783 rows=705 loops=1)

  • Hash Cond: ((unnest(sellerinvoicemappingtable.payoutids)) = pd.id)
6. 8,460.411 9,992.612 ↓ 45.4 11,078,633 1

HashAggregate (cost=94,473.48..97,522.10 rows=243,889 width=22) (actual time=7,127.142..9,992.612 rows=11,078,633 loops=1)

  • Group Key: (unnest(sellerinvoicemappingtable.payoutids)), sellerinvoicemappingtable.invoiceid, sellershop101serviceinvoicetable.igst
7. 1,051.194 1,532.201 ↓ 45.4 11,078,633 1

Gather (cost=6,582.31..92,644.32 rows=243,889 width=22) (actual time=32.205..1,532.201 rows=11,078,633 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 399.567 481.007 ↑ 2.8 3,692,878 3 / 3

ProjectSet (cost=5,582.31..67,255.42 rows=10,162,000 width=22) (actual time=29.973..481.007 rows=3,692,878 loops=3)

9. 41.428 81.440 ↑ 1.3 80,062 3 / 3

Parallel Hash Left Join (cost=5,582.31..15,683.26 rows=101,620 width=269) (actual time=29.970..81.440 rows=80,062 loops=3)

  • Hash Cond: (sellerinvoicemappingtable.invoiceid = sellershop101serviceinvoicetable.invoiceid)
10. 10.576 10.576 ↑ 1.3 80,062 3 / 3

Parallel Seq Scan on sellerinvoicemappingtable (cost=0.00..9,834.20 rows=101,620 width=263) (actual time=0.004..10.576 rows=80,062 loops=3)

11. 16.833 29.436 ↑ 1.2 80,062 3 / 3

Parallel Hash (cost=4,331.58..4,331.58 rows=100,058 width=14) (actual time=29.436..29.436 rows=80,062 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 13376kB
12. 12.603 12.603 ↑ 1.2 80,062 3 / 3

Parallel Seq Scan on sellershop101serviceinvoicetable (cost=0.00..4,331.58 rows=100,058 width=14) (actual time=0.005..12.603 rows=80,062 loops=3)

13. 0.143 2.418 ↑ 12.0 472 1

Hash (cost=16,344.18..16,344.18 rows=5,670 width=54) (actual time=2.418..2.418 rows=472 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 110kB
14. 2.275 2.275 ↑ 12.0 472 1

Index Scan using payoutdetailstable_new_suborderid_storeid_key on payoutdetailstable pd (cost=0.43..16,344.18 rows=5,670 width=54) (actual time=0.190..2.275 rows=472 loops=1)

  • Index Cond: (suborderid = ANY ('{7548748,7548517,7548405,7548208,7548058,7547931,7547790,7547604,7547531,7547048,7547021,7546589,7546141,7546115,7545930,7544820,7543853,7543599,7543547,7543535,7543128,7542957,7541697,7540061,7539645,7539322,7538737,7536183,7536031,7535969,7535760,7532557,7531961,7531645,7527455,7527254,7527070,7526946,7526657,7526396,7526094,7525750,7525723,7524394,7524261,7524068,7524020,7523951,7523788,7523674,7523650,7523069,7521764,7521462,7521369,7520067,7519998,7519959,7512694,7512102,7511828,7511028,7510441,7510410,7510386,7510367,7510357,7510334,7510132,7510094,7509986,7509951,7509912,7509872,7509504,7509110,7509096,7508752,7507639,7507513,7507418,7507333,7507204,7506685,7506602,7506439,7506286,7506236,7506234,7506210,7505795,7505625,7505589,7505361,7504918,7504886,7503979,7503851,7503585,7503468,7503295,7499622,7499531,7499527,7499309,7498725,7497654,7497590,7497023,7496913,7496783,7494915,7494528,7494292,7494125,7493485,7493484,7493483,7492779,7492686,7491434,7490192,7490162,7489960,7489857,7489803,7489451,7489312,7489282,7489268,7488582,7488426,7485359,7484087,7483209,7482308,7482297,7482171,7481388,7481171,7480657,7480575,7480074,7479575,7479232,7478959,7478884,7477884,7477357,7477334,7477073,7476338,7475990,7471762,7470105,7470068,7467890,7466878,7465685,7465670,7465430,7465428,7464096,7460661,7454984,7454413,7453925,7453658,7452901,7452803,7452799,7452773,7452753,7452011,7451764,7451519,7451467,7451443,7449871,7449201,7448932,7448931,7448750,7447916,7447905,7447546,7447538,7447521,7447476,7446470,7446414,7445769,7445758,7445364,7445361,7445317,7444449,7444144,7442278,7442262,7442220,7441771,7440822,7437188,7437150,7437003,7435884,7435471,7435084,7434600,7434565,7434540,7434427,7434255,7434049,7433991,7433831,7432394,7431196,7431188,7431187,7431186,7431170,7431166,7431165,7431161,7431160,7431159,7431156,7431130,7431127,7431123,7431118,7431115,7431085,7431061,7431053,7431048,7431044,7431043,7431042,7431041,7431040,7431037,7430965,7430964,7430956,7430952,7430932,7430745,7430529,7430168,7429776,7429671,7429571,7429561,7429551,7429281,7429270,7429159,7429110,7428897,7428828,7428745,7428697,7428363,7428294,7428212,7427696,7427625,7427531,7427424,7427330,7425913,7425885,7425684,7425612,7425581,7425553,7425481,7425430,7425357,7425079,7424750,7424682,7424657,7424586,7424380,7424366,7424354,7424241,7424167,7424081,7424074,7424026,7423882,7423879,7423812,7423813,7423781,7423062,7423010,7422974,7422941,7422915,7422894,7422754,7421821,7421400,7421383,7419079,7418866,7418841,7418781,7418778,7418723,7417965,7417939,7417879,7417645,7417630,7417606,7417593,7416257,7412366,7411274,7406451,7406101,7406032,7403053,7401902,7401848,7401760,7399230,7399038,7398995,7398247,7398158,7398111,7397872,7397572,7397091,7396873,7396180,7395840,7395744,7395636,7395377,7395220,7394111,7393919,7393762,7393707,7393557,7393528,7393351,7393304,7393144,7392923,7392845,7392535,7392160,7390680,7390056,7389459,7389158,7388093,7387607,7387520,7386872,7386694,7386630,7386590,7386469,7386403,7386274,7386217,7386148,7385415,7384910,7384770,7384559,7384371,7384330,7384331,7383785,7383473,7383418,7383419,7383202,7382612,7382439,7382109,7381752,7380649,7380523,7380495,7380318,7380292,7379619,7379600,7379489,7379353,7379190,7379133,7375175,7374827,7374799,7374474,7374054,7373940,7373221,7373176,7371963,7371938,7371820,7371708,7371554,7371514,7370303,7369900,7369644,7367331,7367292,7366912,7366804,7366747,7366716,7364379,7364274,7364178,7364144,7364101,7363161,7363147,7363023,7362617,7362451,7361271,7361084,7360749,7359928,7359553,7358483,7357935,7356525,7356524,7356447,7356405,7356091,7355923,7355891,7355618,7355569,7355539,7355441,7355361,7355236,7355209,7355168,7355037,7354963,7353682,7353183,7353064,7352961,7352943,7352705,7352666,7352633,7352625,7352547,7352471,7352468,7352438,7352386,7351646,7350349,7350259,7350253,7350211,7350195,7350174,7350086,7349937,7349910,7349856,7349783,7349759,7349715,7349691,7349550,7349534,7349477,7349443,7349259,7349208,7349185,7348743,7348732,7347974,7347856,7347810,7347713,7347703,7347677,7347640,7347375,7347281,7347264,7347238,7347168,7347136,7347107,7347005,7346964,7346907,7346273,7345865,7345631,7345563,7345495,7344980,7344775,7344710,7343253,7342647,7342562,7342507,7342460,7342422,7342261,7341782,7339196,7339173,7338744,7338488,7337899,7337739,7337626,7337603,7337414,7337362,7336937,7336831,7336722,7336668,7336637,7336615,7336102,7335715,7335557,7335530,7335474,7335433,7335414,7335257,7335065,7334326,7334296,7334217,7334192,7334165,7334020,7333685,7333590,7332083,7331941,7330027,7329992,7329970,7329939,7329896,7329869,7329816,7329055,7328936,7328486,7326286,7326238,7325879,7325863,7324862,7324836,7324807,7324762,7324723,7324677,7324641,7324608,7323930,7323852,7323824,7323727,7323666,7323476,7323463,7322129,7321900,7321636,7321565,7320988,7319542,7319477,7319156,7318893,7318761,7318599,7318543,7317922,7317910,7317493,7317064,7316927,7316365,7316357,7316352,7316308,7316286,7316199,7316123,7316066,7316046,7315700,7315400,7315084,7314434,7314141,7314066,7314036,7313971,7313783,7313559,7313530,7313283,7313243,7312912,7312505,7312470,7312245,7311947,7311908,7311745,7311687,7311683,7311553,7311492,7310603,7310447,7310299,7310232,7310208,7310199,7310101,7310068,7310048,7310020,7309992,7309932,7309551,7309160,7308861,7308580,7308536,7308433,7307277,7307174,7306686,7306419,7306173,7306093,7305225,7304935,7304906,7304587,7304383,7304047,7302061,7302035,7300865,7300864,7300720,7300696,7300674,7300447,7300430,7300377,7300279,7300236,7300209,7300174,7300160,7299966,7299935,7299886,7299573,7299506,7299192,7298336,7297952,7297917,7297892,7297848,7297847,7297775,7297776,7297528,7297476,7297080,7297055,7296880,7296863,7296783,7296717,7296678,7296464,7296425,7296365,7296325,7296278,7295939,7295863,7295626,7294837,7294584,7294383,7294150,7294089,7294058,7293812,7293744,7293409,7292742,7292576,7292201,7292199,7292069,7291832,7291758,7291596,7291529,7290962,7290621,7290330,7290284,7290133,7289951,7289499,7289405,7288606,7288451,7288448,7288212,7288187,7288088,7288073,7288068,7288061,7287981,7287956,7287949,7287943,7287939,7287931,7287927,7287768,7287716,7287615,7287447,7287439,7287345,7287296,7287202,7287110,7287075,7287016,7287001,7286943,7286883,7286877,7286802,7286800,7286725,7286658,7286630,7286528,7286508,7286376,7286349,7286024,7285827,7285787,7285409,7285055,7285022,7284879,7284863,7284821,7284814,7284591,7284559,7284165,7283834,7283803,7283774,7282872,7282311,7280003,7279991,7279963,7279939,7278999,7278971,7278736,7278444,7278223,7278115,7277831,7277830,7277827,7277490,7277358,7277099,7277043,7275781,7275751,7275743,7275599,7275577,7275552,7275530,7275489,7275450,7275429,7275328,7275326,7275197,7274739,7274561,7274502,7274492,7274474,7274456,7274292,7274239,7274231,7274218,7273680,7273638,7273295,7272647,7272612,7272496,7270360,7269165,7268871,7268862,7268539,7268441,7268411,7268375,7268298,7268184,7268156,7268155,7268070,7267926,7267862,7267186,7266959,7266674,7266256,7265900,7265670,7265522,7265460,7265413,7265327,7265308,7265248,7265241,7265216,7265171,7264907,7263241,7263101,7263100,7263075,7263022,7262981,7262900,7262898,7262232,7261801,7261520,7261510,7261069,7260963,7260901,7260882,7260858,7260832,7260816,7260168,7259822,7259501,7259482,7259470,7259426,7259386,7259372,7259337,7259326,7259311,7259283,7259282,7258933,7258911,7258886,7258877,7258862,7258845,7258841,7258836,7258826,7258805,7258793,7258775,7258706,7258688,7258648,7258599,7258403,7258365,7258130,7257744,7257703,7257668,7257449,7257145,7256968,7256741,7256701,7256641,7256498,7256470,7256301,7256292,7256273,7256250,7256170,7256145,7256143,7255936,7255812,7255790,7255679,7255619,7254323,7252212,7252213,7250342,7250098,7249930,7249737,7249731,7249702,7249525,7249506,7249492,7249394,7248926,7248895,7248846,7248823,7248694,7248639,7248508,7248404,7246691,7245983,7244402,7244085,7243920,7243919,7243658,7243467,7243310,7243273,7243220,7243161,7243138,7243117,7243112,7243109,7242810,7242451,7242436,7242160,7241793,7241719,7240980,7240890,7240873,7240809,7240790,7240728,7240647,7240365,7240253,7239853,7239742,7239547,7239013,7238656,7238614,7238337,7237909,7237878,7237804,7237766,7237695,7237632,7237617,7237616,7237541,7237413,7237132,7237012,7236714,7236675,7236666,7236447,7236298,7236197,7235580,7235497,7235474,7235442,7235440,7235288,7235272,7235164,7235139,7234945,7234920,7234875,7234504,7234395,7234228,7234129,7233719,7233614,7233520,7233439,7233412,7233282,7233131,7233046,7232939,7232630,7232536,7231979,7231850,7231758,7231672,7231667,7231614,7231610,7231583,7231433,7231381,7231103,7230951,7230857,7230675,7230627,7230481,7230463,7229738,7229321,7229154,7229100,7229043,7229027,7228972,7228968,7228443,7228202,7228159,7228152,7227917,7227262,7226857,7226699,7226674,7226548,7226485,7226329,7226188,7225772,7225736,7225558,7225477,7225207,7224999,7224669,7224536,7224535,7224484,7224360,7224265,7223989,7223786,7223706,7223677,7223375,7223200,7223096,7222691,7222379,7222307,7222140,7222061,7221837,7221824,7221770,7221713,7221373,7221371,7221181,7221003,7220966,7220939,7220891,7220560,7220520,7220343,7220294,7220286,7219938,7219918,7219872,7219643,7219572,7219551,7219505,7219379,7219371,7219312,7219279,7218954,7218872,7218690,7218465,7218230,7218194,7218164,7218141,7218040,7217991,7217727,7217705,7217688,7217678,7217336,7217247,7217117,7217044,7216946,7216790,7216762,7216619,7216556,7216198,7216130,7216112,7216060,7215996,7215474,7215012,7214824,7214626,7214526,7214396,7214318,7214265,7214252,7214171,7214091,7214052,7213992,7213969,7213368,7213317,7213304,7213132,7212814,7212731,7212467,7212366,7212256,7212238,7211752,7211710,7211568,7211236,7211159,7211125,7210915,7210723,7210705,7210444,7210398,7210206,7209884,7208928,7208838,7208822,7207938,7207585,7207213,7207189,7207064,7206982,7206740,7206506,7206467,7206205,7206016,7205892,7204298,7203784,7203674,7200036,7199422,7194526,7193763,7189419,7176801,7174356,7155658,7153694,7145752,7142987,7140909,7134905,7129276,7121053,7121028,7093480,7092483,7089141,7082896,7082893,7072080,7072079,7068241,7062491,7060286,7052256,6982959,6965273,6963651,6963323,6962853,6911890,6910602,6865527,6865439,6840165,6825550,6822683,6822682,6817659,6801577,6795247,6774408,6765962,6761762,6744985,6742888,6718194,6709285,6689746}'::bigint[]))
15. 4.230 4.230 ↑ 1.0 1 705

Index Scan using sellerpaymentrecordtable_invoiceid_success_key on sellerpaymentrecordtable (cost=0.43..7.52 rows=1 width=15) (actual time=0.006..0.006 rows=1 loops=705)

  • Index Cond: ((invoiceid = pd.invoiceid) AND (success = true))
  • Filter: success
16. 2.115 2.115 ↑ 1.0 1 705

Index Scan using subordertcsgsttable_invoiceid_gstid_key on subordertcsgsttable stcs (cost=0.41..1.08 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=705)

  • Index Cond: (invoiceid = pd.invoiceid)
Planning time : 2.057 ms
Execution time : 10,826.037 ms