explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wDtB

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

Nested Loop Left Join (cost=0.15..11.69 rows=1 width=140) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on pg_authid (cost=0.00..1.22 rows=1 width=80) (actual rows= loops=)

  • Filter: rolcanlogin
3. 0.000 0.000 ↓ 0.0

Index Scan using pg_db_role_setting_databaseid_rol_index on pg_db_role_setting s (cost=0.15..8.17 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((setdatabase = '0'::oid) AND (pg_authid.oid = setrole))