explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XjVT

Settings
# exclusive inclusive rows x rows loops node
1. 21.053 61,303.780 ↑ 3.4 4,674 1

Gather (cost=1,000.00..1,915,224.89 rows=15,661 width=8) (actual time=32,036.956..61,303.780 rows=4,674 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 61,282.727 61,282.727 ↑ 4.2 1,558 3 / 3

Parallel Seq Scan on pgl (cost=0.00..1,912,658.79 rows=6,525 width=8) (actual time=31,802.208..61,282.727 rows=1,558 loops=3)

  • Filter: ((program_line_level2 <> 0) AND ((material_id)::text = ANY ('{00892087,00892088,00892089,00893010,00893011,00893012,00893013,00893014,00893015,00893016,00893017,00893018,00893019,00893020,00893021,00893022,00893023,00893024,00893027,00893572,00893573,00893574,00893575,00893576,00893578,00893579,00893580,00893581,00893582,00893583,00893584,00893585,00893586,00893587,00893588,00893589,00893590,00893591,00893571,00893592,00893593,00893594,00894988,00894989,00894990,00894992,00894993,00894994,00894995,00894996,00894997,00894999,00895000,00895001,00895002,00895927,00895929,00895930,00895931,00895932,00895933,00895934,00895935,00895936,00895937,00895938,00895939,00895940,00895941,00895942,00895914,00895915,00895916,00895917,00895919,00895920,00895921,00895922,00895923,00895924,00896142,00896143,00896144,00896145,00896146,00896147,00896148,00896149,00896150,00897288,00897287,00897289,00897290,00897291,00897292,00897293,00897294,00897295,00897296,00897297,00897452,00897633,00897634,00897635,00897636,00897637,00897638,00897639,00897640,00897641,00897642,00897643,00897644,00897645,00897646,00897647,00897648,00897649,00897650,00897651,00897652,00897653,00897654,00897655,00895834,00895835,00895836,00895837,00895838,00895839,00895840,00895841,00895842,00897004,00897005,00897006,00897007,00897008,00897009,00897010,00897011,00897012,00897013,00897014,00897015,00897016,00897017,00897019,00897020,00897021,00897022,00897023,00897024,00897025,00897027,00897028,00897029,00897030,00897031,00897032,00899717,00899719,00899720,00899721,00899722,00899723,00899724,00899725,00899726,00899727,00899728,00899729,00899731,00899732,00899733,00899734,00899735,00899736,00899737,00899738,00899739,00902167,00899741,00899743,00901034,00901035,00901036,00901037,00901038,00901039,00901040,00901041,00901042,00901043,00901044,00901045,00901047,00901048,00901049,00901050,00901051,00901052,00901053,00901055,00901057,00901058,00901059,00901060,00901061,00901062,00901063,00903183,00903184,00903185,00903186,00903187,00903188,00903189,00903190,00903191,00903192,00903193,00903194,00903195,00903196,00903198,00903199,00903200,00903201,00903202,00904227,00904228,00904229,00904230,00904231,00904232,00904233,00904234,00904235,00904236,00904237,00904238,00904239,00904240,00904241,00904242,00904243,00904244,00904245,00904246,00904247,00904248,00904249,00904250,00904251,00904252,00902945,00902946,00902947,00902948,00902949,00902950,00902951,00902952,00902953,00902955,00902956,00902957,00902958,00902959,00902960,00902961,00902962,00902963,00902964,00904586,00904587,00904589,00904590,00904591,00904592,00904593,00904595,00904597,00904598,00904599,00904600,00904601,00904602,00904606,00904607,00904609,00904610,00904613,00904614,00904615,00904616,00904617,00904618,00904385,00904387,00904388,00904390,00904391,00904392,00905080,00905079,00905081,00905082,00905083,00905084,00905085,00905086,00905087,00905088,00905290,00905291,00905292,00905293,00905294,00905296,00905297,00905298,00905299,00905300,00905301,00905283,00905284,00905285,00905286,00905287,00905288,00905289,00906318,00906317,00906319,00906321,00906322,00906323,00906324,00906325,00906326,00906327,00906328,00906329,00906330,00906331,00906332,00906333,00906334,00906335,00906749,00906750,00906752,00906753,00906754,00906755,00906756,00906757,00906758,00906759,00906760,00906761,00906763,00906764,00906765,00906766,00906767,00906768,00906769,00906770,00906771,00906772,00906773,00906774,00908051,00908052,00908053,00908054,00908055,00908056,00908057,00908058,00908059,00908060,00908061,00908062,00908063,00908064,00908065,00908066,00908067,00908273,00908274,00908275,00908276,00908277,00908278,00908279,00908280,00908281,00908282,00908283,00908284,00908285,00908287,00908288,00908289,00908290,00908291,00908292,00908293,00908294,00908295,00908296,00908297,00908298,00908299,00908705,00908707,00908708,00908709,00908710,00908711,00908712,00908713,00908714,00908715,00908716,00908717,00908718,00908719,00908720,00908721,00908729,00908731,00908732,00908733,00908734,00909832,00909833,00909834,00909835,00909836,00909837,00909838,00909839,00909840,00909841,00909842,00909843,00910574,00910575,00910576,00910577,00910581,00910578,00910579,00910580,00910582,00910583,00910584,00910585,00910586,00910587,00910588,00910589,00910749,00910348,00910349,00910351,00910352,00910353,00910355,00910361,00910362,00910363,00910364,00910366,00910368,00910369,00910370,00910371,00910372,00910373,00910976,00910979,00910980,00910981,00910983,00910984,00911030,00911031,00911032,00911033,00911034,00912812,00912813,00912814,00912815,00912816,00912818,00912819,00912820,00912821,00912822,00912823,00912824,00912825,00912826,00912827,00912828,00912829,00912830,00912831,00912833,00912834,00912835,00912836,00912547,00912548,00915246,00912549,00912550,00912551,00912552,00912553,00912554,00912555,00914834,00914835,00914836,00914837,00914838,00914839,00914840,00914841,00914842,00914843,00914844,00914845,00914847,00914848,00914849,00914850,00914851,00915865,00914852,00914853,00914854,00914855,00914856,00914857,00914858,00914859,00914860,00914861,00914862,00914152,00914153,00914154,00914155,00914156,00914157,00914158,00914159,00914160,00914162,00914163,00914143,00914144,00914145,00916579,00916577,00916576,00916580,00916581,00916582,00916583,00916584,00916585,00916586,00916587,00916588,00916589,00916590,00916591,00916592,00916593,00916594,00916596,00916597,00916598,00916599,00916600,00916602,00916603,00917025,00917026,00917027,00917028,00917029,00917030,00917031,00917032,00917033,00917034,00917035,00917036,00917037,00917038,00917039,00917040,00917041,00917042,00917043,00917044,00917045,00917046,00917047,00917048,00917049,00917050,00917051,00917381,00917382,00917384,00917385,00917386,00917387,00917388,00917389,00917390,00917391,00917392,00917393,00917394,00917395,00917396,00917397,00917398,00917399,00917400,00917402,00917403,00917404,00917405,00917406,00917408,00917409,00918279,00918280,00918281,00918283,00918285,00918286,00918287,00918288,00918289,00918290,00918291,00918292,00918293,00918294,00918295,00918296,00918297,00918298,00918299,00919788,00919789,00919790,00920111,00920112,00919823,00919824,00919825,00919826,00919827,00919828,00919829,00919831,00919832,00919833,00919835,00919836,00919939,00919940,00919941,00919942,00919943,00919944,00919945,00919946,00919947,00919948,00919949,00919950,00921026,00921027,00921028,00921029,00921004,00921006,00921007,00921008,00921009,00921011,00921012,00921013,00921005,00921015,00921016,00921017,00921018,00921019,00921020,00921021,00921023,00921014,00921022,00921024,00921030,00921031,00921654,00921656,00921657,00921658,00921659,00921660,00921661,00921662,00921663,00921664,00921665,00921667,00921666,00921668,00921669,00921670,00921671,00921672,00921673,00921674,00921675,00921676,00921677,00921678,00924099,00924101,00924102,00924103,00924104,00924105,00924106,00924107,00924108,00924109,00924110,00924111,00924112,00924113,00924114,00924115,00924116,00924117,00924118,00924119,00924120,00924121,00924122,00924123,00924124,00924125,00924126,00924127,00924939,00924940,00924941,00924942,00924943,00924944,00924946,00924947,00924948,00924949,00924950,00924951,00924952,00924953,00924956,00924957,00924958,00924959,00924960,00924961,00924962,00924963,00924964,00926484,00926486,00926487,00926488,00926489,00926490,00926491,00926492,00926493,00926494,00926495,00926496,00926497,00926498,00926499,00926500,00926501,00926502,00926503,00926504,00926505,00926754,00926755,00926756,00924445,00924446,00924447,00924448,00928118,00928117,00928120,00928121,00928122,00928123,00928124,00928125,00928126,00928127,00928128,00928129,00928130,00928131,00928132,00928133,00928134,00928135,00928136,00928137,00928138,00928139,00928141,00928142,00928143,00928144,00928145,00928146,00928147,00928963,00928964,00928965,00928966,00928967,00928968,00928969,00928970,00928971,00928972,00928973,00928974,00928975,00928551,00928552,00928553,00928554,00928555,00928556,00928557,00928558,00928559,00928560,00928561,00928573,00928564,00928565,00928566,00928567,00928568,00928569,00928570,00928571,00928572,00928574,00928575,00928576,00928562,00929997,00929998,00929999,00930000,00930001,00930700,00930701,00930702,00930703,00930705,00930706,00930707,00930708,00930709,00930710,00930711,00932117,00932118,00932119,00932120,00932122,00932123,00932124,00932125,00932126,00932127,00932128,00932129,00932130,00932131,00932132,00932133,00932134,00932142,00932136,00932137,00932138,00932139,00932140,00932141,00931533,00931534,00931535,00931536,00931537,00931538,00931539,00931540,00931541,00931542,00931543,00931544,00931545,00931546,00931547,00931548,00931549,00931550,00931551,00931552,00931553,00931554,00931555,00931556,00932988,00932990,00932992,00932993,00932994,00932995,00932996,00932997,00932998,00932999,00933000,00933001,00933002,00933906,00933003,00933004,00933005,00933006,00933007,00933009,00933010,00933013,00933014,00934176,00934177,00933015,00933952,00933953,00933954,00933955,00933956,00933957,00933958,00933959,00933960,00933961,00933962,00933963,00933964,00933965,00933966,00933967,00933968,00933969,00933970,00933971,00933972,00933973,00933974,00933975,00933976,00933977,00933979,00933980,00933981,00934242,00934243,00934244,00934245,00934246,00934247,00934481,00934483,00934846,00934847,00934848,00934849,00934850,00934851,00934852,00934853,00934854,00934855,00934856,00934857,00934859,00934860,00934861,00934746,00934747,00934748,00934749,00934750,00934753,00934754,00934755,00934756,00935045,00935046,00935047,00935048,00935049,00935050,00935051,00935053,00935054,00935055,00935056,00935057,00935058,00935059,00935060,00935061,00935062,00935063,00935064,00935065,00935066,00935067,00935068,00935069,00935070,00935071,00935072,00935073,00935074,00935075,00935076,00935077,00935613,00935614,00935615,00935619,00935620,00935621,00935623,00935911,00935624,00935625,00935626,00935627,00935628,00936061,00936062,00935629,00935630,00935631,00935632,00935918,00935919,00935920,00935921,00935633,00935634,00935635,00935636,00936063,00936064,00936065,00935637,00935638,00936225,00936227,00936228,00936229,00936230,00936231,00936232,00936233,00936234,00936235,00936236,00936237,00936341,00936342,00936343,00936344,00936345,00936346,00936348,00936349,00936350,00936351,00936352,00936353,00936354,00936355,00936360,00936361,00936362,00936363,00936364,00936365,00936366,00936367,00936368,00936369,00936370,00936371,00936372,00936373,00936374,00936375,00936376,00936377,00937366,00937367,00937368,00937369,00937370,00937371,00937372,00937374,00937375,00937376,00937805,00937806,00937808,00937809,00937810,00937811,00937812,00937813,00937814,00937815,00937816,00937817,00937818,00937819,00937820,00937821,00937822,00937823,00938002,00938003,00938004,00938733,00938736,00938737,00938738,00938743,00938744,00938745,00938746,00938747,00938748,00938749,00938750,00938751,00938752,00938753,00938754,00938755,00938756,00938757,00938758,00938760,00938761,00938762,00939324,00939325,00939326,00939327,00939328,00939329,00939330,00939331,00939874,00939875,00939876,00939877,00939878,00939879,00939880,00939881,00939882,00939883,00939884,00939885,00940307,00939888,00939886,00939887,00939889,00939890,00939891,00939892,00939893,00939894,00939857,00939862,00939863,00939864,00939865,00939866,00939867,00939868,00939869,00939870,00939871,00939873,00939858,00939859,00940344,00940345,00940346,00940347,00940348,00940349,00940350,00940351,00940352,00940353,00940354,00940355,00940356,00940357,00940358,00940359,00940360,00940361,00940362,00940363,00940364,00940365,00940366,00940367,00940368,00940369,00940371,00940372,00940861,00940862,00940863,00940864,00940865,00940866,00940867,00940868,00940869,00940870,00940871,00940872,00941559,00941560,00941563,00941564,00941565,00941566,00941567,00941568,00941569,00941570,00941571,00941572,00941573,00941575,00941576,00941577,00941579,00941580,00941578,00941556,00941557,00941558,00941947,00941948,00941949,00941950,00941951,00941952,00941953,00941954,00941955,00941956,00941957,00941958,00941959,00941960,00941937,00941938,00941939,00941940,00941941,00942437,00942436,00942438,00942444,00942445,00942446,00942447,00942448,00942449,00942175,00942176,00942177,00942178,00942179,00942180,00942181,00942182,00942183,00942184,00942185,00942186,00942187,00942188,00942189,00942190,00942191,00942192,00942193,00942194,00942195,00942196,00942197,00942198,00942200,00942201,00942203,00942204,00942713,00942714,00942715,00942716,00942717,00942205,00942206,00942207,00942208,00943082,00943083,00943084,00943085,00943086,00943087,00943088,00943089,00943090,00943091,00943092,00943093,00943094,00943095,00943096,00943098,00943328,00943329,00943330,00943331,00943332,00943333,00943334,00943335,00943315,00943307,00943308,00943309,00943310,00943311,00943313,00943314,00943316,00943317,00943318,00943319,00943320,00943321,00943322,00943323,00943324,00943325,00943326,00943327,00943586,00943587,00943862,00943863,00943864,00943865,00943866,00943867,00943868,00943869,00943870,00943871,00943872,00943873,00943878,00944894,00944895,00944896,00944892,00944893,00943879,00943880,00943881,00944695,00944696,00944698,00944699,00944700,00944701,00944702,00944703,00944704,00944705,00944706,00944707,00944708,00944709,00944710,00944711,00944712,00944717,00944718,00944719,00944720,00945225,00945226,00945228,00945229,00945230,00945231,00945232,00945233,00945234,00945235,00945236,00945237,00945238,00946905,00946910,00946911,00946912,00946913,00946914,00946915,00946916,00946917,00945952,00945953,00945954,00945955,00945956,00945957,00945958,00945969,00945970,00945971,00945972,00945973,00945974,00945975,00945976,00945977,00945978,00945979,00945980,00945959,00945960,00945961,00945962,00945963,00945964,00945967,00945966,00946778,00946779,00946781,00946785,00946787,00946788,00946789,00946531,00946532,00946533,00946534,00946535,00946536,00946537,00946538,00946539,00946540,00946541,00946542,00946543,00946544,00946545,00946546,00946547,00946548,00946549,00946550,00946551,00946197,00946198,00946199,00946200,00946201,00946202,00946203,00946204,00946205,00946206,00946207,00946208,00946209,00946210,00946211,00946212,00946213,00946214,00946215,00946216,00946217,00946218,00946219,00946220,00946221,00946222,00946224,00946225,00946226,00947601,00947600,00947602,00947603,00947604,00947605,00947606,00947607,00947608,00947609,00947610,00947611,00949349,00949348,00949350,00949351,00949352,00949353,00949354,00949355,00949356,00949357,00949358,00949359,00949363,00949364,00948511,00948512,00948513,00948514,00948515,00948516,00948517,00948518,00948519,00948520,00948521,00948522,00948523,00948524,00948525,00948526,00948527,00948528,00948529,00948530,00948787,00948788,00948789,00948790,00948791,00948792,00948793,00948794,00948795,00948797,00948798,00948799,00948800,00948801,00948802,00948803,00948804,00948805,00948806,00948807,00948808,00948809,00948810,00948811,00948812,00948818,00948819,00948993,00948994,00948995,00948996,00948997,00948998,00948999,00949001,00949002,00949003,00949004,00949005,00949006,00949014,00949015,00949016,00949017,00949018,00949019,00949020,00949616,00949617,00949618,00949619,00949620,00949621,00949622,00949623,00949624,00949625,00949626,00949627,00949628,00949629,00949630,00949631,00949632,00949634,00949635,00949636,00949637,00949638,00949639,00949640,00949641,00949642,00949643,00949644,00949645,00950521,00950522,00950523,00950524,00950837,00950838,00950840,00950841,00950876,00950877,00950878,00950879,00950880,00950882,00950883,00950884,00950031,00950033,00950034,00950035,00950036,00950037,00950038,00950039,00950040,00950041,00950042,00950043,00950044,00950045,00950046,00950047,00950048,00950049,00950051,00950052,00950053,00950054,00950055,00950056,00951733,00951734,00951735,00951736,00951737,00951738,00951739,00951740,00951741,00951742,00951743,00951744,00951745,00951746,00951747,00951748,00951749,00951750,00951751,00951752,00951754,00951755,00951756,00951757,00951758,00951759,00951760,00951972,00951973,00951974,00951975,00951976,00951977,00951978,00951979,00951980,00951981,00951982,00951983,00951984,00951985,00953125,00953126,00953124,00953127,00953128,00953130,00953131,00953132,00953133,00953134,00953135,00953136,00953137,00953139,00952875,00952876,00952877,00952878,00952879,00952880,00952881,00952883,00952884,00952885,00952886,00952887,00952888,00952889,00952890,00952891,00952892,00952893,00952894,00952895,00952896,00952897,00952898,00953634,00953635,00953636,00953637,00953638,00953639,00953640,00953641,00953642,00953643,00953644,00953646,00953647,00953648,00953649,00953650,00953651,00953652,00953653,00953654,00953655,00953656,00953657,00953658,00953659,00953660,00953661,00953667,00953668,00953669,00953670,00953671,00953672,00953673,00953674,00953676,00953677,00953678,00953679,00953680,00953681,00955197,00955198,00955199,00955200,00955201,00955202,00955203,00955204,00955205,00955206,00955207,00955208,00955209,00955210,00955211,00956152,00956153,00956154,00956155,00956156,00956157,00956158,00956159,00956160,00956161,00956162,00956163,00956164,00956165,00956166,00956167,00956168,00956169,00956170,00956171,00956172,00956173,00956174,00956176,00956177,00956178,00956179,00956148,00956149,00956879,00956880,00956882,00956885,00956886,00956887,00956888,00956889,00956890,00956891,00956892,00956893,00956894,00956895,00956896,00956897,00956898,00956899,00956900,00956901,00956902,00958164,00958163,00958165,00958166,00958167,00958168,00958169,00958170,00958171,00958172,00958173,00958174,00958162,00954853,00954854,00954855,00954856,00954883,00954884,00954886,00954721,00954722,00954723,00954724,00954725,00954726,00954727,00954728,00954729,00954730,00954731,00954732,00954733,00954734,00954736,00954737,00954738,00954739,00954740,00954741,00959413,00957385,00957386,00957387,00954946,00954945,00954947,00959127,00959128,00959129,00959130,00959131,00959132,00959133,00959134,00959135,00959136,00959137,00960127,00960128,00960129,00960130,00960131,00960132,00960133,00960134,00960135,00960136,00960137,00960138,00960139,00960140,00960141,00960142,00960143,00960144,00960145,00960146,00960147,00960148,00961002,00961003,00961006,00961007,00961008,00961009,00961010,00961011,00961012,00961013,00961014,00961015,00961016,00961017,00961018,00961019,00961020,00961021,00961022,00961023,00961024,00961025,00961026,00961027,00961028,00961029,00961030,00961731,00961733,00961994,00961995,00961996,00961997,00961998,00961999,00962000,00962001,00962002,00962003,00962004,00962005,00962006,00962007,00962008,00962009,00962010,00962011,00962012,00962013,00962014,00962015,00962016,00962017,00962018,00962019,00962020,00962022,00960735,00960736,00960737,00960738,00962346,00962347,00962345,00962348,00962349,00962350,00962351,00962352,00962353,00962354,00962355,00962356,00962357,00962358,00962359,00962360,00962370,00962361,00962362,00962363,00962364,00962365,00962366,00962367,00962368,00962369,00957430,00957431,00957432,00957433,00957434,00957435,00957436,00957437,00957438,00957439,00957440,00957441,00957442,00957443,00957445,00957446,00957447,00957448,00957449,00957450,00957451,00957452,00957453,00957454,00957455,00957456,00957457,00957458,00957459,00957460,00962901,00962900,00962886,00962913,00962914,00962915,00962904,00962912,00962916,00962889,00962890,00962891,00962892,00962893,00962894,00962895,00962896,00962897,00962898,00963850,00963851,00963852,00963853,00963854,00963855,00965048,00965047,00965049,00965050,00965051,00965052,00965053,00965054,00965055,00965213,00965214,00965215,00965216,00965217,00965218,00965220,00965221,00965222,00965421,00965420,00965422,00965423,00965424,00965425,00965426,00965427,00965428,00965429,00965430,00965431,00965432,00964817,00964818,00964819,00964820,00964821,00964822,00964824,00964825,00964826,00964827,00964828,00964829,00964830,00964831,00964832,00964834,00964835,00964836,00964837,00964838,00964839,00964840,00964841,00964842,00964843,00964844,00964845,00966971,00966972,00966973,00966974,00966975,00966529,00966530,00966531,00966532,00966533,00966534,00966535,00966536,00966537,00966538,00966539,00966540,00966541,00966542,00966543,00966545,00966546,00966547,00966548,00966549,00966550,00966551,00968046,00968047,00968049,00968050,00968051,00968052,00968053,00968054,00968055,00968056,00968057,00968058,00968059,00968060,00968061,00968062,00968063,00968064,00968065,00968066,00968068,00968069,00968070,00968071,00968072,00968073,00968074,00968800,00968801,00969089,00969090,00969091,00969092,00969093,00969094,00969095,00969096,00969097,00969098,00969099,00969100,00969101,00969102,00969103,00969104,00969105,00969108,00969107,00969109,00969110,00969111,00969112,00969113,00969114,00968536,00968537,00968538,00968539,00968540,00968541,00968542,00968543,00968544,00968545,00968546,00968547,00968548,00968549,00968550,00968551,00968552,00968553,00968554,00968555,00968557,00968558,00968559,00968560,00968561,00970645,00970646,00970647,00970648,00970649,00970650,00970651,00970631,00970632,00970633,00970634,00970635,00970636,00970637,00970638,00970639,00970640,00970641,00970642,00970643,00971428,00971429,00971430,00971431,00971432,00971433,00971434,00971435,00971436,00971437,00971438,00971439,00971440,00971441,00971442,00971443,00971444,00971446,00971447,00971448,00971449,00971450,00971451,00972945,00974362,00974363,00974365,00974366,00974344,00974345,00974346,00974347,00974348,00974349,00974350,00974351,00974352,00974353,00974354,00974355,00974356,00974357,00974359,00974361,00974360,00974339,00974340,00974341,00975320,00974342,00974343,00974886,00974887,00974888,00974889,00974890,00974891,00974892,00974893,00974894,00974901,00975911,00974902,00974903,00974904,00974905,00974906,00974907,00974908,00974909,00974910,00974912,00974913,00974914,00974915,00974895,00974896,00974897,00974898,00974899,00974900,00976562,00976563,00976564,00976565,00976566,00976567,00976568,00976569,00976570,00976571,00976572,00976573,00976574,00976575,00976576,00976577,00976578,00976579,00976580,00976581,00976583,00976584,00976585,00976586,00976587,00976588,00976589,00976590,00976812,00976813,00976814,00976815,00976816,00976817,00976785,00976786,00976787,00976788,00976789,00976790,00976791,00976792,00976793,00976794,00976795,00976796,00976797,00976799,00976800,00976801,00976802,00976803,00976810,00976809,00976808,00976804,00976805,00976806,00976807,00977602,00977601,00977603,00977604,00977605,00977606,00977607,00977608,00977609,00977610,00977611,00977612,00977613,00977614,00977615,00977616,00977617,00977618,00977619,00977620,00977621,00977622,00977623,00977624,00977626,00977627,00978701,00978702,00978704,00978705,00978706,00978707,00978708,00978709,00978710,00978711,00978712,00978713,00978714,00978715,00978716,00978717,00978718,00978719,00978720,00978721,00978722,00978338,00978339,00978340,00978341,00978342,00978343,00978344,00978345,00978346,00978347,00978348,00978350,00978351,00978352,00978353,00978354,00978355,00978356,00978357,00978358,00978359,00978360,00978361,00980020,00980021,00980022,00980023,00980024,00980025,00980026,00980027,00980030,00980031,00980032,00980033,00980034,00980035,00980036,00980037,00980038,00980039,00980040,00980041,00980043,00980409,00980410,00980411,00980412,00980413,00981380,00981379,00981381,00981382,00981383,00981384,00981385,00981386,00981387,00981388,00981389,00981390,00981391,00981392,00981393,00981394,00981395,00981396,00981398,00981399,00981400,00981401,00981402,00981403,00982048,00982051,00982052,00982053,00982054,00982055,00982056,00982057,00982058,00982059,00982060,00982061,00982062,00982063,00982064,00982065,00982066,00982067,00983054,00982068,00982069,00982070,00982072,00982073,00982074,00982075,00982076,00982077,00982294,00982293,00982292,00982295,00982296,00982297,00982298,00982299,00982300,00982301,00982302,00982303,00982304,00982305,00982306,00982307,00982308,00982309,00982310,00982311,00982312,00982313,00982314,00982316,00982317,00982318,00982540,00982541,00982542,00982543,00982544,00982545,00982546,00982547,00982548,00982549,00982550,00982551,00982552,00982553,00982554,00982555,00982556,00982557,00982558,00982559,00982560,00982561,00982562,00982563,00982564,00982565,00982566,00982567,00982568,00982569,00982573,00982749,00982750,00982751,00982753,00982754,00982755,00982756,00982757,00982758,00982759,00982760,00982761,00982762,00982763,00982764,00982765,00982766,00982767,00982768,00982769,00982770,00982771,00982772,00982773,00982775,00983876,00982776,00982777,00982778,00983361,00983362,00983363,00983364,00983365,00983366,00983367,00983368,00983369,00983370,00983371,00983372,00983373,00983374,00983375,00983376,00983377,00983378,00984442,00984443,00984444,00984445,00984446,00984447,00984448,00984449,00984450,00984451,00984452,00984454,00984455,00984456,00984457,00984458,00984911,00984912,00984913,00984914,00984915,00984916,00984917,00984918,00984919,00984920,00984921,00984922,00984923,00984924,00984925,00984926,00984927,00984928,00984929,00984930,00984931,00984933,00984934,00984935,00984936,00985313,00985315,00985314,00985316,00985317,00985318,00985319,00985320,00985321,00985322,00985323,00985324,00985325,00985328,00985329,00985330,00985331,00985332,00985333,00985334,00985335,00985336,00985337,00985338,00985339,00985340,00985781,00985783,00985780,00985784,00985785,00985786,00985787,00986025,00985341,00985342,00985343,00985344,00985345,00985346,00986731,00986732,00986733,00986734,00986735,00986736,00986737,00986738,00986739,00986740,00986741,00986743,00986744,00986745,00987052,00987053,00987054,00987055,00987056,00987057,00987058,00987059,00987060,00987061,00987062,00987063,00987064,00987065,00987066,00987067,00987068,00987069,00987070,00987071,00987072,00987073,00987091,00987668,00987669,00987670,00987671,00987672,00987673,00987675,00987676,00987677,00987678,00987679,00987680,00987681,00987682,00987683,00987684,00987685,00987686,00987687,00987688,00987689,00987690,00987691,00987692,00987693,00987694,00987695,00987696,00987697,00987698,00987699,00987924,00987925,00987926,00987927,00987929,00987930,00987931,00987932,00987933,00987934,00987935,00987936,00987937,00987938,00987939,00987940,00987941,00987942,00987943,00987944,00987945,00987946,00987947,00987948,00987949,00987950,00988927,00988928,00988930,00988931,00988932,00988933,00988934,00988937,00988938,00988939,00988940,00988941,00988942,00988943,00989881,00989882,00989883,00989884,00989885,00989886,00989887,00989888,00989889,00989890,00989892,00989895,00989896,00989898,00989899,00989900,00989901,00989902,00989903,00989904,00992143,00992144,00992145,00992147,00992148,00992149,00992150,00992152,00992153,00992154,00992155,00992156,00992157,00992159,00992160,00992161,00992163,00992165,00992164,00992166,00992595,00992596,00992598,00992599,00992600,00992602,00992604,00992605,00992606,00992608,00993875,00993876,00993877,00992609,00992610,00992611,00992630,00992631,00992632,00992597,00992613,00994117,00994118,00994119,00994120,00994121,00994122,00994123,00994124,00994136,00994137,00994138,00994139,00994140,00994141,00994142,00994143,00994125,00994126,00996329,00996330,00996331,00994127,00994128,00994129,00994130,00994131,00994132,00994134,00994135,00996334,00996337,00996338,00996339,00996340,00996341,00996342,00996343,00996344,00996345,00996346,00996347,00996318,00996314,00996315,00996316,00996317,00996319,00996320,00996321,00996322,00996323,00996324,00996325,00996326,00996327,00996328,00996332,00996333,00997447,00997448,00997449,00997450,00997451,00997452,00997453,00997454,00997455,00997456,00997457,00997458,00997459,00997460,00997461,00997462,00997464,00998420,00998421,00998422,00998423,00998424,00998425,00998426,00998427,00998428,00998429,00998430,00998161,00998162,00998163,00998164,00998165,00998166,00998168,00998170,00998171,00998172,00998173,00998174,00998175,00998176,00998177,00998178,00998179,00998180,00998181,00998182,00998183,00998184,00998185,00998186,00998187,00998188,00998189,00998190,00998191,00998192,00998193,00998195,00998196,00998941,00998942,00998943,00998944,00998945,00998946,00998947,00998948,00998949,00998950,00998951,00998952,00998953,00998954,00998955,00998956,00998957,00998958,00998959,00998960,00998961,00998962,00998963,00998964,00998965,00998966,00998967,00998968,00999614,00999615,00999616,00998970,00998971,01000049,01000050,01000052,01000053,01000056,01000057,01000058,01000059,01000060,01000061,01000062,01000063,01000064,01000065,01000066,01000067,01000068,01000069,01000070,01000072,01000443,01000444,01000445,01000446,01000447,01000448,01000449,01000450,01000451,01000452,01000453,01000454,01000455,01000456,01000458,01000459,01000461,01000462,01000463,01000464,01000465,01000466,01000467,01000468,01000469,01001641,01001644,01001652,01001653,01001654,01001319,01001320,01001321,01001322,01001323,01001324,01001325,01001326,01001327,01001328,01001329,01001330,01001331,01001332,01001333,01001334,01001335,01001336,01001337,01001338,01001339,01001340,01001341,01001343,01001344,01001345,01001346,01001347,01001819,01001820,01001821,01001822,01001823,01001824,01001825,01001826,01001827,01001828,01001829,01001830,01001831,01001832,01001833,01001834,01001835,01001836,01001837,01001838,01002361,01002362,01002364,01002365,01002366,01002110,01002112,01002113,01002114,01002115,01002116,01002117,01002118,01002119,01002120,01002121,01002122,01002123,01002124,01002125,01002126,01002127,01002128,01002129,01002131,01002132,01002133,01002134,01002135,01002136,01002137,01002661,01002662,01002663,01002664,01002665,01002666,01002667,01002668,01003492,01003493,01003494,01003495,01003496,01003497,01003498,01003499,01003500,01003501,01003503,01003504,01003505,01003506,01003508,01003509,01003693,01003695,01003696,01003697,01003698,01003699,01003700,01003701,01003702,01003703,01003706,01003707,01003708,01003709,01003710,01003711,01003712,01003713,01003714,01003715,01003716,01003717,01003718,01003719,01004666,01003720,01003721,01003722,01004229,01004231,01004230,01004232,01004233,01004234,01004235,01004236,01004237,01004238,01004239,01004240,01004241,01004242,01004244,01004247,01004248,01004249,01004250,01004251,01004252,01004253,01004254,01004255,01004256,01004257,01004258,01004259,01004886,01004887,01004888,01004889,01004890,01004891,01005231,01005232,01005233,01005234,01005235,01005236,01005237,01005238,01005239,01005240,01005241,01005242,01005243,01005245,01005246,01005247,01005248,01005249,01005250,01005251,01005252,01005253,01005254,01005255,01005256,01005257,01005258,01005259,01005261,01005262,01005263,01005822,01005823,01005824,01005825,01005826,01005875,01005876,01005877,01005878,01005879,01005880,01005881,01005882,01005883,01005884,01005885,01005886,01005890,01005891,01005892,01005893,01005894,01005895,01005896,01005897,01005898,01005899,01005900,01005901,01005902,01005903,01005904,01006735,01006737,01006738,01006739,01006740,01006741,01006742,01006743,01006744,01006746,01006747,01006748,01006749,01006750,01006751,01006752,01006753,01006754,01006755,01006756,01006757,01006758,01006759,01006760,01007162,01007163,01007164,01007165,01007463,01007464,01007465,01007466,01007467,01007468,01007470,01007471,01007472,01007473,01007474,01007476,01007477,01007478,01007479,01007480,01007481,01007482,01007483,01007484,01007485,01007486,01007487,01007488,01007489,01007974,01007975,01007976,01007977,01007978,01007695,01007696,01007697,01007698,01007699,01007700,01007701,01007702,01007704,01007705,01007706,01007707,01007708,01007709,01007710,01007711,01007712,01007713,01007714,01007715,01007716,01007717,01007718,01007719,01007720,01007721,01007722,01007723,01007724,01007725,01007726,01007727,01007728,01008681,01008682,01008683,01008684,01008685,01008686,01008687,01008688,01008689,01008691,01008692,01008693,01008694,01008695,01008696,01008697,01008698,01008699,01008700,01008701,01008702,01008703,01008705,01008704,01008706,01008707,01008708,01008709,01008710,01008711,01010066,01010068,01010069,01010070,01010071,01010072,01010074,01010075,01010076,01010077,01010078,01010079,01010080,01010081,01010083,01010084,01010085,01009628,01009629,01009630,01009631,01009632,01009633,01009634,01009635,01009636,01009637,01009638,01009639,01009640,01009641,01009642,01009643,01009644,01009645,01011079,01011078,01011080,01011081,01011082,01011083,01011084,01011085,01011086,01011087,01011088,01011089,01011090,01011091,01011092,01011196,01011197,01011198,01011199,01011200,01011201,01011202,01011203,01011204,01011206,01011207,01011208,01012257,01012259,01012260,01012261,01012262,01012263,01012264,01012265,01012266,01012267,01012268,01012269,01012270,01012271,01012272,01012273,01012274,01012275,01012276,01012277,01012278,01012279,01012280,01012281,01012282,01014529,01014530,01014531,01014532,01014533,01014534,01014536,01014537,01014939,01014940,01014941,01014942,01014943,01014938,01014944,01014945,01014946,01014947,01014948,01014949,01014950,01014951,01014952,01014953,01014954,01015377,01015378,01015379,01015380,01015381,01015382,01015383,01015384,01015385,01015386,01015387,01015388,01015389,01015390,01015391,01016186,01016187,01016878,01016879,01016877,01016880,01016881,01016882,01016883,01016884,01016885,01016886,01016887,01016888,01016889,01016890,01016891,01016892,01016893,01016894,01016895,01016897,01016898,01016899,01016900,01016901,01016902,01016903,01016421,01016424,01016425,01016426,01016427,01016428,01016429,01016430,01016431,01016432,01016433,01016434,01016435,01016436,01016437,01016438,01016439,01016440,01016441,01016442,01016443,01016444,01016445,01016446,01016447,01016448,01016449,01016450,01016451,01017236,01017237,01017238,01017234,01017235,01017239,01016649,01016651,01016652,01016653,01016654,01016655,01016656,01016657,01016658,01016627,01016628,01016629,01016630,01016631,01016632,01016633,01016634,01016635,01016636,01016637,01016638,01016639,01016640,01016641,01016642,01016643,01016644,01016645,01016647,01017349,01017350,01017351,01017352,01017353,01017354,01017355,01017356,01017357,01017358,01017359,01018322,01018321,01018323,01018325,01018326,01018328,01018329,01018330,01018331,01018332,01018333,01018334,01018335,01018336,01018337,01018338,01018340,01018341,01018342,01018343,01018344,01018345,01018346,01018347,01018348,01018349,01018350,01019116,01019117,01019118,01019119,01019120,01019121,01019122,01019123,01019124,01019125,01019126,01019127,01019128,01019129,01019130,01019131,01019132,01019133,01019135,01019136,01019137,01019138,01019139,01019140,01019141,01019612,01019611,01019613,01019614,01019615,01019616,01019617,01019618,01019619,01019620,01019622,01019623,01019624,01019625,01019626,01019627,01019628,01019629,01019630,01019631,01019632,01020038,01019634,01019822,01019823,01019824,01019826,01019827,01019828,01019829,01019830,01019831,01019832,01019833,01019834,01019835,01019836,01019837,01019838,01019840,01019843,01019844,01019845,01019846,01019847,01019848,01019849,01019850,01020712,01020713,01020714,01020715,01020244,01020245,01020246,01020247,01020248,01020249,01020250,01020251,01020252,01020253,01020254,01020255,01020256,01020257,01020258,01020259,01020260,01020261,01020262,01020263,01020265,01020269,01020270,01020271,01020272,01020273,01020274,01020275,01020276,01020277,01020278,01020858,01020859,01020860,01020862,01020820,01020821,01020822,01020823,01020824,01020825,01020826,01020827,01020828,01020829,01020830,01020831,01020832,01020833,01020834,01020835,01020836,01020837,01020838,01020840,01020841,01020842,01020843,01020844,01020845,01020466,01020467,01020468,01020470,01020471,01020472,01020473,01020474,01020475,01020476,01020477,01020478,01020479,01020480,01020481,01020482,01020483,01020484,01020485,01022027,01022028,01022029,01022030,01022098,01022099,01022100,01022101,01022102,01022103,01022104,01022105,01022106,01022107,01022108,01022109,01022110,01022111,01022112,01022113,01022114,01022115,01022116,01022117,01022265,01022266,01022267,01022268,01022269,01021303,01021304,01021305,01021306,01021307,01021308,01021309,01021310,01021311,01021312,01021313,01021314,01021316,01021318,01021319,01021320,01021322,01021323,01021324,01021325,01021326,01021327,01023113,01023114,01023115,01023120,01023121,01023122,01023123,01022857,01022856,01022859,01022860,01022861,01022862,01022863,01022864,01022865,01022866,01022867,01022868,01022869,01022870,01022871,01022872,01022873,01022874,01022875,01022876,01022877,01022878,01024170,01024184,01024180,01024174,01024176,01024177,01024178,01024179,01024171,01024172,01024173,01024154,01024155,01024156,01024157,01024158,01024159,01024160,01024161,01024162,01024163,01024164,01024165,01024166,01024167,01024168,01024169,01023486,01023487,01023488,01023489,01023490,01023493,01023494,01023495,01024434,01024435,01024409,01024410,01024411,01024412,01025107,01025108,01025109,01025110,01025111,01025112,01025113,01025114,01025116,01025117,01025119,01025122,01025123,01025124,01025125,01025126,01025127,01025128,01025332,01025129,01025130,01025131,01025132,01025133,01024725,01024726,01024727,01024728,01024729,01024730,01024731,01024732,01024733,01024734,01024736,01024737,01024738,01024739,01024741,01024742,01024744,01025335,01025337,01025338,01025339,01025340,01025341,01025342,01025343,01025344,01025345,01025346,01025347,01025348,01025349,01026279,01026280,01026281,01026282,01025350,01025351,01025352,01034134,01034135,01034136,01034137,01034132,01034133,01034751,01034752,01034753,01034754,01034755,01034756,01034757,01034758,01034759,01034760,01034761,01034665,01034667,01034668,01034669,01034670,01034671,01034672,01034673,01034674,01030324,01030325,01030327,01030328,01030270,01030271,01030272,01030273,01030274,01030275,01030276,01036792,01036793,01036544,01036545,01036546,01036547,01036548,01036549,01036550,01036551,01036552,01036553,01036554,01036555,01036556,01036557,01036558,01036559,01036560,01037088,01037089,01037090,01037091,01037092,01037093,01037094,01037095,01037097,01037098,01037099,01037100,01037101,01037103,01037104,01037105,01037106,01037107,01037108,01037109,01037110,01037111,01037112,01037113,01037102,01037114,01037845,01037846,01037847,01037848,01037849,01037850,01037851,01037853,01037854,01037858,01037859,01037860,01037861,01037862,01037863,01037864,01037865,01037866,01037837,01037838,01037839,01037840,01037841,01037842,01037843,01037844,01037857,01038400,01038401,01038403,01038404,01038405,01038406,01038407,01038409,01038410,01038411,01038412,01038414,01038415,01038416,01038417,01038418,01038419,01038420,01038421,01038422,01038423,01038424,01038425,01038427,01038428,01038679,01038682,01038683,01038684,01038685,01038686,01038688,01038689,01038690,01038691,01038692,01038693,01038695,01038696,01038697,01038699,01038700,01038701,01038702,01038703,01038704,01038705,01038706,01039422,01039424,01039425,01039426,01039429,01039427,01039430,01039431,01039432,01039433,01039434,01039435,01039436,01039437,01039438,01039439,01039440,01039441,01039442,01039443,01040688,01040689,01040690,01040691,01040692,01040693,01040694,01040695,01040696,01040698,01040699,01040700,01040701,01040702,01040703,01040704,01040705,01040706,01040708,01040709,01040710,01040711,01040712,01040714,01041207,01041208,01041209,01041210,01041211,01041212,01041213,01042144,01042143,01042146,01042147,01042148,01042150,01042151,01042152,01042153,01042154,01042155,01042159,01042160,01042156,01042157,01042158,01042170,01042161,01042162,01042163,01042164,01042165,01042166,01042167,01042168,01042885,01042886,01042889,01042890,01042891,01042892,01042893,01042894,01042895,01042896,01042897,01042898,01042899,01042900,01042901,01042902,01042903,01042904,01042905,01042906,01042907,01042908,01042909,01042910,01042390,01042392,01042393,01042395,01042396,01042397,01042398,01042399,01042400,01042401,01042402,01042403,01042404,01042405,01042671,01042672,01042673,01042674,01042675,01042676,01042677,01042678,01042679,01042680,01042681,01042682,01042684,01042686,01042687,01042688,01042689,01042690,01042691,01042692,01042693,01042694,01042695,01042696,01043677,01043678,01043679,01043682,01043683,01043684,01043685,01043686,01043687,01043688,01043689,01043690,01043691,01043692,01043693,01043694,01043695,01043697,01043698,01044469,01043699,01043700,01043701,01043702,01043703,01043704,01043705,01043706,01043965,01043966,01043967,01043968,01043969,01043970,01043971,01043972,01043954,01043955,01043956,01043957,01043958,01043959,01043960,01043961,01043962,01043963,01043964,01043973,01043974,01043978,01043979,01043980,01043981,01043983,01043984,01043985,01043986,01043987,01043988,01043989,01043990,01043991,01043992,01043975,01044833,01043976,01043977,01044474,01044475,01044476,01044477,01044478,01044479,01044480,01044481,01044482,01044483,01044484,01044485,01044486,01044487,01044488,01044489,01044490,01044491,01044492,01044493,01044494,01044495,01044497,01044498,01044499,01044500,01044501,01044502,01044503,01044505,01045260,01044506,01045264,01045265,01045266,01045267,01045268,01045269,01045270,01045271,01045272,01045273,01045274,01045275,01045276,01045277,01045278,01045279,01045280,01045281,01045282,01045285,01045286,01045287,01045290,01045291,01045292,01045293,01045294,01045556,01045557,01045558,01045559,01045560,01045561,01045562,01045563,01045564,01045565,01045566,01045567,01045568,01045569,01045570,01045571,01045572,01045573,01045574,01045575,01045576,01045577,01045579,01045580,01045581,01045582,01045583,01045584,01045585,01045586,01045587,01045588,01045589,01046829,01046241,01046243,01046244,01046245,01046246,01046247,01046248,01046249,01046250,01046251,01046252,01046253,01046254,01046255,01046256,01046257,01046258,01046259,01047221,01047223,01047224,01047227,01047210,01047211,01047212,01047213,01047214,01047215,01047216,01047218,01047219,01047220,01047228,01047229,01047230,01047231,01047232,01047233,01047234,01047235,01047236,01047237,01047238,01047240,01047495,01047497,01047498,01047499,01047500,01047501,01047502,01047503,01047504,01047505,01047506,01047507,01047508,01047509,01047510,01047511,01047512,01047513,01047514,01047515,01047751,01047752,01047754,01047755,01047756,01047757,01047758,01047759,01047760,01047761,01047762,01047763,01047764,01047765,01047766,01047767,01047768,01047769,01047770,01047771,01047772,01047773,01047774,01047775,01047776,01047777,01048172,01048173,01048174,01048175,01048176,01048178,01048179,01048180,01048181,01048182,01048183,01048187,01048188,01048189,01048190,01048191}'::text[])))
  • Rows Removed by Filter: 252,438
Planning time : 3.291 ms
Execution time : 61,304.352 ms