explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SIXN

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 0.101 ↑ 1.0 134 1

Hash Left Join (cost=6.90..15.09 rows=134 width=53) (actual time=0.062..0.101 rows=134 loops=1)

  • Hash Cond: (portal_users.portal_id = portal.id)
2. 0.023 0.023 ↑ 1.0 134 1

Seq Scan on portal_users (cost=0.00..6.34 rows=134 width=30) (actual time=0.010..0.023 rows=134 loops=1)

3. 0.018 0.039 ↑ 1.0 129 1

Hash (cost=5.29..5.29 rows=129 width=23) (actual time=0.039..0.039 rows=129 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
4. 0.021 0.021 ↑ 1.0 129 1

Seq Scan on portal (cost=0.00..5.29 rows=129 width=23) (actual time=0.006..0.021 rows=129 loops=1)

Planning time : 0.146 ms
Execution time : 0.131 ms