partitioning_test_results_dump_v15.2.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 15.2 (Ubuntu 15.2-1.pgdg22.04+1)
-- Dumped by pg_dump version 15.2 (Ubuntu 15.2-1.pgdg22.04+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: pgss_results_planning_test; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.pgss_results_planning_test (
    hostname text,
    test_start_time timestamp with time zone,
    created_on timestamp with time zone,
    test_name text,
    scale integer,
    duration integer,
    clients integer,
    protocol text,
    part_method text,
    partitions integer,
    mean_plan_time double precision,
    stddev_plan_time double precision,
    mean_exec_time double precision,
    stddev_exec_time double precision,
    calls bigint,
    rows bigint,
    shared_blks_hit bigint,
    shared_blks_read bigint,
    query text
);


ALTER TABLE public.pgss_results_planning_test OWNER TO postgres;

--
-- Data for Name: pgss_results_planning_test; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.pgss_results_planning_test (hostname, test_start_time, created_on, test_name, scale, duration, clients, protocol, part_method, partitions, mean_plan_time, stddev_plan_time, mean_exec_time, stddev_exec_time, calls, rows, shared_blks_hit, shared_blks_read, query) FROM stdin;
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 02:47:36.826968+03	zipfian_access	5000	3600	2	simple	range	0	0.02134040465424262	0.005506776746041097	0.052038904493273315	0.11087077865188323	16366575	16366575	92692469	5507091	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 03:52:36.95767+03	random_access	5000	3600	2	simple	range	0	0.022514398125201264	0.005492341007635882	0.2690315825547952	0.12810411220786894	10833803	10833803	45669966	19332962	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 05:08:43.619048+03	zipfian_access	5000	3600	2	simple	hash	0	0.021403144541123777	0.005570466605967699	0.05092440431624869	0.10700246488970375	16364000	16364000	92677007	5507103	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 06:13:43.748071+03	random_access	5000	3600	2	simple	hash	0	0.02258430189565413	0.0056173669558184525	0.25821226407755904	0.11591514944982233	11024064	11024064	46472208	19672286	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 07:36:00.770552+03	zipfian_access	5000	3600	2	simple	range	16	0.032883765876969284	0.007504704147874375	0.05427055819739558	0.11397241265235519	15642805	15642805	88591521	5267187	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 08:41:00.878108+03	random_access	5000	3600	2	simple	range	16	0.03570265583338781	0.007696808494218386	0.28242439916092593	0.12577844146843384	10356725	10356725	43660557	18481671	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 10:03:36.464368+03	zipfian_access	5000	3600	2	simple	hash	16	0.031978217212924695	0.007381122158404186	0.05490849190881402	0.11408125841236064	15627173	15627173	88501672	5263222	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 11:08:36.577576+03	random_access	5000	3600	2	simple	hash	16	0.03440682753442225	0.007443557184976379	0.28232547001513114	0.12444740485798286	10386345	10386345	43783538	18536388	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 12:32:08.096558+03	zipfian_access	5000	3600	2	simple	range	64	0.03314411545249091	0.007655777021441658	0.05397738129873622	0.11351027010907408	15674421	15674421	73099002	5280371	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 13:37:08.21223+03	random_access	5000	3600	2	simple	range	64	0.03711960692106208	0.007870652152027674	0.2807387778931294	0.12395623158533929	10350351	10350351	33287280	18471743	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 15:01:41.181667+03	zipfian_access	5000	3600	2	simple	hash	64	0.03306089237811581	0.007670811486057402	0.054558216089351456	0.11391048081410049	15549059	15549059	72514869	5238012	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 16:06:41.297208+03	random_access	5000	3600	2	simple	hash	64	0.03575440243438551	0.0077043540707962335	0.28079675473111915	0.12480504162359361	10362452	10362452	33325275	18494571	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 17:33:46.039804+03	zipfian_access	5000	3600	2	simple	range	256	0.03373046086101762	0.008080181873148583	0.050297704611537764	0.10622448074812349	15716541	15716541	73318086	5294963	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 18:38:46.157549+03	random_access	5000	3600	2	simple	range	256	0.03884984107627642	0.008415225674250428	0.2687133120878634	0.12187463514369097	10504083	10504083	33801844	18748915	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 20:10:43.024743+03	zipfian_access	5000	3600	2	simple	hash	256	0.03458817987627043	0.00826057940005419	0.05175777921221413	0.10741663249871938	15486323	15486323	72241902	5220059	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 21:15:43.152007+03	random_access	5000	3600	2	simple	hash	256	0.037206622738908804	0.0084667612118107	0.26069438531416456	0.12288332609997932	10678708	10678708	34363931	19059953	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 22:52:39.96273+03	zipfian_access	5000	3600	2	simple	range	1024	0.035508755369002075	0.011199718101176792	0.054408495050070525	0.11637412744273753	15586246	15586246	72790526	5261674	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-08 23:57:40.106733+03	random_access	5000	3600	2	simple	range	1024	0.04816181703019473	0.01368570747282264	0.2746024647778478	0.12924227025009238	10353342	10353342	33398797	18488883	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-09 01:48:18.063779+03	zipfian_access	5000	3600	2	simple	hash	1024	0.04403233419094529	0.013276336677472854	0.051869575389512076	0.1087838778852937	15315750	15315750	71529381	5170517	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-09 02:53:18.267383+03	random_access	5000	3600	2	simple	hash	1024	0.04692565817065344	0.013262583408244438	0.2569363254393597	0.124916454606621	10665085	10665085	34401179	19045394	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-09 04:42:41.521114+03	zipfian_access	5000	3600	2	simple	range	4096	0.03831655402494125	0.018152915641890296	0.05191365236137142	0.10784477517680069	15534223	15534223	72871710	5283375	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-08 01:31:32.098844+03	2023-04-09 05:47:41.654366+03	random_access	5000	3600	2	simple	range	4096	0.05342747912297135	0.020166394121028684	0.2519409884467334	0.10916593992924714	10587593	10587593	34467389	18954538	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-09 23:34:46.651077+03	2023-04-10 01:49:09.147227+03	zipfian_access	5000	3600	2	simple	hash	4096	0.048510390906189464	0.01849473835710907	0.050182769951405054	0.10547520848545364	14838074	14838074	69619129	5055593	SELECT * FROM pgbench_accounts WHERE aid = $1
testkast	2023-04-09 23:34:46.651077+03	2023-04-10 02:54:09.298101+03	random_access	5000	3600	2	simple	hash	4096	0.05166144714088349	0.018631200508714772	0.24915879605238272	0.1222332271520966	10494518	10494518	34169936	18787006	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 02:49:12.534024+03	zipfian_access	5000	3600	2	simple	range	0	0.018558175148259356	0.0023536067587403785	0.0440279475799386	0.09277711939915118	17733993	17733993	100446169	5957899	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 03:54:12.642433+03	random_access	5000	3600	2	simple	range	0	0.020038743254355586	0.0030951356639894747	0.23353670362212903	0.10531413877809895	11854020	11854020	49970678	21153552	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 05:12:00.729373+03	zipfian_access	5000	3600	2	simple	hash	0	0.018590531460346955	0.002490216873756117	0.044197767782330026	0.09327983240075692	17715284	17715284	100340579	5951235	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 06:17:00.837571+03	random_access	5000	3600	2	simple	hash	0	0.020065038143675745	0.003076755043324468	0.23374737500009274	0.1055284765547789	11845450	11845450	49934231	21138579	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 07:41:08.237634+03	zipfian_access	5000	3600	2	simple	range	16	0.02850170816065663	0.0035336413019861086	0.04456096683405858	0.09406428762740937	16870556	16870556	95551726	5673488	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 08:46:08.344675+03	random_access	5000	3600	2	simple	range	16	0.03197863933447114	0.004574559732990934	0.2369714045745526	0.10690000260616077	11464270	11464270	48329423	20458075	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 10:09:25.009434+03	zipfian_access	5000	3600	2	simple	hash	16	0.027620409083434674	0.0036173606687462897	0.044308866544395475	0.09278396370987857	17149719	17149719	97133029	5767141	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 11:14:25.124625+03	random_access	5000	3600	2	simple	hash	16	0.030354125137318444	0.004343658219869194	0.23363092029069868	0.1040824562519296	11579703	11579703	48814875	20665199	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 12:39:18.577105+03	zipfian_access	5000	3600	2	simple	range	64	0.028741283616460396	0.0037823353404559355	0.044533021570437266	0.09438014706306729	17068632	17068632	79609787	5740641	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 13:44:18.691866+03	random_access	5000	3600	2	simple	range	64	0.03303358575526806	0.0048869599578086195	0.23846556277852912	0.10595610942431533	11403317	11403317	36673216	20350637	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 15:10:01.137719+03	zipfian_access	5000	3600	2	simple	hash	64	0.028324659551789394	0.0036497331359929743	0.04519566625993341	0.09752144267804698	16957008	16957008	79089104	5703522	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 16:15:01.252077+03	random_access	5000	3600	2	simple	hash	64	0.03170236206313138	0.004643995866566856	0.23931304914646165	0.10822601034009012	11254159	11254159	36193350	20085031	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 17:44:43.916562+03	zipfian_access	5000	3600	2	simple	range	256	0.0291804140750934	0.004329580261064281	0.04426388492116014	0.09556744304904127	17049468	17049468	79543239	5734445	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 18:49:44.070663+03	random_access	5000	3600	2	simple	range	256	0.034716401846123644	0.005326639664961709	0.24176692965405852	0.12255343088787463	11302381	11302381	36368391	20173858	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 20:21:02.907272+03	zipfian_access	5000	3600	2	simple	hash	256	0.02966034743068312	0.003978071420849743	0.04492920969306877	0.09654594762718471	17030367	17030367	79453833	5728346	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 21:26:03.04427+03	random_access	5000	3600	2	simple	hash	256	0.033979021333710606	0.005204070332036726	0.24650279835012828	0.1268788060499797	11177239	11177239	35966766	19949773	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-08 23:05:00.922637+03	zipfian_access	5000	3600	2	simple	range	1024	0.030836159733858597	0.007954293130145002	0.043339432306338424	0.09302782754303988	17044721	17044721	79601177	5743396	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-09 00:10:01.069492+03	random_access	5000	3600	2	simple	range	1024	0.04271545409836496	0.009871358135522756	0.21940399850816117	0.11175483349768868	11778611	11778611	37980200	21033823	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-09 02:05:48.299196+03	zipfian_access	5000	3600	2	simple	hash	1024	0.03786218568723741	0.009466037295121603	0.04417073124245469	0.09376553073944476	16693231	16693231	77961460	5625839	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-09 03:10:48.4512+03	random_access	5000	3600	2	simple	hash	1024	0.04144062341922702	0.009099110050539174	0.2184920050916334	0.10196267638171937	11733111	11733111	37834863	20951836	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-09 05:02:44.696395+03	zipfian_access	5000	3600	2	simple	range	4096	0.03335316746338701	0.014354175426242077	0.04373585053553251	0.09420722024048593	16913124	16913124	79304880	5745110	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-08 01:31:35.126434+03	2023-04-09 06:07:44.844003+03	random_access	5000	3600	2	simple	range	4096	0.04743008280293526	0.015049394000488252	0.21662647710112024	0.10957645992989494	11705491	11705491	38055010	20956807	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-09 23:35:48.223179+03	2023-04-10 01:49:21.290165+03	zipfian_access	5000	3600	2	simple	hash	4096	0.04164757031129405	0.01269796879927353	0.04407007011516441	0.0934476238361245	16438426	16438426	77090193	5586029	SELECT * FROM pgbench_accounts WHERE aid = $1
fuji	2023-04-09 23:35:48.223179+03	2023-04-10 02:54:21.432845+03	random_access	5000	3600	2	simple	hash	4096	0.04593587023050231	0.013083330387134117	0.21869071201527474	0.10863261513255174	11630252	11630252	37817407	20817945	SELECT * FROM pgbench_accounts WHERE aid = $1
\.


--
-- PostgreSQL database dump complete
--