explain.depesz.com

PostgreSQL's explain analyze made readable

Result: grPq

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 0.323 ↑ 16.7 6 1

Hash Left Join (cost=2.25..3.80 rows=100 width=440) (actual time=0.306..0.323 rows=6 loops=1)

  • Hash Cond: (s.usesysid = u.oid)
2. 0.065 0.272 ↑ 16.7 6 1

Hash Left Join (cost=1.05..2.32 rows=100 width=376) (actual time=0.260..0.272 rows=6 loops=1)

  • Hash Cond: (s.datid = d.oid)
3. 0.177 0.177 ↑ 16.7 6 1

Function Scan on pg_stat_get_activity s (cost=0.00..1.00 rows=100 width=312) (actual time=0.174..0.177 rows=6 loops=1)

4. 0.012 0.030 ↓ 2.5 5 1

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

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

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

6. 0.020 0.020 ↓ 1.1 10 1

Hash (cost=1.09..1.09 rows=9 width=68) (actual time=0.020..0.020 rows=10 loops=1)