explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6bMH

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.193 ↑ 111.1 9 1

Hash Left Join (cost=6.94..25.69 rows=1,000 width=602) (actual time=0.185..0.193 rows=9 loops=1)

  • Hash Cond: (l.pid = s.pid)
2. 0.073 0.073 ↑ 111.1 9 1

Function Scan on pg_lock_status l (cost=0.00..10.00 rows=1,000 width=162) (actual time=0.072..0.073 rows=9 loops=1)

3. 0.007 0.100 ↑ 16.7 6 1

Hash (cost=5.69..5.69 rows=100 width=440) (actual time=0.100..0.100 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.014 0.093 ↑ 16.7 6 1

Hash Left Join (cost=2.18..5.69 rows=100 width=440) (actual time=0.084..0.093 rows=6 loops=1)

  • Hash Cond: (s.usesysid = u.oid)
5. 0.053 0.068 ↑ 16.7 6 1

Hash Left Join (cost=1.05..3.30 rows=100 width=376) (actual time=0.062..0.068 rows=6 loops=1)

  • Hash Cond: (s.datid = d.oid)
  • -> Function Scan on pg_stat_get_activity s (cost=0.00..1.00 rows=100 width=312) (actual time=0.036..0.038 rows=6 loo
6. 0.005 0.015 ↓ 2.5 5 1

Hash (cost=1.02..1.02 rows=2 width=68) (actual time=0.015..0.015 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.010 0.010 ↓ 2.5 5 1

Seq Scan on pg_database d (cost=0.00..1.02 rows=2 width=68) (actual time=0.008..0.010 rows=5 loops=1)

8. 0.006 0.011 ↓ 1.3 8 1

Hash (cost=1.06..1.06 rows=6 width=68) (actual time=0.011..0.011 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.005 0.005 ↓ 1.3 8 1

Seq Scan on pg_authid u (cost=0.00..1.06 rows=6 width=68) (actual time=0.003..0.005 rows=8 loops=1)

Planning time : 0.367 ms
Execution time : 0.302 ms