explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8kVo

Settings
# exclusive inclusive rows x rows loops node
1. 645.592 645.592 ↓ 1.2 78,219 1

Seq Scan on rv_dates (cost=0.00..5,058,776.10 rows=64,236 width=4) (actual time=0.033..645.592 rows=78,219 loops=1)

  • Filter: ((start_date >= '2020-10-15'::date) AND (start_date <= '2020-12-31'::date) AND (status = 1) AND (rv_id <> ALL ('{2981,26208,9374,10320,5863,10551,209,9310,6207,4336,9260,8343,9809,10510,25641,10651,9256,4648,25764,1902,11638,10917,6903,9199,6548,6017,9954,6543,4405,7627,11405,6364,8406,9342,4525,10425,2873,6452,20137,6348,10747,10330,6729,8458,24444,3966,10172,4605,11466,9767,7713,11408,10768,9497,8581,2801,8189,6703,5712,10496,9815,3782,9824,25762,26170,11538,9874,3476,9547,10579,3475,3477,2367,16145,10846,4173,10221,6082,26350,19198,10122,6373,6291,11209,7233,20575,2593,4137,3463,5222,3499,3525,8348,7758,10030,7673,11573,3038,10707,10968,5229,9298,27086,9610,5119,5431,2125,23207,10459,5579,1636,20070,6855,4892,22705,6243,9802,4712,10924,2264,7877,10279,8779,9142,11152,23137,4109,7236,10184,9896,22022,10977,11148,5491,10028,26004,4799,10257,11502,6318,8853,9495,9752,5207,6529,9032,6829,8179,7857,25624,6057,5625,3003,11526,2124,6905,2899,11608,5468,2718,10973,7695,2286,20671,6350,1285,9430,8831,11274,10332,1936,275,7900,7999,2951,9091,8137,5650,11284,10983,1944,8835,8662,23327,5028,7836,5845,8538,9139,10944,4136,7811,3018,3815,9609,3598,11543,8747,16681,17443,10131,9546,3544,10205,10972,5144,10406,9117,22842,6524,5469,3906,8979,8401,13489,23009,15853,9423,10355,4374,9359,8034,5851,5740,5151,2913,9118,9530,6994,9171,23430,2278,10797,24146,4208,5223,2985,6706,8730,9710,8741,5399,7349,4691,7169,5264,10089,6204,6950,8742,11250,19589,5433,14263,4915,3046,6670,5112,6837,11127,5564,3329,6757,10824,8986,19763,3759,2894,10785,2289,8724,9020,5470,6252,6251,7339,4904,7942,10035,26088,5883,9189,3593,23138,11335,7728,5974,7392,10952,4624,1358,9939,15847,11673,6346,11515,10865,5249,10351,6894,11198,7267,22134,3297,11446,7351,22394,10088,9750,8232,9125,8833,9390,8013,2679,3460,6256,7450,10963,9820,10473,3809,9901,21437,18146,1668,7011,2711,3032,4296,18142,8596,11692,24967,7155,24936,11678,6660,5655,9360,2407,10383,791,6592,5717,19561,5618,6941,7553,11401,10739,10264,18711,10900,10447,21115,3859,7964,4782,8105,1899,9326,18708,6671,4198,5458,6913,6896,24982,5767,10870,3301,16574,11248,8124,20991,10103,7377,8873,16625,25608,11704,6153,11432,8366,26454,7755,9021,1773,9247,9150,9713,7105,10979,21704,3014,11204,10245,1595,14487,16040,24841,9332,15344,21612,17859,11580,25603,9163,8251,6407,10982,2164,5427,10414,5881,8749,20546,10508,11450,6779,2250,4766,3689,10419,1654,6211,1824,7454,7523,5963,11045,4452,4644,25920,9284,10255,6934,6173,5090,7950,25825,4308,23210,10254,10130,4447,11553,9440,6149,4036,8731,10121,8491,11041,8191,10913,8800,10736,11410,26643,1301,1900,11191,8048,4210,4026,2956,9356,9500,5481,5788,10213,8916,11322,18173,4563,5132,11494,5527,11319,3574,11129,1658,8559,5210,2477,5961,4852,3991,4179,6798,839,7887,8720,1058,10912,10733,25892,9684,23904,4736,10629,9926,4842,10564,2224,4514,19925,7193,10989,11219,8046,4922,11255,4535,11412,7656,3264,3550,5287,2557,418,8822,8905,6114,8304,5425,5098,10585,9827,12702,5981,18769,9367,11256,7493,5901,7536,10619,11327,10954,8739,6869,11034,840,4069,2074,7735,9894,9483,8603,9784,10283,10642,10845,16148,3723,8798,19731,5063,8929,10060,25839,6123,9998,9656,2522,19095,1049,5441,7363,5829,7749,11104,10375,7790,10754,2570,5008,8477,5007,2698,8316,5015,6293,4952,5169,2962,3504,25714,1881,6222,26217,7111,2886,9523,14846,5920,6518,1753,21786,11710,9957,6230,8759,7458,5998,21371,11518,7510,10582,11765,6796,2709,3624,3557,7080,16455,4307,8328,5141,10761,3903,11579,8263,3693,8228,17524,25514,24678,9649,10584,1717,9022,11822,8539,5304,8910,6467,6442,9779,2875,10767,4159,6239,3750,8211,7370,8934,23870,3185,6406,8044,1005,25739,18135,9569,2701,5351,16548,11465,7848,10788,7507,26213,2519,6761,10893,3019,7856,9975,9747,4397,10287,2276,9755,2161,2162,23589,4503,9040,10804,5941,1674,11153,8612,1886,11715,7878,9355,10659,10170,2858,16843,10307,11540,11151,7309,11732,8373,11564,7885,2499,2807,9312,4390,11702,6841,12587,2302,1535,9611,2031,2412,11336,8769,1667,8580,6040,10407,1563,11072,22681,4832,6491,9971,8906,10076,2350,5597,7451,6596,6839,4427,3491,14182,17341,11178,10552,5437,3513,7194,11731,24012,5062,4059,8738,7876,11359,9887,4780,10649,25782,11546,6309,11440,11671,11441,4792,7151,5789,7326,11643,5972,5530,10143,9930,11618,6763,6415,2620,9182,11146,9083,6380,14506,20722,10663,9296,11057,3875,11541,24624,7593,4098,9099,10072,11415,3201,14806,4104,11239,20866,3382,7723,2853,6993,14782,5684,9236,4901,11035,8221,6261,6227,11334,6728,7817,6669,416,27145,8816,10539,4281,11585,6883,2467,14813,10142,5438,6327,10910,5298,20228,2431,2368,7249,5355,11244,27108,5485,5285,6343,11876,11226,9413,9604,7469,11572,15221,11498,10437,12546,9961,8020,10509,4327,21859,8212,5484,1528,24727,6512,22691,4570,5302,6370,11874,24627,8513,20154,10567,10465,23007,9974,7874,7404,9161,21908,10730,3255,3534,7484,9231,11481,11928,5994,10456,10217,7934,8037,8969,23751,7738,8481,6325,10066,3173,4306,6427,8029,14381,9061,11089,9907,10670,2462,8597,8875,5806,10617,11023,5594,20343,8931,6074,2063,6560,9677,10227,4250,8377,10806,7443,7754,11237,11206,7495,5601,7866,6661,11269,11042,10316,2728,11394,9764,9245,4053,5163,5563,10318,3290,8918,11417,26462,9382,11473,8273,5924,9642,6046,8017,7649,10312,3058,11532,9505,2779,7625,4580,6242,25307,2148,1992,7437,8157,8850,6916,8870,7456,3363,5993,17301,5025,5971,4035,25320,8649,7847,7710,5379,8849,7918,16287,6688,2923,2634,9705,3731,12552,3588,6470,2316,3951,22687,2518,4554,3451,7910,3454,8190,9271,6075,20447,6870,9669,9810,8656,7378,9041,7608,1861,9025,9489,6577,10175,2694,23850,18782,6435,10362,5814,10901,21846,4801,9293,8949,12581,8085,7756,5600,2648,2670,8448,8927,9072,12906,8262,26089,6804,9175,5108,8542,8126,8213,6672,1750,10540,8082,9262,6393,10615,10890,6292,10647,10056,2427,8051,10276,8234,7821,10367,26861,11067,1730,6298,11227,7477,8315,11273,3025,11231,4147,6033,6705,10862,1791,27022,5940,24104,7712,2351,7761,6970,6972,2591,6065,9221,10605,10174,18258,3502,9537,4176,10903,26953,16460,5376,24112,10703,10942,20791,5101,5850,4851,10902,11212,9893,1611,22125,7927,7065,3560,8917,6769,6807,10734,10969,5140,7580,4919,8229,3948,25848,6045,11230,10489,8349,25295,4275,9716,6644,10953,6917,6387,5823,11435,15661,7917,25944,2121,10235,2601,4080,5518,24080,2067,8113,6307,12222,7835,11118,11587,3299,1680,25627,2322,6698,17012,4654,6666,20677,7583,9446,18322,6416,9653,5694,24356,26504,17861,7480,6385,18921,9396,9621,5078,6723,9780,3193,7530,5610,17544,9606,1774,5273,10132,2589,2855,9944,8063,6035,4487,8555,23981,5991,6321,7485,10057,1801,3837,6791,7797,8300,6436,8001,15129,25144,6147,6693,21124,13821,2101,2572,2130,10586,7826,1932,7208,6570,16488,5908,4984,6541,9136,3942,6328,18288,10740,8288,1693,6657,1270,9228,1714,11055,7014,4368,20399,8331,7503,6117,8547,1783,7464,6533,6777,7459,26590,24520,2007,4629,6367,3831,10625,10144,1499,5840,1696,7403,6782,3971,9627,6310,1923,18119,2803,5591,21907,9280,9253,7387,20714,9567,3637,5152,6957,5585,3922,6007,21104,7006,7806,9819,9729,9237,4810,9235,10011,8484,10379,11581,6939,5214,10706,7961,5233,10000,10696,9379,9773,8774,10787,3472,10446,26580,8183,25919,4794,9119,1576,23056,10099,7512,4804,20023,4333,6901,4897,5950,16434,9959,6842,9292,9168,9607,7657,5752,10285,20848,5965,9834,10631,10278,25777,22061,9965,10505,6341,9652,10463,8673,5766,7560,7488,6438,3404,7153,9335,2975,9986,6362,6418,10153,10431,1822,9985,9044,2680,2890,7566,10531,3035,26275,2123,19445,17018,10988,7379,6171,3578,22238,7852,10491,3500,5666,3721,8595,10185,24462,10847,7237,6878,5949,5943,6439,20262,5457,10645,8521,8857,10714,6424,11279,9947,2958,11288,11027,6137,8837,10916,4826,10120,2389,10930,9946,10050,11252,9830,3367,4555,7413,6034,6277,3314,5104,2866,16901,3713,6019,24698,8951,9706,12924,6454,10397,9708,11395,8173,10109,8045,4432,8386,11081,9461,10115,19302,6414,9553,24900,2793,660,11297,1963,5393,17381,22395,11064,18481,24102,8019,7870,10559,6808,10966,9318,11356,5555,7726,10614,10889,11114,9555,2746,1501,10791,9829,5653,7780,26248,10202,9154,23750,7881,10612,6425,25159,20914,3052,6264,882,7923,6862,9867,6810,10811,5257,7263,5632,6162,6142,6199,5482,8109,10929,9680,9157,2881,4322,2055,9941,3879,8898,5967,7825,8486,9849,17619,5013,2748,10314,9254,9450,7795,14742,8326,6924,10365,9008,5341,5659,5722,10065,10391,12042,8944,10522,4185,5626,8593,8925,9796,8681,7740,1941,20595,1617,10197,5241,9346,5193,10802,1059,16885,10310,8154,8282,4667,8703,6232,4809,10794,9618,8103,4732,10053,26009,3756,3407,7924,5996,6200,5012,10299,1931,7483,1505,8920,7498,6112,7274,10798,11478,8560,3998,4448,5968,5200,351,7909,1993,6699,20182,12585,6376,11378,17473,4856,10408,24564,13242,10106,2127,6830,2944,2460,24906,1468,3486,8238,1245,11316,9910,11597,6814,11370,9366,7596,4425,11202,11935,9808,11098}'::integer[])))
  • Rows Removed by Filter: 2,408,564
Planning time : 2.603 ms
Execution time : 648.155 ms