explain.depesz.com

PostgreSQL's explain analyze made readable

Result: za6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.231 3.888 ↓ 1.3 87 1

Sort (cost=2,783.00..2,783.16 rows=65 width=68) (actual time=3.883..3.888 rows=87 loops=1)

  • Sort Key: n.nspname, (format_type(t.oid, NULL::integer))
  • Sort Method: quicksort Memory: 39kB
2. 2.589 3.657 ↓ 1.3 87 1

Nested Loop Left Join (cost=16.32..2,781.04 rows=65 width=68) (actual time=0.601..3.657 rows=87 loops=1)

  • Join Filter: (n.oid = t.typnamespace)
  • Rows Removed by Join Filter: 435
3. 0.078 0.981 ↓ 1.3 87 1

Hash Anti Join (cost=16.32..2,757.70 rows=65 width=8) (actual time=0.264..0.981 rows=87 loops=1)

  • Hash Cond: ((t.typelem = el.oid) AND (t.oid = el.typarray))
4. 0.466 0.662 ↓ 1.9 157 1

Seq Scan on pg_type t (cost=0.00..2,740.26 rows=81 width=12) (actual time=0.012..0.662 rows=157 loops=1)

  • Filter: (pg_type_is_visible(oid) AND ((typrelid = 0::oid) OR (SubPlan 1)))
  • Rows Removed by Filter: 185
5.          

SubPlan (forSeq Scan)

6. 0.196 0.196 ↑ 1.0 1 98

Index Scan using pg_class_oid_index on pg_class c (cost=0.15..8.17 rows=1 width=1) (actual time=0.002..0.002 rows=1 loops=98)

  • Index Cond: (oid = t.typrelid)
7. 0.111 0.241 ↓ 1.0 342 1

Hash (cost=11.33..11.33 rows=333 width=8) (actual time=0.241..0.241 rows=342 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
8. 0.130 0.130 ↓ 1.0 342 1

Seq Scan on pg_type el (cost=0.00..11.33 rows=333 width=8) (actual time=0.002..0.130 rows=342 loops=1)

9. 0.084 0.087 ↑ 1.0 6 87

Materialize (cost=0.00..1.09 rows=6 width=68) (actual time=0.000..0.001 rows=6 loops=87)

10. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on pg_namespace n (cost=0.00..1.06 rows=6 width=68) (actual time=0.002..0.003 rows=6 loops=1)