explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x2Ya

Settings
# exclusive inclusive rows x rows loops node
1. 0.261 0.386 ↑ 1.5 4 1

Nested Loop Left Join (cost=1.10..120.88 rows=6 width=176) (actual time=0.330..0.386 rows=4 loops=1)

2. 0.002 0.053 ↑ 1.5 4 1

Nested Loop Left Join (cost=0.70..30.04 rows=6 width=819) (actual time=0.042..0.053 rows=4 loops=1)

  • Join Filter: ((a.attrelid = pg_attrdef.adrelid) AND (a.attnum = pg_attrdef.adnum))
3. 0.035 0.035 ↑ 1.5 4 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.41..19.63 rows=6 width=342) (actual time=0.027..0.035 rows=4 loops=1)

  • Index Cond: (attrelid = (to_regclass('osusr_j4v_devicedatabasebinary_view1'::text))::oid)
  • Filter: (NOT attisdropped)
4. 0.004 0.016 ↓ 0.0 0 4

Materialize (cost=0.28..10.20 rows=2 width=479) (actual time=0.004..0.004 rows=0 loops=4)

5. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pg_attrdef_adrelid_adnum_index on pg_attrdef (cost=0.28..10.19 rows=2 width=479) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (adrelid = (to_regclass('osusr_j4v_devicedatabasebinary_view1'::text))::oid)
6. 0.032 0.032 ↑ 1.0 1 4

Index Scan using pg_type_oid_index on pg_type t (cost=0.41..8.43 rows=1 width=280) (actual time=0.008..0.008 rows=1 loops=4)

  • Index Cond: (a.atttypid = oid)
7.          

SubPlan (for Nested Loop Left Join)

8. 0.004 0.040 ↓ 0.0 0 4

Limit (cost=0.28..5.91 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=4)

9. 0.036 0.036 ↓ 0.0 0 4

Index Scan using pg_constraint_conrelid_contypid_conname_index on pg_constraint c (cost=0.28..11.55 rows=2 width=32) (actual time=0.009..0.009 rows=0 loops=4)

  • Index Cond: (conrelid = a.attrelid)
  • Filter: (contype <> ALL ('{t,x}'::"char"[]))