explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JK4Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,511.522 ↑ 3.4 2,719 1

Sort (cost=620,180.94..620,204.37 rows=9,371 width=4) (actual time=2,511.344..2,511.522 rows=2,719 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 224kB
  • Functions: 20
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 5.865 ms, Inlining 307.463 ms, Optimization 158.427 ms, Emission 91.162 ms, Total 562.918 ms
2. 68.748 2,526.227 ↑ 3.4 2,719 1

Gather (cost=1,000.00..619,562.74 rows=9,371 width=4) (actual time=1,549.568..2,526.227 rows=2,719 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 2,457.479 2,457.479 ↑ 4.3 544 5 / 5

Parallel Seq Scan on pos_order_line (cost=0.00..617,625.64 rows=2,343 width=4) (actual time=1,496.473..2,457.479 rows=544 loops=5)

  • Filter: (order_id = ANY ('{541730,541729,541706,541692,541687,541683,541679,541631,541575,541566,541553,541511,541453,541431,541422,541402,541397,541352,541350,541337,541328,541316,541271,541268,541263,541248,541206,541201,541197,541191,541188,541186,541181,541170,541152,541147,541146,541123,541106,541081,541079,541078,541077,541075,541074,541073,541070,541069,541062,541060,541055,541048,541038,541036,541017,540985,540963,540959,540950,540941,540938,540872,540863,540802,540798,540787,540782,540778,540775,540774,540772,540770,540767,540762,540761,540760,540749,540742,540733,540721,540719,540717,540714,540712,540707,540705,540704,540703,540699,540696,540688,540687,540684,540680,540659,540555,540539,540492,540491,540483,540475,540440,540420,540419,540410,540391,540378,540375,540344,540342,540341,540338,540337,540334,540333,540331,540323,540321,540319,540314,540313,540255,540252,540244,540241,540237,540209,540199,540191,540185,540168,540164,540150,540142,540138,540137,540129,540122,540104,540100,540097,540094,540093,540073,540068,540060,540047,540038,540028,540024,540023,540020,540008,540007,540000,539995,539993,539976,539974,539973,539972,539962,539955,539945,539942,539925,539918,539908,539867,539841,534759,534758,534756,534755,534754,534753,534683,534680,534674,534672,534671,534668,534657,534620,534617,534614,534604,534598,534566,534565,534558,534547,534466,534388,534365,534353,534347,534343,534340,534327,534320,534318,534314,534308,534307,534304,534300,534299,534298,534296,534291,534289,534284,534280,534277,534274,534272,534269,534267,534264,534262,534260,534256,534255,533819,533818,533816,533815,533814,533813,533812,533808,533806,533803,533800,533796,533791,533779,533769,533765,533763,533761,533760,533758,533724,533720,533705,533703,533647,533642,533615,533559,533538,533512,533499,533496,533477,533473,533398,533395,533368,533361,533357,533335,533308,533305,533277,533274,533257,533217,533185,533181,533175,533174,533165,533134,533119,533084,533083,533077,533063,533051,533050,533049,533047,532994,532984,532960,532934,532932,532930,532913,532885,532860,532855,532847,532829,532775,532750,532737,532736,532735,532719,532717,532716,532670,532656,532636,532635,532634,532632,532631,532630,532629,532628,532627,532626,532624,532623,532621,532620,532619,532618,532617,532615,532614,532613,532612,532611,532610,532609,532608,532607,532604,532603,532602,532600,532599,532598,532595,532594,532593,532590,532589,532588,532587,532586,532585,532584,532582,532581,532580,531871,531870,531765,531746,531708,531701,531694,531688,531686,531667,531645,531639,531626,531613,531611,531609,531582,531575,531571,531484,531483,531443,531437,531414,531388,531385,531344,531339,531323,531316,531291,531271,531229,531227,531130,531126,531059,531017,531014,531013,530996,530962,530956,530930,530920,530914,530911,530907,530900,530893,530892,530891,530888,530886,530868,530848,530847,530828,530820,530795,530785,530772,530771,530770,530769,530767,530766,530764,530763,530761,530760,530759,530758,530757,530756,530754,530753,530752,530751,530750,530748,530747,530746,530743,530742,530740,530739,530457,530456,530454,530453,530452,530451,530448,530446,530445,530443,530442,530441,530440,530438,530437,530436,530435,530434,530433,530432,530429,529969,529967,529961,529959,529957,529954,529953,529952,529948,529942,529940,529936,529935,529933,529932,529931,529928,529926,529925,529924,529921,529919,529918,529917,529912,529910,529908,529906,529904,529903,529902,529899,529897,529893,529892,529891,529887,529885,529883,529384,529382,529374,529364,529356,529352,529344,529330,529310,529305,529304,529289,529268,529260,529254,529249,529246,529242,529239,529210,529189,529161,529153,529140,529128,529117,529089,529088,529085,529067,529043,529006,528992,528986,528981,528978,528948,528929,528924,528916,528911,528876,528849,528845,528823,528800,528799,528797,528784,528781,528773,528768,528761,528753,528740,528702,528675,528671,528635,528625,528614,528613,528604,528598,528586,528578,528575,528573,528566,528550,528520,528508,528502,528498,528481,528474,528454,528439,528322,528290,528209,528177,528170,528136,528126,528121,528093,528010,527982,527974,527972,527956,527952,527945,527936,527910,527885,527852,527844,527822,527818,527812,527803,527795,527784,527783,527780,527769,527757,527742,527738,527736,527688,527643,527628,527596,527580,527577,527576,527561,527539,527524,527522,527490,527404,527392,527391,527378,527367,527365,527340,527318,527316,527311,527307,527281,527277,527267,527266,527263,527258,527248,527233,527221,527215,527207,527206,527193,527181,527172,527151,527098,527023,527022,527006,527000,526999,526989,526978,526970,526969,526967,526965,526962,526946,526926,526925,526922,526918,526911,526909,526891,526880,526875,526874,526799,526770,526730,526701,521553,521552,521546,521528,521320,521255,521251,521236,521219,521216,521209,521145,521134,521114,521093,521083,521080,521069,520997,520995,520966,520957,520956,520938,520900,520884,520879,520861,520829,520824,520803,520799,520781,520779,520766,520743,520726,520721,520713,520709,520707,520705,520703,520698,520662,520660,520659,520657,520653,520638,520625,520617,520599,520597,520586,520578,520565,520562,520560,520555,520551,520548,520545,520543,520533,520531,520480,520470,520438,520434,520432,520431,520430,520429,520428,520395,520394,520391,520390,520389,520386,520367,520366,520359,520353,520307,520305,520285,520264,520263,520246,520243,520229,520221,520212,520206,520018,520017,520015,520001,520000,519998,519997,519996,519994,519992,519991,519988,519987,519976,519967,519965,519938,519937,519890,519847,519831,519826,519802,519792,519789,519783,519781,519646,519639,519638,519637,519635,519631,519628,519607,519604,519583,519579,519561,519553,519526,519510,519507,519503,519494,519485,519452,519444,519418,519409,519407,519404,519388,519305,519302,519279,519276,519229,519204,519197,519183,519173,519165,519122,519120,519117,519073,519063,519058,519035,519034,519014,519011,518999,518991,518980,518979,518964,518941,518919,518899,518882,518868,518831,518747,518746,518733,518729,518722,518651,518636,518632,518631,518606,518605,518542,518539,518532,518507,518504,518494,518434,518423,518403,518385,518297,518278,518271,518267,518224,518199,518153,517964,517955,517952,517925,517871,517842,517828,517826,517822,517821,517790,517773,517772,517771,517736,517729,517650,517611,517608,517599,517579,517576,517553,517550,517525,517511,517510,517493,517489,517473,517431,517422,517409,517404,517358,517342,517338,517320,517295,517254,517247,517241,517240,517236,517213,517195,517068,517059,517051,517044,517017,516965,516949,516937,516924,516879,516878,516876,516853,516849,516846,516839,516831,516828,516817,516724,516716,516715,516695,516686,516663,516615,499903,499902,499901,499899,499897,499896,499894,499893,499891,499889,499888,499879,499840,499833,499830,499815,499803,499785,499780,499773,499771,499765,499763,499729,499727,499712,499515,499451,499439,499435,499418,499298,499228,499226,499223,498725,498723,498721,498720,498719,498718,498717}'::integer[]))
  • Rows Removed by Filter: 363,547
Planning time : 2.695 ms
Execution time : 2,528.815 ms