explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XsfS

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

Sort (cost=2.86..2.86 rows=1 width=77) (actual rows= loops=)

  • Sort Key: s.query_start
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.15..2.85 rows=1 width=77) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.02..2.66 rows=1 width=81) (actual rows= loops=)

  • Hash Cond: (s.usesysid = u.oid)
4. 0.000 0.000 ↓ 0.0

Function Scan on pg_stat_get_activity s (cost=0.00..1.25 rows=99 width=85) (actual rows= loops=)

  • Filter: (state <> 'idle'::text)
5. 0.000 0.000 ↓ 0.0

Hash (cost=1.01..1.01 rows=1 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on pg_authid u (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using pg_database_oid_index on pg_database d (cost=0.13..0.18 rows=1 width=4) (actual rows= loops=)