租户端 数据库 TDSQL PostgreSQL 版 开发指南 数据类型 json/jsonb类型 jsonb索引使用 测试查询的性能

测试查询的性能

最近更新时间: 2025-02-18 16:02:00

  • 复制
    复制成功
postgres=# select count(1) from t_jsonb;
  count   
----------
 10000000
(1 row)
postgres=# analyze t_jsonb;
ANALYZE
  • 没有索引开销
  • 复制
    复制成功
postgres=# select * from t_jsonb where f_jsonb @> '{"col1":9999}';
  id  |            f_jsonb             
------+--------------------------------
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
(5 rows)
Time: 2473.488 ms (00:02.473)
  • 有索引开销
  • 复制
    复制成功
postgres=# select * from t_jsonb where f_jsonb @> '{"col1":9999}';
  id  |            f_jsonb             
------+--------------------------------
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
 9999 | {"col1": 9999, "col2": "9999"}
(5 rows)
Time: 217.968 ms