SQL：pgsql创建、查询、删除索引

创建

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 systemtime_index;