explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1DGY

Settings
# exclusive inclusive rows x rows loops node
1. 0.045 3.760 ↑ 22.2 9 1

Sort (cost=1,610.85..1,611.35 rows=200 width=48) (actual time=3.759..3.760 rows=9 loops=1)

  • Sort Key: (time_bucket('01:00:00'::interval, _hyper_4_57_chunk."time"))
  • Sort Method: quicksort Memory: 25kB
2. 0.918 3.715 ↑ 22.2 9 1

HashAggregate (cost=1,600.70..1,603.20 rows=200 width=48) (actual time=3.711..3.715 rows=9 loops=1)

  • Group Key: time_bucket('01:00:00'::interval, _hyper_4_57_chunk."time")
3. 0.439 2.797 ↑ 1.0 2,880 1

Nested Loop (cost=0.71..1,521.50 rows=2,880 width=48) (actual time=0.161..2.797 rows=2,880 loops=1)

4. 0.039 0.039 ↑ 1.0 1 1

Index Scan using tags_hostname_idx on tags (cost=0.28..2.50 rows=1 width=4) (actual time=0.038..0.039 rows=1 loops=1)

  • Index Cond: (hostname = 'host_249'::text)
5. 0.231 2.319 ↑ 1.0 2,880 1

Append (cost=0.43..1,483.00 rows=2,880 width=52) (actual time=0.119..2.319 rows=2,880 loops=1)

6. 0.166 0.166 ↑ 1.0 68 1

Index Scan using _hyper_4_57_chunk_tags_id_time_idx on _hyper_4_57_chunk (cost=0.43..37.41 rows=70 width=52) (actual time=0.117..0.166 rows=68 loops=1)

  • Index Cond: ((tags_id = tags.id) AND ("time" >= '2016-01-01 11:48:31.646325+00'::timestamp with time zone) AND ("time" < '2016-01-01 19:48:31.646325+00'::timestamp with time zone))
7. 1.012 1.012 ↑ 1.0 1,440 1

Index Scan using _hyper_4_58_chunk_tags_id_time_idx on _hyper_4_58_chunk (cost=0.43..732.75 rows=1,440 width=52) (actual time=0.122..1.012 rows=1,440 loops=1)

  • Index Cond: ((tags_id = tags.id) AND ("time" >= '2016-01-01 11:48:31.646325+00'::timestamp with time zone) AND ("time" < '2016-01-01 19:48:31.646325+00'::timestamp with time zone))
8. 0.910 0.910 ↓ 1.0 1,372 1

Index Scan using _hyper_4_59_chunk_tags_id_time_idx on _hyper_4_59_chunk (cost=0.43..698.45 rows=1,370 width=52) (actual time=0.107..0.910 rows=1,372 loops=1)

  • Index Cond: ((tags_id = tags.id) AND ("time" >= '2016-01-01 11:48:31.646325+00'::timestamp with time zone) AND ("time" < '2016-01-01 19:48:31.646325+00'::timestamp with time zone))
Planning time : 4.013 ms
Execution time : 4.004 ms