Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.03.2021 22:28
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 17542616 kB
MemAvailable 31600096 kB
Buffers 0 kB
Cached 14164172 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-03-14 22:27:21
DTS_END                         2021-03-14 22:27:21.9730
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/49752
TRN_ID                          236022
ATT_ID                          694
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: 9135.12 19988 1096214
customer order: creation 168.73 325 20248
customer order: refuse 14.13 332 1695
order to supplier: creation 45.22 1263 5426
order to supplier: removal 3.63 99048 435
invoice (draft): creation 45.98 3285 5518
invoice (draft): removal 52.48 871 6297
invoice accept: apply 41.73 16784 5007
invoice accept: cancel 47.23 837 5667
customer reserve: creation 3831.47 166 459776
customer reserve: removal 4585.75 61 550290
realization accept: apply 83.84 165 10061
realization accept: cancel 86.26 112 10351
payment from customer: creation 59.12 117 7094
payment from customer: removal 5.62 107 674
payment to supplier: creation 48.52 135 5822
payment to supplier: removal 3.52 69 422
service: total inventory turnovers 4.45 1249 534
service: total monetary turnovers 6.52 24 782
service: aggregate perf. data 0.93 15074 111
service: refresh index statistics 0.03 259735 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2021 22:29:21 to 14-03-2021 22:29:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5716
TEST_TIME 2 5141
TEST_TIME 3 4794
TEST_TIME 4 4088
TEST_TIME 5 4285
TEST_TIME 6 4984
TEST_TIME 7 5350
TEST_TIME 8 5635
TEST_TIME 9 5583
TEST_TIME 10 5477
TEST_TIME 11 5448
TEST_TIME 12 5529
TEST_TIME 13 5561
TEST_TIME 14 6307
TEST_TIME 15 6361
TEST_TIME 16 6409
TEST_TIME 17 6510
TEST_TIME 18 6952
TEST_TIME 19 7019
TEST_TIME 20 7774
TEST_TIME 21 7617
TEST_TIME 22 7784
TEST_TIME 23 8480
TEST_TIME 24 8547
TEST_TIME 25 8714
TEST_TIME 26 8873
TEST_TIME 27 9238
TEST_TIME 28 10218
TEST_TIME 29 10106
TEST_TIME 30 10142
TEST_TIME 31 10544
TEST_TIME 32 10458
TEST_TIME 33 10206
TEST_TIME 34 10248
TEST_TIME 35 10240
TEST_TIME 36 10209
TEST_TIME 37 10046
TEST_TIME 38 9921
TEST_TIME 39 9861
TEST_TIME 40 9817
TEST_TIME 41 9869
TEST_TIME 42 9984
TEST_TIME 43 9821
TEST_TIME 44 9724
TEST_TIME 45 9752
TEST_TIME 46 9635
TEST_TIME 47 9514
TEST_TIME 48 9469
TEST_TIME 49 9415
TEST_TIME 50 9354
TEST_TIME 51 9321
TEST_TIME 52 9271
TEST_TIME 53 9175
TEST_TIME 54 9153
TEST_TIME 55 9144
TEST_TIME 56 9098
TEST_TIME 57 9221
TEST_TIME 58 9254
TEST_TIME 59 9257
TEST_TIME 60 9221
TEST_TIME 61 9381
TEST_TIME 62 9336
TEST_TIME 63 9399
TEST_TIME 64 9446
TEST_TIME 65 9446
TEST_TIME 66 9488
TEST_TIME 67 9546
TEST_TIME 68 9560
TEST_TIME 69 9599
TEST_TIME 70 9623
TEST_TIME 71 9608
TEST_TIME 72 9499
TEST_TIME 73 9441
TEST_TIME 74 9406
TEST_TIME 75 9422
TEST_TIME 76 9427
TEST_TIME 77 9361
TEST_TIME 78 9377
TEST_TIME 79 9370
TEST_TIME 80 9332
TEST_TIME 81 9342
TEST_TIME 82 9344
TEST_TIME 83 9448
TEST_TIME 84 9423
TEST_TIME 85 9406
TEST_TIME 86 9443
TEST_TIME 87 9511
TEST_TIME 88 9529
TEST_TIME 89 9582
TEST_TIME 90 9595
TEST_TIME 91 9580
TEST_TIME 92 9569
TEST_TIME 93 9527
TEST_TIME 94 9467
TEST_TIME 95 9440
TEST_TIME 96 9407
TEST_TIME 97 9362
TEST_TIME 98 9320
TEST_TIME 99 9326
TEST_TIME 100 9277
TEST_TIME 101 9284
TEST_TIME 102 9333
TEST_TIME 103 9304
TEST_TIME 104 9292
TEST_TIME 105 9255
TEST_TIME 106 9287
TEST_TIME 107 9276
TEST_TIME 108 9297
TEST_TIME 109 9330
TEST_TIME 110 9327
TEST_TIME 111 9337
TEST_TIME 112 9340
TEST_TIME 113 9360
TEST_TIME 114 9296
TEST_TIME 115 9259
TEST_TIME 116 9249
TEST_TIME 117 9233
TEST_TIME 118 9233
TEST_TIME 119 9178
TEST_TIME 120 9140

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2021 22:29:25 to 14-03-2021 22:29:28.

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 1522787 1522787 0 0.00 0 30674 6 0 0
doc_list_biud 1522783 1522783 0 0.00 0 63255 28 0 0
sp_add_invoice_to_stock 5074 5007 67 1.32 26 193800 16784 0 67
sp_cancel_adding_invoice 5667 5667 0 0.00 6 116751 838 0 0
sp_cancel_client_order 1695 1695 0 0.00 4 13780 332 0 0
sp_cancel_customer_reserve 550290 550290 0 0.00 1 63257 62 0 0
sp_cancel_pay_from_customer 674 674 0 0.00 3 6898 108 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 3632 69 0 0
sp_cancel_supplier_invoice 6301 6297 4 0.06 2 34950 872 0 4
sp_cancel_supplier_order 435 435 0 0.00 9 1077384 99048 0 0
sp_cancel_write_off 10351 10351 0 0.00 1 13465 112 0 0
sp_client_order 20248 20248 0 0.00 4 50927 326 0 0
sp_customer_reserve 459776 459776 0 0.00 0 47694 167 0 0
sp_fill_shopping_cart 31185 31185 0 0.00 1 15787 42 0 0
sp_fill_shopping_cart_clo_res 459766 459766 0 0.00 0 23381 14 0 0
sp_get_clo_for_invoice 4997 4997 0 0.00 0 29921 325 0 0
sp_kill_cost_storno 17114 17114 0 0.00 0 6075 53 0 0
sp_kill_qstorno_ret_qs2qd 1117663 1117663 0 0.00 0 63252 34 0 0
sp_kill_qty_storno 589790 589790 0 0.00 0 63255 72 0 0
sp_lock_selected_doc 20790 20790 0 0.00 0 6410 6 0 0
sp_make_cost_storno 27973 27973 0 0.00 0 30664 56 0 0
sp_multiply_rows_for_pdistr 27969 27969 0 0.00 0 17584 30 0 0
sp_multiply_rows_for_qdistr 20248 20248 0 0.00 0 41384 158 0 0
sp_pay_from_customer 7094 7094 0 0.00 4 17594 118 0 0
sp_pay_to_supplier 5822 5822 0 0.00 5 15449 135 0 0
sp_payment_common 12914 12914 0 0.00 2 13595 39 0 0
sp_qd_handle_on_cancel_clo 1695 1695 0 0.00 0 13765 308 0 0
sp_qd_handle_on_invoice_upd_sts 10662 10662 0 0.00 0 37790 314 0 0
sp_qd_handle_on_reserve_upd_sts 10060 10060 0 0.00 0 19396 56 0 0
sp_reserve_write_off 10061 10061 0 0.00 6 19437 165 0 0
sp_supplier_invoice 5518 5518 0 0.00 7 94292 3285 0 0
sp_supplier_order 5426 5426 0 0.00 4 68042 1264 0 0
srv_aggregate_perf_data 111 111 0 0.00 2633 89719 15075 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1560 137354 34520 0 0
srv_find_qd_qs_mism 1049287 1049287 0 0.00 0 23444 5 0 0
srv_make_invnt_saldo 534 534 0 0.00 35 99698 1250 0 0
srv_make_money_saldo 782 782 0 0.00 1 4335 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 101337 404625 259736 0 0
t$perf-abend:sp_add_invoice_to_stock 67 67 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-norm:sp_add_invoice_to_stock 5007 5007 0 0.00 0 11878 145 0 0
t$perf-norm:sp_cancel_adding_invoice 445 445 0 0.00 0 13805 155 0 0
t$perf-norm:sp_cancel_client_order 1695 1695 0 0.00 0 11977 24 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 2040 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 674 674 0 0.00 0 1179 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 551 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 2017 19 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 21036 1503 0 0
t$perf-norm:sp_cancel_write_off 980 980 0 0.00 0 4149 18 0 0
t$perf-norm:sp_client_order 20248 20248 0 0.00 0 15609 18 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 2443 7 0 0
t$perf-norm:sp_pay_from_customer 7094 7094 0 0.00 0 5512 10 0 0
t$perf-norm:sp_pay_to_supplier 5822 5822 0 0.00 0 7458 11 0 0
t$perf-norm:sp_reserve_write_off 10061 10061 0 0.00 0 8302 11 0 0
t$perf-norm:sp_supplier_invoice 5518 5518 0 0.00 0 6645 19 0 0
t$perf-norm:sp_supplier_order 5426 5426 0 0.00 0 4703 13 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 300 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 2115 15 0 0
t$perf-norm:srv_make_invnt_saldo 534 534 0 0.00 0 2062 23 0 0
t$perf-norm:srv_make_money_saldo 782 782 0 0.00 0 497 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10122 9988 134 1.32 0 12162 16 0 134
v_all_customers 37452 37452 0 0.00 0 60 1 0 0
v_all_suppliers 30350 30350 0 0.00 0 20 1 0 0
v_all_wares 40496 40496 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 890 890 0 0.00 0 1858 11 0 0
v_cancel_client_order 3390 3390 0 0.00 0 4357 6 0 0
v_cancel_customer_prepayment 1348 1348 0 0.00 0 6644 14 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 1877 4 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 2616 8 0 0
v_cancel_supplier_invoice 802 794 8 0.99 0 1998 14 0 8
v_cancel_supplier_order 870 870 0 0.00 0 539 3 0 0
v_cancel_write_off 1960 1960 0 0.00 0 7987 22 0 0
v_max_id_clo_ord 5426 5426 0 0.00 0 801 1 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 1532 6 0 0
v_max_id_ord_sup 5511 5511 0 0.00 0 8006 6 0 0
v_max_non_paid_invoice 1582 1582 0 0.00 0 2431 6 0 0
v_max_non_paid_realizn 3600 3600 0 0.00 0 752 3 0 0
v_min_id_clo_ord 5426 5426 0 0.00 0 6458 9 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 8497 23 0 0
v_min_id_ord_sup 5511 5511 0 0.00 0 5071 8 0 0
v_min_non_paid_invoice 5820 5820 0 0.00 0 7729 24 0 0
v_min_non_paid_realizn 7094 7094 0 0.00 0 7419 24 0 0
v_our_firm 10032 10032 0 0.00 0 22 1 0 0
v_reserve_write_off 20120 20120 0 0.00 0 4529 4 0 0
x_lock_depdocs_on_canc_invoice 11567 11567 0 0.00 0 14722 119 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 11295 357 0 0
x_make_qstorno_1000_1200 5426 5426 0 0.00 2 68037 1189 0 0
x_make_qstorno_1200_2000 5518 5518 0 0.00 3 90185 3124 0 0
x_make_qstorno_2100_3300 459776 459776 0 0.00 0 37079 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2021 22:29:29 to 14-03-2021 22:29:33.

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
19:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:32 18888 8192000000 10272311056 10582450176 919566944 10.092 71 54 108 2 940638544 2584000 18487600
19:57:58 17164 8192000000 10325727152 10642243584 1377353920 14.393 100 88 175 1 1411177424 4723504 29100000
19:58:26 38335 8192000000 10374662608 10696929280 1418724400 14.761 100 91 181 1 1454952480 6401552 29826528
19:59:12 26371 8192000000 10401147744 10726236160 1446619376 15.008 100 83 166 0 1480727296 7271168 26836752
19:59:48 20508 8192000000 10419763024 10749558784 1475257248 15.260 100 83 166 0 1510043712 8087872 26698592
20:00:20 20386 8192000000 10453397424 10787950592 1507292288 15.540 100 87 174 0 1543562368 8899648 27370432
20:00:49 22186 8192000000 10475814352 10811473920 1523095616 15.677 100 90 180 0 1561317056 9844528 28376912
20:01:18 13372 8192000000 10483231232 10822651904 1534151088 15.773 100 87 174 0 1571604272 10252208 27200976
20:01:40 26820 8192000000 10505157232 10850455552 1547087712 15.885 100 82 164 1 1583031008 10718256 25225040
20:02:14 18995 8192000000 10539042384 10887815168 1588765904 16.243 100 81 162 0 1623653728 10734960 24152864
20:02:48 13761 8192000000 10565406496 10921127936 1621917888 16.526 100 85 170 1 1658902528 11803696 25180944
20:03:11 12491 8192000000 10593299504 10950688768 1641647184 16.694 100 78 156 0 1677020496 12591344 22781968
20:03:33 10117 8192000000 10597126608 10963722240 1658797968 16.839 100 86 170 2 1696956080 13271152 24886960
20:03:52 8565 8192000000 10618978912 10989330432 1676124816 16.985 100 72 144 0 1708197856 11448064 20624976
20:04:09 7710 8192000000 10644220624 11013505024 1699596592 17.182 100 72 141 1 1731380288 11329440 20454256
20:04:25 9095 8192000000 10658467952 11033776128 1722542464 17.373 100 81 163 1 1758276080 12353456 23380160
20:04:42 9382 8192000000 10682131744 11054698496 1743948080 17.551 100 88 176 1 1781791600 12507056 25336464
20:05:01 5657 8192000000 10684037168 11062255616 1751944432 17.618 100 77 153 0 1785849216 12338368 21566416
20:05:13 4949 8192000000 10712413904 11083292672 1759625920 17.681 100 87 173 3 1797137968 13077248 24434800
20:05:26 5019 8192000000 10706121072 11080171520 1767320480 17.745 100 90 180 1 1807204384 14602192 25281712
20:05:39 4486 8192000000 10712311504 11090931712 1772295552 17.786 100 82 164 0 1809847600 13914304 23637744
20:05:51 4812 8192000000 10729779680 11108810752 1783038640 17.875 100 88 175 0 1822909744 15223920 24647184
20:06:04 2847 8192000000 10733977152 11111686144 1788897424 17.923 100 89 176 0 1828340144 14343856 25098864
20:06:14 2901 8192000000 10735671760 11116765184 1793020656 17.957 100 84 168 1 1830452528 14388576 23043296
20:06:23 2251 8192000000 10740319280 11121291264 1801877824 18.029 100 90 180 0 1842245984 14660704 25707456
20:06:38 2898 8192000000 10740037408 11125821440 1800675120 18.019 100 85 166 1 1837435216 13840272 22919824
20:06:47 2284 8192000000 10754626704 11134337024 1803656768 18.044 100 88 176 0 1843322080 14800832 24864480
20:06:56 2067 8192000000 10760415024 11139108864 1814973424 18.137 100 90 178 4 1855250176 15686432 24590320
20:07:05 2617 8192000000 10761819600 11144617984 1823150320 18.203 100 89 178 0 1862593696 14008352 25435024
20:07:14 1992 8192000000 10773055536 11154128896 1827826528 18.242 100 89 178 4 1865331328 12691472 24813328
20:07:23 2022 8192000000 10779786880 11162300416 1832031424 18.276 100 92 184 0 1871468720 13268016 26169280
20:07:31 1210 8192000000 10777367104 11161796608 1836562960 18.313 100 92 183 0 1876127568 13882768 25681840
20:07:38 2201 8192000000 10795918416 11179249664 1846087552 18.390 100 90 179 0 1882311712 11225232 24998928
20:07:47 1903 8192000000 10791607088 11180068864 1852956368 18.446 100 86 170 1 1888845440 11184064 24705008
20:07:55 1604 8192000000 10802632848 11187826688 1855740560 18.469 100 96 189 2 1896006512 12674272 27591680
20:08:04 1713 8192000000 10804412352 11192832000 1862387184 18.523 100 92 184 1 1901338496 12620304 26331008
20:08:11 2456 8192000000 10805709536 11193409536 1864032720 18.536 100 91 182 1 1902488496 12918624 25537152
20:08:20 1715 8192000000 10810389136 11205292032 1869635936 18.581 100 84 166 3 1906287328 14007872 22643520
20:08:28 2815 8192000000 10820643632 11213438976 1873955664 18.616 100 90 180 0 1916849024 17538224 25355136
20:08:37 37654 8192000000 10813415264 11210747904 1872609344 18.605 100 69 136 2 1904306112 12735376 18961392
20:09:21 1150 8192000000 10824689680 11221868544 1882294992 18.684 100 86 172 2 1918171504 11375408 24501104
20:09:28 1952 8192000000 10814847024 11222155264 1878785408 18.655 100 66 132 0 1909805856 12469232 18551216
20:09:37 2322 8192000000 10817386144 11218157568 1879085296 18.658 100 52 105 0 1903782432 9387008 15310128
20:09:46 5837 8192000000 10805407936 11222134784 1879779984 18.663 100 37 74 2 1899099440 8491344 10828112
20:10:02 3724 8192000000 10807293632 11224186880 1887902656 18.729 100 52 106 2 1910676448 7922480 14851312
20:10:15 4280 8192000000 10789035296 11217100800 1886272464 18.716 100 32 65 2 1902957344 7631408 9053472
20:10:26 2911 8192000000 10808960944 11224952832 1892793968 18.768 100 49 98 3 1913866832 7134736 13938128
20:10:35 6356 8192000000 10806721648 11231518720 1892588992 18.767 100 37 71 3 1910279648 7137360 10553296
20:10:49 45641 8192000000 10827589280 11238793216 1894386016 18.781 100 37 73 1 1910628448 5661952 10580480
20:11:41 12214 8192000000 10817717952 11243569152 1891388864 18.757 100 22 45 1 1902841472 5855600 5597008
20:12:01 7941 8192000000 10807169376 11238539264 1896927248 18.802 100 34 69 2 1912858032 6409680 9521104
20:12:17 6602 8192000000 10807937952 11239178240 1900792256 18.833 100 37 74 6 1917600816 6417376 10391184
20:12:32 5397 8192000000 10811389136 11243413504 1899804608 18.825 100 32 61 2 1916783936 7859152 9120176
20:12:45 3801 8192000000 10820747088 11247656960 1904603328 18.863 100 41 82 1 1923500000 7340496 11556176
20:12:58 8786 8192000000 10814040480 11248844800 1904881920 18.866 100 23 46 1 1917857824 6046096 6929808
20:13:16 3676 8192000000 10827996672 11253878784 1907148592 18.884 100 34 67 1 1923184528 6711296 9324640
20:13:25 7053 8192000000 10817212128 11248771072 1908075824 18.891 100 27 54 1 1922280848 6443040 7761984
20:13:39 4701 8192000000 10822628416 11254599680 1909852288 18.905 100 39 78 0 1927836240 6847152 11136800
20:13:53 8322 8192000000 10821582224 11251372032 1908163920 18.892 100 21 42 1 1919281440 4986640 6130880
20:14:11 7511 8192000000 10814722224 11251412992 1908580704 18.895 100 26 52 1 1922032832 6363136 7088992
20:14:27 9767 8192000000 10818854048 11254472704 1908384976 18.894 100 24 49 2 1922044432 6803344 6856112
20:14:43 8541 8192000000 10813679008 11253551104 1910619920 18.912 100 29 57 1 1925537088 5298816 9618352
20:14:58 62015 8192000000 10833722912 11255873536 1896672592 18.800 99 42 83 0 1914575904 5241920 12661392
20:16:06 7025 8192000000 10812515024 11251740672 1905915632 18.874 100 30 60 0 1921621984 7210032 8496320
20:16:23 7800 8192000000 10828495056 11259207680 1908328768 18.893 100 25 50 1 1921633904 6669072 6636064
20:16:37 8108 8192000000 10819677952 11257380864 1909952640 18.906 100 21 42 0 1921751856 6024224 5774992
20:16:55 6097 8192000000 10813538208 11240853504 1884812576 18.704 99 40 80 2 1902629264 6401520 11415168
20:17:10 3767 8192000000 10776060400 11199508480 1818524976 18.166 96 36 72 1 1836779296 8117152 10137168
20:17:21 6993 8192000000 10788972576 11207401472 1821734096 18.192 97 26 52 1 1835224288 6512864 6977328
20:17:36 6561 8192000000 10782530720 11213381632 1859660832 18.501 99 28 56 1 1874512736 6465344 8386560
20:17:51 5632 8192000000 10780164672 11218219008 1860238752 18.505 99 20 40 0 1872030032 5118384 6672896
20:18:03 8998 8192000000 10783438896 11218427904 1843902544 18.373 98 20 39 2 1859748016 10278144 5567328
20:18:19 8244 8192000000 10801509744 11222851584 1879881664 18.664 100 34 68 2 1897175872 7044912 10249296
20:18:38 9874 8192000000 10743284896 11173236736 1738118064 17.503 93 15 28 1 1751806464 9748528 3939872
20:18:56 8643 8192000000 10745895248 11166289920 1775053776 17.809 96 20 40 2 1785552240 5125632 5372832
20:19:12 6821 8192000000 10739839344 11169824768 1814221536 18.130 99 29 58 1 1829358288 6238960 8897792
20:19:28 7798 8192000000 10722570496 11145478144 1760745888 17.691 96 20 38 2 1773101920 5992496 6363536
20:19:42 11858 8192000000 10725636112 11134107648 1734793824 17.475 95 31 59 1 1748735760 5238704 8703232
20:20:28 22422 8192000000 10738455136 11126099968 1785810016 17.897 99 56 112 1 1807872848 5616448 16446384
20:20:57 8032 8192000000 10713523232 11142561792 1779283584 17.844 98 15 29 1 1789800688 6529184 3987920
20:21:12 10197 8192000000 10721401648 11141230592 1769272032 17.761 98 20 40 2 1780658352 5557952 5828368
20:21:30 4565 8192000000 10709189024 11127521280 1773121520 17.793 98 40 80 1 1791840048 6254960 12463568
20:21:40 8703 8192000000 10709513088 11118530560 1762598080 17.706 98 26 50 4 1775875984 6341536 6936368
20:21:56 7765 8192000000 10707987824 11123843072 1750938016 17.609 97 25 50 2 1763281360 5452544 6890800
20:22:10 4830 8192000000 10685146224 11098841088 1752478736 17.622 98 22 44 0 1764224480 5938784 5806960
20:22:21 8177 8192000000 10721501088 11141160960 1801827728 18.029 100 24 49 3 1819711168 10478752 7404688
20:22:38 9869 8192000000 10710167968 11133644800 1760386736 17.688 97 32 64 0 1775787104 5472960 9927408
20:22:54 7667 8192000000 10728831168 11149467648 1811792800 18.111 100 18 33 2 1826459440 9995808 4670832
20:23:09 8919 8192000000 10735367440 11152748544 1789328448 17.926 98 25 50 2 1806311488 9284224 7698816
20:23:25 12537 8192000000 10752200992 11171205120 1829405024 18.254 100 26 53 0 1842828176 5067568 8355584
20:23:47 7159 8192000000 10762584064 11183562752 1846647328 18.395 100 35 70 2 1862728464 5863824 10217312
20:24:04 6023 8192000000 10764761824 11182837760 1845389968 18.385 100 30 59 2 1859694832 4673744 9631120
20:24:19 15465 8192000000 10790615424 11198529536 1850753264 18.428 100 20 42 1 1861835264 5304000 5778000
20:24:43 65215 8192000000 10775103616 11200569344 1860497504 18.507 100 30 60 0 1878507328 9067648 8942176
20:25:55 11334 8192000000 10775133344 11204702208 1864404848 18.539 100 33 65 2 1880142544 6856480 8881216
20:26:15 7505 8192000000 10786057984 11213967360 1865622016 18.549 100 23 46 2 1881743616 9297440 6824160
20:26:29 9890 8192000000 10777177440 11210342400 1871869552 18.599 100 28 56 1 1885113536 5113744 8130240
20:26:46 8428 8192000000 10779276944 11215163392 1871163488 18.594 100 20 40 1 1882236656 5122576 5950592
20:27:02 8923 8192000000 10802451232 11227492352 1880139168 18.666 100 25 50 3 1892867936 5730352 6998416
20:27:19 10491 8192000000 10817049248 11236868096 1894126720 18.779 100 32 61 1 1908519280 5418400 8974160
20:27:40 8335 8192000000 10840481712 11250786304 1904823824 18.865 100 58 115 1 1928578432 6455040 17299568
20:27:56 9484 8192000000 10847841248 11260948480 1912915184 18.930 100 70 138 1 1943172768 9309232 20948352
20:28:13 7398 8192000000 10836517200 11259498496 1914618704 18.944 100 49 96 0 1936800480 8811024 13370752
20:28:45 25968 8192000000 10856769616 11275853824 1918613632 18.976 100 44 89 0 1939920160 8960656 12345872
20:29:19 9905 8192000000 10862623744 11280715776 1926307920 19.037 100 51 103 0 1951678704 10864352 14506432
20:29:49 16368 8192000000 10865052672 11291369472 1935751936 19.113 100 59 116 4 1962540480 10676640 16111904
20:30:17 120672 8192000000 10873470752 11310800896 1939393280 19.142 100 37 74 3 1963553424 13347568 10812576
20:33:13 21761 8192000000 10887378368 11329835008 1956464032 19.278 100 38 76 0 1987542416 19350064 11728320
20:33:42 15286 8192000000 10904817792 11334332416 1959463824 19.302 100 45 88 1 1991958720 18667456 13827440
20:34:06 4941 8192000000 10918813440 11344355328 1967175280 19.363 100 63 123 1 2005000240 19440704 18384256
20:34:18 17646 8192000000 10918624560 11348668416 1972885584 19.408 100 56 112 1 2007692912 18347136 16460192
20:34:45 16956 8192000000 10919710752 11349016576 1974822768 19.424 100 58 113 1 2009873984 19538512 15512704
20:35:10 15862 8192000000 10922182192 11355197440 1979354192 19.460 100 61 122 0 2018261216 21035456 17871568
20:35:38 14710 8192000000 10923886816 11360485376 1982384000 19.484 100 51 101 3 2016429360 18855360 15190000
20:36:00 9612 8192000000 10932027920 11364265984 1988214464 19.530 100 52 103 1 2021702400 18790512 14697424
20:36:17 4308 8192000000 10942103680 11366301696 1989841536 19.543 100 62 124 2 2027517968 19479264 18197168
20:36:50 6457 8192000000 10945148224 11379847168 1995436480 19.587 100 49 98 0 2033377984 22940480 15001024
20:37:05 12805 8192000000 10936739392 11378892800 1994676400 19.581 100 38 76 0 2027787024 21338784 11771840
20:37:27 9341 8192000000 10937769184 11375980544 1991575616 19.556 100 43 86 0 2026613072 22075872 12961584
20:37:44 16999 8192000000 10943832288 11377872896 1978770368 19.455 99 47 93 0 2015391280 22902368 13718544
20:38:10 2217 8192000000 10958052416 11386773504 2001262432 19.633 100 70 141 1 2045732688 23808272 20661984
20:38:20 3413 8192000000 10958972144 11388497920 2007789040 19.684 100 71 142 1 2053594704 25185952 20619712
20:38:30 10174 8192000000 10970348512 11396603904 2009756960 19.700 100 69 138 0 2056725488 26684784 20283744
20:38:48 5186 8192000000 10969154784 11399421952 2013062096 19.726 100 68 136 1 2060821008 27420368 20338544
20:39:00 5669 8192000000 10962312368 11389173760 1988288880 19.530 99 70 140 1 2036938240 27043248 21606112
20:39:13 6159 8192000000 10972855808 11393687552 2004248048 19.656 100 76 151 1 2054895504 27363536 23283920
20:39:26 3021 8192000000 10980616816 11402498048 2012389392 19.720 100 83 168 0 2065077856 28645344 24043120
20:39:38 6405 8192000000 10974714288 11404201984 2011510912 19.713 100 70 139 1 2063751488 30948352 21292224
20:39:53 4218 8192000000 10985475488 11406073856 2011468176 19.713 100 72 143 2 2063710288 29997984 22244128
20:40:03 1903 8192000000 10987638832 11407130624 2019493456 19.776 100 83 165 2 2075187696 29827104 25867136
20:40:12 3251 8192000000 10976930144 11403882496 1994412784 19.579 99 75 150 0 2049200224 31390368 23397072
20:40:26 8337 8192000000 10970030592 11403587584 2008903984 19.693 100 61 122 0 2059840768 31872592 19064192
20:40:42 10185 8192000000 10981545264 11407192064 2009017168 19.694 100 70 138 0 2064368752 33704336 21647248
20:41:06 11028 8192000000 10973885776 11413229568 1996172768 19.593 99 56 112 0 2051675376 37119216 18383392
20:41:23 2551 8192000000 11002861872 11426762752 2002169168 19.640 99 77 153 0 2061631472 35614768 23847536
20:41:37 3495 8192000000 10979793296 11411128320 2017354464 19.759 100 69 137 2 2070889040 31824432 21710144
20:41:51 4007 8192000000 10991299872 11413549056 2003720640 19.652 99 73 145 1 2056453872 30350192 22383040
20:42:02 3945 8192000000 10987945824 11414794240 2001446992 19.634 99 67 132 0 2054115728 32388256 20280480
20:42:19 6986 8192000000 10972114544 11401715712 2002135520 19.640 99 68 136 2 2056270816 33282992 20852304
20:42:34 6399 8192000000 10976628144 11405422592 2010706784 19.707 100 64 127 1 2061248256 31068192 19473280
20:42:49 4822 8192000000 10984216320 11413045248 2014069888 19.734 100 68 135 2 2066899424 32513664 20315872
20:43:01 4152 8192000000 10972008176 11402358784 2006436832 19.673 100 65 127 1 2058387136 32290912 19659392
20:43:13 2101 8192000000 10989894960 11413147648 2018661792 19.770 100 76 152 0 2076975776 34610720 23703264
20:43:28 2992 8192000000 10990882352 11413962752 2013886448 19.732 100 70 138 0 2070400384 34948256 21565680
20:43:38 4226 8192000000 10970673808 11398701056 1996139232 19.592 99 68 135 1 2056858688 38547264 22172192
20:43:54 4865 8192000000 10984156288 11414269952 2006453008 19.674 100 67 134 1 2066659488 38339168 21867312
20:44:13 4672 8192000000 10982124944 11399950336 1987433072 19.524 99 61 117 2 2042046912 35726368 18887472
20:44:26 3240 8192000000 10979710272 11402190848 2006668736 19.675 100 70 142 1 2066540240 37432784 22438720
20:44:36 3444 8192000000 10967849040 11384655872 1971322880 19.396 99 79 154 1 2035596768 39218464 25055424
20:44:50 2018 8192000000 10958685232 11382624256 1967409072 19.365 99 71 142 1 2031744592 41126880 23208640
20:45:02 4129 8192000000 10958873840 11389657088 1986431840 19.516 100 57 114 1 2045703024 39788928 19482256
20:45:18 1877 8192000000 10942165248 11359318016 1955663088 19.272 99 80 159 0 2024049680 42409472 25977120
20:45:27 2592 8192000000 10928766944 11348439040 1938498784 19.135 99 80 159 0 2009234832 44206752 26529296
20:45:39 4723 8192000000 10915397472 11326427136 1931174224 19.076 99 69 137 3 1993274896 39431504 22669168
20:45:52 8171 8192000000 10924903840 11356090368 1955231776 19.268 100 72 144 0 2021306384 42317296 23757312
20:46:09 13788 8192000000 10915218064 11356504064 1937064320 19.123 99 33 66 1 1988207472 39485680 11657472
20:46:31 5417 8192000000 10926804144 11352637440 1947497072 19.207 100 62 119 1 2010524224 42575920 20451232
20:46:54 1559 8192000000 10958804240 11367522304 1966735312 19.360 100 89 178 2 2040105136 45826576 27543248
20:47:03 3770 8192000000 10961201840 11377238016 1968676528 19.375 100 77 153 1 2042793184 48843856 25272800
20:47:14 2946 8192000000 10980837184 11392958464 1980536016 19.469 100 93 187 1 2060491936 50765648 29190272
20:47:24 1664 8192000000 10989845936 11400740864 1984699952 19.502 100 85 170 2 2065691648 54087808 26903888
20:47:32 11020 8192000000 10946214832 11392299008 1976314384 19.436 100 51 101 0 2040569440 48062784 16192272
20:48:00 7787 8192000000 10946859024 11388518400 1979226320 19.459 100 36 73 1 2031371072 39752976 12391776
20:48:18 3685 8192000000 10961248160 11382632448 1959260416 19.300 99 64 126 1 2020118336 40054768 20803152
20:48:35 8538 8192000000 10933251856 11372371968 1965884704 19.353 100 40 81 1 2022549616 43408112 13256800
20:48:51 5635 8192000000 10935184240 11367079936 1949070192 19.219 99 46 92 1 2009918320 45021200 15826928
20:49:05 7202 8192000000 10946057888 11375833088 1965063776 19.346 100 54 103 2 2031024224 49032256 16928192
20:49:18 9800 8192000000 10941960160 11382222848 1965155840 19.347 100 35 70 0 2026821600 49307088 12358672
20:49:39 10815 8192000000 10954018544 11386380288 1970540096 19.390 100 54 108 1 2039785824 51300608 17945120
20:50:00 3813 8192000000 10936884656 11361669120 1927125200 19.044 98 74 149 2 1997592208 47157712 23309296
20:50:11 4170 8192000000 10954768688 11365089280 1953416960 19.254 100 73 141 2 2025980016 48966976 23596080
20:50:22 1574 8192000000 10966204224 11375271936 1962918752 19.329 100 97 195 4 2046579952 52601216 31059984
20:50:32 31232 8192000000 10898440112 11348570112 1924190080 19.020 99 42 84 1 1992289696 53731648 14367968
20:51:18 11513 8192000000 10913802112 11352748032 1940267760 19.149 100 30 60 0 1998024128 47170224 10586144
20:51:42 23340 8192000000 10899930944 11351781376 1917004704 18.963 99 26 52 2 1972391472 45894576 9492192
20:52:15 24697 8192000000 10903373024 11354066944 1929714704 19.065 100 24 48 1 1985699552 47151360 8833488
20:52:52 32277 8192000000 10889572720 11336413184 1899869680 18.825 99 26 52 1 1957505792 48010736 9625376
20:53:31 24431 8192000000 10875248608 11326824448 1892589904 18.767 99 17 34 2 1947347216 47968848 6788464
20:54:11 23245 8192000000 10846194960 11299594240 1837485744 18.320 97 19 37 1 1893725104 48894368 7344992
20:54:43 36452 8192000000 10855601376 11315650560 1890769744 18.752 100 21 42 1 1953620992 55034608 7816640
20:55:26 31325 8192000000 10827883872 11290140672 1881460480 18.677 99 6 12 0 1911458096 28130464 1867152
20:56:15 60617 8192000000 10866796224 11329826816 1908443520 18.894 99 25 49 2 1937939136 22053520 7442096
20:57:23 45068 8192000000 10869500144 11316391936 1907134464 18.884 99 13 26 2 1935016448 24366432 3515552
20:58:34 111057 8192000000 10853505072 11295666176 1871126000 18.593 97 10 20 0 1897316960 23143600 3047360
21:00:44 74293 8192000000 10856924288 11311718400 1857256896 18.481 96 9 18 1 1868431040 9256048 1918096
21:02:18 113242 8192000000 10871879696 11334287360 1926462864 19.039 99 13 26 0 1941050912 10559456 4028592
21:04:23 35053 8192000000 10884308384 11338387456 1951543040 19.239 100 18 36 2 1962885168 6484848 4857280
21:05:15 2975 8192000000 10886359232 11340804096 1960706560 19.312 100 23 46 4 1974331280 7256768 6367952
21:05:24 35574 8192000000 10902338752 11348021248 1965123968 19.347 100 54 108 0 1990025552 8706368 16195216
21:06:09 60117 8192000000 10894737616 11356311552 1943848208 19.177 99 16 32 1 1958115360 9117936 5149216
21:07:50 30293 8192000000 10907472448 11362848768 1978381392 19.452 100 54 108 3 2010188304 15364896 16442016
21:09:10 55864 8192000000 10868611040 11351941120 1927657088 19.048 99 3 6 0 1946938032 18556768 724176
21:10:11 4772 8192000000 10878983616 11352084480 1954607616 19.263 100 14 26 1 1970881440 12223328 4050496
21:10:27 69878 8192000000 10872952352 11339030528 1947202048 19.204 99 14 28 1 1959708288 8492672 4013568
21:12:14 51438 8192000000 10869992320 11330732032 1933166480 19.092 99 13 26 0 1948299040 10800592 4331968
21:13:14 34114 8192000000 10882216992 11354824704 1961924768 19.321 100 12 24 2 1973394016 7936992 3532256
21:13:59 100508 8192000000 10884474144 11351781376 1964600976 19.343 100 23 46 0 1979393744 8060144 6732624
21:15:50 79428 8192000000 10897543952 11370119168 1975942000 19.433 100 18 36 0 1988566608 7637728 4986880
21:17:16 55854 8192000000 10897578288 11367735296 1968032512 19.370 99 18 36 1 1980963056 7791520 5139024
21:18:27 20914 8192000000 10888004416 11356360704 1956387936 19.277 99 25 50 2 1974136064 10397536 7350592
21:18:55 57381 8192000000 10897930896 11373113344 1982692224 19.486 100 12 24 1 1996121696 10178304 3251168
21:19:58 55359 8192000000 10904933712 11382005760 1981156960 19.474 100 8 16 0 1993799936 10632192 2010784
21:21:23 68338 8192000000 10898440288 11389169664 1985079216 19.505 100 18 36 0 2005377680 14883488 5414976
21:22:38 53271 8192000000 10894324784 11370631168 1933064368 19.091 97 23 45 1 1946756032 7503920 6187744
21:23:39 66378 8192000000 10910707776 11386470400 1981238016 19.474 100 19 38 2 1997216896 10590080 5388800
21:24:52 44757 8192000000 10912414096 11384553472 1984074608 19.497 100 16 32 1 1998357296 10019360 4263328
21:25:49 34436 8192000000 10925179504 11387600896 1977987664 19.449 99 31 62 1 1996772032 9812304 8972064
21:26:44 30543 8192000000 10905589184 11373019136 1950760144 19.233 98 18 35 3 1963097552 7149968 5187440
21:27:24 24824 8192000000 10913222240 11366559744 1933818800 19.097 97 36 71 0 1951991152 8789696 9382656
21:27:58 47902 8192000000 10879911392 11358789632 1929072976 19.059 98 33 65 2 1949120944 11402176 8645792
21:28:52 61936 8192000000 10876477664 11342647296 1871450400 18.596 95 13 26 0 1884345200 9670640 3224160
21:30:01 61461 8192000000 10881242144 11355033600 1887617488 18.727 96 23 46 0 1907342800 13145184 6580128
21:31:12 111371 8192000000 10895801216 11359772672 1853012768 18.447 94 13 26 0 1870521216 14228960 3279488
21:33:11 37782 8192000000 10885845840 11346526208 1907262432 18.885 97 25 50 0 1923958816 10097728 6598656
21:33:57 78927 8192000000 10868154992 11336404992 1843202608 18.367 94 16 31 0 1857383536 10043808 4137120
21:35:22 62285 8192000000 10869826336 11338555392 1863740576 18.534 96 14 28 1 1877628752 10235456 3652720
21:36:38 137354 8192000000 10851339552 11320082432 1809146960 18.089 93 20 41 1 1834190256 19566208 5477088
21:39:01 97408 8192000000 10867648032 11334582272 1900233856 18.828 98 24 48 1 1913851792 6914736 6703200
21:41:01 23683 8192000000 10886735904 11335413760 1916459776 18.958 98 38 76 2 1935617024 9053904 10103344
21:41:31 30255 8192000000 10853283248 11314302976 1868702480 18.574 96 30 60 1 1888238144 9774592 9761072
21:42:16 37809 8192000000 10847514496 11325870080 1916769136 18.961 99 11 22 0 1929368288 9521472 3077680
21:43:48 46958 8192000000 10828225120 11302969344 1868799696 18.575 97 8 16 0 1880299792 9269392 2230704
21:44:41 76014 8192000000 10853444800 11327647744 1910030128 18.907 99 11 22 1 1923597376 10241408 3325840
21:46:24 71371 8192000000 10850178304 11315703808 1872759744 18.607 97 10 20 0 1889364320 13578544 3026032
21:47:41 40109 8192000000 10860331904 11333242880 1911928576 18.922 99 16 32 0 1928192416 11560848 4702992
21:48:31 53325 8192000000 10859056688 11322875904 1896911648 18.801 98 19 38 0 1911799776 9396688 5491440
21:49:31 54370 8192000000 10818873760 11297443840 1866935392 18.559 97 25 50 0 1887939168 12987920 8015856
21:50:34 61028 8192000000 10853900064 11313627136 1885524576 18.710 98 12 25 4 1897897296 8908288 3464432
21:51:59 44056 8192000000 10877966352 11342209024 1919279520 18.981 99 20 38 1 1938795616 13524512 5991584
21:52:54 48644 8192000000 10876182912 11349676032 1946255808 19.197 100 19 38 0 1966627568 14775360 5596400
21:54:17 95680 8192000000 10868393120 11344224256 1864059248 18.536 96 23 46 0 1889173600 18461712 6652640
21:55:59 70401 8192000000 10869676896 11354198016 1906829120 18.881 98 15 30 2 1926537168 15657440 4050608
21:57:15 124245 8192000000 10893068448 11361329152 1915610320 18.952 98 10 20 0 1935087504 16943328 2533856
21:59:31 74609 8192000000 10895444432 11375083520 1961431168 19.317 99 21 42 1 1977981968 10881696 5669104
22:00:52 86206 8192000000 10896476464 11358478336 1958802560 19.297 99 35 69 0 1975268880 6751424 9714896
22:02:42 41374 8192000000 10867149888 11347070976 1934589552 19.104 98 12 24 1 1943713264 6164208 2959504
22:03:30 94031 8192000000 10897252688 11385487360 1981472496 19.476 100 10 20 0 1993343904 8864096 3007312
22:05:11 92181 8192000000 10900270256 11398881280 1990412080 19.547 100 12 24 0 2004330464 10359632 3558752
22:06:49 73843 8192000000 10925490240 11399938048 1980704816 19.470 99 18 36 0 1999058992 13129808 5224368
22:08:11 102095 8192000000 10896932416 11388559360 1957440720 19.286 98 10 20 0 1972548064 12714000 2393344
22:10:00 40225 8192000000 10905132368 11379941376 1951505808 19.238 98 11 22 0 1961092560 6729248 2857504
22:10:46 32992 8192000000 10911314800 11386134528 1978349408 19.452 99 24 48 2 1993297664 8392656 6555600
22:11:31 60590 8192000000 10933084288 11392217088 1938477472 19.135 97 27 55 0 1953948960 7807136 7664352
22:12:37 56794 8192000000 10901264192 11378544640 1946102128 19.195 98 13 26 2 1958780224 8933552 3744544
22:13:45 41978 8192000000 10917106224 11376037888 1954181168 19.260 98 33 65 2 1971990608 8724624 9084816
22:14:33 45946 8192000000 10904529328 11366404096 1915558848 18.951 96 29 58 2 1937078768 13470960 8048960
22:15:30 115445 8192000000 10907318384 11381211136 1899440368 18.822 96 11 22 0 1921446048 18855728 3149952
22:17:42 25669 8192000000 10920787824 11373457408 1945744784 19.193 98 36 71 3 1964727904 8762416 10220704
22:18:15 45963 8192000000 10891054496 11355619328 1903388096 18.854 96 27 54 0 1921480560 10737104 7355360
22:19:07 66892 8192000000 10913228240 11394842624 1963839248 19.337 99 16 32 1 1980642720 12655712 4147760
22:20:28 94660 8192000000 10828123648 11294216192 1794298864 17.967 91 20 40 0 1807063648 6924112 5840672
22:22:09 78940 8192000000 10872794336 11352276992 1936930384 19.122 100 18 36 0 1954135664 12164128 5041152
22:23:34 49300 8192000000 10887734944 11356913664 1958450832 19.294 100 11 22 0 1974389328 12475648 3462848
22:24:34 67233 8192000000 10871741600 11362439168 1945055280 19.187 99 12 24 0 1958110048 9325616 3729152
22:25:48 65680 8192000000 10891458736 11364155392 1950903520 19.234 99 6 12 0 1960576752 8142656 1530576
22:26:59 32554 8192000000 9757487024 10119839744 900083936 9.899 46 2 3 0 905064448 4537856 442656

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-03-2021 22:29:35 to 14-03-2021 22:30:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 67 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 14-03-2021 22:30:07 to 14-03-2021 22:30: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          237316
MON$OLDEST_ACTIVE               237317
MON$OLDEST_SNAPSHOT             237317
MON$NEXT_TRANSACTION            237317
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                       2022848
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
--- end of diff output ---

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

14.03.21 22:30: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-03-14 22:30:13 No severe PSQL-related problems occured
14.03.21 22:30:14. End of report.