explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lb0M

Settings
# exclusive inclusive rows x rows loops node
1. 18,264.966 27,211.165 ↓ 1.0 8,354,373 1

Hash Join (cost=90.00..150,825.31 rows=8,353,223 width=8) (actual time=15.729..27,211.165 rows=8,354,373 loops=1)

  • Hash Cond: (a.permission = p.id)
  • Buffers: shared hit=45,266
2. 8,930.540 8,930.540 ↓ 1.0 8,354,373 1

Seq Scan on permission_in_acl a (cost=0.00..128,778.23 rows=8,353,223 width=16) (actual time=0.022..8,930.540 rows=8,354,373 loops=1)

  • Buffers: shared hit=45,246
3. 7.945 15.659 ↑ 1.0 3,111 1

Hash (cost=51.11..51.11 rows=3,111 width=8) (actual time=15.658..15.659 rows=3,111 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 154kB
  • Buffers: shared hit=20
4. 7.714 7.714 ↑ 1.0 3,111 1

Seq Scan on permission p (cost=0.00..51.11 rows=3,111 width=8) (actual time=0.016..7.714 rows=3,111 loops=1)

  • Buffers: shared hit=20
Planning time : 0.794 ms
Execution time : 35,478.676 ms