explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U8Pj

Settings
# exclusive inclusive rows x rows loops node
1. 5.929 25,271.804 ↓ 324.0 324 1

Nested Loop (cost=1.79..55,546.90 rows=1 width=289) (actual time=30.064..25,271.804 rows=324 loops=1)

  • Join Filter: (a_1.attname = a.attname)
  • Rows Removed by Join Filter: 5274
2. 7.607 25,262.311 ↓ 324.0 324 1

Nested Loop (cost=1.37..55,511.38 rows=1 width=366) (actual time=30.027..25,262.311 rows=324 loops=1)

  • Join Filter: ((c_1.relname)::text = (c.relname)::text)
  • Rows Removed by Join Filter: 30294
3. 42.628 918.379 ↓ 325.0 325 1

Nested Loop (cost=0.96..46,756.72 rows=1 width=365) (actual time=29.922..918.379 rows=325 loops=1)

  • Join Filter: (n.nspname = n_1.nspname)
  • Rows Removed by Join Filter: 583700
4. 2.226 812.051 ↓ 325.0 325 1

Nested Loop Left Join (cost=0.96..46,689.98 rows=1 width=361) (actual time=29.914..812.051 rows=325 loops=1)

  • Join Filter: ((s_2.connamespace = n_1.oid) AND (s_2.conrelid = c_1.oid) AND (a_1.attnum = ANY (s_2.conkey)))
  • Rows Removed by Join Filter: 17172
5. 2.470 656.425 ↓ 325.0 325 1

Nested Loop Left Join (cost=0.96..46,607.51 rows=1 width=316) (actual time=29.456..656.425 rows=325 loops=1)

  • Join Filter: ((s_1.connamespace = n_1.oid) AND (s_1.conrelid = c_1.oid) AND (a_1.attnum = ANY (s_1.conkey)))
  • Rows Removed by Join Filter: 17172
6. 2.606 501.205 ↓ 325.0 325 1

Nested Loop Left Join (cost=0.96..46,525.09 rows=1 width=261) (actual time=28.973..501.205 rows=325 loops=1)

  • Join Filter: ((s.connamespace = n_1.oid) AND (s.conrelid = c_1.oid) AND (a_1.attnum = ANY (s.conkey)))
  • Rows Removed by Join Filter: 17172
7. 39.323 310.424 ↓ 325.0 325 1

Nested Loop (cost=0.96..46,442.68 rows=1 width=206) (actual time=28.123..310.424 rows=325 loops=1)

  • Join Filter: (c_1.relnamespace = n_1.oid)
  • Rows Removed by Join Filter: 583700
8. 1.609 197.976 ↓ 325.0 325 1

Nested Loop (cost=0.96..46,375.94 rows=1 width=142) (actual time=28.110..197.976 rows=325 loops=1)

  • Join Filter: (a_1.atttypid = t.oid)
  • Rows Removed by Join Filter: 13849
9. 0.044 0.044 ↑ 1.0 1 1

Index Scan using pg_type_typname_nsp_index on pg_type t (cost=0.54..16.55 rows=1 width=4) (actual time=0.043..0.044 rows=1 loops=1)

  • Index Cond: (typname = 'geometry'::name)
10. 2.431 196.323 ↓ 1.9 14,174 1

Nested Loop (cost=0.42..46,265.40 rows=7,519 width=146) (actual time=0.028..196.323 rows=14,174 loops=1)

11. 30.232 30.232 ↓ 1.0 980 1

Seq Scan on pg_class c_1 (cost=0.00..11,881.17 rows=947 width=72) (actual time=0.015..30.232 rows=980 loops=1)

  • Filter: ((relname <> 'raster_columns'::name) AND (NOT pg_is_other_temp_schema(relnamespace)) AND has_table_privilege(oid, 'SELECT'::text) AND (relkind = ANY ('{r,v,m,f}'::"char"[])))
  • Rows Removed by Filter: 2312
12. 163.660 163.660 ↓ 1.8 14 980

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a_1 (cost=0.42..36.23 rows=8 width=78) (actual time=0.119..0.167 rows=14 loops=980)

  • Index Cond: (attrelid = c_1.oid)
  • Filter: (NOT attisdropped)
  • Rows Removed by Filter: 0
13. 73.125 73.125 ↑ 1.0 1,797 325

Seq Scan on pg_namespace n_1 (cost=0.00..43.55 rows=1,855 width=68) (actual time=0.003..0.225 rows=1,797 loops=325)

14. 188.175 188.175 ↓ 1.0 53 325

Seq Scan on pg_constraint s (cost=0.00..80.99 rows=52 width=86) (actual time=0.151..0.579 rows=53 loops=325)

  • Filter: (consrc ~~* '%geometrytype(% = %'::text)
  • Rows Removed by Filter: 1388
15. 152.750 152.750 ↓ 1.0 53 325

Seq Scan on pg_constraint s_1 (cost=0.00..80.99 rows=52 width=86) (actual time=0.120..0.470 rows=53 loops=325)

  • Filter: (consrc ~~* '%ndims(% = %'::text)
  • Rows Removed by Filter: 1388
16. 153.400 153.400 ↑ 1.0 53 325

Seq Scan on pg_constraint s_2 (cost=0.00..80.99 rows=54 width=86) (actual time=0.120..0.472 rows=53 loops=325)

  • Filter: (consrc ~~* '%srid(% = %'::text)
  • Rows Removed by Filter: 1388
17. 63.700 63.700 ↑ 1.0 1,797 325

Seq Scan on pg_namespace n (cost=0.00..43.55 rows=1,855 width=68) (actual time=0.002..0.196 rows=1,797 loops=325)

18. 24,336.325 24,336.325 ↑ 1.4 94 325

Index Scan using pg_class_relname_nsp_index on pg_class c (cost=0.41..8,752.42 rows=128 width=73) (actual time=0.032..74.881 rows=94 loops=325)

  • Index Cond: (relnamespace = n.oid)
  • Filter: ((relkind = ANY ('{r,v}'::"char"[])) AND (relname !~ '^pg_'::text))
  • Rows Removed by Filter: 108
19. 3.564 3.564 ↓ 2.1 17 324

Index Scan using pg_attribute_relid_attnum_index on pg_attribute a (cost=0.42..35.38 rows=8 width=70) (actual time=0.007..0.011 rows=17 loops=324)

  • Index Cond: (attrelid = c.oid)
Planning time : 4.379 ms
Execution time : 25,272.130 ms