explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f3l

Settings
# exclusive inclusive rows x rows loops node
1. 0.855 55,052.954 ↓ 0.0 0 1

Delete on public.product_snapshots (cost=0.00..7,683,840.71 rows=3,883 width=6) (actual time=55,052.954..55,052.954 rows=0 loops=1)

  • Delete on public.product_snapshots
  • Delete on _timescaledb_internal._hyper_67_7288_chunk
  • Delete on _timescaledb_internal._hyper_67_7297_chunk
  • Delete on _timescaledb_internal._hyper_67_7304_chunk
  • Delete on _timescaledb_internal._hyper_67_7360_chunk
  • Delete on _timescaledb_internal._hyper_67_7431_chunk
2. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on public.product_snapshots (cost=0.00..0.00 rows=1 width=6) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: product_snapshots.ctid
  • Filter: ((product_snapshots."timestamp" >= '2020-06-10 01:13:03.909+02'::timestamp with time zone) AND (product_snapshots."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (product_snapshots.id = ANY ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047,424402048,424402049,424402050,424402238,424402051,424402239,424402052,424402053,424402054,424402055,424402056,424402240,424402057,424402058,424402059,424402060,424402241,424402242,424402061,424402243,424402244,424402062,424402063,424402245,424402064,424402246,424402065,424402066,424402067,424402068,424402069,424402247,424402248,424402249,424402070,424402071,424402072,424402073,424402074,424402250,424402075,424402076,424402251,424402077,424402252,424402253,424402078,424402254,424402079,424402255,424402256,424402080,424402081,424402082,424402257,424402083,424402084,424402258,424402259,424402085,424402086,424402087,424402088,424402089,424402090,424402091,424402092,424402093,424401911,424402260,424402094,424402095,424401912,424402096,424402097,424401913,424401914,424401915,424401916,424401917,424401918,424401919,424401920,424401921,424401922,424401923,424401924,424401925,424401926,424401927,424401928,424401929,424401930,424401931,424401932,424401933,424401934,424401935,424401936,424401937,424401938,424401939,424401940,424401941,424401942,424401943,424401944,424401945,424401946,424401947,424401948,424401949,424401951,424401950,424401952,424401953,424401954,424401955,424401956,424401957,424401958,424401959,424401960,424401961,424401962,424402098,424402099,424401963,424401964,424402100,424402101,424402102,424401965,424401966,424401967,424401968,424401969,424401970,424401971,424401972,424401973,424401974,424401975,424401976,424401977,424401978,424401979,424401980,424401981,424401982,424401983,424401984,424401985,424401986,424401987,424401988,424401989,424401990,424401991,424401992,424401993,424401994,424401995,424401996,424401997,424401998,424401999,424402000,424402261,424402001,424402002,424402003,424402004,424402005,424402103,424402104,424402006,424402105,424402007,424402106,424402107,424402262,424402108,424402263,424402109,424402110,424402111,424402112,424402113,424402114,424402115,424402116,424402117,424402118,424402264,424402265,424402119,424402120,424402121,424402122,424402123,424402124,424402125,424402126,424402127,424402128,424402266,424402267,424402129,424402130,424402131,424402268,424402269,424402132,424402133,424402134,424402270,424402271,424402135,424402136,424402272,424402137,424402138,424402139,424402140,424402141,424402273,424402142,424402143,424402144,424402145,424402146,424402147,424402274,424402148,424402275,424402149,424402276,424402150,424402151,424402277,424402152,424402153,424402154,424402278,424402155,424402279,424402156,424402280,424402157,424402158,424402159,424402160,424402161,424402162,424402163,424402164,424402281,424402165,424402166,424402167,424402168,424402282,424402169,424402775,424402170,424402171,424402172,424402173,424402174,424402175,424402176,424402283,424402177,424402178,424402179,424402180,424402181,424402182,424402183,424402776,424402184,424402185,424402186,424402777,424402778,424402969,424402779,424402780,424402970,424402971,424402781,424402972,424402973,424402782,424402974,424402975,424402783,424402784,424402785,424402976,424402977,424402786,424402978,424402787,424402979,424402980,424402788,424402981,424402789,424402982,424402790,424402791,424402792,424402983,424402793,424402984,424402794,424402795,424402796,424402985,424402986,424402987,424402797,424402988,424402798,424402799,424402800,424402989,424402990,424402801,424402802,424402991,424402803,424402992,424402804,424402806,424402805,424402993,424402807,424402808,424402994,424402809,424402995,424402810,424402811,424402812,424402996,424402997,424402813,424402814,424402815,424402816,424402998,424402817,424402818,424402819,424402999,424402820,424402821,424403000,424403001,424403002,424403003,424402822,424402823,424402824,424403004,424402825,424402826,424403005,424402827,424403006,424402828,424402829,424402832,424402830,424402831,424402833,424403007,424402834,424402835,424402836,424403008,424402837,424402838,424402839,424402840,424403009,424402841,424402842,424402843,424403010,424402844,424402845,424402846,424402847,424402848,424403011,424402849,424403012,424402850,424402851,424402852,424402853,424403013,424402854,424402855,424403014,424402856,424402857,424402858,424402859,424402860,424402861,424402862,424403015,424402863,424402864,424402865,424403016,424402866,424402867,424403017,424402868,424402869,424402870,424402871,424403018,424403019,424402872,424402873,424402874,424402875,424402876,424403020,424402877,424403021,424402878,424403022,424402879,424402880,424403023,424403024,424403025,424402881,424402882,424402883,424403026,424403027,424403028,424403029,424402885,424402884,424402886,424402887,424402888,424403030,424403031,424402889,424403032,424402890,424402891,424403033,424402892,424403034,424402893,424402894,424403036,424403035,424402895,424403037,424403038,424402896,424402897,424403039,424402898,424403040,424402899,424402900,424402901,424402902,424403041,424402903,424402904,424402905,424402906,424403042,424403043,424402907,424402908,424402909,424402910,424402911,424402912,424402913,424402914,424402915,424402917,424402916,424402918,424403044,424403045,424403046,424402919,424403047,424402920,424402921,424402922,424403048,424402923,424402924,424402925,424402926,424402927,424403049,424403050,424402928,424403051,424403052,424403053,424402929,424402930,424402931,424402933,424402932,424402934,424402935,424403054,424403055,424403056,424402936,424402937,424402938,424402939,424402940,424402941,424402942,424403057,424403058,424402943,424402944,424403059,424403060,424402945,424402946,424402947,424402948,424403061,424402949,424402950,424402951,424403062,424402952,424403063,424402953,424403064,424402954,424403065,424403066,424402955,424402956,424403067,424402957,424402958,424403068,424403069,424402959,424402960,424403070,424402962,424402961,424403071,424402963,424403118,424403072,424402964,424402965,424403073,424403119,424402966,424402967,424403074,424403120,424403121,424403122,424403350,424402968,424403123,424403124,424403125,424403126,424403127,424403128,424403351,424403129,424403130,424403131,424403132,424403133,424403134,424403135,424403136,424403137,424403352,424403138,424403353,424403139,424403140,424403141,424403142,424403143,424403144,424403145,424403354,424403146,424403147,424403355,424403148,424403149,424403150,424403356,424403151,424403152,424403153,424403357,424403154,424403358,424403155,424403156,424403359,424403360,424403157,424403361,424403158,424403159,424403160,424403362,424403161,424403162,424403363,424403163,424403164,424403165,424403364,424403166,424403167,424403365,424403168,424403169,424403366,424403170,424403171,424403367,424403368,424403172,424403173,424403369,424403174,424403175,424403176,424403177,424403178,424403179,424403180,424403181,424403182,424403183,424403184,424403185,424403370,424403371,424403186,424403187,424403188,424403372,424403189,424403190,424403191,424403373,424403192,424403374,424403193,424403194,424403375,424403195,424403196,424403197,424403198,424403376,424403199,424403200,424403201,424403202,424403377,424403203,424403204,424403205,424403378,424403206,424403207,424403379,424403208,424403380,424403209,424403210,424403211,424403212,424403213,424403214,424403215,424403381,424403216,424403382,424403217,424403218,424403220,424403219,424403221,424403222,424403383,424403223,424403384,424403224,424403225,424403385,424403226,424403386,424403387,424403227,424403228,424403388,424403229,424403230,424403389,424403231,424403232,424403233,424403234,424403390,424403235,424403236,424403237,424403238,424403239,424403391,424403240,424403241,424403392,424403242,424403243,424403244,424403393,424403245,424403246,424403247,424403248,424403250,424403249,424403251,424403252,424403253,424403254,424403394,424403255,424403395,424403256,424403257,424403396,424403397,424403258,424403398,424403399,424403259,424403260,424403261,424403400,424403262,424403263,424403264,424403401,424403265,424403266,424403267,424403268,424403269,424403270,424403271,424403402,424403272,424403273,424403274,424403275,424403403,424403276,424403404,424403277,424403278,424403279,424403405,424403280,424403281,424403282,424403283,424403284,424403285,424403286,424403406,424403287,424403288,424403407,424403408,424403289,424403290,424403291,424403292,424403409,424403410,424403411,424403293,424403412,424403295,424403294,424403296,424403413,424403297,424403298,424403299,424403300,424403301,424403302,424403303,424403304,424403414,424403415,424403416,424403305,424403306,424403417,424403307,424403308,424403309,424403310,424403311,424403312,424403313,424403314,424403418,424403315,424403316,424403419,424403317,424403318,424403319,424403320,424403321,424403322,424403323,424403324,424403325,424403326,424403327,424403420,424403328,424403329,424403330,424403421,424403331,424403332,424403333,424403334,424403335,424403336,424403337,424403338,424403339,424403422,424403340,424403541,424403341,424403342,424403343,424403344,424403542,424403790,424403543,424403544,424403545,424403546,424403547,424403548,424403549,424403550,424403551,424403552,424403553,424403554,424403555,424403556,424403557,424403558,424403559,424403560,424403561,424403562,424403791,424403563,424403564,424403565,424403566,424403792,424403567,424403793,424403568,424403569,424403570,424403794,424403571,424403572,424403573,424403574,424403575,424403576,424403795,424403577,424403578,424403579,424403796,424403580,424403581,424403582,424403583,424403584,424403585,424403586,424403587,424403588,424403589,424403590,424403797,424403591,424403592,424403593,424403594,424403595,424403596,424403597,424403598,424403599,424403600,424403601,424403602,424403603,424403604,424403605,424403798,424403606,424403607,424403799,424403608,424403609,424403610,424403800,424403611,424403612,424403613,424403801,424403614,424403802,424403803,424403615,424403616,424403617,424403618,424403619,424403620,424403621,424403622,424403623,424403804,424403805,424403624,424403625,424403626,424403627,424403628,424403629,424403630,424403631,424403632}'::bigint[])))
3. 2,250.690 2,250.690 ↓ 0.0 0 1

Index Scan using _hyper_67_7288_chunk_product_snapshots_timestamp_idx on _timescaledb_internal._hyper_67_7288_chunk (cost=0.43..175,230.63 rows=98 width=6) (actual time=2,250.690..2,250.690 rows=0 loops=1)

  • Output: _hyper_67_7288_chunk.ctid
  • Index Cond: ((_hyper_67_7288_chunk."timestamp" >= '2020-06-10 01:13:03.909+02'::timestamp with time zone) AND (_hyper_67_7288_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone))
  • Filter: (_hyper_67_7288_chunk.id = ANY ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047,424402048,424402049,424402050,424402238,424402051,424402239,424402052,424402053,424402054,424402055,424402056,424402240,424402057,424402058,424402059,424402060,424402241,424402242,424402061,424402243,424402244,424402062,424402063,424402245,424402064,424402246,424402065,424402066,424402067,424402068,424402069,424402247,424402248,424402249,424402070,424402071,424402072,424402073,424402074,424402250,424402075,424402076,424402251,424402077,424402252,424402253,424402078,424402254,424402079,424402255,424402256,424402080,424402081,424402082,424402257,424402083,424402084,424402258,424402259,424402085,424402086,424402087,424402088,424402089,424402090,424402091,424402092,424402093,424401911,424402260,424402094,424402095,424401912,424402096,424402097,424401913,424401914,424401915,424401916,424401917,424401918,424401919,424401920,424401921,424401922,424401923,424401924,424401925,424401926,424401927,424401928,424401929,424401930,424401931,424401932,424401933,424401934,424401935,424401936,424401937,424401938,424401939,424401940,424401941,424401942,424401943,424401944,424401945,424401946,424401947,424401948,424401949,424401951,424401950,424401952,424401953,424401954,424401955,424401956,424401957,424401958,424401959,424401960,424401961,424401962,424402098,424402099,424401963,424401964,424402100,424402101,424402102,424401965,424401966,424401967,424401968,424401969,424401970,424401971,424401972,424401973,424401974,424401975,424401976,424401977,424401978,424401979,424401980,424401981,424401982,424401983,424401984,424401985,424401986,424401987,424401988,424401989,424401990,424401991,424401992,424401993,424401994,424401995,424401996,424401997,424401998,424401999,424402000,424402261,424402001,424402002,424402003,424402004,424402005,424402103,424402104,424402006,424402105,424402007,424402106,424402107,424402262,424402108,424402263,424402109,424402110,424402111,424402112,424402113,424402114,424402115,424402116,424402117,424402118,424402264,424402265,424402119,424402120,424402121,424402122,424402123,424402124,424402125,424402126,424402127,424402128,424402266,424402267,424402129,424402130,424402131,424402268,424402269,424402132,424402133,424402134,424402270,424402271,424402135,424402136,424402272,424402137,424402138,424402139,424402140,424402141,424402273,424402142,424402143,424402144,424402145,424402146,424402147,424402274,424402148,424402275,424402149,424402276,424402150,424402151,424402277,424402152,424402153,424402154,424402278,424402155,424402279,424402156,424402280,424402157,424402158,424402159,424402160,424402161,424402162,424402163,424402164,424402281,424402165,424402166,424402167,424402168,424402282,424402169,424402775,424402170,424402171,424402172,424402173,424402174,424402175,424402176,424402283,424402177,424402178,424402179,424402180,424402181,424402182,424402183,424402776,424402184,424402185,424402186,424402777,424402778,424402969,424402779,424402780,424402970,424402971,424402781,424402972,424402973,424402782,424402974,424402975,424402783,424402784,424402785,424402976,424402977,424402786,424402978,424402787,424402979,424402980,424402788,424402981,424402789,424402982,424402790,424402791,424402792,424402983,424402793,424402984,424402794,424402795,424402796,424402985,424402986,424402987,424402797,424402988,424402798,424402799,424402800,424402989,424402990,424402801,424402802,424402991,424402803,424402992,424402804,424402806,424402805,424402993,424402807,424402808,424402994,424402809,424402995,424402810,424402811,424402812,424402996,424402997,424402813,424402814,424402815,424402816,424402998,424402817,424402818,424402819,424402999,424402820,424402821,424403000,424403001,424403002,424403003,424402822,424402823,424402824,424403004,424402825,424402826,424403005,424402827,424403006,424402828,424402829,424402832,424402830,424402831,424402833,424403007,424402834,424402835,424402836,424403008,424402837,424402838,424402839,424402840,424403009,424402841,424402842,424402843,424403010,424402844,424402845,424402846,424402847,424402848,424403011,424402849,424403012,424402850,424402851,424402852,424402853,424403013,424402854,424402855,424403014,424402856,424402857,424402858,424402859,424402860,424402861,424402862,424403015,424402863,424402864,424402865,424403016,424402866,424402867,424403017,424402868,424402869,424402870,424402871,424403018,424403019,424402872,424402873,424402874,424402875,424402876,424403020,424402877,424403021,424402878,424403022,424402879,424402880,424403023,424403024,424403025,424402881,424402882,424402883,424403026,424403027,424403028,424403029,424402885,424402884,424402886,424402887,424402888,424403030,424403031,424402889,424403032,424402890,424402891,424403033,424402892,424403034,424402893,424402894,424403036,424403035,424402895,424403037,424403038,424402896,424402897,424403039,424402898,424403040,424402899,424402900,424402901,424402902,424403041,424402903,424402904,424402905,424402906,424403042,424403043,424402907,424402908,424402909,424402910,424402911,424402912,424402913,424402914,424402915,424402917,424402916,424402918,424403044,424403045,424403046,424402919,424403047,424402920,424402921,424402922,424403048,424402923,424402924,424402925,424402926,424402927,424403049,424403050,424402928,424403051,424403052,424403053,424402929,424402930,424402931,424402933,424402932,424402934,424402935,424403054,424403055,424403056,424402936,424402937,424402938,424402939,424402940,424402941,424402942,424403057,424403058,424402943,424402944,424403059,424403060,424402945,424402946,424402947,424402948,424403061,424402949,424402950,424402951,424403062,424402952,424403063,424402953,424403064,424402954,424403065,424403066,424402955,424402956,424403067,424402957,424402958,424403068,424403069,424402959,424402960,424403070,424402962,424402961,424403071,424402963,424403118,424403072,424402964,424402965,424403073,424403119,424402966,424402967,424403074,424403120,424403121,424403122,424403350,424402968,424403123,424403124,424403125,424403126,424403127,424403128,424403351,424403129,424403130,424403131,424403132,424403133,424403134,424403135,424403136,424403137,424403352,424403138,424403353,424403139,424403140,424403141,424403142,424403143,424403144,424403145,424403354,424403146,424403147,424403355,424403148,424403149,424403150,424403356,424403151,424403152,424403153,424403357,424403154,424403358,424403155,424403156,424403359,424403360,424403157,424403361,424403158,424403159,424403160,424403362,424403161,424403162,424403363,424403163,424403164,424403165,424403364,424403166,424403167,424403365,424403168,424403169,424403366,424403170,424403171,424403367,424403368,424403172,424403173,424403369,424403174,424403175,424403176,424403177,424403178,424403179,424403180,424403181,424403182,424403183,424403184,424403185,424403370,424403371,424403186,424403187,424403188,424403372,424403189,424403190,424403191,424403373,424403192,424403374,424403193,424403194,424403375,424403195,424403196,424403197,424403198,424403376,424403199,424403200,424403201,424403202,424403377,424403203,424403204,424403205,424403378,424403206,424403207,424403379,424403208,424403380,424403209,424403210,424403211,424403212,424403213,424403214,424403215,424403381,424403216,424403382,424403217,424403218,424403220,424403219,424403221,424403222,424403383,424403223,424403384,424403224,424403225,424403385,424403226,424403386,424403387,424403227,424403228,424403388,424403229,424403230,424403389,424403231,424403232,424403233,424403234,424403390,424403235,424403236,424403237,424403238,424403239,424403391,424403240,424403241,424403392,424403242,424403243,424403244,424403393,424403245,424403246,424403247,424403248,424403250,424403249,424403251,424403252,424403253,424403254,424403394,424403255,424403395,424403256,424403257,424403396,424403397,424403258,424403398,424403399,424403259,424403260,424403261,424403400,424403262,424403263,424403264,424403401,424403265,424403266,424403267,424403268,424403269,424403270,424403271,424403402,424403272,424403273,424403274,424403275,424403403,424403276,424403404,424403277,424403278,424403279,424403405,424403280,424403281,424403282,424403283,424403284,424403285,424403286,424403406,424403287,424403288,424403407,424403408,424403289,424403290,424403291,424403292,424403409,424403410,424403411,424403293,424403412,424403295,424403294,424403296,424403413,424403297,424403298,424403299,424403300,424403301,424403302,424403303,424403304,424403414,424403415,424403416,424403305,424403306,424403417,424403307,424403308,424403309,424403310,424403311,424403312,424403313,424403314,424403418,424403315,424403316,424403419,424403317,424403318,424403319,424403320,424403321,424403322,424403323,424403324,424403325,424403326,424403327,424403420,424403328,424403329,424403330,424403421,424403331,424403332,424403333,424403334,424403335,424403336,424403337,424403338,424403339,424403422,424403340,424403541,424403341,424403342,424403343,424403344,424403542,424403790,424403543,424403544,424403545,424403546,424403547,424403548,424403549,424403550,424403551,424403552,424403553,424403554,424403555,424403556,424403557,424403558,424403559,424403560,424403561,424403562,424403791,424403563,424403564,424403565,424403566,424403792,424403567,424403793,424403568,424403569,424403570,424403794,424403571,424403572,424403573,424403574,424403575,424403576,424403795,424403577,424403578,424403579,424403796,424403580,424403581,424403582,424403583,424403584,424403585,424403586,424403587,424403588,424403589,424403590,424403797,424403591,424403592,424403593,424403594,424403595,424403596,424403597,424403598,424403599,424403600,424403601,424403602,424403603,424403604,424403605,424403798,424403606,424403607,424403799,424403608,424403609,424403610,424403800,424403611,424403612,424403613,424403801,424403614,424403802,424403803,424403615,424403616,424403617,424403618,424403619,424403620,424403621,424403622,424403623,424403804,424403805,424403624,424403625,424403626,424403627,424403628,424403629,424403630,424403631,424403632}'::bigint[]))
  • Rows Removed by Filter: 121,160
4. 9,471.083 9,471.083 ↑ 1.0 1,000 1

Seq Scan on _timescaledb_internal._hyper_67_7297_chunk (cost=0.00..1,648,661.22 rows=1,000 width=6) (actual time=2,544.410..9,471.083 rows=1,000 loops=1)

  • Output: _hyper_67_7297_chunk.ctid
  • Filter: ((_hyper_67_7297_chunk."timestamp" >= '2020-06-10 01:13:03.909+02'::timestamp with time zone) AND (_hyper_67_7297_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_67_7297_chunk.id = ANY ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047,424402048,424402049,424402050,424402238,424402051,424402239,424402052,424402053,424402054,424402055,424402056,424402240,424402057,424402058,424402059,424402060,424402241,424402242,424402061,424402243,424402244,424402062,424402063,424402245,424402064,424402246,424402065,424402066,424402067,424402068,424402069,424402247,424402248,424402249,424402070,424402071,424402072,424402073,424402074,424402250,424402075,424402076,424402251,424402077,424402252,424402253,424402078,424402254,424402079,424402255,424402256,424402080,424402081,424402082,424402257,424402083,424402084,424402258,424402259,424402085,424402086,424402087,424402088,424402089,424402090,424402091,424402092,424402093,424401911,424402260,424402094,424402095,424401912,424402096,424402097,424401913,424401914,424401915,424401916,424401917,424401918,424401919,424401920,424401921,424401922,424401923,424401924,424401925,424401926,424401927,424401928,424401929,424401930,424401931,424401932,424401933,424401934,424401935,424401936,424401937,424401938,424401939,424401940,424401941,424401942,424401943,424401944,424401945,424401946,424401947,424401948,424401949,424401951,424401950,424401952,424401953,424401954,424401955,424401956,424401957,424401958,424401959,424401960,424401961,424401962,424402098,424402099,424401963,424401964,424402100,424402101,424402102,424401965,424401966,424401967,424401968,424401969,424401970,424401971,424401972,424401973,424401974,424401975,424401976,424401977,424401978,424401979,424401980,424401981,424401982,424401983,424401984,424401985,424401986,424401987,424401988,424401989,424401990,424401991,424401992,424401993,424401994,424401995,424401996,424401997,424401998,424401999,424402000,424402261,424402001,424402002,424402003,424402004,424402005,424402103,424402104,424402006,424402105,424402007,424402106,424402107,424402262,424402108,424402263,424402109,424402110,424402111,424402112,424402113,424402114,424402115,424402116,424402117,424402118,424402264,424402265,424402119,424402120,424402121,424402122,424402123,424402124,424402125,424402126,424402127,424402128,424402266,424402267,424402129,424402130,424402131,424402268,424402269,424402132,424402133,424402134,424402270,424402271,424402135,424402136,424402272,424402137,424402138,424402139,424402140,424402141,424402273,424402142,424402143,424402144,424402145,424402146,424402147,424402274,424402148,424402275,424402149,424402276,424402150,424402151,424402277,424402152,424402153,424402154,424402278,424402155,424402279,424402156,424402280,424402157,424402158,424402159,424402160,424402161,424402162,424402163,424402164,424402281,424402165,424402166,424402167,424402168,424402282,424402169,424402775,424402170,424402171,424402172,424402173,424402174,424402175,424402176,424402283,424402177,424402178,424402179,424402180,424402181,424402182,424402183,424402776,424402184,424402185,424402186,424402777,424402778,424402969,424402779,424402780,424402970,424402971,424402781,424402972,424402973,424402782,424402974,424402975,424402783,424402784,424402785,424402976,424402977,424402786,424402978,424402787,424402979,424402980,424402788,424402981,424402789,424402982,424402790,424402791,424402792,424402983,424402793,424402984,424402794,424402795,424402796,424402985,424402986,424402987,424402797,424402988,424402798,424402799,424402800,424402989,424402990,424402801,424402802,424402991,424402803,424402992,424402804,424402806,424402805,424402993,424402807,424402808,424402994,424402809,424402995,424402810,424402811,424402812,424402996,424402997,424402813,424402814,424402815,424402816,424402998,424402817,424402818,424402819,424402999,424402820,424402821,424403000,424403001,424403002,424403003,424402822,424402823,424402824,424403004,424402825,424402826,424403005,424402827,424403006,424402828,424402829,424402832,424402830,424402831,424402833,424403007,424402834,424402835,424402836,424403008,424402837,424402838,424402839,424402840,424403009,424402841,424402842,424402843,424403010,424402844,424402845,424402846,424402847,424402848,424403011,424402849,424403012,424402850,424402851,424402852,424402853,424403013,424402854,424402855,424403014,424402856,424402857,424402858,424402859,424402860,424402861,424402862,424403015,424402863,424402864,424402865,424403016,424402866,424402867,424403017,424402868,424402869,424402870,424402871,424403018,424403019,424402872,424402873,424402874,424402875,424402876,424403020,424402877,424403021,424402878,424403022,424402879,424402880,424403023,424403024,424403025,424402881,424402882,424402883,424403026,424403027,424403028,424403029,424402885,424402884,424402886,424402887,424402888,424403030,424403031,424402889,424403032,424402890,424402891,424403033,424402892,424403034,424402893,424402894,424403036,424403035,424402895,424403037,424403038,424402896,424402897,424403039,424402898,424403040,424402899,424402900,424402901,424402902,424403041,424402903,424402904,424402905,424402906,424403042,424403043,424402907,424402908,424402909,424402910,424402911,424402912,424402913,424402914,424402915,424402917,424402916,424402918,424403044,424403045,424403046,424402919,424403047,424402920,424402921,424402922,424403048,424402923,424402924,424402925,424402926,424402927,424403049,424403050,424402928,424403051,424403052,424403053,424402929,424402930,424402931,424402933,424402932,424402934,424402935,424403054,424403055,424403056,424402936,424402937,424402938,424402939,424402940,424402941,424402942,424403057,424403058,424402943,424402944,424403059,424403060,424402945,424402946,424402947,424402948,424403061,424402949,424402950,424402951,424403062,424402952,424403063,424402953,424403064,424402954,424403065,424403066,424402955,424402956,424403067,424402957,424402958,424403068,424403069,424402959,424402960,424403070,424402962,424402961,424403071,424402963,424403118,424403072,424402964,424402965,424403073,424403119,424402966,424402967,424403074,424403120,424403121,424403122,424403350,424402968,424403123,424403124,424403125,424403126,424403127,424403128,424403351,424403129,424403130,424403131,424403132,424403133,424403134,424403135,424403136,424403137,424403352,424403138,424403353,424403139,424403140,424403141,424403142,424403143,424403144,424403145,424403354,424403146,424403147,424403355,424403148,424403149,424403150,424403356,424403151,424403152,424403153,424403357,424403154,424403358,424403155,424403156,424403359,424403360,424403157,424403361,424403158,424403159,424403160,424403362,424403161,424403162,424403363,424403163,424403164,424403165,424403364,424403166,424403167,424403365,424403168,424403169,424403366,424403170,424403171,424403367,424403368,424403172,424403173,424403369,424403174,424403175,424403176,424403177,424403178,424403179,424403180,424403181,424403182,424403183,424403184,424403185,424403370,424403371,424403186,424403187,424403188,424403372,424403189,424403190,424403191,424403373,424403192,424403374,424403193,424403194,424403375,424403195,424403196,424403197,424403198,424403376,424403199,424403200,424403201,424403202,424403377,424403203,424403204,424403205,424403378,424403206,424403207,424403379,424403208,424403380,424403209,424403210,424403211,424403212,424403213,424403214,424403215,424403381,424403216,424403382,424403217,424403218,424403220,424403219,424403221,424403222,424403383,424403223,424403384,424403224,424403225,424403385,424403226,424403386,424403387,424403227,424403228,424403388,424403229,424403230,424403389,424403231,424403232,424403233,424403234,424403390,424403235,424403236,424403237,424403238,424403239,424403391,424403240,424403241,424403392,424403242,424403243,424403244,424403393,424403245,424403246,424403247,424403248,424403250,424403249,424403251,424403252,424403253,424403254,424403394,424403255,424403395,424403256,424403257,424403396,424403397,424403258,424403398,424403399,424403259,424403260,424403261,424403400,424403262,424403263,424403264,424403401,424403265,424403266,424403267,424403268,424403269,424403270,424403271,424403402,424403272,424403273,424403274,424403275,424403403,424403276,424403404,424403277,424403278,424403279,424403405,424403280,424403281,424403282,424403283,424403284,424403285,424403286,424403406,424403287,424403288,424403407,424403408,424403289,424403290,424403291,424403292,424403409,424403410,424403411,424403293,424403412,424403295,424403294,424403296,424403413,424403297,424403298,424403299,424403300,424403301,424403302,424403303,424403304,424403414,424403415,424403416,424403305,424403306,424403417,424403307,424403308,424403309,424403310,424403311,424403312,424403313,424403314,424403418,424403315,424403316,424403419,424403317,424403318,424403319,424403320,424403321,424403322,424403323,424403324,424403325,424403326,424403327,424403420,424403328,424403329,424403330,424403421,424403331,424403332,424403333,424403334,424403335,424403336,424403337,424403338,424403339,424403422,424403340,424403541,424403341,424403342,424403343,424403344,424403542,424403790,424403543,424403544,424403545,424403546,424403547,424403548,424403549,424403550,424403551,424403552,424403553,424403554,424403555,424403556,424403557,424403558,424403559,424403560,424403561,424403562,424403791,424403563,424403564,424403565,424403566,424403792,424403567,424403793,424403568,424403569,424403570,424403794,424403571,424403572,424403573,424403574,424403575,424403576,424403795,424403577,424403578,424403579,424403796,424403580,424403581,424403582,424403583,424403584,424403585,424403586,424403587,424403588,424403589,424403590,424403797,424403591,424403592,424403593,424403594,424403595,424403596,424403597,424403598,424403599,424403600,424403601,424403602,424403603,424403604,424403605,424403798,424403606,424403607,424403799,424403608,424403609,424403610,424403800,424403611,424403612,424403613,424403801,424403614,424403802,424403803,424403615,424403616,424403617,424403618,424403619,424403620,424403621,424403622,424403623,424403804,424403805,424403624,424403625,424403626,424403627,424403628,424403629,424403630,424403631,424403632}'::bigint[])))
  • Rows Removed by Filter: 1,283,224
5. 19,191.591 19,191.591 ↓ 0.0 0 1

Seq Scan on _timescaledb_internal._hyper_67_7304_chunk (cost=0.00..3,036,889.93 rows=1,000 width=6) (actual time=19,191.591..19,191.591 rows=0 loops=1)

  • Output: _hyper_67_7304_chunk.ctid
  • Filter: ((_hyper_67_7304_chunk."timestamp" >= '2020-06-10 01:13:03.909+02'::timestamp with time zone) AND (_hyper_67_7304_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_67_7304_chunk.id = ANY ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047,424402048,424402049,424402050,424402238,424402051,424402239,424402052,424402053,424402054,424402055,424402056,424402240,424402057,424402058,424402059,424402060,424402241,424402242,424402061,424402243,424402244,424402062,424402063,424402245,424402064,424402246,424402065,424402066,424402067,424402068,424402069,424402247,424402248,424402249,424402070,424402071,424402072,424402073,424402074,424402250,424402075,424402076,424402251,424402077,424402252,424402253,424402078,424402254,424402079,424402255,424402256,424402080,424402081,424402082,424402257,424402083,424402084,424402258,424402259,424402085,424402086,424402087,424402088,424402089,424402090,424402091,424402092,424402093,424401911,424402260,424402094,424402095,424401912,424402096,424402097,424401913,424401914,424401915,424401916,424401917,424401918,424401919,424401920,424401921,424401922,424401923,424401924,424401925,424401926,424401927,424401928,424401929,424401930,424401931,424401932,424401933,424401934,424401935,424401936,424401937,424401938,424401939,424401940,424401941,424401942,424401943,424401944,424401945,424401946,424401947,424401948,424401949,424401951,424401950,424401952,424401953,424401954,424401955,424401956,424401957,424401958,424401959,424401960,424401961,424401962,424402098,424402099,424401963,424401964,424402100,424402101,424402102,424401965,424401966,424401967,424401968,424401969,424401970,424401971,424401972,424401973,424401974,424401975,424401976,424401977,424401978,424401979,424401980,424401981,424401982,424401983,424401984,424401985,424401986,424401987,424401988,424401989,424401990,424401991,424401992,424401993,424401994,424401995,424401996,424401997,424401998,424401999,424402000,424402261,424402001,424402002,424402003,424402004,424402005,424402103,424402104,424402006,424402105,424402007,424402106,424402107,424402262,424402108,424402263,424402109,424402110,424402111,424402112,424402113,424402114,424402115,424402116,424402117,424402118,424402264,424402265,424402119,424402120,424402121,424402122,424402123,424402124,424402125,424402126,424402127,424402128,424402266,424402267,424402129,424402130,424402131,424402268,424402269,424402132,424402133,424402134,424402270,424402271,424402135,424402136,424402272,424402137,424402138,424402139,424402140,424402141,424402273,424402142,424402143,424402144,424402145,424402146,424402147,424402274,424402148,424402275,424402149,424402276,424402150,424402151,424402277,424402152,424402153,424402154,424402278,424402155,424402279,424402156,424402280,424402157,424402158,424402159,424402160,424402161,424402162,424402163,424402164,424402281,424402165,424402166,424402167,424402168,424402282,424402169,424402775,424402170,424402171,424402172,424402173,424402174,424402175,424402176,424402283,424402177,424402178,424402179,424402180,424402181,424402182,424402183,424402776,424402184,424402185,424402186,424402777,424402778,424402969,424402779,424402780,424402970,424402971,424402781,424402972,424402973,424402782,424402974,424402975,424402783,424402784,424402785,424402976,424402977,424402786,424402978,424402787,424402979,424402980,424402788,424402981,424402789,424402982,424402790,424402791,424402792,424402983,424402793,424402984,424402794,424402795,424402796,424402985,424402986,424402987,424402797,424402988,424402798,424402799,424402800,424402989,424402990,424402801,424402802,424402991,424402803,424402992,424402804,424402806,424402805,424402993,424402807,424402808,424402994,424402809,424402995,424402810,424402811,424402812,424402996,424402997,424402813,424402814,424402815,424402816,424402998,424402817,424402818,424402819,424402999,424402820,424402821,424403000,424403001,424403002,424403003,424402822,424402823,424402824,424403004,424402825,424402826,424403005,424402827,424403006,424402828,424402829,424402832,424402830,424402831,424402833,424403007,424402834,424402835,424402836,424403008,424402837,424402838,424402839,424402840,424403009,424402841,424402842,424402843,424403010,424402844,424402845,424402846,424402847,424402848,424403011,424402849,424403012,424402850,424402851,424402852,424402853,424403013,424402854,424402855,424403014,424402856,424402857,424402858,424402859,424402860,424402861,424402862,424403015,424402863,424402864,424402865,424403016,424402866,424402867,424403017,424402868,424402869,424402870,424402871,424403018,424403019,424402872,424402873,424402874,424402875,424402876,424403020,424402877,424403021,424402878,424403022,424402879,424402880,424403023,424403024,424403025,424402881,424402882,424402883,424403026,424403027,424403028,424403029,424402885,424402884,424402886,424402887,424402888,424403030,424403031,424402889,424403032,424402890,424402891,424403033,424402892,424403034,424402893,424402894,424403036,424403035,424402895,424403037,424403038,424402896,424402897,424403039,424402898,424403040,424402899,424402900,424402901,424402902,424403041,424402903,424402904,424402905,424402906,424403042,424403043,424402907,424402908,424402909,424402910,424402911,424402912,424402913,424402914,424402915,424402917,424402916,424402918,424403044,424403045,424403046,424402919,424403047,424402920,424402921,424402922,424403048,424402923,424402924,424402925,424402926,424402927,424403049,424403050,424402928,424403051,424403052,424403053,424402929,424402930,424402931,424402933,424402932,424402934,424402935,424403054,424403055,424403056,424402936,424402937,424402938,424402939,424402940,424402941,424402942,424403057,424403058,424402943,424402944,424403059,424403060,424402945,424402946,424402947,424402948,424403061,424402949,424402950,424402951,424403062,424402952,424403063,424402953,424403064,424402954,424403065,424403066,424402955,424402956,424403067,424402957,424402958,424403068,424403069,424402959,424402960,424403070,424402962,424402961,424403071,424402963,424403118,424403072,424402964,424402965,424403073,424403119,424402966,424402967,424403074,424403120,424403121,424403122,424403350,424402968,424403123,424403124,424403125,424403126,424403127,424403128,424403351,424403129,424403130,424403131,424403132,424403133,424403134,424403135,424403136,424403137,424403352,424403138,424403353,424403139,424403140,424403141,424403142,424403143,424403144,424403145,424403354,424403146,424403147,424403355,424403148,424403149,424403150,424403356,424403151,424403152,424403153,424403357,424403154,424403358,424403155,424403156,424403359,424403360,424403157,424403361,424403158,424403159,424403160,424403362,424403161,424403162,424403363,424403163,424403164,424403165,424403364,424403166,424403167,424403365,424403168,424403169,424403366,424403170,424403171,424403367,424403368,424403172,424403173,424403369,424403174,424403175,424403176,424403177,424403178,424403179,424403180,424403181,424403182,424403183,424403184,424403185,424403370,424403371,424403186,424403187,424403188,424403372,424403189,424403190,424403191,424403373,424403192,424403374,424403193,424403194,424403375,424403195,424403196,424403197,424403198,424403376,424403199,424403200,424403201,424403202,424403377,424403203,424403204,424403205,424403378,424403206,424403207,424403379,424403208,424403380,424403209,424403210,424403211,424403212,424403213,424403214,424403215,424403381,424403216,424403382,424403217,424403218,424403220,424403219,424403221,424403222,424403383,424403223,424403384,424403224,424403225,424403385,424403226,424403386,424403387,424403227,424403228,424403388,424403229,424403230,424403389,424403231,424403232,424403233,424403234,424403390,424403235,424403236,424403237,424403238,424403239,424403391,424403240,424403241,424403392,424403242,424403243,424403244,424403393,424403245,424403246,424403247,424403248,424403250,424403249,424403251,424403252,424403253,424403254,424403394,424403255,424403395,424403256,424403257,424403396,424403397,424403258,424403398,424403399,424403259,424403260,424403261,424403400,424403262,424403263,424403264,424403401,424403265,424403266,424403267,424403268,424403269,424403270,424403271,424403402,424403272,424403273,424403274,424403275,424403403,424403276,424403404,424403277,424403278,424403279,424403405,424403280,424403281,424403282,424403283,424403284,424403285,424403286,424403406,424403287,424403288,424403407,424403408,424403289,424403290,424403291,424403292,424403409,424403410,424403411,424403293,424403412,424403295,424403294,424403296,424403413,424403297,424403298,424403299,424403300,424403301,424403302,424403303,424403304,424403414,424403415,424403416,424403305,424403306,424403417,424403307,424403308,424403309,424403310,424403311,424403312,424403313,424403314,424403418,424403315,424403316,424403419,424403317,424403318,424403319,424403320,424403321,424403322,424403323,424403324,424403325,424403326,424403327,424403420,424403328,424403329,424403330,424403421,424403331,424403332,424403333,424403334,424403335,424403336,424403337,424403338,424403339,424403422,424403340,424403541,424403341,424403342,424403343,424403344,424403542,424403790,424403543,424403544,424403545,424403546,424403547,424403548,424403549,424403550,424403551,424403552,424403553,424403554,424403555,424403556,424403557,424403558,424403559,424403560,424403561,424403562,424403791,424403563,424403564,424403565,424403566,424403792,424403567,424403793,424403568,424403569,424403570,424403794,424403571,424403572,424403573,424403574,424403575,424403576,424403795,424403577,424403578,424403579,424403796,424403580,424403581,424403582,424403583,424403584,424403585,424403586,424403587,424403588,424403589,424403590,424403797,424403591,424403592,424403593,424403594,424403595,424403596,424403597,424403598,424403599,424403600,424403601,424403602,424403603,424403604,424403605,424403798,424403606,424403607,424403799,424403608,424403609,424403610,424403800,424403611,424403612,424403613,424403801,424403614,424403802,424403803,424403615,424403616,424403617,424403618,424403619,424403620,424403621,424403622,424403623,424403804,424403805,424403624,424403625,424403626,424403627,424403628,424403629,424403630,424403631,424403632}'::bigint[])))
  • Rows Removed by Filter: 2,624,086
6. 9,760.307 9,760.307 ↓ 0.0 0 1

Seq Scan on _timescaledb_internal._hyper_67_7360_chunk (cost=0.00..1,646,632.43 rows=1,000 width=6) (actual time=9,760.307..9,760.307 rows=0 loops=1)

  • Output: _hyper_67_7360_chunk.ctid
  • Filter: ((_hyper_67_7360_chunk."timestamp" >= '2020-06-10 01:13:03.909+02'::timestamp with time zone) AND (_hyper_67_7360_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_67_7360_chunk.id = ANY ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047,424402048,424402049,424402050,424402238,424402051,424402239,424402052,424402053,424402054,424402055,424402056,424402240,424402057,424402058,424402059,424402060,424402241,424402242,424402061,424402243,424402244,424402062,424402063,424402245,424402064,424402246,424402065,424402066,424402067,424402068,424402069,424402247,424402248,424402249,424402070,424402071,424402072,424402073,424402074,424402250,424402075,424402076,424402251,424402077,424402252,424402253,424402078,424402254,424402079,424402255,424402256,424402080,424402081,424402082,424402257,424402083,424402084,424402258,424402259,424402085,424402086,424402087,424402088,424402089,424402090,424402091,424402092,424402093,424401911,424402260,424402094,424402095,424401912,424402096,424402097,424401913,424401914,424401915,424401916,424401917,424401918,424401919,424401920,424401921,424401922,424401923,424401924,424401925,424401926,424401927,424401928,424401929,424401930,424401931,424401932,424401933,424401934,424401935,424401936,424401937,424401938,424401939,424401940,424401941,424401942,424401943,424401944,424401945,424401946,424401947,424401948,424401949,424401951,424401950,424401952,424401953,424401954,424401955,424401956,424401957,424401958,424401959,424401960,424401961,424401962,424402098,424402099,424401963,424401964,424402100,424402101,424402102,424401965,424401966,424401967,424401968,424401969,424401970,424401971,424401972,424401973,424401974,424401975,424401976,424401977,424401978,424401979,424401980,424401981,424401982,424401983,424401984,424401985,424401986,424401987,424401988,424401989,424401990,424401991,424401992,424401993,424401994,424401995,424401996,424401997,424401998,424401999,424402000,424402261,424402001,424402002,424402003,424402004,424402005,424402103,424402104,424402006,424402105,424402007,424402106,424402107,424402262,424402108,424402263,424402109,424402110,424402111,424402112,424402113,424402114,424402115,424402116,424402117,424402118,424402264,424402265,424402119,424402120,424402121,424402122,424402123,424402124,424402125,424402126,424402127,424402128,424402266,424402267,424402129,424402130,424402131,424402268,424402269,424402132,424402133,424402134,424402270,424402271,424402135,424402136,424402272,424402137,424402138,424402139,424402140,424402141,424402273,424402142,424402143,424402144,424402145,424402146,424402147,424402274,424402148,424402275,424402149,424402276,424402150,424402151,424402277,424402152,424402153,424402154,424402278,424402155,424402279,424402156,424402280,424402157,424402158,424402159,424402160,424402161,424402162,424402163,424402164,424402281,424402165,424402166,424402167,424402168,424402282,424402169,424402775,424402170,424402171,424402172,424402173,424402174,424402175,424402176,424402283,424402177,424402178,424402179,424402180,424402181,424402182,424402183,424402776,424402184,424402185,424402186,424402777,424402778,424402969,424402779,424402780,424402970,424402971,424402781,424402972,424402973,424402782,424402974,424402975,424402783,424402784,424402785,424402976,424402977,424402786,424402978,424402787,424402979,424402980,424402788,424402981,424402789,424402982,424402790,424402791,424402792,424402983,424402793,424402984,424402794,424402795,424402796,424402985,424402986,424402987,424402797,424402988,424402798,424402799,424402800,424402989,424402990,424402801,424402802,424402991,424402803,424402992,424402804,424402806,424402805,424402993,424402807,424402808,424402994,424402809,424402995,424402810,424402811,424402812,424402996,424402997,424402813,424402814,424402815,424402816,424402998,424402817,424402818,424402819,424402999,424402820,424402821,424403000,424403001,424403002,424403003,424402822,424402823,424402824,424403004,424402825,424402826,424403005,424402827,424403006,424402828,424402829,424402832,424402830,424402831,424402833,424403007,424402834,424402835,424402836,424403008,424402837,424402838,424402839,424402840,424403009,424402841,424402842,424402843,424403010,424402844,424402845,424402846,424402847,424402848,424403011,424402849,424403012,424402850,424402851,424402852,424402853,424403013,424402854,424402855,424403014,424402856,424402857,424402858,424402859,424402860,424402861,424402862,424403015,424402863,424402864,424402865,424403016,424402866,424402867,424403017,424402868,424402869,424402870,424402871,424403018,424403019,424402872,424402873,424402874,424402875,424402876,424403020,424402877,424403021,424402878,424403022,424402879,424402880,424403023,424403024,424403025,424402881,424402882,424402883,424403026,424403027,424403028,424403029,424402885,424402884,424402886,424402887,424402888,424403030,424403031,424402889,424403032,424402890,424402891,424403033,424402892,424403034,424402893,424402894,424403036,424403035,424402895,424403037,424403038,424402896,424402897,424403039,424402898,424403040,424402899,424402900,424402901,424402902,424403041,424402903,424402904,424402905,424402906,424403042,424403043,424402907,424402908,424402909,424402910,424402911,424402912,424402913,424402914,424402915,424402917,424402916,424402918,424403044,424403045,424403046,424402919,424403047,424402920,424402921,424402922,424403048,424402923,424402924,424402925,424402926,424402927,424403049,424403050,424402928,424403051,424403052,424403053,424402929,424402930,424402931,424402933,424402932,424402934,424402935,424403054,424403055,424403056,424402936,424402937,424402938,424402939,424402940,424402941,424402942,424403057,424403058,424402943,424402944,424403059,424403060,424402945,424402946,424402947,424402948,424403061,424402949,424402950,424402951,424403062,424402952,424403063,424402953,424403064,424402954,424403065,424403066,424402955,424402956,424403067,424402957,424402958,424403068,424403069,424402959,424402960,424403070,424402962,424402961,424403071,424402963,424403118,424403072,424402964,424402965,424403073,424403119,424402966,424402967,424403074,424403120,424403121,424403122,424403350,424402968,424403123,424403124,424403125,424403126,424403127,424403128,424403351,424403129,424403130,424403131,424403132,424403133,424403134,424403135,424403136,424403137,424403352,424403138,424403353,424403139,424403140,424403141,424403142,424403143,424403144,424403145,424403354,424403146,424403147,424403355,424403148,424403149,424403150,424403356,424403151,424403152,424403153,424403357,424403154,424403358,424403155,424403156,424403359,424403360,424403157,424403361,424403158,424403159,424403160,424403362,424403161,424403162,424403363,424403163,424403164,424403165,424403364,424403166,424403167,424403365,424403168,424403169,424403366,424403170,424403171,424403367,424403368,424403172,424403173,424403369,424403174,424403175,424403176,424403177,424403178,424403179,424403180,424403181,424403182,424403183,424403184,424403185,424403370,424403371,424403186,424403187,424403188,424403372,424403189,424403190,424403191,424403373,424403192,424403374,424403193,424403194,424403375,424403195,424403196,424403197,424403198,424403376,424403199,424403200,424403201,424403202,424403377,424403203,424403204,424403205,424403378,424403206,424403207,424403379,424403208,424403380,424403209,424403210,424403211,424403212,424403213,424403214,424403215,424403381,424403216,424403382,424403217,424403218,424403220,424403219,424403221,424403222,424403383,424403223,424403384,424403224,424403225,424403385,424403226,424403386,424403387,424403227,424403228,424403388,424403229,424403230,424403389,424403231,424403232,424403233,424403234,424403390,424403235,424403236,424403237,424403238,424403239,424403391,424403240,424403241,424403392,424403242,424403243,424403244,424403393,424403245,424403246,424403247,424403248,424403250,424403249,424403251,424403252,424403253,424403254,424403394,424403255,424403395,424403256,424403257,424403396,424403397,424403258,424403398,424403399,424403259,424403260,424403261,424403400,424403262,424403263,424403264,424403401,424403265,424403266,424403267,424403268,424403269,424403270,424403271,424403402,424403272,424403273,424403274,424403275,424403403,424403276,424403404,424403277,424403278,424403279,424403405,424403280,424403281,424403282,424403283,424403284,424403285,424403286,424403406,424403287,424403288,424403407,424403408,424403289,424403290,424403291,424403292,424403409,424403410,424403411,424403293,424403412,424403295,424403294,424403296,424403413,424403297,424403298,424403299,424403300,424403301,424403302,424403303,424403304,424403414,424403415,424403416,424403305,424403306,424403417,424403307,424403308,424403309,424403310,424403311,424403312,424403313,424403314,424403418,424403315,424403316,424403419,424403317,424403318,424403319,424403320,424403321,424403322,424403323,424403324,424403325,424403326,424403327,424403420,424403328,424403329,424403330,424403421,424403331,424403332,424403333,424403334,424403335,424403336,424403337,424403338,424403339,424403422,424403340,424403541,424403341,424403342,424403343,424403344,424403542,424403790,424403543,424403544,424403545,424403546,424403547,424403548,424403549,424403550,424403551,424403552,424403553,424403554,424403555,424403556,424403557,424403558,424403559,424403560,424403561,424403562,424403791,424403563,424403564,424403565,424403566,424403792,424403567,424403793,424403568,424403569,424403570,424403794,424403571,424403572,424403573,424403574,424403575,424403576,424403795,424403577,424403578,424403579,424403796,424403580,424403581,424403582,424403583,424403584,424403585,424403586,424403587,424403588,424403589,424403590,424403797,424403591,424403592,424403593,424403594,424403595,424403596,424403597,424403598,424403599,424403600,424403601,424403602,424403603,424403604,424403605,424403798,424403606,424403607,424403799,424403608,424403609,424403610,424403800,424403611,424403612,424403613,424403801,424403614,424403802,424403803,424403615,424403616,424403617,424403618,424403619,424403620,424403621,424403622,424403623,424403804,424403805,424403624,424403625,424403626,424403627,424403628,424403629,424403630,424403631,424403632}'::bigint[])))
  • Rows Removed by Filter: 1,323,711
7. 14,378.426 14,378.426 ↓ 0.0 0 1

Index Scan using _hyper_67_7431_chunk_product_snapshots_timestamp_idx on _timescaledb_internal._hyper_67_7431_chunk (cost=0.43..1,176,426.49 rows=784 width=6) (actual time=14,378.426..14,378.426 rows=0 loops=1)

  • Output: _hyper_67_7431_chunk.ctid
  • Index Cond: ((_hyper_67_7431_chunk."timestamp" >= '2020-06-10 01:13:03.909+02'::timestamp with time zone) AND (_hyper_67_7431_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone))
  • Filter: (_hyper_67_7431_chunk.id = ANY ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047,424402048,424402049,424402050,424402238,424402051,424402239,424402052,424402053,424402054,424402055,424402056,424402240,424402057,424402058,424402059,424402060,424402241,424402242,424402061,424402243,424402244,424402062,424402063,424402245,424402064,424402246,424402065,424402066,424402067,424402068,424402069,424402247,424402248,424402249,424402070,424402071,424402072,424402073,424402074,424402250,424402075,424402076,424402251,424402077,424402252,424402253,424402078,424402254,424402079,424402255,424402256,424402080,424402081,424402082,424402257,424402083,424402084,424402258,424402259,424402085,424402086,424402087,424402088,424402089,424402090,424402091,424402092,424402093,424401911,424402260,424402094,424402095,424401912,424402096,424402097,424401913,424401914,424401915,424401916,424401917,424401918,424401919,424401920,424401921,424401922,424401923,424401924,424401925,424401926,424401927,424401928,424401929,424401930,424401931,424401932,424401933,424401934,424401935,424401936,424401937,424401938,424401939,424401940,424401941,424401942,424401943,424401944,424401945,424401946,424401947,424401948,424401949,424401951,424401950,424401952,424401953,424401954,424401955,424401956,424401957,424401958,424401959,424401960,424401961,424401962,424402098,424402099,424401963,424401964,424402100,424402101,424402102,424401965,424401966,424401967,424401968,424401969,424401970,424401971,424401972,424401973,424401974,424401975,424401976,424401977,424401978,424401979,424401980,424401981,424401982,424401983,424401984,424401985,424401986,424401987,424401988,424401989,424401990,424401991,424401992,424401993,424401994,424401995,424401996,424401997,424401998,424401999,424402000,424402261,424402001,424402002,424402003,424402004,424402005,424402103,424402104,424402006,424402105,424402007,424402106,424402107,424402262,424402108,424402263,424402109,424402110,424402111,424402112,424402113,424402114,424402115,424402116,424402117,424402118,424402264,424402265,424402119,424402120,424402121,424402122,424402123,424402124,424402125,424402126,424402127,424402128,424402266,424402267,424402129,424402130,424402131,424402268,424402269,424402132,424402133,424402134,424402270,424402271,424402135,424402136,424402272,424402137,424402138,424402139,424402140,424402141,424402273,424402142,424402143,424402144,424402145,424402146,424402147,424402274,424402148,424402275,424402149,424402276,424402150,424402151,424402277,424402152,424402153,424402154,424402278,424402155,424402279,424402156,424402280,424402157,424402158,424402159,424402160,424402161,424402162,424402163,424402164,424402281,424402165,424402166,424402167,424402168,424402282,424402169,424402775,424402170,424402171,424402172,424402173,424402174,424402175,424402176,424402283,424402177,424402178,424402179,424402180,424402181,424402182,424402183,424402776,424402184,424402185,424402186,424402777,424402778,424402969,424402779,424402780,424402970,424402971,424402781,424402972,424402973,424402782,424402974,424402975,424402783,424402784,424402785,424402976,424402977,424402786,424402978,424402787,424402979,424402980,424402788,424402981,424402789,424402982,424402790,424402791,424402792,424402983,424402793,424402984,424402794,424402795,424402796,424402985,424402986,424402987,424402797,424402988,424402798,424402799,424402800,424402989,424402990,424402801,424402802,424402991,424402803,424402992,424402804,424402806,424402805,424402993,424402807,424402808,424402994,424402809,424402995,424402810,424402811,424402812,424402996,424402997,424402813,424402814,424402815,424402816,424402998,424402817,424402818,424402819,424402999,424402820,424402821,424403000,424403001,424403002,424403003,424402822,424402823,424402824,424403004,424402825,424402826,424403005,424402827,424403006,424402828,424402829,424402832,424402830,424402831,424402833,424403007,424402834,424402835,424402836,424403008,424402837,424402838,424402839,424402840,424403009,424402841,424402842,424402843,424403010,424402844,424402845,424402846,424402847,424402848,424403011,424402849,424403012,424402850,424402851,424402852,424402853,424403013,424402854,424402855,424403014,424402856,424402857,424402858,424402859,424402860,424402861,424402862,424403015,424402863,424402864,424402865,424403016,424402866,424402867,424403017,424402868,424402869,424402870,424402871,424403018,424403019,424402872,424402873,424402874,424402875,424402876,424403020,424402877,424403021,424402878,424403022,424402879,424402880,424403023,424403024,424403025,424402881,424402882,424402883,424403026,424403027,424403028,424403029,424402885,424402884,424402886,424402887,424402888,424403030,424403031,424402889,424403032,424402890,424402891,424403033,424402892,424403034,424402893,424402894,424403036,424403035,424402895,424403037,424403038,424402896,424402897,424403039,424402898,424403040,424402899,424402900,424402901,424402902,424403041,424402903,424402904,424402905,424402906,424403042,424403043,424402907,424402908,424402909,424402910,424402911,424402912,424402913,424402914,424402915,424402917,424402916,424402918,424403044,424403045,424403046,424402919,424403047,424402920,424402921,424402922,424403048,424402923,424402924,424402925,424402926,424402927,424403049,424403050,424402928,424403051,424403052,424403053,424402929,424402930,424402931,424402933,424402932,424402934,424402935,424403054,424403055,424403056,424402936,424402937,424402938,424402939,424402940,424402941,424402942,424403057,424403058,424402943,424402944,424403059,424403060,424402945,424402946,424402947,424402948,424403061,424402949,424402950,424402951,424403062,424402952,424403063,424402953,424403064,424402954,424403065,424403066,424402955,424402956,424403067,424402957,424402958,424403068,424403069,424402959,424402960,424403070,424402962,424402961,424403071,424402963,424403118,424403072,424402964,424402965,424403073,424403119,424402966,424402967,424403074,424403120,424403121,424403122,424403350,424402968,424403123,424403124,424403125,424403126,424403127,424403128,424403351,424403129,424403130,424403131,424403132,424403133,424403134,424403135,424403136,424403137,424403352,424403138,424403353,424403139,424403140,424403141,424403142,424403143,424403144,424403145,424403354,424403146,424403147,424403355,424403148,424403149,424403150,424403356,424403151,424403152,424403153,424403357,424403154,424403358,424403155,424403156,424403359,424403360,424403157,424403361,424403158,424403159,424403160,424403362,424403161,424403162,424403363,424403163,424403164,424403165,424403364,424403166,424403167,424403365,424403168,424403169,424403366,424403170,424403171,424403367,424403368,424403172,424403173,424403369,424403174,424403175,424403176,424403177,424403178,424403179,424403180,424403181,424403182,424403183,424403184,424403185,424403370,424403371,424403186,424403187,424403188,424403372,424403189,424403190,424403191,424403373,424403192,424403374,424403193,424403194,424403375,424403195,424403196,424403197,424403198,424403376,424403199,424403200,424403201,424403202,424403377,424403203,424403204,424403205,424403378,424403206,424403207,424403379,424403208,424403380,424403209,424403210,424403211,424403212,424403213,424403214,424403215,424403381,424403216,424403382,424403217,424403218,424403220,424403219,424403221,424403222,424403383,424403223,424403384,424403224,424403225,424403385,424403226,424403386,424403387,424403227,424403228,424403388,424403229,424403230,424403389,424403231,424403232,424403233,424403234,424403390,424403235,424403236,424403237,424403238,424403239,424403391,424403240,424403241,424403392,424403242,424403243,424403244,424403393,424403245,424403246,424403247,424403248,424403250,424403249,424403251,424403252,424403253,424403254,424403394,424403255,424403395,424403256,424403257,424403396,424403397,424403258,424403398,424403399,424403259,424403260,424403261,424403400,424403262,424403263,424403264,424403401,424403265,424403266,424403267,424403268,424403269,424403270,424403271,424403402,424403272,424403273,424403274,424403275,424403403,424403276,424403404,424403277,424403278,424403279,424403405,424403280,424403281,424403282,424403283,424403284,424403285,424403286,424403406,424403287,424403288,424403407,424403408,424403289,424403290,424403291,424403292,424403409,424403410,424403411,424403293,424403412,424403295,424403294,424403296,424403413,424403297,424403298,424403299,424403300,424403301,424403302,424403303,424403304,424403414,424403415,424403416,424403305,424403306,424403417,424403307,424403308,424403309,424403310,424403311,424403312,424403313,424403314,424403418,424403315,424403316,424403419,424403317,424403318,424403319,424403320,424403321,424403322,424403323,424403324,424403325,424403326,424403327,424403420,424403328,424403329,424403330,424403421,424403331,424403332,424403333,424403334,424403335,424403336,424403337,424403338,424403339,424403422,424403340,424403541,424403341,424403342,424403343,424403344,424403542,424403790,424403543,424403544,424403545,424403546,424403547,424403548,424403549,424403550,424403551,424403552,424403553,424403554,424403555,424403556,424403557,424403558,424403559,424403560,424403561,424403562,424403791,424403563,424403564,424403565,424403566,424403792,424403567,424403793,424403568,424403569,424403570,424403794,424403571,424403572,424403573,424403574,424403575,424403576,424403795,424403577,424403578,424403579,424403796,424403580,424403581,424403582,424403583,424403584,424403585,424403586,424403587,424403588,424403589,424403590,424403797,424403591,424403592,424403593,424403594,424403595,424403596,424403597,424403598,424403599,424403600,424403601,424403602,424403603,424403604,424403605,424403798,424403606,424403607,424403799,424403608,424403609,424403610,424403800,424403611,424403612,424403613,424403801,424403614,424403802,424403803,424403615,424403616,424403617,424403618,424403619,424403620,424403621,424403622,424403623,424403804,424403805,424403624,424403625,424403626,424403627,424403628,424403629,424403630,424403631,424403632}'::bigint[]))
  • Rows Removed by Filter: 932,305
Planning time : 17.066 ms
Execution time : 55,053.073 ms