explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nI0

Settings
# exclusive inclusive rows x rows loops node
1. 0.766 1.767 ↓ 1.1 800 1

Sort (cost=113.21..115.11 rows=759 width=264) (actual time=1.727..1.767 rows=800 loops=1)

  • Sort Key: tsdb.schema_name, tsdb.table_name, hyp.table_name
  • Sort Method: quicksort Memory: 329kB
  • Buffers: shared hit=40 read=12 dirtied=4
2. 0.145 1.001 ↓ 1.1 800 1

Hash Left Join (cost=45.24..76.90 rows=759 width=264) (actual time=0.615..1.001 rows=800 loops=1)

  • Hash Cond: (hyp.compressed_chunk_id = cmp.id)
  • Buffers: shared hit=37 read=12 dirtied=4
3. 0.203 0.406 ↓ 1.1 800 1

Hash Join (cost=8.16..37.83 rows=759 width=200) (actual time=0.149..0.406 rows=800 loops=1)

  • Hash Cond: (hyp.hypertable_id = tsdb.id)
  • Buffers: shared hit=26 read=3
4. 0.092 0.092 ↓ 1.1 800 1

Seq Scan on chunk hyp (cost=0.00..27.59 rows=759 width=72) (actual time=0.015..0.092 rows=800 loops=1)

  • Buffers: shared hit=19 read=1
5. 0.027 0.111 ↑ 1.0 96 1

Hash (cost=6.96..6.96 rows=96 width=132) (actual time=0.111..0.111 rows=96 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
  • Buffers: shared hit=4 read=2
6. 0.084 0.084 ↑ 1.0 96 1

Seq Scan on hypertable tsdb (cost=0.00..6.96 rows=96 width=132) (actual time=0.015..0.084 rows=96 loops=1)

  • Buffers: shared hit=4 read=2
7. 0.149 0.450 ↓ 1.1 800 1

Hash (cost=27.59..27.59 rows=759 width=68) (actual time=0.450..0.450 rows=800 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 87kB
  • Buffers: shared hit=11 read=9 dirtied=4
8. 0.301 0.301 ↓ 1.1 800 1

Seq Scan on chunk cmp (cost=0.00..27.59 rows=759 width=68) (actual time=0.002..0.301 rows=800 loops=1)