explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fd9P

Settings
# exclusive inclusive rows x rows loops node
1. 365.600 365.600 ↑ 1.1 62,201 1

Index Scan using index_rv_dates_on_rv_id on rv_dates (cost=0.43..175,915.38 rows=66,620 width=4) (actual time=0.097..365.600 rows=62,201 loops=1)

  • Index Cond: (rv_id = ANY ('{10976,4405,5863,7496,7826,6862,17859,7428,5438,11538,9461,8316,7852,3014,9986,2164,9247,4780,6452,10057,23981,8916,8581,10175,4368,6991,11370,3504,1563,11146,25920,7900,25342,11450,11072,7781,4984,11316,4179,2746,11395,3038,6375,6439,3559,6669,20182,5431,2055,5335,9309,8212,1693,23207,10900,10582,9809,9125,10355,10283,3578,11445,10696,8560,18532,1902,3598,6364,25764,9644,6019,5579,5229,8741,8400,7712,10917,17012,6670,4514,10626,13114,8279,7456,9810,4452,2973,9296,7349,2984,4059,26217,2233,6491,10706,11127,25144,11255,26750,3999,19445,9083,3264,10912,16145,14401,22681,6808,2522,24967,8228,10804,3759,6470,6436,10586,10440,4654,9946,6941,5618,10065,5264,11239,2620,8951,24520,11345,6318,11080,10030,11489,9061,6415,8300,27145,9680,16040,3906,7964,7887,5101,10056,17341,6693,8709,4374,5098,3959,15847,2711,10330,17310,8925,3966,11394,7878,7011,6810,10889,11198,24096,9896,6438,23327,21124,6590,2467,10988,6855,6752,5883,5998,8126,11027,6310,6074,25603,7464,9947,5151,6323,7735,1944,16096,10035,1636,9998,4842,6957,6239,13242,8458,7902,8861,7740,8315,8125,6600,5650,8612,10787,20575,8304,11082,10028,8029,3175,7530,8221,3693,10649,10585,7483,5163,10144,8189,9802,2962,10496,9569,5555,11432,5981,4035,8929,18769,10407,839,8804,4799,5594,7267,8539,3245,6384,1941,10579,3750,3624,10510,9182,6350,10913,7151,3477,5449,8816,9752,10736,7043,9374,3019,9154,18322,18135,6033,9379,14846,3689,6163,11273,2890,26213,7958,297,7045,8232,10824,1822,26580,7454,9894,20262,11104,8157,8373,11151,11435,6515,10115,7758,1923,17524,6132,8958,9975,2350,1501,10121,11081,14487,10425,20914,11397,13821,3290,9168,1714,27108,8898,7761,7080,11363,9979,9413,5191,9032,10419,7566,7193,9298,2981,7849,8961,22691,10310,10747,5806,9199,6779,2698,25159,8992,21115,7249,9310,14361,10730,2701,7664,10383,26454,6841,8798,2647,7006,9275,6804,26643,23571,25272,7656,2975,26325,7856,8603,8835,10505,3763,6728,11219,7790,11237,9382,8466,9235,9161,4852,9767,5144,7673,2264,9326,9044,2302,3297,3217,9091,20991,18258,7286,9867,6894,4275,10614,24104,10522,8844,6376,11494,21859,21704,7379,11519,11129,22238,7005,11526,9642,11423,9530,7233,4336,5628,3815,16843,1270,10491,7857,23007,8703,11353,3922,10972,9961,8555,9610,5334,4147,7835,3003,5062,8411,11608,18849,9611,8245,6454,6131,6706,5963,10153,6387,2327,18110,10041,11446,7208,9564,11671,7309,7806,11410,10142,5469,6905,6518,8406,10625,2866,9136,1773,5458,8873,8454,11152,24564,3574,4624,25624,5298,10473,8570,2985,5967,4644,8328,11405,6698,7999,6341,7627,7870,9729,10629,8191,7821,10982,6407,6348,8063,10285,5351,16625,12042,5399,12924,8747,8137,8001,6657,11209,8348,7392,6596,5073,2728,6494,6592,10133,23870,9423,9245,2712,20642,1943,9446,23009,3314,6581,3544,1654,2893,9117,5304,6543,7484,1071,6321,9965,5585,11667,7935,2881,10740,3376,8730,9850,7498,26004,25514,10963,9985,473,2679,8060,8412,7925,5740,5441,4569,25320,8282,26546,26476,7155,2433,6137,7924,6916,11296,679,1049,10539,1801,10910,8779,8041,6702,8738,4208,1617,21242,6529,6633,7111,3875,11822,9346,7451,6842,7366,10462,5404,3859,16574,10332,11297,10131,1932,8048,5717,17544,16548,9825,10952,10279,19925,4381,8109,5814,5924,11478,6046,1680,9099,9450,1750,6798,10890,6837,10663,11564,4794,6878,6075,10351,6791,24330,10406,3781,7105,8613,8477,1696,6896,7236,7291,6362,7014,2161,2368,9378,6188,2873,8596,7728,10788,3764,9231,8322,7443,10659,5291,21104,10287,10103,7594,11515,7558,8521,8050,4824,9939,7583,11543,2716,8837,11588,5341,10617,5971,10437,4199,11060,19198,25714,5241,9022,9930,9228,6818,12046,4159,9020,5427,6659,18711,10235,23138,8513,9834,5273,26462,11250,22395,4525,26350,5591,7237,11473,8595,8742,21527,11634,6346,11652,10670,10411,7909,5222,872,6903,9021,9822,8491,9830,10011,6435,9630,11532,8989,7394,8759,10245,8681,5949,5393,7165,6327,10893,11683,9784,4736,10768,10651,8918,11479,2009,3782,3550,11580,10185,5285,3593,4136,19943,9284,11089,10221,6899,2412,24012,11401,7377,6307,6293,9254,11114,4563,8749,5457,8172,8979,9332,7404,11541,9941,6548,7370,4390,6414,11191,18708,2648,4646,14445,1984,22287,2250,9653,11202,11731,26722,6370,5198,7756,3475,1910,336,4173,3363,13489,5249,4427,5888,20363,19095,1900,8685,10053,2351,22692,5090,11730,6708,11274,11287,13167,22394,7917,22134,6661,8739,5366,17010,6380,1767,23589,9354,7738,7876,14182,5016,5481,6317,6917,5078,6666,10184,2125,8944,12222,10802,18123,5655,16350,9236,16909,2130,11527,10748,10552,3460,11727,2951,5015,6922,11248,5122,8849,3657,4535,3879,11268,5028,1930,2960,11572,11279,7371,2793,11374,25627,5140,6034,8331,1058,9139,7469,6291,6173,6147,9350,14345,5528,8046,3872,5169,7495,5470,10811,2278,15108,10977,9025,5564,12585,6535,22687,3409,8805,10465,8874,17018,7831,10612,7874,6230,7723,21846,9359,11508,3971,7169,11769,7749,25825,25797,10845,6458,8486,11772,8731,5901,4487,5632,11160,12082,6869,7961,6671,9523,10620,26248,10143,8662,5185,6007,5287,1831,2477,26009,9169,11765,17619,4137,11638,9705,10846,6022,11777,10456,11506,2431,20343,9312,10093,5991,7523,11246,6883,24356,5792,10989,2899,11524,9893,11649,1538,23056,11662,9932,12906,21371,2204,5625,6416,11042,12262,25608,4719,10564,3756,4832,15967,4712,3382,25641,6057,8446,11692,10761,506,10929,8211,2680,8956,11212,3393,2589,13928,8240,8473,22842,1730,4580,24936,7885,3052,8469,21376,5822,6796,4804,11334,7657,7194,5210,9619,6373,6263,16244,10072,6049,11458,1765,8906,10281,8920,21908,14263,6729,9627,6427,3486,3738,9175,6994,7310,7705,10132,4922,9974,9971,11573,1936,10508,6993,10307,2101,25944,19302,6110,10775,10642,11510,5804,4856,4301,2855,1595,11702,9959,9607,11448,4915,25307,6577,11440,5741,11732,11148,11553,9649,24982,7488,8288,6222,9355,6016,7866,5025,20023,4676,5522,5088,6133,2148,11403,7480,11046,11400,5476,8366,10810,3185,3903,20596,11839,15429,3831,6367,11876,10599,9618,11244,11447,17249,12914,15006,9477,4792,8020,9128,8966,5659,9519,4732,10954,1954,9229,9142,1753,7229,4425,10463,10983,10874,17821,5567,1687,23474,4575,8840,5600,2322,6562,11442,9380,16287,20320,4700,8683,1745,3873,13543,10201,23906,1880,12587,6624,26612,19931,4384,14221,10760,9381,17902,4129,5721,12987,1576,3476,24709,24861,7384,22593,8301,15339,18840,1535,15221,16488,8190,6831,26242,5807,16020,18119,23647,5506,4680,9582,4621,19763,14801,22061,3229,1658,3788,20595,23818,1677,5603,18920,14813,3401,17666,24146,3694,18195,2725,2572,16507,24669,11041,7326,1742,7268,24896,3525,16460,6251,3686,7019,23902,1929,5612,2702,1659,5638,23245,2482,5234,4182,5694,2646,16312,3620,9741,2801,6860,6480,6901,6430,9122,26086,6035,19847,3360,6472,4382,3451,5666,5964,5852,2224,5559,16701,14761,13224,10301,16919,4080,5132,4904,8827,3147,4307,11453,15562,26901,1586,904,1066,3720,7848,275,965,2225,2407,2700,7037,8051,19561,3030,6325,4304,5063,3503,15322,2427,6292,5667,5608,4928,6604,7913,6285,24155,6446,8822,8800,5689,23098,1824,1747,4851,5192,5690,8853,9079,7474,5524,8774,26701,2320,14321,15131,16231,21265,18075,1961,3392,9827,21158,6940,3942,3193,24112,14641,3454,4176,10120,4625,23751,4333,7351,2694,8034,7433,7457,18255,9483,7687,10316,23211,10254,8155,8597,8112,10734,21373,7553,1543,26953,10524,8349,7356,10174,7796,6243,8484,10347,8481,5825,2591,3329,10540,6822,6065,10704,6162,9335,8143,10678,6309,4210,10739,10509,8037,5379,25782,5742,11067,7512,9953,2121,2462,8649,3948,7565,3785,9967,17525,17606,8970,2779,24080,26453,8870,9209,8259,11412,5009,10210,11182,21786,3929,10062,10288,7797,10414,10318,5951,4592,11206,5940,4340,7039,5518,1826,8794,3751,7312,11285,8559,10969,8199,8280,6644,3213,6619,10979,9814,11482,11459,5989,27086,2585,3025,6570,9901,20791,6200,9256,11546,9567,24444,10870,20714,9432,10264,20671,8968,9885,11026,8850,5425,5994,4730,9292,15672,6328,6153,20137,2123,9874,3878,8016,9230,5228,2967,6393,5478,16148,5376,5170,7646,26275,4554,7554,7533,7388,6170,18142,5853,6591,20399,7417,7106,6885,5207,24143,25128,5920,6707,7654,7580,3496,5502,7271,3945,6672,26543,6107,7696,7502,7787,9253,6020,3527,5176,2849,7041,7623,4447,2789,6244,1667,5908,3274,4919,26398,6807,7836,4342,7934,5722,21160,19798,19957,22030,5517,5712,2162,8680,3309,7485,25892,4801,8234,19942,5829,5530,2023,4598,2086,7275,26900,6830,6607,1785,6723,7210,5598,7501,20735,7153,3818,4071,5736,25229,5766,6497,4355,25839,3311,6847,1673,7322,1903,4296,7339,1973,2894,16002,3588,5248,9982,7292,7596,4784,6777,4350,4397,1783,3058,25669,22527,6313,6199,1605,7243,6558,24654,8276,7783,7817,7819,1904,21053,5922,6863,5858,20876,1591,1585,6843,24665,6710,6343,5468,1708,6148,7009,2670,22125,4723,8834,6945,3312,18789,7813,3713,7372,6720,2579,4594,6378,4503,7065,6396,5193,27022,24841,5584,15285,7503,7470,6631,5233,6709,5979,25916,1979,6794,3364,7877,2886,3561,6261,6111,7089,7804,6620,19912,4892,7458,2226,26380,5323,5799,7196,5484,3186,5049,6943,5482,5847,7692,16934,6425,5491,7792,7044,5639,3801,3832,3026,5772,2338,27049,6782,10621,2655,7449,5978,24226,3722,5257,3833,6217,2994,4325,7789,3508,2690,6819,6045,23904,14103,1661,7288,7680,7152,2858,17189,5946,2499,25134,22683,1629,7765,6572,7898,4907,3709,6969,26871,7701,6913,4734,5850,4877,5960,6319,23600,6030,12581,5510,21114,6814,7294,5489,7254,5627,2147,5874,6442,26861,7376,2276,2398,6565,18023,3800,7468,7710,4432,3173,6744,7699,22588,4283,2372,4306,6386,6897,3407,5780,7112,3967,7473,3732,4162,2889,12702,7261,7767,2519,2978,6970,6242,6613,7078,7510,4813,4888,3216,6528,2625,2697,4941,7477,3439,4104,6664,5643,6487,5550,3301,3362,4479,14105,6322,6000,2298,27046,12182,6476,21322,7638,3926,25295,7424,4578,6466,3956,19731,7422,25179,7300,7871,7478,7603,4389,2127,7942,7838,4250,2799,2518,1623,5021,7786,6972,7911,6490,4721,7545,6649,6621,7536,2244,15062,5881,7582,7555,23567,7617,23430,7421,5936,1836,2665,21266,2379,23442,7881,5177,7693,7785,4596,7655,7883,8110,7809,3348,8066,6742,7901,2177,26259,7833,7628,6207,5455,8023,23137,5036,19168,26613,5925,8017,7649,7950,6987,7907,3708,8152,8173,5693,8156,6840,6492,6688,6829,7926,7399,1536,24353,24370,6382,7182,7459,6540,5974,7157,6695,8205,7550,6933,6683,2015,24340,6417,3445,5686,8766,8995,2417,1966,7652,9677,24326,3513,8185,8324,2634,8019,1791,25848,7251,9736,8327,7676,8401,4648,23877,5972,23455,10033,4281,1668,8377,8938,8723,6406,6992,4036,8959,10113,2965,1580,24624,5199,9708,22564,9652,3548,10130,26089,9490,11581,8472,8821,2473,5788,5767,3951,9720,8583,5218,8892,23863,2708,8363,10202,8235,8726,9508,2709,2818,10246,21372,1611,8769,10255,4150,8261,9360,8233,6560,11465,8848,2422,27090,5505,5779,9088,6757,8567,9451,9054,9071,5562,2255,5008,8174,4988,8044,5161,23891,8313,7868,9041,24522,2245,5355,3843,7228,8028,2562,8145,21415,7608,2243,18781,5538,7040,6888,8151,24903,6241,8006,6225,1624,8241,7759,8278,7386,6040,8181,8200,20447,4399,4229,2356,4109,7387,6544,3059,5553,8427,7694,6643,21141,7171,8251,8237,7020,4198,5237,8138,5745,7659,9820,8384,16885,1615,8419,5857,8485,1561,7036,2340,23268,7770,2280,8239,8263,6721,8967,7711,5243,8392,8519,9065,7773,8586,8127,1703,6082,7382,7462,2601,8919,12967,21728,3888,8538,8669,8620,8725,7413,4906,3896,6870,2406,6432,3839,8593,1933,25257,6083,15344,24349,26630,6974,8588,8885,7487,8577,4221,23844,6988,21886,8632,3367,8857,8416,4268,7927,2124,26365,3723,8423,8969,1796,8179,4619,6769,24720,23384,6530,8753,5958,18407,3572,2623,8086,18963,1992,1717,16222,3438,26434,5214,23850,21907,12552,7862,8673,2098,9040,8168,19235,3479,4265,5737,5959,4248,20228,6793,1688,1955,19844,5066,7698,9922,14530,2257,5982,3421,8565,6882,25632,4062,8277,12961,9072,9409,9492,9367,8950,19589,8337,2434,9352,8931,6537,9537,1999,9383,9430,8799,7697,4817,9434,7493,8553,24754,8757,7432,8949,8643,1886,7730,9221,17886,9428,6990,6533,3035,7220,7138,7052,3635,3961,4327,2784,6658,6165,4853,4146,17862,7189,26829,6424,6453,7442,2660,7803,6763,7675,6699,4188,7922,7289,25168,8318,3500,2290,4834,6220,2316,8457,8113,8391,16681,6522,15521,4582,3299,24762,4127,5112,24913,8213,7825,8238,8935,9334,22821,9356,3262,8542,7017,8117,5246,14506,8656,18146,1991,10060,4098,9590,7983,14767,9237,5993,10066,9716,10276,14646,9489,7745,1566,8639,10048,10259,6185,4393,7733,10702,8013,5808,9260,10250,9857,9843,10367,10362,14381,10247,10559,2760,3665,8633,9637,8474,10901,20562,9926,4779,8872,8580,7717,10495,6294,17463,5977,10134,20992,23577,9035,9283,9669,8864,6473,9017,8087,8856,10044,10527,7943,4927,10253,5309,22451,4053,5472,9358,10714,10679,11348,10751,10903,16181,3898,11023,9815,10631,5601,7073,10770,10331,9989,11319,9105,6042,6392,8579,11335,10991,5504,10227,11044,10584,16990,11045,11007,10042,8851,25216,10719,9444,9293,2067,19096,8831,10170,11231,11236,9148,11230,10615,24627,8829,11451,7695,7754,9500,6612,11264,10073,10953,1766,9973,11269,10644,7593,11428,1301,3979,11411,11552,9956,2063,11626,11533,10675,10306,11622,8830,5527,9747,7560,13404,11562,9709,13304,20070,20866,12841,9270,8361,7755,11783,3420,26208,8905,1227,1685,5950,6839,1131,8541,5433,7437,2616,2389,9656,24894,416,4322,8564,20470,19463,16066,1646,4454,2260,5842,3369,14847,3450,2715,25358,6018,2812,3452,1639,2446,6252,18288,6351,2920,1878,4996,16918,6610,20546,26012,5569,4693,21944,1963,6910,5870,20786,7221,20677,6915,17473,5732,21301,1989,4026,18921,1931,3463,6857,21844,21612,24088,24768,26500,21684,5752,4653,2404,4897,27021,20398,25739,395,15106,3557,24900,4020,1470,22932,7513,20680,7027,21530,23210,2576,24661,22461,3701,3349,4174,5944,15328,6249,6821,5789,6939,20154,23043,15501,3970,5840,16593,20799,1842,24727,5134,5961,25282,6011,1861,5247,5519,22524,5773,2811,3294,23920,6297,15853,2534,22383,25104,1899,4009,19196,3976,26239,2521,486,24566,6785,19846,22458,16504,4252,7103,4717,1094,18321,6879,18481,2344,2188,12621,3404,23447,765,4555,5932,15008,4605,23004,23018,19587,21501,4517,14806,25777,11666,5181,24650,3930,17445,1798,7352,5700,6178,1168,27087,23665,17686,2081,17332,1604,5546,21668,18134,21033,6526,26526,21222,3845,17447,1251,3212,24094,19454,4821,24678,5701,6077,23102,6224,25185,2078,11824,13421,21037,4810,20906,16283,3041,1530,19061,17203,23779,24930,5286,17301,24365,2200,2265,6660,12101,13281,20926,6114,4448,3371,10742,17551,22648,14645,1994,6890,2853,23994,5104,4280,14782,13981,13425,24190,19911,6120,7482,2561,2939,24921,4177,6431,3046,17196,2570,20848,1219,17331,20722,1475,5302,4228,21710,22756,6809,16805,16564,24666,20583,19362,24681,1803,6171,18027,14298,2402,5421,20622,24518,18505,13188,15896,21029,2108,1499,12181,17011,10800,12003,2774,17017,12555,2583,23595,14943,9600,16869,7847,13581,17466,25623,5586,22930,10420,17617,4500,14151,4480,9801,21062,17861,22324,16415,15894,10801,23304,16901,15850,16162,11722,13849,8900,24609,10102,15361,9685,13554,15427,10104,20742,9361,4220,6861,16366,10806,3780,3855,14809,12861,21424,4161,14804,19033,16741,6700,24114,3196,9861,15848,18922,20501,11375,13502,6400,26906,15722,15603,8421,1625,23223,16542,4628,17443,17567,3643,2923,8562,21321,7840,5485,26161,3120,12421,14088,17571,2172,16664,21804,20748,15786,22531,11590,10922,12446,4112,15284,14904,16342,9940,17311,6684,13701,13561,13423,17783,12364,15323,26169,4672,7053,2215,19062,2331,1792,10180,1572,10860,1583,20481,6920,12455,3534,10762,3795,3828,15301,11463,13565,5942,9562,21406,17309,16261,10622,21848,18846,19004,7666,3551,2626,4043,1657,3194,1864,2180,14242,13244,3018,15965,17603,21040,4990,19667,17148,24774,19327,23457,6044,18447,8721,11341,3276,18284,9624,2531,26920,14721,15742,26095,11377,2202,24486,11100,5048,2366,22501,3836,5141,1567,3840,25922,16487,1838,11801,12061,2064,25758,16097,9202,10240,3560,19146,19162,1777,21221,3298,18098,14389,23590,4023,11542,6204,16034,12548,16164,26761,4051,12729,23475,3373,26150,7323,17727,3899,20165,2019,3441,26383,2441,13144,17076,2780,2133,2794,7841,17891,12449,4635,2452,20012,3403,23169,21565,11661,13487,2361,14742,24319,1985,2704,3935,6467,10159,21562,26937,10826,23001,14521,3660,14061,19269,7760,2026,1597,1895,1968,17305,2995,6283,14762,12801,5549,20404,17570,8761,14211,19223,3183,1868,6582,26862,24157,3856,3615,22308,21905,1722,23569,13521,15362,22508,14404,23326,19142,15878,4091,17042,2111,24358,11383,7463,21390,21888,25559,17476,17656,10523,22484,9062,13074,14529,4240,18351,25143,24253,18944,7360,3607,10403,6900,16071,19899,1854,25539,9603,15663,19893,18964,2189,3944,1641,19581,25765,1758,15121,17315,1526,726,586,6112,2405,22124,20290,2546,5426,7663,15744,22523,21962,5030,20197,13069,9261,1331,5213,16289,5130,26277,5007,18048,301,8646,2718,3324,9465,16149,5108,15941,12910,2021,2348,1986,19606,16070,26590,2806,4045,23867,13126,15955,26094,17906,3331,21165,2378,469,19267,18347,4089,22482,2027,15044,16306,15952,6191,10441,1651,19712,19487,7445,3316,7842,19237,26170,3255,23572,2028,18409,5131,2426,17607,5365,20455,5560,18035,10803,2778,2659,6302,2241,3946,8740,3666,19170,3568,2961,18072,5844,9480,5817,4094,5969,16077,18150,5965,4178,1794,17316,1715,5563,2883,5467,5660,18515,12968,26605,18861,1744,19381,23820,367,2440,20072,20452,2444,18082,21739,26258,3851,3506,12084,1469,5513,3998,3334,1962,1635,2022,5635,5418,14810,24737,5327,5905,1847,5640,6645,192,17882,3327,2539,2192,5463,10823,2239,5621,1692,1733,3203,15345,14688,20451,2166,26384,1887,12701,12885,2295,2869,699,20286,12623,786,969,3633,216,470,235,330,25890,1284,1059,2258,2112,5451,2638,6448,11943,3127,681,467,26504,11961,17909,2649,19493,3354,2099,2072,3789,721,2416,18207,5350,16262,670,12423,1821,4926,1938,2437,4190,4151,1820,3715,1784,3017,16036,20678,8701,3599,5743,10981,27027,18863,24252,3227,12916,7060,12681,23710,5921,25917,2105,15329,26961,13462,2359,2817,12583,1571,1138,5357,1242,5010,3744,5723,5268,1916,5450,1909,2077,7301,14041,13945,18514,6117,23792,19583,5970,24825,2803,3654,7843,13864,16226,17668,4042,2783,9803,4884,21732,4110,16142,1655,21432,21966,4329,14042,5626,19646,24024,1737,2380,11406,17721,16759,9663,3669,5845,4593,17753,4742,23696,4983,18174,8641,22200,266,18076,11705,3737,23918,3571,5509,14675,4702,14202,15661,1805,26214,4375,3614,2430,19621,16571,2963,1243,3592,6593,2051,23243,18768,3332,5785,3381,6180,4372,20318,4183,13485,7543,3466,18047,13762,19161,5135,4623,5642,3731,1573,9462,23329,24999,5316,2156,21081,2969,1789,17671,15763,2218,4021,16067,1896,4949,6265,26542,2365,16567,13081,5012,3721,1779,5460,25545,2144,1876,3652,6150,17509,3128,18445,3618,20058,4310,517,3499,24569,22705,24284,6024,2169,6717,26881,17006,4620,22022,4319,2367,19529,4867,21520,18906,3223,4172,2286,2114,24313,1874,18760,3837,19024,1863,26298,2008,16432,24170,4422,3446,15857,19956,25105,16661,6639,23175,27088,20706,2535,17158,18783,16662,23448,21437,21798,17379,4666,23750,20322,25325,25123,24584,24462,3564,24983,2031,25762,2413,953,14978,6775,23868,25859,12145,20022,5160,24726,22433,7144,6260,5026,18106,16750,27082,24684,27173,1774,1702,1764,18785,1713,3201,24698,14382,26826,11563,1630,6541,19730,16434,6076,2617,3207,2073,25856,21024,3330,25783,19849,3802,3491,6797,3650,2635,26430,2593,1804,4562,19122,1883,26203,2937,22345,3749,2944,26088,2945,19872,1534,2220,6674,23883,4419,4893,3698,6352,3352,6813,23452,13562,4627,5252,2554,23493,22460,3600,22757,1644,2748,2044,24920,23454,14972,23082,24102,1993,16742,25952,19644,2236,18166,3667,1517,6946,5599,3411,2913,4819,22239,22208,6420,1950,27060,2586,4606,2875,23738,25679,24906,23215,2196,22945,5529,6277,2595,1982,1757,24722,22222,3529,1500,22906,3205,2460,2472,3963,3768,1881,5152,6703,17070,21538,2807,4531,5336,2776,2205,3032,27068,6628,3056,4166,3853,1813,2867,26432,4416,6455,26720,5784,6088,2726,18782,24730,2956,7046,4362,5296,935,5797,8922,677,1637,903,10834,8936,9546,12546,4748,751,8768,9684,1139,640,1293,281,840,500,4004,1552,5602,6761,2007,4509,25955,253,3073,1050,1040,1148,418,417,434,1163,178,1029,459,2768,599,975,4542,723,1024,5225,276,221,734,919,875,361,1178,4767,712,610,757,2656,217,254,4782,3870,226,3687,672,3949,1039,2176,474,1328,725,1245,4508,3806,252,4337,1205,2717,5819,22111,1120,7795,22390,5995,5968,7327,5854,7564,209,7713,1206,3596,2050,3184,2989,1482,4936,8459,6934,1358,7274,10619,11945,7563,27084,4727,7726,8227,1069,2207,5574,2940,4629,6149,6059,4414,5597,5865,2388,7391,4733,11603,11544,15102,15929,13642,1541,17707,17365,18112,18286,22532,4796,19361,24765,21983,25996,25636,21417,2120,15845,1981,15909,688,2159,1083,682,23162,3740,7665,2409,19395,1810,15648,7780,6238,7247,3260,6635,3131,2880,16722,7618,3077,23282,4962,6360,25340,7579,4641,24508,7981,18754,13842,5200,3580,4520,11941,3040,6686,12144,15721,7801,26043,17465,3165,8561,13524,15170,15224,20261,21462,5001,15171,25130,13607,5547,14544,9340,16331,20877,9682,3116,25910,13142,18792,2720,6080,10200,1537,12102,24998,14285,11881,17057,14212,6995,20928,11861,17008,17881,22841,2080,25919,3760,4120,23147,1540,3158,3085,3520,8760,8360,11566,19862,3133,6483,10040,14462,17381,4880,7507,5300,18865,20841,1888,17469,17347,16969,5050,9693,1674,9581,13202,25929,16225,19921,16201,4061,5572,7923,7450,20213,14070,14728,1937,19143,23099,1539,3130,21063,26245,1940,4040,9691,3540,9688,6274,16400,17005,3841,16354,21043,3081,2010,15997,9860,21021,4320,17706,6574,20364,2383,3111,8003,3167,3581,3960,10984,16455,4795,1928,8026,3001,10666,2089,7410,7811,25977,8128,8052,8049,3469,2565,1913,2485,2606,2228,1743,25947,1815,24575,7722,23402,26172,4385,3079,2541,3140,2109,2269,27165,4489,3100,20071,5753,23622,5179,25606,4261,3881,3419,26372,3114,3880,1628,3168,2840,2551,16023,1569,3161,15908,17041,3123,7684,4069,21745,3163,4300,8040,24079,3066,4242,3132,3962,9200,5400,17467,17621,13307,22586,5370,3075,14286,3159,17202,17659,17523,18943,5880,11200,5422,3365,24488,17866,22455,1776,4234,25579,3137,16872,2988,4348,23739,2279,14980,17021,1700,18038,22862,27142,9180,16561,20724,23997,18243,21408,4781,3106,15441,18788,1643,3160,25141,16563,16641,20310,23733,14328,3982,20713,26260,12353,14246,10906,15010,15341,19764,24638,10003,21147,25853,8002,22672,24963,12110,20740,6500,1893,3069,3820,11843,3028,2501,2480,25111,2281,3876,4010,3757,3050,27063,3148,2360,3138,2645,3169,3238,5184,4420,4701,18374,16981,15129,5900,9629,8065,4100,5523,16496,3166,13305,1860,3150,3122,9625,4160,15065,10561,11521,19003,5004,6048,5777,5851,352,4612,18244,12823,23938,13492,11376,10861,22562,26006,20129,8660,14649,19681,18519,9150,21214,13681,23270,26002,10847,982,2833,1079,4512,2897,1367,882,865,1127,1005,3246,1285,2805,1360,4667,3307,5688,342,1063,3375,2342,1505,2457,1035,3181,3517,720,647,1548,3605,565,6159,4766,918,810,4411,791,2074,5038,4585,886,4691,5943,1181,1188,1147,4316,1221,1480,3918,3805,265,4650,4308,989,3803,6129,775,4977,184,5648,3044,4463,191,4239,966,2423,958,578,6770,938,4678,4976,3941,4115,4822,952,848,949,539,4087,837,5834,3674,798,755,3306,5106,6287,924,7704,843,2892,5013,1531,4553,1361,4973,799,329,4540,399,2673,4793,704,1008,1848,5575,1104,6512,4132,715,830,749,700,3355,655,4570,668,846,1061,1256,4469,5343,6144,625,626,831,697,4185,4410,979,1335,1945,1440,9366,5609,1092,5610,5801,9674,9994,9077,9495,8467,9851,10023,8124,13121,9606,9824,9119,6017,8532,21949,3637,9833,9397,4583,10000,6449,8273,9878,9609,10122,9725,7000,10050,10151,10099,9118,7403,10076,7716,9246,5437,8045,9887,9750,6950,9773,7524,6764,9163,10172,9566,8386,4952,9920,950,915,1166,834,6956,7509,9066,4901,9171,15122,8216,6741,3006,963,8183,8422,7383,7897,5696,5415,8154,8689,8658,8698,21289,6232,7896,8388,7702,8986,9189,8343,8192,8876,7899,8910,7263,1463,2630,9241,4538,5119,4826,2448,9487,7685,8833,5462,7660,8073,9491,6145,8720,4394,9721,1257,7258,2450,8217,256,1022,940,1171,1231,1125,1224,1275,1254,11020,7681,16502,11522,20543,20930,21409,1622,5423,24623,23729,25505,1681,2042,6391,10459,2012,614,25867,1241,25988,2629,24992,2577,7860,24453,2695,2439,3037,2049,2757,3442,3437,3857,3923,466,4224,1336,4677,2724,4808,1055,5203,973,5143,5274,6443,6262,2738,6662,6339,8024,7957,8654,9160,8802,9394,10366,10512,10091,10797,9005,7661,10152,10658,5583,6893,10476,10207,10312,2272,9555,9572,9553,10320,420,9280,5941,9819,10012,7865,10213,10940,8105,302,9793,9170,10075,9342,10015,10379,9755,10070,10793,8653,6766,5223,10389,4809,6256,3809,10816,3862,10424,8498,9398,7266,9717,10257,10278,5653,8953,10435,6409,10381,9706,9579,10106,10375,9796,10449,3917,10450,10707,10386,1154,9831,9401,10829,10446,10365,10408,693,6248,10701,6330,6586,10962,6401,3991,9552,10567,11053,10088,10916,4611,5631,7002,9780,9910,10467,3891,9655,8664,9832,9157,9797,10230,10944,10431,9954,6881,10683,6138,10197,6856,3542,5079,10314,512,9829,10645,8838,10926,11153,7764,11356,9151,10973,11037,11256,11009,7520,10733,10968,10966,3863,11057,10531,11039,727,10727,10930,11055,9646,10158,10156,11068,11408,11414,9934,7130,11284,645,10447,9320,4626,3586,8897,11015,10924,10657,10377,964,10036,9008,10027,8103,11126,6196,11141,10798,11064,11034,10813,11186,4215,11327,6229,9891,10794,11466,10217,10932,11178,10986,8433,11022,11362,8067,11252,11138,11083,11139,11336,11205,11502,11520,10785,9808,9942,10668,11161,10580,7334,9935,8533,9580,9029}'::integer[]))
  • Filter: ((start_date >= '2020-10-15'::date) AND (start_date <= '2020-12-31'::date) AND (status = 1))
  • Rows Removed by Filter: 1,657,406
Planning time : 6.053 ms
Execution time : 368.240 ms