explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EjUr

Settings
# exclusive inclusive rows x rows loops node
1. 35,608.633 35,608.892 ↓ 1.3 9 1

Hash Join (cost=1.20..2.77 rows=7 width=192) (actual time=272.874..35,608.892 rows=9 loops=1)

  • Hash Cond: (d.oid = d_1.oid)
  • Buffers: shared hit=5
2. 0.245 0.245 ↓ 1.3 9 1

Seq Scan on pg_database d (cost=0.00..1.14 rows=7 width=68) (actual time=0.014..0.245 rows=9 loops=1)

  • Filter: ((datname <> 'rdsadmin'::name) AND (datname <> 'azure_maintenance'::name))
  • Buffers: shared hit=1
3. 0.007 0.014 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=4) (actual time=0.014..0.014 rows=9 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
4. 0.007 0.007 ↑ 1.0 9 1

Seq Scan on pg_database d_1 (cost=0.00..1.09 rows=9 width=4) (actual time=0.003..0.007 rows=9 loops=1)

  • Buffers: shared hit=1
Planning time : 2.284 ms
Execution time : 35,609.088 ms