explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8g4R

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.797 ↑ 1.0 1 1

Aggregate (cost=469.05..469.06 rows=1 width=1) (actual time=2.797..2.797 rows=1 loops=1)

2. 2.776 2.796 ↓ 0.0 0 1

Seq Scan on security_cache_122988 (cost=2.30..453.30 rows=6,301 width=0) (actual time=2.796..2.796 rows=0 loops=1)

  • Filter: (active AND (NOT (hashed SubPlan 1)) AND (userid = '122988'::bpchar) AND ((((subject)::text = 'system'::text) AND (roledata @> '{"items": ["HRAdmin"]}'::jsonb)) OR ((subject)::text <> 'system'::text)))
  • Rows Removed by Filter: 12622
3.          

SubPlan (forSeq Scan)

4. 0.000 0.020 ↑ 1.0 1 1

Unique (cost=0.28..2.30 rows=1 width=13) (actual time=0.020..0.020 rows=1 loops=1)

5. 0.020 0.020 ↑ 1.0 1 1

Index Only Scan using security_cache_invalidate_userid on security_cache_invalidate (cost=0.28..2.30 rows=1 width=13) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (userid = '122988'::bpchar)
  • Heap Fetches: 1