explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ysg5

Settings
# exclusive inclusive rows x rows loops node
1. 1.352 23,341.359 ↓ 0.0 0 1

Delete on input_data (cost=0.00..5,061,048.10 rows=1,000 width=6) (actual time=23,341.359..23,341.359 rows=0 loops=1)

  • Buffers: shared hit=2000 read=59623 dirtied=49 written=2
2. 23,340.007 23,340.007 ↑ 1.0 1,000 1

Seq Scan on input_data (cost=0.00..5,061,048.10 rows=1,000 width=6) (actual time=0.485..23,340.007 rows=1,000 loops=1)

  • Filter: (batch_id = ANY ('{19749,19769,19787,19807,19826,19841,19858,19866,19867,19869,19872,19873,19884,19894,19903,19912,19919,19927,19935,19943,19951,19959,19967,19975,19983,19992,19999,20007,20014,20021,20028,20032,20037,20042,20047,20052,20057,20062,20067,20072,22494,20222,20248,20278,19646,19668,19689,19709,19729,19750,19770,19788,19808,19827,19842,19859,19875,19885,19895,19904,19913,19920,19928,19936,19944,19952,19960,19968,19976,19984,19993,20000,20008,20015,20022,20029,20033,20038,20043,20048,20053,20058,20063,20068,20071,20073,20078,20083,20088,20093,20095,22495,20223,19647,19669,19690,19710,19730,19751,19771,19789,19809,19828,19843,19860,19876,19886,19896,19905,19914,19921,19929,19937,19945,19953,19961,19969,19977,19985,19990,20001,20005,20009,22496,22497,20225,27931,27932,20249,22519,19648,19670,19691,19711,19731,19752,19772,19790,19810,19829,19844,22498,20226,27933,27934,22520,22557,22558,20252,22601,22661,22662,22663,22728,22761,19649,19671,19692,19712,19732,19753,19773,19791,19811,19830,19845,19862,19877,19887,19897,19906,19915,19922,19930,19938,19946,19954,19962,19970,19978,19986,19994,20002,20010,20016,20017,20023,20024,20026,20034,20039,20044,20049,20054,20059,20064,20069,20074,20076,20079,20081,20082,20084,20085,20086,20087,20089,20090,20091,20092,20094,22499,20227,27935,20253,20267,20270,20271,20274,20276,22509,22510,22511,22514,22515,22517,22518,22521,22554,22555,22556,22602,20096,20097,20098,20099,20100,20101,20102,20103,20104,20105,20106,20107,20108,20109,20110,20111,20112,20113,20114,20115,20116,20117,20118,20119,20120,20121,20122,20123,20124,22664,20125,20126,20127,20128,22696,22729,20286,20295,20300,20304,20308,20312,20316,20319,20321,20323,20325,20129,20130,20131,20132,20133,20134,20135,20136,20137,20138,20139,20140,20141,20142,20327,22762,20329,22811,22844,22873,22903,22933,22963,22993,23023,23053,23083,23113,20143,20144,20145,20146,20147,20148,20149,20150,20151,20152,20153,20154,20155,20330,20332,20334,20336,20338,20340,20342,20344,20346,20348,20350,20352,20354,20356,20358,20360,20362,20364,20366,20368,20163,20164,20165,20166,20167,20168,20169,20170,20171,20172,20173,20174,20175,20176,20156,20157,20158,20159,20160,20161,20162,22500,27936,27937,22522,22560,22603,22665,22697,22730,22754,22812,22845,22874,22904,20177,20178,20179,20180,20181,20182,20183,20184,20185,20186,20187,20188,20228,22934,20254,22964,20280,22994,23024,23054,23084,23114,23143,23144,23167,23200,23227,23253,23280,23307,23334,23361,23388,23415,23442,23472,23499,20282,20283,20284,20285,20287,20288,20289,20290,20291,20292,20293,20294,20296,20297,20298,20299,20301,20302,20303,20305,20306,20307,20309,20310,20311,20313,20314,20315,20317,20318,20320,20322,20324,20326,20328,20331,20333,20335,20337,20339,20341,20343,20345,20347,20349,20351,20353,20355,20357,20359,20361,20363,20365,22501,27870,27938,27940,22523,22561,22604,22666,22698,22731,22763,22813,22846,22875,22905,22935,22965,22995,23025,23055,23085,23115,23145,23173,23195,23201,20367,20369,20370,20371,20372,20373,20374,20375,20376,20377,20378,20379,20380,20381,20382,20383,20384,20385,20386,20387,20388,20389,20390,20391,20392,20393,20394,20395,20396,20397,20398,20399,20400,20401,20402,23254,23281,23308,23335,23362,23389,23416,23443,23473,23500,23521,23545,23569,23593,23617,23640,23663,23687,23710,23733,23756,23768,23779,23802,20403,20404,20405,20406,20407,20408,20409,20410,20411,20412,20413,20414,20415,20416,20440,23840,23861,23882,23905,23926,23946,23966,23985,23988,24007,24026,24044,24062,24080,24095,24111,24127,24143,24159,24174,24190,24206,24222,24234,24249,24261,24274,24287,25184,22502,25185,25186,25187,25188,22524,25189,22562,22605,22667,22699,22732,22764,22814,22847,22876,22906,22936,22966,22996,23026,23056,23086,23116,23146,20417,20418,20419,20420,20421,20422,20423,20424,20425,20426,20427,20428,20429,20430,20431,20432,20433,20434,20435,20436,20437,20438,20439,23174,23202,23228,23255,23282,23309,23336,23363,23390,23417,23444,23474,23501,23522,23546,20441,20442,20443,20444,20445,20446,20447,20448,20449,20450,20451,20452,20453,20454,20455,20456,20457,20458,20459,20460,20461,20462,20463,20464,20465,20466,20467,20468,20469,20470,20481,20482,23570,23594,23618,23641,23664,23688,23711,23734,23757,23780,23803,23823,23841,23862,23883,23906,23927,23947,23967,23986,23989,24008,24027,24045,24063,24081,24096,24112,24128,24144,24160,24175,24179,20471,20472,20473,20474,20475,20476,20477,20478,20479,20480,25190,22503,25191,25192,25193,22525,22563,22606,22668,22700,22733,20483,20484,20485,20486,20487,20488,20489,20490,20491,20492,20493,20494,20495,20496,20497,20498,22765,22815,22848,22877,22907,22937,22967,22997,20499,20500,20501,20502,20503,20504,20505,20506,20507,20508,20509,20510,20511,20512,20513,20514,20515,20516,20517,23027,23057,23087,23117,23147,23175,20518,20519,20520,20521,20522,20523,20524,20525,20526,20527,20528,20529,20530,20531,23203,23229,23256,23283,23310,23337,23364,23391,23418,23445,23475,23502,23523,20532,20533,20534,20535,20536,20537,20538,20539,20540,20541,20542,20543,20544,20545,20546,20547,20548,23547,23571,23595,23619,23642,23665,23689,23712,23735,23758,23781,23804,23824,23842,23863,23884,23907,25194,22504,25195,20549,20550,20551,22526,22564,22607,22669,20552,20553,20554,20555,20556,20557,20558,20559,22701,22734,22766,22781,22783,22786,22790,22849,22878,20560,20561,20562,20563,20564,20565,20566,20567,20568,20569,20570,20571,20572,20573,20574,20575,22908,20576,20577,20578,20579,22938,22968,22998,23028,23058,23088,23118,23148,23176,23204,23230,23257,23284,23311,23338,23365,23392,23419,23446,23476,23503,23524,23548,23572,20580,20581,20582,20583,20584,20585,20586,20587,20588,20589,20590,20591,20592,20593,20594,20595,20596,20597,20598,20600,23596,23620,23643,23666,23690,23713,23736,23759,23782,23805,23825,23843,23864,23885,23908,23928,23948,23968,23987,23990,24009,24028,24046,24064,24082,24097,24113,24129,24145,24161,24176,24192,24208,24214,24235,24250,20599,22462,22463,22464,22465,22466,22467,22468,22469,22470,22471,22472,22473,22474,22475,22476,22477,22478,22479}'::integer[]))
  • Rows Removed by Filter: 3964159
  • Buffers: shared read=59623 dirtied=13 written=2
Planning time : 1.555 ms
Execution time : 23,443.421 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint headers_source_id_fkey on input_data 34.282 ms 1000 0.034 ms
for constraint official_account_source_id_fkey on headers 29.630 ms 1882 0.016 ms
for constraint language_source_id_fkey on headers 37.365 ms 1882 0.020 ms