explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mEPS

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

Hash Left Join (cost=2.18..3.73 rows=100 width=440) (actual rows= loops=)

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

Hash Left Join (cost=1.05..2.32 rows=100 width=376) (actual rows= loops=)

  • Hash Cond: (s.datid = d.oid)
3. 0.000 0.000 ↓ 0.0

Function Scan on pg_stat_get_activity s (cost=0.00..1.00 rows=100 width=312) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=2 width=68) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on pg_database d (cost=0.00..1.02 rows=2 width=68) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=1.06..1.06 rows=6 width=68) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on pg_authid u (cost=0.00..1.06 rows=6 width=68) (actual rows= loops=)