explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ic8h

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=115.41..142.61 rows=5 width=401) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=115.27..141.28 rows=5 width=475) (actual rows= loops=)

  • Hash Cond: ((s.starelid = c.oid) AND (s.staattnum = a.attnum))
3. 0.000 0.000 ↓ 0.0

Seq Scan on pg_statistic s (cost=0.00..20.98 rows=398 width=349) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=102.31..102.31 rows=864 width=142) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=20.55..102.31 rows=864 width=142) (actual rows= loops=)

  • Hash Cond: (a.attrelid = c.oid)
  • Join Filter: has_column_privilege(c.oid, a.attnum, 'select'::text)
6. 0.000 0.000 ↓ 0.0

Seq Scan on pg_attribute a (cost=0.00..74.92 rows=2,592 width=70) (actual rows= loops=)

  • Filter: (NOT attisdropped)
7. 0.000 0.000 ↓ 0.0

Hash (cost=16.27..16.27 rows=342 width=72) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on pg_class c (cost=0.00..16.27 rows=342 width=72) (actual rows= loops=)

  • Filter: ((NOT relrowsecurity) OR (NOT row_security_active(oid)))
9. 0.000 0.000 ↓ 0.0

Index Scan using pg_namespace_oid_index on pg_namespace n (cost=0.13..0.19 rows=1 width=68) (actual rows= loops=)

  • Index Cond: (oid = c.relnamespace)