explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZF1

Settings
# exclusive inclusive rows x rows loops node
1. 22.359 1,013.693 ↓ 3.1 16,710 1

Sort (cost=3,396.57..3,410.21 rows=5,456 width=13) (actual time=1,011.029..1,013.693 rows=16,710 loops=1)

  • Sort Key: channel_5c8ca6a6_46e3_40b2_badb_4c43d4f56f65."timestamp
  • Sort Method: quicksort Memory: 1552kB
2. 160.706 991.334 ↓ 3.1 16,710 1

HashAggregate (cost=3,003.36..3,057.92 rows=5,456 width=13) (actual time=977.835..991.334 rows=16,710 loops=1)

  • Group Key: channel_5c8ca6a6_46e3_40b2_badb_4c43d4f56f65."timestamp", channel_5c8ca6a6_46e3_40b2_badb_4c43d4f56f65.duration, channel_5c8ca6a6_46e3_40b2_badb_4c43d4f56f65.motion_flag
3. 2.597 830.628 ↑ 1.0 26,482 1

Append (cost=0.00..2,798.73 rows=27,284 width=13) (actual time=0.024..830.628 rows=26,482 loops=1)

4. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on channel_5c8ca6a6_46e3_40b2_badb_4c43d4f56f65 (cost=0.00..0.00 rows=1 width=13) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (("timestamp" >= '1567357800000'::bigint) AND ("timestamp" <= '1567530600000'::bigint))
5. 179.000 179.000 ↓ 1.0 2,025 1

Seq Scan on _hyper_2361_1728033_chunk (cost=0.00..414.78 rows=2,024 width=13) (actual time=0.018..179.000 rows=2,025 loops=1)

  • Filter: (("timestamp" >= '1567357800000'::bigint) AND ("timestamp" <= '1567530600000'::bigint))
  • Rows Removed by Filter: 4298
6. 395.536 395.536 ↑ 1.1 7,470 1

Seq Scan on _hyper_2361_1737328_chunk (cost=0.00..1,368.72 rows=8,273 width=13) (actual time=0.021..395.536 rows=7,470 loops=1)

  • Filter: (("timestamp" >= '1567357800000'::bigint) AND ("timestamp" <= '1567530600000'::bigint))
  • Rows Removed by Filter: 25368
7. 253.490 253.490 ↓ 1.0 16,987 1

Seq Scan on _hyper_2361_1731714_chunk (cost=0.00..878.80 rows=16,986 width=13) (actual time=0.018..253.490 rows=16,987 loops=1)

  • Filter: (("timestamp" >= '1567357800000'::bigint) AND ("timestamp" <= '1567530600000'::bigint))
Planning time : 853.994 ms