</sect4>

<sect4 id="aqo-query-stat-table">

<title>aqo_query_stat Table</title>

<para>

<para>

The <literal>aqo_query_stat</literal> table stores statistics

about query execution, by query type:

</para>

<itemizedlist spacing="compact">

<listitem>

<para>

execution time

</para>

</listitem>

<listitem>

<para>

planning time

</para>

</listitem>

<listitem>

<para>

cardinality estimation error in the selected query plans

</para>

</listitem>

</itemizedlist>

<para>

The <filename>aqo</filename> extension uses this data when the

about query execution, by query type. The <filename>aqo</filename> extension uses this data when the

<literal>auto_tuning</literal> option is enabled for a

particular query type.

</para>

<table id="aqo-query-stat-ref">

<title>aqo_query_stat Table</title>

<tgroup cols="2">

<thead>

<row><entry>Data</entry><entry>Description</entry>

</row>

</thead>

<tbody>

<row>

<entry><literal>execution_time_with_aqo</literal></entry>

<entry>Execution time for queries run with <filename>aqo</filename> enabled.</entry>

</row>

<row>

<entry><literal>execution_time_without_aqo</literal></entry>

<entry>Execution time for queries run with <filename>aqo</filename> disabled.</entry>

</row>

<row>

<entry><literal>planning_time_with_aqo</literal></entry>

<entry>Planning time for queries run with <filename>aqo</filename> enabled.</entry>

</row>

<row>

<entry><literal>planning_time_without_aqo</literal></entry>

<entry>Planning time for queries run with <filename>aqo</filename> disabled.</entry>

</row>

<row>

<entry><literal>cardinality_error_with_aqo</literal></entry>

<entry>Cardinality estimation error in the selected query plans with <filename>aqo</filename> enabled.</entry>

</row>

<row>

<entry><literal>cardinality_error_without_aqo</literal></entry>

<entry>Cardinality estimation error in the selected query plans with <filename>aqo</filename> disabled.</entry>

</row>

<row>

<entry><literal>executions_with_aqo</literal></entry>

<entry>Number of queries run with <filename>aqo</filename> enabled.</entry>

</row>

<row>

<entry><literal>executions_without_aqo</literal></entry>

<entry>Number of queries run with <filename>aqo</filename> disabled.</entry>

</row>

</tbody>

</tgroup>

</table>

</sect4>

</sect3>

</sect2>