explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y5mT

Settings
# exclusive inclusive rows x rows loops node
1. 0.423 4.591 ↓ 80.0 400 1

Nested Loop Left Join (cost=115.41..142.61 rows=5 width=401) (actual time=3.968..4.591 rows=400 loops=1)

  • -> Index Scan using pg_namespace_oid_index on pg_namespace n (cost=0.13..0.19 rows=1 width=68) (actual time=0.000..0.000
2. 0.234 4.168 ↓ 80.0 400 1

Hash Join (cost=115.27..141.28 rows=5 width=475) (actual time=3.955..4.168 rows=400 loops=1)

  • Hash Cond: ((s.starelid = c.oid) AND (s.staattnum = a.attnum))
  • Index Cond: (oid = c.relnamespace)
3. 0.072 0.072 ↓ 1.0 400 1

Seq Scan on pg_statistic s (cost=0.00..20.98 rows=398 width=349) (actual time=0.013..0.072 rows=400 loops=1)

4. 0.749 3.862 ↓ 3.0 2,627 1

Hash (cost=102.31..102.31 rows=864 width=142) (actual time=3.862..3.862 rows=2,627 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 479kB
5. 2.709 3.113 ↓ 3.0 2,627 1

Hash Join (cost=20.55..102.31 rows=864 width=142) (actual time=0.543..3.113 rows=2,627 loops=1)

  • Hash Cond: (a.attrelid = c.oid)
  • Join Filter: has_column_privilege(c.oid, a.attnum, 'select'::text)
  • -> Seq Scan on pg_attribute a (cost=0.00..74.92 rows=2592 width=70) (actual time=0.061..0.746 rows=2627
  • Filter: (NOT attisdropped)
6. 0.404 0.404 ↓ 1.0 347 1

Hash (cost=16.27..16.27 rows=342 width=72) (actual time=0.403..0.404 rows=347 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
  • -> Seq Scan on pg_class c (cost=0.00..16.27 rows=342 width=72) (actual time=0.012..0.249 rows=347
  • Filter: ((NOT relrowsecurity) OR (NOT row_security_active(oid)))