[postgis-users] Layer storage

Kevin Neufeld kneufeld at refractions.net
Mon Aug 24 08:33:37 PDT 2009


When you say layer, you mean database table?

http://www.postgresql.org/docs/8.4/static/functions-admin.html

pg_total_relation_size(regclass)

postgis=# select pg_total_relation_size('public.spatial_ref_sys'::regclass);
  pg_total_relation_size
------------------------
                   16384
(1 row)

-- Kevin

Donny Velazquez wrote:
> Is there a way to see how much space 1 layer takes up in the database?
> 
>  
> 
> Thanks
> 
>  
> 
> *Donny Velazquez **|** **Civil Solutions, a division of ARH** **| **GIS 
> Lead Software Developer***
> 
> 850 S. White Horse Pike, Hammonton, NJ 08037
> 
> ': 800.924.0482 ext 215| Fax: 609.704.8011
> 
> * dvela at arh-us.com
> 
> www.civilsolutions.biz <http://www.civilsolutions.biz/>
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list