Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.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 17561896 kB
MemAvailable 31567436 kB
Buffers 0 kB
Cached 14089120 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-10 22:27:17
DTS_END                         2021-03-10 22:27:17.7710
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/43948
TRN_ID                          238515
ATT_ID                          706
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: 9101.40 18726 1092168
customer order: creation 175.87 368 21104
customer order: refuse 14.00 387 1680
order to supplier: creation 43.76 1406 5251
order to supplier: removal 3.54 89833 425
invoice (draft): creation 46.41 3400 5569
invoice (draft): removal 51.83 785 6219
invoice accept: apply 42.40 18323 5088
invoice accept: cancel 46.34 805 5561
customer reserve: creation 3866.11 183 463933
customer reserve: removal 4518.42 55 542210
realization accept: apply 84.04 171 10085
realization accept: cancel 77.72 114 9326
payment from customer: creation 61.17 115 7340
payment from customer: removal 5.38 71 645
payment to supplier: creation 49.19 120 5903
payment to supplier: removal 3.41 85 409
service: total inventory turnovers 4.88 1114 586
service: total monetary turnovers 6.17 31 740
service: aggregate perf. data 0.75 24934 90
service: refresh index statistics 0.03 232220 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-03-2021 22:28:28 to 10-03-2021 22:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3451
TEST_TIME 2 5158
TEST_TIME 3 5192
TEST_TIME 4 5144
TEST_TIME 5 5235
TEST_TIME 6 5290
TEST_TIME 7 5468
TEST_TIME 8 5348
TEST_TIME 9 6142
TEST_TIME 10 6261
TEST_TIME 11 6560
TEST_TIME 12 6955
TEST_TIME 13 6913
TEST_TIME 14 6839
TEST_TIME 15 6984
TEST_TIME 16 7351
TEST_TIME 17 7534
TEST_TIME 18 7682
TEST_TIME 19 8372
TEST_TIME 20 8435
TEST_TIME 21 8762
TEST_TIME 22 8687
TEST_TIME 23 9303
TEST_TIME 24 9346
TEST_TIME 25 10302
TEST_TIME 26 10555
TEST_TIME 27 10455
TEST_TIME 28 10327
TEST_TIME 29 10213
TEST_TIME 30 10119
TEST_TIME 31 10065
TEST_TIME 32 10006
TEST_TIME 33 9850
TEST_TIME 34 9805
TEST_TIME 35 9832
TEST_TIME 36 9767
TEST_TIME 37 9748
TEST_TIME 38 9671
TEST_TIME 39 9713
TEST_TIME 40 9579
TEST_TIME 41 9582
TEST_TIME 42 9566
TEST_TIME 43 9451
TEST_TIME 44 9598
TEST_TIME 45 9502
TEST_TIME 46 9626
TEST_TIME 47 9585
TEST_TIME 48 9528
TEST_TIME 49 9692
TEST_TIME 50 9707
TEST_TIME 51 9640
TEST_TIME 52 9671
TEST_TIME 53 9837
TEST_TIME 54 9831
TEST_TIME 55 9890
TEST_TIME 56 9940
TEST_TIME 57 9850
TEST_TIME 58 9708
TEST_TIME 59 9629
TEST_TIME 60 9559
TEST_TIME 61 9549
TEST_TIME 62 9561
TEST_TIME 63 9497
TEST_TIME 64 9438
TEST_TIME 65 9374
TEST_TIME 66 9370
TEST_TIME 67 9313
TEST_TIME 68 9341
TEST_TIME 69 9336
TEST_TIME 70 9313
TEST_TIME 71 9325
TEST_TIME 72 9327
TEST_TIME 73 9382
TEST_TIME 74 9386
TEST_TIME 75 9361
TEST_TIME 76 9401
TEST_TIME 77 9422
TEST_TIME 78 9459
TEST_TIME 79 9502
TEST_TIME 80 9516
TEST_TIME 81 9564
TEST_TIME 82 9467
TEST_TIME 83 9446
TEST_TIME 84 9384
TEST_TIME 85 9343
TEST_TIME 86 9289
TEST_TIME 87 9256
TEST_TIME 88 9220
TEST_TIME 89 9189
TEST_TIME 90 9160
TEST_TIME 91 9185
TEST_TIME 92 9167
TEST_TIME 93 9198
TEST_TIME 94 9214
TEST_TIME 95 9271
TEST_TIME 96 9298
TEST_TIME 97 9282
TEST_TIME 98 9267
TEST_TIME 99 9326
TEST_TIME 100 9389
TEST_TIME 101 9338
TEST_TIME 102 9329
TEST_TIME 103 9405
TEST_TIME 104 9404
TEST_TIME 105 9358
TEST_TIME 106 9298
TEST_TIME 107 9254
TEST_TIME 108 9263
TEST_TIME 109 9240
TEST_TIME 110 9208
TEST_TIME 111 9196
TEST_TIME 112 9152
TEST_TIME 113 9173
TEST_TIME 114 9152
TEST_TIME 115 9182
TEST_TIME 116 9186
TEST_TIME 117 9165
TEST_TIME 118 9204
TEST_TIME 119 9176
TEST_TIME 120 9103

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-03-2021 22:28:32 to 10-03-2021 22:28:35.

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 1522552 1522552 0 0.00 0 19250 7 0 0
doc_list_biud 1522552 1522552 0 0.00 0 36210 25 0 0
sp_add_invoice_to_stock 5211 5088 123 2.36 35 172023 18323 0 123
sp_cancel_adding_invoice 5561 5561 0 0.00 5 59586 805 0 0
sp_cancel_client_order 1680 1680 0 0.00 4 17162 387 0 0
sp_cancel_customer_reserve 542210 542210 0 0.00 1 21151 55 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 2 5383 71 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 2 5079 86 0 0
sp_cancel_supplier_invoice 6234 6219 15 0.24 2 15262 785 0 15
sp_cancel_supplier_order 425 425 0 0.00 8 1207477 89833 0 0
sp_cancel_write_off 9326 9326 0 0.00 1 18307 115 0 0
sp_client_order 21104 21104 0 0.00 3 32143 368 0 0
sp_customer_reserve 463933 463933 0 0.00 0 98838 184 0 0
sp_fill_shopping_cart 31906 31906 0 0.00 1 11453 37 0 0
sp_fill_shopping_cart_clo_res 463930 463930 0 0.00 0 29634 14 0 0
sp_get_clo_for_invoice 5080 5080 0 0.00 0 30363 335 0 0
sp_kill_cost_storno 15941 15941 0 0.00 0 5374 54 0 0
sp_kill_qstorno_ret_qs2qd 1100390 1100390 0 0.00 0 21146 30 0 0
sp_kill_qty_storno 580584 580584 0 0.00 0 36209 66 0 0
sp_lock_selected_doc 20936 20936 0 0.00 0 8845 6 0 0
sp_make_cost_storno 28406 28406 0 0.00 0 18162 46 0 0
sp_multiply_rows_for_pdistr 28406 28406 0 0.00 0 18802 31 0 0
sp_multiply_rows_for_qdistr 21104 21104 0 0.00 0 11470 166 0 0
sp_pay_from_customer 7340 7340 0 0.00 4 10823 116 0 0
sp_pay_to_supplier 5903 5903 0 0.00 5 18876 120 0 0
sp_payment_common 13243 13243 0 0.00 1 10965 23 0 0
sp_qd_handle_on_cancel_clo 1680 1680 0 0.00 0 17153 354 0 0
sp_qd_handle_on_invoice_upd_sts 10639 10639 0 0.00 0 36206 301 0 0
sp_qd_handle_on_reserve_upd_sts 10085 10085 0 0.00 0 21007 62 0 0
sp_reserve_write_off 10085 10085 0 0.00 6 21045 172 0 0
sp_supplier_invoice 5569 5569 0 0.00 6 94988 3401 0 0
sp_supplier_order 5251 5251 0 0.00 6 104774 1407 0 0
srv_aggregate_perf_data 90 90 0 0.00 2739 299332 24935 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1151 206318 33263 0 0
srv_find_qd_qs_mism 1044427 1044427 0 0.00 0 19250 6 0 0
srv_make_invnt_saldo 586 586 0 0.00 44 83704 1114 0 0
srv_make_money_saldo 740 740 0 0.00 1 4238 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 157671 293849 232220 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5088 5088 0 0.00 0 14379 152 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 1 5056 88 0 0
t$perf-norm:sp_cancel_client_order 1680 1680 0 0.00 0 2992 9 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 869 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 1023 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 190 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 1537 17 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 16739 1438 0 0
t$perf-norm:sp_cancel_write_off 1077 1077 0 0.00 0 4907 13 0 0
t$perf-norm:sp_client_order 21104 21104 0 0.00 0 14182 17 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 5045 11 0 0
t$perf-norm:sp_pay_from_customer 7340 7340 0 0.00 0 10710 7 0 0
t$perf-norm:sp_pay_to_supplier 5903 5903 0 0.00 0 14144 17 0 0
t$perf-norm:sp_reserve_write_off 10085 10085 0 0.00 0 11600 10 0 0
t$perf-norm:sp_supplier_invoice 5569 5569 0 0.00 0 6651 17 0 0
t$perf-norm:sp_supplier_order 5251 5251 0 0.00 0 8992 15 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 254 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 285 5 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 3884 35 0 0
t$perf-norm:srv_make_money_saldo 740 740 0 0.00 0 3515 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 19 7 0 0
v_add_invoice_to_stock 10392 10146 246 2.36 0 7165 18 0 246
v_all_customers 38692 38692 0 0.00 0 52 1 0 0
v_all_suppliers 29888 29888 0 0.00 0 21 1 0 0
v_all_wares 42202 42202 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 5960 15 0 0
v_cancel_client_order 3360 3360 0 0.00 0 3504 5 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 1831 5 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 6008 7 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 561 4 0 0
v_cancel_supplier_invoice 862 832 30 3.48 0 1915 18 0 30
v_cancel_supplier_order 850 850 0 0.00 0 1834 7 0 0
v_cancel_write_off 2154 2154 0 0.00 0 5370 15 0 0
v_max_id_clo_ord 5250 5250 0 0.00 0 2056 2 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 2821 16 0 0
v_max_id_ord_sup 5554 5554 0 0.00 0 3965 3 0 0
v_max_non_paid_invoice 1762 1762 0 0.00 0 411 2 0 0
v_max_non_paid_realizn 3892 3892 0 0.00 0 2847 4 0 0
v_min_id_clo_ord 5250 5250 0 0.00 0 5082 7 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 1546 4 0 0
v_min_id_ord_sup 5554 5554 0 0.00 0 9246 10 0 0
v_min_non_paid_invoice 5903 5903 0 0.00 0 10961 13 0 0
v_min_non_paid_realizn 7340 7340 0 0.00 0 5369 14 0 0
v_our_firm 10406 10406 0 0.00 0 25 1 0 0
v_reserve_write_off 20170 20170 0 0.00 0 5268 6 0 0
x_lock_depdocs_on_canc_invoice 11364 11364 0 0.00 0 21180 113 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 17289 359 0 0
x_make_qstorno_1000_1200 5251 5251 0 0.00 1 104717 1331 0 0
x_make_qstorno_1200_2000 5569 5569 0 0.00 3 88865 3265 0 0
x_make_qstorno_2100_3300 463933 463933 0 0.00 0 98836 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-03-2021 22:28:36 to 10-03-2021 22:28:40.

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:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:27 21049 8192000000 10228206448 10532118528 837826464 9.278 67 52 105 0 858542080 2554288 18161328
19:58:01 24766 8192000000 10326803360 10637406208 1368496720 14.314 100 81 162 0 1399593616 4705920 26390976
19:58:41 23736 8192000000 10357910416 10675900416 1406808352 14.656 100 86 172 0 1442218608 6701616 28708640
19:59:13 24065 8192000000 10386050992 10709721088 1437050848 14.924 100 84 168 0 1471712352 7592864 27068640
19:59:51 14985 8192000000 10406503840 10732879872 1464744256 15.168 100 87 175 0 1500987968 8257024 27986688
20:00:24 19917 8192000000 10430299600 10761523200 1482502384 15.323 100 88 177 2 1519809392 9138960 28168048
20:00:53 21571 8192000000 10462987360 10795515904 1502111168 15.495 100 86 172 0 1538894784 9604560 27179056
20:01:24 10962 8192000000 10473339968 10808877056 1527010176 15.711 100 83 166 0 1562905664 9972448 25923040
20:01:42 19483 8192000000 10499889712 10843107328 1553583008 15.941 100 83 166 1 1589681248 10358336 25739904
20:02:11 18093 8192000000 10514413808 10865799168 1573004544 16.108 100 79 158 0 1607618448 10570256 24043648
20:02:38 16223 8192000000 10553739904 10903474176 1593883712 16.287 100 76 152 0 1627336624 10744368 22708544
20:03:02 9063 8192000000 10560945424 10914320384 1620702608 16.516 100 88 175 1 1658887392 11502816 26681968
20:03:20 9526 8192000000 10576291984 10936778752 1637770144 16.661 100 83 166 2 1674128480 11779760 24578576
20:03:40 7024 8192000000 10591461760 10954711040 1650731264 16.771 100 76 153 0 1684485936 11472480 22282192
20:04:00 8169 8192000000 10608045072 10978152448 1677116976 16.993 100 74 147 2 1709460592 11190528 21153088
20:04:15 10585 8192000000 10636918736 11007262720 1694820288 17.142 100 79 158 1 1729270480 11600752 22849440
20:04:34 7547 8192000000 10650137392 11021365248 1711218720 17.279 100 75 149 1 1744132320 12200624 20712976
20:04:50 6558 8192000000 10681069120 11051859968 1736613728 17.490 100 86 171 2 1774137936 12922784 24601424
20:05:05 5941 8192000000 10696210784 11069603840 1752873840 17.625 100 89 176 1 1791387952 14105920 24408192
20:05:19 4847 8192000000 10700506096 11075657728 1762647808 17.706 100 91 182 0 1802403104 14331536 25423760
20:05:32 4765 8192000000 10707461280 11084111872 1767613920 17.747 100 83 164 1 1805567872 14285280 23668672
20:05:43 4025 8192000000 10712725424 11088523264 1774403248 17.803 100 89 179 2 1814309648 14821840 25084560
20:05:54 3808 8192000000 10726140608 11105456128 1787005952 17.907 100 88 175 1 1825524416 13825456 24693008
20:06:05 3274 8192000000 10730421744 11114008576 1795965696 17.981 100 84 167 2 1832410432 12954432 23490304
20:06:15 3089 8192000000 10745695328 11122548736 1801277408 18.024 100 89 177 0 1839644192 14337056 24029728
20:06:24 2699 8192000000 10748575648 11128795136 1804835296 18.054 100 93 186 1 1846580864 16049952 25695616
20:06:39 6469 8192000000 10749635472 11136446464 1811493840 18.108 100 87 174 1 1849905104 14872656 23538608
20:06:52 2905 8192000000 10771183808 11153461248 1824406816 18.214 100 87 176 2 1862916832 14277216 24232800
20:07:02 2650 8192000000 10774662992 11156770816 1835460848 18.304 100 93 186 0 1875853584 13628096 26764640
20:07:11 2177 8192000000 10779582432 11163512832 1838546688 18.329 100 89 178 2 1877105312 13184592 25374032
20:07:19 2408 8192000000 10779011392 11160834048 1840091584 18.342 100 88 176 1 1875849584 11483936 24274064
20:07:28 2129 8192000000 10783316352 11166142464 1847012208 18.398 100 94 187 3 1885058544 11247728 26798608
20:07:37 2237 8192000000 10791972176 11176767488 1847598160 18.403 100 88 175 0 1886085456 13556272 24931024
20:07:45 1348 8192000000 10796768768 11184418816 1851690752 18.436 100 92 184 1 1892258832 13634848 26933232
20:07:53 1483 8192000000 10800099088 11187539968 1854594048 18.459 100 93 188 0 1895031440 14261632 26175760
20:08:02 1458 8192000000 10804817056 11189579776 1857389200 18.482 100 93 188 0 1898712320 14135600 27187520
20:08:10 2470 8192000000 10797092224 11189633024 1857242080 18.481 100 80 158 3 1892928112 13494416 22191616
20:08:19 10339 8192000000 10796905584 11191746560 1863634416 18.533 100 71 142 3 1896110400 10282720 22193264
20:08:36 19886 8192000000 10800883408 11195289600 1867340896 18.563 100 63 124 4 1894796048 9473472 17981680
20:09:04 7373 8192000000 10776655616 11195359232 1859246208 18.497 100 27 54 2 1874818528 8292992 7279328
20:09:17 10226 8192000000 10776421184 11194142720 1864897360 18.543 100 35 73 1 1880342880 5938448 9507072
20:09:35 10084 8192000000 10789293568 11198291968 1863603040 18.532 100 24 46 1 1875586400 5810000 6173360
20:09:52 6124 8192000000 10772590432 11195383808 1864467408 18.539 100 26 52 1 1879126256 7111936 7546912
20:10:04 7043 8192000000 10776381184 11204034560 1866894064 18.559 100 21 42 1 1879543216 6800800 5848352
20:10:19 11802 8192000000 10777308272 11207856128 1873745328 18.615 100 21 42 1 1886082112 6238288 6098496
20:10:38 10641 8192000000 10793515504 11219304448 1875624640 18.630 100 30 60 1 1892001776 7980304 8396832
20:10:56 10529 8192000000 10793519936 11217448960 1880674896 18.671 100 21 41 1 1892561152 5514208 6372048
20:11:16 9248 8192000000 10794125040 11223810048 1884836480 18.704 100 24 48 0 1898789712 7482336 6470896
20:11:32 15295 8192000000 10797847792 11225686016 1886646128 18.719 100 26 52 1 1901138768 7165856 7326784
20:11:58 8819 8192000000 10796816080 11228237824 1886726832 18.719 100 19 37 1 1898286624 5389728 6170064
20:12:16 10656 8192000000 10798753424 11236098048 1896340176 18.797 100 24 48 1 1909524448 6797296 6386976
20:12:33 55137 8192000000 10827324832 11248967680 1897226016 18.804 100 23 46 2 1909500448 5389696 6884736
20:13:35 27838 8192000000 10829043952 11255377920 1902414352 18.846 100 28 56 3 1915889536 5610640 7864544
20:14:09 4380 8192000000 10824640208 11256266752 1903515984 18.855 100 26 52 3 1918071248 6970528 7584736
20:14:22 11476 8192000000 10812926208 11250262016 1902787792 18.849 100 23 46 1 1915255920 5601200 6866928
20:14:40 6328 8192000000 10825081712 11252187136 1901874896 18.841 100 26 52 0 1915787152 6785536 7126720
20:14:56 5448 8192000000 10825337168 11253841920 1906674368 18.880 100 27 54 2 1920681152 5883248 8123536
20:15:12 4291 8192000000 10822139424 11256459264 1909737088 18.905 100 36 72 1 1927443648 7622112 10084448
20:15:24 5107 8192000000 10819438080 11256926208 1908210048 18.892 100 32 64 2 1927830512 10563520 9056944
20:15:40 4924 8192000000 10829153936 11254501376 1891208288 18.756 99 38 78 0 1908089200 5217920 11662992
20:15:54 9273 8192000000 10811134688 11253895168 1889843056 18.745 99 25 51 1 1903218960 5435600 7940304
20:16:09 4923 8192000000 10825762608 11259822080 1908781216 18.897 100 30 58 0 1924214688 6743008 8690464
20:16:20 9020 8192000000 10798859024 11229962240 1871638272 18.598 98 22 44 3 1883966128 5867856 6460000
20:16:38 6343 8192000000 10821780400 11255529472 1902155184 18.844 100 27 54 1 1915747776 5843792 7748800
20:16:51 6891 8192000000 10822479104 11251662848 1901365776 18.837 100 25 50 3 1914259920 6016576 6877568
20:17:04 11890 8192000000 10778293264 11191422976 1788365072 17.918 94 30 59 2 1803357264 4885552 10106640
20:17:24 71911 8192000000 10749452976 11173740544 1724171600 17.387 92 31 63 0 1742542384 9122080 9248704
20:18:48 6883 8192000000 10750880288 11171946496 1814199312 18.130 98 33 68 0 1830331552 6780400 9351840
20:19:01 7754 8192000000 10747864144 11153039360 1754744352 17.641 95 29 58 0 1768995120 5228080 9022688
20:19:15 6027 8192000000 10736596240 11155775488 1806728928 18.069 99 26 52 3 1820432208 6995664 6707616
20:19:27 4754 8192000000 10739245760 11151433728 1799411136 18.009 99 43 86 3 1820241808 8279488 12551184
20:19:42 5136 8192000000 10733637920 11145932800 1805428688 18.058 99 22 41 1 1817903296 5269824 7204784
20:19:54 10662 8192000000 10739042224 11153231872 1756372048 17.654 96 25 49 2 1769644976 5673152 7599776
20:20:11 11140 8192000000 10703753600 11120402432 1706651328 17.241 94 18 36 2 1717621504 4923264 6046912
20:20:30 6052 8192000000 10711724016 11125022720 1762034736 17.701 98 24 48 0 1774321088 4981616 7304736
20:20:42 7346 8192000000 10709132048 11123200000 1762750080 17.707 98 27 54 1 1777352976 5849312 8753584
20:20:58 5711 8192000000 10717923216 11126296576 1745593936 17.565 97 28 57 2 1763375680 9668864 8112880
20:21:10 9744 8192000000 10711792096 11127238656 1775093536 17.809 99 21 42 2 1786811552 5665632 6052384
20:21:27 9955 8192000000 10697663424 11106430976 1712871216 17.293 96 28 56 1 1726711216 5382432 8457568
20:21:45 6795 8192000000 10713455456 11131424768 1782218800 17.868 99 22 45 1 1794269408 5889248 6161360
20:22:02 14019 8192000000 10722355552 11132559360 1748826736 17.592 96 37 72 1 1764834592 5531264 10476592
20:22:22 54236 8192000000 10760742928 11152715776 1820682656 18.183 100 71 145 1 1848268864 5546016 22040192
20:23:22 6189 8192000000 10751058800 11169468416 1827034784 18.235 100 38 76 2 1845917024 8259760 10622480
20:23:35 7526 8192000000 10760118624 11175813120 1831678320 18.273 100 29 58 1 1844985040 5344064 7962656
20:23:52 4791 8192000000 10765769248 11186130944 1842923152 18.365 100 49 97 0 1866414192 10185520 13305520
20:24:03 8801 8192000000 10761986496 11180675072 1843016080 18.365 100 35 70 2 1859003664 6406560 9581024
20:24:26 5940 8192000000 10777687616 11184209920 1843354080 18.368 100 27 54 3 1857384000 5272304 8757616
20:24:40 5943 8192000000 10764997616 11185643520 1844649424 18.379 100 23 46 2 1856549264 5076304 6823536
20:24:52 9666 8192000000 10763635856 11191955456 1848507856 18.410 100 28 56 1 1863503984 6847152 8148976
20:25:09 7018 8192000000 10764918864 11195097088 1853947056 18.454 100 38 76 2 1871876000 6534912 11394032
20:25:22 7232 8192000000 10784978240 11205861376 1859205056 18.497 100 36 72 3 1875337168 4650144 11481968
20:25:36 8087 8192000000 10777719056 11206074368 1864305088 18.538 100 28 55 1 1878631456 5957984 8368384
20:25:53 12807 8192000000 10795044432 11212283904 1867320256 18.563 100 36 71 0 1883826352 4999344 11506752
20:26:13 11283 8192000000 10781845824 11211325440 1866879264 18.559 100 18 36 0 1878176112 6289120 5007728
20:26:32 120698 8192000000 10825071072 11245719552 1878577616 18.654 100 26 52 2 1891637216 5883360 7176240
20:28:46 10289 8192000000 10852890864 11272921088 1917086400 18.963 100 69 138 2 1949114656 12361872 19666384
20:29:05 17873 8192000000 10862215072 11277545472 1922510752 19.007 100 67 134 0 1954960112 13607184 18842176
20:29:32 10543 8192000000 10883853600 11294285824 1932717840 19.089 100 65 132 1 1964631920 13901568 18012512
20:29:50 2387 8192000000 10881581536 11294527488 1936163792 19.116 100 69 136 0 1970120880 14176608 19780480
20:30:00 2706 8192000000 10891549968 11302424576 1943160256 19.172 100 75 150 1 1978539472 13193536 22185680
20:30:10 5128 8192000000 10858211680 11272732672 1919503776 18.983 99 62 124 3 1950490768 12947216 18039776
20:30:23 36235 8192000000 10881351264 11301277696 1937337968 19.126 100 51 102 1 1967675104 15850576 14486560
20:31:07 16514 8192000000 10875256688 11305324544 1938570192 19.135 100 48 96 2 1968055424 15641280 13843952
20:31:31 16667 8192000000 10873077520 11307016192 1944237312 19.181 100 42 84 0 1971295056 14955280 12102464
20:32:14 11771 8192000000 10887267168 11310198784 1952277232 19.245 100 50 100 4 1981936080 15894384 13764464
20:32:37 5877 8192000000 10886257120 11317534720 1952692832 19.248 100 46 93 2 1982340544 16305200 13342512
20:32:50 14513 8192000000 10889957360 11321978880 1955148064 19.267 100 43 86 0 1985818448 17028656 13641728
20:33:12 10563 8192000000 10902729568 11333009408 1963223216 19.332 100 56 111 1 1997516288 18015888 16277184
20:33:31 12669 8192000000 10901043632 11333419008 1964168976 19.339 100 42 84 0 1994915712 18096576 12650160
20:33:56 15079 8192000000 10905822960 11338821632 1968568976 19.374 100 45 89 3 2001081472 18932064 13580432
20:34:19 10684 8192000000 10906800208 11342458880 1970062112 19.386 100 47 92 3 2001688816 17759680 13867024
20:34:41 9834 8192000000 10920316928 11345240064 1972856736 19.408 100 40 80 2 2003253552 18423520 11973296
20:35:08 2515 8192000000 10933955616 11352608768 1979238080 19.459 100 58 116 1 2015341504 18276768 17826656
20:35:17 5636 8192000000 10920927856 11347451904 1961569840 19.319 99 61 121 0 1998021152 18645344 17805968
20:35:31 3585 8192000000 10933310000 11351810048 1977531808 19.445 100 66 132 0 2017616416 20234864 19849744
20:35:44 12563 8192000000 10933840160 11351490560 1963226736 19.332 99 69 136 1 2005608032 22243120 20138176
20:36:06 6475 8192000000 10925820976 11346927616 1955899056 19.273 99 67 133 1 1999817568 23960976 19957536
20:36:19 16150 8192000000 10939339696 11364667392 1974006816 19.417 100 63 126 0 2018686464 25793280 18886368
20:36:46 10416 8192000000 10926524496 11362652160 1980303584 19.467 100 47 95 1 2019452992 25050288 14099120
20:37:05 8228 8192000000 10932473568 11364757504 1986905888 19.519 100 56 112 1 2023452400 19826656 16719856
20:37:20 2834 8192000000 10936522384 11366436864 1987628864 19.525 100 62 124 3 2028042608 20496960 19916784
20:37:30 8766 8192000000 10931538464 11359133696 1966970848 19.361 99 59 119 1 2007172640 21650704 18551088
20:38:03 9284 8192000000 10943298592 11378008064 1987129216 19.521 100 52 104 1 2027794528 24874240 15791072
20:38:26 8001 8192000000 10959085936 11381452800 1992307744 19.562 100 69 138 3 2044425360 30441856 21675760
20:38:41 5985 8192000000 10942658256 11372335104 1966362512 19.357 99 57 114 0 2015491440 31825968 17302960
20:38:54 4045 8192000000 10959581792 11380936704 1991062608 19.552 100 79 158 2 2049139936 33236256 24841072
20:39:07 14007 8192000000 10950863104 11378958336 1986285536 19.514 100 59 118 2 2037498864 32594816 18618512
20:39:31 5493 8192000000 10946832016 11381493760 1988290800 19.530 100 58 116 0 2038359120 31293792 18774528
20:39:44 12755 8192000000 10936758336 11374063616 1982049408 19.481 100 51 102 1 2028671440 30592640 16029392
20:40:10 6325 8192000000 10940178576 11365785600 1964021600 19.338 99 56 112 0 2008333648 26256112 18055936
20:40:24 3876 8192000000 10946391200 11366449152 1964019760 19.338 99 67 132 0 2011239168 27137360 20082048
20:40:35 3167 8192000000 10955432048 11377541120 1986799152 19.518 100 71 141 0 2037489440 29063888 21626400
20:40:48 9179 8192000000 10944120688 11376021504 1989067424 19.536 100 70 140 1 2039508336 28808288 21632624
20:41:11 4384 8192000000 10948797360 11373076480 1967846608 19.368 99 72 144 1 2021504784 30799584 22858592
20:41:23 5030 8192000000 10936696496 11352887296 1940769200 19.153 98 76 152 5 1994850640 30814000 23267440
20:41:35 5450 8192000000 10945659376 11366703104 1974351232 19.420 100 73 143 2 2027873344 31950208 21571904
20:41:48 10029 8192000000 10952751136 11375005696 1978756496 19.455 100 79 158 1 2036604256 33378352 24469408
20:42:07 1669 8192000000 10943258272 11358707712 1964410704 19.341 99 80 160 3 2022736960 33444944 24881312
20:42:15 3369 8192000000 10950959904 11367075840 1973029840 19.409 100 79 155 1 2032104224 35105888 23968496
20:42:27 4294 8192000000 10942268032 11365105664 1956508304 19.278 99 75 150 0 2016889168 36908016 23472848
20:42:38 8187 8192000000 10941638784 11360292864 1962750096 19.328 100 77 153 1 2024216928 37679312 23787520
20:43:00 2145 8192000000 10952811056 11372101632 1970424176 19.389 100 85 170 2 2035329840 37981056 26924608
20:43:10 5815 8192000000 10963332224 11372838912 1961316080 19.317 99 80 160 1 2021922272 35439424 25166768
20:43:23 3894 8192000000 10953278832 11373301760 1977794592 19.447 100 76 153 2 2034038112 33764960 22478560
20:43:35 1229 8192000000 10949703488 11367989248 1977069936 19.441 100 90 176 2 2040056912 35225488 27761488
20:43:46 1601 8192000000 10960089344 11375448064 1976494608 19.437 100 88 179 0 2040911792 37290976 27126208
20:43:56 4510 8192000000 10952498448 11366158336 1967534672 19.366 100 81 159 2 2030485232 38081056 24869504
20:44:09 1823 8192000000 10955212976 11375407104 1970782464 19.392 100 84 164 3 2039315088 42770480 25762144
20:44:18 1529 8192000000 10957717232 11363848192 1961852976 19.321 100 92 181 2 2028584448 38637296 28094176
20:44:27 3404 8192000000 10941406256 11365523456 1968320208 19.372 100 68 137 0 2029094064 39214720 21559136
20:44:40 4288 8192000000 10962334224 11379978240 1976733248 19.439 100 84 168 1 2044690192 41764256 26192688
20:44:51 5003 8192000000 10966294320 11381387264 1976962528 19.441 100 82 163 3 2042750928 41181968 24606432
20:45:05 3347 8192000000 10962751216 11383373824 1975426960 19.428 100 71 141 1 2038580320 41463440 21689920
20:45:22 2922 8192000000 10964345440 11391303680 1981326176 19.475 100 66 131 0 2044455696 41718432 21411088
20:45:33 1866 8192000000 10946913808 11354759168 1939621200 19.144 98 87 171 3 2008072688 41034208 27417280
20:45:42 2405 8192000000 10948903328 11364114432 1960802192 19.312 100 88 172 1 2030664752 42131120 27731440
20:45:52 2044 8192000000 10963889360 11370033152 1968204048 19.371 100 93 182 2 2042688960 44909616 29575296
20:46:03 5732 8192000000 10957590160 11373555712 1966267024 19.356 100 76 151 1 2034773472 45052896 23453552
20:46:19 1661 8192000000 10977374768 11385692160 1977782976 19.447 100 90 176 1 2051001536 44291376 28927184
20:46:28 5978 8192000000 10962563136 11389734912 1978708976 19.454 100 61 119 2 2042770224 44514064 19547184
20:46:41 10640 8192000000 10928523920 11365629952 1951768928 19.241 99 42 84 2 2008267360 42141264 14357168
20:47:04 10407 8192000000 10922518592 11358199808 1951833856 19.241 100 44 88 1 2003722640 37354176 14534608
20:47:25 11219 8192000000 10907897360 11346497536 1930934784 19.074 99 34 68 1 1978257248 36205616 11116848
20:47:53 14978 8192000000 10927370640 11364966400 1939068944 19.139 99 36 72 1 1991222384 39755056 12398384
20:48:17 12101 8192000000 10907442048 11355148288 1953949136 19.258 100 32 63 2 1998990464 33716704 11324624
20:48:43 14907 8192000000 10908553984 11364225024 1954216048 19.260 100 23 46 1 1995239024 32839296 8183680
20:49:04 1151 8192000000 10919270704 11365212160 1961105536 19.315 100 33 66 3 2005402304 32585120 11711648
20:49:14 14940 8192000000 10918843056 11372732416 1965813040 19.352 100 28 56 0 2010332928 34477824 10042064
20:49:41 15119 8192000000 10908983952 11351437312 1913421824 18.934 98 32 64 2 1962727280 37987792 11317664
20:50:03 23859 8192000000 10862047040 11319459840 1872684336 18.606 97 27 54 0 1920021008 37534000 9802672
20:50:34 22776 8192000000 10863758160 11316080640 1884057648 18.698 98 30 60 2 1927100304 32013472 11029184
20:51:05 24056 8192000000 10871616336 11331940352 1893930320 18.777 99 20 40 0 1930286304 29403776 6952208
20:51:49 20257 8192000000 10869428112 11320664064 1893833920 18.777 99 23 46 1 1941510880 39491520 8185440
20:52:19 18472 8192000000 10851906752 11330875392 1894254528 18.780 99 18 36 2 1936870336 36563872 6051936
20:52:44 17859 8192000000 10854742416 11318951936 1904139984 18.860 99 21 42 1 1924178736 13644288 6394464
20:53:21 27631 8192000000 10853493920 11318898688 1925712352 19.033 100 8 16 0 1937332080 9297776 2321952
20:54:00 61824 8192000000 10817868496 11275513856 1829557424 18.256 95 14 29 0 1843018880 8620992 4840464
20:55:08 49291 8192000000 10859721504 11286913024 1872092720 18.601 98 30 61 2 1886775600 6428112 8254768
20:56:07 128317 8192000000 10833494928 11284770816 1845169792 18.383 96 19 38 2 1858507360 8199120 5138448
20:58:44 84429 8192000000 10858827152 11307319296 1885382656 18.709 98 19 38 0 1898222464 7935504 4904304
21:00:16 30356 8192000000 10842494096 11292770304 1885156096 18.707 98 13 26 1 1898426496 9544976 3725424
21:01:05 31083 8192000000 10866208448 11317432320 1930157408 19.068 100 21 42 0 1948839376 12353904 6328064
21:01:43 8410 8192000000 10879794352 11324579840 1942659056 19.168 100 30 60 1 1964321456 13477952 8184448
21:02:00 6338 8192000000 10901391120 11330772992 1949998320 19.226 100 77 152 2 1982219664 10635232 21586112
21:02:13 42783 8192000000 10884172848 11339964416 1947659792 19.208 100 37 72 0 1969501472 11590416 10251264
21:03:06 36923 8192000000 10890988176 11331887104 1930654832 19.072 99 33 66 1 1950340752 10722336 8963584
21:03:49 41661 8192000000 10869511488 11318292480 1912004048 18.923 98 42 82 1 1940366832 15998864 12363920
21:04:41 24751 8192000000 10871841616 11328942080 1907552352 18.887 98 29 57 1 1929804896 14206080 8046464
21:05:17 38935 8192000000 10874923744 11331289088 1938619968 19.136 100 21 41 2 1964254688 19707296 5927424
21:06:03 61360 8192000000 10883142080 11339567104 1926321872 19.037 99 8 16 1 1938520112 9303344 2894896
21:07:18 34113 8192000000 10886748976 11345682432 1942713248 19.168 99 21 41 3 1960983408 11942688 6327472
21:08:25 148051 8192000000 10897213952 11356872704 1943691296 19.176 99 24 48 1 1966149616 15291856 7166464
21:11:01 44100 8192000000 10869792096 11350990848 1920747232 18.993 98 13 26 0 1945481248 21253488 3480528
21:11:51 40097 8192000000 10903613200 11357417472 1958859344 19.297 100 22 44 1 1976477296 11146496 6471456
21:12:43 27835 8192000000 10879726336 11339321344 1946074608 19.195 99 43 86 1 1971801296 12487632 13239056
21:13:18 90888 8192000000 10863979088 11310395392 1839563296 18.337 94 8 16 0 1853690656 11858080 2269280
21:15:04 20436 8192000000 10893538688 11321581568 1912367056 18.926 98 55 110 1 1936292464 7956944 15968464
21:15:33 62338 8192000000 10876786512 11353026560 1935091568 19.108 99 27 55 0 1960140864 17350000 7699296
21:16:51 108610 8192000000 10889404928 11345219584 1897116784 18.803 97 11 22 2 1920975648 20974144 2884720
21:18:52 53114 8192000000 10886238432 11360653312 1937133520 19.124 99 24 48 0 1965641200 21527504 6980176
21:19:53 101043 8192000000 10905134112 11373490176 1951757808 19.240 100 6 12 0 1967423840 14265312 1400720
21:21:40 100764 8192000000 10913237136 11377524736 1933548960 19.095 98 18 36 1 1955905040 17611552 4744528
21:23:27 149790 8192000000 10898837568 11357155328 1917850160 18.970 97 26 54 1 1936488848 11952672 6686016
21:26:04 42366 8192000000 10885921408 11336417280 1890873296 18.753 96 35 70 2 1912871104 12661824 9335984
21:26:55 52854 8192000000 10915636944 11365859328 1966665616 19.359 100 35 70 1 1986797680 9922800 10209264
21:27:56 31741 8192000000 10870630784 11333124096 1918673408 18.976 97 28 56 0 1934833344 8524160 7635776
21:28:37 43071 8192000000 10859092496 11332632576 1902849056 18.849 97 23 46 1 1916002304 6722224 6431024
21:30:07 56852 8192000000 10870197584 11344084992 1939797040 19.145 99 10 19 1 1950927136 8126592 3003504
21:31:30 28376 8192000000 10852189280 11331674112 1919728640 18.985 98 5 10 1 1930345200 8918048 1698512
21:32:07 20961 8192000000 10868599744 11339927552 1930816160 19.073 99 12 25 0 1943217792 8638784 3762848
21:33:16 55639 8192000000 10833803504 11312361472 1895826208 18.793 98 12 24 0 1910027600 10218352 3983040
21:34:20 54306 8192000000 10847576240 11320532992 1898536768 18.815 98 9 18 1 1910075360 9001776 2536816
21:35:20 63848 8192000000 10877331936 11340935168 1904525744 18.863 98 7 14 0 1916127856 9507232 2094880
21:36:40 31283 8192000000 10866003552 11333066752 1893498720 18.774 97 21 42 0 1907853968 8358416 5996832
21:38:05 68331 8192000000 10859732976 11336732672 1891895584 18.761 97 24 48 0 1910436112 11089760 7450768
21:39:48 66022 8192000000 10846301888 11320279040 1869038320 18.576 96 25 50 1 1885974608 10372464 6563824
21:41:15 84893 8192000000 10879084784 11340095488 1881410160 18.676 97 31 62 1 1899877024 10121952 8344912
21:42:47 64767 8192000000 10882237696 11342241792 1900444256 18.830 98 28 57 1 1922873504 14548400 7880848
21:44:00 22784 8192000000 10897362912 11345629184 1931269600 19.077 99 37 74 2 1956026096 14377440 10379056
21:44:34 30727 8192000000 10883641472 11345788928 1927996608 19.051 99 35 70 1 1952801792 14945392 9859792
21:45:27 32984 8192000000 10877101168 11338706944 1939224464 19.141 100 24 48 2 1959865152 13508880 7131808
21:46:21 69558 8192000000 10872815792 11340107776 1899015296 18.818 98 17 34 3 1917757008 14404592 4337120
21:49:04 206318 8192000000 10857688512 11334369280 1810484960 18.100 93 13 26 0 1830795504 16758704 3551840
21:52:36 23322 8192000000 10854039664 11328356352 1929155680 19.060 100 7 15 0 1944491488 13732960 1602848
21:53:07 75654 8192000000 10833196848 11313414144 1894776352 18.784 98 7 14 0 1903767776 7273952 1717472
21:55:35 60122 8192000000 10857803296 11338481664 1924370800 19.022 99 12 24 0 1941713168 14136432 3205936
21:56:53 77891 8192000000 10856304112 11336028160 1905851504 18.873 98 7 14 0 1916625936 8819024 1955408
21:58:19 92211 8192000000 10890285712 11365048320 1945789488 19.193 99 13 26 1 1961095056 11782016 3523552
22:00:14 61691 8192000000 10898955424 11364073472 1922057392 19.003 97 24 48 0 1939823920 11141456 6625072
22:01:28 66966 8192000000 10870144160 11348021248 1889527600 18.742 96 10 20 1 1904698288 12232368 2938320
22:02:42 39942 8192000000 10906394304 11356880896 1925062544 19.027 98 41 82 0 1945857904 8471360 12324000
22:03:29 81351 8192000000 10884393808 11363328000 1918976992 18.979 98 16 32 0 1935136880 11851440 4308448
22:05:07 44958 8192000000 10892953808 11364540416 1924870016 19.026 98 23 46 0 1942045104 10960336 6214752
22:06:58 138228 8192000000 10895357408 11361607680 1913223280 18.933 97 20 40 2 1929817632 11488288 5106064
22:09:23 29193 8192000000 10919646128 11383586816 1977469952 19.445 100 37 74 3 2001336976 13525904 10341120
22:10:10 89298 8192000000 10918480768 11379798016 1920777456 18.993 97 20 40 1 1947682992 21466048 5439488
22:11:47 74685 8192000000 10887997040 11360194560 1936074288 19.115 98 22 44 0 1959717248 17462416 6180544
22:13:38 89752 8192000000 10895898496 11366821888 1934355824 19.102 98 18 36 2 1947040544 7690528 4994192
22:15:15 40296 8192000000 10880661728 11354992640 1930880672 19.074 98 18 34 1 1943655904 7605200 5170032
22:16:02 56881 8192000000 10881254064 11363676160 1963617696 19.335 100 10 20 0 1974508832 8209264 2681872
22:17:10 21137 8192000000 10879040288 11364491264 1967734000 19.367 100 10 20 0 1977222592 7226944 2261648
22:17:38 18535 8192000000 10874782768 11353612288 1909353520 18.901 97 6 11 1 1919667888 8535296 1779072
22:18:08 67153 8192000000 10906393056 11376848896 1969975984 19.385 100 19 38 1 1985323664 10000832 5346848
22:19:21 38000 8192000000 10863051920 11343142912 1889467360 18.741 96 23 46 1 1906368800 10501888 6399552
22:20:08 32488 8192000000 10863438272 11352608768 1925222640 19.029 99 10 20 1 1942365040 14083728 3058672
22:20:51 84858 8192000000 10878737088 11371683840 1955251328 19.268 100 8 16 0 1967368128 9869472 2247328
22:22:25 48368 8192000000 10872390016 11353817088 1900151504 18.828 97 21 42 1 1917296080 10759984 6384592
22:23:20 35504 8192000000 10879222800 11344949248 1927818544 19.049 99 19 38 0 1942430160 10024096 4587520
22:24:07 20882 8192000000 10892003264 11356631040 1958724320 19.296 100 34 68 2 1977529104 9225504 9579280
22:24:35 31132 8192000000 10898385008 11361816576 1944661632 19.184 99 37 74 1 1967060560 11990208 10408720
22:25:15 29113 8192000000 10870370496 11347533824 1913891280 18.938 98 22 44 2 1930369808 9646896 6831632
22:25:53 77008 8192000000 10910280112 11370192896 1938899856 19.138 99 28 56 1 1959729248 12608480 8220912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-03-2021 22:28:42 to 10-03-2021 22:29:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 123 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-03-2021 22:29:14 to 10-03-2021 22:29:16.

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          236883
MON$OLDEST_ACTIVE               239187
MON$OLDEST_SNAPSHOT             239187
MON$NEXT_TRANSACTION            239187
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                       2018112
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:287: 
:288: mscs-test-161.budzdorov.ru    Wed Mar 10 22:27:26 2021
:289:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:290: 
:291: 
:292: mscs-test-161.budzdorov.ru    Wed Mar 10 22:27:26 2021
:293:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:294: 
--- end of diff output ---

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

10.03.21 22:29:17. 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-10 22:29:19 No severe PSQL-related problems occured
10.03.21 22:29:20. End of report.