explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p2zo

Settings
# exclusive inclusive rows x rows loops node
1. 244.403 217,632.824 ↓ 0.0 0 1

Gather (cost=1,000.00..4,583,603.01 rows=1,130,658 width=0) (actual time=217,403.284..217,632.824 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=927 read=3,832,432
2. 0.014 217,388.421 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.00..4,469,537.21 rows=471,108 width=0) (actual time=217,388.421..217,388.421 rows=0 loops=3)

  • Buffers: shared hit=927 read=3,832,432
  • Worker 0: actual time=217,384.638..217384.638 rows=0 loops=1
  • Buffers: shared hit=773 read=1,301,436
  • Worker 1: actual time=217,384.868..217384.868 rows=0 loops=1
  • Buffers: shared hit=133 read=1,423,680
3. 0.355 0.355 ↓ 0.0 0 1 / 3

Parallel Index Scan using _hyper_70_7436_chunk_offers_timestamp_idx on _timescaledb_internal._hyper_70_7436_chunk (cost=0.42..2.64 rows=1 width=0) (actual time=1.064..1.064 rows=0 loops=1)

  • Index Cond: ((_hyper_70_7436_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7436_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone))
  • Filter: (_hyper_70_7436_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[])
  • Buffers: shared hit=3 read=1
  • Worker 1: actual time=1.064..1.064 rows=0 loops=1
  • Buffers: shared hit=3 read=1
4. 30,047.623 30,047.623 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7299_chunk (cost=0.00..544,914.51 rows=75,555 width=0) (actual time=90,142.869..90,142.870 rows=0 loops=1)

  • Filter: ((_hyper_70_7299_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7299_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7299_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 9,923,326
  • Buffers: shared hit=771 read=471,943
  • Worker 0: actual time=90,142.869..90142.870 rows=0 loops=1
  • Buffers: shared hit=771 read=471,943
5. 18,456.638 18,456.638 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7306_chunk (cost=0.00..477,266.84 rows=85,152 width=0) (actual time=55,369.913..55,369.913 rows=0 loops=1)

  • Filter: ((_hyper_70_7306_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7306_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7306_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 9,338,940
  • Buffers: shared hit=124 read=409,217
  • Worker 1: actual time=55,369.913..55369.913 rows=0 loops=1
  • Buffers: shared hit=124 read=409,217
6. 17,618.450 17,618.450 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7305_chunk (cost=0.00..438,336.16 rows=23,546 width=0) (actual time=52,855.351..52,855.351 rows=0 loops=1)

  • Filter: ((_hyper_70_7305_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7305_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7305_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 9,217,492
  • Buffers: shared hit=2 read=371,129
  • Worker 1: actual time=52,855.351..52855.351 rows=0 loops=1
  • Buffers: shared hit=2 read=371,129
7. 17,760.503 17,760.503 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7294_chunk (cost=0.00..334,012.82 rows=51,820 width=0) (actual time=53,281.510..53,281.510 rows=0 loops=1)

  • Filter: ((_hyper_70_7294_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7294_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7294_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 6,127,561
  • Buffers: shared hit=2 read=289,323
  • Worker 0: actual time=53,281.510..53281.510 rows=0 loops=1
  • Buffers: shared hit=2 read=289,323
8. 7,653.382 7,653.382 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7301_chunk (cost=0.00..235,109.16 rows=13,844 width=0) (actual time=22,960.147..22,960.147 rows=0 loops=1)

  • Filter: ((_hyper_70_7301_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7301_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7301_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 4,784,479
  • Buffers: shared hit=3 read=200,227
  • Worker 1: actual time=22,960.147..22960.147 rows=0 loops=1
  • Buffers: shared hit=3 read=200,227
9. 13,580.000 13,580.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7307_chunk (cost=0.00..226,598.84 rows=20,870 width=0) (actual time=40,739.998..40,739.999 rows=0 loops=1)

  • Filter: ((_hyper_70_7307_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7307_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7307_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 4,387,733
  • Buffers: shared hit=1 read=194,603
  • Worker 1: actual time=40,739.998..40739.999 rows=0 loops=1
  • Buffers: shared hit=1 read=194,603
10. 6,461.210 6,461.210 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7432_chunk (cost=0.00..214,676.23 rows=11,012 width=0) (actual time=19,383.631..19,383.631 rows=0 loops=1)

  • Filter: ((_hyper_70_7432_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7432_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7432_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 4,617,392
  • Buffers: shared read=181,006
  • Worker 0: actual time=19,383.631..19383.631 rows=0 loops=1
  • Buffers: shared read=181,006
11. 6,201.674 6,201.674 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7308_chunk (cost=0.00..189,263.46 rows=12,380 width=0) (actual time=18,605.022..18,605.022 rows=0 loops=1)

  • Filter: ((_hyper_70_7308_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7308_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7308_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 3,829,025
  • Buffers: shared read=161,345
  • Worker 0: actual time=18,605.022..18605.022 rows=0 loops=1
  • Buffers: shared read=161,345
12. 9,587.069 9,587.069 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7358_chunk (cost=0.00..171,159.08 rows=11,275 width=0) (actual time=28,761.207..28,761.207 rows=0 loops=1)

  • Filter: ((_hyper_70_7358_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7358_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7358_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 3,487,005
  • Buffers: shared read=145,733
  • Worker 1: actual time=28,761.207..28761.207 rows=0 loops=1
  • Buffers: shared read=145,733
13. 6,989.646 6,989.646 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7363_chunk (cost=0.00..149,985.47 rows=15,620 width=0) (actual time=20,968.938..20,968.938 rows=0 loops=1)

  • Filter: ((_hyper_70_7363_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7363_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7363_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 3,066,442
  • Buffers: shared read=127,626
  • Worker 0: actual time=20,968.938..20968.938 rows=0 loops=1
  • Buffers: shared read=127,626
14. 7,749.710 7,749.710 ↓ 0.0 0 3 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7397_chunk (cost=0.00..149,756.03 rows=9,195 width=0) (actual time=7,749.710..7,749.710 rows=0 loops=3)

  • Filter: ((_hyper_70_7397_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7397_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7397_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,000,413
  • Buffers: shared read=127,872
  • Worker 0: actual time=3,275.923..3275.923 rows=0 loops=1
  • Buffers: shared read=11,217
  • Worker 1: actual time=16,697.178..16697.178 rows=0 loops=1
  • Buffers: shared read=102,770
15. 7,821.472 7,821.472 ↓ 0.0 0 2 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7361_chunk (cost=0.00..146,406.31 rows=48,402 width=0) (actual time=11,732.208..11,732.208 rows=0 loops=2)

  • Filter: ((_hyper_70_7361_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7361_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7361_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,489,462
  • Buffers: shared read=124,685
  • Worker 0: actual time=11,726.732..11726.732 rows=0 loops=1
  • Buffers: shared read=58,976
16. 4,366.126 4,366.126 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7359_chunk (cost=0.00..140,943.16 rows=9,457 width=0) (actual time=13,098.377..13,098.377 rows=0 loops=1)

  • Filter: ((_hyper_70_7359_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7359_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7359_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 2,924,868
  • Buffers: shared read=119,616
17. 7,665.580 7,665.580 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7302_chunk (cost=0.00..121,778.46 rows=11,759 width=0) (actual time=22,996.739..22,996.739 rows=0 loops=1)

  • Filter: ((_hyper_70_7302_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7302_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7302_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 2,099,858
  • Buffers: shared read=106,467
18. 7,061.204 7,061.204 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7364_chunk (cost=0.00..119,459.57 rows=9,465 width=0) (actual time=21,183.613..21,183.613 rows=0 loops=1)

  • Filter: ((_hyper_70_7364_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7364_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7364_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 2,319,849
  • Buffers: shared read=102,544
19. 6,479.844 6,479.844 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7303_chunk (cost=0.00..115,315.09 rows=6,727 width=0) (actual time=19,439.532..19,439.532 rows=0 loops=1)

  • Filter: ((_hyper_70_7303_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7303_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7303_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 2,324,173
  • Buffers: shared hit=1 read=98,367
20. 6,155.570 6,155.570 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7433_chunk (cost=0.00..104,375.43 rows=8,294 width=0) (actual time=18,466.710..18,466.710 rows=0 loops=1)

  • Filter: ((_hyper_70_7433_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7433_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7433_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 2,032,791
  • Buffers: shared hit=2 read=89,551
21. 5,683.397 5,683.397 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7430_chunk (cost=0.00..98,396.73 rows=5,835 width=0) (actual time=17,050.190..17,050.190 rows=0 loops=1)

  • Filter: ((_hyper_70_7430_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7430_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7430_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,904,603
  • Buffers: shared hit=2 read=84,507
22. 4,772.311 4,772.311 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7434_chunk (cost=0.00..98,153.48 rows=7,640 width=0) (actual time=14,316.934..14,316.934 rows=0 loops=1)

  • Filter: ((_hyper_70_7434_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7434_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7434_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,953,666
  • Buffers: shared hit=2 read=83,906
23. 5,586.597 5,586.597 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7298_chunk (cost=0.00..85,231.35 rows=7,959 width=0) (actual time=16,759.791..16,759.791 rows=0 loops=1)

  • Filter: ((_hyper_70_7298_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7298_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7298_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,465,419
  • Buffers: shared hit=2 read=74,544
24. 5,141.662 5,141.662 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7300_chunk (cost=0.00..84,768.15 rows=7,163 width=0) (actual time=15,424.985..15,424.985 rows=0 loops=1)

  • Filter: ((_hyper_70_7300_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7300_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7300_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,406,146
  • Buffers: shared hit=6 read=74,509
25. 5,246.873 5,246.873 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7435_chunk (cost=0.00..78,542.74 rows=5,793 width=0) (actual time=15,740.620..15,740.620 rows=0 loops=1)

  • Filter: ((_hyper_70_7435_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7435_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7435_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,363,302
  • Buffers: shared hit=2 read=68,600
26. 4,715.308 4,715.308 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7362_chunk (cost=0.00..75,002.59 rows=4,883 width=0) (actual time=14,145.923..14,145.923 rows=0 loops=1)

  • Filter: ((_hyper_70_7362_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7362_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7362_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,366,984
  • Buffers: shared hit=2 read=65,033
27. 4,586.203 4,586.203 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7293_chunk (cost=0.00..67,727.36 rows=7,461 width=0) (actual time=13,758.609..13,758.609 rows=0 loops=1)

  • Filter: ((_hyper_70_7293_chunk."timestamp" >= '2020-06-10 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7293_chunk."timestamp" <= '2020-06-11 00:00:00+02'::timestamp with time zone) AND (_hyper_70_7293_chunk.attribute_name_ids && '{8057289278,8057289127,8084547336,8057289365,8059967007,8059327762,8084547529,8060550778,8057323819,8084547035,8057289498,8060562755,8059327480,8060562762,8084547379,8060561980,8084547635,8057289107,8084547183,8059955490,8084547128,8060550028,8084547279,8059969059,8084548252,8059980748,8057302008,8084547528,8057587060,8057323861,8084547768,8059333501,8084547727,8057298676,8057301822,8084547723,8057289142,8084547372,8084547927,8084547315,8059327382,8057302230,8084548056,8057372611,8084548040,8057298764,8060556951,8084547623,8061462496,8084547913,8057587210,8059327555,8084547894,8059327875,8060553258,8057940448,8059955672,8084547701,8060557160,8084547009,8084547668,8059327317,8059327953,8084548091,8059327553,8084547301,8084548107,8084547250,8057323844,8084547409,8057289187,8084548198,8084548210,8084547883,8084547262,8059327383,8060562318,8060562781,8084547645,8059328155,8084547398,8060708223,8060707301,8084547370,8057492686,8060015401,8060016211,8084548141,8060015519,8059955667,8084547149,8059195834,8060556960,8084548237,8059327428,8060556214,8084548182,8084547957,8084547928,8060557107,8084548071,8061477925,8084548042,8060554350,8057444385,8084547067,8057302090,8084548062,8060553166,8059327521,8060013242,8084548101,8060020987,8084547221,8060553456,8084547680,8060556894,8059327814,8084547392,8057317590,8084547230,8057301949,8084547526}'::bigint[]))
  • Rows Removed by Filter: 1,048,781
  • Buffers: shared hit=2 read=60,078
Planning time : 67.907 ms
Execution time : 217,632.942 ms