explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RbSQ

Settings
# exclusive inclusive rows x rows loops node
1. 1.895 15.980 ↓ 68.5 411 1

Nested Loop Left Join (cost=48.60..287.51 rows=6 width=401) (actual time=3.086..15.980 rows=411 loops=1)

  • Buffers: shared hit=2266
2. 1.011 12.441 ↓ 68.5 411 1

Nested Loop (cost=48.47..285.93 rows=6 width=475) (actual time=3.042..12.441 rows=411 loops=1)

  • Join Filter: (s.starelid = c.oid)
  • Buffers: shared hit=1444
3. 1.913 7.731 ↓ 22.8 411 1

Merge Join (cost=48.20..279.99 rows=18 width=417) (actual time=3.000..7.731 rows=411 loops=1)

  • Merge Cond: ((a.attrelid = s.starelid) AND (a.attnum = s.staattnum))
  • Buffers: shared hit=211
4. 2.737 2.737 ↑ 1.0 2,790 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.28..213.97 rows=2,845 width=70) (actual time=0.042..2.737 rows=2,790 loops=1)

  • Filter: (NOT attisdropped)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=190
5. 2.417 3.081 ↑ 1.2 411 1

Sort (cost=47.92..49.15 rows=492 width=349) (actual time=2.895..3.081 rows=411 loops=1)

  • Sort Key: s.starelid, s.staattnum
  • Sort Method: quicksort Memory: 214kB
  • Buffers: shared hit=21
6. 0.664 0.664 ↑ 1.2 411 1

Seq Scan on pg_statistic s (cost=0.00..25.92 rows=492 width=349) (actual time=0.020..0.664 rows=411 loops=1)

  • Buffers: shared hit=21
7. 3.699 3.699 ↑ 1.0 1 411

Index Scan using pg_class_oid_index on pg_class c (cost=0.27..0.32 rows=1 width=72) (actual time=0.009..0.009 rows=1 loops=411)

  • Index Cond: (oid = a.attrelid)
  • Filter: (((NOT relrowsecurity) OR (NOT row_security_active(oid))) AND has_column_privilege(oid, a.attnum, 'select'::text))
  • Buffers: shared hit=1233
8. 1.644 1.644 ↑ 1.0 1 411

Index Scan using pg_namespace_oid_index on pg_namespace n (cost=0.13..0.18 rows=1 width=68) (actual time=0.004..0.004 rows=1 loops=411)

  • Index Cond: (oid = c.relnamespace)
  • Buffers: shared hit=822