explain.depesz.com

PostgreSQL's explain analyze made readable

Result: twp

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. 151,961.282 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