-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathlog
More file actions
93 lines (93 loc) · 11.7 KB
/
Copy pathlog
File metadata and controls
93 lines (93 loc) · 11.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
[insert]---> 10000 rows, use 347ms
[query]---> total 10000 rows, type raw use 15ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 9ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 51ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 10ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 51ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 10ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 52ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 2ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 11ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 52ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 9ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 50ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 10ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 55ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 9ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 53ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 9ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 51ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 9ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 51ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 10000 rows, type raw use 3ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 10000 rows, type json use 10ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 10000 rows, type json_to_string use 51ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[insert]---> 100000 rows, use 3819ms
[query]---> total 110000 rows, type raw use 51ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 96ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 218ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 26ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 96ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 202ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 26ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 98ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 200ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 25ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 98ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 202ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 25ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 95ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 216ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 26ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 97ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 202ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 25ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 95ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 208ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 26ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 97ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 201ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 26ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 95ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 202ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 110000 rows, type raw use 25ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 110000 rows, type json use 95ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 110000 rows, type json_to_string use 209ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[insert]---> 1000000 rows, use 56059ms
[query]---> total 1110000 rows, type raw use 200ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 422ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 1986ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 129ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 387ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2016ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 129ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 387ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2095ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 136ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 425ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2104ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 127ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 386ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2132ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 132ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 402ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2277ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 137ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 414ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2166ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 129ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 417ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2175ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 132ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 416ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2190ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'
[query]---> total 1110000 rows, type raw use 129ms, query by SELECT * FROM test_json WHERE data_meta = 'c836c4c3';
[query]---> total 1110000 rows, type json use 437ms, query by SELECT * FROM test_json WHERE data #>>'{candidates,users,0,oxygenId}' = 'c836c4c3'
[query]---> total 1110000 rows, type json_to_string use 2205ms, query by SELECT * FROM test_json WHERE data::text SIMILAR TO '%(c836c4c3)%'