explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NzMy : teste

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.295 ↓ 0.0 0 1

Hash Join (cost=2.37..3.44 rows=1 width=337) (actual time=0.295..0.295 rows=0 loops=1)

  • Hash Cond: (d.oid = s.datid)
2. 0.005 0.005 ↑ 4.0 1 1

Seq Scan on pg_database d (cost=0.00..1.04 rows=4 width=68) (actual time=0.005..0.005 rows=1 loops=1)

3. 0.002 0.280 ↓ 0.0 0 1

Hash (cost=2.36..2.36 rows=1 width=273) (actual time=0.280..0.280 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
4. 0.005 0.278 ↓ 0.0 0 1

Hash Join (cost=1.26..2.36 rows=1 width=273) (actual time=0.278..0.278 rows=0 loops=1)

  • Hash Cond: (u.oid = s.usesysid)
5. 0.002 0.002 ↑ 6.0 1 1

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

6. 0.003 0.271 ↓ 0.0 0 1

Hash (cost=1.25..1.25 rows=1 width=209) (actual time=0.271..0.271 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
7. 0.268 0.268 ↓ 0.0 0 1

Function Scan on pg_stat_get_activity s (cost=0.00..1.25 rows=1 width=209) (actual time=0.268..0.268 rows=0 loops=1)

  • Filter: (pid = 109130)
  • Rows Removed by Filter: 54