Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.12.2020 16:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17678628 kB
MemAvailable 31575200 kB
Buffers 0 kB
Cached 13987048 kB
SwapCached 1944 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-02 16:27:06
DTS_END                         2020-12-02 16:27:06.1920
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56534
TRN_ID                          238003
ATT_ID                          650
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9110.55 22351 1093266
customer order: creation 167.98 363 20157
customer order: refuse 15.14 360 1817
order to supplier: creation 43.70 1207 5244
order to supplier: removal 3.57 101512 428
invoice (draft): creation 44.85 3255 5382
invoice (draft): removal 53.03 827 6364
invoice accept: apply 40.46 19183 4855
invoice accept: cancel 47.46 778 5695
customer reserve: creation 3676.73 194 441207
customer reserve: removal 4724.70 60 566964
realization accept: apply 82.63 186 9915
realization accept: cancel 84.01 110 10081
payment from customer: creation 57.19 140 6863
payment from customer: removal 5.62 88 674
payment to supplier: creation 47.91 146 5749
payment to supplier: removal 3.40 96 408
service: total inventory turnovers 4.81 1208 577
service: total monetary turnovers 6.41 37 769
service: aggregate perf. data 0.94 16092 113
service: refresh index statistics 0.03 301181 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-12-2020 16:27:42 to 02-12-2020 16:27:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7048
TEST_TIME 2 5935
TEST_TIME 3 4932
TEST_TIME 4 5516
TEST_TIME 5 5120
TEST_TIME 6 5299
TEST_TIME 7 5643
TEST_TIME 8 5575
TEST_TIME 9 5729
TEST_TIME 10 5708
TEST_TIME 11 5897
TEST_TIME 12 6223
TEST_TIME 13 6426
TEST_TIME 14 6729
TEST_TIME 15 7053
TEST_TIME 16 7261
TEST_TIME 17 7326
TEST_TIME 18 7459
TEST_TIME 19 7712
TEST_TIME 20 7654
TEST_TIME 21 8136
TEST_TIME 22 8536
TEST_TIME 23 8781
TEST_TIME 24 9235
TEST_TIME 25 9789
TEST_TIME 26 10534
TEST_TIME 27 11398
TEST_TIME 28 11236
TEST_TIME 29 10966
TEST_TIME 30 10794
TEST_TIME 31 10746
TEST_TIME 32 10562
TEST_TIME 33 10463
TEST_TIME 34 10328
TEST_TIME 35 10167
TEST_TIME 36 10163
TEST_TIME 37 9915
TEST_TIME 38 9743
TEST_TIME 39 9800
TEST_TIME 40 9647
TEST_TIME 41 9634
TEST_TIME 42 9611
TEST_TIME 43 9497
TEST_TIME 44 9514
TEST_TIME 45 9529
TEST_TIME 46 9527
TEST_TIME 47 9620
TEST_TIME 48 9572
TEST_TIME 49 9630
TEST_TIME 50 9559
TEST_TIME 51 9608
TEST_TIME 52 9556
TEST_TIME 53 9613
TEST_TIME 54 9676
TEST_TIME 55 9629
TEST_TIME 56 9546
TEST_TIME 57 9737
TEST_TIME 58 9677
TEST_TIME 59 9526
TEST_TIME 60 9556
TEST_TIME 61 9537
TEST_TIME 62 9454
TEST_TIME 63 9464
TEST_TIME 64 9422
TEST_TIME 65 9355
TEST_TIME 66 9312
TEST_TIME 67 9217
TEST_TIME 68 9187
TEST_TIME 69 9292
TEST_TIME 70 9238
TEST_TIME 71 9230
TEST_TIME 72 9239
TEST_TIME 73 9384
TEST_TIME 74 9423
TEST_TIME 75 9380
TEST_TIME 76 9315
TEST_TIME 77 9340
TEST_TIME 78 9374
TEST_TIME 79 9425
TEST_TIME 80 9412
TEST_TIME 81 9318
TEST_TIME 82 9270
TEST_TIME 83 9237
TEST_TIME 84 9212
TEST_TIME 85 9156
TEST_TIME 86 9113
TEST_TIME 87 9099
TEST_TIME 88 9101
TEST_TIME 89 9097
TEST_TIME 90 9048
TEST_TIME 91 9046
TEST_TIME 92 9117
TEST_TIME 93 9102
TEST_TIME 94 9085
TEST_TIME 95 9157
TEST_TIME 96 9178
TEST_TIME 97 9167
TEST_TIME 98 9204
TEST_TIME 99 9223
TEST_TIME 100 9226
TEST_TIME 101 9256
TEST_TIME 102 9263
TEST_TIME 103 9197
TEST_TIME 104 9159
TEST_TIME 105 9139
TEST_TIME 106 9097
TEST_TIME 107 9051
TEST_TIME 108 9031
TEST_TIME 109 9028
TEST_TIME 110 9107
TEST_TIME 111 9059
TEST_TIME 112 9101
TEST_TIME 113 9105
TEST_TIME 114 9073
TEST_TIME 115 9111
TEST_TIME 116 9095
TEST_TIME 117 9160
TEST_TIME 118 9138
TEST_TIME 119 9184
TEST_TIME 120 9114

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-12-2020 16:27:46 to 02-12-2020 16:27:49.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1503597 1503597 0 0.00 0 22619 7 0 0
doc_list_biud 1503597 1503597 0 0.00 0 63870 29 0 0
sp_add_invoice_to_stock 4999 4855 144 2.88 34 176048 19183 0 144
sp_cancel_adding_invoice 5695 5695 0 0.00 5 61011 778 0 0
sp_cancel_client_order 1817 1817 0 0.00 4 19870 361 0 0
sp_cancel_customer_reserve 566964 566964 0 0.00 1 63872 60 0 0
sp_cancel_pay_from_customer 674 674 0 0.00 2 10527 89 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 7542 97 0 0
sp_cancel_supplier_invoice 6378 6364 14 0.21 2 21924 828 0 14
sp_cancel_supplier_order 428 428 0 0.00 6 1229829 101512 0 0
sp_cancel_write_off 10081 10081 0 0.00 1 9821 111 0 0
sp_client_order 20157 20157 0 0.00 3 27273 364 0 0
sp_customer_reserve 441207 441207 0 0.00 0 118961 194 0 0
sp_fill_shopping_cart 30781 30781 0 0.00 1 15236 39 0 0
sp_fill_shopping_cart_clo_res 441199 441199 0 0.00 0 15415 14 0 0
sp_get_clo_for_invoice 4846 4846 0 0.00 0 25029 320 0 0
sp_kill_cost_storno 16858 16858 0 0.00 0 9625 57 0 0
sp_kill_qstorno_ret_qs2qd 1150801 1150801 0 0.00 0 63864 33 0 0
sp_kill_qty_storno 606110 606110 0 0.00 0 63870 70 0 0
sp_lock_selected_doc 20498 20498 0 0.00 0 7331 4 0 0
sp_make_cost_storno 27373 27373 0 0.00 0 22615 62 0 0
sp_multiply_rows_for_pdistr 27373 27373 0 0.00 0 9246 30 0 0
sp_multiply_rows_for_qdistr 20157 20157 0 0.00 0 19956 166 0 0
sp_pay_from_customer 6863 6863 0 0.00 4 22624 141 0 0
sp_pay_to_supplier 5749 5749 0 0.00 5 14481 146 0 0
sp_payment_common 12612 12612 0 0.00 1 16345 40 0 0
sp_qd_handle_on_cancel_clo 1817 1817 0 0.00 0 19863 328 0 0
sp_qd_handle_on_invoice_upd_sts 10541 10541 0 0.00 0 12147 317 0 0
sp_qd_handle_on_reserve_upd_sts 9915 9915 0 0.00 0 12354 59 0 0
sp_reserve_write_off 9915 9915 0 0.00 6 22623 186 0 0
sp_supplier_invoice 5382 5382 0 0.00 5 86677 3256 0 0
sp_supplier_order 5244 5244 0 0.00 5 26667 1208 0 0
srv_aggregate_perf_data 114 113 1 0.87 2365 196595 16093 0 1
srv_fill_mon_cache_memory 152 152 0 0.00 1064 166959 34950 0 0
srv_find_qd_qs_mism 1048010 1048010 0 0.00 0 12431 6 0 0
srv_make_invnt_saldo 577 577 0 0.00 39 169073 1209 0 0
srv_make_money_saldo 769 769 0 0.00 1 6965 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 153515 537987 301181 0 0
t$perf-abend:sp_add_invoice_to_stock 144 144 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4856 4856 0 0.00 0 11118 154 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 1 2291 99 0 0
t$perf-norm:sp_cancel_client_order 1817 1817 0 0.00 0 8084 19 0 0
t$perf-norm:sp_cancel_customer_reserve 626 626 0 0.00 0 1694 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 674 674 0 0.00 0 993 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 1947 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 705 13 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 22013 1517 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 6082 15 0 0
t$perf-norm:sp_client_order 20157 20157 0 0.00 0 6506 15 0 0
t$perf-norm:sp_customer_reserve 995 995 0 0.00 0 605 3 0 0
t$perf-norm:sp_pay_from_customer 6863 6863 0 0.00 0 3810 7 0 0
t$perf-norm:sp_pay_to_supplier 5749 5749 0 0.00 0 3193 8 0 0
t$perf-norm:sp_reserve_write_off 9915 9915 0 0.00 0 7707 11 0 0
t$perf-norm:sp_supplier_invoice 5382 5382 0 0.00 0 3245 16 0 0
t$perf-norm:sp_supplier_order 5244 5244 0 0.00 0 5400 17 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 446 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 707 12 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 1111 28 0 0
t$perf-norm:srv_make_money_saldo 769 769 0 0.00 0 1758 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9976 9688 288 2.88 0 26340 32 0 288
v_all_customers 36994 36994 0 0.00 0 16 1 0 0
v_all_suppliers 29570 29570 0 0.00 0 20 1 0 0
v_all_wares 40314 40314 0 0.00 0 84 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 1441 7 0 0
v_cancel_client_order 3634 3634 0 0.00 0 9023 9 0 0
v_cancel_customer_prepayment 1348 1348 0 0.00 0 10399 21 0 0
v_cancel_customer_reserve 1252 1252 0 0.00 0 3252 12 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 2256 11 0 0
v_cancel_supplier_invoice 886 858 28 3.16 0 7474 35 0 28
v_cancel_supplier_order 856 856 0 0.00 0 5152 15 0 0
v_cancel_write_off 1924 1924 0 0.00 0 3546 16 0 0
v_max_id_clo_ord 5244 5244 0 0.00 0 503 1 0 0
v_max_id_clo_res 995 995 0 0.00 0 2439 14 0 0
v_max_id_ord_sup 5379 5379 0 0.00 0 15190 7 0 0
v_max_non_paid_invoice 1587 1587 0 0.00 0 1259 3 0 0
v_max_non_paid_realizn 3602 3602 0 0.00 0 5433 6 0 0
v_min_id_clo_ord 5244 5244 0 0.00 0 3130 8 0 0
v_min_id_clo_res 995 995 0 0.00 0 3697 17 0 0
v_min_id_ord_sup 5379 5379 0 0.00 0 4712 7 0 0
v_min_non_paid_invoice 5749 5749 0 0.00 0 13986 28 0 0
v_min_non_paid_realizn 6863 6863 0 0.00 0 9544 25 0 0
v_our_firm 9842 9842 0 0.00 0 15 1 0 0
v_reserve_write_off 19830 19830 0 0.00 0 12461 12 0 0
x_lock_depdocs_on_canc_invoice 11630 11630 0 0.00 0 28706 122 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 8006 313 0 0
x_make_qstorno_1000_1200 5244 5244 0 0.00 1 26662 1126 0 0
x_make_qstorno_1200_2000 5382 5382 0 0.00 2 83278 3117 0 0
x_make_qstorno_2100_3300 441207 441207 0 0.00 0 118960 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-12-2020 16:27:50 to 02-12-2020 16:27:54.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:16 30603 8192000000 10294875200 10612117504 1097946544 11.818 84 65 131 0 1122155744 3100848 21108352
13:57:56 34496 8192000000 10367547728 10690990080 1418407120 14.759 100 92 182 2 1454460688 5566640 30486928
13:58:45 20983 8192000000 10403438400 10728542208 1455389104 15.085 100 87 174 0 1491328768 7185728 28753936
13:59:20 11345 8192000000 10406532144 10742841344 1473553984 15.245 100 79 159 0 1506871712 7901776 25415952
13:59:42 21339 8192000000 10460344496 10792591360 1503893888 15.510 100 93 185 0 1541257552 8036896 29326768
14:00:15 18934 8192000000 10478417376 10812645376 1528485856 15.724 100 91 182 0 1566733968 9642656 28605456
14:00:50 24807 8192000000 10490443392 10834067456 1543622944 15.855 100 91 182 1 1582894864 10499088 28772832
14:01:45 12340 8192000000 10525729120 10877825024 1591141360 16.264 100 81 162 0 1626167952 10395744 24630848
14:02:05 14404 8192000000 10556968256 10911698944 1607652944 16.405 100 75 151 0 1641362128 11219296 22489888
14:02:27 16693 8192000000 10575150736 10933952512 1628279392 16.580 100 84 166 1 1664804208 11652400 24872416
14:02:52 13691 8192000000 10588934576 10953883648 1651237488 16.775 100 85 170 1 1688422208 12097776 25086944
14:03:13 8834 8192000000 10611459984 10978701312 1669302128 16.927 100 78 156 1 1703928384 11958688 22667568
14:03:29 7187 8192000000 10636366368 11003858944 1694289488 17.137 100 88 176 2 1733047296 12647072 26110736
14:03:45 13108 8192000000 10641526784 11014443008 1706073776 17.236 100 80 161 0 1741468560 12214112 23180672
14:04:05 5713 8192000000 10655065600 11029909504 1720079008 17.353 100 83 165 2 1756805872 13250144 23476720
14:04:18 6997 8192000000 10664780800 11042742272 1729590768 17.432 100 75 148 3 1764131840 13209616 21331456
14:04:32 4078 8192000000 10696470480 11070820352 1743786032 17.550 100 78 156 0 1777989536 12859600 21343904
14:04:43 8542 8192000000 10695574736 11075022848 1756959936 17.659 100 83 165 1 1793575280 13675392 22939952
14:04:59 4084 8192000000 10716049088 11091480576 1771017808 17.775 100 87 172 0 1808690576 13154544 24518224
14:05:11 4507 8192000000 10731999600 11107590144 1788366848 17.918 100 87 173 1 1825692272 13436336 23889088
14:05:23 3885 8192000000 10733070992 11111653376 1794955344 17.972 100 93 186 2 1833994912 13643456 25396112
14:05:34 2980 8192000000 10741282384 11123757056 1804722960 18.053 100 84 166 0 1842046320 14297600 23025760
14:05:43 2984 8192000000 10750138320 11135209472 1804588256 18.052 100 81 162 2 1842363776 14525376 23250144
14:05:53 2789 8192000000 10754122128 11136557056 1814341632 18.131 100 90 180 1 1854228304 14532368 25354304
14:06:02 2668 8192000000 10758252384 11143430144 1821159824 18.187 100 88 176 1 1858670144 13257680 24252640
14:06:11 8508 8192000000 10756215584 11149185024 1818609712 18.166 100 74 149 1 1852038592 13324368 20104512
14:06:27 2761 8192000000 10776407072 11163340800 1823681504 18.208 100 81 158 2 1858508400 12540128 22286768
14:06:36 2844 8192000000 10779617488 11168681984 1841633296 18.354 100 89 177 0 1879961840 13240544 25088000
14:06:45 1746 8192000000 10789734880 11175829504 1845880544 18.389 100 91 183 3 1884796592 13764256 25151792
14:06:53 1052 8192000000 10794486672 11178143744 1849529344 18.418 100 91 182 0 1890297616 14985312 25782960
14:07:02 2101 8192000000 10798212416 11188854784 1855435296 18.466 100 93 185 0 1895342752 13494544 26412912
14:07:11 2736 8192000000 10795666016 11189821440 1859871120 18.502 100 91 182 1 1902581584 16811024 25899440
14:07:20 2492 8192000000 10808958592 11198570496 1864311072 18.538 100 86 172 0 1901748352 13406480 24030800
14:07:29 1565 8192000000 10807979936 11202031616 1867877024 18.567 100 89 178 3 1906301056 13949040 24474992
14:07:37 1872 8192000000 10812782576 11203362816 1866168992 18.553 100 91 182 2 1904943936 14376256 24398688
14:07:45 1327 8192000000 10820635984 11208155136 1869821472 18.583 100 92 185 4 1910182976 14373968 25987536
14:07:53 10199 8192000000 10807999120 11207733248 1872398944 18.604 100 92 184 1 1912841904 13879184 26563776
14:08:09 1260 8192000000 10822399728 11215851520 1876691968 18.638 100 87 176 2 1915008144 13387072 24929104
14:08:17 21145 8192000000 10794806896 11205799936 1871470144 18.596 100 53 99 3 1895262848 9549920 14242784
14:08:44 3411 8192000000 10798543936 11209027584 1875613888 18.630 100 61 121 1 1903620720 10185872 17820960
14:08:57 6061 8192000000 10799539744 11211149312 1874379648 18.620 100 45 90 1 1896068896 9468032 12221216
14:09:09 4456 8192000000 10792182224 11212845056 1877559408 18.645 100 42 84 2 1898214048 8585168 12069472
14:09:21 7375 8192000000 10780135808 11210153984 1875868864 18.632 100 21 42 3 1888190672 6296880 6024928
14:09:36 6622 8192000000 10804163536 11216015360 1881507552 18.677 100 32 64 2 1896884864 6865488 8511824
14:09:51 3675 8192000000 10790825760 11219763200 1883312096 18.692 100 31 64 1 1900511376 7707168 9492112
14:10:02 12049 8192000000 10783999408 11220209664 1883033072 18.690 100 23 46 3 1896053760 6731856 6288832
14:10:23 7179 8192000000 10781250080 11221200896 1883505040 18.693 100 19 36 1 1895286976 6578960 5202976
14:10:37 7904 8192000000 10791927968 11224309760 1885442896 18.709 100 20 40 2 1897173248 6095056 5635296
14:10:51 10197 8192000000 10788447808 11223273472 1885084928 18.706 100 16 32 0 1895034192 5619056 4330208
14:11:07 8087 8192000000 10795919664 11231318016 1891643536 18.759 100 29 58 2 1905696432 6155088 7897808
14:11:28 61617 8192000000 10851118144 11251585024 1903323136 18.853 100 57 114 5 1924622960 4889200 16410624
14:12:36 6548 8192000000 10822269280 11253235712 1902526256 18.847 100 37 74 0 1922588016 9503408 10558352
14:12:50 7027 8192000000 10825094288 11251134464 1902493840 18.846 100 32 64 1 1918330944 7017152 8819952
14:13:04 3931 8192000000 10824563344 11251544064 1904030176 18.859 100 28 56 4 1919223232 7082928 8110128
14:13:14 4170 8192000000 10825595520 11253817344 1905456288 18.870 100 32 64 2 1925929856 11340032 9133536
14:13:25 4772 8192000000 10826462256 11256606720 1906539312 18.879 100 38 76 2 1929445408 11421472 11484624
14:13:38 7794 8192000000 10845214400 11263995904 1909253648 18.901 100 38 75 4 1926798464 6777408 10767408
14:13:55 4674 8192000000 10833030944 11264045056 1912444112 18.926 100 34 68 1 1928888672 6792768 9651792
14:14:09 9378 8192000000 10830877472 11257856000 1910152576 18.908 100 22 42 0 1926081136 10030960 5897600
14:14:24 10295 8192000000 10825462064 11265642496 1915597664 18.952 100 28 56 4 1930545296 6628528 8319104
14:14:41 6136 8192000000 10825143024 11270348800 1920158880 18.988 100 25 50 0 1933254256 5742048 7353328
14:14:55 5605 8192000000 10826678400 11268632576 1918723504 18.977 100 17 34 0 1928868944 5482096 4663344
14:15:06 4402 8192000000 10841610544 11277410304 1923621488 19.016 100 28 56 2 1942159344 10652496 7885360
14:15:17 53521 8192000000 10857611984 11272318976 1890008672 18.746 98 43 87 1 1907910720 5016752 12885296
14:16:17 12674 8192000000 10827279088 11268874240 1916584048 18.959 100 20 40 1 1927980400 5771056 5625296
14:16:35 12808 8192000000 10823935968 11262214144 1900954384 18.834 99 24 48 0 1912706928 5394816 6357728
14:16:57 10228 8192000000 10822030832 11258011648 1874357904 18.620 98 20 40 1 1885250000 5072096 5820000
14:17:14 7546 8192000000 10811252784 11241152512 1866081920 18.553 98 36 72 2 1882809648 6541120 10186608
14:17:28 6424 8192000000 10763565888 11189219328 1792685200 17.954 95 37 74 0 1809705120 6346576 10673344
14:17:42 4939 8192000000 10793209408 11212857344 1856384848 18.474 99 31 62 3 1871425024 6400912 8639264
14:17:55 8477 8192000000 10765167248 11200950272 1818754640 18.168 97 21 40 1 1830451728 6414368 5282720
14:18:11 8477 8192000000 10762244432 11187269632 1814070016 18.129 97 17 34 1 1823648784 5318016 4260752
14:18:28 8557 8192000000 10741845424 11154178048 1771367568 17.778 96 21 41 1 1786824368 9569840 5886960
14:18:43 7796 8192000000 10722993440 11147624448 1747340432 17.580 95 19 37 0 1757636928 5269328 5027168
14:18:57 8752 8192000000 10718778592 11133161472 1761351664 17.696 97 25 50 1 1773989088 5172128 7465296
14:19:11 10130 8192000000 10740600560 11151732736 1797304784 17.992 99 20 39 0 1808704256 5486032 5913440
14:19:28 9815 8192000000 10712573632 11129880576 1773367904 17.795 98 19 38 2 1784061456 5152208 5541344
14:19:45 55493 8192000000 10697900960 11093372928 1657832112 16.831 92 28 56 1 1671055520 4485184 8738224
14:20:46 14106 8192000000 10670534896 11095232512 1737939456 17.502 98 23 46 1 1751691392 7023344 6728592
14:21:07 12855 8192000000 10683188992 11093307392 1704806240 17.225 95 29 58 2 1722631056 9692048 8132768
14:21:27 7204 8192000000 10703756416 11119005696 1775832400 17.815 99 26 52 3 1793948208 9667536 8448272
14:21:41 8803 8192000000 10711195232 11123888128 1762746944 17.707 98 22 44 3 1779001584 9536512 6718128
14:22:00 4696 8192000000 10725197776 11143933952 1795192080 17.974 99 40 80 1 1814396944 8055280 11149584
14:22:11 7945 8192000000 10738083696 11153182720 1810034496 18.096 100 35 70 0 1830778288 10390384 10353408
14:22:27 11047 8192000000 10732474096 11152502784 1788280128 17.918 98 15 29 2 1797956736 5419568 4257040
14:22:47 8117 8192000000 10741027392 11165523968 1830281712 18.262 100 36 71 2 1847099360 6205056 10612592
14:23:01 16536 8192000000 10765169152 11180716032 1840744864 18.347 100 35 67 4 1855637072 5525360 9366848
14:23:25 8369 8192000000 10754628224 11185180672 1848210176 18.408 100 37 73 3 1865292576 5583792 11498608
14:23:39 8799 8192000000 10765478064 11189288960 1852000784 18.438 100 25 49 2 1866071968 6142816 7928368
14:23:57 11853 8192000000 10771851280 11195383808 1852686544 18.444 100 20 41 1 1864489104 6445920 5356640
14:24:17 53369 8192000000 10791360064 11202162688 1863009216 18.528 100 49 98 3 1883881296 4979680 15892400
14:25:26 16055 8192000000 10771121760 11197366272 1856112000 18.472 100 20 39 2 1867936672 5755264 6069408
14:25:52 5992 8192000000 10774292128 11201175552 1862154176 18.521 100 26 52 2 1876294176 6244720 7895280
14:26:05 7412 8192000000 10791314080 11214163968 1867859328 18.567 100 24 48 1 1884175520 9835488 6480704
14:26:19 10923 8192000000 10787489488 11215372288 1871743072 18.598 100 22 42 1 1883096416 5535088 5818256
14:26:39 5862 8192000000 10800032336 11225202688 1875699680 18.630 100 28 57 1 1894070192 10637008 7733504
14:26:53 9330 8192000000 10806940800 11227336704 1880298752 18.668 100 22 44 2 1891563600 5205712 6059136
14:27:10 7928 8192000000 10828095360 11243098112 1897063984 18.803 100 42 83 1 1915284224 5510528 12709712
14:27:31 3469 8192000000 10845945776 11253288960 1908698736 18.896 100 52 104 2 1929872560 7062944 14110880
14:27:41 21371 8192000000 10849861616 11268542464 1913364224 18.934 100 43 84 1 1932967360 7602752 12000384
14:28:10 17756 8192000000 10847185744 11268456448 1922594768 19.008 100 46 93 0 1944344752 8519040 13230944
14:28:37 14231 8192000000 10861127056 11278610432 1928824336 19.057 100 52 104 0 1951701472 8481600 14395536
14:29:00 56597 8192000000 10862194464 11292110848 1931495696 19.079 100 42 83 1 1954761856 10939328 12326832
14:30:07 67113 8192000000 10875923952 11318349824 1941638560 19.160 100 30 60 2 1963197984 12850864 8708560
14:31:22 25426 8192000000 10877786240 11314872320 1945886080 19.194 100 31 59 1 1970170064 15103280 9180704
14:31:55 14311 8192000000 10887094880 11323441152 1955113360 19.267 100 40 80 0 1984545264 17658032 11773872
14:32:19 32065 8192000000 10897736240 11332456448 1961207152 19.316 100 34 67 2 1988946528 16977920 10761456
14:33:04 22001 8192000000 10913229184 11344515072 1970334256 19.388 100 43 86 3 2004186000 21205360 12646384
14:33:48 22272 8192000000 10921016576 11359318016 1980618400 19.470 100 42 84 2 2013832352 20728384 12485568
14:34:19 9618 8192000000 10924156000 11361357824 1983666368 19.494 100 41 82 2 2017484576 20808112 13010096
14:34:38 14921 8192000000 10934274144 11363332096 1986443568 19.516 100 59 118 3 2024266480 20844368 16978544
14:35:04 15075 8192000000 10955918528 11378757632 1973422400 19.413 99 66 133 0 2023658528 31762608 18473520
14:35:27 6899 8192000000 10948479168 11375538176 1991234432 19.554 100 66 132 0 2035547424 24946480 19366512
14:35:44 2929 8192000000 10955049856 11383541760 1992075232 19.560 100 69 136 0 2041649408 29906144 19668032
14:35:54 15517 8192000000 10952667248 11377524736 1992417408 19.563 100 69 137 1 2037986608 25928032 19641168
14:36:17 4209 8192000000 10952859904 11377844224 1989237264 19.538 100 70 139 0 2039098256 29540624 20320368
14:36:29 5256 8192000000 10965317376 11385655296 1993932784 19.575 100 65 130 0 2046369984 33414288 19022912
14:36:42 9366 8192000000 10957589632 11387449344 2000794480 19.629 100 59 118 0 2048196752 29870720 17531552
14:37:00 2500 8192000000 10962071328 11379372032 1990606144 19.549 99 68 137 0 2042442880 31793776 20042960
14:37:10 7789 8192000000 10974830480 11399016448 2007983072 19.686 100 75 150 1 2062859472 33019200 21857200
14:37:28 7023 8192000000 10986239536 11411107840 2012758784 19.723 100 66 130 1 2065967424 34287840 18920800
14:37:46 6632 8192000000 10987508800 11415683072 2017123856 19.758 100 68 135 1 2075328800 37833904 20371040
14:38:00 8411 8192000000 10992375216 11423928320 2021864576 19.795 100 58 118 3 2077566576 38443584 17258416
14:38:19 7197 8192000000 10997824736 11424145408 2028739072 19.849 100 67 133 2 2089340304 40075408 20525824
14:38:33 1663 8192000000 11009987712 11429339136 2026962032 19.835 100 73 146 0 2088812528 39754000 22096496
14:38:43 1501 8192000000 10976842144 11393572864 1991583200 19.556 99 82 165 2 2058381600 40573136 26225264
14:38:52 5290 8192000000 10983542224 11410624512 2010451856 19.705 100 72 143 1 2078900496 46499024 21949616
14:39:06 2484 8192000000 11003597296 11426217984 2019633760 19.777 100 70 140 0 2086635040 45405312 21595968
14:39:16 2642 8192000000 10995315632 11419897856 2009171440 19.695 100 80 158 3 2079701456 46195424 24334592
14:39:27 1552 8192000000 10989851312 11410857984 2006314800 19.673 100 85 168 1 2079645072 47037616 26292656
14:39:35 3854 8192000000 10980185232 11402125312 1996856656 19.598 100 74 145 2 2065057120 46462704 21737760
14:39:46 11542 8192000000 10966697056 11383021568 1963328464 19.332 98 70 138 4 2031394352 46682640 21383248
14:40:09 7670 8192000000 10988525536 11412459520 2004223632 19.656 100 70 140 1 2074326848 48569104 21534112
14:40:27 6216 8192000000 10993822720 11421691904 2008280368 19.688 100 70 138 2 2081317152 51207824 21828960
14:40:45 3037 8192000000 10975515680 11399880704 1962305312 19.324 98 69 138 2 2036663616 52768672 21589632
14:40:56 7984 8192000000 10959245760 11389034496 1984147664 19.498 100 63 125 4 2054573392 49715600 20710128
14:41:15 2423 8192000000 10955215152 11373731840 1930701056 19.072 97 64 126 2 2002470112 52043104 19725952
14:41:24 2444 8192000000 10980315504 11391442944 1978836816 19.455 100 92 182 0 2061730464 53711856 29181792
14:41:35 3127 8192000000 10955051104 11370270720 1966568352 19.358 100 70 140 0 2038215408 49684304 21962752
14:41:49 3296 8192000000 10974710448 11392032768 1982272576 19.483 100 76 152 1 2057628768 51091120 24265072
14:42:03 3378 8192000000 10973693952 11387088896 1963916800 19.337 99 80 161 0 2043574672 53271808 26386064
14:42:13 2830 8192000000 10972404096 11378118656 1969975248 19.385 99 89 173 2 2051417872 54310496 27132128
14:42:30 2583 8192000000 10995068928 11406921728 1991323056 19.554 100 83 165 0 2072864128 56309824 25231248
14:42:40 5144 8192000000 10991829888 11410624512 1998148528 19.608 100 81 162 0 2077797792 54644256 25005008
14:42:59 6475 8192000000 10994174128 11419639808 2005854512 19.669 100 67 132 1 2077986064 52403856 19727696
14:43:14 4721 8192000000 10969811072 11388379136 1973354880 19.412 99 68 136 3 2047861200 52900176 21606144
14:43:27 4128 8192000000 10976399504 11396136960 1980355520 19.468 100 70 141 1 2056867120 53624544 22887056
14:43:39 1831 8192000000 10985576512 11402207232 1986904672 19.519 100 82 164 1 2067822768 55218336 25699760
14:43:49 2809 8192000000 10977830176 11391987712 1984417312 19.500 100 78 156 2 2060353344 51414352 24521680
14:43:58 2256 8192000000 10987474416 11399835648 1975773088 19.431 99 92 184 3 2057492576 53284944 28434544
14:44:09 1064 8192000000 10985147008 11395870720 1982232864 19.482 100 87 172 2 2062198576 54227024 25738688
14:44:17 3988 8192000000 10986492048 11407552512 1993180352 19.569 100 77 154 0 2072264272 54861664 24222256
14:44:28 3439 8192000000 10999715504 11417133056 2001943840 19.638 100 83 164 1 2081013008 53907376 25161792
14:44:41 2722 8192000000 10998873184 11417767936 2007602576 19.683 100 78 156 0 2085117872 53706272 23809024
14:44:52 3302 8192000000 11004423184 11428925440 2009462976 19.697 100 70 140 1 2089522288 58390912 21668400
14:45:03 1563 8192000000 11011198496 11422228480 2002857088 19.645 100 91 182 1 2088292416 56649216 28786112
14:45:12 2809 8192000000 10993652912 11410575360 1979205824 19.458 99 83 166 0 2062575136 58112000 25257312
14:45:28 2400 8192000000 10994305440 11401310208 1984995648 19.504 100 92 184 0 2071552688 58137984 28419056
14:45:37 2090 8192000000 11000175184 11414024192 1993051808 19.568 100 90 181 0 2079697392 58446496 28199088
14:45:47 1673 8192000000 10995850704 11406864384 1972821152 19.408 99 92 186 1 2060453280 59180928 28451200
14:45:55 2854 8192000000 10994370256 11408035840 1985452912 19.508 100 85 170 2 2070532928 59289120 25790896
14:46:08 1221 8192000000 10998187264 11404726272 1985504672 19.508 100 89 180 0 2073656640 60012528 28139440
14:46:19 1572 8192000000 11000933728 11409637376 1990217296 19.546 100 84 167 2 2075287472 59003344 26066832
14:46:29 5138 8192000000 10991486528 11412697088 1990380448 19.547 100 69 138 1 2072560272 60322384 21857440
14:46:41 3743 8192000000 10982878160 11411333120 1991653664 19.557 100 64 128 1 2073286448 61296144 20336640
14:46:56 19053 8192000000 10980420848 11422322688 1991261984 19.554 100 43 86 2 2067185984 61296800 14627200
14:47:23 12077 8192000000 10974842512 11415531520 1972503072 19.405 99 41 82 0 2051508608 63877616 15127920
14:47:48 7798 8192000000 10985275872 11419889664 1988221840 19.530 100 54 108 1 2073543856 66681808 18640208
14:48:12 2850 8192000000 11000090048 11420553216 1978660480 19.454 99 79 157 1 2069822192 66161904 24999808
14:48:25 2690 8192000000 11022864480 11447255040 2004078352 19.655 100 80 162 0 2099992928 70723120 25191456
14:48:38 6383 8192000000 11007216432 11452989440 1997577136 19.604 100 51 102 0 2091963072 77873440 16512496
14:48:56 18428 8192000000 10991000528 11447775232 2002764912 19.645 100 47 94 1 2088212816 70133536 15314368
14:49:23 8183 8192000000 11003978224 11446996992 2005076448 19.663 100 49 98 1 2090983232 69496960 16409824
14:49:45 20634 8192000000 10989228640 11436634112 1988176304 19.529 99 38 76 1 2065715584 64429024 13110256
14:50:14 8232 8192000000 10997421936 11435679744 1993404976 19.571 100 52 104 1 2077475664 66817680 17253008
14:50:38 13798 8192000000 10987788720 11439960064 1988247376 19.530 100 33 66 1 2073784512 73345712 12191424
14:51:01 4649 8192000000 10981119344 11437584384 1987720848 19.526 100 32 64 0 2069825520 70037168 12067504
14:51:28 25239 8192000000 10971081536 11427737600 1980145984 19.466 100 33 66 0 2058246352 66535520 11564848
14:52:01 33599 8192000000 10944601408 11409395712 1953242656 19.252 99 24 48 2 2025305904 62884416 9178832
14:52:54 50917 8192000000 10934628704 11397709824 1907887664 18.890 97 18 36 1 1965542368 50990496 6664208
14:54:04 36089 8192000000 10899957840 11371016192 1945312160 19.189 99 8 16 0 1968980896 21172480 2496256
14:54:48 71271 8192000000 10906221120 11365834752 1942522240 19.167 99 18 36 1 1963356688 14952992 5881456
14:56:38 39453 8192000000 10917216912 11374354432 1963415440 19.333 99 56 111 0 1987676736 8334176 15927120
14:57:25 77672 8192000000 10893323616 11354824704 1942259632 19.165 98 26 52 2 1961329216 12277168 6792416
14:59:17 67839 8192000000 10863562144 11326926848 1879026640 18.657 96 12 24 1 1893145216 11005968 3112608
15:00:31 166959 8192000000 10887866224 11359080448 1873561024 18.613 95 19 38 0 1898414704 19645488 5208192
15:04:50 85869 8192000000 10886341184 11370213376 1950066144 19.227 99 19 38 2 1976032960 20487632 5479184
15:06:37 45294 8192000000 10900389216 11385778176 1957473200 19.286 99 21 42 0 1990925376 26926688 6525488
15:07:28 39762 8192000000 10910349680 11377328128 1983993728 19.496 100 39 75 3 2012485056 16334832 12156496
15:08:20 58791 8192000000 10916563792 11382124544 1987447392 19.524 100 22 43 0 2005980368 12119824 6413152
15:09:29 55471 8192000000 10914851760 11388817408 1991337536 19.554 100 9 18 0 2005838384 12120560 2380288
15:10:35 57734 8192000000 10898457632 11372490752 1949454144 19.222 98 15 27 0 1968742448 15140016 4148288
15:11:44 74970 8192000000 10905769936 11375054848 1981681664 19.478 100 11 22 0 2000465296 15452128 3331504
15:13:06 93812 8192000000 10881503712 11372412928 1904199776 18.860 96 10 20 1 1919259680 12057264 3002640
15:14:56 123008 8192000000 10899006656 11368558592 1936559792 19.119 98 12 24 0 1953439456 13960512 2919152
15:17:07 38279 8192000000 10933282864 11378798592 1989135472 19.537 100 54 101 1 2011796576 7823840 14837264
15:17:59 40345 8192000000 10923728144 11391152128 1991731904 19.557 100 31 62 2 2010449440 10275776 8441760
15:19:06 64285 8192000000 10911643056 11375144960 1928544896 19.055 97 21 43 0 1944631232 10452176 5634160
15:20:49 52089 8192000000 10896189792 11357466624 1916580640 18.959 97 22 44 0 1940118272 17187552 6350080
15:21:47 92930 8192000000 10903247712 11369545728 1898973616 18.818 96 18 36 0 1915454032 11787952 4692464
15:23:58 55775 8192000000 10897473488 11391000576 1959538992 19.302 99 28 56 0 1986821136 19434592 7847552
15:25:03 103072 8192000000 10903286128 11378065408 1962015712 19.322 99 15 30 0 1980795168 14658752 4120704
15:27:06 47831 8192000000 10897357360 11365810176 1925235568 19.029 97 31 63 0 1947206432 13407712 8563152
15:28:03 39685 8192000000 10907275888 11363864576 1943354704 19.174 98 49 98 1 1967177760 10059616 13763440
15:28:49 42350 8192000000 10902830128 11362562048 1964750784 19.344 100 41 82 2 1986708800 11028080 10929936
15:29:38 2000 8192000000 10912725904 11361918976 1972797520 19.408 100 55 109 1 1998634656 10209392 15627744
15:29:49 11323 8192000000 10908468112 11363958784 1972639152 19.406 100 33 66 2 1990973248 9577232 8756864
15:30:22 9891 8192000000 10887865744 11348291584 1967148752 19.363 100 36 64 3 1980570688 5045536 8376400
15:30:42 71015 8192000000 10869495360 11344973824 1891855776 18.761 96 15 30 0 1903968160 7690880 4421504
15:31:59 67895 8192000000 10863463904 11341479936 1916204224 18.956 98 14 28 0 1930233536 9930656 4098656
15:33:13 102233 8192000000 10865832512 11342233600 1901085792 18.835 97 12 24 0 1915285584 10442160 3757632
15:35:47 49950 8192000000 10850130256 11334352896 1901836208 18.841 98 25 50 3 1924326768 14862976 7627584
15:36:44 19694 8192000000 10877219920 11328069632 1909323472 18.901 98 23 46 0 1924623952 8761744 6538736
15:37:09 22947 8192000000 10888793968 11344547840 1952026704 19.243 100 55 109 1 1981225440 13200448 15998288
15:37:50 37429 8192000000 10899031040 11360768000 1959756336 19.304 100 37 74 0 1985608752 15136544 10715872
15:38:50 89758 8192000000 10890321008 11359559680 1898612464 18.815 97 13 26 0 1924075440 21539376 3923600
15:41:03 84338 8192000000 10883766288 11350151168 1938612256 19.136 99 15 30 1 1956656704 13864176 4180272
15:42:40 22982 8192000000 10901809088 11355115520 1959809200 19.305 100 37 74 3 1979221088 9143360 10268528
15:43:11 31087 8192000000 10909556240 11363155968 1949401520 19.222 99 47 94 1 1976489344 14010688 13077136
15:44:00 76945 8192000000 10898678288 11375984640 1948758608 19.217 99 21 42 0 1971331872 16539728 6033536
15:45:37 52173 8192000000 10847140192 11318554624 1805133376 18.056 92 16 32 1 1825260864 15487152 4640336
15:46:35 71770 8192000000 10866888112 11327434752 1901152480 18.836 98 26 52 2 1919241120 11115792 6972848
15:47:55 102636 8192000000 10869437200 11325980672 1917122416 18.964 99 40 80 0 1936426288 7971312 11332560
15:49:57 71731 8192000000 10875448960 11340476416 1926901952 19.042 99 30 60 1 1947215744 12082416 8231376
15:51:35 41505 8192000000 10842367936 11323080704 1884145264 18.699 97 7 16 0 1895380640 9490752 1744624
15:52:23 76340 8192000000 10833084928 11303084032 1914299072 18.941 99 17 34 1 1926836000 7300144 5236784
15:53:50 27065 8192000000 10851741808 11319660544 1913400512 18.934 99 18 36 2 1928414768 9086160 5928096
15:54:29 91418 8192000000 10858651792 11335188480 1905834944 18.873 98 6 12 0 1916145344 8408960 1901440
15:56:08 68359 8192000000 10891864512 11359850496 1884527872 18.702 96 10 20 0 1893639200 6803776 2307552
15:57:28 41163 8192000000 10882391792 11337134080 1911407744 18.918 97 23 46 1 1927833872 10040928 6385200
15:58:15 89615 8192000000 10879342736 11346370560 1900894528 18.833 97 11 22 1 1915543104 11733728 2914848
16:00:47 24200 8192000000 10897183712 11344375808 1938864208 19.138 99 33 66 2 1958589872 10493728 9231936
16:01:24 93094 8192000000 10873231408 11334803456 1864124176 18.537 95 20 40 0 1883433472 13782336 5526960
16:03:04 34539 8192000000 10872683152 11325112320 1905057040 18.867 98 27 54 0 1921536032 9035776 7443216
16:03:45 59898 8192000000 10857993744 11319513088 1880289968 18.667 97 29 58 4 1902958912 13859344 8809600
16:05:14 84074 8192000000 10881023520 11350073344 1907358368 18.885 98 14 28 2 1921897024 10634112 3904544
16:06:49 135142 8192000000 10864068256 11326005248 1814018832 18.129 93 12 24 1 1826092432 8989456 3084144
16:09:11 158853 8192000000 10879968448 11337416704 1930749600 19.073 99 24 48 1 1948447952 10977744 6720608
16:11:58 20273 8192000000 10875528080 11341029376 1952880896 19.249 100 21 43 1 1966666928 7761216 6024816
16:12:24 42226 8192000000 10884170000 11351068672 1938453584 19.134 99 9 18 1 1951410528 10210432 2746512
16:13:20 56569 8192000000 10870085520 11345641472 1928131552 19.052 98 14 29 0 1946006672 13567280 4307840
16:14:23 99170 8192000000 10871928016 11344617472 1917351328 18.966 98 12 24 1 1937179232 16198960 3628944
16:16:11 70278 8192000000 10876477520 11353554944 1927262144 19.045 99 9 18 0 1950040224 20139776 2638304
16:17:27 165737 8192000000 10883606784 11367268352 1901323744 18.837 97 11 22 1 1919550592 15191088 3035760
16:20:20 71484 8192000000 10887531120 11344334848 1886275968 18.716 96 20 40 0 1901628736 9273072 6079696
16:21:49 89461 8192000000 10868207568 11344375808 1895379200 18.789 97 18 36 1 1915383056 15392400 4611456
16:23:32 36971 8192000000 10888864688 11341422592 1932238752 19.085 99 37 74 1 1953318912 10646064 10434096
16:24:16 62524 8192000000 10863949952 11329114112 1891177904 18.755 97 15 30 0 1910986016 15491568 4316544
16:25:28 98975 8192000000 9825910128 10345472000 809317296 8.991 42 10 20 0 817097584 5255840 2524448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-12-2020 16:27:56 to 02-12-2020 16:28:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 144 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-12-2020 16:28:27 to 02-12-2020 16:28:29.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          238253
MON$OLDEST_ACTIVE               238254
MON$OLDEST_SNAPSHOT             238254
MON$NEXT_TRANSACTION            238254
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2007168
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:236: 
:237: mscs-test-161.budzdorov.ru    Wed Dec  2 16:27:10 2020
:238:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:239: 
:240: 
:241: mscs-test-161.budzdorov.ru    Wed Dec  2 16:27:14 2020
:242:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:243: 
:244: 
:245: mscs-test-161.budzdorov.ru    Wed Dec  2 16:27:14 2020
:246:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:247: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

02.12.20 16:28:30. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-12-02 16:28:33 No severe PSQL-related problems occured
02.12.20 16:28:34. End of report.