Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.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 17596396 kB
MemAvailable 31446848 kB
Buffers 0 kB
Cached 14059360 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-01 01:27:26
DTS_END                         2021-04-01 01:27:26.4070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60388
TRN_ID                          235872
ATT_ID                          642
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: 9002.46 22805 1080295
customer order: creation 169.67 374 20360
customer order: refuse 14.17 390 1700
order to supplier: creation 44.94 1236 5393
order to supplier: removal 3.42 96791 410
invoice (draft): creation 45.54 3060 5465
invoice (draft): removal 50.58 732 6069
invoice accept: apply 40.67 18732 4880
invoice accept: cancel 45.83 857 5499
customer reserve: creation 3747.01 186 449641
customer reserve: removal 4544.53 57 545344
realization accept: apply 83.68 183 10041
realization accept: cancel 86.62 110 10394
payment from customer: creation 57.51 104 6901
payment from customer: removal 5.63 98 675
payment to supplier: creation 47.20 129 5664
payment to supplier: removal 3.29 94 395
service: total inventory turnovers 4.77 906 572
service: total monetary turnovers 6.58 20 790
service: aggregate perf. data 0.82 19879 98
service: refresh index statistics 0.03 312154 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2505
TEST_TIME 2 4526
TEST_TIME 3 4072
TEST_TIME 4 4612
TEST_TIME 5 4295
TEST_TIME 6 3946
TEST_TIME 7 4752
TEST_TIME 8 4988
TEST_TIME 9 5039
TEST_TIME 10 5160
TEST_TIME 11 5386
TEST_TIME 12 5473
TEST_TIME 13 6166
TEST_TIME 14 6196
TEST_TIME 15 6764
TEST_TIME 16 7269
TEST_TIME 17 7911
TEST_TIME 18 8873
TEST_TIME 19 9374
TEST_TIME 20 9219
TEST_TIME 21 9473
TEST_TIME 22 9521
TEST_TIME 23 9830
TEST_TIME 24 9853
TEST_TIME 25 10419
TEST_TIME 26 10221
TEST_TIME 27 10044
TEST_TIME 28 10420
TEST_TIME 29 10176
TEST_TIME 30 10275
TEST_TIME 31 10122
TEST_TIME 32 9938
TEST_TIME 33 9905
TEST_TIME 34 9738
TEST_TIME 35 9501
TEST_TIME 36 9593
TEST_TIME 37 9506
TEST_TIME 38 9413
TEST_TIME 39 9286
TEST_TIME 40 9248
TEST_TIME 41 9152
TEST_TIME 42 9023
TEST_TIME 43 9213
TEST_TIME 44 9203
TEST_TIME 45 9077
TEST_TIME 46 9235
TEST_TIME 47 9211
TEST_TIME 48 9280
TEST_TIME 49 9233
TEST_TIME 50 9261
TEST_TIME 51 9219
TEST_TIME 52 9322
TEST_TIME 53 9253
TEST_TIME 54 9304
TEST_TIME 55 9391
TEST_TIME 56 9414
TEST_TIME 57 9478
TEST_TIME 58 9416
TEST_TIME 59 9382
TEST_TIME 60 9279
TEST_TIME 61 9257
TEST_TIME 62 9263
TEST_TIME 63 9192
TEST_TIME 64 9172
TEST_TIME 65 9160
TEST_TIME 66 9110
TEST_TIME 67 9062
TEST_TIME 68 9115
TEST_TIME 69 9182
TEST_TIME 70 9201
TEST_TIME 71 9135
TEST_TIME 72 9302
TEST_TIME 73 9324
TEST_TIME 74 9346
TEST_TIME 75 9338
TEST_TIME 76 9331
TEST_TIME 77 9406
TEST_TIME 78 9354
TEST_TIME 79 9386
TEST_TIME 80 9386
TEST_TIME 81 9289
TEST_TIME 82 9256
TEST_TIME 83 9210
TEST_TIME 84 9182
TEST_TIME 85 9188
TEST_TIME 86 9139
TEST_TIME 87 9107
TEST_TIME 88 9052
TEST_TIME 89 8990
TEST_TIME 90 9043
TEST_TIME 91 9068
TEST_TIME 92 9088
TEST_TIME 93 9104
TEST_TIME 94 9098
TEST_TIME 95 9096
TEST_TIME 96 9076
TEST_TIME 97 9123
TEST_TIME 98 9157
TEST_TIME 99 9135
TEST_TIME 100 9101
TEST_TIME 101 9191
TEST_TIME 102 9212
TEST_TIME 103 9210
TEST_TIME 104 9173
TEST_TIME 105 9108
TEST_TIME 106 9063
TEST_TIME 107 9039
TEST_TIME 108 9001
TEST_TIME 109 9034
TEST_TIME 110 9005
TEST_TIME 111 9035
TEST_TIME 112 9023
TEST_TIME 113 9008
TEST_TIME 114 8974
TEST_TIME 115 8972
TEST_TIME 116 9015
TEST_TIME 117 9022
TEST_TIME 118 9040
TEST_TIME 119 9058
TEST_TIME 120 9007

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-04-2021 01:28:26 to 01-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 1497847 1497847 0 0.00 0 19013 6 0 0
doc_list_biud 1497845 1497845 0 0.00 0 48345 27 0 0
sp_add_invoice_to_stock 4998 4880 118 2.36 45 211097 18732 0 118
sp_cancel_adding_invoice 5499 5499 0 0.00 5 85341 857 0 0
sp_cancel_client_order 1700 1700 0 0.00 4 11359 390 0 0
sp_cancel_customer_reserve 545344 545344 0 0.00 1 48347 58 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 6270 98 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 2 9003 94 0 0
sp_cancel_supplier_invoice 6076 6069 7 0.11 2 16996 733 0 7
sp_cancel_supplier_order 410 410 0 0.00 9 1040471 96791 0 0
sp_cancel_write_off 10394 10394 0 0.00 1 12961 110 0 0
sp_client_order 20360 20360 0 0.00 3 14751 375 0 0
sp_customer_reserve 449641 449641 0 0.00 0 43867 187 0 0
sp_fill_shopping_cart 31207 31207 0 0.00 1 16546 41 0 0
sp_fill_shopping_cart_clo_res 449630 449630 0 0.00 0 11650 14 0 0
sp_get_clo_for_invoice 4865 4865 0 0.00 0 25141 342 0 0
sp_kill_cost_storno 16963 16963 0 0.00 0 12404 59 0 0
sp_kill_qstorno_ret_qs2qd 1107561 1107561 0 0.00 0 48342 31 0 0
sp_kill_qty_storno 584316 584316 0 0.00 0 48344 67 0 0
sp_lock_selected_doc 20587 20587 0 0.00 0 8996 6 0 0
sp_make_cost_storno 27467 27467 0 0.00 0 18996 54 0 0
sp_multiply_rows_for_pdistr 27465 27465 0 0.00 0 6331 26 0 0
sp_multiply_rows_for_qdistr 20360 20360 0 0.00 0 14414 180 0 0
sp_pay_from_customer 6901 6901 0 0.00 4 15520 105 0 0
sp_pay_to_supplier 5664 5664 0 0.00 4 11320 129 0 0
sp_payment_common 12565 12565 0 0.00 1 10552 31 0 0
sp_qd_handle_on_cancel_clo 1700 1700 0 0.00 0 11349 359 0 0
sp_qd_handle_on_invoice_upd_sts 10358 10358 0 0.00 0 42743 335 0 0
sp_qd_handle_on_reserve_upd_sts 10041 10041 0 0.00 0 20331 67 0 0
sp_reserve_write_off 10041 10041 0 0.00 6 20370 183 0 0
sp_supplier_invoice 5465 5465 0 0.00 6 70496 3061 0 0
sp_supplier_order 5393 5393 0 0.00 5 83996 1236 0 0
srv_aggregate_perf_data 99 98 1 1.01 3199 215100 19879 0 1
srv_fill_mon_cache_memory 155 155 0 0.00 984 183615 35380 0 0
srv_find_qd_qs_mism 1034269 1034269 0 0.00 0 17698 6 0 0
srv_make_invnt_saldo 572 572 0 0.00 31 37021 906 0 0
srv_make_money_saldo 790 790 0 0.00 1 454 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 156264 529460 312154 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 4880 4880 0 0.00 0 14305 186 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 6081 111 0 0
t$perf-norm:sp_cancel_client_order 1700 1700 0 0.00 0 1435 10 0 0
t$perf-norm:sp_cancel_customer_reserve 724 724 0 0.00 0 4042 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 1996 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 313 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 378 378 0 0.00 0 3357 26 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 24416 1611 0 0
t$perf-norm:sp_cancel_write_off 999 999 0 0.00 0 5932 14 0 0
t$perf-norm:sp_client_order 20360 20360 0 0.00 0 16662 20 0 0
t$perf-norm:sp_customer_reserve 956 956 0 0.00 0 2132 7 0 0
t$perf-norm:sp_pay_from_customer 6901 6901 0 0.00 0 7375 12 0 0
t$perf-norm:sp_pay_to_supplier 5664 5664 0 0.00 0 7434 11 0 0
t$perf-norm:sp_reserve_write_off 10041 10041 0 0.00 0 12507 15 0 0
t$perf-norm:sp_supplier_invoice 5465 5465 0 0.00 0 5206 18 0 0
t$perf-norm:sp_supplier_order 5393 5393 0 0.00 0 6269 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 301 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 61 1 0 0
t$perf-norm:srv_make_invnt_saldo 572 572 0 0.00 0 875 18 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 15606 37 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 9954 9718 236 2.37 0 4349 16 0 236
v_all_customers 37460 37460 0 0.00 0 36 1 0 0
v_all_suppliers 29938 29938 0 0.00 0 44 1 0 0
v_all_wares 40718 40718 0 0.00 0 62 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 173 5 0 0
v_cancel_client_order 3400 3400 0 0.00 0 4560 7 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 5931 11 0 0
v_cancel_customer_reserve 1448 1448 0 0.00 0 1124 4 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 2372 7 0 0
v_cancel_supplier_invoice 770 756 14 1.81 0 170 11 0 14
v_cancel_supplier_order 820 820 0 0.00 0 2935 7 0 0
v_cancel_write_off 1998 1998 0 0.00 0 2462 13 0 0
v_max_id_clo_ord 5392 5392 0 0.00 0 418 1 0 0
v_max_id_clo_res 956 956 0 0.00 0 2494 18 0 0
v_max_id_ord_sup 5455 5455 0 0.00 0 5147 5 0 0
v_max_non_paid_invoice 1542 1542 0 0.00 0 148 2 0 0
v_max_non_paid_realizn 3540 3540 0 0.00 0 3871 5 0 0
v_min_id_clo_ord 5392 5392 0 0.00 0 13877 11 0 0
v_min_id_clo_res 956 956 0 0.00 0 6658 10 0 0
v_min_id_ord_sup 5455 5455 0 0.00 0 14469 11 0 0
v_min_non_paid_invoice 5664 5664 0 0.00 0 10548 24 0 0
v_min_non_paid_realizn 6901 6901 0 0.00 0 6397 18 0 0
v_our_firm 9980 9980 0 0.00 0 18 1 0 0
v_reserve_write_off 20082 20082 0 0.00 0 5144 6 0 0
x_lock_depdocs_on_canc_invoice 11190 11190 0 0.00 0 32506 115 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 7888 309 0 0
x_make_qstorno_1000_1200 5393 5393 0 0.00 1 83989 1156 0 0
x_make_qstorno_1200_2000 5465 5465 0 0.00 3 70488 2909 0 0
x_make_qstorno_2100_3300 449641 449641 0 0.00 0 43863 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-04-2021 01:28:30 to 01-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 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:36 12068 8192000000 10223240272 10524430336 873054592 9.630 68 56 114 0 894277040 2408432 18814016
22:57:58 38116 8192000000 10354215600 10672320512 1394186352 14.543 100 87 173 1 1431361888 9147840 28027696
22:58:46 24655 8192000000 10390182208 10713333760 1441074432 14.959 100 89 178 0 1477474672 6731408 29668832
22:59:21 26453 8192000000 10425279904 10756755456 1475947552 15.266 100 91 182 0 1512896064 7730288 29218224
23:00:16 17944 8192000000 10450556336 10783961088 1504825056 15.518 100 85 170 1 1540907424 9074736 27007632
23:00:45 26522 8192000000 10473078096 10814816256 1529615056 15.734 100 84 168 0 1565556720 9570832 26370832
23:01:23 24207 8192000000 10512028464 10855378944 1561196736 16.007 100 85 169 2 1597271296 10193344 25881216
23:01:55 15918 8192000000 10520911088 10869817344 1580831504 16.175 100 79 158 2 1615952512 10922832 24198176
23:02:22 19068 8192000000 10558541936 10911604736 1609880752 16.424 100 87 172 2 1647439504 11497040 26061712
23:02:54 13234 8192000000 10578008224 10940121088 1637992848 16.663 100 90 180 1 1677431792 12426144 27012800
23:03:21 10750 8192000000 10599712176 10959888384 1656265760 16.817 100 84 168 3 1693064832 12406864 24392208
23:03:39 13127 8192000000 10608049616 10970988544 1663666784 16.880 100 82 165 0 1701187344 13265056 24255504
23:04:00 11435 8192000000 10607967408 10978000896 1672362496 16.953 100 79 158 1 1708451760 13264976 22824288
23:04:19 8614 8192000000 10624068736 10993745920 1688483936 17.089 100 81 159 3 1724350832 12798560 23068336
23:04:37 11048 8192000000 10636049904 11008061440 1700353536 17.188 100 76 152 2 1735675168 13220880 22100752
23:04:57 7363 8192000000 10659338128 11030278144 1716584096 17.324 100 81 162 1 1753522512 13924976 23013440
23:05:12 7664 8192000000 10672038640 11044315136 1731110336 17.445 100 78 154 2 1766694320 13173376 22410608
23:05:31 4699 8192000000 10683630864 11065597952 1748220320 17.587 100 77 154 0 1782817200 12854192 21742688
23:05:44 4386 8192000000 10703543264 11076022272 1761735680 17.699 100 88 174 1 1799409616 13455440 24218496
23:05:55 4272 8192000000 10710291520 11089260544 1766607792 17.739 100 79 158 1 1802762816 14079808 22075216
23:06:06 3702 8192000000 10714401296 11095724032 1780395856 17.853 100 83 166 1 1817490592 14303728 22791008
23:06:17 3131 8192000000 10716865072 11095728128 1779854160 17.848 100 77 155 1 1813646560 11984336 21808064
23:06:28 3019 8192000000 10728173952 11108892672 1783719200 17.880 100 82 164 0 1818762864 12992368 22051296
23:06:38 10113 8192000000 10719527152 11106267136 1792882128 17.955 100 78 154 2 1826556960 12477520 21197312
23:06:57 3165 8192000000 10751944064 11134648320 1815665136 18.142 100 89 176 2 1852137488 12191616 24280736
23:07:08 2367 8192000000 10763909072 11145265152 1821353312 18.189 100 89 180 1 1859993856 13195488 25445056
23:07:16 3133 8192000000 10773556112 11157336064 1830171536 18.261 100 86 172 2 1867376080 13005840 24198704
23:07:26 2979 8192000000 10784598256 11165683712 1838756784 18.331 100 94 184 2 1878264608 13499520 26008304
23:07:36 1982 8192000000 10783722272 11168256000 1844575792 18.378 100 91 182 1 1884987280 14588208 25823280
23:07:44 943 8192000000 10795394480 11178770432 1848469760 18.410 100 94 189 2 1889797136 14453648 26873728
23:07:52 1495 8192000000 10793942736 11182305280 1850236480 18.424 100 87 173 0 1889443408 14177280 25029648
23:08:00 1257 8192000000 10804910576 11187650560 1854524432 18.459 100 90 181 1 1892302352 12065840 25712080
23:08:07 2079 8192000000 10794684528 11183017984 1856171696 18.472 100 86 168 3 1892527024 11534352 24820976
23:08:16 1592 8192000000 10811039360 11195621376 1862036144 18.520 100 93 186 2 1902212816 13423376 26753296
23:08:24 1342 8192000000 10815959632 11202539520 1870550160 18.589 100 91 180 2 1909780672 13113456 26117056
23:08:31 975 8192000000 10818309088 11204521984 1872950704 18.608 100 95 190 0 1913189008 13386512 26851792
23:08:39 1468 8192000000 10817886544 11204673536 1872358864 18.603 100 95 191 0 1911818576 12570336 26889376
23:08:46 1574 8192000000 10820021552 11207987200 1874934960 18.624 100 92 184 4 1914270000 12990864 26344176
23:08:54 1422 8192000000 10815021888 11206127616 1877175152 18.642 100 89 174 4 1913557184 12539280 23842752
23:09:02 1498 8192000000 10825064880 11212701696 1875215456 18.626 100 82 162 1 1911426352 12527488 23683408
23:09:10 31893 8192000000 10814155392 11208433664 1871622128 18.597 100 63 127 0 1900839664 10235424 18982112
23:09:48 3211 8192000000 10814789952 11214807040 1880514400 18.669 100 87 178 2 1916370752 10598272 25258080
23:10:01 7805 8192000000 10790186544 11208364032 1872351968 18.603 100 40 79 3 1891661888 8893760 10416160
23:10:15 8212 8192000000 10782329088 11210371072 1871278736 18.595 100 23 46 2 1884558640 6859312 6420592
23:10:32 7639 8192000000 10775925712 11207524352 1874972192 18.624 100 22 44 0 1887597456 6392720 6232544
23:10:47 7410 8192000000 10775552432 11211452416 1875952848 18.632 100 25 50 2 1889969744 6941984 7074912
23:11:01 9768 8192000000 10800834160 11223805952 1881942816 18.681 100 27 55 2 1896939504 6965712 8030976
23:11:17 6463 8192000000 10781021696 11218386944 1882580336 18.686 100 26 52 1 1895499776 5955232 6964208
23:11:32 16719 8192000000 10803944272 11221643264 1884702112 18.703 100 20 40 1 1895111600 5114912 5294576
23:11:55 74587 8192000000 10802318080 11235823616 1891106336 18.755 100 30 59 1 1905646032 6310704 8228992
23:13:16 5949 8192000000 10802921872 11237670912 1892899024 18.769 100 26 51 0 1906341408 6024960 7417424
23:13:29 8475 8192000000 10810502512 11244560384 1893730448 18.776 100 22 44 2 1906523536 6984960 5808128
23:13:45 6111 8192000000 10818818208 11245518848 1896191888 18.796 100 35 72 1 1914017248 7556576 10268784
23:13:59 6665 8192000000 10809065216 11241316352 1894416128 18.781 100 25 49 0 1906461664 5104464 6941072
23:14:13 10006 8192000000 10811849328 11251654656 1900726816 18.832 100 21 43 1 1913280160 6552240 6001104
23:14:30 11002 8192000000 10811094784 11250483200 1903201280 18.852 100 14 29 1 1912552304 5511600 3839424
23:14:47 9272 8192000000 10808626400 11246329856 1888678720 18.735 99 24 46 0 1900260624 4866336 6715568
23:15:03 6721 8192000000 10814543136 11253796864 1907132656 18.884 100 22 45 3 1919120032 5380176 6607200
23:15:16 10510 8192000000 10820999120 11260788736 1904047104 18.859 100 18 36 1 1914916768 5961376 4908288
23:15:33 7386 8192000000 10820340768 11258671104 1911737648 18.921 100 18 35 2 1922052880 5693088 4622144
23:15:49 13098 8192000000 10822948240 11262349312 1913078592 18.931 100 14 28 2 1922762512 5840288 3843632
23:16:10 13171 8192000000 10820175328 11250724864 1873696848 18.614 98 22 43 1 1885599600 5598688 6304064
23:16:30 40536 8192000000 10807834368 11239432192 1863923264 18.535 98 23 46 0 1875427344 5355968 6148112
23:17:40 18583 8192000000 10791344528 11230105600 1870396752 18.587 99 23 44 1 1883276096 6050576 6828768
23:18:07 6073 8192000000 10808046832 11234361344 1874082336 18.617 99 35 70 0 1890675888 7231440 9362112
23:18:21 6295 8192000000 10792803648 11222855680 1863950272 18.535 99 24 48 3 1878382080 7891408 6540400
23:18:34 4885 8192000000 10772218944 11204317184 1841727008 18.355 98 31 61 1 1856851168 6152224 8971936
23:18:45 8094 8192000000 10694327792 11114659840 1676340512 16.987 90 27 52 1 1688994736 4999168 7655056
23:19:00 6569 8192000000 10752778160 11173761024 1800288144 18.016 98 29 58 2 1818248000 9532976 8426880
23:19:17 10526 8192000000 10729088784 11147001856 1751390688 17.613 96 31 62 1 1775043568 15047680 8605200
23:19:39 8418 8192000000 10724139824 11125465088 1764668640 17.723 97 28 56 4 1777978240 5057248 8252352
23:19:53 6716 8192000000 10752011536 11170865152 1825820448 18.225 100 18 35 1 1835977024 5246704 4909872
23:20:07 6320 8192000000 10733038112 11163131904 1795411680 17.976 98 19 38 1 1806481840 5844784 5225376
23:20:22 14100 8192000000 10714173344 11130249216 1718650992 17.341 94 23 46 1 1730968112 5384240 6932880
23:20:43 39876 8192000000 10718629056 11129946112 1755837056 17.650 97 29 56 0 1769280784 5077664 8366064
23:21:40 20286 8192000000 10676253136 11088482304 1654948496 16.806 92 23 46 0 1666814064 5248032 6617536
23:22:07 8858 8192000000 10683415760 11089620992 1684312000 17.054 94 29 57 1 1697770368 5397888 8060480
23:22:25 6018 8192000000 10702740496 11110711296 1726642032 17.408 96 23 46 1 1738495104 5279376 6573696
23:22:40 6806 8192000000 10694128320 11115597824 1774346544 17.803 99 28 56 1 1789432128 7132960 7952624
23:22:54 7523 8192000000 10717949376 11139264512 1804837584 18.054 100 23 46 0 1817885632 6789968 6258080
23:23:10 7746 8192000000 10710488688 11129118720 1774796560 17.807 98 24 48 3 1787327728 5443328 7087840
23:23:26 6598 8192000000 10733321216 11153141760 1817186192 18.155 100 24 48 1 1830673280 6486912 7000176
23:23:42 11788 8192000000 10738856512 11167895552 1827087520 18.236 100 16 32 0 1837547824 5339168 5121136
23:24:05 9031 8192000000 10753607776 11169787904 1831183312 18.269 100 27 55 0 1844284976 4826992 8274672
23:24:20 10290 8192000000 10758988464 11178536960 1842767472 18.363 100 36 72 2 1859201328 5441184 10992672
23:24:38 9562 8192000000 10759762480 11184939008 1847977360 18.406 100 19 38 1 1858737104 5254112 5505632
23:24:59 17606 8192000000 10763929440 11197530112 1853142672 18.448 100 10 20 0 1865647136 10045488 2458976
23:25:24 77781 8192000000 10780405696 11202969600 1860055520 18.504 100 32 59 3 1874551632 5682336 8813776
23:26:49 4973 8192000000 10785622864 11212656640 1865988528 18.552 100 16 32 1 1876300544 5765264 4546752
23:27:00 8468 8192000000 10802579024 11222917120 1877247744 18.643 100 25 51 1 1889357712 5655520 6454448
23:27:15 7321 8192000000 10797545152 11228430336 1890714080 18.752 100 20 39 2 1900600752 4923088 4963584
23:27:31 9647 8192000000 10839845248 11255025664 1907144960 18.884 100 55 107 2 1929666848 6855168 15666720
23:27:57 5500 8192000000 10842915472 11261362176 1914431344 18.942 100 51 102 1 1937400656 8946432 14022880
23:28:10 49064 8192000000 10855788032 11277783040 1922676208 19.008 100 67 133 1 1951996288 11235040 18085040
23:29:17 13451 8192000000 10870317712 11289853952 1928487264 19.055 100 56 112 0 1963006064 19345568 15173232
23:29:38 9051 8192000000 10869920160 11296768000 1935878752 19.114 100 50 99 1 1963552896 13580448 14093696
23:29:56 19403 8192000000 10879345712 11303723008 1942751152 19.169 100 54 108 1 1973055456 14742048 15562256
23:30:36 38656 8192000000 10888822656 11319726080 1954020672 19.258 100 42 84 0 1982120896 15360544 12739680
23:31:32 16090 8192000000 10891638880 11329392640 1956874192 19.281 100 35 70 0 1988220976 20785232 10561552
23:31:56 21315 8192000000 10897220432 11325091840 1959917920 19.305 100 36 72 0 1986489664 15365440 11206304
23:32:26 51955 8192000000 10905599616 11343802368 1970190368 19.387 100 38 76 1 2001558416 19434720 11933328
23:33:34 26074 8192000000 10913301632 11347906560 1972059552 19.402 100 38 75 2 2005514720 21675056 11780112
23:34:26 12390 8192000000 10891970368 11336765440 1955434304 19.270 99 32 64 2 1989842480 23941408 10466768
23:34:48 22132 8192000000 10909858976 11353186304 1972387920 19.404 100 25 50 1 1998483840 18427856 7668064
23:35:21 11374 8192000000 10918484512 11357982720 1981363264 19.475 100 43 87 2 2015124128 20479008 13281856
23:35:40 11365 8192000000 10927239312 11363487744 1982163504 19.482 100 32 64 0 2013721568 20939520 10618544
23:36:01 9503 8192000000 10927771088 11359674368 1981666080 19.478 100 42 84 1 2015243808 20560768 13016960
23:36:21 6029 8192000000 10932176208 11368546304 1990230112 19.546 100 47 94 3 2025805168 20973760 14601296
23:36:34 5144 8192000000 10957344912 11382005760 2001507312 19.635 100 73 145 1 2047668032 22720784 23439936
23:36:51 2336 8192000000 10973168896 11390783488 2008282944 19.688 100 77 155 2 2055342656 24034672 23025040
23:36:59 3368 8192000000 10964078144 11389149184 2004934160 19.662 100 63 126 1 2049616336 24875536 19806640
23:37:17 4656 8192000000 10964234256 11390111744 2004797712 19.661 100 62 124 2 2048742704 24817568 19127424
23:37:31 6039 8192000000 10963830256 11397652480 2009276304 19.696 100 67 130 0 2055343312 25826272 20240736
23:37:50 9471 8192000000 10962417808 11396202496 2003225936 19.648 100 51 100 0 2045146704 26556176 15364592
23:38:10 12511 8192000000 10959819584 11393236992 1988539392 19.532 99 54 107 1 2034228320 28338672 17350256
23:38:32 8024 8192000000 10946054640 11381850112 1996117472 19.592 100 48 96 1 2038988128 27365232 15505424
23:38:48 10574 8192000000 10966227520 11397984256 2009106816 19.694 100 56 112 0 2054975152 28387920 17480416
23:39:06 3227 8192000000 10980901696 11407278080 2014379680 19.736 100 69 135 0 2064612576 29901216 20331680
23:39:16 4207 8192000000 10973663616 11401285632 2008867840 19.693 100 77 152 1 2063441776 31414400 23159536
23:39:28 4586 8192000000 10985734816 11411660800 2013570432 19.730 100 73 143 3 2067878912 32789632 21518848
23:39:41 2017 8192000000 10996258688 11417939968 2022493808 19.800 100 83 167 2 2082731568 34793760 25444000
23:39:50 7162 8192000000 10993939344 11421446144 2023757472 19.810 100 69 138 2 2079873760 35547120 20569168
23:40:05 5283 8192000000 10976145856 11410042880 2000106608 19.624 99 67 134 1 2055448768 34706352 20635808
23:40:17 1967 8192000000 10983759264 11407761408 2009901776 19.701 100 83 165 1 2068251424 32152896 26196752
23:40:26 6760 8192000000 10973108352 11400445952 2006287872 19.672 100 76 152 5 2058892384 29202464 23402048
23:40:43 1363 8192000000 10990667152 11403771904 2011682112 19.715 100 91 184 0 2069267504 29897328 27688064
23:40:54 2424 8192000000 10952509552 11377459200 1970739072 19.391 98 76 153 2 2024251232 29787472 23724688
23:41:03 1571 8192000000 10990800416 11404165120 2008846928 19.692 100 87 173 0 2067718608 31740928 27130752
23:41:13 4336 8192000000 10990794688 11410690048 2012921136 19.725 100 74 148 2 2067382032 31511584 22949312
23:41:26 983 8192000000 10990312864 11409199104 2009097600 19.694 100 85 169 2 2074285840 37467216 27721024
23:41:35 4922 8192000000 10974981024 11404124160 1991363488 19.555 99 70 139 0 2052519248 38937632 22218128
23:41:47 5536 8192000000 10982801264 11414310912 2008440576 19.689 100 68 136 0 2071205472 40710816 22054080
23:42:00 1413 8192000000 10988205408 11408220160 2005314032 19.665 100 87 172 1 2074861024 41888176 27658816
23:42:08 3138 8192000000 10999571328 11417612288 2013241232 19.727 100 84 165 4 2080722080 41043776 26437072
23:42:18 5775 8192000000 10982987488 11403382784 1983853872 19.495 99 80 157 5 2051986880 42962592 25170416
23:42:31 1582 8192000000 10992249888 11413196800 2004961232 19.662 100 85 169 0 2076359504 44512320 26885952
23:42:39 8699 8192000000 10994518736 11414769664 2009452960 19.697 100 79 157 2 2077152416 43708416 23991040
23:42:55 2616 8192000000 10999482048 11421896704 2013780976 19.731 100 82 164 0 2083487520 44252160 25454384
23:43:04 2549 8192000000 10978177536 11398946816 1974837824 19.424 98 76 152 1 2043446416 44828864 23779728
23:43:14 2717 8192000000 10997848384 11415146496 2002363600 19.641 100 90 180 1 2078383504 47917872 28102032
23:43:23 5135 8192000000 10986037088 11403542528 1993669904 19.573 100 71 141 0 2060562080 45074128 21818048
23:43:37 990 8192000000 10997657904 11416936448 2003545904 19.651 100 86 170 0 2076256816 46575488 26135424
23:43:47 3638 8192000000 10983751264 11408076800 1984707312 19.502 99 84 168 2 2056424032 46402624 25314096
23:43:59 1053 8192000000 10978854912 11400392704 1989889328 19.543 100 85 168 2 2061141840 44456912 26795600
23:44:07 2627 8192000000 10966680624 11389767680 1978901680 19.456 100 72 145 1 2048911136 45341872 24667584
23:44:16 1863 8192000000 10986076096 11400757248 1990178160 19.545 100 86 171 2 2059084176 41654864 27251152
23:44:26 4758 8192000000 10974596960 11403087872 1990739472 19.550 100 70 140 0 2057138832 44313696 22085664
23:44:39 7092 8192000000 10969850384 11399598080 1988166528 19.529 100 72 145 0 2055609360 43888464 23554368
23:44:56 11369 8192000000 10949208496 11396575232 1967809808 19.368 99 55 111 0 2029671312 43859312 18002192
23:45:17 9371 8192000000 10942780704 11396526080 1966084736 19.354 99 39 78 2 2023437648 44150128 13202784
23:45:32 16251 8192000000 10932113472 11380551680 1967363760 19.365 99 40 80 0 2012185536 32235712 12586064
23:46:08 11394 8192000000 10919338448 11373957120 1954705008 19.264 99 33 66 1 1993739120 28395600 10638512
23:46:26 5232 8192000000 10926238816 11385769984 1973024352 19.409 100 29 58 0 2012714208 30519472 9170384
23:47:12 18874 8192000000 10909158992 11359678464 1932006368 19.083 98 22 43 1 1965646832 26783856 6856608
23:47:47 29225 8192000000 10894209344 11350597632 1899113392 18.819 97 25 50 1 1943916464 36332608 8470464
23:48:24 14379 8192000000 10872631680 11329441792 1897280032 18.804 98 21 42 2 1935802112 31603552 6918528
23:48:45 14455 8192000000 10874535904 11323785216 1911934832 18.922 99 22 44 1 1945437664 26867840 6634992
23:49:06 11466 8192000000 10868010336 11310096384 1872003504 18.600 97 29 57 2 1906679504 25674784 9001216
23:49:24 12361 8192000000 10874230672 11308953600 1881860592 18.680 98 48 98 0 1925325360 28520064 14944704
23:49:48 11233 8192000000 10857930608 11306360832 1890238832 18.748 99 26 52 2 1932563552 33878608 8446112
23:50:19 20336 8192000000 10876401136 11321245696 1899985040 18.826 99 20 40 1 1938237120 31827424 6424656
23:50:48 27016 8192000000 10881572960 11332038656 1912650640 18.928 99 27 54 1 1954263952 33035264 8578048
23:51:45 16402 8192000000 10890464720 11345825792 1932858000 19.090 100 21 42 2 1975922832 35691712 7373120
23:52:18 38185 8192000000 10870575280 11334721536 1901657408 18.840 98 11 22 0 1931165376 26121344 3386624
23:53:39 40253 8192000000 10881680272 11312730112 1918143824 18.972 99 47 93 5 1957420384 25765040 13511520
23:54:33 39899 8192000000 10891272384 11334545408 1916670496 18.960 99 40 80 1 1953559312 24380656 12508160
23:55:19 27613 8192000000 10867949728 11312726016 1914952480 18.946 99 29 58 1 1951387120 27465696 8968944
23:56:00 54709 8192000000 10843124992 11275702272 1880586656 18.670 97 42 84 4 1904856896 12760224 11510016
23:57:02 46566 8192000000 10816645824 11288039424 1841291072 18.351 96 11 23 0 1859679632 15416400 2972160
23:58:04 33198 8192000000 10831853040 11285966848 1882112960 18.682 98 24 49 0 1894574432 5164480 7296992
23:59:05 89064 8192000000 10834584096 11293749248 1893589344 18.775 99 14 27 1 1903693312 6815632 3288336
00:00:41 36568 8192000000 10859583872 11313774592 1903579360 18.855 99 9 18 0 1913010336 7118800 2312176
00:01:23 83117 8192000000 10855600080 11311812608 1916815616 18.961 99 16 32 1 1930299040 8920544 4562880
00:02:54 64173 8192000000 10857818208 11295797248 1914041696 18.939 99 28 58 3 1942375872 20773904 7560272
00:04:06 31742 8192000000 10869772960 11314745344 1918419248 18.974 99 41 81 4 1939470448 9904160 11147040
00:04:49 36997 8192000000 10855390384 11321065472 1933384208 19.094 100 13 26 3 1950092928 12452576 4256144
00:05:33 28992 8192000000 10858255280 11322040320 1899922256 18.826 98 14 28 0 1911609584 7790288 3897040
00:06:09 11368 8192000000 10872463072 11335430144 1944912704 19.186 100 18 36 0 1965931568 15811792 5207072
00:06:32 30259 8192000000 10883476016 11340443648 1954534992 19.263 100 30 58 2 1979170272 15044944 9590336
00:07:10 46155 8192000000 10876690112 11349270528 1949041488 19.219 100 12 24 0 1971111392 18713312 3356592
00:08:36 50947 8192000000 10868663888 11326906368 1909564912 18.903 98 18 36 1 1935083568 19459840 6058816
00:09:36 64606 8192000000 10860769808 11340488704 1905583440 18.871 98 24 48 0 1936844048 23832976 7427632
00:11:00 71220 8192000000 10870833776 11332947968 1909419232 18.902 98 24 47 3 1928201616 11537872 7244512
00:12:40 47216 8192000000 10869788736 11342999552 1945216688 19.188 100 16 32 0 1962009600 12165344 4627568
00:13:34 40222 8192000000 10864858128 11349975040 1944840464 19.185 100 16 32 0 1965382912 16179776 4362672
00:14:38 72017 8192000000 10878760144 11357368320 1945804208 19.193 99 11 22 1 1959227744 10040416 3383120
00:15:56 100302 8192000000 10886913008 11352657920 1910427808 18.910 97 27 54 0 1934942400 16970480 7544112
00:17:44 67406 8192000000 10911840064 11369832448 1955059248 19.267 99 30 60 0 1974653600 11339552 8254800
00:18:58 68795 8192000000 10892093072 11352940544 1910693008 18.912 97 17 34 1 1929925936 14661984 4570944
00:20:13 21844 8192000000 10911095184 11362258944 1963810080 19.336 100 36 72 1 1987959536 14191376 9958080
00:20:43 69450 8192000000 10902461472 11372924928 1953228560 19.252 99 27 54 2 1978248784 17396080 7624144
00:22:08 42735 8192000000 10919169936 11375259648 1965739408 19.352 100 15 30 2 1988333712 18227264 4367040
00:23:07 75378 8192000000 10905135504 11371782144 1939224928 19.141 98 24 48 2 1956917792 11204416 6488448
00:24:38 86194 8192000000 10892523680 11349839872 1911692352 18.920 97 24 47 1 1930163872 11138800 7332720
00:26:10 25095 8192000000 10904950192 11351318528 1928881232 19.058 98 38 76 1 1950997296 10923728 11192336
00:26:47 115019 8192000000 10861775888 11334504448 1885544864 18.710 96 29 57 1 1901359856 8036064 7778928
00:28:52 88535 8192000000 10899072352 11360751616 1969885712 19.385 100 17 35 0 1985979232 10992992 5100528
00:30:27 36447 8192000000 10898397280 11365765120 1970863952 19.392 100 22 44 1 1985276832 8853632 5559248
00:31:16 69511 8192000000 10903093824 11381858304 1985078128 19.505 100 15 30 1 2003965792 14334816 4552848
00:32:32 43000 8192000000 10906273584 11391545344 1985578576 19.509 100 8 16 1 1999060400 11406368 2075456
00:33:21 27373 8192000000 10923635520 11399696384 2001567088 19.635 100 13 25 0 2016645856 11626064 3452704
00:33:55 41773 8192000000 10915495744 11392536576 1971819952 19.400 99 11 22 0 1992854320 18078912 2955456
00:34:43 36940 8192000000 10885967568 11356991488 1901717776 18.840 96 14 28 0 1926175712 20738416 3719520
00:35:32 41326 8192000000 10895120352 11375042560 1949146480 19.220 99 18 36 1 1966811520 12725216 4939824
00:36:20 40049 8192000000 10897471744 11356667904 1918146720 18.972 97 27 54 2 1935960704 9524256 8289728
00:37:07 45563 8192000000 10895549872 11351666688 1897794752 18.809 96 39 78 1 1923022784 14027184 11200848
00:37:58 86800 8192000000 10892489856 11362844672 1908801680 18.897 97 18 36 0 1931958960 17704992 5452288
00:39:37 90151 8192000000 10867768816 11347042304 1882870832 18.688 96 10 20 0 1899174432 13320480 2983120
00:41:47 71349 8192000000 10883567872 11337936896 1856191248 18.472 95 32 65 1 1877612160 13084048 8336864
00:43:04 69280 8192000000 10872055728 11325427712 1836628512 18.313 94 41 81 1 1858273792 10934464 10710816
00:44:23 92081 8192000000 10853959824 11305959424 1822240608 18.196 95 14 28 1 1837565808 11417312 3907888
00:46:05 30374 8192000000 10856923824 11312824320 1902149728 18.844 99 29 58 1 1921987792 11132944 8705120
00:46:44 58621 8192000000 10849962320 11317039104 1891185056 18.755 98 24 48 3 1908221696 10452080 6584560
00:47:49 82175 8192000000 10860107808 11310510080 1909837216 18.905 99 23 46 2 1924649936 7928208 6884512
00:49:18 100415 8192000000 10864654416 11328020480 1886840416 18.720 97 31 62 1 1905223920 9156816 9226688
00:51:05 43029 8192000000 10852553296 11314765824 1907735696 18.888 98 38 74 1 1927084176 8623232 10725248
00:51:56 48231 8192000000 10844825520 11316670464 1901847920 18.841 98 15 31 1 1913796320 7340720 4607680
00:53:45 68202 8192000000 10869044304 11340902400 1927317136 19.045 99 13 26 0 1942919552 11887120 3715296
00:55:09 68565 8192000000 10844044832 11313455104 1877428224 18.644 97 12 20 0 1896035552 15960080 2647248
00:56:24 93798 8192000000 10872486400 11349024768 1913788592 18.937 99 10 20 1 1931593968 14613696 3191680
00:58:05 63222 8192000000 10878208160 11342864384 1921344128 18.998 98 25 48 0 1935563376 7629088 6590160
00:59:14 89929 8192000000 10867119872 11339829248 1902681184 18.848 97 18 36 1 1916202976 8753712 4768080
01:00:52 13579 8192000000 10880207424 11345244160 1955326496 19.269 100 32 60 2 1970678976 5885344 9467136
01:01:13 54835 8192000000 10907700288 11354992640 1962654320 19.327 100 32 63 3 1983042256 10717360 9670576
01:02:14 60121 8192000000 10914867296 11366776832 1965865584 19.353 100 31 62 0 1984486320 10176592 8444144
01:03:21 13390 8192000000 10912453472 11360997376 1956946336 19.282 99 58 116 2 1984382032 11443536 15992160
01:03:45 29104 8192000000 10916456080 11372888064 1971118976 19.394 100 36 72 1 1990738128 10012336 9606816
01:04:22 82838 8192000000 10890228272 11362340864 1931815504 19.081 98 21 42 2 1951634000 13616080 6202416
01:06:29 34775 8192000000 10889821104 11343974400 1914285152 18.941 98 16 32 0 1926358624 7609344 4464128
01:07:10 48833 8192000000 10907749600 11360940032 1942830896 19.169 99 36 71 0 1965289664 12556608 9902160
01:08:08 54595 8192000000 10858020832 11338801152 1908959536 18.898 98 24 47 2 1931561680 16091200 6510944
01:09:14 84031 8192000000 10885784192 11361624064 1926611696 19.040 99 8 16 0 1939501872 10646816 2243360
01:10:45 183615 8192000000 10907055120 11367518208 1955976096 19.274 99 30 59 2 1977581952 13527872 8077984
01:14:01 54583 8192000000 10899753312 11373412352 1961860352 19.321 99 24 47 3 1980293952 10900992 7532608
01:15:02 93832 8192000000 10885643648 11376685056 1939406704 19.142 98 12 24 0 1958893632 15626480 3860448
01:16:45 21559 8192000000 10893669472 11373142016 1966904816 19.361 100 7 15 1 1981767536 12651424 2211296
01:17:27 69033 8192000000 10890487664 11370090496 1954774272 19.264 99 16 32 2 1974429520 14987776 4667472
01:18:48 65668 8192000000 10863653504 11344384000 1889515008 18.742 96 6 12 0 1901546640 10051616 1980016
01:20:00 49577 8192000000 10849214864 11310047232 1862477536 18.523 96 18 36 3 1874302528 7578816 4246176
01:21:06 18022 8192000000 10877676480 11317354496 1902087920 18.843 98 47 96 2 1923563040 7972688 13502432
01:21:31 78221 8192000000 10864137024 11318353920 1857016256 18.479 96 33 66 1 1881337520 14064752 10256512
01:22:56 82554 8192000000 10845521920 11323125760 1856656832 18.476 96 17 34 0 1877086096 15469296 4959968
01:24:27 51993 8192000000 10856122688 11324690432 1889619984 18.743 98 13 26 1 1905653248 12059520 3973744
01:25:25 41987 8192000000 10867764624 11331268608 1931321488 19.077 100 17 34 0 1947632720 11563968 4747264
01:26:14 52878 8192000000 10871349776 11325480960 1864897632 18.543 96 24 48 4 1885778288 13831728 7048928
01:27:13 23594 8192000000 9231043488 9484562432 380007792 4.433 20 4 6 1 390419280 9782832 628656

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 118 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

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          235344
MON$OLDEST_ACTIVE               236356
MON$OLDEST_SNAPSHOT             236356
MON$NEXT_TRANSACTION            236356
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                       1996928
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.33429 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33429 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33429 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33429 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 ---
:253: 
:254: mscs-test-161.budzdorov.ru    Thu Apr  1 01:27:39 2021
:255:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:256: 
:257: 
:258: mscs-test-161.budzdorov.ru    Thu Apr  1 01:27:39 2021
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:260: 
:261: 
:262: mscs-test-161.budzdorov.ru    Thu Apr  1 01:27:52 2021
:263:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:264: 
--- end of diff output ---

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

01.04.21 01:29:10. 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-01 01:29:13 No severe PSQL-related problems occured
01.04.21 01:29:14. End of report.