explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fRQy

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.011 0.031 ↓ 0.0 0 1

Hash Join (cost=23.02..37.29 rows=115 width=96) (actual time=0.030..0.031 rows=0 loops=1)

  • Hash Cond: (tbl.relnamespace = ns.oid)
2. 0.001 0.003 ↓ 0.0 0 1

Hash Join (cost=21.89..34.49 rows=115 width=132) (actual time=0.003..0.003 rows=0 loops=1)

  • Hash Cond: (trg.tgrelid = tbl.oid)
3. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on pg_trigger trg (cost=0.00..12.30 rows=115 width=68) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (NOT tgisinternal)
4. 0.000 0.000 ↓ 0.0 0

Hash (cost=16.95..16.95 rows=395 width=72) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on pg_class tbl (cost=0.00..16.95 rows=395 width=72) (never executed)

6. 0.007 0.017 ↑ 1.0 6 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
7. 0.010 0.010 ↑ 1.0 6 1

Seq Scan on pg_namespace ns (cost=0.00..1.06 rows=6 width=68) (actual time=0.006..0.010 rows=6 loops=1)

Planning time : 0.247 ms
Execution time : 0.060 ms