explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 70op : Optimization for: plan #IFPK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.574 5.518 ↓ 1.0 4,082 1

Hash Join (cost=207.52..1,233.10 rows=4,014 width=2,372) (actual time=1.181..5.518 rows=4,082 loops=1)

  • Hash Cond: (permission0_.certificate_id = c.id)
2. 2.780 2.780 ↓ 1.0 4,082 1

Seq Scan on permission permission0_ (cost=0.00..970.38 rows=4,014 width=1,385) (actual time=0.009..2.780 rows=4,082 loops=1)

  • Filter: (((validuntil IS NULL) OR (validuntil >= '2019-03-11'::date)) AND (role <> ALL ('{61,70}'::integer[])))
  • Rows Removed by Filter: 477
3. 0.697 1.164 ↑ 1.0 1,308 1

Hash (cost=191.12..191.12 rows=1,312 width=995) (actual time=1.163..1.164 rows=1,308 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1331kB
4. 0.467 0.467 ↑ 1.0 1,308 1

Seq Scan on certificateocsp c (cost=0.00..191.12 rows=1,312 width=995) (actual time=0.002..0.467 rows=1,308 loops=1)