Admin UI Statements Page Is Always Cleared at Current Timestamp Despite Default 1 Hour Reporting Interval

Hello Cockroach Forum!

I figured I would post this here before making an issue on github. I bet I can benefit from a little community help.

Version: v19.1.2

Environment: Single node test cluster with about 1.8GB of disk capacity used

Summary:

The title says a lot. However, I can say a bit more here in detail. In our system, when trying to diagnose slow queries by using the admin UI. The statements page always has the statement in the top right corner that says “Last cleared 2019-10-02 16:05:37” equal to the current timestamp UTC. It appears to always clear the saved statements for reporting upon refreshing the page.

Clearly the first step is to look up settings in the docs, and I double checked that in this cluster diagnostics.reporting.interval is set to the default of 01:00:00 and diagnostics.forced_stat_reset.interval is set to the default of 02:00:00, so I was able to rule that out as a cause.

Has anyone else ever experienced this problem or have any advice? Thanks for the help!

Hey @bgreco

Can you share a screenshot of the part of the AdminUI you are referencing, just for confirmation of the issue you are bringing up. I would like to know exactly what to look out for when I try to reproduce the issue.

Cheers,
Ricardo

Hi Ricardo, thanks for the response! Here’s a screenshot of the statements page on the admin UI. You can see the Last cleared timestamp is the current time as of this post. The Last cleared timestamp in the top right is ALWAYS the current UTC time which is why there are never any statements to see.

Thanks for your help!

Hi Ricardo, do you have any suggestions or ideas after viewing the screenshot?

Hey @bgreco

I am running through some docs and working with the PM to get some more info you. Please stand by and I will let you know what we find.

1 Like

Hey @bgreco

Sorry for the delay. Would you be able to get an output for

SELECT * FROM crdb_internal.node_statement_statistics;

and post the output in the ticket?

Hi @rickrock,

Here is the abridged output limited to 100 lines. The actual output is 139 lines but there is a character limit on this blog plus it does not allow uploads of files that are not pictures.

Also, I have since upgraded the cluster to 19.1.5 that came out recently since we last spoke. Thanks for looking at this. The issue was not solved by upgrading the version.

Cheeers,

node_id	application_name	flags	key	anonymized	count	first_attempt_count	max_retries	last_error	rows_avg	rows_var	parse_lat_avg	parse_lat_var	plan_lat_avg	plan_lat_var	run_lat_avg	run_lat_var	service_lat_avg	service_lat_var	overhead_lat_avg	overhead_lat_var
1	$ cockroach sql		SELECT * FROM crdb_internal.node_statement_statistics	SELECT * FROM crdb_internal.node_statement_statistics	2	2	0	NULL	135.5	0.5	0.000131675	1.6928368002e-080.00023095	1.8122652962000002e-08	0.0049642409999999994	1.8079119735119992e-06	0.0054756779999999994	1.809011226049998e-06	0.0001488119999999999	1.6831602000005405e-11
1	$ cockroach sql		SELECT * FROM crdb_internal.node_build_info	SELECT * FROM crdb_internal.node_build_info	1	1	0	NULL	6	NaN	0.00031579	NaN	0.000116149	NaN	0.000168144	NaN	0.000754801	NaN	0.00015471800000000009	NaN
1	$ cockroach sql	-	SET sql_safe_updates = _	SET sql_safe_updates = _	1	1	0NULL	0	NaN	4.5812e-05	NaN	0.000122683	NaN	6.4753e-05	NaN	0.000313004	NaN	7.975599999999997e-05	NaN
1	$ cockroach sql	-	SHOW database	SHOW database	2	2	0	NULL	1	0	1.3538500000000001e-05	1.5362424500000006e-11	0.000976795	7.425392875219998e-07	0.0001316035	1.7613768050000044e-10	0.0012451699999999999	6.944876941519999e-07	0.00012323299999999994	1.244726420000023e-10
1	$ internal-admin-getUIData		"SELECT key, value, ""lastUpdated"" FROM system.ui WHERE key IN ($1, $2)"	SELECT _, _, _ FROM _ WHERE _ IN ($1, $2)	1	1	0	NULL	0	NaN	0NaN	0.00028649	NaN	0.013322223	NaN	0.015070293	NaN	0.0014615800000000005	NaN
1	$ internal-adopt-job	+	SELECT id, payload, progress IS _ FROM system.jobs WHERE status IN ($1, $2) ORDER BY created DESC	NULL	20	20	0	NULL	0	0	0	0	0.00046301600000000007	2.934408010315794e-09	0.0019061995	9.33817742550879e-06	0.0036158775999999993	1.045563395506162e-05	0.0012466620999999998	4.3698575444305256e-08
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4483] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4483] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0621e-05	NaN	2.0516e-05	NaN	0.105826807	NaN	0.106053587	NaN	0.00015564300000001086	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4435] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4435] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.291e-05	NaN	2.2126e-05	NaN	0.109976676	NaN	0.110206828	NaN	0.0001551160000000107	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4469] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4469] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.9431e-05	NaN	2.1627e-05	NaN	0.503527729	NaN	0.50379522	NaN	0.00019643300000005137	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4422] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4422] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.3646e-05	NaN	2.3245e-05	NaN	1.840989378	NaN	1.841245569	NaN	0.00017930000000010438	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4424] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4424] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1951e-05	NaN	2.162e-05	NaN	0.125929177	NaN	0.126167529	NaN	0.00016478100000000273	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4447] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4447] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.8117e-05	NaN	2.2577e-05	NaN	0.161361383	NaN	0.161636955	NaN	0.00018487799999999943	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4468] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4468] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.9638e-05	NaN	2.5594e-05	NaN	0.264903544	NaN	0.265199784	NaN	0.00021100800000001252	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4478] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4478] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.5645e-05	NaN	2.2427e-05	NaN	1.937896862	NaN	1.938101823	NaN	0.0001368889999999734	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4476] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4476] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1073e-05	NaN	1.979e-05	NaN	4.802978117	NaN	4.8032027809999995	NaN	0.00015380099999884322	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4439] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4439] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2338e-05	NaN	2.236e-05	NaN	0.735033092	NaN	0.735262434	NaN	0.00015464399999998157	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4459] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4459] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1992e-05	NaN	1.9762e-05	NaN	0.104376204	NaN	0.104603784	NaN	0.00015582600000001168	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4474] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4474] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.1752e-05	NaN	2.5807e-05	NaN	2.209755473	NaN	2.21003014	NaN	0.00018710800000043548	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4448] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4448] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0049e-05	NaN	2.1475e-05	NaN	0.125311054	NaN	0.12553145	NaN	0.00014887199999999434	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4430] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4430] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2075e-05	NaN	2.0659e-05	NaN	0.130000403	NaN	0.130216981	NaN	0.00014384400000003184	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4482] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4482] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0664e-05	NaN	2.1867e-05	NaN	0.269455709	NaN	0.269692307	NaN	0.00016406700000004548	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4497] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4497] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.116e-05	NaN	2.0658e-05	NaN	0.168098366	NaN	0.168319297	NaN	0.00014911300000000627	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4458] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4458] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.8501e-05	NaN	2e-05	NaN	0.123121155	NaN	0.123344668	NaN	0.0001450120000000138	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4433] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4433] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	0.000128819	NaN	2.0558e-05	NaN	0.135475475	NaN	0.135795086	NaN	0.00017023399999999134	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4509] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4509] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0424e-05	NaN	2.078e-05	NaN	0.106575494	NaN	0.106817804	NaN	0.00017110599999999032	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4508] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4508] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.9115e-05	NaN	2.205e-05	NaN	0.094978053	NaN	0.095194917	NaN	0.00014569899999999913	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4510] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4510] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.4003e-05	NaN	2.1672e-05	NaN	0.115159271	NaN	0.115389913	NaN	0.00015496700000000585	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4427] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4427] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1127e-05	NaN	2.1489e-05	NaN	0.138198562	NaN	0.138425163	NaN	0.00015398499999999538	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4438] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4438] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2317e-05	NaN	2.4132e-05	NaN	22.007750418	NaN	22.007998178	NaN	0.00017131099999900812	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4525] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4525] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.2437e-05	NaN	2.6002e-05	NaN	0.128567313	NaN	0.12882086	NaN	0.0001651080000000249	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4389] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4389] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1909e-05	NaN	2.1746e-05	NaN	0.221984446	NaN	0.222215654	NaN	0.00015755300000000472	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4418] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4418] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.9109e-05	NaN	2.5586e-05	NaN	0.09831162	NaN	0.098592567	NaN	0.00019625200000000786	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4442] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4442] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.8829e-05	NaN	1.9406e-05	NaN	0.131580334	NaN	0.131792176	NaN	0.0001436070000000178	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4526] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4526] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.7497e-05	NaN	2.1725e-05	NaN	0.441855713	NaN	0.442103198	NaN	0.00015826299999999183	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4445] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4445] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2142e-05	NaN	2.0218e-05	NaN	0.173838445	NaN	0.174066643	NaN	0.00015583799999999148	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4493] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4493] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.3029e-05	NaN	2.125e-05	NaN	0.130784372	NaN	0.131125383	NaN	0.00026673199999999175	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4499] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4499] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.8653e-05	NaN	2.0464e-05	NaN	0.115518699	NaN	0.115747116	NaN	0.0001593000000000011	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4461] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4461] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.345e-05	NaN	2.0918e-05	NaN	0.089169152	NaN	0.089419648	NaN	0.00017612799999999762	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4492] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4492] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.4443e-05	NaN	1.9629e-05	NaN	0.12154995	NaN	0.121786719	NaN	0.0001526969999999933	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4460] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4460] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.8444e-05	NaN	2.1958e-05	NaN	0.102909017	NaN	0.103140811	NaN	0.00016139199999999632	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4440] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4440] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2385e-05	NaN	1.9743e-05	NaN	0.532953343	NaN	0.533205402	NaN	0.00017993100000002205	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4425] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4425] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1391e-05	NaN	2.2933e-05	NaN	0.117090967	NaN	0.11731826	NaN	0.00015296899999998892	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4457] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4457] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.5766e-05	NaN	2.2367e-05	NaN	0.414907372	NaN	0.415147656	NaN	0.00016215099999999927	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4415] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4415] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.5271e-05	NaN	2.2348e-05	NaN	0.09780685	NaN	0.09803267	NaN	0.00014820100000000058	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4428] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4428] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.89e-05	NaN	2.539e-05	NaN	0.10305683	NaN	0.103271443	NaN	0.00014032299999999776	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4472] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4472] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.704e-05	NaN	1.9371e-05	NaN	5.147656476	NaN	5.147865961	NaN	0.00014307400000035386	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4414] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4414] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.5075e-05	NaN	2.1367e-05	NaN	0.104554306	NaN	0.104799891	NaN	0.00016914300000001048	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4518] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4518] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.6174e-05	NaN	2.0545e-05	NaN	0.092835697	NaN	0.093063965	NaN	0.00015154900000000082	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4489] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4489] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	0.000273278	NaN	2.2692e-05	NaN	0.148096684	NaN	0.148604055	NaN	0.00021140099999999995	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4516] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4516] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.6739e-05	NaN	2.0142e-05	NaN	0.097499539	NaN	0.097710706	NaN	0.00014428599999999348	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4429] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4429] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.4914e-05	NaN	2.6109e-05	NaN	0.102173332	NaN	0.102488616	NaN	0.0002442609999999956	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4463] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4463] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0763e-05	NaN	2.0536e-05	NaN	0.101813265	NaN	0.102024915	NaN	0.0001403509999999969	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4506] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4506] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.7147e-05	NaN	2.1425e-05	NaN	0.159355046	NaN	0.159598585	NaN	0.0001649669999999881	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4462] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4462] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.6696e-05	NaN	2.1999e-05	NaN	0.125575708	NaN	0.125802563	NaN	0.00014816000000000829	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4519] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4519] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.4722e-05	NaN	2.0985e-05	NaN	0.109169935	NaN	0.10941547	NaN	0.00016982800000001075	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4452] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4452] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.9327e-05	NaN	2.0885e-05	NaN	0.119810642	NaN	0.120033806	NaN	0.00015295200000001175	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4437] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4437] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.6387e-05	NaN	2.0589e-05	NaN	0.114643848	NaN	0.114857114	NaN	0.00014628999999999337	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4514] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4514] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.9756e-05	NaN	2.073e-05	NaN	0.089086099	NaN	0.089303972	NaN	0.00014738699999999882	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4471] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4471] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.8307e-05	NaN	2.1448e-05	NaN	1.545280043	NaN	1.545512448	NaN	0.00015264999999997642	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4473] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4473] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1838e-05	NaN	2.1823e-05	NaN	9.399705295	NaN	9.39993396	NaN	0.00015500399999979209	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4522] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4522] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.7866e-05	NaN	2.2145e-05	NaN	0.125735872	NaN	0.126004978	NaN	0.00018909500000000024	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4500] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4500] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.188e-05	NaN	2.1485e-05	NaN	0.141146871	NaN	0.141379009	NaN	0.00015877300000000094	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4494] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4494] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.8284e-05	NaN	2.216e-05	NaN	0.099461598	NaN	0.0996937	NaN	0.00015165799999999896	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4505] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4505] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.8251e-05	NaN	2.1289e-05	NaN	0.104136136	NaN	0.104361431	NaN	0.00015575499999999354	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4441] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4441] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.5291e-05	NaN	2.1298e-05	NaN	0.10837758	NaN	0.108620833	NaN	0.00016666399999999693	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4419] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4419] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.9629e-05	NaN	2.2356e-05	NaN	0.170605514	NaN	0.170865917	NaN	0.00017841799999998575	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4446] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4446] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.8399e-05	NaN	2.1945e-05	NaN	0.15141003	NaN	0.151620388	NaN	0.00014001399999999387	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4449] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4449] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.9866e-05	NaN	2.2749e-05	NaN	0.179136686	NaN	0.179424914	NaN	0.00020561299999999338	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4521] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4521] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2429e-05	NaN	2.186e-05	NaN	0.114093758	NaN	0.114317269	NaN	0.00014922199999999053	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4467] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4467] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.5589e-05	NaN	2.1615e-05	NaN	0.096908733	NaN	0.097119495	NaN	0.00014355800000000196	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4491] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4491] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.1164e-05	NaN	2.3914e-05	NaN	0.110839027	NaN	0.111080225	NaN	0.0001561199999999957	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4417] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4417] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1554e-05	NaN	2.1253e-05	NaN	0.156995071	NaN	0.157215946	NaN	0.00014806799999997344	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4511] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4511] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1882e-05	NaN	2.0401e-05	NaN	0.117053034	NaN	0.117289817	NaN	0.00016449999999999798	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4421] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4421] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	7.9905e-05	NaN	3.4841e-05	NaN	0.22607793	NaN	0.226484056	NaN	0.00029137999999998	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4520] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4520] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.8096e-05	NaN	1.9574e-05	NaN	0.105644474	NaN	0.105860115	NaN	0.00014797099999999674	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4490] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4490] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	8.3005e-05	NaN	2.0885e-05	NaN	0.208098607	NaN	0.208371444	NaN	0.00016894700000000262	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4436] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4436] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.898e-05	NaN	2.1669e-05	NaN	0.132870954	NaN	0.133159115	NaN	0.00019751199999998303	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4480] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4480] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0382e-05	NaN	2.0733e-05	NaN	5.614384383	NaN	5.614602138	NaN	0.0001466400000005308	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4481] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4481] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.3958e-05	NaN	2.0853e-05	NaN	0.116329734	NaN	0.116569406	NaN	0.00016486100000000226	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4443] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4443] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.2506e-05	NaN	2.0203e-05	NaN	0.140526212	NaN	0.140746717	NaN	0.00014779599999997783	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4465] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4465] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	7.7223e-05	NaN	2.4749e-05	NaN	0.123958298	NaN	0.124222395	NaN	0.00016212499999999908	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4475] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4475] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.7736e-05	NaN	2.1733e-05	NaN	1.517516817	NaN	1.5178652129999999	NaN	0.0002589269999999644	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4431] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4431] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.1632e-05	NaN	2.0829e-05	NaN	4.43568084	NaN	4.435920543	NaN	0.00016724199999984535	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4512] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4512] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.3252e-05	NaN	2.083e-05	NaN	0.274285065	NaN	0.274521997	NaN	0.00016285000000004768	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4503] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4503] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.9536e-05	NaN	2.2468e-05	NaN	0.105592043	NaN	0.105831005	NaN	0.0001669580000000087	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4455] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4455] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.872e-05	NaN	2.0761e-05	NaN	0.07857078	NaN	0.078783975	NaN	0.00014371400000000312	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4507] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4507] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.986e-05	NaN	2.154e-05	NaN	0.130653334	NaN	0.130890607	NaN	0.00015587299999997306	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4485] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4485] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.9268e-05	NaN	1.9812e-05	NaN	0.110159025	NaN	0.110392138	NaN	0.00016403300000000787	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4487] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4487] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.6726e-05	NaN	2.1979e-05	NaN	0.14549448	NaN	0.14582122	NaN	0.00023803499999999755	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4515] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4515] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	7.2919e-05	NaN	3.1338e-05	NaN	0.136854712	NaN	0.137157037	NaN	0.00019806800000002345	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4495] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4495] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.4586e-05	NaN	2.2814e-05	NaN	0.088756717	NaN	0.089000134	NaN	0.00016601699999999053	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4444] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4444] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.5688e-05	NaN	1.9444e-05	NaN	0.107810534	NaN	0.108019212	NaN	0.00014354600000000828	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4513] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4513] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	9.444e-05	NaN	2.2106e-05	NaN	0.127935028	NaN	0.128230353	NaN	0.00017877899999999003	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4524] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4524] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0951e-05	NaN	2.1394e-05	NaN	0.098169087	NaN	0.098400482	NaN	0.00015904999999999392	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4502] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4502] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0757e-05	NaN	2.2025e-05	NaN	0.101489166	NaN	0.101722262	NaN	0.00016031399999999474	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4477] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4477] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.0646e-05	NaN	2.1058e-05	NaN	0.725218802	NaN	0.72546271	NaN	0.00017220399999995362	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4479] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4479] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	6.7731e-05	NaN	2.261e-05	NaN	10.481894224	NaN	10.482159842	NaN	0.00017527700000030677	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4434] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4434] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	4.7253e-05	NaN	2.6058e-05	NaN	0.112575826	NaN	0.112801057	NaN	0.00015191999999998596	NaN
1	$ internal-create-stats	-	CREATE STATISTICS __auto__ FROM [4523] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	CREATE STATISTICS _ FROM [4523] WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME _	1	1	0NULL	0	NaN	5.3916e-05	NaN	2.0588e-05	NaN	0.123012903	NaN	0.123247683	NaN	0.00016027599999998698	NaN