explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XHny

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

Limit (cost=72.11..72.15 rows=16 width=382) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=72.11..72.15 rows=16 width=382) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=32.53..71.79 rows=16 width=382) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=31.79..54.20 rows=16 width=390) (never executed)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=31.64..37.12 rows=33 width=390) (never executed)

6. 0.000 0.000 ↓ 0.0

Seq Scan on portalgeschaeftspartner portalgesc1_ (cost=0.00..4.56 rows=156 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash (cost=31.02..31.02 rows=50 width=382) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.46..31.02 rows=50 width=382) (never executed)

9. 0.000 0.000 ↓ 0.0

Seq Scan on benutzer_benachrichtigungsoptionen dokumenteb3_ (cost=0.00..15.76 rows=77 width=8) (never executed)

  • Filter: (((kategorie)::text = 'DOKUMENTE'::text) AND ((aktiv)::text = 'JA'::text))
10. 0.000 0.000 ↓ 0.0

Hash (cost=12.71..12.71 rows=140 width=382) (never executed)

11. 0.000 0.000 ↓ 0.0

Seq Scan on benutzer hauptbenut0_ (cost=0.00..12.71 rows=140 width=382) (never executed)

  • Filter: ((aktiveadresse IS NOT NULL) AND ((benutzertyp)::text = 'HAUPTBENUTZER'::text))
12. 0.000 0.000 ↓ 0.0

Index Only Scan using benutzersperren_benutzer_id_sperrtyp_uq on benutzersperren benutzersp2_ (cost=0.15..0.51 rows=1 width=8) (never executed)

  • Index Cond: ((benutzer_id = hauptbenut0_.id) AND (sperrtyp = 'BENUTZER_ACCOUNT_SPERRE'::text))
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.74..1.27 rows=1 width=16) (never executed)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.60..1.01 rows=1 width=39) (never executed)

15. 0.000 0.000 ↓ 0.0

Index Only Scan using portalgeschaeftspartner_berechtigungstypen_pk on portalgeschaeftspartner_berechtigungstypen portalgesc5_ (cost=0.28..0.66 rows=4 width=31) (never executed)

  • Index Cond: (portalgeschaeftspartner_id = portalgesc1_.id)
16. 0.000 0.000 ↓ 0.0

Hash (cost=0.31..0.31 rows=1 width=8) (never executed)

17. 0.000 0.000 ↓ 0.0

Index Only Scan using portalgeschaeftspartner_pk on portalgeschaeftspartner portalgesc6_ (cost=0.14..0.31 rows=1 width=8) (never executed)

  • Index Cond: (id = hauptbenut0_.portalgeschaeftspartner_id)
18. 0.000 0.000 ↓ 0.0

Index Only Scan using berechtigungstypen_pk on berechtigungstypen berechtigu4_ (cost=0.15..0.25 rows=1 width=98) (never executed)

  • Index Cond: (id = (portalgesc5_.berechtigungstypen_id)::text)