explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y2p

Settings
# exclusive inclusive rows x rows loops node
1. 100.318 129.597 ↑ 1.0 17,563 1

Hash Join (cost=1,484.87..7,490.99 rows=17,567 width=993) (actual time=17.712..129.597 rows=17,563 loops=1)

  • Hash Cond: ((t.sn)::text = (u.name)::text)
2. 11.689 11.689 ↑ 1.0 17,563 1

Seq Scan on terminals t (cost=0.00..1,826.63 rows=17,563 width=740) (actual time=0.018..11.689 rows=17,563 loops=1)

  • Filter: (id IS NOT NULL)
3. 13.270 17.590 ↓ 1.0 18,175 1

Hash (cost=635.72..635.72 rows=18,172 width=253) (actual time=17.590..17.590 rows=18,175 loops=1)

  • Buckets: 16384 Batches: 2 Memory Usage: 1914kB
4. 4.320 4.320 ↓ 1.0 18,175 1

Seq Scan on users u (cost=0.00..635.72 rows=18,172 width=253) (actual time=0.009..4.320 rows=18,175 loops=1)

Planning time : 0.287 ms
Execution time : 131.585 ms