Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.03.2021 19: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 17552260 kB
MemAvailable 31570052 kB
Buffers 0 kB
Cached 14159088 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-20 19:27:26
DTS_END                         2021-03-20 19:27:26.7740
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/56804
TRN_ID                          238704
ATT_ID                          671
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: 9029.60 23170 1083552
customer order: creation 172.25 376 20670
customer order: refuse 14.33 321 1720
order to supplier: creation 45.11 1293 5413
order to supplier: removal 3.20 121140 384
invoice (draft): creation 45.74 3881 5489
invoice (draft): removal 50.37 909 6044
invoice accept: apply 41.56 18288 4987
invoice accept: cancel 45.74 835 5489
customer reserve: creation 3818.59 181 458231
customer reserve: removal 4495.65 68 539478
realization accept: apply 83.94 181 10073
realization accept: cancel 82.63 124 9915
payment from customer: creation 59.00 125 7080
payment from customer: removal 5.83 96 700
payment to supplier: creation 49.63 128 5955
payment to supplier: removal 3.41 86 409
service: total inventory turnovers 5.04 1114 605
service: total monetary turnovers 6.72 26 806
service: aggregate perf. data 0.83 23171 100
service: refresh index statistics 0.03 291056 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-03-2021 19:29:07 to 20-03-2021 19:29:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2610
TEST_TIME 2 4055
TEST_TIME 3 4259
TEST_TIME 4 6025
TEST_TIME 5 6034
TEST_TIME 6 6754
TEST_TIME 7 6651
TEST_TIME 8 6364
TEST_TIME 9 6638
TEST_TIME 10 6467
TEST_TIME 11 6354
TEST_TIME 12 6328
TEST_TIME 13 6476
TEST_TIME 14 6529
TEST_TIME 15 6515
TEST_TIME 16 6843
TEST_TIME 17 6987
TEST_TIME 18 7221
TEST_TIME 19 7334
TEST_TIME 20 8009
TEST_TIME 21 8440
TEST_TIME 22 8412
TEST_TIME 23 8715
TEST_TIME 24 8893
TEST_TIME 25 9164
TEST_TIME 26 9412
TEST_TIME 27 9755
TEST_TIME 28 11083
TEST_TIME 29 11311
TEST_TIME 30 11157
TEST_TIME 31 10918
TEST_TIME 32 10828
TEST_TIME 33 10663
TEST_TIME 34 10499
TEST_TIME 35 10295
TEST_TIME 36 10172
TEST_TIME 37 10162
TEST_TIME 38 10217
TEST_TIME 39 10095
TEST_TIME 40 9977
TEST_TIME 41 9939
TEST_TIME 42 9928
TEST_TIME 43 9865
TEST_TIME 44 9753
TEST_TIME 45 9662
TEST_TIME 46 9549
TEST_TIME 47 9487
TEST_TIME 48 9417
TEST_TIME 49 9314
TEST_TIME 50 9349
TEST_TIME 51 9298
TEST_TIME 52 9331
TEST_TIME 53 9365
TEST_TIME 54 9330
TEST_TIME 55 9340
TEST_TIME 56 9272
TEST_TIME 57 9154
TEST_TIME 58 9110
TEST_TIME 59 8990
TEST_TIME 60 8937
TEST_TIME 61 8932
TEST_TIME 62 8955
TEST_TIME 63 8926
TEST_TIME 64 9021
TEST_TIME 65 9022
TEST_TIME 66 9051
TEST_TIME 67 9112
TEST_TIME 68 9166
TEST_TIME 69 9192
TEST_TIME 70 9166
TEST_TIME 71 9259
TEST_TIME 72 9248
TEST_TIME 73 9189
TEST_TIME 74 9342
TEST_TIME 75 9350
TEST_TIME 76 9283
TEST_TIME 77 9202
TEST_TIME 78 9131
TEST_TIME 79 9141
TEST_TIME 80 9079
TEST_TIME 81 9043
TEST_TIME 82 8986
TEST_TIME 83 9040
TEST_TIME 84 9019
TEST_TIME 85 8980
TEST_TIME 86 9071
TEST_TIME 87 9094
TEST_TIME 88 9104
TEST_TIME 89 9119
TEST_TIME 90 9089
TEST_TIME 91 9089
TEST_TIME 92 9086
TEST_TIME 93 9089
TEST_TIME 94 9178
TEST_TIME 95 9213
TEST_TIME 96 9294
TEST_TIME 97 9216
TEST_TIME 98 9155
TEST_TIME 99 9139
TEST_TIME 100 9146
TEST_TIME 101 9080
TEST_TIME 102 9016
TEST_TIME 103 8996
TEST_TIME 104 9052
TEST_TIME 105 9058
TEST_TIME 106 9049
TEST_TIME 107 9069
TEST_TIME 108 9079
TEST_TIME 109 9040
TEST_TIME 110 9064
TEST_TIME 111 9067
TEST_TIME 112 9079
TEST_TIME 113 9124
TEST_TIME 114 9088
TEST_TIME 115 9088
TEST_TIME 116 9160
TEST_TIME 117 9141
TEST_TIME 118 9106
TEST_TIME 119 9101
TEST_TIME 120 9030

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-03-2021 19:29:11 to 20-03-2021 19:29:14.

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 1508130 1508130 0 0.00 0 21400 7 0 0
doc_list_biud 1508127 1508127 0 0.00 0 27642 31 0 0
sp_add_invoice_to_stock 5108 4987 121 2.36 22 178635 18288 0 121
sp_cancel_adding_invoice 5489 5489 0 0.00 5 85799 835 0 0
sp_cancel_client_order 1720 1720 0 0.00 4 8129 322 0 0
sp_cancel_customer_reserve 539478 539478 0 0.00 1 27643 68 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 3 6524 96 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 5926 86 0 0
sp_cancel_supplier_invoice 6054 6044 10 0.16 1 13708 909 0 10
sp_cancel_supplier_order 384 384 0 0.00 6 1216006 121140 0 0
sp_cancel_write_off 9915 9915 0 0.00 1 9177 125 0 0
sp_client_order 20670 20670 0 0.00 3 78412 377 0 0
sp_customer_reserve 458231 458231 0 0.00 0 72099 181 0 0
sp_fill_shopping_cart 31550 31550 0 0.00 1 34054 46 0 0
sp_fill_shopping_cart_clo_res 458231 458231 0 0.00 0 17247 15 0 0
sp_get_clo_for_invoice 4987 4987 0 0.00 0 23813 379 0 0
sp_kill_cost_storno 16513 16513 0 0.00 0 9273 62 0 0
sp_kill_qstorno_ret_qs2qd 1095299 1095299 0 0.00 0 27624 37 0 0
sp_kill_qty_storno 578087 578087 0 0.00 0 27641 79 0 0
sp_lock_selected_doc 20848 20848 0 0.00 0 6326 5 0 0
sp_make_cost_storno 28095 28095 0 0.00 0 21283 56 0 0
sp_multiply_rows_for_pdistr 28093 28093 0 0.00 0 9069 31 0 0
sp_multiply_rows_for_qdistr 20670 20670 0 0.00 0 78369 172 0 0
sp_pay_from_customer 7080 7080 0 0.00 4 22712 125 0 0
sp_pay_to_supplier 5955 5955 0 0.00 5 21424 128 0 0
sp_payment_common 13035 13035 0 0.00 1 22689 29 0 0
sp_qd_handle_on_cancel_clo 1720 1720 0 0.00 0 8124 296 0 0
sp_qd_handle_on_invoice_upd_sts 10475 10475 0 0.00 0 23424 351 0 0
sp_qd_handle_on_reserve_upd_sts 10071 10071 0 0.00 0 12174 53 0 0
sp_reserve_write_off 10073 10073 0 0.00 6 14611 181 0 0
sp_supplier_invoice 5489 5489 0 0.00 5 99002 3882 0 0
sp_supplier_order 5413 5413 0 0.00 6 60203 1294 0 0
srv_aggregate_perf_data 100 100 0 0.00 2299 497265 23171 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1384 132164 28871 0 0
srv_find_qd_qs_mism 1036045 1036045 0 0.00 0 9133 6 0 0
srv_make_invnt_saldo 605 605 0 0.00 30 59460 1114 0 0
srv_make_money_saldo 806 806 0 0.00 1 2064 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 180901 521988 291057 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4987 4987 0 0.00 0 10785 222 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 2590 77 0 0
t$perf-norm:sp_cancel_client_order 1720 1720 0 0.00 0 3898 22 0 0
t$perf-norm:sp_cancel_customer_reserve 728 728 0 0.00 0 1000 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 1653 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 566 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 5537 36 0 0
t$perf-norm:sp_cancel_supplier_order 384 384 0 0.00 0 20399 1819 0 0
t$perf-norm:sp_cancel_write_off 1040 1040 0 0.00 0 4903 11 0 0
t$perf-norm:sp_client_order 20670 20670 0 0.00 0 10412 21 0 0
t$perf-norm:sp_customer_reserve 1024 1024 0 0.00 0 3942 18 0 0
t$perf-norm:sp_pay_from_customer 7080 7080 0 0.00 0 8773 20 0 0
t$perf-norm:sp_pay_to_supplier 5955 5955 0 0.00 0 9150 14 0 0
t$perf-norm:sp_reserve_write_off 10073 10073 0 0.00 0 10535 17 0 0
t$perf-norm:sp_supplier_invoice 5489 5489 0 0.00 0 10532 22 0 0
t$perf-norm:sp_supplier_order 5413 5413 0 0.00 0 7133 25 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 182 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 1759 32 0 0
t$perf-norm:srv_make_invnt_saldo 605 605 0 0.00 0 1268 26 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 1134 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 40 11 0 0
v_add_invoice_to_stock 10214 9972 242 2.36 0 7341 21 0 242
v_all_customers 37514 37514 0 0.00 0 22 1 0 0
v_all_suppliers 30340 30340 0 0.00 0 113 1 0 0
v_all_wares 41340 41340 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 1859 11 0 0
v_cancel_client_order 3440 3440 0 0.00 0 7235 5 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 5047 9 0 0
v_cancel_customer_reserve 1456 1456 0 0.00 0 2928 7 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 5914 11 0 0
v_cancel_supplier_invoice 820 800 20 2.43 0 419 13 0 20
v_cancel_supplier_order 768 768 0 0.00 0 727 4 0 0
v_cancel_write_off 2080 2080 0 0.00 0 6773 20 0 0
v_max_id_clo_ord 5412 5412 0 0.00 0 396 1 0 0
v_max_id_clo_res 1024 1024 0 0.00 0 2175 10 0 0
v_max_id_ord_sup 5466 5466 0 0.00 0 5278 5 0 0
v_max_non_paid_invoice 1663 1663 0 0.00 0 130 2 0 0
v_max_non_paid_realizn 3944 3944 0 0.00 0 5324 5 0 0
v_min_id_clo_ord 5412 5412 0 0.00 0 3059 7 0 0
v_min_id_clo_res 1024 1024 0 0.00 0 7157 19 0 0
v_min_id_ord_sup 5466 5466 0 0.00 0 4484 6 0 0
v_min_non_paid_invoice 5955 5955 0 0.00 0 7860 15 0 0
v_min_non_paid_realizn 7080 7080 0 0.00 0 8457 18 0 0
v_our_firm 10098 10098 0 0.00 0 18 1 0 0
v_reserve_write_off 20142 20142 0 0.00 0 6749 7 0 0
x_lock_depdocs_on_canc_invoice 11133 11133 0 0.00 0 11649 124 0 0
x_lock_depdocs_on_canc_sup_ord 384 384 0 0.00 0 3456 396 0 0
x_make_qstorno_1000_1200 5413 5413 0 0.00 2 60196 1212 0 0
x_make_qstorno_1200_2000 5489 5489 0 0.00 3 98979 3700 0 0
x_make_qstorno_2100_3300 458231 458231 0 0.00 0 72098 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2021 19:29:15 to 20-03-2021 19:29:19.

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
16:57:30 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:36 11583 8192000000 10162648576 10449661952 740368448 8.288 61 47 98 0 758770224 2144784 16256992
16:57:56 41153 8192000000 10341687712 10654728192 1368110496 14.310 100 85 170 0 1400173232 4085392 27977344
16:58:58 30489 8192000000 10385765968 10706759680 1436107968 14.915 100 90 180 1 1472603520 6938160 29557392
16:59:37 27152 8192000000 10411365520 10738233344 1464711776 15.167 100 95 190 1 1503017200 7833264 30472160
17:00:12 22545 8192000000 10435955440 10762850304 1481945552 15.318 100 86 171 0 1517121696 8345536 26830608
17:01:00 22825 8192000000 10458117904 10792120320 1507848864 15.545 100 87 174 1 1544732816 9314800 27569152
17:01:31 23884 8192000000 10489767232 10828673024 1536775680 15.796 100 87 174 1 1573648800 9732784 27140336
17:02:05 21043 8192000000 10505635680 10851831808 1563681952 16.028 100 85 169 1 1600820416 10661040 26477424
17:02:37 14230 8192000000 10535719344 10887634944 1588165920 16.238 100 79 158 0 1623300304 11439312 23695072
17:03:00 15644 8192000000 10558402208 10916687872 1613762272 16.457 100 80 160 1 1649328768 11552640 24013856
17:03:24 10919 8192000000 10585338560 10944733184 1639777520 16.678 100 73 146 1 1672720080 11279504 21663056
17:03:46 7728 8192000000 10600863312 10965360640 1665020128 16.891 100 79 158 1 1699980176 11810912 23149136
17:04:04 6246 8192000000 10618152048 10983923712 1679085296 17.010 100 81 160 0 1714735216 12056304 23593616
17:04:18 10552 8192000000 10642145040 11010142208 1694924480 17.143 100 76 152 1 1729129760 12069120 22136160
17:04:37 8594 8192000000 10655027952 11025580032 1714964752 17.310 100 82 164 0 1752430864 13154160 24311952
17:04:53 7107 8192000000 10666421872 11044585472 1733231280 17.462 100 76 151 0 1766062960 11968832 20862848
17:05:07 6618 8192000000 10692276752 11063869440 1747840304 17.584 100 83 166 0 1783099936 11704448 23555184
17:05:21 7166 8192000000 10690854880 11067789312 1756496176 17.655 100 81 160 2 1791405584 11980112 22929296
17:05:35 3410 8192000000 10706393952 11081785344 1768494256 17.755 100 82 165 0 1804537920 12933472 23110192
17:05:45 5291 8192000000 10718914528 11095994368 1776848064 17.824 100 78 156 0 1811629824 12242624 22539136
17:05:57 4064 8192000000 10725125600 11101310976 1788963520 17.923 100 83 165 1 1824759968 12811248 22985200
17:06:08 2941 8192000000 10729711216 11107827712 1791672560 17.946 100 83 165 1 1827759728 13466624 22620544
17:06:18 2911 8192000000 10739126208 11119144960 1802836176 18.037 100 85 170 1 1840749648 14148464 23765008
17:06:27 3226 8192000000 10740844976 11120627712 1804563872 18.051 100 90 180 1 1843890704 14493680 24833152
17:06:37 2652 8192000000 10748326656 11131351040 1808813728 18.086 100 91 183 1 1849461392 14585392 26062272
17:06:47 6629 8192000000 10741908672 11132497920 1807547472 18.076 100 71 139 2 1840815824 14091456 19176896
17:07:00 4430 8192000000 10759200096 11147169792 1817505056 18.157 100 77 154 2 1852154640 13537984 21111600
17:07:11 2468 8192000000 10779250592 11164811264 1836211216 18.310 100 85 168 0 1873319296 12392528 24715552
17:07:20 2524 8192000000 10782148128 11163447296 1838264912 18.327 100 93 184 0 1877612960 14045440 25302608
17:07:29 1835 8192000000 10786061664 11172757504 1843685792 18.371 100 92 180 2 1884876736 15130240 26060704
17:07:37 2614 8192000000 10792109008 11178668032 1848356096 18.409 100 94 188 1 1890157856 15931328 25870432
17:07:46 2552 8192000000 10795156656 11185614848 1855998688 18.471 100 91 182 0 1896118128 14668832 25450608
17:07:55 2961 8192000000 10801832416 11188105216 1856008000 18.471 100 84 168 0 1893551648 13450976 24092672
17:08:04 1782 8192000000 10802502928 11187523584 1862432544 18.523 100 89 179 2 1900964720 13299456 25232720
17:08:12 1907 8192000000 10808357696 11195482112 1863277840 18.530 100 86 172 3 1900494608 12972928 24243840
17:08:21 1324 8192000000 10810999888 11200765952 1868613328 18.573 100 90 176 0 1906584224 12555440 25415456
17:08:28 4677 8192000000 10798872208 11205832704 1872158000 18.602 100 84 168 0 1907810768 11435312 24217456
17:08:51 7722 8192000000 10808972000 11208425472 1866611728 18.557 100 66 132 1 1894930592 10432576 17886288
17:09:05 5254 8192000000 10790569600 11207311360 1867488592 18.564 100 47 94 0 1894996912 14614768 12893552
17:09:17 3205 8192000000 10804985952 11205537792 1872180592 18.602 100 52 101 1 1894293776 7079824 15033360
17:09:27 9466 8192000000 10781149392 11202920448 1869461696 18.580 100 27 54 2 1883980592 7003648 7515248
17:09:42 7783 8192000000 10792676528 11206909952 1871156960 18.594 100 33 66 1 1887572224 7114656 9300608
17:09:59 4190 8192000000 10801791456 11217920000 1884162976 18.699 100 41 79 0 1901931520 7170352 10598192
17:10:12 8424 8192000000 10803833040 11228741632 1882682752 18.687 100 16 32 1 1898170544 10926304 4561488
17:10:27 7668 8192000000 10798157552 11228192768 1887750208 18.728 100 30 61 1 1903275728 6901312 8624208
17:10:41 5283 8192000000 10803628640 11228991488 1891435392 18.757 100 29 58 3 1906602288 7414816 7752080
17:10:53 6869 8192000000 10808089184 11233849344 1893018288 18.770 100 28 57 1 1908619168 7619072 7981808
17:11:08 6222 8192000000 10799785952 11237613568 1893951424 18.778 100 20 40 2 1905679008 6519968 5207616
17:11:21 10812 8192000000 10800543232 11236626432 1894512976 18.782 100 14 26 1 1903688112 5634720 3540416
17:11:38 9205 8192000000 10815614752 11240210432 1899007216 18.818 100 33 66 0 1914860528 5940544 9912768
17:11:56 73186 8192000000 10802477056 11244998656 1903824688 18.857 100 39 77 1 1921245472 5602528 11818256
17:13:15 9372 8192000000 10818256096 11253182464 1900741280 18.832 100 19 38 0 1916183920 10355088 5087552
17:13:32 4253 8192000000 10830799952 11254411264 1905712080 18.872 100 42 85 1 1924779280 7267472 11799728
17:13:46 8645 8192000000 10823968352 11255865344 1906610448 18.879 100 33 61 2 1922102528 6033456 9458624
17:14:06 10739 8192000000 10815699920 11249795072 1901874832 18.841 100 18 36 0 1912503536 5923520 4705184
17:14:24 6845 8192000000 10817065456 11256516608 1906588304 18.879 100 22 43 1 1918740240 5622432 6529504
17:14:38 10381 8192000000 10829746944 11265462272 1912013936 18.923 100 23 46 5 1924069808 5453488 6602384
17:14:55 12466 8192000000 10831406880 11266330624 1912540832 18.927 100 15 30 0 1922868624 5887792 4440000
17:15:18 7545 8192000000 10830633904 11265150976 1912548992 18.927 100 20 38 2 1923016496 4849008 5618496
17:15:34 3733 8192000000 10826528336 11263205376 1910957088 18.914 100 17 34 3 1921745792 5491344 5297360
17:15:44 6623 8192000000 10827218800 11261677568 1896738208 18.800 99 20 40 1 1908339632 6282592 5318832
17:16:01 10475 8192000000 10833546352 11265974272 1913396288 18.934 100 23 45 4 1929418256 9601808 6420160
17:16:19 23157 8192000000 10800895888 11237187584 1837006192 18.316 96 21 35 3 1848261632 4429840 6825600
17:16:48 63321 8192000000 10770894016 11206303744 1821697280 18.192 96 29 58 4 1834970048 4584880 8687888
17:17:59 19267 8192000000 10770742656 11189145600 1731247248 17.446 92 21 41 1 1741554496 5016192 5291056
17:18:27 6122 8192000000 10749187952 11177644032 1816210704 18.147 98 34 68 1 1833419264 7209440 9999120
17:18:42 4644 8192000000 10769115920 11198943232 1857265168 18.481 100 44 88 0 1877713264 7920704 12527392
17:18:54 4358 8192000000 10727720800 11155722240 1791570192 17.945 97 41 82 6 1809125472 5889136 11666144
17:19:05 7438 8192000000 10732690432 11148550144 1766628992 17.739 96 35 70 0 1782719136 5484160 10605984
17:19:21 6921 8192000000 10713652640 11130060800 1768556144 17.755 98 30 60 1 1787340128 10187936 8596048
17:19:36 7240 8192000000 10703121856 11119927296 1731451728 17.448 96 25 50 2 1743942944 5396096 7095120
17:19:53 5649 8192000000 10692849056 11115212800 1771699552 17.781 98 23 47 1 1783454368 5598000 6156816
17:20:09 8827 8192000000 10693623616 11105775616 1723271456 17.379 95 32 64 0 1738313872 6131056 8911360
17:20:24 9144 8192000000 10693584048 11112742912 1748848848 17.592 97 29 57 3 1762996528 5898176 8249504
17:20:39 8495 8192000000 10671880864 11083378688 1687242096 17.078 94 18 34 0 1697006832 5061888 4702848
17:20:54 8235 8192000000 10687314944 11096756224 1732231648 17.454 97 21 41 3 1743186144 5127136 5827360
17:21:11 6581 8192000000 10703161600 11112902656 1751893600 17.617 98 28 54 1 1766038320 5567152 8577568
17:21:28 18100 8192000000 10706920064 11112181760 1742472256 17.539 97 30 61 1 1757897760 5207792 10217712
17:21:54 68109 8192000000 10718157952 11141951488 1778095344 17.834 98 34 68 0 1794124944 5955584 10074016
17:23:11 5490 8192000000 10735378016 11153354752 1817626592 18.158 100 34 65 2 1833599264 7097392 8875280
17:23:26 5297 8192000000 10749186480 11155025920 1809382192 18.091 99 46 92 1 1828224112 6037872 12804048
17:23:39 4283 8192000000 10754493008 11168923648 1830683872 18.265 100 36 72 1 1848524272 7852912 9987488
17:23:50 6439 8192000000 10757616432 11178659840 1839677520 18.338 100 31 62 0 1855110816 6121376 9311920
17:24:08 6091 8192000000 10759466544 11179024384 1839779392 18.339 100 28 56 0 1854142960 5373728 8989840
17:24:21 8095 8192000000 10762132432 11185012736 1844936608 18.381 100 29 57 1 1859373408 5424688 9012112
17:24:37 7731 8192000000 10765737120 11190484992 1846842512 18.396 100 23 46 1 1858492160 5315904 6333744
17:24:51 6797 8192000000 10764024480 11192365056 1849447248 18.418 100 16 31 1 1859280032 5063232 4769552
17:25:06 5477 8192000000 10770488944 11201384448 1856231904 18.473 100 23 46 3 1868896976 6247488 6417584
17:25:21 12116 8192000000 10764388992 11193741312 1840738912 18.347 99 29 58 1 1863203520 14077264 8387344
17:25:42 5931 8192000000 10777124896 11200319488 1856311328 18.473 100 20 40 1 1867134736 5390992 5432416
17:25:56 9223 8192000000 10781878944 11205750784 1857534336 18.483 100 25 50 1 1874383040 9651232 7197472
17:26:15 12135 8192000000 10762696256 11199492096 1856979136 18.479 100 20 40 1 1868161536 5645008 5537392
17:26:38 99773 8192000000 10822127968 11239964672 1882072320 18.682 100 32 63 1 1896162768 5084032 9006416
17:28:27 13719 8192000000 10835292784 11251740672 1904062768 18.859 100 42 85 1 1923345616 6631760 12651088
17:28:52 16355 8192000000 10838441600 11261009920 1912670464 18.928 100 51 102 0 1937875408 10535600 14669344
17:29:27 9014 8192000000 10852930896 11272613888 1919643904 18.984 100 53 106 2 1944225008 10167792 14413312
17:29:47 14876 8192000000 10850421328 11279142912 1925891600 19.034 100 54 109 0 1956416752 14730480 15794672
17:30:09 5571 8192000000 10864027168 11285499904 1928670000 19.056 100 55 110 0 1958327984 14648880 15009104
17:30:24 10950 8192000000 10860563392 11287052288 1930703296 19.073 100 49 98 2 1955235776 10313552 14218928
17:30:49 15296 8192000000 10872279872 11298136064 1935911728 19.114 100 45 90 1 1960075616 11593696 12570192
17:31:14 5985 8192000000 10879970992 11300671488 1938828128 19.137 100 48 96 2 1964747168 11766256 14152784
17:31:26 2315 8192000000 10889395264 11308027904 1947091856 19.203 100 75 150 1 1979754096 11128544 21533696
17:31:36 20151 8192000000 10878412432 11311529984 1947867856 19.209 100 47 93 1 1971468320 10293792 13306672
17:32:03 7315 8192000000 10890888064 11318890496 1953373552 19.253 100 44 88 0 1979745568 12722896 13649120
17:32:17 4480 8192000000 10905520752 11326644224 1960067824 19.307 100 57 113 1 1989574848 13368528 16138496
17:32:30 3000 8192000000 10905618576 11329265664 1966053936 19.354 100 71 139 2 2001406512 14953328 20399248
17:32:41 18184 8192000000 10918946176 11339870208 1970705936 19.391 100 65 129 5 2001701904 13894992 17100976
17:33:08 2161 8192000000 10921675712 11331944448 1968593408 19.374 100 89 174 1 2006928640 15013392 23321840
17:33:17 2999 8192000000 10921046592 11333951488 1967504752 19.366 100 79 157 2 2005828112 16103696 22219664
17:33:27 5037 8192000000 10908453136 11332251648 1968846848 19.376 100 60 119 1 2000495664 15207296 16441520
17:33:39 3076 8192000000 10923746528 11343724544 1975255376 19.427 100 76 151 1 2012782048 15568720 21957952
17:33:48 2252 8192000000 10930345568 11353079808 1981019680 19.473 100 78 153 2 2018783632 15484480 22279472
17:34:06 13063 8192000000 10926116064 11354750976 1984371248 19.499 100 57 112 1 2015151568 14691088 16089232
17:34:32 3187 8192000000 10934995712 11362353152 1994080384 19.576 100 74 148 4 2028791360 13639680 21071296
17:34:43 16022 8192000000 10930452720 11360559104 1974096864 19.418 99 52 104 0 2004379328 15308960 14973504
17:35:07 18281 8192000000 10944115104 11372457984 1994677264 19.581 100 61 120 1 2029155056 16361920 18115872
17:35:37 15261 8192000000 10945588368 11384745984 1999192992 19.616 100 50 100 0 2035856944 21781792 14882160
17:36:02 4848 8192000000 10948145872 11386462208 2004511920 19.658 100 54 108 1 2047032576 25803760 16716896
17:36:15 11816 8192000000 10959135216 11397697536 2007956656 19.685 100 60 120 2 2057090240 30867872 18265712
17:36:40 6761 8192000000 10952900656 11394600960 2007858592 19.685 100 61 118 2 2045331568 19988608 17484368
17:37:02 7881 8192000000 10981269792 11406299136 2019725968 19.778 100 64 127 0 2062315456 23330544 19258944
17:37:17 2467 8192000000 10979455312 11403067392 2015359360 19.744 100 80 156 3 2062531200 23900464 23271376
17:37:27 4799 8192000000 10969187856 11397980160 1998068672 19.608 99 68 135 0 2043266912 25231440 19966800
17:37:40 13502 8192000000 10973583056 11399819264 2012407072 19.720 100 71 140 0 2060400624 26796000 21197552
17:38:01 2777 8192000000 10962288976 11389243392 2003599440 19.651 100 64 128 3 2050517104 27981648 18936016
17:38:11 5734 8192000000 10966667872 11392045056 2003628432 19.651 100 74 147 2 2055269744 28872480 22768832
17:38:27 13651 8192000000 10951125792 11389071360 1996425360 19.595 100 61 121 2 2044344896 28686464 19233072
17:38:54 4601 8192000000 10966319040 11398066176 1988158848 19.529 99 55 108 1 2034242272 29313936 16769488
17:39:08 3048 8192000000 10960096832 11382902784 1994032800 19.576 100 73 147 1 2046873056 30440464 22399792
17:39:19 5063 8192000000 10960952832 11393785856 1999014400 19.615 100 62 124 0 2051075664 33059632 19001632
17:39:37 12738 8192000000 10962361760 11389280256 1993780288 19.574 100 69 135 2 2051050800 35550240 21720272
17:40:04 5121 8192000000 10917576928 11352137728 1960541920 19.310 99 47 94 0 2009721280 34220944 14958416
17:40:17 11307 8192000000 10925190112 11362123776 1966471184 19.357 100 43 85 1 2014396880 34282608 13643088
17:40:41 2557 8192000000 10969481168 11386376192 1989814528 19.542 100 72 145 1 2047703504 35351808 22537168
17:40:52 5860 8192000000 10970104400 11396653056 1997716880 19.605 100 67 134 0 2055411408 36801568 20892960
17:41:05 3041 8192000000 10991512656 11414028288 2008939920 19.693 100 78 153 0 2070317408 38022672 23354816
17:41:18 2977 8192000000 10974781792 11393466368 1991023344 19.552 99 73 146 1 2052550384 39121216 22405824
17:41:28 5308 8192000000 10978376256 11402039296 2000601536 19.627 100 80 157 0 2063809008 39034208 24173264
17:41:43 4966 8192000000 10973527920 11390955520 1996976640 19.599 100 90 177 1 2062818384 38411552 27430192
17:41:55 7237 8192000000 10979934128 11406893056 2002201168 19.640 100 70 138 1 2063814272 40276208 21336896
17:42:09 2731 8192000000 10966422880 11380146176 1979707488 19.462 99 75 148 2 2043790960 40645408 23438064
17:42:19 5420 8192000000 10979532272 11399680000 2003101920 19.647 100 82 166 0 2070328752 41186000 26040832
17:42:32 1480 8192000000 10995596464 11408797696 2006970640 19.678 100 85 165 3 2074864464 41992560 25901264
17:42:41 6282 8192000000 10983683456 11408629760 2001895248 19.638 100 74 148 1 2069164240 43893184 23375808
17:42:57 3073 8192000000 10984088800 11411398656 2004316912 19.657 100 71 142 1 2071571792 44950304 22304576
17:43:14 8284 8192000000 10987472160 11410026496 2000142736 19.624 100 65 130 1 2071059376 49679312 21237328
17:43:29 2304 8192000000 10997408048 11413929984 2003036512 19.647 100 84 168 1 2076476720 47613952 25826256
17:43:38 1395 8192000000 10997496496 11419066368 2008559408 19.690 100 79 158 4 2081432736 48306160 24567168
17:43:47 4560 8192000000 10974066848 11394666496 1978696944 19.454 99 70 140 1 2045810704 44767936 22345824
17:44:00 1744 8192000000 10948173056 11358765056 1942704976 19.168 98 81 163 1 2014481840 46492592 25284272
17:44:10 4255 8192000000 10936230624 11353808896 1937220560 19.125 99 77 155 1 2011326576 50272752 23833264
17:44:22 2053 8192000000 10960236784 11374723072 1965232880 19.348 100 82 165 3 2043904832 51783616 26888336
17:44:32 4584 8192000000 10968883856 11386683392 1976900640 19.440 100 75 150 0 2051540032 51018768 23620624
17:44:43 2582 8192000000 10989673280 11398389760 1985201760 19.506 100 92 184 1 2065622512 52218480 28202272
17:44:54 4661 8192000000 10996709968 11407663104 1994906992 19.583 100 86 171 1 2075197504 52786336 27504176
17:45:06 1728 8192000000 10979173520 11390320640 1977136992 19.442 99 88 176 1 2056740096 51901120 27701984
17:45:15 5794 8192000000 10991844432 11410042880 1995096864 19.584 100 84 170 1 2074441584 52765200 26579520
17:45:31 3840 8192000000 10992176400 11411992576 1997306256 19.601 100 81 162 1 2075631248 52976464 25348528
17:45:49 4104 8192000000 10995474576 11416895488 1996116912 19.592 100 84 168 0 2079365648 55713968 27534768
17:46:00 3141 8192000000 11003304816 11419869184 1988443200 19.531 99 83 166 0 2073046944 58130592 26473152
17:46:10 2415 8192000000 10992451488 11405692928 1980109104 19.466 99 85 168 2 2068179040 61404896 26665040
17:46:22 3842 8192000000 11011115376 11425058816 1998896272 19.614 100 75 150 2 2085403088 62287632 24219184
17:46:32 2096 8192000000 11006467328 11415552000 1990112672 19.545 99 80 161 1 2077817616 61858096 25846848
17:46:43 4981 8192000000 10978453232 11392356352 1973685136 19.415 99 73 146 1 2062254032 64302448 24266448
17:46:55 4471 8192000000 10994205904 11419013120 1991066608 19.552 100 68 136 1 2078774640 65161104 22546928
17:47:08 1382 8192000000 11000953568 11408850944 1988307888 19.530 100 93 186 1 2083086880 64354768 30424224
17:47:16 3217 8192000000 10996218896 11406565376 1986806992 19.519 100 77 151 0 2071053632 59665392 24581248
17:47:31 2302 8192000000 11004950272 11421261824 1999643488 19.620 100 81 162 0 2089338976 62381744 27313744
17:47:40 6181 8192000000 10996561840 11424591872 2001842656 19.637 100 61 123 1 2079309040 57721440 19744944
17:48:15 17097 8192000000 10981322160 11431665664 1987558096 19.524 99 36 72 0 2056908656 56846864 12503696
17:48:39 8368 8192000000 10968650256 11409555456 1979960128 19.464 99 39 78 1 2044995984 52182480 12853376
17:48:56 9003 8192000000 10970890368 11405475840 1976160960 19.434 99 48 96 2 2041390848 49600224 15629664
17:49:15 8173 8192000000 10975185648 11416121344 1998312416 19.609 100 48 96 0 2067593680 52551456 16729808
17:49:51 12787 8192000000 10948231248 11391598592 1937370976 19.126 97 45 90 1 2015485552 62312256 15802320
17:50:18 11079 8192000000 10944356160 11384426496 1965400144 19.349 100 54 108 0 2038673952 54852048 18421760
17:50:38 15043 8192000000 10954039136 11393458176 1966131904 19.355 100 41 80 2 2038310384 58293568 13884912
17:51:12 11098 8192000000 10947107664 11384074240 1953764928 19.256 99 40 80 0 2017021920 49751792 13505200
17:51:32 20242 8192000000 10940888704 11382333440 1952164752 19.244 99 41 82 0 2017852064 51908560 13778752
17:52:02 11010 8192000000 10944694000 11387056128 1943909664 19.178 99 38 74 2 2017233808 60692640 12631504
17:52:39 18651 8192000000 10942724992 11393355776 1963701056 19.335 100 29 58 0 2028640256 54403952 10535248
17:53:04 7918 8192000000 10935174880 11393249280 1957368128 19.285 100 28 56 1 2022315536 54444032 10503376
17:53:18 12219 8192000000 10933844512 11395465216 1952719744 19.248 100 28 56 0 2026060800 63232688 10108368
17:54:05 12283 8192000000 10925367392 11372392448 1924513456 19.023 99 30 60 2 2005689088 70083952 11091680
17:54:33 26611 8192000000 10934938832 11389734912 1922753632 19.009 99 27 54 3 1999736208 66977056 10005520
17:55:22 31175 8192000000 10901927856 11379945472 1948133104 19.212 100 22 43 1 2008398064 52579376 7685584
17:56:37 25876 8192000000 10851272112 11314872320 1896291296 18.796 98 16 32 1 1910759232 9429392 5038544
17:57:12 39387 8192000000 10904214080 11343708160 1949726816 19.224 100 32 64 0 1968634448 8885376 10022256
17:58:00 86087 8192000000 10879831744 11340374016 1937815248 19.129 99 23 47 1 1954000112 9448896 6735968
17:59:46 22939 8192000000 10849085776 11313508352 1913402016 18.934 99 16 30 0 1924217648 6913984 3901648
18:00:17 17421 8192000000 10870116336 11335319552 1940207584 19.148 100 29 58 0 1957436704 9431536 7797584
18:01:48 89859 8192000000 10884758448 11337719808 1923025552 19.011 98 29 58 0 1944292064 13036800 8229712
18:03:32 100847 8192000000 10875756400 11334529024 1914524000 18.943 98 21 42 0 1934068960 13769408 5775552
18:05:24 132164 8192000000 10884516576 11349807104 1922097952 19.004 98 17 34 2 1942380640 15330784 4951904
18:08:02 67311 8192000000 10874680000 11345555456 1902007728 18.842 97 14 28 0 1919173632 13199904 3966000
18:09:16 49952 8192000000 10870998816 11346952192 1940396928 19.150 99 13 26 0 1956909520 13023664 3488928
18:10:17 8414 8192000000 10870414496 11348316160 1948454736 19.214 100 11 23 1 1963140016 11543312 3141968
18:10:31 16414 8192000000 10884245536 11345014784 1949625680 19.223 100 9 19 0 1962172496 10029920 2516896
18:10:56 39457 8192000000 10871478624 11329794048 1923346848 19.014 98 18 36 0 1939779120 11789040 4643232
18:11:45 96194 8192000000 10858495760 11316858880 1904336976 18.861 98 26 52 0 1919307616 7338048 7632592
18:13:29 30652 8192000000 10900637600 11336708096 1927045472 19.043 99 45 90 1 1951665760 11892448 12727840
18:14:10 16892 8192000000 10905997296 11349024768 1959937776 19.306 100 54 108 1 1987883120 12394704 15550640
18:14:35 66101 8192000000 10873698992 11339493376 1939481808 19.143 99 17 34 0 1956919856 12338624 5099424
18:15:56 30472 8192000000 10884570144 11348377600 1959806976 19.305 100 18 35 1 1978307392 12531456 5968960
18:16:36 5169 8192000000 10897314944 11355553792 1965647200 19.351 100 33 66 1 1987389088 12118736 9623152
18:16:48 22100 8192000000 10898317520 11360841728 1966260416 19.356 100 20 39 1 1985618256 13487728 5870112
18:17:22 34564 8192000000 10917279136 11371417600 1981883664 19.480 100 29 58 1 2003339968 10994032 10462272
18:18:03 67160 8192000000 10920665200 11379572736 1987473280 19.524 100 34 68 0 2010776304 13159600 10143424
18:19:27 67854 8192000000 10908618320 11391606784 1980697056 19.470 100 15 30 0 2005016672 19614896 4704720
18:20:41 67743 8192000000 10903771536 11372269568 1946629968 19.200 98 15 28 2 1965467472 14481728 4355776
18:22:08 78057 8192000000 10873635936 11341205504 1952351088 19.245 99 12 24 1 1968382752 12525696 3505968
18:23:32 57259 8192000000 10895194912 11343826944 1929180560 19.060 98 38 76 5 1946433072 6697712 10554800
18:24:36 4483 8192000000 10925249232 11361542144 1976945264 19.441 100 79 157 2 2007306560 7471552 22889744
18:24:48 20410 8192000000 10907689904 11363487744 1976105120 19.434 100 45 89 0 1998950160 9775728 13069312
18:25:31 36501 8192000000 10865944944 11339235328 1934606160 19.104 98 14 28 0 1945163904 6824704 3733040
18:26:14 92589 8192000000 10885509344 11367755776 1968219920 19.371 100 14 28 0 1979155616 7256432 3679264
18:27:53 70676 8192000000 10891490304 11365605376 1954179200 19.260 99 14 28 1 1965920048 7423360 4317488
18:29:10 43320 8192000000 10902341520 11363946496 1940184176 19.148 98 12 25 0 1951565088 8190720 3190192
18:30:08 68355 8192000000 10895038032 11361411072 1883308192 18.692 95 17 34 1 1905309104 17226128 4774784
18:31:31 64847 8192000000 10882212160 11350953984 1904797872 18.865 97 25 50 2 1925896064 14025392 7072800
18:32:50 81719 8192000000 10897388416 11368153088 1921712704 19.001 98 16 32 0 1942916752 16603952 4600096
18:34:20 40200 8192000000 10893126512 11352088576 1908627552 18.896 97 30 59 1 1933034000 16080048 8326400
18:35:08 24221 8192000000 10878336912 11336880128 1881290656 18.676 96 34 67 1 1904251328 13392176 9568496
18:35:42 100786 8192000000 10858890592 11317907456 1794836576 17.972 92 15 28 0 1810716336 11778576 4101184
18:37:29 26576 8192000000 10875835872 11330498560 1892009680 18.762 97 39 78 3 1911484928 8115536 11359712
18:38:08 60121 8192000000 10863978400 11343753216 1921344224 18.998 99 13 26 1 1935771360 10836496 3590640
18:39:21 46187 8192000000 10879411952 11337715712 1889856912 18.745 97 15 30 0 1904796288 10852336 4087040
18:40:18 88783 8192000000 10861166208 11339186176 1885988336 18.713 97 22 44 3 1906047456 13800848 6258272
18:41:53 94421 8192000000 10831093728 11291795456 1773497568 17.796 92 8 16 0 1783748800 8240192 2011040
18:44:38 46492 8192000000 10868222832 11317989376 1927938432 19.050 100 41 82 3 1945711968 6210576 11562960
18:45:31 29421 8192000000 10864193424 11327504384 1937902960 19.130 100 38 76 1 1960114640 12201920 10009760
18:46:18 51033 8192000000 10846937440 11323809792 1932814256 19.089 100 7 14 0 1942340096 7611584 1914256
18:47:15 27702 8192000000 10849491440 11326238720 1934425392 19.102 100 4 8 0 1943858304 8319232 1113680
18:47:49 14579 8192000000 10850099632 11331571712 1936416272 19.118 100 5 10 0 1946341008 8480416 1444320
18:48:12 14032 8192000000 10852511536 11324104704 1899169488 18.820 98 11 20 1 1910944432 8791840 2983104
18:48:47 57110 8192000000 10856346448 11327299584 1917531520 18.967 99 14 28 1 1928261664 7024896 3705248
18:49:56 54279 8192000000 10855581760 11337646080 1938210224 19.132 100 21 42 1 1953773664 9584864 5978576
18:51:08 52841 8192000000 10859915248 11326824448 1904361680 18.861 98 23 46 2 1921192400 9910784 6919936
18:52:11 54727 8192000000 10880371376 11333435392 1885978576 18.713 97 17 34 0 1902205440 11453760 4773104
18:53:14 62741 8192000000 10869246208 11350351872 1946073568 19.195 100 15 30 1 1965945056 15333072 4538416
18:55:15 45684 8192000000 10853494656 11326889984 1918755728 18.977 99 13 26 1 1930450960 7349472 4345760
18:56:07 51452 8192000000 10858547424 11337814016 1923123264 19.012 99 19 37 1 1935259152 6995728 5140160
18:57:10 25487 8192000000 10879289424 11328344064 1886955776 18.721 96 49 99 0 1906589120 5890912 13742432
18:57:46 18387 8192000000 10894822416 11348373504 1951839280 19.241 100 41 81 1 1975587024 12636240 11111504
18:58:13 12843 8192000000 10869807216 11313623040 1901827824 18.841 97 44 88 1 1923476768 9662016 11986928
18:58:32 31740 8192000000 10878207440 11342864384 1934998896 19.107 99 30 61 3 1952512640 9783488 7730256
18:59:10 44239 8192000000 10908828560 11368812544 1962862256 19.329 100 33 65 3 1980161568 8592064 8707248
19:00:05 77483 8192000000 10905938128 11396308992 1958856384 19.297 99 27 54 0 1983412272 16269072 8286816
19:02:06 108749 8192000000 10885588992 11372441600 1854725424 18.460 94 14 28 0 1874158256 15499648 3933184
19:06:13 29774 8192000000 10886900352 11351531520 1937044672 19.123 99 43 84 2 1963314128 13676976 12592480
19:06:51 32502 8192000000 10861794848 11343499264 1912980560 18.931 98 20 40 0 1936114528 17491952 5642016
19:07:33 44118 8192000000 10879911536 11364491264 1954080256 19.259 100 11 22 0 1969805280 12491616 3233408
19:08:30 40243 8192000000 10891138720 11371220992 1966702016 19.359 100 12 24 1 1981714416 11503824 3508576
19:10:57 104035 8192000000 10883176080 11369160704 1917672336 18.968 97 17 33 1 1940420288 18166816 4581136
19:13:17 71877 8192000000 10880033728 11358646272 1914666416 18.944 97 19 36 1 1928429488 8655280 5107792
19:14:35 112131 8192000000 10891100064 11371724800 1886643952 18.719 96 14 28 1 1903852096 13379728 3828416
19:16:34 47845 8192000000 10895806208 11348738048 1909206096 18.900 97 40 75 1 1933231424 13273904 10751424
19:17:39 93262 8192000000 10880650144 11343433728 1857177584 18.480 95 14 28 0 1871097920 9795248 4125088
19:19:19 46683 8192000000 10896656752 11359154176 1956746000 19.280 100 23 46 1 1974449280 11135504 6567776
19:20:20 63184 8192000000 10868514576 11328749568 1842264672 18.359 94 21 40 2 1856835232 9266864 5303696
19:21:29 32941 8192000000 10902948912 11351810048 1925943552 19.034 99 48 96 3 1954138144 15056640 13137952
19:22:14 63465 8192000000 10879100416 11358797824 1912490608 18.927 98 21 42 1 1938998992 20252512 6255872
19:24:05 43600 8192000000 10876124288 11345162240 1915214336 18.948 98 25 49 2 1932788080 10655056 6918688
19:24:56 89652 8192000000 10877856112 11358375936 1950202688 19.228 100 28 56 0 1972154912 14443632 7508592
19:26:38 54522 8192000000 9774066272 10123235328 906492880 9.963 47 8 16 1 918712256 10085520 2133856

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 20-03-2021 19:29:21 to 20-03-2021 19:29:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 121 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-03-2021 19:29:53 to 20-03-2021 19:29:55.

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          238703
MON$OLDEST_ACTIVE               239435
MON$OLDEST_SNAPSHOT             239435
MON$NEXT_TRANSACTION            239435
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                       2021120
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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'

20.03.21 19:29:56. 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-20 19:29:59 No severe PSQL-related problems occured
20.03.21 19:30:00. End of report.