创建

CREATE INDEX 索引名称 ON 表名 USING 索引类型 (字段)

CREATE INDEX systemtime_index ON buct_composedata USING btree (systemtime)

查询

select * from pg_indexes where tablename='buct_composedata';

select * from pg_statio_all_indexes where relname='buct_composedata';

删除

DROP INDEX 索引名称;

DROP INDEX systemtime_index;