Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.04.2021 01: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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17103644 kB
MemAvailable 31403848 kB
Buffers 0 kB
Cached 14529524 kB
SwapCached 0 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 2021-04-06 01:27:27
DTS_END                         2021-04-06 01:27:27.2630
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54158
TRN_ID                          246926
ATT_ID                          695
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: 9510.36 19751 1141243
customer order: creation 180.09 357 21611
customer order: refuse 16.13 351 1936
order to supplier: creation 47.11 1339 5653
order to supplier: removal 3.45 100653 414
invoice (draft): creation 48.55 3203 5826
invoice (draft): removal 51.92 803 6230
invoice accept: apply 42.75 17951 5130
invoice accept: cancel 47.14 731 5657
customer reserve: creation 4086.27 173 490352
customer reserve: removal 4670.15 58 560418
realization accept: apply 88.25 183 10590
realization accept: cancel 93.93 117 11271
payment from customer: creation 61.53 117 7384
payment from customer: removal 6.36 91 763
payment to supplier: creation 50.60 132 6072
payment to supplier: removal 3.58 96 429
service: total inventory turnovers 4.79 1270 575
service: total monetary turnovers 6.95 26 834
service: aggregate perf. data 0.78 26846 94
service: refresh index statistics 0.03 240514 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-04-2021 01:28:22 to 06-04-2021 01:28:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3867
TEST_TIME 2 2999
TEST_TIME 3 3588
TEST_TIME 4 3365
TEST_TIME 5 3821
TEST_TIME 6 4186
TEST_TIME 7 4153
TEST_TIME 8 4586
TEST_TIME 9 4938
TEST_TIME 10 4810
TEST_TIME 11 5389
TEST_TIME 12 5540
TEST_TIME 13 5598
TEST_TIME 14 6238
TEST_TIME 15 6559
TEST_TIME 16 6764
TEST_TIME 17 7154
TEST_TIME 18 7341
TEST_TIME 19 7437
TEST_TIME 20 7506
TEST_TIME 21 8261
TEST_TIME 22 8344
TEST_TIME 23 8435
TEST_TIME 24 8544
TEST_TIME 25 8622
TEST_TIME 26 9375
TEST_TIME 27 10709
TEST_TIME 28 10426
TEST_TIME 29 10573
TEST_TIME 30 10630
TEST_TIME 31 10848
TEST_TIME 32 10656
TEST_TIME 33 10522
TEST_TIME 34 10440
TEST_TIME 35 10387
TEST_TIME 36 10405
TEST_TIME 37 10383
TEST_TIME 38 10289
TEST_TIME 39 10396
TEST_TIME 40 10310
TEST_TIME 41 10308
TEST_TIME 42 10283
TEST_TIME 43 10267
TEST_TIME 44 10372
TEST_TIME 45 10201
TEST_TIME 46 10012
TEST_TIME 47 10087
TEST_TIME 48 10017
TEST_TIME 49 9959
TEST_TIME 50 9897
TEST_TIME 51 9827
TEST_TIME 52 9883
TEST_TIME 53 9821
TEST_TIME 54 9970
TEST_TIME 55 9966
TEST_TIME 56 9872
TEST_TIME 57 9865
TEST_TIME 58 9729
TEST_TIME 59 9758
TEST_TIME 60 9742
TEST_TIME 61 9737
TEST_TIME 62 9743
TEST_TIME 63 9739
TEST_TIME 64 9808
TEST_TIME 65 9818
TEST_TIME 66 9760
TEST_TIME 67 9780
TEST_TIME 68 9747
TEST_TIME 69 9806
TEST_TIME 70 9897
TEST_TIME 71 9909
TEST_TIME 72 9895
TEST_TIME 73 9892
TEST_TIME 74 9935
TEST_TIME 75 9888
TEST_TIME 76 9790
TEST_TIME 77 9783
TEST_TIME 78 9799
TEST_TIME 79 9715
TEST_TIME 80 9738
TEST_TIME 81 9692
TEST_TIME 82 9676
TEST_TIME 83 9670
TEST_TIME 84 9645
TEST_TIME 85 9598
TEST_TIME 86 9545
TEST_TIME 87 9537
TEST_TIME 88 9499
TEST_TIME 89 9498
TEST_TIME 90 9487
TEST_TIME 91 9558
TEST_TIME 92 9570
TEST_TIME 93 9620
TEST_TIME 94 9573
TEST_TIME 95 9601
TEST_TIME 96 9628
TEST_TIME 97 9656
TEST_TIME 98 9693
TEST_TIME 99 9692
TEST_TIME 100 9700
TEST_TIME 101 9753
TEST_TIME 102 9766
TEST_TIME 103 9703
TEST_TIME 104 9619
TEST_TIME 105 9633
TEST_TIME 106 9590
TEST_TIME 107 9550
TEST_TIME 108 9531
TEST_TIME 109 9545
TEST_TIME 110 9523
TEST_TIME 111 9489
TEST_TIME 112 9455
TEST_TIME 113 9493
TEST_TIME 114 9473
TEST_TIME 115 9491
TEST_TIME 116 9515
TEST_TIME 117 9527
TEST_TIME 118 9530
TEST_TIME 119 9563
TEST_TIME 120 9512

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-04-2021 01:28:25 to 06-04-2021 01:28:29.

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 1592721 1592721 0 0.00 0 18743 6 0 0
doc_list_biud 1592720 1592720 0 0.00 0 32714 26 0 0
sp_add_invoice_to_stock 5203 5130 73 1.40 20 169873 17952 0 73
sp_cancel_adding_invoice 5657 5657 0 0.00 6 63719 732 0 0
sp_cancel_client_order 1936 1936 0 0.00 4 11826 351 0 0
sp_cancel_customer_reserve 560418 560418 0 0.00 1 24593 58 0 0
sp_cancel_pay_from_customer 763 763 0 0.00 2 8416 92 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 2 7858 97 0 0
sp_cancel_supplier_invoice 6234 6230 4 0.06 2 22450 804 0 4
sp_cancel_supplier_order 414 414 0 0.00 9 1197382 100653 0 0
sp_cancel_write_off 11271 11271 0 0.00 1 15789 117 0 0
sp_client_order 21611 21611 0 0.00 3 36009 357 0 0
sp_customer_reserve 490352 490352 0 0.00 0 99765 173 0 0
sp_fill_shopping_cart 33084 33084 0 0.00 1 32465 41 0 0
sp_fill_shopping_cart_clo_res 490346 490346 0 0.00 0 20817 13 0 0
sp_get_clo_for_invoice 5124 5124 0 0.00 0 19649 230 0 0
sp_kill_cost_storno 18120 18120 0 0.00 0 18737 56 0 0
sp_kill_qstorno_ret_qs2qd 1138751 1138751 0 0.00 0 24501 32 0 0
sp_kill_qty_storno 601639 601639 0 0.00 0 32714 68 0 0
sp_lock_selected_doc 21882 21882 0 0.00 0 6650 5 0 0
sp_make_cost_storno 29169 29169 0 0.00 0 12980 53 0 0
sp_multiply_rows_for_pdistr 29169 29169 0 0.00 0 8985 29 0 0
sp_multiply_rows_for_qdistr 21611 21611 0 0.00 0 28834 158 0 0
sp_pay_from_customer 7384 7384 0 0.00 4 9947 118 0 0
sp_pay_to_supplier 6072 6072 0 0.00 4 17598 133 0 0
sp_payment_common 13456 13456 0 0.00 1 9916 34 0 0
sp_qd_handle_on_cancel_clo 1936 1936 0 0.00 0 11819 321 0 0
sp_qd_handle_on_invoice_upd_sts 10780 10780 0 0.00 0 32713 313 0 0
sp_qd_handle_on_reserve_upd_sts 10590 10590 0 0.00 0 12467 54 0 0
sp_reserve_write_off 10590 10590 0 0.00 6 14278 183 0 0
sp_supplier_invoice 5826 5826 0 0.00 6 95771 3203 0 0
sp_supplier_order 5653 5653 0 0.00 5 52890 1340 0 0
srv_aggregate_perf_data 95 94 1 1.05 3163 548245 26846 0 1
srv_fill_mon_cache_memory 163 163 0 0.00 742 121167 33060 0 0
srv_find_qd_qs_mism 1089860 1089860 0 0.00 0 15091 5 0 0
srv_make_invnt_saldo 575 575 0 0.00 37 56022 1270 0 0
srv_make_money_saldo 834 834 0 0.00 1 1605 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 205378 290123 240515 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 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 5130 5130 0 0.00 0 14277 192 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 1 4704 93 0 0
t$perf-norm:sp_cancel_client_order 1936 1936 0 0.00 0 6107 17 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 1937 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 763 763 0 0.00 0 9187 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 1525 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 486 6 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 24971 1611 0 0
t$perf-norm:sp_cancel_write_off 1071 1071 0 0.00 0 1761 10 0 0
t$perf-norm:sp_client_order 21611 21611 0 0.00 0 9239 17 0 0
t$perf-norm:sp_customer_reserve 1095 1095 0 0.00 0 3219 11 0 0
t$perf-norm:sp_pay_from_customer 7384 7384 0 0.00 0 6994 13 0 0
t$perf-norm:sp_pay_to_supplier 6072 6072 0 0.00 0 9351 16 0 0
t$perf-norm:sp_reserve_write_off 10590 10590 0 0.00 0 9236 17 0 0
t$perf-norm:sp_supplier_invoice 5826 5826 0 0.00 0 5079 19 0 0
t$perf-norm:sp_supplier_order 5653 5653 0 0.00 0 5447 17 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 1560 30 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 5165 53 0 0
t$perf-norm:srv_make_invnt_saldo 575 575 0 0.00 0 1556 20 0 0
t$perf-norm:srv_make_money_saldo 834 834 0 0.00 0 1149 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10392 10246 146 1.40 0 4524 17 0 146
v_all_customers 39592 39592 0 0.00 0 198 1 0 0
v_all_suppliers 32026 32026 0 0.00 0 84 1 0 0
v_all_wares 43222 43222 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 4044 15 0 0
v_cancel_client_order 3872 3872 0 0.00 0 4805 7 0 0
v_cancel_customer_prepayment 1526 1526 0 0.00 0 4531 10 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 1881 5 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 3999 9 0 0
v_cancel_supplier_invoice 866 858 8 0.92 0 1193 13 0 8
v_cancel_supplier_order 828 828 0 0.00 0 4074 12 0 0
v_cancel_write_off 2142 2142 0 0.00 0 4353 16 0 0
v_max_id_clo_ord 5648 5648 0 0.00 0 913 2 0 0
v_max_id_clo_res 1095 1095 0 0.00 0 2887 14 0 0
v_max_id_ord_sup 5823 5823 0 0.00 0 8718 7 0 0
v_max_non_paid_invoice 1530 1530 0 0.00 0 2817 6 0 0
v_max_non_paid_realizn 3904 3904 0 0.00 0 3744 5 0 0
v_min_id_clo_ord 5648 5648 0 0.00 0 28518 22 0 0
v_min_id_clo_res 1095 1095 0 0.00 0 1854 6 0 0
v_min_id_ord_sup 5823 5823 0 0.00 0 14528 25 0 0
v_min_non_paid_invoice 6072 6072 0 0.00 0 9908 27 0 0
v_min_non_paid_realizn 7384 7384 0 0.00 0 9772 22 0 0
v_our_firm 10590 10590 0 0.00 0 91 1 0 0
v_reserve_write_off 21180 21180 0 0.00 0 6712 7 0 0
x_lock_depdocs_on_canc_invoice 11458 11458 0 0.00 0 15596 110 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 20468 401 0 0
x_make_qstorno_1000_1200 5653 5653 0 0.00 2 52821 1244 0 0
x_make_qstorno_1200_2000 5826 5826 0 0.00 3 95676 3063 0 0
x_make_qstorno_2100_3300 490352 490352 0 0.00 0 99745 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-04-2021 01:28:30 to 06-04-2021 01:28:34.

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
22:57:30 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:37 26608 8192000000 10275094880 10588983296 833691216 9.236 64 51 103 0 852633264 2359664 16582384
22:58:13 43203 8192000000 10363289440 10683936768 1408496160 14.671 100 89 178 0 1442558416 5128880 28933376
22:59:07 27113 8192000000 10397543856 10720448512 1439047104 14.941 100 89 178 0 1474917424 6622368 29247952
22:59:42 27283 8192000000 10414175296 10740850688 1462759952 15.150 100 89 178 0 1499289104 7307152 29222000
23:00:19 19698 8192000000 10433054032 10762850304 1483764384 15.334 100 90 178 1 1520411520 7892976 28754160
23:00:57 19646 8192000000 10448549600 10782277632 1502327104 15.496 100 94 188 0 1541373904 8706448 30340352
23:01:29 14830 8192000000 10460951200 10802810880 1522732768 15.674 100 77 154 1 1555964624 8909280 24322576
23:01:52 11546 8192000000 10481000112 10826178560 1542238112 15.843 100 75 150 0 1574439696 9140896 23060688
23:02:15 11705 8192000000 10519231536 10869383168 1578802032 16.158 100 80 160 1 1612847680 9497776 24547872
23:02:36 14396 8192000000 10545839264 10900656128 1606533952 16.395 100 78 156 0 1639769440 9569072 23666416
23:02:59 16692 8192000000 10584348832 10942517248 1631717008 16.609 100 78 156 0 1665442384 10423712 23301664
23:03:23 12566 8192000000 10597330128 10961764352 1659236800 16.842 100 82 165 2 1695137792 11536320 24364672
23:03:43 10089 8192000000 10613805616 10979209216 1676331728 16.986 100 77 154 3 1710677456 12058640 22287088
23:04:00 11680 8192000000 10624016992 10997673984 1689182256 17.094 100 71 142 1 1721357584 11795472 20379856
23:04:20 9610 8192000000 10648548016 11022057472 1705230768 17.229 100 76 152 0 1738940432 11581632 22128032
23:04:40 10099 8192000000 10664375824 11041771520 1731997360 17.452 100 77 152 3 1766264096 12563344 21703392
23:04:57 7017 8192000000 10682075584 11056844800 1742961088 17.543 100 85 170 0 1780085136 13458960 23665088
23:05:16 8033 8192000000 10694188160 11071569920 1757443552 17.663 100 81 162 1 1794455568 13680576 23331440
23:05:32 6651 8192000000 10706705168 11086479360 1764347648 17.720 100 76 151 2 1799283824 13688672 21247504
23:05:45 3860 8192000000 10712112832 11091918848 1776818368 17.823 100 85 168 2 1814217200 13692352 23706480
23:05:55 2551 8192000000 10723356352 11102912512 1787796176 17.914 100 84 168 3 1824315440 13034752 23484512
23:06:05 5706 8192000000 10728283216 11112824832 1793266656 17.959 100 78 157 0 1827658016 12403152 21988208
23:06:17 3718 8192000000 10738179168 11122020352 1803867184 18.046 100 87 175 2 1841166176 12654288 24644704
23:06:27 11141 8192000000 10745078624 11131191296 1804750896 18.053 100 79 156 1 1840070736 13610400 21709440
23:06:45 2312 8192000000 10748448000 11135623168 1807720768 18.077 100 78 155 1 1842789264 13794640 21273856
23:06:55 2247 8192000000 10769686176 11151888384 1825934048 18.226 100 84 166 1 1862807552 13152064 23721440
23:07:03 2468 8192000000 10780645184 11165380608 1835816192 18.307 100 88 175 2 1874223344 12654928 25752224
23:07:13 2143 8192000000 10780599568 11167342592 1843223088 18.367 100 88 176 3 1879946288 12584080 24139120
23:07:21 2472 8192000000 10793594208 11175997440 1848372256 18.409 100 90 180 2 1887003696 12894848 25736592
23:07:30 1877 8192000000 10786965776 11171602432 1845346928 18.384 100 87 171 1 1883593856 13920864 24326064
23:07:39 2526 8192000000 10785960480 11178676224 1847032592 18.398 100 85 168 1 1884172192 13568960 23570640
23:07:48 2295 8192000000 10789544144 11178201088 1852451760 18.442 100 87 174 4 1890362592 13048304 24862528
23:07:57 2430 8192000000 10809440864 11194703872 1855315808 18.465 100 88 176 0 1895383552 14946736 25121008
23:08:06 1835 8192000000 10805575984 11194150912 1859697296 18.501 100 94 189 1 1900631376 14939760 25994320
23:08:14 1801 8192000000 10811108112 11198263296 1862105552 18.520 100 91 180 0 1902850528 15360512 25384464
23:08:22 2235 8192000000 10808823760 11195764736 1865109872 18.545 100 96 191 2 1907168784 15042688 27016224
23:08:31 2019 8192000000 10811613760 11200294912 1867455760 18.564 100 92 182 0 1907169040 13164336 26548944
23:08:39 1746 8192000000 10808924064 11202818048 1876180496 18.634 100 93 186 1 1915818112 12931440 26706176
23:08:47 1844 8192000000 10817955280 11211022336 1874318112 18.619 100 76 152 0 1907330272 11826832 21185328
23:08:55 10218 8192000000 10817810192 11211706368 1876747456 18.639 100 71 138 2 1905439776 9593920 19098400
23:09:15 4658 8192000000 10819326704 11214819328 1877765456 18.647 100 85 170 2 1911890528 10657392 23467680
23:09:25 1413 8192000000 10828273792 11219357696 1879713664 18.663 100 89 177 1 1918955680 13337888 25904128
23:09:35 2392 8192000000 10804840592 11215216640 1875581792 18.629 100 59 118 0 1903355424 11200144 16573488
23:09:44 4243 8192000000 10788223168 11211063296 1879289312 18.659 100 49 98 1 1901238528 8968384 12980832
23:09:54 8785 8192000000 10785906944 11206598656 1876379616 18.636 100 41 82 1 1895354160 6845472 12129072
23:10:09 3146 8192000000 10786572240 11208617984 1875769040 18.631 100 38 77 2 1894582432 8172352 10641040
23:10:19 6296 8192000000 10779251104 11209474048 1873099760 18.609 100 20 42 0 1884881760 6135072 5646928
23:10:34 9109 8192000000 10791019264 11214467072 1880201504 18.667 100 35 71 1 1897605840 7103008 10301328
23:10:49 9927 8192000000 10781210864 11213488128 1880379632 18.668 100 24 48 1 1893543472 6406864 6756976
23:11:08 5796 8192000000 10792078064 11217014784 1882675600 18.687 100 24 46 3 1894716912 5699280 6342032
23:11:23 11529 8192000000 10789106720 11219603456 1880540880 18.669 100 23 46 0 1893815600 6775424 6499296
23:11:42 6630 8192000000 10788638752 11216015360 1880862128 18.672 100 24 48 1 1894204704 6269808 7072768
23:11:56 8759 8192000000 10787495120 11220381696 1881317008 18.676 100 20 40 3 1892486080 5774352 5394720
23:12:12 12710 8192000000 10785008272 11222859776 1882396528 18.684 100 17 34 0 1893863136 6441648 5024960
23:12:32 5870 8192000000 10789409760 11224158208 1884541840 18.702 100 21 42 1 1896942352 6459024 5941488
23:12:44 8520 8192000000 10807708960 11225915392 1887815440 18.728 100 42 85 1 1905986096 5665312 12505344
23:13:01 69998 8192000000 10796106000 11236282368 1888428752 18.733 100 25 51 0 1901201888 4346320 8426816
23:14:18 7240 8192000000 10802493328 11241414656 1891514960 18.758 100 27 54 2 1906081024 7610160 6955904
23:14:33 5126 8192000000 10811439952 11243171840 1893471968 18.774 100 30 60 1 1909371808 7673952 8225888
23:14:46 3198 8192000000 10834203728 11247058944 1896694960 18.800 100 40 79 3 1916250320 8064272 11491088
23:14:56 5964 8192000000 10814800576 11246469120 1896194432 18.796 100 29 58 0 1911984912 7298592 8491888
23:15:09 8522 8192000000 10813941888 11252654080 1898367616 18.813 100 24 48 2 1911944112 6950064 6626432
23:15:26 9676 8192000000 10835040688 11255390208 1905124960 18.867 100 34 68 2 1920963968 5435632 10403376
23:15:42 9021 8192000000 10811336864 11251068928 1881389328 18.676 99 22 44 0 1893771248 6262816 6119104
23:16:00 4208 8192000000 10810420192 11240148992 1889705104 18.743 100 23 46 3 1902045616 5473968 6866544
23:16:12 12803 8192000000 10811389424 11253436416 1895374624 18.789 100 19 38 1 1910492128 9160672 5956832
23:16:31 7772 8192000000 10823961584 11253645312 1895613664 18.791 100 15 29 1 1905799072 5840336 4345072
23:16:49 8134 8192000000 10802026368 11232534528 1858184960 18.489 98 36 72 1 1875564800 5768080 11611760
23:17:05 8438 8192000000 10798580672 11235078144 1882020160 18.681 100 19 38 1 1893415296 6041280 5353856
23:17:22 11050 8192000000 10782188112 11217342464 1829546576 18.256 97 20 40 3 1841325952 5981648 5797728
23:17:40 58734 8192000000 10797038192 11205877760 1796153888 17.982 96 47 94 1 1816017008 5889312 13973808
23:18:47 15623 8192000000 10729287376 11157823488 1728155296 17.420 93 24 48 0 1740484176 5163152 7165728
23:19:08 7487 8192000000 10748818048 11167952896 1792205856 17.950 98 26 52 0 1805228720 5895504 7127360
23:19:23 6813 8192000000 10768477952 11189903360 1814329104 18.131 98 36 71 3 1831390608 7393152 9668352
23:19:38 10714 8192000000 10734299152 11150942208 1727546928 17.415 94 23 46 0 1739583056 5451728 6584400
23:19:57 6713 8192000000 10716849184 11135045632 1739779488 17.517 96 28 56 0 1753466320 5809008 7877824
23:20:10 5814 8192000000 10687633984 11108999168 1750732960 17.608 98 27 54 1 1764403600 6277520 7393120
23:20:27 5031 8192000000 10699965440 11115102208 1737331008 17.496 97 18 36 3 1748426976 5259264 5836704
23:20:41 10370 8192000000 10652573216 11064827904 1671284368 16.944 94 14 27 2 1680449712 5324656 3840688
23:21:00 8037 8192000000 10691364480 11102466048 1745590384 17.565 98 30 60 3 1759737712 5565280 8582048
23:21:14 12499 8192000000 10715087616 11127840768 1783281632 17.877 99 24 48 0 1796380160 5808688 7289840
23:21:34 12607 8192000000 10698500864 11113205760 1707142992 17.245 95 21 40 2 1718290640 5114400 6033248
23:21:53 6609 8192000000 10698098944 11110907904 1776203120 17.818 99 29 59 0 1790517936 5463872 8850944
23:22:06 10744 8192000000 10727911696 11142938624 1772451040 17.787 98 25 50 0 1785349872 4588528 8310304
23:22:23 10389 8192000000 10739751376 11158974464 1817576944 18.158 100 34 68 2 1833700368 5364752 10758672
23:22:43 66397 8192000000 10746222656 11173457920 1829610528 18.256 100 35 70 0 1844836896 5460656 9765712
23:24:00 7075 8192000000 10746603360 11170385920 1805156608 18.056 98 22 45 0 1817788112 6177088 6454416
23:24:15 7297 8192000000 10762427728 11187646464 1843152768 18.366 100 28 56 1 1856997248 5782272 8062208
23:24:28 13871 8192000000 10763610800 11188412416 1833668640 18.289 99 22 44 2 1845911376 5893536 6349200
23:24:51 7458 8192000000 10777468784 11199066112 1859259136 18.497 100 40 80 3 1876696752 5109200 12328416
23:25:06 7306 8192000000 10786680512 11209715712 1863377440 18.531 100 32 65 0 1878900704 6243104 9280160
23:25:23 5140 8192000000 10802991952 11217973248 1867584080 18.565 100 32 62 3 1887805152 10569392 9651680
23:25:37 7284 8192000000 10779379680 11214180352 1869667888 18.582 100 33 67 0 1886091840 7162656 9261296
23:25:51 5695 8192000000 10785958496 11213627392 1869275968 18.578 100 30 61 1 1884413584 6303840 8833776
23:26:03 11623 8192000000 10785778768 11218067456 1869636544 18.581 100 23 47 1 1883083728 5888256 7558928
23:26:22 6469 8192000000 10795911808 11224117248 1877109056 18.642 100 30 60 1 1896477360 9273264 10095040
23:26:37 13178 8192000000 10788846576 11223019520 1876622032 18.638 100 20 40 0 1887902656 5384240 5896384
23:27:01 10869 8192000000 10804432688 11231432704 1884232576 18.699 100 20 38 3 1895233936 5226672 5774688
23:27:18 15678 8192000000 10814803808 11239903232 1889941008 18.745 100 8 16 0 1896633120 5097904 1594208
23:27:40 20586 8192000000 10836337520 11254886400 1908795744 18.897 100 48 95 0 1929466992 7021968 13649280
23:28:10 118088 8192000000 10865384032 11290177536 1915954960 18.954 100 49 97 0 1937218544 8274976 12988608
23:30:19 19024 8192000000 10868080560 11301523456 1942924880 19.170 100 57 112 1 1973486240 14567008 15994352
23:30:47 23173 8192000000 10872160992 11304783872 1941747776 19.161 100 42 84 1 1967293216 13643536 11901904
23:31:25 44048 8192000000 10892284080 11324534784 1952358880 19.245 100 38 76 1 1980470304 17170288 10941136
23:32:17 3061 8192000000 10907422160 11334148096 1962837872 19.329 100 50 98 0 1994126592 17331712 13957008
23:32:35 11241 8192000000 10900185008 11336880128 1965959264 19.353 100 48 96 1 1998131504 17988352 14183888
23:32:56 23358 8192000000 10917557888 11349381120 1973897008 19.416 100 50 100 2 2008356816 20390368 14069440
23:33:33 10813 8192000000 10917030544 11349598208 1975610496 19.430 100 52 104 2 2010819504 19618608 15590400
23:33:54 21455 8192000000 10928287904 11359989760 1976869232 19.440 100 51 97 1 2015066752 24094192 14103328
23:34:27 6455 8192000000 10928409376 11370467328 1981671280 19.478 100 42 82 2 2021717408 27575952 12470176
23:34:41 17663 8192000000 10926223200 11366019072 1984138656 19.497 100 38 74 1 2022301664 27376656 10786352
23:35:09 8049 8192000000 10946753136 11376357376 1995935408 19.591 100 59 118 0 2037598752 24176416 17486928
23:35:28 12369 8192000000 10943824080 11374714880 1992754016 19.566 100 55 110 2 2033799728 24861504 16184208
23:35:51 5888 8192000000 10958770080 11385462784 2000082848 19.623 100 63 125 2 2045383904 26107520 19193536
23:36:04 2840 8192000000 10958156064 11387363328 2001813904 19.637 100 66 129 0 2046798848 25619584 19365360
23:36:13 11783 8192000000 10942077824 11375472640 1994129296 19.576 100 51 102 0 2034328928 24325136 15874496
23:36:35 13260 8192000000 10968266752 11401158656 2005631936 19.667 100 51 101 0 2048521280 27118576 15770768
23:36:58 11327 8192000000 10922252704 11359793152 1967342912 19.364 98 41 82 2 2005773232 25886400 12543920
23:37:16 12076 8192000000 10943115776 11381661696 1993838768 19.574 100 41 82 0 2033126784 26753968 12534048
23:37:37 15616 8192000000 10964549536 11389833216 1997925536 19.606 100 66 132 0 2047883824 30941744 19016544
23:37:59 7469 8192000000 10950519216 11384958976 1981992832 19.480 99 62 124 3 2033113776 30516656 20604288
23:38:20 3178 8192000000 10971895488 11389825024 2000456336 19.626 100 72 144 2 2050425120 28392720 21576064
23:38:30 1835 8192000000 10975637856 11388329984 2000251296 19.625 100 80 157 0 2052775488 29524320 22999872
23:38:40 2895 8192000000 10956572608 11384557568 1992155680 19.561 100 66 128 0 2043598384 32639264 18803440
23:38:49 3543 8192000000 10972533024 11398324224 2003638112 19.651 100 67 134 1 2058286912 33917552 20731248
23:38:59 5622 8192000000 10974754528 11402387456 2006064448 19.671 100 72 144 1 2062446128 34802208 21579472
23:39:16 20806 8192000000 10974845968 11405705216 1990113744 19.545 99 71 141 1 2048867664 37421952 21331968
23:39:46 17356 8192000000 10970314720 11409149952 2005098656 19.663 100 51 100 2 2060222688 39461856 15662176
23:40:13 4823 8192000000 10980825696 11409940480 2002809184 19.645 100 62 124 0 2064066032 41785824 19471024
23:40:25 5478 8192000000 10983093872 11407515648 1972768240 19.407 98 67 134 0 2036786256 42019136 21998880
23:40:39 6050 8192000000 10994126864 11419844608 2011838896 19.716 100 75 148 1 2079713936 44645984 23229056
23:41:01 3456 8192000000 10991119232 11430694912 2010892704 19.709 100 61 122 0 2075721552 45957104 18871744
23:41:16 5625 8192000000 10991473856 11420831744 2015151728 19.742 100 64 128 0 2076259040 41290448 19816864
23:41:29 15111 8192000000 10989311264 11420393472 1997038800 19.599 99 65 130 1 2059465872 42407872 20019200
23:41:51 2862 8192000000 10988204528 11413180416 2007449408 19.681 100 83 164 4 2076673792 44428080 24796304
23:42:01 3552 8192000000 11003925568 11421245440 2007447520 19.681 100 68 135 0 2074353776 46191264 20714992
23:42:15 12998 8192000000 10979221024 11413164032 1997258480 19.601 100 66 129 0 2066986704 50105536 19622688
23:42:34 5082 8192000000 10985924560 11416092672 2000407680 19.626 100 68 136 0 2069778928 48218592 21152656
23:42:48 4102 8192000000 10975870928 11405709312 1981135712 19.474 99 64 128 1 2048748192 47800624 19811856
23:42:59 3327 8192000000 10976353632 11394809856 1964676160 19.343 98 71 141 2 2035559936 48335872 22547904
23:43:10 1789 8192000000 10994358992 11412275200 1995479440 19.587 100 86 170 3 2073205264 50794880 26930944
23:43:20 741 8192000000 10998129456 11409321984 1993775136 19.574 100 93 188 0 2074412928 52100720 28537072
23:43:28 1900 8192000000 11004146976 11420131328 2001193856 19.632 100 95 189 1 2080448400 51229328 28025216
23:43:37 4536 8192000000 10982666992 11407155200 1989423600 19.539 100 76 150 2 2063383824 50551360 23408864
23:43:50 1870 8192000000 10996685312 11416354816 1995552672 19.588 100 78 155 0 2071925072 52249248 24123152
23:44:00 6252 8192000000 10982421184 11401424896 1982017760 19.481 99 81 159 0 2060665104 54823776 23823568
23:44:13 3076 8192000000 10988422976 11415547904 1986163056 19.513 99 78 155 0 2065875744 55949088 23763600
23:44:23 3631 8192000000 10981100048 11401842688 1968780368 19.376 99 81 161 2 2051757792 57886096 25091328
23:44:34 4302 8192000000 10986496208 11406815232 1985151360 19.505 100 76 152 0 2067127360 58577328 23398672
23:44:45 984 8192000000 10992311760 11407241216 1982293248 19.483 100 93 184 2 2071693440 61231392 28168800
23:44:52 1104 8192000000 10983634288 11394002944 1975905536 19.432 100 92 183 1 2062505120 57931712 28667872
23:45:00 3492 8192000000 10983367840 11391303680 1971546656 19.398 100 86 171 1 2055297584 57796880 25954048
23:45:10 3788 8192000000 10982030528 11395231744 1975799728 19.431 100 85 166 3 2061007632 59094848 26113056
23:45:24 2488 8192000000 10984994272 11403411456 1981753584 19.479 100 83 164 0 2068048608 60652000 25643024
23:45:33 1862 8192000000 10986769072 11407515648 1984510896 19.500 100 80 158 1 2067057952 57344912 25202144
23:45:42 2779 8192000000 10998215904 11412795392 1989363040 19.539 100 90 180 1 2076772832 59462624 27947168
23:45:53 2530 8192000000 10993768384 11414507520 1990682096 19.549 100 80 160 0 2076238272 59822032 25734144
23:46:02 1972 8192000000 10989093616 11400740864 1979919056 19.464 100 91 182 0 2066683440 58390848 28373536
23:46:11 3524 8192000000 10957975760 11374923776 1954267296 19.260 99 72 144 0 2036791824 59737952 22786576
23:46:21 2850 8192000000 10967100992 11380080640 1950270800 19.229 99 84 168 2 2036902816 60158672 26473344
23:46:31 2443 8192000000 10960705152 11378954240 1958400304 19.293 100 71 144 2 2043080064 61171584 23508176
23:46:46 9980 8192000000 10966428192 11395276800 1967580448 19.366 100 51 102 1 2047789024 62640032 17568544
23:47:02 5415 8192000000 10976527136 11402375168 1972785808 19.408 100 54 108 2 2055456768 65178240 17492720
23:47:20 6387 8192000000 10955600912 11378765824 1937644272 19.128 98 67 133 1 2026495328 66582224 22268832
23:47:35 7084 8192000000 10942965952 11374952448 1932353056 19.086 99 48 93 0 2015345584 67073168 15919360
23:47:49 6370 8192000000 10935979152 11362877440 1921168400 18.996 99 50 100 1 2005100224 67489088 16442736
23:48:05 3627 8192000000 10966968624 11379458048 1953065344 19.251 100 84 169 0 2047136384 66910064 27160976
23:48:16 2309 8192000000 10960803168 11372822528 1951649888 19.240 100 79 158 0 2039092448 61742800 25699760
23:48:28 2458 8192000000 10951118192 11367342080 1939167008 19.140 99 80 160 1 2022552880 58400240 24985632
23:48:37 15629 8192000000 10928432480 11373871104 1947381168 19.206 100 41 82 1 2016873712 56154336 13338208
23:49:20 10463 8192000000 10924734272 11367890944 1932050528 19.083 99 39 77 0 2000513600 55815216 12647856
23:49:38 5255 8192000000 10937484352 11368255488 1933438992 19.094 99 46 93 1 2006782336 57718736 15624608
23:49:54 10254 8192000000 10945496624 11382435840 1959127456 19.299 100 39 78 1 2025814272 53973104 12713712
23:50:28 40324 8192000000 10941238112 11383353344 1920439632 18.990 98 29 58 3 1987927040 57568656 9918752
23:51:16 24445 8192000000 10944399104 11397566464 1942508048 19.167 100 24 49 0 2014443088 63986304 7948736
23:51:47 52165 8192000000 10914080848 11372699648 1912302640 18.925 99 22 44 1 1992108544 71261184 8544720
23:52:46 15535 8192000000 10930674384 11376611328 1903325488 18.853 99 29 58 1 1991674352 77416416 10932448
23:53:09 25217 8192000000 10887265776 11350880256 1888009136 18.730 99 20 40 0 1970034880 73964000 8061744
23:53:41 22871 8192000000 10901331024 11365101568 1913491040 18.935 100 16 32 1 1984692464 65150800 6050624
23:54:16 22615 8192000000 10849100304 11304574976 1901861488 18.841 99 18 36 3 1936280384 28370320 6048576
23:54:45 51260 8192000000 10868924624 11323199488 1929632560 19.064 100 20 41 1 1950342192 14796848 5912784
23:55:49 38806 8192000000 10856044512 11316965376 1887930432 18.729 98 19 38 1 1913548176 19845168 5772576
23:56:48 43644 8192000000 10867243008 11342512128 1915842336 18.954 99 24 48 4 1946613936 23381840 7389760
23:57:47 62626 8192000000 10854393072 11333959680 1901387808 18.837 99 6 12 0 1928465520 25131440 1946272
23:59:04 63951 8192000000 10889357616 11333636096 1933493920 19.095 99 36 73 2 1950206160 6806656 9905584
00:00:23 46843 8192000000 10883705952 11343663104 1942180352 19.164 99 22 45 0 1955563776 7864912 5518512
00:01:18 29009 8192000000 10898785232 11348492288 1946860464 19.201 99 31 62 1 1965148848 8978752 9309632
00:02:01 100971 8192000000 10902025120 11370692608 1956494928 19.278 100 9 18 0 1968374592 9850720 2028944
00:03:58 110056 8192000000 10876619600 11333480448 1867993488 18.568 95 11 22 0 1880940048 9849040 3097520
00:05:54 37954 8192000000 10891143168 11352653824 1960763440 19.312 100 14 29 1 1973680544 8838272 4078832
00:06:59 91918 8192000000 10888984256 11352772608 1922397328 19.006 98 4 8 0 1934774560 11171344 1205888
00:08:44 80229 8192000000 10894674192 11359813632 1934308448 19.101 98 23 46 1 1949922928 8581344 7033136
00:10:16 104966 8192000000 10913770496 11378774016 1934550640 19.103 98 6 12 0 1957612480 20748096 2313744
00:12:08 115178 8192000000 10917265152 11372068864 1962085696 19.323 99 25 50 0 1979907152 9978528 7842928
00:14:12 52603 8192000000 10899226064 11354116096 1957584752 19.287 99 38 74 1 1977709328 9560304 10564272
00:15:11 30033 8192000000 10932553856 11373064192 1963487232 19.334 99 36 72 0 1982381392 8343808 10550352
00:15:53 106916 8192000000 10910985552 11383476224 1949572768 19.223 98 23 46 3 1968001584 11802784 6626032
00:17:47 38009 8192000000 10913305424 11377332224 1965501168 19.350 99 15 30 1 1981211680 10762992 4947520
00:18:33 45143 8192000000 10934020784 11388731392 1964882272 19.345 99 23 46 2 1990789968 17434032 8473664
00:19:26 31155 8192000000 10935698416 11389108224 1991816656 19.558 100 35 71 0 2016522736 14177984 10528096
00:20:07 18899 8192000000 10945737024 11399053312 1993152256 19.569 100 44 84 0 2020218048 14448272 12617520
00:20:47 63700 8192000000 10908510080 11398021120 1982038944 19.481 99 33 66 0 2012205664 20797408 9369312
00:21:57 76896 8192000000 10887431264 11363799040 1926779440 19.041 97 10 21 0 1945935344 16236224 2919680
00:23:20 64848 8192000000 10901657152 11376680960 1936619216 19.120 98 13 26 1 1949761296 9519728 3622352
00:24:47 43276 8192000000 10897808768 11377582080 1959762272 19.304 99 8 16 0 1972811520 10873200 2176048
00:25:47 40303 8192000000 10893661584 11371130880 1939625616 19.144 98 18 36 0 1963594720 18651456 5317648
00:26:43 50556 8192000000 10898853632 11386437632 1974970800 19.425 100 6 12 0 1990724320 14029472 1724048
00:27:42 38074 8192000000 10881375440 11368984576 1911290048 18.917 97 5 10 0 1924156896 11737488 1129360
00:28:26 33180 8192000000 10885259088 11360055296 1921742096 19.001 98 12 23 0 1933274912 8562448 2970368
00:29:09 55404 8192000000 10877178208 11351310336 1861834144 18.518 94 23 46 0 1881908112 13529328 6544640
00:30:10 46974 8192000000 10871375328 11337850880 1871489680 18.596 96 20 40 1 1890224944 13194288 5540976
00:31:25 74385 8192000000 10893381568 11345424384 1907877472 18.890 98 19 38 2 1923259024 9683824 5697728
00:32:48 19976 8192000000 10883271952 11335819264 1936261760 19.117 99 41 82 2 1955730752 8395200 11073792
00:33:54 62559 8192000000 10863613104 11321077760 1844588832 18.378 95 22 43 3 1866510080 15691472 6229776
00:35:05 44859 8192000000 10899347616 11363364864 1941764656 19.161 100 28 56 1 1975480608 25160384 8555568
00:36:07 104690 8192000000 10877490912 11345809408 1917606224 18.968 98 9 19 0 1933557968 13116512 2835232
00:37:58 50466 8192000000 10862339072 11305033728 1788575888 17.920 92 14 28 0 1800376576 7813264 3987424
00:38:58 22953 8192000000 10864442064 11299692544 1875942784 18.632 98 49 98 0 1902122128 12165840 14013504
00:39:34 31018 8192000000 10837938288 11291906048 1883719504 18.695 98 26 52 0 1900653664 9846416 7087744
00:40:15 26731 8192000000 10853962416 11312848896 1915644496 18.952 100 24 47 0 1930388704 8471136 6273072
00:40:48 59260 8192000000 10836584512 11299590144 1830946608 18.267 95 13 26 3 1844650816 10484880 3219328
00:41:58 39597 8192000000 10862801056 11330375680 1921696448 19.000 100 33 66 1 1944732464 13345824 9690192
00:42:44 27172 8192000000 10869632928 11312631808 1920357312 18.990 99 35 70 0 1939079936 8332128 10390496
00:43:18 108243 8192000000 10838730784 11295350784 1861931968 18.519 96 28 56 1 1878527328 8718560 7876800
00:45:13 53773 8192000000 10837637120 11318841344 1920663648 18.992 100 23 46 3 1939081744 11894336 6523760
00:46:27 16616 8192000000 10843065024 11314311168 1887617488 18.727 98 13 26 2 1901294032 9965120 3711424
00:46:50 34731 8192000000 10875445392 11331248128 1920845792 18.994 99 42 84 1 1940365248 8001152 11518304
00:47:49 54508 8192000000 10852672912 11327426560 1906342208 18.877 98 13 26 3 1918401008 8016560 4042240
00:48:50 59830 8192000000 10846810112 11316633600 1881381312 18.676 97 15 30 1 1895090496 9365136 4344048
00:49:56 50725 8192000000 10842204960 11325169664 1905666896 18.872 99 8 16 0 1917131936 9072336 2392704
00:50:56 50095 8192000000 10875222896 11347042304 1933087232 19.092 100 12 23 2 1942892976 6645328 3160416
00:51:57 67060 8192000000 10872148832 11349852160 1953785504 19.257 100 15 30 1 1967803216 9614544 4403168
00:53:23 76682 8192000000 10861509376 11349389312 1937639632 19.128 99 12 24 0 1953732256 12477216 3615408
00:54:46 39228 8192000000 10871565664 11347144704 1931963392 19.083 99 4 8 0 1943147504 10200240 983872
00:55:33 27497 8192000000 10908024960 11366170624 1964599808 19.343 100 32 64 1 1979431968 6396272 8435888
00:56:08 26272 8192000000 10887532800 11360243712 1951242576 19.236 99 47 92 2 1975794192 11335744 13215872
00:56:56 77215 8192000000 10917647968 11385815040 1976803264 19.439 100 15 30 0 1994281648 13497632 3980752
00:58:20 44573 8192000000 10906522720 11386892288 1950738320 19.232 98 9 18 1 1963306688 10260640 2307728
00:59:38 79253 8192000000 10898009936 11380899840 1928323856 19.053 97 16 32 0 1941518416 8881168 4313392
01:01:05 29759 8192000000 10928604352 11382554624 1947219680 19.204 98 22 44 1 1960706320 7200768 6285872
01:01:41 24700 8192000000 10936536976 11388096512 1983986160 19.496 100 43 85 2 2004622000 8858560 11777280
01:02:13 42377 8192000000 10916365072 11391504384 1948627632 19.216 98 38 76 1 1971291968 12127456 10536880
01:03:02 83674 8192000000 10910448208 11389095936 1963375904 19.333 99 16 32 1 1984330016 16255472 4698640
01:04:34 104822 8192000000 10927743392 11394715648 1924348304 19.022 97 14 28 0 1938656176 10496528 3811344
01:06:29 39168 8192000000 10924401648 11390607360 1966056736 19.354 99 32 64 1 1988049952 13009104 8984112
01:07:17 107369 8192000000 10919100352 11407785984 1945932400 19.194 98 12 24 0 1965537232 16244512 3360320
01:09:11 70891 8192000000 10936450816 11380334592 1934636112 19.104 97 25 48 0 1960823312 19316560 6870640
01:10:32 121167 8192000000 10866208848 11337154560 1870091984 18.585 95 20 40 1 1887152704 11493680 5567040
01:12:39 32851 8192000000 10892938496 11372052480 1958578352 19.295 100 24 48 1 1981979168 16757232 6643584
01:13:25 35907 8192000000 10888966352 11352743936 1918975600 18.979 98 25 50 1 1937703760 11591024 7137136
01:14:18 71685 8192000000 10850866560 11328782336 1858474000 18.491 95 16 32 0 1876049648 13216304 4359344
01:15:36 55311 8192000000 10828514944 11305607168 1840276320 18.343 96 12 24 1 1861687648 17114416 4296912
01:16:48 82249 8192000000 10854364016 11328516096 1887967648 18.729 98 13 27 0 1901768192 9718912 4081632
01:20:08 46016 8192000000 10876316368 11340451840 1898738304 18.816 97 29 58 0 1914714704 7773456 8202944
01:21:00 13901 8192000000 10887524192 11340517376 1931511968 19.079 99 49 92 4 1953635760 8982720 13141072
01:21:20 44622 8192000000 10852604304 11317616640 1859370896 18.498 95 38 76 3 1881491344 11417984 10702464
01:22:11 63319 8192000000 10859988144 11347316736 1920935104 18.994 99 11 22 0 1934605360 10334944 3335312
01:23:30 21928 8192000000 10881832672 11323740160 1889079472 18.738 98 36 68 1 1905202480 5813808 10309200
01:24:00 23158 8192000000 10878384448 11334443008 1910509200 18.911 99 39 77 1 1935055248 13970944 10575104
01:25:20 68149 8192000000 10857780448 11317833728 1844773184 18.380 95 35 70 3 1868726432 14116656 9836592
01:26:44 52839 8192000000 9664124320 10000494592 776606368 8.659 41 7 11 1 785793520 7637328 1549824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-04-2021 01:28:36 to 06-04-2021 01:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 73 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-04-2021 01:29:08 to 06-04-2021 01:29:10.

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          246130
MON$OLDEST_ACTIVE               247163
MON$OLDEST_SNAPSHOT             247163
MON$NEXT_TRANSACTION            247163
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                       2046944
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
:109: 
:110: mscs-test-161.budzdorov.ru    Tue Apr  6 01:27:43 2021
:111:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:112: 
--- end of diff output ---

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

06.04.21 01:29:11. 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
2021-04-06 01:29:13 No severe PSQL-related problems occured
06.04.21 01:29:15. End of report.