explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DnFA : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.204 ↑ 5.0 2 1

Hash Left Join (cost=1.48..2.98 rows=10 width=340) (actual time=0.201..0.204 rows=2 loops=1)

  • Hash Cond: (s.usesysid = u.oid)
2. 0.017 0.165 ↑ 5.0 2 1

Hash Join (cost=0.23..1.71 rows=10 width=276) (actual time=0.162..0.165 rows=2 loops=1)

  • Hash Cond: (s.pid = w.pid)
3. 0.099 0.099 ↑ 9.1 11 1

Function Scan on pg_stat_get_activity s (cost=0.00..1.00 rows=100 width=120) (actual time=0.097..0.099 rows=11 loops=1)

4. 0.021 0.049 ↑ 5.0 2 1

Hash (cost=0.10..0.10 rows=10 width=160) (actual time=0.049..0.049 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.028 0.028 ↑ 5.0 2 1

Function Scan on pg_stat_get_wal_senders w (cost=0.00..0.10 rows=10 width=160) (actual time=0.027..0.028 rows=2 loops=1)

6. 0.010 0.025 ↓ 1.3 14 1

Hash (cost=1.11..1.11 rows=11 width=68) (actual time=0.025..0.025 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
7. 0.015 0.015 ↓ 1.3 14 1

Seq Scan on pg_authid u (cost=0.00..1.11 rows=11 width=68) (actual time=0.013..0.015 rows=14 loops=1)

Planning time : 0.293 ms
Execution time : 0.379 ms