explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4YKy

Settings
# exclusive inclusive rows x rows loops node
1. 11.916 61.516 ↑ 1.0 9,247 1

Merge Join (cost=162.96..1,120.93 rows=9,439 width=468) (actual time=4.405..61.516 rows=9,247 loops=1)

  • Merge Cond: (pg_class.oid = a.attrelid)
2. 3.013 4.722 ↑ 1.0 1,855 1

Sort (cost=162.68..167.33 rows=1,861 width=263) (actual time=4.362..4.722 rows=1,855 loops=1)

  • Sort Key: pg_class.oid
  • Sort Method: quicksort Memory: 541kB
3. 1.709 1.709 ↑ 1.0 1,855 1

Seq Scan on pg_class (cost=0.00..61.61 rows=1,861 width=263) (actual time=0.017..1.709 rows=1,855 loops=1)

4. 2.768 44.878 ↑ 1.0 9,247 1

Materialize (cost=0.29..812.08 rows=9,546 width=205) (actual time=0.034..44.878 rows=9,247 loops=1)

5. 42.110 42.110 ↑ 1.0 9,247 1

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.29..692.75 rows=9,546 width=205) (actual time=0.030..42.110 rows=9,247 loops=1)

Planning time : 30.703 ms
Execution time : 62.670 ms