Postgresql查询表和索引空间_pg的二维空间索引

--查询表空间 
planet_t1=# select pg_relation_size('s_ways.ways_road');
 pg_relation_size
------------------
      60497190912
(1 row)

planet_t1=# select pg_size_pretty(pg_relation_size('s_ways.ways_road'));
 pg_size_pretty
----------------
 56 GB
(1 row)

planet_t1=# select pg_size_pretty(pg_relation_size('public.ways'));
 pg_size_pretty
----------------
 225 GB
(1 row)

planet_t1=# select pg_size_pretty(pg_indexes_size('public.ways'));
 pg_size_pretty
----------------
 80 GB
(1 row)

--查询索引空间
planet_t1=# select pg_size_pretty(pg_indexes_size('s_ways.ways_road'));
 pg_size_pretty
----------------
 18 GB
(1 row)