explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KMkS

Settings
# exclusive inclusive rows x rows loops node
1. 1,609.271 153,570.553 ↓ 0.0 0 1

Update on notes (cost=324,596.40..324,606.51 rows=1 width=2,502) (actual time=153,570.553..153,570.553 rows=0 loops=1)

  • Buffers: shared dirtied=664 hit=258649 read=144088
2. 14.420 151,961.282 ↓ 110.0 110 1

Nested Loop (cost=324,596.40..324,606.51 rows=1 width=2,502) (actual time=151,959.156..151,961.282 rows=110 loops=1)

  • Buffers: shared hit=258318 read=144088 dirtied=664
3. 151,946.862 151,946.862 ↓ 100.0 100 1

HashAggregate (cost=324,595.70..324,595.71 rows=1 width=106) (actual time=151,946.813..151,946.862 rows=100 loops=1)

  • Group Key: ("ANY_subquery".discussion_id)::text
  • Buffers: shared dirtied=664 hit=257657 read=144088