public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrei Lepikhov <[email protected]>
To: Alexander Kulikov <[email protected]>
To: [email protected]
Subject: Re: small database huge planning time
Date: Sat, 24 Jan 2026 23:12:54 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com>
References: <AS4PR02MB874303264FDEF9B160C06DF9EA8EA@AS4PR02MB8743.eurprd02.prod.outlook.com>
On 13/1/26 10:16, Alexander Kulikov wrote:
> Changing parameters: from_collapse_limit, join_collapse_limit, geqo, jit, work_mem and many
> others does not help at all. I attach 1. additional setting in the
> postgresql.status.conf. 2. querry itself in query.sql. 3. zql plan in
> query.sqlplan 4. additioanal information about os, tables etc. would you
> please help me -Alexander Kulikov
I have analysed your case (query-explain-1c.txt), thanks for the data
provided off-list.
In short, the main issue is the extensive use of MCV statistics on
(compressed) bytea columns.
The flamegraph of the planning process (see flamegraph-4999-1c.svg)
shows little, except that we spend a lot of time in the byteaeq routine.
Your tables contain many variable-length columns.
Look at the statistics on your tables (pgstats-1c.txt). There are
columns that exist containing 500 MCV elements and Histogram bins.
But how much do we actually touch these statistics and detoast these
massive arrays? Statistics on pg_statistic usage show my extension
pg_index_stats [1] - be careful, it is for research purposes for now! It
has been shown (see stat_used-1c.res) that some statistics were used 200
times or more during the planning of this query.
Column analysis exposes that _inforg10621::_fld10622rref and
_inforg8199::_fld8200_rrref are used in join clauses more than 6 times.
The _inforg10621::_fld15131rref is used in equality comparisons 7 times.
Remember, how many indexes your tables have, and you can imagine that
different combinations of parameterised index scan might add extra
clauses too.
Simple test: nullify the MCV of the two most used columns:
UPDATE pg_statistic
SET
stanumbers1 = CASE WHEN stakind1 = 1 THEN NULL ELSE stanumbers1 END,
stavalues1 = CASE WHEN stakind1 = 1 THEN NULL ELSE stavalues1 END,
stakind1 = CASE WHEN stakind1 = 1 THEN 0 ELSE stakind1 END,
stanumbers2 = CASE WHEN stakind2 = 1 THEN NULL ELSE stanumbers2 END,
stavalues2 = CASE WHEN stakind2 = 1 THEN NULL ELSE stavalues2 END,
stakind2 = CASE WHEN stakind2 = 1 THEN 0 ELSE stakind2 END
WHERE (starelid = '_inforg10621'::regclass AND staattnum = (
SELECT attnum FROM pg_attribute
WHERE (attrelid = '_inforg10621'::regclass AND attname =
'_fld10622rref')))
OR (starelid = '_inforg8199'::regclass AND staattnum = (
SELECT attnum FROM pg_attribute
WHERE (attrelid = '_inforg8199'::regclass AND attname =
'_fld8201rref')));
and now we see:
Planning:
Buffers: shared hit=5
Memory: used=4030kB allocated=4096kB
Planning Time: 31.347 ms
Execution Time: 0.237 ms
That's much better. Let's make the second check and launch this query on
the alternative Postgres fork (see query-explain-pgpro.txt) - same
version of Postgres (17.5). It touched almost 1500 buffers compared to 5
in the first case, but planning time is close to 0! Why?
Flamegraph seems to be the same (flamegraph-4999-pgpro.svg). Statistics
are exactly the same (pgstats-pgpro.txt). But pg_index_stats show that
it rarely ends up in the statistic slot (stats_used-pgpro). I suppose
here we have two factors: toast reading optimisation and (more
importantly) technique of caching recent statistic slots (in detoasted
and decompressed state).
What can you do? Not much, but still:
1. Reduce the statistical target on tables causing the problem, or just
nullify MCV statistics as I did in the example.
2. Complain to the vendor and force them to cache statistics.
[1] https://github.com/danolivo/pg_index_stats
--
regards, Andrei Lepikhov,
pgEdge
schemaname | tablename | column_name | n_distinct | mcv_count | histogram_bins | correlation | null_frac | avg_width
------------+---------------+-----------------+-------------+-----------+----------------+--------------+-----------+-----------
public | _inforg10621 | _fld10622rref | 1073 | 500 | 501 | 0.9152254 | 0 | 17
public | _inforg10621 | _fld10623rref | 162 | 162 | | 0.09570214 | 0 | 17
public | _inforg10621 | _fld10624_rrref | 45 | 45 | | 0.62922955 | 0 | 17
public | _inforg10621 | _fld10624_rtref | 3 | 3 | | 0.6892289 | 0 | 5
public | _inforg10621 | _fld10624_type | 2 | 2 | | 0.6972119 | 0 | 2
public | _inforg10621 | _fld10625 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10626 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10627 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10628 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld10629 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld15131rref | 161 | 161 | | 0.11234584 | 0 | 17
public | _inforg10621 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11507_rrref | -0.7140151 | 96 | 281 | -0.07345131 | 0 | 17
public | _inforg11506 | _fld11507_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11507_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11508rref | 10 | 10 | | 0.40504858 | 0 | 17
public | _inforg11506 | _fld11509_rrref | -0.7140151 | 96 | 281 | -0.07200607 | 0 | 17
public | _inforg11506 | _fld11509_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11509_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11510 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11511rref | 1 | 1 | | 1 | 0 | 17
public | _inforg11506 | _fld11512 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11513 | -0.50189394 | 263 | 2 | 0.99565864 | 0 | 8
public | _inforg11506 | _fld11514 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11515 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11516_rrref | 17 | 17 | | -0.0465909 | 0 | 17
public | _inforg11506 | _fld11516_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11516_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld3920 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld3921 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg11506 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg8199 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld8200_rrref | -0.367398 | 500 | 501 | -0.013070492 | 0 | 20
public | _inforg8199 | _fld8200_rtref | 28 | 16 | 12 | 0.54122746 | 0 | 8
public | _inforg8199 | _fld8200_type | 1 | 1 | | 1 | 0 | 5
public | _inforg8199 | _fld8201rref | 1104 | 500 | 501 | -0.23066422 | 0 | 20
public | _inforg8199 | _fld8202rref | 28 | 16 | 12 | 0.54122746 | 0 | 20
public | _inforg8199 | _fld8203 | 5 | 5 | | 0.6466329 | 0 | 4
public | _inforg8199 | _fld8204_rrref | 4 | 4 | | 0.99980766 | 0 | 20
public | _inforg8199 | _fld8204_rtref | 3 | 3 | | 0.99980766 | 0 | 8
public | _inforg8199 | _fld8204_type | 2 | 2 | | 0.9998094 | 0 | 5
public | _reference127 | _code | -1 | | 501 | 0.9443135 | 0 | 31
public | _reference127 | _description | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1459 | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _fld1776_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1776_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1776_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1777 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1778rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1779rref | 3 | 2 | | 0.9687825 | 0 | 17
public | _reference127 | _fld1780rref | 48 | 39 | 9 | -0.2917445 | 0 | 17
public | _reference127 | _fld1781rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1782 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1783rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1784 | 11 | 3 | 8 | 0.96876526 | 0 | 8
public | _reference127 | _fld1785 | 4 | 2 | 2 | 0.96883035 | 0 | 8
public | _reference127 | _fld1786 | 28 | 22 | 6 | 0.76139975 | 0 | 8
public | _reference127 | _fld1787 | -0.39789197 | 2 | 300 | 0.81572783 | 0 | 8
public | _reference127 | _fld1788 | -1 | | 501 | 0.94424146 | 0 | 8
public | _reference127 | _fld1789 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1790rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1791 | -0.5019763 | 98 | 283 | -0.21203266 | 0 | 132
public | _reference127 | _fld1792 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1793_rrref | 28 | 23 | 5 | 0.7010143 | 0 | 17
public | _reference127 | _fld1793_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1793_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1794rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1795 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1796 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1797 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1798 | 15 | 6 | 9 | 0.9886509 | 0 | 4
public | _reference127 | _fld1799 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1800rref | 46 | 39 | 7 | 0.57804096 | 0 | 17
public | _reference127 | _fld1801rref | 65 | 55 | 10 | 0.42004952 | 0 | 17
public | _reference127 | _fld1802 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1803_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1803_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1803_s | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1803_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1804 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1805rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1806rref | 46 | 35 | 11 | 0.53845924 | 0 | 17
public | _reference127 | _fld1807_rrref | 30 | 28 | 2 | -0.0657541 | 0 | 17
public | _reference127 | _fld1807_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1807_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1808_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1808_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1808_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1809rref | 9 | 9 | | -0.17734085 | 0 | 17
public | _reference127 | _fld1810_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1810_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1810_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1811_rrref | 14 | 10 | 4 | 0.68622756 | 0 | 17
public | _reference127 | _fld1811_rtref | 2 | 2 | | 0.72631794 | 0 | 5
public | _reference127 | _fld1811_type | 2 | 2 | | 0.72631794 | 0 | 2
public | _reference127 | _fld1812rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1813 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1814 | 2 | 2 | | 0.98784095 | 0 | 22
public | _reference127 | _fld1815 | 2 | 2 | | 0.89355975 | 0 | 1
public | _reference127 | _fld1816rref | 19 | 17 | 2 | 0.27056217 | 0 | 17
public | _reference127 | _fld1817rref | 3 | 3 | | 0.96886265 | 0 | 17
public | _reference127 | _fld1818rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1819 | -0.39130434 | 1 | 296 | 0.76031446 | 0 | 11
public | _reference127 | _fld1820rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1821 | -0.4387352 | 61 | 272 | 0.62197965 | 0 | 64
public | _reference127 | _fld1822_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1822_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1822_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1823 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1824 | -0.3043478 | 110 | 121 | 0.7274448 | 0 | 5
public | _reference127 | _fld1825 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1826 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1827 | -0.3043478 | 110 | 121 | 0.75412107 | 0 | 55
public | _reference127 | _fld1828rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1829 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1830_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1830_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1830_type | 2 | 2 | | 0.8860852 | 0 | 2
public | _reference127 | _fld1831_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1831_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1831_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1832rref | 2 | 2 | | 0.50350326 | 0 | 17
public | _reference127 | _fld1833 | -0.39262187 | 2 | 296 | 0.8355084 | 0 | 3
public | _reference127 | _fld1834rref | 47 | 40 | 7 | -0.29586703 | 0 | 17
public | _reference127 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _idrref | -1 | | 501 | 0.07025076 | 0 | 17
public | _reference127 | _marked | 2 | 2 | | -0.2822618 | 0 | 1
public | _reference127 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _version | 1 | 1 | | 1 | 0 | 4
public | _reference147 | _code | -1 | | | | 0 | 19
public | _reference147 | _description | -1 | | | | 0 | 27
public | _reference147 | _fld2132_rrref | -1 | | | | 0 | 17
public | _reference147 | _fld2132_rtref | -1 | | | | 0 | 5
public | _reference147 | _fld2132_type | -1 | | | | 0 | 2
public | _reference147 | _fld2133 | -1 | | | | 0 | 8
public | _reference147 | _fld2134 | -1 | | | | 0 | 1
public | _reference147 | _fld2135 | -1 | | | | 0 | 1
public | _reference147 | _fld809 | -1 | | | | 0 | 3
public | _reference147 | _idrref | -1 | | | | 0 | 17
public | _reference147 | _marked | -1 | | | | 0 | 1
public | _reference147 | _parentidrref | -1 | | | | 0 | 20
public | _reference147 | _predefinedid | -1 | | | | 0 | 20
public | _reference147 | _version | -1 | | | | 0 | 4
public | _reference312 | _code | -1 | | 501 | 0.8900151 | 0 | 101
public | _reference312 | _description | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4780_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4780_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4780_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4781_rrref | -0.5487805 | 135 | 180 | -0.24625185 | 0 | 17
public | _reference312 | _fld4781_rtref | 3 | 2 | | 0.9897413 | 0 | 5
public | _reference312 | _fld4781_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4782 | 1 | 1 | | 1 | 0 | 8
public | _reference312 | _fld4783 | -0.9982578 | 1 | 501 | 0.89001584 | 0 | 8
public | _reference312 | _fld4784 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4785 | 9 | 8 | | 0.9139689 | 0 | 5
public | _reference312 | _fld4786 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4787 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4788 | 2 | 2 | | 0.6711636 | 0 | 1
public | _reference312 | _fld4789 | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld4790rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4791_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4792rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4793rref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _fld4794_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4794_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4794_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4795 | -0.74390244 | 93 | 334 | 0.73108906 | 0 | 8
public | _reference312 | _fld4796 | -0.9982578 | 1 | 501 | 0.8900151 | 0 | 8
public | _reference312 | _fld4797 | 1 | 1 | | 1 | 0 | 101
public | _reference312 | _fld4798 | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4799 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4800 | -0.77874565 | 84 | 363 | 0.035318557 | 0 | 7
public | _reference312 | _fld4801 | 10 | 8 | 2 | 0.9465714 | 0 | 7
public | _reference312 | _fld4802rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4803 | 1 | 1 | | 1 | 0 | 19
public | _reference312 | _fld4804 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4805rref | 2 | 2 | | 0.9945617 | 0 | 17
public | _reference312 | _fld4806 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference312 | _idrref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _marked | 2 | 2 | | 0.56867975 | 0 | 1
public | _reference312 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference312 | _version | 1 | 1 | | 1 | 0 | 4
(191 rows)
# By pg_index_stats
Statistics used during query planning:
_inforg11506._fld11507_rtref: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_inforg10621._fld15131rref: 12 times, stats: { MCV: 161 values, Correlation, ndistinct: 161.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_type: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 2 }
_inforg8199._fld8200_rtref: 10 times, stats: { MCV: 16 values, Histogram: 12 values, Correlation, ndistinct: 28.0000, nullfrac: 0.0000, width: 8 }
_inforg10621._fld10622rref: 217 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1073.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2135: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 1 }
_reference147._idrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_inforg11506._fld809: 3 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11507_type: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 2 }
_reference147._fld809: 9 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 3 }
_inforg8199._fld8200_rrref: 7 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: -0.3674, nullfrac: 0.0000, width: 20 }
_reference312._fld809: 36 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11508rref: 1 times, stats: { MCV: 10 values, Correlation, ndistinct: 10.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rtref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 5 }
_reference127._fld809: 31 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11507_rrref: 1 times, stats: { MCV: 96 values, Histogram: 281 values, Correlation, ndistinct: -0.7140, nullfrac: 0.0000, width: 17 }
_inforg8199._fld809: 128 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_reference312._idrref: 2 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_inforg10621._fld809: 156 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg8199._fld8200_type: 10 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_inforg8199._fld8201rref: 195 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1104.0000, nullfrac: 0.0000, width: 20 }
_reference127._fld1806rref: 1 times, stats: { MCV: 35 values, Histogram: 11 values, Correlation, ndistinct: 46.0000, nullfrac: 0.0000, width: 17 }
_reference127._idrref: 1 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
Nested Loop Left Join (cost=1.33..12.15 rows=1 width=18) (actual time=0.014..0.016 rows=0 loops=1)
Buffers: shared hit=2
-> Nested Loop Left Join (cost=1.33..4.72 rows=1 width=19) (actual time=0.014..0.015 rows=0 loops=1)
Buffers: shared hit=2
-> Nested Loop Left Join (cost=0.11..2.35 rows=1 width=18) (actual time=0.014..0.014 rows=0 loops=1)
Buffers: shared hit=2
-> Index Scan using _reference127_s_hpk on _reference127 t1 (cost=0.11..2.33 rows=1 width=17) (actual time=0.013..0.013 rows=0 loops=1)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = '\\x00000000000000000000000000000000'::bytea))
Filter: (_fld1806rref = '\\x83ee005056be2b6311f08d4ce2699bc4'::bytea)
Buffers: shared hit=2
-> Seq Scan on _inforg12030 t3 (cost=0.00..0.01 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND (_fld12031rref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 3
-> Nested Loop (cost=0.33..7.40 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t4 (cost=0.16..2.42 rows=3 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t3._fld12031rref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t5 (cost=0.17..1.65 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t4._fld8201rref))
Heap Fetches: 0
-> Bitmap Heap Scan on _inforg11506 t7 (cost=1.22..2.36 rows=1 width=18) (never executed)
Recheck Cond: ((_fld809 = '0'::numeric) AND ('\\x08'::bytea = _fld11507_type) AND ('\\x0000007f'::bytea = _fld11507_rtref) AND (_fld11507_rrref = '\\x00000000000000000000000000000000'::bytea) AND (_fld11508rref = '\\x9f58005056bec67f11f0896cf79bbf9c'::bytea))
-> Bitmap Index Scan on _inforg11506_1 (cost=0.00..1.22 rows=1 width=0) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld11507_type = '\\x08'::bytea) AND (_fld11507_rtref = '\\x0000007f'::bytea) AND (_fld11507_rrref = '\\x00000000000000000000000000000000'::bytea) AND (_fld11508rref = '\\x9f58005056bec67f11f0896cf79bbf9c'::bytea))
SubPlan 11
-> Nested Loop Left Join (cost=9.77..23.81 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11509_type = '\\x01'::bytea) AND (t7._fld11509_rtref = '\\x00000000'::bytea) AND (t7._fld11509_rrref = '\\x00000000000000000000000000000000'::bytea)) OR ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 8)) OR (((t7._fld11509_type <> '\\x08'::bytea) OR (t7._fld11509_rtref <> '\\x00000138'::bytea)) AND (InitPlan 10).col1))
InitPlan 7
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t12 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11507_type) AND (_fld8200_rtref = t7._fld11507_rtref) AND (_fld8200_rrref = t7._fld11507_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t13 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t12._fld8201rref))
Heap Fetches: 0
InitPlan 10
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t16 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11509_type) AND (_fld8200_rtref = t7._fld11509_rtref) AND (_fld8200_rrref = t7._fld11509_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t17 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t16._fld8201rref))
Heap Fetches: 0
-> Nested Loop Left Join (cost=0.11..7.13 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 5)) OR (((t7._fld11507_type <> '\\x08'::bytea) OR (t7._fld11507_rtref <> '\\x00000138'::bytea)) AND (InitPlan 7).col1))
-> Result (cost=0.00..0.01 rows=1 width=0) (never executed)
-> Index Scan using _reference312_s_hpk on _reference312 t8 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11507_rrref))
SubPlan 5
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t10 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t8._fld4781_type) AND (_fld8200_rtref = t8._fld4781_rtref) AND (_fld8200_rrref = t8._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t11 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t10._fld8201rref))
Heap Fetches: 0
-> Index Scan using _reference312_s_hpk on _reference312 t9 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11509_rrref))
SubPlan 8
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t14 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t9._fld4781_type) AND (_fld8200_rtref = t9._fld4781_rtref) AND (_fld8200_rrref = t9._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t15 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t14._fld8201rref))
Heap Fetches: 0
-> Seq Scan on _inforg8926 t19 (cost=0.00..0.01 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND ('\\x08'::bytea = _fld8927_type) AND ('\\x0000007f'::bytea = _fld8927_rtref) AND (_fld8927_rrref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 14
-> Seq Scan on _reference147 t20 (cost=0.00..8.00 rows=1 width=0) (never executed)
Filter: ((t19._fld8928rref = _idrref) AND (_fld809 = '0'::numeric) AND (((_fld2132_type = '\\x08'::bytea) AND (_fld2132_rtref = '\\x00000110'::bytea) AND (_fld2132_rrref = '\\x8840005056bec73c11f0a4a3392378c8'::bytea)) OR ((NOT _fld2135) AND (ANY (_idrref = (hashed SubPlan 13).col1)))))
SubPlan 13
-> Nested Loop Semi Join (cost=0.33..7.13 rows=1 width=20) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t21 (cost=0.16..2.53 rows=1 width=40) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x00000093'::bytea))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t22 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t21._fld8201rref))
Heap Fetches: 0
SubPlan 1
-> Nested Loop (cost=0.33..7.40 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t23 (cost=0.16..2.42 rows=3 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t1._idrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t24 (cost=0.17..1.65 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t23._fld8201rref))
Heap Fetches: 0
Settings: effective_cache_size = '1GB', random_page_cost = '1.1', effective_io_concurrency = '200', work_mem = '1747kB', max_parallel_workers_per_gather = '3', max_parallel_workers = '6', enable_mergejoin = 'off', cpu_operator_cost = '0.001'
Planning:
Buffers: shared hit=5
Memory: used=4539kB allocated=5092kB
Planning Time: 421.608 ms
Execution Time: 0.145 ms
(95 rows)
Nested Loop Left Join (cost=0.22..46.05 rows=1 width=18) (actual time=0.144..0.146 rows=0 loops=1)
Buffers: shared read=2
-> Nested Loop Left Join (cost=0.22..33.26 rows=1 width=19) (actual time=0.144..0.145 rows=0 loops=1)
Buffers: shared read=2
-> Nested Loop Left Join (cost=0.11..7.11 rows=1 width=18) (actual time=0.144..0.144 rows=0 loops=1)
Buffers: shared read=2
-> Index Scan using _reference127_s_hpk on _reference127 t1 (cost=0.11..2.33 rows=1 width=17) (actual time=0.144..0.144 rows=0 loops=1)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = '\\x00000000000000000000000000000000'::bytea))
Filter: (_fld1806rref = '\\x83ee005056be2b6311f08d4ce2699bc4'::bytea)
Buffers: shared read=2
-> Seq Scan on _inforg12030 t3 (cost=0.00..4.78 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND (_fld12031rref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 3
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t4 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t3._fld12031rref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t5 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t4._fld8201rref))
Heap Fetches: 0
-> Index Only Scan using _inforg11506_1 on _inforg11506 t7 (cost=0.11..26.14 rows=1 width=18) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld11507_type = '\\x08'::bytea) AND (_fld11507_rtref = '\\x0000007f'::bytea) AND (_fld11507_rrref = '\\x00000000000000000000000000000000'::bytea) AND (_fld11508rref = '\\x9f58005056bec67f11f0896cf79bbf9c'::bytea))
Heap Fetches: 0
SubPlan 11
-> Nested Loop Left Join (cost=9.77..23.81 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11509_type = '\\x01'::bytea) AND (t7._fld11509_rtref = '\\x00000000'::bytea) AND (t7._fld11509_rrref = '\\x00000000000000000000000000000000'::bytea)) OR ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 8)) OR (((t7._fld11509_type <> '\\x08'::bytea) OR (t7._fld11509_rtref <> '\\x00000138'::bytea)) AND (InitPlan 10).col1))
InitPlan 7
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t12 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11507_type) AND (_fld8200_rtref = t7._fld11507_rtref) AND (_fld8200_rrref = t7._fld11507_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t13 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t12._fld8201rref))
Heap Fetches: 0
InitPlan 10
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t16 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11509_type) AND (_fld8200_rtref = t7._fld11509_rtref) AND (_fld8200_rrref = t7._fld11509_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t17 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t16._fld8201rref))
Heap Fetches: 0
-> Nested Loop Left Join (cost=0.11..7.13 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 5)) OR (((t7._fld11507_type <> '\\x08'::bytea) OR (t7._fld11507_rtref <> '\\x00000138'::bytea)) AND (InitPlan 7).col1))
-> Result (cost=0.00..0.01 rows=1 width=0) (never executed)
-> Index Scan using _reference312_s_hpk on _reference312 t8 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11507_rrref))
SubPlan 5
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t10 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t8._fld4781_type) AND (_fld8200_rtref = t8._fld4781_rtref) AND (_fld8200_rrref = t8._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t11 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t10._fld8201rref))
Heap Fetches: 0
-> Index Scan using _reference312_s_hpk on _reference312 t9 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11509_rrref))
SubPlan 8
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t14 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t9._fld4781_type) AND (_fld8200_rtref = t9._fld4781_rtref) AND (_fld8200_rrref = t9._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t15 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t14._fld8201rref))
Heap Fetches: 0
-> Seq Scan on _inforg8926 t19 (cost=0.00..8.00 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND ('\\x08'::bytea = _fld8927_type) AND ('\\x0000007f'::bytea = _fld8927_rtref) AND (_fld8927_rrref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 14
-> Seq Scan on _reference147 t20 (cost=0.00..8.00 rows=1 width=0) (never executed)
Filter: ((t19._fld8928rref = _idrref) AND (_fld809 = '0'::numeric) AND (((_fld2132_type = '\\x08'::bytea) AND (_fld2132_rtref = '\\x00000110'::bytea) AND (_fld2132_rrref = '\\x8840005056bec73c11f0a4a3392378c8'::bytea)) OR ((NOT _fld2135) AND (ANY (_idrref = (hashed SubPlan 13).col1)))))
SubPlan 13
-> Nested Loop Semi Join (cost=0.33..6.98 rows=1 width=20) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t21 (cost=0.16..2.38 rows=1 width=40) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x00000093'::bytea))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t22 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t21._fld8201rref))
Heap Fetches: 0
SubPlan 1
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t23 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t1._idrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t24 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t23._fld8201rref))
Heap Fetches: 0
Settings: effective_cache_size = '15GB', random_page_cost = '1.1', work_mem = '1747kB', max_parallel_workers_per_gather = '3', max_parallel_workers = '6', enable_mergejoin = 'off', cpu_operator_cost = '0.001'
Planning:
Buffers: shared hit=1448 read=111
Memory: used=3900kB allocated=4096kB
Planning Time: 0.000 ms
Execution Time: 0.549 ms
(94 rows)
schemaname | tablename | column_name | n_distinct | mcv_count | histogram_bins | correlation | null_frac | avg_width
------------+---------------+-----------------+-------------+-----------+----------------+--------------+-----------+-----------
public | _inforg10621 | _fld10622rref | 1073 | 500 | 501 | 0.9152254 | 0 | 17
public | _inforg10621 | _fld10623rref | 162 | 162 | | 0.09570214 | 0 | 17
public | _inforg10621 | _fld10624_rrref | 45 | 45 | | 0.62922955 | 0 | 17
public | _inforg10621 | _fld10624_rtref | 3 | 3 | | 0.6892289 | 0 | 5
public | _inforg10621 | _fld10624_type | 2 | 2 | | 0.6972119 | 0 | 2
public | _inforg10621 | _fld10625 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10626 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10627 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10628 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld10629 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld15131rref | 161 | 161 | | 0.11234584 | 0 | 17
public | _inforg10621 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11507_rrref | -0.7140151 | 96 | 281 | -0.07345131 | 0 | 17
public | _inforg11506 | _fld11507_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11507_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11508rref | 10 | 10 | | 0.40504858 | 0 | 17
public | _inforg11506 | _fld11509_rrref | -0.7140151 | 96 | 281 | -0.07200607 | 0 | 17
public | _inforg11506 | _fld11509_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11509_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11510 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11511rref | 1 | 1 | | 1 | 0 | 17
public | _inforg11506 | _fld11512 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11513 | -0.50189394 | 263 | 2 | 0.99565864 | 0 | 8
public | _inforg11506 | _fld11514 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11515 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11516_rrref | 17 | 17 | | -0.0465909 | 0 | 17
public | _inforg11506 | _fld11516_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11516_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld3920 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld3921 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg11506 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg8199 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld8200_rrref | -0.367398 | 500 | 501 | -0.013070492 | 0 | 20
public | _inforg8199 | _fld8200_rtref | 28 | 16 | 12 | 0.54122746 | 0 | 8
public | _inforg8199 | _fld8200_type | 1 | 1 | | 1 | 0 | 5
public | _inforg8199 | _fld8201rref | 1104 | 500 | 501 | -0.23066422 | 0 | 20
public | _inforg8199 | _fld8202rref | 28 | 16 | 12 | 0.54122746 | 0 | 20
public | _inforg8199 | _fld8203 | 5 | 5 | | 0.6466329 | 0 | 4
public | _inforg8199 | _fld8204_rrref | 4 | 4 | | 0.99980766 | 0 | 20
public | _inforg8199 | _fld8204_rtref | 3 | 3 | | 0.99980766 | 0 | 8
public | _inforg8199 | _fld8204_type | 2 | 2 | | 0.9998094 | 0 | 5
public | _reference127 | _code | -1 | | 501 | 0.9443135 | 0 | 31
public | _reference127 | _description | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1459 | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _fld1776_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1776_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1776_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1777 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1778rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1779rref | 3 | 2 | | 0.9687825 | 0 | 17
public | _reference127 | _fld1780rref | 48 | 39 | 9 | -0.2917445 | 0 | 17
public | _reference127 | _fld1781rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1782 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1783rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1784 | 11 | 3 | 8 | 0.96876526 | 0 | 8
public | _reference127 | _fld1785 | 4 | 2 | 2 | 0.96883035 | 0 | 8
public | _reference127 | _fld1786 | 28 | 22 | 6 | 0.76139975 | 0 | 8
public | _reference127 | _fld1787 | -0.39789197 | 2 | 300 | 0.81572783 | 0 | 8
public | _reference127 | _fld1788 | -1 | | 501 | 0.94424146 | 0 | 8
public | _reference127 | _fld1789 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1790rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1791 | -0.5019763 | 98 | 283 | -0.21203266 | 0 | 132
public | _reference127 | _fld1792 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1793_rrref | 28 | 23 | 5 | 0.7010143 | 0 | 17
public | _reference127 | _fld1793_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1793_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1794rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1795 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1796 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1797 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1798 | 15 | 6 | 9 | 0.9886509 | 0 | 4
public | _reference127 | _fld1799 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1800rref | 46 | 39 | 7 | 0.57804096 | 0 | 17
public | _reference127 | _fld1801rref | 65 | 55 | 10 | 0.42004952 | 0 | 17
public | _reference127 | _fld1802 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1803_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1803_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1803_s | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1803_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1804 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1805rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1806rref | 46 | 35 | 11 | 0.53845924 | 0 | 17
public | _reference127 | _fld1807_rrref | 30 | 28 | 2 | -0.0657541 | 0 | 17
public | _reference127 | _fld1807_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1807_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1808_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1808_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1808_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1809rref | 9 | 9 | | -0.17734085 | 0 | 17
public | _reference127 | _fld1810_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1810_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1810_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1811_rrref | 14 | 10 | 4 | 0.68622756 | 0 | 17
public | _reference127 | _fld1811_rtref | 2 | 2 | | 0.72631794 | 0 | 5
public | _reference127 | _fld1811_type | 2 | 2 | | 0.72631794 | 0 | 2
public | _reference127 | _fld1812rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1813 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1814 | 2 | 2 | | 0.98784095 | 0 | 22
public | _reference127 | _fld1815 | 2 | 2 | | 0.89355975 | 0 | 1
public | _reference127 | _fld1816rref | 19 | 17 | 2 | 0.27056217 | 0 | 17
public | _reference127 | _fld1817rref | 3 | 3 | | 0.96886265 | 0 | 17
public | _reference127 | _fld1818rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1819 | -0.39130434 | 1 | 296 | 0.76031446 | 0 | 11
public | _reference127 | _fld1820rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1821 | -0.4387352 | 61 | 272 | 0.62197965 | 0 | 64
public | _reference127 | _fld1822_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1822_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1822_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1823 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1824 | -0.3043478 | 110 | 121 | 0.7274448 | 0 | 5
public | _reference127 | _fld1825 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1826 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1827 | -0.3043478 | 110 | 121 | 0.75412107 | 0 | 55
public | _reference127 | _fld1828rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1829 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1830_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1830_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1830_type | 2 | 2 | | 0.8860852 | 0 | 2
public | _reference127 | _fld1831_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1831_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1831_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1832rref | 2 | 2 | | 0.50350326 | 0 | 17
public | _reference127 | _fld1833 | -0.39262187 | 2 | 296 | 0.8355084 | 0 | 3
public | _reference127 | _fld1834rref | 47 | 40 | 7 | -0.29586703 | 0 | 17
public | _reference127 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _idrref | -1 | | 501 | 0.07025076 | 0 | 17
public | _reference127 | _marked | 2 | 2 | | -0.2822618 | 0 | 1
public | _reference127 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _version | 1 | 1 | | 1 | 0 | 4
public | _reference147 | _code | -1 | | | | 0 | 19
public | _reference147 | _description | -1 | | | | 0 | 27
public | _reference147 | _fld2132_rrref | -1 | | | | 0 | 17
public | _reference147 | _fld2132_rtref | -1 | | | | 0 | 5
public | _reference147 | _fld2132_type | -1 | | | | 0 | 2
public | _reference147 | _fld2133 | -1 | | | | 0 | 8
public | _reference147 | _fld2134 | -1 | | | | 0 | 1
public | _reference147 | _fld2135 | -1 | | | | 0 | 1
public | _reference147 | _fld809 | -1 | | | | 0 | 3
public | _reference147 | _idrref | -1 | | | | 0 | 17
public | _reference147 | _marked | -1 | | | | 0 | 1
public | _reference147 | _parentidrref | -1 | | | | 0 | 20
public | _reference147 | _predefinedid | -1 | | | | 0 | 20
public | _reference147 | _version | -1 | | | | 0 | 4
public | _reference312 | _code | -1 | | 501 | 0.8900151 | 0 | 101
public | _reference312 | _description | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4780_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4780_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4780_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4781_rrref | -0.5487805 | 135 | 180 | -0.24625185 | 0 | 17
public | _reference312 | _fld4781_rtref | 3 | 2 | | 0.9897413 | 0 | 5
public | _reference312 | _fld4781_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4782 | 1 | 1 | | 1 | 0 | 8
public | _reference312 | _fld4783 | -0.9982578 | 1 | 501 | 0.89001584 | 0 | 8
public | _reference312 | _fld4784 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4785 | 9 | 8 | | 0.9139689 | 0 | 5
public | _reference312 | _fld4786 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4787 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4788 | 2 | 2 | | 0.6711636 | 0 | 1
public | _reference312 | _fld4789 | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld4790rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4791_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4792rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4793rref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _fld4794_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4794_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4794_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4795 | -0.74390244 | 93 | 334 | 0.73108906 | 0 | 8
public | _reference312 | _fld4796 | -0.9982578 | 1 | 501 | 0.8900151 | 0 | 8
public | _reference312 | _fld4797 | 1 | 1 | | 1 | 0 | 101
public | _reference312 | _fld4798 | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4799 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4800 | -0.77874565 | 84 | 363 | 0.035318557 | 0 | 7
public | _reference312 | _fld4801 | 10 | 8 | 2 | 0.9465714 | 0 | 7
public | _reference312 | _fld4802rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4803 | 1 | 1 | | 1 | 0 | 19
public | _reference312 | _fld4804 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4805rref | 2 | 2 | | 0.9945617 | 0 | 17
public | _reference312 | _fld4806 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference312 | _idrref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _marked | 2 | 2 | | 0.56867975 | 0 | 1
public | _reference312 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference312 | _version | 1 | 1 | | 1 | 0 | 4
(191 rows)
_reference147._fld2135: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 1 }
_reference147._fld2132_type: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 2 }
_reference147._idrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference127._idrref: 1 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld809: 9 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 3 }
_inforg10621._fld15131rref: 12 times, stats: { MCV: 161 values, Correlation, ndistinct: 161.0000, nullfrac: 0.0000, width: 17 }
_inforg10621._fld10622rref: 138 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1073.0000, nullfrac: 0.0000, width: 17 }
_inforg8199._fld8200_type: 10 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_inforg8199._fld8200_rtref: 10 times, stats: { MCV: 16 values, Histogram: 12 values, Correlation, ndistinct: 28.0000, nullfrac: 0.0000, width: 8 }
_inforg11506._fld809: 3 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11507_type: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 2 }
_inforg8199._fld809: 128 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_reference127._fld1806rref: 1 times, stats: { MCV: 35 values, Histogram: 11 values, Correlation, ndistinct: 46.0000, nullfrac: 0.0000, width: 17 }
_inforg11506._fld11507_rrref: 1 times, stats: { MCV: 96 values, Histogram: 281 values, Correlation, ndistinct: -0.7140, nullfrac: 0.0000, width: 17 }
_inforg8199._fld8200_rrref: 7 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: -0.3674, nullfrac: 0.0000, width: 20 }
_inforg11506._fld11508rref: 1 times, stats: { MCV: 10 values, Correlation, ndistinct: 10.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_inforg11506._fld11507_rtref: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_reference312._fld809: 36 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg10621._fld809: 156 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg8199._fld8201rref: 105 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1104.0000, nullfrac: 0.0000, width: 20 }
_reference312._idrref: 2 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rtref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 5 }
_reference127._fld809: 31 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
Attachments:
[image/svg+xml] flamegraph-4999-1c.svg (439.1K, ../[email protected]/2-flamegraph-4999-1c.svg)
download | view image
[text/plain] pgstats-1c.txt (24.1K, ../[email protected]/3-pgstats-1c.txt)
download | inline:
schemaname | tablename | column_name | n_distinct | mcv_count | histogram_bins | correlation | null_frac | avg_width
------------+---------------+-----------------+-------------+-----------+----------------+--------------+-----------+-----------
public | _inforg10621 | _fld10622rref | 1073 | 500 | 501 | 0.9152254 | 0 | 17
public | _inforg10621 | _fld10623rref | 162 | 162 | | 0.09570214 | 0 | 17
public | _inforg10621 | _fld10624_rrref | 45 | 45 | | 0.62922955 | 0 | 17
public | _inforg10621 | _fld10624_rtref | 3 | 3 | | 0.6892289 | 0 | 5
public | _inforg10621 | _fld10624_type | 2 | 2 | | 0.6972119 | 0 | 2
public | _inforg10621 | _fld10625 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10626 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10627 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10628 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld10629 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld15131rref | 161 | 161 | | 0.11234584 | 0 | 17
public | _inforg10621 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11507_rrref | -0.7140151 | 96 | 281 | -0.07345131 | 0 | 17
public | _inforg11506 | _fld11507_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11507_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11508rref | 10 | 10 | | 0.40504858 | 0 | 17
public | _inforg11506 | _fld11509_rrref | -0.7140151 | 96 | 281 | -0.07200607 | 0 | 17
public | _inforg11506 | _fld11509_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11509_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11510 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11511rref | 1 | 1 | | 1 | 0 | 17
public | _inforg11506 | _fld11512 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11513 | -0.50189394 | 263 | 2 | 0.99565864 | 0 | 8
public | _inforg11506 | _fld11514 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11515 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11516_rrref | 17 | 17 | | -0.0465909 | 0 | 17
public | _inforg11506 | _fld11516_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11516_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld3920 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld3921 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg11506 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg8199 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld8200_rrref | -0.367398 | 500 | 501 | -0.013070492 | 0 | 20
public | _inforg8199 | _fld8200_rtref | 28 | 16 | 12 | 0.54122746 | 0 | 8
public | _inforg8199 | _fld8200_type | 1 | 1 | | 1 | 0 | 5
public | _inforg8199 | _fld8201rref | 1104 | 500 | 501 | -0.23066422 | 0 | 20
public | _inforg8199 | _fld8202rref | 28 | 16 | 12 | 0.54122746 | 0 | 20
public | _inforg8199 | _fld8203 | 5 | 5 | | 0.6466329 | 0 | 4
public | _inforg8199 | _fld8204_rrref | 4 | 4 | | 0.99980766 | 0 | 20
public | _inforg8199 | _fld8204_rtref | 3 | 3 | | 0.99980766 | 0 | 8
public | _inforg8199 | _fld8204_type | 2 | 2 | | 0.9998094 | 0 | 5
public | _reference127 | _code | -1 | | 501 | 0.9443135 | 0 | 31
public | _reference127 | _description | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1459 | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _fld1776_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1776_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1776_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1777 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1778rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1779rref | 3 | 2 | | 0.9687825 | 0 | 17
public | _reference127 | _fld1780rref | 48 | 39 | 9 | -0.2917445 | 0 | 17
public | _reference127 | _fld1781rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1782 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1783rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1784 | 11 | 3 | 8 | 0.96876526 | 0 | 8
public | _reference127 | _fld1785 | 4 | 2 | 2 | 0.96883035 | 0 | 8
public | _reference127 | _fld1786 | 28 | 22 | 6 | 0.76139975 | 0 | 8
public | _reference127 | _fld1787 | -0.39789197 | 2 | 300 | 0.81572783 | 0 | 8
public | _reference127 | _fld1788 | -1 | | 501 | 0.94424146 | 0 | 8
public | _reference127 | _fld1789 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1790rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1791 | -0.5019763 | 98 | 283 | -0.21203266 | 0 | 132
public | _reference127 | _fld1792 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1793_rrref | 28 | 23 | 5 | 0.7010143 | 0 | 17
public | _reference127 | _fld1793_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1793_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1794rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1795 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1796 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1797 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1798 | 15 | 6 | 9 | 0.9886509 | 0 | 4
public | _reference127 | _fld1799 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1800rref | 46 | 39 | 7 | 0.57804096 | 0 | 17
public | _reference127 | _fld1801rref | 65 | 55 | 10 | 0.42004952 | 0 | 17
public | _reference127 | _fld1802 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1803_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1803_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1803_s | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1803_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1804 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1805rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1806rref | 46 | 35 | 11 | 0.53845924 | 0 | 17
public | _reference127 | _fld1807_rrref | 30 | 28 | 2 | -0.0657541 | 0 | 17
public | _reference127 | _fld1807_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1807_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1808_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1808_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1808_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1809rref | 9 | 9 | | -0.17734085 | 0 | 17
public | _reference127 | _fld1810_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1810_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1810_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1811_rrref | 14 | 10 | 4 | 0.68622756 | 0 | 17
public | _reference127 | _fld1811_rtref | 2 | 2 | | 0.72631794 | 0 | 5
public | _reference127 | _fld1811_type | 2 | 2 | | 0.72631794 | 0 | 2
public | _reference127 | _fld1812rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1813 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1814 | 2 | 2 | | 0.98784095 | 0 | 22
public | _reference127 | _fld1815 | 2 | 2 | | 0.89355975 | 0 | 1
public | _reference127 | _fld1816rref | 19 | 17 | 2 | 0.27056217 | 0 | 17
public | _reference127 | _fld1817rref | 3 | 3 | | 0.96886265 | 0 | 17
public | _reference127 | _fld1818rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1819 | -0.39130434 | 1 | 296 | 0.76031446 | 0 | 11
public | _reference127 | _fld1820rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1821 | -0.4387352 | 61 | 272 | 0.62197965 | 0 | 64
public | _reference127 | _fld1822_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1822_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1822_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1823 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1824 | -0.3043478 | 110 | 121 | 0.7274448 | 0 | 5
public | _reference127 | _fld1825 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1826 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1827 | -0.3043478 | 110 | 121 | 0.75412107 | 0 | 55
public | _reference127 | _fld1828rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1829 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1830_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1830_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1830_type | 2 | 2 | | 0.8860852 | 0 | 2
public | _reference127 | _fld1831_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1831_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1831_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1832rref | 2 | 2 | | 0.50350326 | 0 | 17
public | _reference127 | _fld1833 | -0.39262187 | 2 | 296 | 0.8355084 | 0 | 3
public | _reference127 | _fld1834rref | 47 | 40 | 7 | -0.29586703 | 0 | 17
public | _reference127 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _idrref | -1 | | 501 | 0.07025076 | 0 | 17
public | _reference127 | _marked | 2 | 2 | | -0.2822618 | 0 | 1
public | _reference127 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _version | 1 | 1 | | 1 | 0 | 4
public | _reference147 | _code | -1 | | | | 0 | 19
public | _reference147 | _description | -1 | | | | 0 | 27
public | _reference147 | _fld2132_rrref | -1 | | | | 0 | 17
public | _reference147 | _fld2132_rtref | -1 | | | | 0 | 5
public | _reference147 | _fld2132_type | -1 | | | | 0 | 2
public | _reference147 | _fld2133 | -1 | | | | 0 | 8
public | _reference147 | _fld2134 | -1 | | | | 0 | 1
public | _reference147 | _fld2135 | -1 | | | | 0 | 1
public | _reference147 | _fld809 | -1 | | | | 0 | 3
public | _reference147 | _idrref | -1 | | | | 0 | 17
public | _reference147 | _marked | -1 | | | | 0 | 1
public | _reference147 | _parentidrref | -1 | | | | 0 | 20
public | _reference147 | _predefinedid | -1 | | | | 0 | 20
public | _reference147 | _version | -1 | | | | 0 | 4
public | _reference312 | _code | -1 | | 501 | 0.8900151 | 0 | 101
public | _reference312 | _description | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4780_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4780_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4780_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4781_rrref | -0.5487805 | 135 | 180 | -0.24625185 | 0 | 17
public | _reference312 | _fld4781_rtref | 3 | 2 | | 0.9897413 | 0 | 5
public | _reference312 | _fld4781_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4782 | 1 | 1 | | 1 | 0 | 8
public | _reference312 | _fld4783 | -0.9982578 | 1 | 501 | 0.89001584 | 0 | 8
public | _reference312 | _fld4784 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4785 | 9 | 8 | | 0.9139689 | 0 | 5
public | _reference312 | _fld4786 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4787 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4788 | 2 | 2 | | 0.6711636 | 0 | 1
public | _reference312 | _fld4789 | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld4790rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4791_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4792rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4793rref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _fld4794_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4794_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4794_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4795 | -0.74390244 | 93 | 334 | 0.73108906 | 0 | 8
public | _reference312 | _fld4796 | -0.9982578 | 1 | 501 | 0.8900151 | 0 | 8
public | _reference312 | _fld4797 | 1 | 1 | | 1 | 0 | 101
public | _reference312 | _fld4798 | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4799 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4800 | -0.77874565 | 84 | 363 | 0.035318557 | 0 | 7
public | _reference312 | _fld4801 | 10 | 8 | 2 | 0.9465714 | 0 | 7
public | _reference312 | _fld4802rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4803 | 1 | 1 | | 1 | 0 | 19
public | _reference312 | _fld4804 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4805rref | 2 | 2 | | 0.9945617 | 0 | 17
public | _reference312 | _fld4806 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference312 | _idrref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _marked | 2 | 2 | | 0.56867975 | 0 | 1
public | _reference312 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference312 | _version | 1 | 1 | | 1 | 0 | 4
(191 rows)
[text/plain] stat_used-1c.res (3.0K, ../[email protected]/4-stat_used-1c.res)
download | inline:
# By pg_index_stats
Statistics used during query planning:
_inforg11506._fld11507_rtref: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_inforg10621._fld15131rref: 12 times, stats: { MCV: 161 values, Correlation, ndistinct: 161.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_type: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 2 }
_inforg8199._fld8200_rtref: 10 times, stats: { MCV: 16 values, Histogram: 12 values, Correlation, ndistinct: 28.0000, nullfrac: 0.0000, width: 8 }
_inforg10621._fld10622rref: 217 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1073.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2135: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 1 }
_reference147._idrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_inforg11506._fld809: 3 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11507_type: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 2 }
_reference147._fld809: 9 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 3 }
_inforg8199._fld8200_rrref: 7 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: -0.3674, nullfrac: 0.0000, width: 20 }
_reference312._fld809: 36 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11508rref: 1 times, stats: { MCV: 10 values, Correlation, ndistinct: 10.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rtref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 5 }
_reference127._fld809: 31 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11507_rrref: 1 times, stats: { MCV: 96 values, Histogram: 281 values, Correlation, ndistinct: -0.7140, nullfrac: 0.0000, width: 17 }
_inforg8199._fld809: 128 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_reference312._idrref: 2 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_inforg10621._fld809: 156 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg8199._fld8200_type: 10 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_inforg8199._fld8201rref: 195 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1104.0000, nullfrac: 0.0000, width: 20 }
_reference127._fld1806rref: 1 times, stats: { MCV: 35 values, Histogram: 11 values, Correlation, ndistinct: 46.0000, nullfrac: 0.0000, width: 17 }
_reference127._idrref: 1 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
[text/plain] query-explain-1c.txt (10.4K, ../[email protected]/5-query-explain-1c.txt)
download | inline:
Nested Loop Left Join (cost=1.33..12.15 rows=1 width=18) (actual time=0.014..0.016 rows=0 loops=1)
Buffers: shared hit=2
-> Nested Loop Left Join (cost=1.33..4.72 rows=1 width=19) (actual time=0.014..0.015 rows=0 loops=1)
Buffers: shared hit=2
-> Nested Loop Left Join (cost=0.11..2.35 rows=1 width=18) (actual time=0.014..0.014 rows=0 loops=1)
Buffers: shared hit=2
-> Index Scan using _reference127_s_hpk on _reference127 t1 (cost=0.11..2.33 rows=1 width=17) (actual time=0.013..0.013 rows=0 loops=1)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = '\\x00000000000000000000000000000000'::bytea))
Filter: (_fld1806rref = '\\x83ee005056be2b6311f08d4ce2699bc4'::bytea)
Buffers: shared hit=2
-> Seq Scan on _inforg12030 t3 (cost=0.00..0.01 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND (_fld12031rref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 3
-> Nested Loop (cost=0.33..7.40 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t4 (cost=0.16..2.42 rows=3 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t3._fld12031rref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t5 (cost=0.17..1.65 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t4._fld8201rref))
Heap Fetches: 0
-> Bitmap Heap Scan on _inforg11506 t7 (cost=1.22..2.36 rows=1 width=18) (never executed)
Recheck Cond: ((_fld809 = '0'::numeric) AND ('\\x08'::bytea = _fld11507_type) AND ('\\x0000007f'::bytea = _fld11507_rtref) AND (_fld11507_rrref = '\\x00000000000000000000000000000000'::bytea) AND (_fld11508rref = '\\x9f58005056bec67f11f0896cf79bbf9c'::bytea))
-> Bitmap Index Scan on _inforg11506_1 (cost=0.00..1.22 rows=1 width=0) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld11507_type = '\\x08'::bytea) AND (_fld11507_rtref = '\\x0000007f'::bytea) AND (_fld11507_rrref = '\\x00000000000000000000000000000000'::bytea) AND (_fld11508rref = '\\x9f58005056bec67f11f0896cf79bbf9c'::bytea))
SubPlan 11
-> Nested Loop Left Join (cost=9.77..23.81 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11509_type = '\\x01'::bytea) AND (t7._fld11509_rtref = '\\x00000000'::bytea) AND (t7._fld11509_rrref = '\\x00000000000000000000000000000000'::bytea)) OR ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 8)) OR (((t7._fld11509_type <> '\\x08'::bytea) OR (t7._fld11509_rtref <> '\\x00000138'::bytea)) AND (InitPlan 10).col1))
InitPlan 7
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t12 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11507_type) AND (_fld8200_rtref = t7._fld11507_rtref) AND (_fld8200_rrref = t7._fld11507_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t13 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t12._fld8201rref))
Heap Fetches: 0
InitPlan 10
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t16 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11509_type) AND (_fld8200_rtref = t7._fld11509_rtref) AND (_fld8200_rrref = t7._fld11509_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t17 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t16._fld8201rref))
Heap Fetches: 0
-> Nested Loop Left Join (cost=0.11..7.13 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 5)) OR (((t7._fld11507_type <> '\\x08'::bytea) OR (t7._fld11507_rtref <> '\\x00000138'::bytea)) AND (InitPlan 7).col1))
-> Result (cost=0.00..0.01 rows=1 width=0) (never executed)
-> Index Scan using _reference312_s_hpk on _reference312 t8 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11507_rrref))
SubPlan 5
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t10 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t8._fld4781_type) AND (_fld8200_rtref = t8._fld4781_rtref) AND (_fld8200_rrref = t8._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t11 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t10._fld8201rref))
Heap Fetches: 0
-> Index Scan using _reference312_s_hpk on _reference312 t9 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11509_rrref))
SubPlan 8
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t14 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t9._fld4781_type) AND (_fld8200_rtref = t9._fld4781_rtref) AND (_fld8200_rrref = t9._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t15 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t14._fld8201rref))
Heap Fetches: 0
-> Seq Scan on _inforg8926 t19 (cost=0.00..0.01 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND ('\\x08'::bytea = _fld8927_type) AND ('\\x0000007f'::bytea = _fld8927_rtref) AND (_fld8927_rrref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 14
-> Seq Scan on _reference147 t20 (cost=0.00..8.00 rows=1 width=0) (never executed)
Filter: ((t19._fld8928rref = _idrref) AND (_fld809 = '0'::numeric) AND (((_fld2132_type = '\\x08'::bytea) AND (_fld2132_rtref = '\\x00000110'::bytea) AND (_fld2132_rrref = '\\x8840005056bec73c11f0a4a3392378c8'::bytea)) OR ((NOT _fld2135) AND (ANY (_idrref = (hashed SubPlan 13).col1)))))
SubPlan 13
-> Nested Loop Semi Join (cost=0.33..7.13 rows=1 width=20) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t21 (cost=0.16..2.53 rows=1 width=40) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x00000093'::bytea))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t22 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t21._fld8201rref))
Heap Fetches: 0
SubPlan 1
-> Nested Loop (cost=0.33..7.40 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t23 (cost=0.16..2.42 rows=3 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t1._idrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t24 (cost=0.17..1.65 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t23._fld8201rref))
Heap Fetches: 0
Settings: effective_cache_size = '1GB', random_page_cost = '1.1', effective_io_concurrency = '200', work_mem = '1747kB', max_parallel_workers_per_gather = '3', max_parallel_workers = '6', enable_mergejoin = 'off', cpu_operator_cost = '0.001'
Planning:
Buffers: shared hit=5
Memory: used=4539kB allocated=5092kB
Planning Time: 421.608 ms
Execution Time: 0.145 ms
(95 rows)
[text/plain] query-explain-pgpro.txt (10.1K, ../[email protected]/6-query-explain-pgpro.txt)
download | inline:
Nested Loop Left Join (cost=0.22..46.05 rows=1 width=18) (actual time=0.144..0.146 rows=0 loops=1)
Buffers: shared read=2
-> Nested Loop Left Join (cost=0.22..33.26 rows=1 width=19) (actual time=0.144..0.145 rows=0 loops=1)
Buffers: shared read=2
-> Nested Loop Left Join (cost=0.11..7.11 rows=1 width=18) (actual time=0.144..0.144 rows=0 loops=1)
Buffers: shared read=2
-> Index Scan using _reference127_s_hpk on _reference127 t1 (cost=0.11..2.33 rows=1 width=17) (actual time=0.144..0.144 rows=0 loops=1)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = '\\x00000000000000000000000000000000'::bytea))
Filter: (_fld1806rref = '\\x83ee005056be2b6311f08d4ce2699bc4'::bytea)
Buffers: shared read=2
-> Seq Scan on _inforg12030 t3 (cost=0.00..4.78 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND (_fld12031rref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 3
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t4 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t3._fld12031rref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t5 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t4._fld8201rref))
Heap Fetches: 0
-> Index Only Scan using _inforg11506_1 on _inforg11506 t7 (cost=0.11..26.14 rows=1 width=18) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld11507_type = '\\x08'::bytea) AND (_fld11507_rtref = '\\x0000007f'::bytea) AND (_fld11507_rrref = '\\x00000000000000000000000000000000'::bytea) AND (_fld11508rref = '\\x9f58005056bec67f11f0896cf79bbf9c'::bytea))
Heap Fetches: 0
SubPlan 11
-> Nested Loop Left Join (cost=9.77..23.81 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11509_type = '\\x01'::bytea) AND (t7._fld11509_rtref = '\\x00000000'::bytea) AND (t7._fld11509_rrref = '\\x00000000000000000000000000000000'::bytea)) OR ((t7._fld11509_type = '\\x08'::bytea) AND (t7._fld11509_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 8)) OR (((t7._fld11509_type <> '\\x08'::bytea) OR (t7._fld11509_rtref <> '\\x00000138'::bytea)) AND (InitPlan 10).col1))
InitPlan 7
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t12 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11507_type) AND (_fld8200_rtref = t7._fld11507_rtref) AND (_fld8200_rrref = t7._fld11507_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t13 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t12._fld8201rref))
Heap Fetches: 0
InitPlan 10
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t16 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t7._fld11509_type) AND (_fld8200_rtref = t7._fld11509_rtref) AND (_fld8200_rrref = t7._fld11509_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t17 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t16._fld8201rref))
Heap Fetches: 0
-> Nested Loop Left Join (cost=0.11..7.13 rows=1 width=0) (never executed)
Join Filter: ((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea))
Filter: (((t7._fld11507_type = '\\x08'::bytea) AND (t7._fld11507_rtref = '\\x00000138'::bytea) AND EXISTS(SubPlan 5)) OR (((t7._fld11507_type <> '\\x08'::bytea) OR (t7._fld11507_rtref <> '\\x00000138'::bytea)) AND (InitPlan 7).col1))
-> Result (cost=0.00..0.01 rows=1 width=0) (never executed)
-> Index Scan using _reference312_s_hpk on _reference312 t8 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11507_rrref))
SubPlan 5
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t10 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t8._fld4781_type) AND (_fld8200_rtref = t8._fld4781_rtref) AND (_fld8200_rrref = t8._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t11 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t10._fld8201rref))
Heap Fetches: 0
-> Index Scan using _reference312_s_hpk on _reference312 t9 (cost=0.11..2.33 rows=1 width=24) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_idrref = t7._fld11509_rrref))
SubPlan 8
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t14 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = t9._fld4781_type) AND (_fld8200_rtref = t9._fld4781_rtref) AND (_fld8200_rrref = t9._fld4781_rrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t15 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t14._fld8201rref))
Heap Fetches: 0
-> Seq Scan on _inforg8926 t19 (cost=0.00..8.00 rows=1 width=33) (never executed)
Filter: ((_fld809 = '0'::numeric) AND ('\\x08'::bytea = _fld8927_type) AND ('\\x0000007f'::bytea = _fld8927_rtref) AND (_fld8927_rrref = '\\x00000000000000000000000000000000'::bytea))
SubPlan 14
-> Seq Scan on _reference147 t20 (cost=0.00..8.00 rows=1 width=0) (never executed)
Filter: ((t19._fld8928rref = _idrref) AND (_fld809 = '0'::numeric) AND (((_fld2132_type = '\\x08'::bytea) AND (_fld2132_rtref = '\\x00000110'::bytea) AND (_fld2132_rrref = '\\x8840005056bec73c11f0a4a3392378c8'::bytea)) OR ((NOT _fld2135) AND (ANY (_idrref = (hashed SubPlan 13).col1)))))
SubPlan 13
-> Nested Loop Semi Join (cost=0.33..6.98 rows=1 width=20) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t21 (cost=0.16..2.38 rows=1 width=40) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x00000093'::bytea))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t22 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t21._fld8201rref))
Heap Fetches: 0
SubPlan 1
-> Nested Loop (cost=0.33..4.78 rows=1 width=0) (never executed)
-> Index Only Scan using _inforg8199_1 on _inforg8199 t23 (cost=0.16..2.38 rows=1 width=20) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld8200_type = '\\x08'::bytea) AND (_fld8200_rtref = '\\x0000007f'::bytea) AND (_fld8200_rrref = t1._idrref))
Heap Fetches: 0
-> Index Only Scan using _inforg10621_2 on _inforg10621 t24 (cost=0.17..2.38 rows=1 width=17) (never executed)
Index Cond: ((_fld809 = '0'::numeric) AND (_fld15131rref = '\\x8840005056bec73c11f0a4a33fd169be'::bytea) AND (_fld10622rref = t23._fld8201rref))
Heap Fetches: 0
Settings: effective_cache_size = '15GB', random_page_cost = '1.1', work_mem = '1747kB', max_parallel_workers_per_gather = '3', max_parallel_workers = '6', enable_mergejoin = 'off', cpu_operator_cost = '0.001'
Planning:
Buffers: shared hit=1448 read=111
Memory: used=3900kB allocated=4096kB
Planning Time: 0.000 ms
Execution Time: 0.549 ms
(94 rows)
[image/svg+xml] flamegraph-4999-pgpro.svg (713.3K, ../[email protected]/7-flamegraph-4999-pgpro.svg)
download | view image
[text/plain] pgstats-pgpro.txt (24.1K, ../[email protected]/8-pgstats-pgpro.txt)
download | inline:
schemaname | tablename | column_name | n_distinct | mcv_count | histogram_bins | correlation | null_frac | avg_width
------------+---------------+-----------------+-------------+-----------+----------------+--------------+-----------+-----------
public | _inforg10621 | _fld10622rref | 1073 | 500 | 501 | 0.9152254 | 0 | 17
public | _inforg10621 | _fld10623rref | 162 | 162 | | 0.09570214 | 0 | 17
public | _inforg10621 | _fld10624_rrref | 45 | 45 | | 0.62922955 | 0 | 17
public | _inforg10621 | _fld10624_rtref | 3 | 3 | | 0.6892289 | 0 | 5
public | _inforg10621 | _fld10624_type | 2 | 2 | | 0.6972119 | 0 | 2
public | _inforg10621 | _fld10625 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10626 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10627 | 2 | 2 | | 0.5662952 | 0 | 1
public | _inforg10621 | _fld10628 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld10629 | 1 | 1 | | 1 | 0 | 1
public | _inforg10621 | _fld15131rref | 161 | 161 | | 0.11234584 | 0 | 17
public | _inforg10621 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg10621 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11507_rrref | -0.7140151 | 96 | 281 | -0.07345131 | 0 | 17
public | _inforg11506 | _fld11507_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11507_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11508rref | 10 | 10 | | 0.40504858 | 0 | 17
public | _inforg11506 | _fld11509_rrref | -0.7140151 | 96 | 281 | -0.07200607 | 0 | 17
public | _inforg11506 | _fld11509_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11509_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld11510 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11511rref | 1 | 1 | | 1 | 0 | 17
public | _inforg11506 | _fld11512 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11513 | -0.50189394 | 263 | 2 | 0.99565864 | 0 | 8
public | _inforg11506 | _fld11514 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld11515 | 1 | 1 | | 1 | 0 | 3
public | _inforg11506 | _fld11516_rrref | 17 | 17 | | -0.0465909 | 0 | 17
public | _inforg11506 | _fld11516_rtref | 1 | 1 | | 1 | 0 | 5
public | _inforg11506 | _fld11516_type | 1 | 1 | | 1 | 0 | 2
public | _inforg11506 | _fld3920 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld3921 | 1 | 1 | | 1 | 0 | 1
public | _inforg11506 | _fld7826 | 1 | 1 | | 1 | 0 | 20
public | _inforg11506 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld7827 | 1 | 1 | | 1 | 0 | 20
public | _inforg8199 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _inforg8199 | _fld8200_rrref | -0.367398 | 500 | 501 | -0.013070492 | 0 | 20
public | _inforg8199 | _fld8200_rtref | 28 | 16 | 12 | 0.54122746 | 0 | 8
public | _inforg8199 | _fld8200_type | 1 | 1 | | 1 | 0 | 5
public | _inforg8199 | _fld8201rref | 1104 | 500 | 501 | -0.23066422 | 0 | 20
public | _inforg8199 | _fld8202rref | 28 | 16 | 12 | 0.54122746 | 0 | 20
public | _inforg8199 | _fld8203 | 5 | 5 | | 0.6466329 | 0 | 4
public | _inforg8199 | _fld8204_rrref | 4 | 4 | | 0.99980766 | 0 | 20
public | _inforg8199 | _fld8204_rtref | 3 | 3 | | 0.99980766 | 0 | 8
public | _inforg8199 | _fld8204_type | 2 | 2 | | 0.9998094 | 0 | 5
public | _reference127 | _code | -1 | | 501 | 0.9443135 | 0 | 31
public | _reference127 | _description | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1459 | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _fld1776_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1776_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1776_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1777 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1778rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1779rref | 3 | 2 | | 0.9687825 | 0 | 17
public | _reference127 | _fld1780rref | 48 | 39 | 9 | -0.2917445 | 0 | 17
public | _reference127 | _fld1781rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1782 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1783rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1784 | 11 | 3 | 8 | 0.96876526 | 0 | 8
public | _reference127 | _fld1785 | 4 | 2 | 2 | 0.96883035 | 0 | 8
public | _reference127 | _fld1786 | 28 | 22 | 6 | 0.76139975 | 0 | 8
public | _reference127 | _fld1787 | -0.39789197 | 2 | 300 | 0.81572783 | 0 | 8
public | _reference127 | _fld1788 | -1 | | 501 | 0.94424146 | 0 | 8
public | _reference127 | _fld1789 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1790rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1791 | -0.5019763 | 98 | 283 | -0.21203266 | 0 | 132
public | _reference127 | _fld1792 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1793_rrref | 28 | 23 | 5 | 0.7010143 | 0 | 17
public | _reference127 | _fld1793_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1793_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1794rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1795 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1796 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1797 | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1798 | 15 | 6 | 9 | 0.9886509 | 0 | 4
public | _reference127 | _fld1799 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1800rref | 46 | 39 | 7 | 0.57804096 | 0 | 17
public | _reference127 | _fld1801rref | 65 | 55 | 10 | 0.42004952 | 0 | 17
public | _reference127 | _fld1802 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1803_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1803_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1803_s | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1803_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1804 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1805rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1806rref | 46 | 35 | 11 | 0.53845924 | 0 | 17
public | _reference127 | _fld1807_rrref | 30 | 28 | 2 | -0.0657541 | 0 | 17
public | _reference127 | _fld1807_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1807_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1808_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1808_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1808_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1809rref | 9 | 9 | | -0.17734085 | 0 | 17
public | _reference127 | _fld1810_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1810_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1810_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1811_rrref | 14 | 10 | 4 | 0.68622756 | 0 | 17
public | _reference127 | _fld1811_rtref | 2 | 2 | | 0.72631794 | 0 | 5
public | _reference127 | _fld1811_type | 2 | 2 | | 0.72631794 | 0 | 2
public | _reference127 | _fld1812rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1813 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1814 | 2 | 2 | | 0.98784095 | 0 | 22
public | _reference127 | _fld1815 | 2 | 2 | | 0.89355975 | 0 | 1
public | _reference127 | _fld1816rref | 19 | 17 | 2 | 0.27056217 | 0 | 17
public | _reference127 | _fld1817rref | 3 | 3 | | 0.96886265 | 0 | 17
public | _reference127 | _fld1818rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1819 | -0.39130434 | 1 | 296 | 0.76031446 | 0 | 11
public | _reference127 | _fld1820rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1821 | -0.4387352 | 61 | 272 | 0.62197965 | 0 | 64
public | _reference127 | _fld1822_rrref | 31 | 27 | 4 | -0.08488945 | 0 | 17
public | _reference127 | _fld1822_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference127 | _fld1822_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1823 | 1 | 1 | | 1 | 0 | 8
public | _reference127 | _fld1824 | -0.3043478 | 110 | 121 | 0.7274448 | 0 | 5
public | _reference127 | _fld1825 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _fld1826 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1827 | -0.3043478 | 110 | 121 | 0.75412107 | 0 | 55
public | _reference127 | _fld1828rref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1829 | 1 | 1 | | 1 | 0 | 1
public | _reference127 | _fld1830_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1830_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1830_type | 2 | 2 | | 0.8860852 | 0 | 2
public | _reference127 | _fld1831_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference127 | _fld1831_rtref | 2 | 2 | | 0.8860852 | 0 | 5
public | _reference127 | _fld1831_type | 1 | 1 | | 1 | 0 | 2
public | _reference127 | _fld1832rref | 2 | 2 | | 0.50350326 | 0 | 17
public | _reference127 | _fld1833 | -0.39262187 | 2 | 296 | 0.8355084 | 0 | 3
public | _reference127 | _fld1834rref | 47 | 40 | 7 | -0.29586703 | 0 | 17
public | _reference127 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference127 | _idrref | -1 | | 501 | 0.07025076 | 0 | 17
public | _reference127 | _marked | 2 | 2 | | -0.2822618 | 0 | 1
public | _reference127 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference127 | _version | 1 | 1 | | 1 | 0 | 4
public | _reference147 | _code | -1 | | | | 0 | 19
public | _reference147 | _description | -1 | | | | 0 | 27
public | _reference147 | _fld2132_rrref | -1 | | | | 0 | 17
public | _reference147 | _fld2132_rtref | -1 | | | | 0 | 5
public | _reference147 | _fld2132_type | -1 | | | | 0 | 2
public | _reference147 | _fld2133 | -1 | | | | 0 | 8
public | _reference147 | _fld2134 | -1 | | | | 0 | 1
public | _reference147 | _fld2135 | -1 | | | | 0 | 1
public | _reference147 | _fld809 | -1 | | | | 0 | 3
public | _reference147 | _idrref | -1 | | | | 0 | 17
public | _reference147 | _marked | -1 | | | | 0 | 1
public | _reference147 | _parentidrref | -1 | | | | 0 | 20
public | _reference147 | _predefinedid | -1 | | | | 0 | 20
public | _reference147 | _version | -1 | | | | 0 | 4
public | _reference312 | _code | -1 | | 501 | 0.8900151 | 0 | 101
public | _reference312 | _description | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld1269rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4780_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4780_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4780_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4781_rrref | -0.5487805 | 135 | 180 | -0.24625185 | 0 | 17
public | _reference312 | _fld4781_rtref | 3 | 2 | | 0.9897413 | 0 | 5
public | _reference312 | _fld4781_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4782 | 1 | 1 | | 1 | 0 | 8
public | _reference312 | _fld4783 | -0.9982578 | 1 | 501 | 0.89001584 | 0 | 8
public | _reference312 | _fld4784 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4785 | 9 | 8 | | 0.9139689 | 0 | 5
public | _reference312 | _fld4786 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4787 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4788 | 2 | 2 | | 0.6711636 | 0 | 1
public | _reference312 | _fld4789 | -0.74738675 | 93 | 336 | 0.0886461 | 0 | 68
public | _reference312 | _fld4790rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rrref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4791_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4791_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4792rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4793rref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _fld4794_rrref | 26 | 20 | 6 | 0.314383 | 0 | 17
public | _reference312 | _fld4794_rtref | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4794_type | 1 | 1 | | 1 | 0 | 2
public | _reference312 | _fld4795 | -0.74390244 | 93 | 334 | 0.73108906 | 0 | 8
public | _reference312 | _fld4796 | -0.9982578 | 1 | 501 | 0.8900151 | 0 | 8
public | _reference312 | _fld4797 | 1 | 1 | | 1 | 0 | 101
public | _reference312 | _fld4798 | 1 | 1 | | 1 | 0 | 5
public | _reference312 | _fld4799 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4800 | -0.77874565 | 84 | 363 | 0.035318557 | 0 | 7
public | _reference312 | _fld4801 | 10 | 8 | 2 | 0.9465714 | 0 | 7
public | _reference312 | _fld4802rref | 1 | 1 | | 1 | 0 | 17
public | _reference312 | _fld4803 | 1 | 1 | | 1 | 0 | 19
public | _reference312 | _fld4804 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld4805rref | 2 | 2 | | 0.9945617 | 0 | 17
public | _reference312 | _fld4806 | 1 | 1 | | 1 | 0 | 1
public | _reference312 | _fld809 | 1 | 1 | | 1 | 0 | 3
public | _reference312 | _idrref | -1 | | 501 | -0.23554955 | 0 | 17
public | _reference312 | _marked | 2 | 2 | | 0.56867975 | 0 | 1
public | _reference312 | _predefinedid | 1 | 1 | | 1 | 0 | 20
public | _reference312 | _version | 1 | 1 | | 1 | 0 | 4
(191 rows)
[text/plain] stats_used-pgpro.res (2.9K, ../[email protected]/9-stats_used-pgpro.res)
download | inline:
_reference147._fld2135: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 1 }
_reference147._fld2132_type: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 2 }
_reference147._idrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference127._idrref: 1 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld809: 9 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 3 }
_inforg10621._fld15131rref: 12 times, stats: { MCV: 161 values, Correlation, ndistinct: 161.0000, nullfrac: 0.0000, width: 17 }
_inforg10621._fld10622rref: 138 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1073.0000, nullfrac: 0.0000, width: 17 }
_inforg8199._fld8200_type: 10 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_inforg8199._fld8200_rtref: 10 times, stats: { MCV: 16 values, Histogram: 12 values, Correlation, ndistinct: 28.0000, nullfrac: 0.0000, width: 8 }
_inforg11506._fld809: 3 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg11506._fld11507_type: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 2 }
_inforg8199._fld809: 128 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_reference127._fld1806rref: 1 times, stats: { MCV: 35 values, Histogram: 11 values, Correlation, ndistinct: 46.0000, nullfrac: 0.0000, width: 17 }
_inforg11506._fld11507_rrref: 1 times, stats: { MCV: 96 values, Histogram: 281 values, Correlation, ndistinct: -0.7140, nullfrac: 0.0000, width: 17 }
_inforg8199._fld8200_rrref: 7 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: -0.3674, nullfrac: 0.0000, width: 20 }
_inforg11506._fld11508rref: 1 times, stats: { MCV: 10 values, Correlation, ndistinct: 10.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rrref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_inforg11506._fld11507_rtref: 1 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 5 }
_reference312._fld809: 36 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg10621._fld809: 156 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
_inforg8199._fld8201rref: 105 times, stats: { MCV: 500 values, Histogram: 501 values, Correlation, ndistinct: 1104.0000, nullfrac: 0.0000, width: 20 }
_reference312._idrref: 2 times, stats: { Histogram: 501 values, Correlation, ndistinct: -1.0000, nullfrac: 0.0000, width: 17 }
_reference147._fld2132_rtref: 1 times, stats: { ndistinct: -1.0000, nullfrac: 0.0000, width: 5 }
_reference127._fld809: 31 times, stats: { MCV: 1 values, Correlation, ndistinct: 1.0000, nullfrac: 0.0000, width: 3 }
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: small database huge planning time
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox