explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZslI

Settings
# exclusive inclusive rows x rows loops node
1. 1.516 75.234 ↓ 0.0 0 1

Delete on public.offers (cost=0.00..1,248.85 rows=6,894 width=6) (actual time=75.234..75.234 rows=0 loops=1)

  • Delete on public.offers
  • Delete on _timescaledb_internal._hyper_70_8426_chunk
  • Delete on _timescaledb_internal._hyper_70_8427_chunk
  • Delete on _timescaledb_internal._hyper_70_8428_chunk
  • Delete on _timescaledb_internal._hyper_70_8429_chunk
  • Buffers: shared hit=3,173 read=169 dirtied=140
2. 0.007 0.007 ↓ 0.0 0 1

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

  • Output: offers.ctid
  • Filter: ((offers."timestamp" >= '2020-07-11 20:00:00+02'::timestamp with time zone) AND (offers."timestamp" <= '2020-07-11 23:00:00+02'::timestamp with time zone) AND (offers.product_snapshot_id = ANY ('{632221498,632221560,632221561,632221417,632221499,632221562,632221563,632221850,632221500,632221564,632221851,632221852,632221978,632221501,632221565,632221979,632221853,632221980,632221981,632221982,632221566,632221983,632221854,632221984,632221567,632222200,632222201,632221855,632221985,632221986,632222202,632221856,632221987,632221857,632221858,632222203,632221859,632222204,632222205,632221988,632222206,632221860,632222207,632221861,632222208,632221862,632221863,632222209,632221864,632221989,632222210,632221990,632221991,632221992,632222211,632222212,632221865,632221866,632222213,632221993,632222214,632221867,632221868,632221994,632221995,632222215,632221869,632221996,632222216,632221870,632222217,632222218,632221871,632222219,632221997,632221872,632221873,632221998,632221999,632222220,632222000,632222001,632222221,632222222,632222223,632222224,632222002,632222225,632222003,632222480,632222004,632222226,632222005,632222227,632222006,632222228,632222549,632222481,632222229,632222550}'::bigint[])))
3. 70.857 70.857 ↑ 1.4 1,897 1

Index Scan using _hyper_70_8426_chunk_offer_product_snapshot_id_idx on _timescaledb_internal._hyper_70_8426_chunk (cost=0.43..319.91 rows=2,603 width=6) (actual time=2.060..70.857 rows=1,897 loops=1)

  • Output: _hyper_70_8426_chunk.ctid
  • Index Cond: (_hyper_70_8426_chunk.product_snapshot_id = ANY ('{632221498,632221560,632221561,632221417,632221499,632221562,632221563,632221850,632221500,632221564,632221851,632221852,632221978,632221501,632221565,632221979,632221853,632221980,632221981,632221982,632221566,632221983,632221854,632221984,632221567,632222200,632222201,632221855,632221985,632221986,632222202,632221856,632221987,632221857,632221858,632222203,632221859,632222204,632222205,632221988,632222206,632221860,632222207,632221861,632222208,632221862,632221863,632222209,632221864,632221989,632222210,632221990,632221991,632221992,632222211,632222212,632221865,632221866,632222213,632221993,632222214,632221867,632221868,632221994,632221995,632222215,632221869,632221996,632222216,632221870,632222217,632222218,632221871,632222219,632221997,632221872,632221873,632221998,632221999,632222220,632222000,632222001,632222221,632222222,632222223,632222224,632222002,632222225,632222003,632222480,632222004,632222226,632222005,632222227,632222006,632222228,632222549,632222481,632222229,632222550}'::bigint[]))
  • Filter: ((_hyper_70_8426_chunk."timestamp" >= '2020-07-11 20:00:00+02'::timestamp with time zone) AND (_hyper_70_8426_chunk."timestamp" <= '2020-07-11 23:00:00+02'::timestamp with time zone))
  • Buffers: shared hit=385 read=160 dirtied=133
4. 0.903 0.903 ↓ 0.0 0 1

Index Scan using _hyper_70_8427_chunk_offer_product_snapshot_id_idx on _timescaledb_internal._hyper_70_8427_chunk (cost=0.43..282.85 rows=1,647 width=6) (actual time=0.903..0.903 rows=0 loops=1)

  • Output: _hyper_70_8427_chunk.ctid
  • Index Cond: (_hyper_70_8427_chunk.product_snapshot_id = ANY ('{632221498,632221560,632221561,632221417,632221499,632221562,632221563,632221850,632221500,632221564,632221851,632221852,632221978,632221501,632221565,632221979,632221853,632221980,632221981,632221982,632221566,632221983,632221854,632221984,632221567,632222200,632222201,632221855,632221985,632221986,632222202,632221856,632221987,632221857,632221858,632222203,632221859,632222204,632222205,632221988,632222206,632221860,632222207,632221861,632222208,632221862,632221863,632222209,632221864,632221989,632222210,632221990,632221991,632221992,632222211,632222212,632221865,632221866,632222213,632221993,632222214,632221867,632221868,632221994,632221995,632222215,632221869,632221996,632222216,632221870,632222217,632222218,632221871,632222219,632221997,632221872,632221873,632221998,632221999,632222220,632222000,632222001,632222221,632222222,632222223,632222224,632222002,632222225,632222003,632222480,632222004,632222226,632222005,632222227,632222006,632222228,632222549,632222481,632222229,632222550}'::bigint[]))
  • Filter: ((_hyper_70_8427_chunk."timestamp" >= '2020-07-11 20:00:00+02'::timestamp with time zone) AND (_hyper_70_8427_chunk."timestamp" <= '2020-07-11 23:00:00+02'::timestamp with time zone))
  • Buffers: shared hit=297 read=3
5. 1.033 1.033 ↓ 0.0 0 1

Index Scan using _hyper_70_8428_chunk_offer_product_snapshot_id_idx on _timescaledb_internal._hyper_70_8428_chunk (cost=0.42..360.65 rows=2,642 width=6) (actual time=1.033..1.033 rows=0 loops=1)

  • Output: _hyper_70_8428_chunk.ctid
  • Index Cond: (_hyper_70_8428_chunk.product_snapshot_id = ANY ('{632221498,632221560,632221561,632221417,632221499,632221562,632221563,632221850,632221500,632221564,632221851,632221852,632221978,632221501,632221565,632221979,632221853,632221980,632221981,632221982,632221566,632221983,632221854,632221984,632221567,632222200,632222201,632221855,632221985,632221986,632222202,632221856,632221987,632221857,632221858,632222203,632221859,632222204,632222205,632221988,632222206,632221860,632222207,632221861,632222208,632221862,632221863,632222209,632221864,632221989,632222210,632221990,632221991,632221992,632222211,632222212,632221865,632221866,632222213,632221993,632222214,632221867,632221868,632221994,632221995,632222215,632221869,632221996,632222216,632221870,632222217,632222218,632221871,632222219,632221997,632221872,632221873,632221998,632221999,632222220,632222000,632222001,632222221,632222222,632222223,632222224,632222002,632222225,632222003,632222480,632222004,632222226,632222005,632222227,632222006,632222228,632222549,632222481,632222229,632222550}'::bigint[]))
  • Filter: ((_hyper_70_8428_chunk."timestamp" >= '2020-07-11 20:00:00+02'::timestamp with time zone) AND (_hyper_70_8428_chunk."timestamp" <= '2020-07-11 23:00:00+02'::timestamp with time zone))
  • Buffers: shared hit=297 read=3
6. 0.918 0.918 ↓ 0.0 0 1

Index Scan using _hyper_70_8429_chunk_offer_product_snapshot_id_idx on _timescaledb_internal._hyper_70_8429_chunk (cost=0.43..285.43 rows=1 width=6) (actual time=0.918..0.918 rows=0 loops=1)

  • Output: _hyper_70_8429_chunk.ctid
  • Index Cond: (_hyper_70_8429_chunk.product_snapshot_id = ANY ('{632221498,632221560,632221561,632221417,632221499,632221562,632221563,632221850,632221500,632221564,632221851,632221852,632221978,632221501,632221565,632221979,632221853,632221980,632221981,632221982,632221566,632221983,632221854,632221984,632221567,632222200,632222201,632221855,632221985,632221986,632222202,632221856,632221987,632221857,632221858,632222203,632221859,632222204,632222205,632221988,632222206,632221860,632222207,632221861,632222208,632221862,632221863,632222209,632221864,632221989,632222210,632221990,632221991,632221992,632222211,632222212,632221865,632221866,632222213,632221993,632222214,632221867,632221868,632221994,632221995,632222215,632221869,632221996,632222216,632221870,632222217,632222218,632221871,632222219,632221997,632221872,632221873,632221998,632221999,632222220,632222000,632222001,632222221,632222222,632222223,632222224,632222002,632222225,632222003,632222480,632222004,632222226,632222005,632222227,632222006,632222228,632222549,632222481,632222229,632222550}'::bigint[]))
  • Filter: ((_hyper_70_8429_chunk."timestamp" >= '2020-07-11 20:00:00+02'::timestamp with time zone) AND (_hyper_70_8429_chunk."timestamp" <= '2020-07-11 23:00:00+02'::timestamp with time zone))
  • Buffers: shared hit=297 read=3
Planning time : 923.948 ms
Execution time : 75.375 ms