explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H5AR

Settings
# exclusive inclusive rows x rows loops node
1. 6.391 4,422.624 ↓ 13.3 5,410 1

Nested Loop (cost=123.49..59,749.84 rows=407 width=820) (actual time=85.167..4,422.624 rows=5,410 loops=1)

2. 591.363 591.363 ↓ 13.3 5,410 1

Seq Scan on series (cost=0.00..9,477.52 rows=407 width=756) (actual time=8.964..591.363 rows=5,410 loops=1)

  • Filter: ((labels ->> '__name__'::text) = 'container_tasks_state'::text)
  • Rows Removed by Filter: 76025
3. 59.510 3,824.870 ↑ 1.0 1 5,410

Aggregate (cost=123.49..123.50 rows=1 width=64) (actual time=0.707..0.707 rows=1 loops=5,410)

4. 54.100 3,765.360 ↓ 1.5 50 5,410

Subquery Scan on subsub (cost=118.52..123.31 rows=34 width=16) (actual time=0.605..0.696 rows=50 loops=5,410)

  • Filter: ((subsub.bucket - subsub.data_time) < '00:05:00'::interval)
5. 64.920 3,711.260 ↑ 2.0 50 5,410

Custom Scan (GapFill) (cost=118.52..121.80 rows=101 width=0) (actual time=0.604..0.686 rows=50 loops=5,410)

6. 357.060 3,646.340 ↑ 2.0 50 5,410

GroupAggregate (cost=118.52..121.80 rows=101 width=0) (actual time=0.604..0.674 rows=50 loops=5,410)

  • Group Key: (time_bucket_gapfill('00:00:14'::interval, data."time"))
7. 173.120 3,289.280 ↑ 1.0 101 5,410

Sort (cost=118.52..118.77 rows=101 width=24) (actual time=0.601..0.608 rows=101 loops=5,410)

  • Sort Key: (time_bucket_gapfill('00:00:14'::interval, data."time"))
  • Sort Method: quicksort Memory: 25kB
8. 108.200 3,116.160 ↑ 1.0 101 5,410

Custom Scan (ChunkAppend) on container_tasks_state data (cost=0.43..115.15 rows=101 width=24) (actual time=0.086..0.576 rows=101 loops=5,410)

9. 3,007.960 3,007.960 ↑ 1.0 101 5,410

Index Scan using _hyper_203_180_chunk_series_id_time_idx on _hyper_203_180_chunk data_1 (cost=0.43..114.90 rows=101 width=16) (actual time=0.085..0.556 rows=101 loops=5,410)

  • Index Cond: ((series_id = series.id) AND ("time" < '2019-12-29 09:00:00.711+00'::timestamp with time zone) AND ("time" > '2019-12-29 07:55:00.711+00'::timestamp with time zone))