如何将查询计划信息从Postgres获取到JDBC [英] How to get query plan information from Postgres into JDBC

问题描述

我想从解释"查询时所获得的查询计划中获取成本编号.有什么方法可以在Java ResultSet(或类似对象)中获取此数据?

I want to capture the cost numbers from the query plan you get when you 'Explain' a query. Is there any way to get at this data inside of a Java ResultSet(or similar object)?

推荐答案

当然，只需将其作为常规语句运行即可即可.

Sure, just run it as a regular statement:

Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("explain analyze select * from foo");
while (rs.next())
{
   System.out.println(rs.getString(1));
}

这篇关于如何将查询计划信息从Postgres获取到JDBC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！