客户要求用pgsql,所在服务器装了一下pgsql,我出了一个pgsql的分类,看这篇文章前,把这个分类下的文章都可以看一下,这是我熟悉pgsql的一套流程。以前搞过一次pgsql,很早了。
1,查看数据库
- playboy=>l
- Listofdatabases
- Name|Owner|Encoding
- -----------+----------+----------
- playboy|postgres|UTF8
- postgres|postgres|UTF8
- template0|postgres|UTF8
- template1|postgres|UTF8
- playboy=>selectpg_database_size('playboy');
- pg_database_size
- ------------------
- 3637896
- (1row)
- playboy=>selectpg_database.datname,pg_database_size(pg_database.datname)ASsizefrompg_database;
- datname|size
- -----------+---------
- postgres|3621512
- playboy|3637896
- template1|3563524
- template0|3563524
- (4rows)
- playboy=>selectpg_size_pretty(pg_database_size('playboy'));
- pg_size_pretty
- ----------------
- 3553kB
- (1row)
2,查看多表
playboy=>dt
Listofrelations
Schema|Name|Type|Owner
--------+------+-------+---------
public|test|table|playboy
(1row)
3,查看单表
playboy=>dtest;
Table"public.test"
Column|Type|Modifiers
--------+-----------------------+-----------
id|integer|notnull
name|charactervarying(32)|
Indexes:"playboy_id_pk"PRIMARYKEY,btree(id)
playboy=>selectpg_relation_size('test');
pg_relation_size
------------------
0
(1row)
playboy=>selectpg_size_pretty(pg_relation_size('test'));
0bytes
playboy=>selectpg_size_pretty(pg_total_relation_size(//查看表的总大小,包括索引大小
8192bytes
(1row)
4,查看索引
playboy=>di
Schema|Name|Type|Owner|Table
--------+---------------+-------+---------+-------
public|playboy_id_pk|index|playboy|test
'playboy_id_pk'));
pg_size_pretty
----------------
8192bytes
(1row)
5,查看表空间,以及大小
playboy=>selectspcnamefrompg_tablespace;
spcname
------------
pg_default
pg_global
(2rows)
playboy=>selectpg_size_pretty(pg_tablespace_size('pg_default'));
14MB
(1row)
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|