explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iAy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=205.48..207.65 rows=1 width=927) (actual rows= loops=)

  • Output: c.id, c.certificate, c.issuer, c.serial, c.subject
  • Join Filter: (oc.organisation_id = orgs.organisation_id)
2.          

CTE orgs

3. 0.000 0.000 ↓ 0.0

Unique (cost=193.67..193.76 rows=18 width=4) (actual rows= loops=)

  • Output: ur.organisation_id
4. 0.000 0.000 ↓ 0.0

Sort (cost=193.67..193.71 rows=18 width=4) (actual rows= loops=)

  • Output: ur.organisation_id
  • Sort Key: ur.organisation_id
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..193.29 rows=18 width=4) (actual rows= loops=)

  • Output: ur.organisation_id
6. 0.000 0.000 ↓ 0.0

Seq Scan on iam_owner."user" u (cost=0.00..178.30 rows=1 width=4) (actual rows= loops=)

  • Output: u.id, u.email, u.pec_uid, u.username, u.fullname, u.creation_date, u.created_by, u.debtor_number, u.failed_login_attempts, u.password, u.password_modification_date, u.locked, u.lock_reason, u.modification_date, u.last_login_date, u.modified_by
  • Filter: ((u.username)::text ~~* 'albkamp'::text)
7. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_user_right on iam_owner.user_right ur (cost=0.42..14.80 rows=19 width=8) (actual rows= loops=)

  • Output: ur.user_id, ur.organisation_id, ur.application_right
  • Index Cond: (ur.user_id = u.id)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.72..13.31 rows=1 width=931) (actual rows= loops=)

  • Output: c.id, c.certificate, c.issuer, c.serial, c.subject, oc.organisation_id
  • Hash Cond: (oc.certificate_id = c.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on iam_owner.organisation_certificate oc (cost=0.00..1.42 rows=42 width=8) (actual rows= loops=)

  • Output: oc.certificate_id, oc.organisation_id
10. 0.000 0.000 ↓ 0.0

Hash (cost=11.71..11.71 rows=1 width=927) (actual rows= loops=)

  • Output: c.id, c.certificate, c.issuer, c.serial, c.subject
11. 0.000 0.000 ↓ 0.0

Seq Scan on iam_owner.certificate c (cost=0.00..11.71 rows=1 width=927) (actual rows= loops=)

  • Output: c.id, c.certificate, c.issuer, c.serial, c.subject
  • Filter: ((c.serial)::text = '78fd93c5ddf3cfd109329fb8'::text)
12. 0.000 0.000 ↓ 0.0

CTE Scan on orgs (cost=0.00..0.36 rows=18 width=4) (actual rows= loops=)

  • Output: orgs.organisation_id