explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W5Ot

Settings
# exclusive inclusive rows x rows loops node
1. 278.886 217,895.339 ↓ 0.0 0 1

Gather (cost=1,000.00..5,036,499.15 rows=1,130,564 width=319) (actual time=217,634.668..217,895.339 rows=0 loops=1)

  • Output: _hyper_70_7436_chunk."timestamp", _hyper_70_7436_chunk.price, _hyper_70_7436_chunk.delivery_costs, _hyper_70_7436_chunk.name_id, _hyper_70_7436_chunk.vendor_id, _hyper_70_7436_chunk.vendor_domain_id_id, _hyper_70_7436_chunk.url_id, _hyper_70_7436_chunk.min_delivery_time, _hyper_70_7436_chunk.max_delivery_time, _hyper_70_7436_chunk.availability, _hyper_70_7436_chunk.retrieval_date, _hyper_70_7436_chunk.valid, _hyper_70_7436_chunk.attribute_name_ids, _hyper_70_7436_chunk.attribute_value_ids, _hyper_70_7436_chunk.id, _hyper_70_7436_chunk.product_snapshot_id, _hyper_70_7436_chunk.position_by_unit_price, _hyper_70_7436_chunk.position_by_total_price
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=378,115 read=3,455,210
2. 0.014 217,616.453 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.00..4,922,442.75 rows=471,068 width=319) (actual time=217,616.453..217,616.453 rows=0 loops=3)

  • Buffers: shared hit=378,115 read=3,455,210
  • Worker 0: actual time=217,612.061..217612.062 rows=0 loops=1
  • Buffers: shared hit=258,672 read=984,269
  • Worker 1: actual time=217,614.091..217614.092 rows=0 loops=1
  • Buffers: shared hit=76,487 read=1,068,174
3. 0.010 0.010 ↓ 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.65 rows=1 width=402) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: _hyper_70_7436_chunk."timestamp", _hyper_70_7436_chunk.price, _hyper_70_7436_chunk.delivery_costs, _hyper_70_7436_chunk.name_id, _hyper_70_7436_chunk.vendor_id, _hyper_70_7436_chunk.vendor_domain_id_id, _hyper_70_7436_chunk.url_id, _hyper_70_7436_chunk.min_delivery_time, _hyper_70_7436_chunk.max_delivery_time, _hyper_70_7436_chunk.availability, _hyper_70_7436_chunk.retrieval_date, _hyper_70_7436_chunk.valid, _hyper_70_7436_chunk.attribute_name_ids, _hyper_70_7436_chunk.attribute_value_ids, _hyper_70_7436_chunk.id, _hyper_70_7436_chunk.product_snapshot_id, _hyper_70_7436_chunk.position_by_unit_price, _hyper_70_7436_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7436_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Buffers: shared hit=4
  • Worker 1: actual time=0.031..0.031 rows=0 loops=1
  • Buffers: shared hit=4
4. 28,520.915 28,520.915 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7299_chunk (cost=0.00..596,573.44 rows=75,545 width=341) (actual time=85,562.745..85,562.745 rows=0 loops=1)

  • Output: _hyper_70_7299_chunk."timestamp", _hyper_70_7299_chunk.price, _hyper_70_7299_chunk.delivery_costs, _hyper_70_7299_chunk.name_id, _hyper_70_7299_chunk.vendor_id, _hyper_70_7299_chunk.vendor_domain_id_id, _hyper_70_7299_chunk.url_id, _hyper_70_7299_chunk.min_delivery_time, _hyper_70_7299_chunk.max_delivery_time, _hyper_70_7299_chunk.availability, _hyper_70_7299_chunk.retrieval_date, _hyper_70_7299_chunk.valid, _hyper_70_7299_chunk.attribute_name_ids, _hyper_70_7299_chunk.attribute_value_ids, _hyper_70_7299_chunk.id, _hyper_70_7299_chunk.product_snapshot_id, _hyper_70_7299_chunk.position_by_unit_price, _hyper_70_7299_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7299_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 9,923,326
  • Buffers: shared hit=76,477 read=396,220
  • Worker 1: actual time=85,562.745..85562.745 rows=0 loops=1
  • Buffers: shared hit=76,477 read=396,220
5. 21,410.366 21,410.366 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7306_chunk (cost=0.00..525,872.44 rows=85,148 width=311) (actual time=64,231.097..64,231.097 rows=0 loops=1)

  • Output: _hyper_70_7306_chunk."timestamp", _hyper_70_7306_chunk.price, _hyper_70_7306_chunk.delivery_costs, _hyper_70_7306_chunk.name_id, _hyper_70_7306_chunk.vendor_id, _hyper_70_7306_chunk.vendor_domain_id_id, _hyper_70_7306_chunk.url_id, _hyper_70_7306_chunk.min_delivery_time, _hyper_70_7306_chunk.max_delivery_time, _hyper_70_7306_chunk.availability, _hyper_70_7306_chunk.retrieval_date, _hyper_70_7306_chunk.valid, _hyper_70_7306_chunk.attribute_name_ids, _hyper_70_7306_chunk.attribute_value_ids, _hyper_70_7306_chunk.id, _hyper_70_7306_chunk.product_snapshot_id, _hyper_70_7306_chunk.position_by_unit_price, _hyper_70_7306_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7306_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 9,338,940
  • Buffers: shared hit=122,687 read=286,637
  • Worker 0: actual time=64,231.097..64231.097 rows=0 loops=1
  • Buffers: shared hit=122,687 read=286,637
6. 20,899.360 20,899.360 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7305_chunk (cost=0.00..486,339.84 rows=23,545 width=283) (actual time=62,698.079..62,698.079 rows=0 loops=1)

  • Output: _hyper_70_7305_chunk."timestamp", _hyper_70_7305_chunk.price, _hyper_70_7305_chunk.delivery_costs, _hyper_70_7305_chunk.name_id, _hyper_70_7305_chunk.vendor_id, _hyper_70_7305_chunk.vendor_domain_id_id, _hyper_70_7305_chunk.url_id, _hyper_70_7305_chunk.min_delivery_time, _hyper_70_7305_chunk.max_delivery_time, _hyper_70_7305_chunk.availability, _hyper_70_7305_chunk.retrieval_date, _hyper_70_7305_chunk.valid, _hyper_70_7305_chunk.attribute_name_ids, _hyper_70_7305_chunk.attribute_value_ids, _hyper_70_7305_chunk.id, _hyper_70_7305_chunk.product_snapshot_id, _hyper_70_7305_chunk.position_by_unit_price, _hyper_70_7305_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7305_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 9,217,492
  • Buffers: shared hit=135,390 read=235,741
  • Worker 0: actual time=62,698.079..62698.079 rows=0 loops=1
  • Buffers: shared hit=135,390 read=235,741
7. 18,505.559 18,505.559 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7294_chunk (cost=0.00..365,932.69 rows=51,812 width=337) (actual time=55,516.677..55,516.677 rows=0 loops=1)

  • Output: _hyper_70_7294_chunk."timestamp", _hyper_70_7294_chunk.price, _hyper_70_7294_chunk.delivery_costs, _hyper_70_7294_chunk.name_id, _hyper_70_7294_chunk.vendor_id, _hyper_70_7294_chunk.vendor_domain_id_id, _hyper_70_7294_chunk.url_id, _hyper_70_7294_chunk.min_delivery_time, _hyper_70_7294_chunk.max_delivery_time, _hyper_70_7294_chunk.availability, _hyper_70_7294_chunk.retrieval_date, _hyper_70_7294_chunk.valid, _hyper_70_7294_chunk.attribute_name_ids, _hyper_70_7294_chunk.attribute_value_ids, _hyper_70_7294_chunk.id, _hyper_70_7294_chunk.product_snapshot_id, _hyper_70_7294_chunk.position_by_unit_price, _hyper_70_7294_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7294_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 6,127,561
  • Buffers: shared hit=2 read=289,323
  • Worker 1: actual time=55,516.677..55516.677 rows=0 loops=1
  • Buffers: shared hit=2 read=289,323
8. 13,341.989 13,341.989 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7301_chunk (cost=0.00..260,022.85 rows=13,843 width=295) (actual time=40,025.967..40,025.967 rows=0 loops=1)

  • Output: _hyper_70_7301_chunk."timestamp", _hyper_70_7301_chunk.price, _hyper_70_7301_chunk.delivery_costs, _hyper_70_7301_chunk.name_id, _hyper_70_7301_chunk.vendor_id, _hyper_70_7301_chunk.vendor_domain_id_id, _hyper_70_7301_chunk.url_id, _hyper_70_7301_chunk.min_delivery_time, _hyper_70_7301_chunk.max_delivery_time, _hyper_70_7301_chunk.availability, _hyper_70_7301_chunk.retrieval_date, _hyper_70_7301_chunk.valid, _hyper_70_7301_chunk.attribute_name_ids, _hyper_70_7301_chunk.attribute_value_ids, _hyper_70_7301_chunk.id, _hyper_70_7301_chunk.product_snapshot_id, _hyper_70_7301_chunk.position_by_unit_price, _hyper_70_7301_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7301_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 4,784,479
  • Buffers: shared hit=592 read=199,638
  • Worker 0: actual time=40,025.967..40025.967 rows=0 loops=1
  • Buffers: shared hit=592 read=199,638
9. 13,716.296 13,716.296 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7307_chunk (cost=0.00..249,452.30 rows=20,868 width=315) (actual time=41,148.888..41,148.888 rows=0 loops=1)

  • Output: _hyper_70_7307_chunk."timestamp", _hyper_70_7307_chunk.price, _hyper_70_7307_chunk.delivery_costs, _hyper_70_7307_chunk.name_id, _hyper_70_7307_chunk.vendor_id, _hyper_70_7307_chunk.vendor_domain_id_id, _hyper_70_7307_chunk.url_id, _hyper_70_7307_chunk.min_delivery_time, _hyper_70_7307_chunk.max_delivery_time, _hyper_70_7307_chunk.availability, _hyper_70_7307_chunk.retrieval_date, _hyper_70_7307_chunk.valid, _hyper_70_7307_chunk.attribute_name_ids, _hyper_70_7307_chunk.attribute_value_ids, _hyper_70_7307_chunk.id, _hyper_70_7307_chunk.product_snapshot_id, _hyper_70_7307_chunk.position_by_unit_price, _hyper_70_7307_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7307_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 4,387,733
  • Buffers: shared hit=2 read=194,602
  • Worker 1: actual time=41,148.888..41148.888 rows=0 loops=1
  • Buffers: shared hit=2 read=194,602
10. 11,166.349 11,166.349 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7432_chunk (cost=0.00..238,726.39 rows=11,012 width=275) (actual time=33,499.048..33,499.048 rows=0 loops=1)

  • Output: _hyper_70_7432_chunk."timestamp", _hyper_70_7432_chunk.price, _hyper_70_7432_chunk.delivery_costs, _hyper_70_7432_chunk.name_id, _hyper_70_7432_chunk.vendor_id, _hyper_70_7432_chunk.vendor_domain_id_id, _hyper_70_7432_chunk.url_id, _hyper_70_7432_chunk.min_delivery_time, _hyper_70_7432_chunk.max_delivery_time, _hyper_70_7432_chunk.availability, _hyper_70_7432_chunk.retrieval_date, _hyper_70_7432_chunk.valid, _hyper_70_7432_chunk.attribute_name_ids, _hyper_70_7432_chunk.attribute_value_ids, _hyper_70_7432_chunk.id, _hyper_70_7432_chunk.product_snapshot_id, _hyper_70_7432_chunk.position_by_unit_price, _hyper_70_7432_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7432_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 4,617,392
  • Buffers: shared hit=2 read=181,004
  • Worker 0: actual time=33,499.048..33499.048 rows=0 loops=1
  • Buffers: shared hit=2 read=181,004
11. 10,164.132 10,164.132 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7308_chunk (cost=0.00..209,205.21 rows=12,379 width=297) (actual time=30,492.397..30,492.397 rows=0 loops=1)

  • Output: _hyper_70_7308_chunk."timestamp", _hyper_70_7308_chunk.price, _hyper_70_7308_chunk.delivery_costs, _hyper_70_7308_chunk.name_id, _hyper_70_7308_chunk.vendor_id, _hyper_70_7308_chunk.vendor_domain_id_id, _hyper_70_7308_chunk.url_id, _hyper_70_7308_chunk.min_delivery_time, _hyper_70_7308_chunk.max_delivery_time, _hyper_70_7308_chunk.availability, _hyper_70_7308_chunk.retrieval_date, _hyper_70_7308_chunk.valid, _hyper_70_7308_chunk.attribute_name_ids, _hyper_70_7308_chunk.attribute_value_ids, _hyper_70_7308_chunk.id, _hyper_70_7308_chunk.product_snapshot_id, _hyper_70_7308_chunk.position_by_unit_price, _hyper_70_7308_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7308_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 3,829,025
  • Buffers: shared hit=2 read=161,343
  • Worker 1: actual time=30,492.397..30492.397 rows=0 loops=1
  • Buffers: shared hit=2 read=161,343
12. 10,320.196 10,320.196 ↓ 0.0 0 3 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7358_chunk (cost=0.00..189,320.56 rows=11,274 width=295) (actual time=10,320.196..10,320.196 rows=0 loops=3)

  • Output: _hyper_70_7358_chunk."timestamp", _hyper_70_7358_chunk.price, _hyper_70_7358_chunk.delivery_costs, _hyper_70_7358_chunk.name_id, _hyper_70_7358_chunk.vendor_id, _hyper_70_7358_chunk.vendor_domain_id_id, _hyper_70_7358_chunk.url_id, _hyper_70_7358_chunk.min_delivery_time, _hyper_70_7358_chunk.max_delivery_time, _hyper_70_7358_chunk.availability, _hyper_70_7358_chunk.retrieval_date, _hyper_70_7358_chunk.valid, _hyper_70_7358_chunk.attribute_name_ids, _hyper_70_7358_chunk.attribute_value_ids, _hyper_70_7358_chunk.id, _hyper_70_7358_chunk.product_snapshot_id, _hyper_70_7358_chunk.position_by_unit_price, _hyper_70_7358_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7358_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,162,335
  • Buffers: shared hit=1 read=145,732
  • Worker 0: actual time=17,157.862..17157.862 rows=0 loops=1
  • Buffers: shared hit=1 read=81,249
  • Worker 1: actual time=4,893.344..4893.344 rows=0 loops=1
  • Buffers: shared read=26,686
13. 4,875.165 4,875.165 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7363_chunk (cost=0.00..165,956.52 rows=15,619 width=295) (actual time=14,625.495..14,625.495 rows=0 loops=1)

  • Output: _hyper_70_7363_chunk."timestamp", _hyper_70_7363_chunk.price, _hyper_70_7363_chunk.delivery_costs, _hyper_70_7363_chunk.name_id, _hyper_70_7363_chunk.vendor_id, _hyper_70_7363_chunk.vendor_domain_id_id, _hyper_70_7363_chunk.url_id, _hyper_70_7363_chunk.min_delivery_time, _hyper_70_7363_chunk.max_delivery_time, _hyper_70_7363_chunk.availability, _hyper_70_7363_chunk.retrieval_date, _hyper_70_7363_chunk.valid, _hyper_70_7363_chunk.attribute_name_ids, _hyper_70_7363_chunk.attribute_value_ids, _hyper_70_7363_chunk.id, _hyper_70_7363_chunk.product_snapshot_id, _hyper_70_7363_chunk.position_by_unit_price, _hyper_70_7363_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7363_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 3,066,442
  • Buffers: shared hit=2 read=127,624
14. 4,886.366 4,886.366 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7397_chunk (cost=0.00..165,387.49 rows=9,195 width=301) (actual time=14,659.099..14,659.099 rows=0 loops=1)

  • Output: _hyper_70_7397_chunk."timestamp", _hyper_70_7397_chunk.price, _hyper_70_7397_chunk.delivery_costs, _hyper_70_7397_chunk.name_id, _hyper_70_7397_chunk.vendor_id, _hyper_70_7397_chunk.vendor_domain_id_id, _hyper_70_7397_chunk.url_id, _hyper_70_7397_chunk.min_delivery_time, _hyper_70_7397_chunk.max_delivery_time, _hyper_70_7397_chunk.availability, _hyper_70_7397_chunk.retrieval_date, _hyper_70_7397_chunk.valid, _hyper_70_7397_chunk.attribute_name_ids, _hyper_70_7397_chunk.attribute_value_ids, _hyper_70_7397_chunk.id, _hyper_70_7397_chunk.product_snapshot_id, _hyper_70_7397_chunk.position_by_unit_price, _hyper_70_7397_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7397_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 3,001,239
  • Buffers: shared hit=2 read=127,870
15. 4,733.377 4,733.377 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7361_chunk (cost=0.00..161,921.54 rows=48,399 width=297) (actual time=14,200.131..14,200.131 rows=0 loops=1)

  • Output: _hyper_70_7361_chunk."timestamp", _hyper_70_7361_chunk.price, _hyper_70_7361_chunk.delivery_costs, _hyper_70_7361_chunk.name_id, _hyper_70_7361_chunk.vendor_id, _hyper_70_7361_chunk.vendor_domain_id_id, _hyper_70_7361_chunk.url_id, _hyper_70_7361_chunk.min_delivery_time, _hyper_70_7361_chunk.max_delivery_time, _hyper_70_7361_chunk.availability, _hyper_70_7361_chunk.retrieval_date, _hyper_70_7361_chunk.valid, _hyper_70_7361_chunk.attribute_name_ids, _hyper_70_7361_chunk.attribute_value_ids, _hyper_70_7361_chunk.id, _hyper_70_7361_chunk.product_snapshot_id, _hyper_70_7361_chunk.position_by_unit_price, _hyper_70_7361_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7361_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 2,978,923
  • Buffers: shared hit=2 read=124,683
16. 4,418.607 4,418.607 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7359_chunk (cost=0.00..156,176.85 rows=9,456 width=289) (actual time=13,255.820..13,255.820 rows=0 loops=1)

  • Output: _hyper_70_7359_chunk."timestamp", _hyper_70_7359_chunk.price, _hyper_70_7359_chunk.delivery_costs, _hyper_70_7359_chunk.name_id, _hyper_70_7359_chunk.vendor_id, _hyper_70_7359_chunk.vendor_domain_id_id, _hyper_70_7359_chunk.url_id, _hyper_70_7359_chunk.min_delivery_time, _hyper_70_7359_chunk.max_delivery_time, _hyper_70_7359_chunk.availability, _hyper_70_7359_chunk.retrieval_date, _hyper_70_7359_chunk.valid, _hyper_70_7359_chunk.attribute_name_ids, _hyper_70_7359_chunk.attribute_value_ids, _hyper_70_7359_chunk.id, _hyper_70_7359_chunk.product_snapshot_id, _hyper_70_7359_chunk.position_by_unit_price, _hyper_70_7359_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7359_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 2,924,868
  • Buffers: shared hit=2 read=119,614
17. 4,649.859 4,649.859 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7302_chunk (cost=0.00..132,715.23 rows=11,758 width=365) (actual time=13,949.577..13,949.577 rows=0 loops=1)

  • Output: _hyper_70_7302_chunk."timestamp", _hyper_70_7302_chunk.price, _hyper_70_7302_chunk.delivery_costs, _hyper_70_7302_chunk.name_id, _hyper_70_7302_chunk.vendor_id, _hyper_70_7302_chunk.vendor_domain_id_id, _hyper_70_7302_chunk.url_id, _hyper_70_7302_chunk.min_delivery_time, _hyper_70_7302_chunk.max_delivery_time, _hyper_70_7302_chunk.availability, _hyper_70_7302_chunk.retrieval_date, _hyper_70_7302_chunk.valid, _hyper_70_7302_chunk.attribute_name_ids, _hyper_70_7302_chunk.attribute_value_ids, _hyper_70_7302_chunk.id, _hyper_70_7302_chunk.product_snapshot_id, _hyper_70_7302_chunk.position_by_unit_price, _hyper_70_7302_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7302_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 2,099,858
  • Buffers: shared hit=150 read=106,317
18. 4,274.198 4,274.198 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7364_chunk (cost=0.00..131,542.11 rows=9,465 width=315) (actual time=12,822.594..12,822.594 rows=0 loops=1)

  • Output: _hyper_70_7364_chunk."timestamp", _hyper_70_7364_chunk.price, _hyper_70_7364_chunk.delivery_costs, _hyper_70_7364_chunk.name_id, _hyper_70_7364_chunk.vendor_id, _hyper_70_7364_chunk.vendor_domain_id_id, _hyper_70_7364_chunk.url_id, _hyper_70_7364_chunk.min_delivery_time, _hyper_70_7364_chunk.max_delivery_time, _hyper_70_7364_chunk.availability, _hyper_70_7364_chunk.retrieval_date, _hyper_70_7364_chunk.valid, _hyper_70_7364_chunk.attribute_name_ids, _hyper_70_7364_chunk.attribute_value_ids, _hyper_70_7364_chunk.id, _hyper_70_7364_chunk.product_snapshot_id, _hyper_70_7364_chunk.position_by_unit_price, _hyper_70_7364_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7364_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 2,319,849
  • Buffers: shared hit=2 read=102,542
19. 4,946.136 4,946.136 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7303_chunk (cost=0.00..127,420.16 rows=6,726 width=299) (actual time=14,838.408..14,838.408 rows=0 loops=1)

  • Output: _hyper_70_7303_chunk."timestamp", _hyper_70_7303_chunk.price, _hyper_70_7303_chunk.delivery_costs, _hyper_70_7303_chunk.name_id, _hyper_70_7303_chunk.vendor_id, _hyper_70_7303_chunk.vendor_domain_id_id, _hyper_70_7303_chunk.url_id, _hyper_70_7303_chunk.min_delivery_time, _hyper_70_7303_chunk.max_delivery_time, _hyper_70_7303_chunk.availability, _hyper_70_7303_chunk.retrieval_date, _hyper_70_7303_chunk.valid, _hyper_70_7303_chunk.attribute_name_ids, _hyper_70_7303_chunk.attribute_value_ids, _hyper_70_7303_chunk.id, _hyper_70_7303_chunk.product_snapshot_id, _hyper_70_7303_chunk.position_by_unit_price, _hyper_70_7303_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7303_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 2,324,173
  • Buffers: shared hit=737 read=97,631
20. 3,592.500 3,592.500 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7433_chunk (cost=0.00..114,962.89 rows=8,293 width=313) (actual time=10,777.501..10,777.501 rows=0 loops=1)

  • Output: _hyper_70_7433_chunk."timestamp", _hyper_70_7433_chunk.price, _hyper_70_7433_chunk.delivery_costs, _hyper_70_7433_chunk.name_id, _hyper_70_7433_chunk.vendor_id, _hyper_70_7433_chunk.vendor_domain_id_id, _hyper_70_7433_chunk.url_id, _hyper_70_7433_chunk.min_delivery_time, _hyper_70_7433_chunk.max_delivery_time, _hyper_70_7433_chunk.availability, _hyper_70_7433_chunk.retrieval_date, _hyper_70_7433_chunk.valid, _hyper_70_7433_chunk.attribute_name_ids, _hyper_70_7433_chunk.attribute_value_ids, _hyper_70_7433_chunk.id, _hyper_70_7433_chunk.product_snapshot_id, _hyper_70_7433_chunk.position_by_unit_price, _hyper_70_7433_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7433_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 2,032,791
  • Buffers: shared hit=2 read=89,551
21. 3,260.671 3,260.671 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7434_chunk (cost=0.00..108,328.82 rows=7,640 width=303) (actual time=9,782.014..9,782.014 rows=0 loops=1)

  • Output: _hyper_70_7434_chunk."timestamp", _hyper_70_7434_chunk.price, _hyper_70_7434_chunk.delivery_costs, _hyper_70_7434_chunk.name_id, _hyper_70_7434_chunk.vendor_id, _hyper_70_7434_chunk.vendor_domain_id_id, _hyper_70_7434_chunk.url_id, _hyper_70_7434_chunk.min_delivery_time, _hyper_70_7434_chunk.max_delivery_time, _hyper_70_7434_chunk.availability, _hyper_70_7434_chunk.retrieval_date, _hyper_70_7434_chunk.valid, _hyper_70_7434_chunk.attribute_name_ids, _hyper_70_7434_chunk.attribute_value_ids, _hyper_70_7434_chunk.id, _hyper_70_7434_chunk.product_snapshot_id, _hyper_70_7434_chunk.position_by_unit_price, _hyper_70_7434_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7434_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,953,666
  • Buffers: shared hit=2 read=83,906
22. 4,373.561 4,373.561 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7430_chunk (cost=0.00..108,316.54 rows=5,835 width=315) (actual time=13,120.683..13,120.683 rows=0 loops=1)

  • Output: _hyper_70_7430_chunk."timestamp", _hyper_70_7430_chunk.price, _hyper_70_7430_chunk.delivery_costs, _hyper_70_7430_chunk.name_id, _hyper_70_7430_chunk.vendor_id, _hyper_70_7430_chunk.vendor_domain_id_id, _hyper_70_7430_chunk.url_id, _hyper_70_7430_chunk.min_delivery_time, _hyper_70_7430_chunk.max_delivery_time, _hyper_70_7430_chunk.availability, _hyper_70_7430_chunk.retrieval_date, _hyper_70_7430_chunk.valid, _hyper_70_7430_chunk.attribute_name_ids, _hyper_70_7430_chunk.attribute_value_ids, _hyper_70_7430_chunk.id, _hyper_70_7430_chunk.product_snapshot_id, _hyper_70_7430_chunk.position_by_unit_price, _hyper_70_7430_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7430_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,904,603
  • Buffers: shared hit=2 read=84,507
23. 5,788.114 5,788.114 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7298_chunk (cost=0.00..92,863.74 rows=7,958 width=366) (actual time=17,364.343..17,364.343 rows=0 loops=1)

  • Output: _hyper_70_7298_chunk."timestamp", _hyper_70_7298_chunk.price, _hyper_70_7298_chunk.delivery_costs, _hyper_70_7298_chunk.name_id, _hyper_70_7298_chunk.vendor_id, _hyper_70_7298_chunk.vendor_domain_id_id, _hyper_70_7298_chunk.url_id, _hyper_70_7298_chunk.min_delivery_time, _hyper_70_7298_chunk.max_delivery_time, _hyper_70_7298_chunk.availability, _hyper_70_7298_chunk.retrieval_date, _hyper_70_7298_chunk.valid, _hyper_70_7298_chunk.attribute_name_ids, _hyper_70_7298_chunk.attribute_value_ids, _hyper_70_7298_chunk.id, _hyper_70_7298_chunk.product_snapshot_id, _hyper_70_7298_chunk.position_by_unit_price, _hyper_70_7298_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7298_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,465,419
  • Buffers: shared hit=5 read=74,541
24. 5,890.050 5,890.050 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7300_chunk (cost=0.00..92,091.82 rows=7,162 width=382) (actual time=17,670.149..17,670.149 rows=0 loops=1)

  • Output: _hyper_70_7300_chunk."timestamp", _hyper_70_7300_chunk.price, _hyper_70_7300_chunk.delivery_costs, _hyper_70_7300_chunk.name_id, _hyper_70_7300_chunk.vendor_id, _hyper_70_7300_chunk.vendor_domain_id_id, _hyper_70_7300_chunk.url_id, _hyper_70_7300_chunk.min_delivery_time, _hyper_70_7300_chunk.max_delivery_time, _hyper_70_7300_chunk.availability, _hyper_70_7300_chunk.retrieval_date, _hyper_70_7300_chunk.valid, _hyper_70_7300_chunk.attribute_name_ids, _hyper_70_7300_chunk.attribute_value_ids, _hyper_70_7300_chunk.id, _hyper_70_7300_chunk.product_snapshot_id, _hyper_70_7300_chunk.position_by_unit_price, _hyper_70_7300_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7300_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,406,146
  • Buffers: shared hit=42,042 read=32,473
25. 4,638.598 4,638.598 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7435_chunk (cost=0.00..85,643.27 rows=5,792 width=362) (actual time=13,915.794..13,915.794 rows=0 loops=1)

  • Output: _hyper_70_7435_chunk."timestamp", _hyper_70_7435_chunk.price, _hyper_70_7435_chunk.delivery_costs, _hyper_70_7435_chunk.name_id, _hyper_70_7435_chunk.vendor_id, _hyper_70_7435_chunk.vendor_domain_id_id, _hyper_70_7435_chunk.url_id, _hyper_70_7435_chunk.min_delivery_time, _hyper_70_7435_chunk.max_delivery_time, _hyper_70_7435_chunk.availability, _hyper_70_7435_chunk.retrieval_date, _hyper_70_7435_chunk.valid, _hyper_70_7435_chunk.attribute_name_ids, _hyper_70_7435_chunk.attribute_value_ids, _hyper_70_7435_chunk.id, _hyper_70_7435_chunk.product_snapshot_id, _hyper_70_7435_chunk.position_by_unit_price, _hyper_70_7435_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7435_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,363,302
  • Buffers: shared hit=2 read=68,600
26. 4,697.231 4,697.231 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7362_chunk (cost=0.00..82,122.30 rows=4,883 width=341) (actual time=14,091.692..14,091.692 rows=0 loops=1)

  • Output: _hyper_70_7362_chunk."timestamp", _hyper_70_7362_chunk.price, _hyper_70_7362_chunk.delivery_costs, _hyper_70_7362_chunk.name_id, _hyper_70_7362_chunk.vendor_id, _hyper_70_7362_chunk.vendor_domain_id_id, _hyper_70_7362_chunk.url_id, _hyper_70_7362_chunk.min_delivery_time, _hyper_70_7362_chunk.max_delivery_time, _hyper_70_7362_chunk.availability, _hyper_70_7362_chunk.retrieval_date, _hyper_70_7362_chunk.valid, _hyper_70_7362_chunk.attribute_name_ids, _hyper_70_7362_chunk.attribute_value_ids, _hyper_70_7362_chunk.id, _hyper_70_7362_chunk.product_snapshot_id, _hyper_70_7362_chunk.position_by_unit_price, _hyper_70_7362_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7362_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,366,984
  • Buffers: shared hit=2 read=65,033
27. 4,546.834 4,546.834 ↓ 0.0 0 1 / 3

Parallel Seq Scan on _timescaledb_internal._hyper_70_7293_chunk (cost=0.00..73,189.76 rows=7,460 width=416) (actual time=13,640.501..13,640.501 rows=0 loops=1)

  • Output: _hyper_70_7293_chunk."timestamp", _hyper_70_7293_chunk.price, _hyper_70_7293_chunk.delivery_costs, _hyper_70_7293_chunk.name_id, _hyper_70_7293_chunk.vendor_id, _hyper_70_7293_chunk.vendor_domain_id_id, _hyper_70_7293_chunk.url_id, _hyper_70_7293_chunk.min_delivery_time, _hyper_70_7293_chunk.max_delivery_time, _hyper_70_7293_chunk.availability, _hyper_70_7293_chunk.retrieval_date, _hyper_70_7293_chunk.valid, _hyper_70_7293_chunk.attribute_name_ids, _hyper_70_7293_chunk.attribute_value_ids, _hyper_70_7293_chunk.id, _hyper_70_7293_chunk.product_snapshot_id, _hyper_70_7293_chunk.position_by_unit_price, _hyper_70_7293_chunk.position_by_total_price
  • 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[]) AND (_hyper_70_7293_chunk.product_snapshot_id <> ALL ('{424402038,424402039,424402040,424402041,424402042,424402043,424402044,424402045,424402046,424402047}'::bigint[])))
  • Rows Removed by Filter: 1,048,781
  • Buffers: shared hit=2 read=60,078
Planning time : 11.937 ms
Execution time : 217,895.580 ms