explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6pTX

Settings
# exclusive inclusive rows x rows loops node
1. 0.436 4.998 ↓ 89.4 447 1

Nested Loop Left Join (cost=144.06..179.21 rows=5 width=401) (actual time=4.368..4.998 rows=447 loops=1)

  • Buffers: shared hit=993
  • Execution Time: 5.139 msa
2. 0.167 4.562 ↓ 89.4 447 1

Hash Join (cost=143.93..177.92 rows=5 width=475) (actual time=4.360..4.562 rows=447 loops=1)

  • Hash Cond: ((s.starelid = c.oid) AND (s.staattnum = a.attnum))
  • Buffers: shared hit=99
3. 0.060 0.060 ↑ 1.0 447 1

Seq Scan on pg_statistic s (cost=0.00..29.47 rows=447 width=349) (actual time=0.012..0.060 rows=447 loops=1)

  • Buffers: shared hit=25
4. 0.964 4.335 ↓ 3.1 3,321 1

Hash (cost=127.70..127.70 rows=1,082 width=142) (actual time=4.335..4.335 rows=3,321 loops=1)

  • Buckets: 4,096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 597kB
  • Buffers: shared hit=74
5. 1.874 3.371 ↓ 3.1 3,321 1

Hash Join (cost=23.35..127.70 rows=1,082 width=142) (actual time=0.572..3.371 rows=3,321 loops=1)

  • Hash Cond: (a.attrelid = c.oid)
  • Join Filter: has_column_privilege(c.oid, a.attnum, 'select'::text)
  • Buffers: shared hit=74
6. 0.953 0.953 ↑ 1.0 3,321 1

Seq Scan on pg_attribute a (cost=0.00..95.52 rows=3,352 width=70) (actual time=0.011..0.953 rows=3,321 loops=1)

  • Filter: (NOT attisdropped)
  • Buffers: shared hit=62
7. 0.211 0.544 ↓ 1.0 462 1

Hash (cost=17.68..17.68 rows=454 width=72) (actual time=0.544..0.544 rows=462 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 55kB
  • Buffers: shared hit=12
8. 0.333 0.333 ↓ 1.0 462 1

Seq Scan on pg_class c (cost=0.00..17.68 rows=454 width=72) (actual time=0.010..0.333 rows=462 loops=1)

  • Filter: ((NOT relrowsecurity) OR (NOT row_security_active(oid)))
  • Buffers: shared hit=12
9. 0.000 0.000 ↑ 1.0 1 447

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

  • Index Cond: (oid = c.relnamespace)
  • Buffers: shared hit=894
Planning time : 1.834 ms