explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZLGw

Settings
# exclusive inclusive rows x rows loops node
1. 15.516 15.637 ↑ 1.9 10,100 1

Nested Loop (cost=14.84..1,571.28 rows=19,341 width=89) (actual time=0.104..15.637 rows=10,100 loops=1)

2. 0.121 0.121 ↑ 1.0 100 1

Hash Right Join (cost=9.25..21.39 rows=100 width=121) (actual time=0.061..0.121 rows=100 loops=1)

  • Hash Cond: ((snap.associationadminmlulunobjectas