explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yQG6 : RIGHT JOIN

Settings
# exclusive inclusive rows x rows loops node
1. 383.358 1,161.644 ↓ 1.1 788 1

HashAggregate (cost=130,935.86..130,942.73 rows=687 width=16) (actual time=1,161.552..1,161.644 rows=788 loops=1)

  • Group Key: message.channel_id
2. 488.987 778.286 ↑ 1.0 3,291,232 1

Hash Right Join (cost=43.81..114,446.74 rows=3,297,825 width=16) (actual time=0.388..778.286 rows=3,291,232 loops=1)

  • Hash Cond: (message.channel_id = channel.tg_id)
3. 288.933 288.933 ↑ 1.0 3,291,183 1

Seq Scan on message (cost=0.00..105,702.25 rows=3,297,825 width=16) (actual time=0.010..288.933 rows=3,291,183 loops=1)

4. 0.124 0.366 ↑ 1.0 836 1

Hash (cost=33.36..33.36 rows=836 width=8) (actual time=0.366..0.366 rows=836 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
5. 0.242 0.242 ↑ 1.0 836 1

Seq Scan on channel (cost=0.00..33.36 rows=836 width=8) (actual time=0.014..0.242 rows=836 loops=1)