explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nsPY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 137.380 ↓ 5.1 1,051 1

Nested Loop (cost=1,000.27..84,340.67 rows=208 width=32) (actual time=97.989..137.380 rows=1,051 loops=1)

2. 11.768 142.462 ↓ 4.8 1,054 1

Gather (cost=1,000.00..84,145.42 rows=221 width=16) (actual time=97.963..142.462 rows=1,054 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 130.694 130.694 ↓ 3.8 211 5

Parallel Seq Scan on message (cost=0.00..83,123.32 rows=55 width=16) (actual time=82.483..130.694 rows=211 loops=5)

  • Filter: (fwd_channel_id = 1088885190)
  • Rows Removed by Filter: 658877
4. 2.108 2.108 ↑ 1.0 1 1,054

Index Scan using channel_tg_id_idx on channel (cost=0.28..0.87 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=1,054)

  • Index Cond: (tg_id = message.channel_id)
  • Filter: (username IS NOT NULL)
  • Rows Removed by Filter: 0