explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eiNv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2.074 ↑ 1.0 2,790 1

a (cost=0.28..213.97 rows=2,845 width=70) (actual time=0.033..2.074 rows=2,790 loops=1)

  • Filter: (NOT attisdropped)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=190
  • Planning Time: 5.054 ms
  • Execution Time: 11.970 ms
2. 1.477 1.869 ↑ 1.2 411 1

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

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

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

  • Buffers: shared hit=21
4. 2.466 2.466 ↑ 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.006..0.006 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
5. 1.233 1.233 ↑ 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.003..0.003 rows=1 loops=411)

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