explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iyou

Settings
# exclusive inclusive rows x rows loops node
1. 0.365 736.418 ↓ 13.3 5,410 1

Nested Loop (cost=123.74..59,852.61 rows=407 width=816) (actual time=1.087..736.418 rows=5,410 loops=1)

2. 38.163 38.163 ↓ 13.3 5,410 1

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

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

Aggregate (cost=123.74..123.75 rows=1 width=64) (actual time=0.129..0.129 rows=1 loops=5,410)

4. 32.460 660.020 ↓ 1.5 50 5,410

Subquery Scan on subsub (cost=118.52..123.57 rows=34 width=16) (actual time=0.068..0.122 rows=50 loops=5,410)

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

Custom Scan (GapFill) (cost=118.52..122.05 rows=101 width=24) (actual time=0.067..0.116 rows=50 loops=5,410)

6. 216.400 600.510 ↑ 2.0 50 5,410

GroupAggregate (cost=118.52..121.29 rows=101 width=0) (actual time=0.067..0.111 rows=50 loops=5,410)

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

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

  • Sort Key: (time_bucket_gapfill('00:00:14'::interval, data."time"))
  • Sort Method: quicksort Memory: 25kB
8. 64.920 281.320 ↑ 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.006..0.052 rows=101 loops=5,410)

9. 216.400 216.400 ↑ 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.006..0.040 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))