Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.06.2021 16: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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17103784 kB
MemAvailable 31353140 kB
Buffers 0 kB
Cached 14537180 kB
SwapCached 2432 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-06-20 16:27:41
DTS_END                         2021-06-20 16:27:41.0440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(127:13) ==> X_MAKE_QSTORNO_2100_3300(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53630
TRN_ID                          239164
ATT_ID                          636
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: 9276.14 22366 1113137
customer order: creation 164.67 382 19760
customer order: refuse 14.56 345 1747
order to supplier: creation 44.15 1378 5298
order to supplier: removal 3.64 96685 437
invoice (draft): creation 44.97 3216 5396
invoice (draft): removal 54.93 739 6591
invoice accept: apply 39.78 17232 4773
invoice accept: cancel 49.71 737 5965
customer reserve: creation 3700.63 170 444075
customer reserve: removal 4875.22 57 585026
realization accept: apply 78.97 182 9477
realization accept: cancel 79.53 98 9544
payment from customer: creation 57.75 119 6930
payment from customer: removal 5.67 77 680
payment to supplier: creation 47.05 140 5646
payment to supplier: removal 3.15 73 378
service: total inventory turnovers 4.60 1110 552
service: total monetary turnovers 6.30 24 756
service: aggregate perf. data 0.85 23316 102
service: refresh index statistics 0.03 301245 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-06-2021 16:28:57 to 20-06-2021 16:28:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3261
TEST_TIME 2 3630
TEST_TIME 3 4183
TEST_TIME 4 3689
TEST_TIME 5 3970
TEST_TIME 6 4704
TEST_TIME 7 4685
TEST_TIME 8 5387
TEST_TIME 9 5489
TEST_TIME 10 5491
TEST_TIME 11 5629
TEST_TIME 12 5763
TEST_TIME 13 6220
TEST_TIME 14 6429
TEST_TIME 15 6577
TEST_TIME 16 6787
TEST_TIME 17 6900
TEST_TIME 18 7471
TEST_TIME 19 7533
TEST_TIME 20 7599
TEST_TIME 21 7979
TEST_TIME 22 8028
TEST_TIME 23 8159
TEST_TIME 24 8664
TEST_TIME 25 8590
TEST_TIME 26 8731
TEST_TIME 27 8731
TEST_TIME 28 9081
TEST_TIME 29 10153
TEST_TIME 30 10108
TEST_TIME 31 9957
TEST_TIME 32 9996
TEST_TIME 33 10085
TEST_TIME 34 10010
TEST_TIME 35 9974
TEST_TIME 36 9972
TEST_TIME 37 10243
TEST_TIME 38 9989
TEST_TIME 39 9861
TEST_TIME 40 9741
TEST_TIME 41 9647
TEST_TIME 42 9600
TEST_TIME 43 9513
TEST_TIME 44 9608
TEST_TIME 45 9478
TEST_TIME 46 9400
TEST_TIME 47 9457
TEST_TIME 48 9546
TEST_TIME 49 9546
TEST_TIME 50 9470
TEST_TIME 51 9395
TEST_TIME 52 9417
TEST_TIME 53 9337
TEST_TIME 54 9594
TEST_TIME 55 9507
TEST_TIME 56 9571
TEST_TIME 57 9564
TEST_TIME 58 9496
TEST_TIME 59 9556
TEST_TIME 60 9548
TEST_TIME 61 9551
TEST_TIME 62 9718
TEST_TIME 63 9653
TEST_TIME 64 9658
TEST_TIME 65 9714
TEST_TIME 66 9821
TEST_TIME 67 9800
TEST_TIME 68 9691
TEST_TIME 69 9647
TEST_TIME 70 9606
TEST_TIME 71 9547
TEST_TIME 72 9519
TEST_TIME 73 9530
TEST_TIME 74 9482
TEST_TIME 75 9439
TEST_TIME 76 9435
TEST_TIME 77 9362
TEST_TIME 78 9352
TEST_TIME 79 9391
TEST_TIME 80 9403
TEST_TIME 81 9445
TEST_TIME 82 9397
TEST_TIME 83 9407
TEST_TIME 84 9497
TEST_TIME 85 9501
TEST_TIME 86 9453
TEST_TIME 87 9553
TEST_TIME 88 9559
TEST_TIME 89 9646
TEST_TIME 90 9616
TEST_TIME 91 9584
TEST_TIME 92 9494
TEST_TIME 93 9475
TEST_TIME 94 9454
TEST_TIME 95 9446
TEST_TIME 96 9429
TEST_TIME 97 9372
TEST_TIME 98 9387
TEST_TIME 99 9386
TEST_TIME 100 9401
TEST_TIME 101 9375
TEST_TIME 102 9400
TEST_TIME 103 9393
TEST_TIME 104 9386
TEST_TIME 105 9455
TEST_TIME 106 9430
TEST_TIME 107 9436
TEST_TIME 108 9488
TEST_TIME 109 9475
TEST_TIME 110 9453
TEST_TIME 111 9401
TEST_TIME 112 9366
TEST_TIME 113 9335
TEST_TIME 114 9384
TEST_TIME 115 9363
TEST_TIME 116 9327
TEST_TIME 117 9288
TEST_TIME 118 9323
TEST_TIME 119 9328
TEST_TIME 120 9281

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-06-2021 16:29:01 to 20-06-2021 16:29:04.

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 1526005 1526005 0 0.00 0 31020 6 0 0
doc_list_biud 1526005 1526005 0 0.00 0 61989 27 0 0
sp_add_invoice_to_stock 4894 4773 121 2.47 43 197614 17232 0 121
sp_cancel_adding_invoice 5965 5965 0 0.00 4 86145 738 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 14737 346 0 0
sp_cancel_customer_reserve 585026 585026 0 0.00 1 61996 58 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 3 5590 78 0 0
sp_cancel_pay_to_supplier 378 378 0 0.00 3 3557 74 0 0
sp_cancel_supplier_invoice 6600 6591 9 0.13 2 30247 740 0 9
sp_cancel_supplier_order 437 437 0 0.00 8 932356 96686 0 0
sp_cancel_write_off 9544 9544 0 0.00 1 18179 99 0 0
sp_client_order 19760 19760 0 0.00 3 31080 383 0 0
sp_customer_reserve 444075 444075 0 0.00 0 66987 171 0 0
sp_fill_shopping_cart 30448 30448 0 0.00 1 10881 38 0 0
sp_fill_shopping_cart_clo_res 444072 444072 0 0.00 0 22182 13 0 0
sp_get_clo_for_invoice 4764 4764 0 0.00 0 20765 303 0 0
sp_kill_cost_storno 16567 16567 0 0.00 0 31011 52 0 0
sp_kill_qstorno_ret_qs2qd 1186624 1186624 0 0.00 0 61974 31 0 0
sp_kill_qty_storno 623551 623551 0 0.00 0 61987 67 0 0
sp_lock_selected_doc 19896 19896 0 0.00 0 8488 3 0 0
sp_make_cost_storno 26817 26817 0 0.00 0 13596 59 0 0
sp_multiply_rows_for_pdistr 26817 26817 0 0.00 0 8625 27 0 0
sp_multiply_rows_for_qdistr 19760 19760 0 0.00 0 24106 180 0 0
sp_pay_from_customer 6930 6930 0 0.00 4 16129 120 0 0
sp_pay_to_supplier 5646 5646 0 0.00 5 13640 140 0 0
sp_payment_common 12576 12576 0 0.00 1 11158 36 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 11012 313 0 0
sp_qd_handle_on_invoice_upd_sts 10729 10729 0 0.00 0 45678 305 0 0
sp_qd_handle_on_reserve_upd_sts 9477 9477 0 0.00 0 11243 53 0 0
sp_reserve_write_off 9477 9477 0 0.00 6 15792 182 0 0
sp_supplier_invoice 5396 5396 0 0.00 6 84160 3217 0 0
sp_supplier_order 5298 5298 0 0.00 5 37114 1378 0 0
srv_aggregate_perf_data 102 102 0 0.00 2889 499014 23317 0 0
srv_fill_mon_cache_memory 148 148 0 0.00 1672 159103 36515 0 0
srv_find_qd_qs_mism 1067965 1067965 0 0.00 0 19649 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 68 84590 1110 0 0
srv_make_money_saldo 756 756 0 0.00 1 3551 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 153768 434241 301245 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 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4773 4773 0 0.00 0 30910 158 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 6620 97 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 4066 14 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 539 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 1171 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 378 378 0 0.00 0 130 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 383 383 0 0.00 0 1432 9 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 47267 1586 0 0
t$perf-norm:sp_cancel_write_off 944 944 0 0.00 0 3594 15 0 0
t$perf-norm:sp_client_order 19760 19760 0 0.00 0 6146 17 0 0
t$perf-norm:sp_customer_reserve 968 968 0 0.00 0 3981 10 0 0
t$perf-norm:sp_pay_from_customer 6930 6930 0 0.00 0 4942 7 0 0
t$perf-norm:sp_pay_to_supplier 5646 5646 0 0.00 0 7066 12 0 0
t$perf-norm:sp_reserve_write_off 9477 9477 0 0.00 0 7525 11 0 0
t$perf-norm:sp_supplier_invoice 5396 5396 0 0.00 0 9408 16 0 0
t$perf-norm:sp_supplier_order 5299 5299 0 0.00 0 3490 14 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 308 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 148 148 0 0.00 0 279 3 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 3156 31 0 0
t$perf-norm:srv_make_money_saldo 756 756 0 0.00 0 681 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 437 121 0 0
v_add_invoice_to_stock 9770 9528 242 2.47 0 9172 25 0 242
v_all_customers 36326 36326 0 0.00 0 174 0 0 0
v_all_suppliers 29654 29654 0 0.00 0 17 1 0 0
v_all_wares 39520 39520 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 4034 13 0 0
v_cancel_client_order 3494 3494 0 0.00 0 6779 11 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 5582 11 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 4056 9 0 0
v_cancel_payment_to_supplier 756 756 0 0.00 0 3538 13 0 0
v_cancel_supplier_invoice 784 766 18 2.29 0 4082 28 0 18
v_cancel_supplier_order 874 874 0 0.00 0 5935 15 0 0
v_cancel_write_off 1888 1888 0 0.00 0 3775 17 0 0
v_max_id_clo_ord 5297 5297 0 0.00 0 257 1 0 0
v_max_id_clo_res 968 968 0 0.00 0 2422 16 0 0
v_max_id_ord_sup 5391 5391 0 0.00 0 6759 4 0 0
v_max_non_paid_invoice 1507 1507 0 0.00 0 438 2 0 0
v_max_non_paid_realizn 3574 3574 0 0.00 0 1990 5 0 0
v_min_id_clo_ord 5297 5297 0 0.00 0 10670 12 0 0
v_min_id_clo_res 968 968 0 0.00 0 5753 9 0 0
v_min_id_ord_sup 5391 5391 0 0.00 0 7475 9 0 0
v_min_non_paid_invoice 5646 5646 0 0.00 0 8984 27 0 0
v_min_non_paid_realizn 6930 6930 0 0.00 0 11154 25 0 0
v_our_firm 9906 9906 0 0.00 0 13 1 0 0
v_reserve_write_off 18954 18954 0 0.00 0 6390 11 0 0
x_lock_depdocs_on_canc_invoice 12173 12173 0 0.00 0 18000 108 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 8133 277 0 0
x_make_qstorno_1000_1200 5298 5298 0 0.00 2 37106 1305 0 0
x_make_qstorno_1200_2000 5396 5396 0 0.00 2 79024 3076 0 0
x_make_qstorno_2100_3300 444075 444075 0 0.00 0 66986 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-06-2021 16:29:05 to 20-06-2021 16:29:09.

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
13:57:44 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:51 12130 8192000000 10214453376 10513772544 796224736 8.858 64 53 106 0 817620400 2411648 18984016
13:58:10 10947 8192000000 10291054144 10604638208 1351237664 14.159 100 85 172 0 1382877728 3989200 27650864
13:58:31 35240 8192000000 10358359488 10674081792 1407719872 14.664 100 92 184 1 1443002912 5636720 29646320
13:59:13 21524 8192000000 10392511168 10712788992 1436489152 14.919 100 89 178 0 1472911280 6875184 29546944
13:59:45 12630 8192000000 10399905552 10722099200 1454481408 15.077 100 91 182 0 1492008512 7877264 29649840
14:00:15 11110 8192000000 10417595680 10741415936 1470247328 15.216 100 87 174 1 1506688576 8367600 28073648
14:00:38 24167 8192000000 10442097056 10775154688 1492223808 15.408 100 85 170 1 1528010192 8550064 27236320
14:01:13 19003 8192000000 10464397280 10801168384 1525675216 15.700 100 90 178 2 1562848416 9063792 28109408
14:01:42 18280 8192000000 10503746800 10847748096 1561438016 16.009 100 85 170 0 1596968944 9336816 26194112
14:02:09 10329 8192000000 10517430816 10865262592 1574492608 16.121 100 85 170 0 1610765440 10019328 26253504
14:02:33 8208 8192000000 10536615504 10887405568 1593187632 16.281 100 82 164 2 1628099472 9910576 25001264
14:03:04 9524 8192000000 10562309376 10920390656 1618893568 16.500 100 76 152 0 1651963392 10419232 22650592
14:03:22 12885 8192000000 10580678064 10940280832 1640532384 16.684 100 76 152 2 1673868336 10830464 22505488
14:03:44 8876 8192000000 10588775952 10953613312 1652198608 16.783 100 78 156 0 1686541808 11309312 23033888
14:04:03 13110 8192000000 10619300912 10986172416 1676263904 16.986 100 77 154 2 1709693456 10886688 22542864
14:04:23 11366 8192000000 10650159200 11018424320 1704807968 17.225 100 84 165 2 1739702944 11509040 23385936
14:04:42 10771 8192000000 10669790720 11038793728 1723780432 17.384 100 82 164 1 1759861728 12448336 23632960
14:04:59 8324 8192000000 10677067136 11049828352 1741382128 17.530 100 86 170 1 1778418128 12702896 24333104
14:05:16 5362 8192000000 10692391328 11067342848 1753467008 17.630 100 78 154 1 1787815088 12642352 21705728
14:05:28 5144 8192000000 10695060144 11076841472 1763278304 17.711 100 69 138 0 1795044512 12482464 19283744
14:05:42 4498 8192000000 10716497056 11091324928 1775291824 17.811 100 85 170 0 1812197552 12580528 24325200
14:05:54 4344 8192000000 10714835008 11096305664 1778131008 17.834 100 81 164 2 1813107696 11647104 23329584
14:06:05 3337 8192000000 10734526128 11110105088 1790795904 17.938 100 89 180 2 1828309056 12388592 25124560
14:06:16 3852 8192000000 10735654240 11118804992 1796234656 17.983 100 83 167 1 1832896256 13743024 22918576
14:06:26 3589 8192000000 10744318384 11128664064 1802949664 18.038 100 79 158 0 1839000976 13357056 22694256
14:06:36 3285 8192000000 10742588640 11129606144 1810875152 18.103 100 86 171 1 1848904992 14040672 23989168
14:06:46 8865 8192000000 10748536880 11135516672 1813343424 18.123 100 77 154 1 1848942256 13863088 21735744
14:07:02 3369 8192000000 10756906240 11143024640 1814920912 18.136 100 78 153 0 1849553184 14162992 20469280
14:07:12 2520 8192000000 10772617968 11160719360 1828566096 18.248 100 86 170 0 1867125904 14475504 24084304
14:07:21 2183 8192000000 10782488336 11166973952 1840333760 18.344 100 97 194 0 1883185664 15854256 26997648
14:07:30 2641 8192000000 10784584656 11170242560 1842393952 18.360 100 88 174 1 1881307408 14690368 24223088
14:07:39 2160 8192000000 10793389248 11179245568 1846926976 18.397 100 90 181 2 1890555328 18781296 24847056
14:07:47 1785 8192000000 10799311376 11183919104 1851920128 18.438 100 94 185 0 1892885552 14558176 26407248
14:07:55 1372 8192000000 10801072384 11190575104 1853780832 18.453 100 89 178 0 1893065760 13902256 25382672
14:08:03 1570 8192000000 10802834592 11187765248 1860832464 18.510 100 91 180 1 1899053472 13031408 25189600
14:08:11 1312 8192000000 10806401440 11196231680 1864306896 18.538 100 93 186 3 1905640592 14352624 26981072
14:08:19 2168 8192000000 10810099952 11197706240 1865249152 18.546 100 93 186 0 1905791520 14226288 26316080
14:08:27 1241 8192000000 10807356272 11194990592 1868883952 18.575 100 91 180 1 1906791648 12019872 25887824
14:08:34 1593 8192000000 10814274112 11206635520 1873419584 18.612 100 86 173 2 1910012928 11338544 25254800
14:08:42 26493 8192000000 10801800080 11203600384 1867935024 18.568 100 60 121 1 1894618400 9475424 17207952
14:09:15 21963 8192000000 10795971072 11203776512 1870672544 18.590 100 39 79 2 1888903472 6932368 11298560
14:09:44 5126 8192000000 10784413808 11206193152 1875611632 18.630 100 42 84 1 1894834592 7358160 11864800
14:09:56 5418 8192000000 10787585280 11211309056 1881351648 18.676 100 58 114 3 1905989488 7881824 16756016
14:10:07 6038 8192000000 10787301312 11210108928 1876564288 18.637 100 28 56 3 1891626512 7314592 7747632
14:10:19 4538 8192000000 10787713504 11216093184 1881649600 18.678 100 35 70 1 1898662080 6879248 10133232
14:10:31 8213 8192000000 10786359280 11215319040 1881062400 18.674 100 29 58 1 1896200672 6922208 8216064
14:10:47 16645 8192000000 10794738576 11225227264 1885967584 18.713 100 28 55 1 1899811904 6479568 7364752
14:11:10 5360 8192000000 10810482080 11230654464 1891857856 18.761 100 34 67 4 1908116176 7163184 9095136
14:11:22 8426 8192000000 10791453392 11231461376 1892910000 18.769 100 24 47 2 1905673728 6601520 6162208
14:11:37 11002 8192000000 10797954528 11238096896 1896877200 18.801 100 15 30 0 1911426960 10320336 4229424
14:12:02 11477 8192000000 10805846832 11237945344 1896609120 18.799 100 17 34 0 1908198352 7101648 4487584
14:12:20 10113 8192000000 10809197632 11244875776 1900376912 18.829 100 15 30 2 1915083824 10627520 4079392
14:12:38 12229 8192000000 10819150064 11248783360 1903936512 18.858 100 19 32 3 1915408272 6038272 5433488
14:12:56 16369 8192000000 10821372720 11256066048 1910106560 18.908 100 32 62 4 1924016064 5163008 8746496
14:13:23 63063 8192000000 10831189632 11265019904 1911733200 18.921 100 31 63 0 1926531968 5320272 9478496
14:14:33 4425 8192000000 10824043824 11263205376 1911533696 18.919 100 22 44 2 1924102128 6613312 5955120
14:14:45 7847 8192000000 10829301152 11266056192 1914170784 18.940 100 22 44 2 1926702352 6485760 6045808
14:15:02 3378 8192000000 10846246192 11274010624 1918043088 18.971 100 42 83 0 1938300512 8334912 11922512
14:15:12 4131 8192000000 10833859504 11267788800 1917043216 18.963 100 37 74 3 1935416416 8326832 10046368
14:15:22 4934 8192000000 10839207360 11276226560 1917055328 18.963 100 26 52 0 1935932064 11531424 7345312
14:15:33 7414 8192000000 10828891424 11262517248 1900966224 18.834 99 32 63 1 1916234976 5788304 9480448
14:15:47 3193 8192000000 10821058416 11259645952 1899004912 18.818 99 36 72 1 1915678544 6386528 10287104
14:15:59 4646 8192000000 10819477664 11254902784 1905102480 18.867 100 33 65 1 1920278544 5251248 9924816
14:16:13 8415 8192000000 10810636368 11247075328 1894654768 18.783 99 13 26 2 1903805280 5592896 3557616
14:16:30 8809 8192000000 10808597552 11244736512 1895229184 18.788 99 24 48 1 1908821168 6643792 6948192
14:16:45 10805 8192000000 10820203936 11253489664 1856386608 18.474 97 21 43 2 1868680480 5740160 6553712
14:17:03 9047 8192000000 10821510512 11260485632 1910201120 18.908 100 25 49 0 1924319152 7059200 7058832
14:17:18 7944 8192000000 10800244080 11227545600 1855159744 18.464 97 17 33 4 1865480256 5222944 5097568
14:17:33 6621 8192000000 10770302240 11203907584 1828678688 18.249 97 21 42 0 1840850480 6298272 5873520
14:17:48 20653 8192000000 10774508720 11179507712 1761270976 17.695 94 18 37 1 1771350672 5043216 5036480
14:18:15 43565 8192000000 10768780896 11191603200 1845523104 18.386 99 26 52 1 1858368256 5660016 7185136
14:19:11 22911 8192000000 10777536832 11209609216 1806525664 18.067 96 17 33 2 1816296752 4990784 4780304
14:19:42 7942 8192000000 10763967904 11188039680 1807984112 18.079 97 25 50 2 1819945600 5635616 6325872
14:19:59 7249 8192000000 10748365488 11164782592 1774502944 17.804 96 31 62 0 1790195104 6735760 8956400
14:20:14 4853 8192000000 10723944432 11139407872 1783091504 17.875 98 30 62 0 1797940144 5164928 9683712
14:20:27 7592 8192000000 10698580816 11109793792 1702020432 17.202 94 27 53 3 1714441328 4970704 7450192
14:20:44 7244 8192000000 10686502800 11098746880 1702686336 17.208 95 27 55 0 1719626960 9717552 7223072
14:20:59 6600 8192000000 10704312368 11114246144 1754228960 17.637 98 31 63 1 1769090672 5894112 8967600
14:21:13 6716 8192000000 10687511936 11102359552 1768572928 17.755 99 27 54 2 1782381808 6159440 7649440
14:21:29 9192 8192000000 10706955680 11123871744 1745943920 17.568 97 20 40 0 1758205856 5808752 6453184
14:21:46 10128 8192000000 10731704688 11151953920 1799802192 18.012 99 25 50 1 1816965024 9599600 7563232
14:22:02 8062 8192000000 10725691760 11143925760 1813014896 18.121 100 21 43 2 1828324736 9929120 5380720
14:22:16 8192 8192000000 10736175328 11152941056 1804433872 18.050 99 24 46 0 1816301248 5302832 6564544
14:22:31 10429 8192000000 10740468432 11167940608 1817317120 18.156 99 25 51 4 1830565648 5857168 7391360
14:22:48 8933 8192000000 10752308816 11180343296 1822613376 18.199 99 28 57 4 1839740112 9459792 7666944
14:23:04 62049 8192000000 10761228656 11185688576 1830912528 18.267 99 30 59 3 1845883712 5084016 9887168
14:24:18 23075 8192000000 10781661008 11203465216 1858611136 18.492 100 29 57 4 1872880272 6317232 7951904
14:24:49 7960 8192000000 10769091040 11199488000 1859597776 18.500 100 26 52 1 1873246864 6503776 7145312
14:25:05 10306 8192000000 10785948000 11214553088 1867168912 18.561 100 39 78 1 1889729792 11637120 10923760
14:25:22 8920 8192000000 10786501312 11214270464 1867097488 18.561 100 27 54 0 1880730752 5930736 7702528
14:25:40 5132 8192000000 10790675888 11212312576 1868192496 18.570 100 33 62 4 1883124304 5670048 9261760
14:25:55 9257 8192000000 10780194080 11216474112 1870162784 18.586 100 12 24 1 1878482064 4928528 3390752
14:26:11 6128 8192000000 10792181648 11222192128 1875871264 18.632 100 24 48 2 1888501904 5580400 7050240
14:26:23 9312 8192000000 10788207904 11220668416 1877969824 18.649 100 17 34 0 1888334736 5089680 5275232
14:26:40 12047 8192000000 10802630768 11231887360 1877465024 18.645 100 16 32 0 1887454800 5254416 4735360
14:26:59 9864 8192000000 10826410448 11244949504 1892398016 18.765 100 24 48 2 1904556048 5338864 6819168
14:27:15 13542 8192000000 10812539904 11250798592 1904253472 18.860 100 8 16 2 1910457392 4472096 1731824
14:27:37 19589 8192000000 10829879968 11262201856 1913222832 18.933 100 26 50 1 1925715568 5376656 7116080
14:28:06 18333 8192000000 10861701328 11280326656 1929536240 19.063 100 61 121 1 1954613344 8210208 16866896
14:28:35 52921 8192000000 10868264832 11296059392 1932659760 19.088 100 53 104 2 1958549840 9754496 16135584
14:29:37 141319 8192000000 10870285200 11313307648 1927884336 19.050 99 37 74 1 1947081600 8702672 10494592
14:32:09 16978 8192000000 10888879760 11322585088 1960532880 19.310 100 35 70 1 1985061344 14495984 10032480
14:32:33 12520 8192000000 10893500768 11320717312 1938880048 19.138 99 49 98 1 1968745120 15864048 14001024
14:32:54 12169 8192000000 10905052480 11332980736 1965146144 19.347 100 60 118 3 1995337968 12796784 17395040
14:33:25 18701 8192000000 10891245504 11331100672 1949205936 19.220 99 38 76 2 1975422528 14329840 11886752
14:33:55 19642 8192000000 10906230016 11340541952 1969119440 19.378 100 37 74 0 1992570800 12625072 10826288
14:34:35 31071 8192000000 10915244384 11352948736 1974501648 19.421 100 54 107 2 2005537520 15286240 15749632
14:35:24 5452 8192000000 10924422288 11359690752 1979015008 19.457 100 40 79 0 2009441408 18305952 12120448
14:35:36 17299 8192000000 10937565376 11366707200 1992667440 19.565 100 57 114 0 2026686096 15864464 18154192
14:36:05 15807 8192000000 10937729440 11377283072 1997912976 19.606 100 49 97 1 2027572384 15382912 14276496
14:36:30 5999 8192000000 10924867328 11358961664 1976147600 19.434 99 50 97 1 2005946128 15152976 14645552
14:36:44 3428 8192000000 10948933680 11376795648 2001266592 19.633 100 66 132 1 2036751376 16213584 19271200
14:36:56 6668 8192000000 10945612528 11378036736 2005891312 19.669 100 71 138 2 2042899072 16929936 20077824
14:37:10 2189 8192000000 10958503360 11383406592 2008355776 19.689 100 70 140 0 2047909264 18949232 20604256
14:37:22 18758 8192000000 10953131360 11382505472 1987447104 19.524 99 61 122 2 2025170384 19343008 18380272
14:37:47 18813 8192000000 10950093312 11380436992 1987884032 19.527 99 64 124 3 2028831568 22499360 18448176
14:38:13 14018 8192000000 10944201136 11378352128 1981186272 19.474 99 55 110 1 2021703984 23197920 17319792
14:38:37 8275 8192000000 10935448800 11371589632 1974492960 19.421 99 52 104 1 2011809408 21179600 16136848
14:38:54 7604 8192000000 10934581840 11374309376 1988049392 19.528 100 50 99 2 2026349520 22363488 15936640
14:39:14 25224 8192000000 10928412288 11366637568 1953935824 19.258 98 47 95 1 1992892144 24285712 14670608
14:39:50 2460 8192000000 10944913024 11374764032 1987341376 19.523 100 67 129 2 2032261456 25108640 19811440
14:40:00 9849 8192000000 10949020336 11376717824 1986204720 19.514 100 55 107 2 2029037616 25675392 17157504
14:40:16 3423 8192000000 10956366128 11389161472 1997997120 19.607 100 60 120 0 2043399008 26476048 18925840
14:40:27 3735 8192000000 10971485696 11396689920 2004824736 19.661 100 78 151 0 2055868688 26724144 24319808
14:40:38 5271 8192000000 10973110704 11396988928 1992203152 19.561 99 72 144 0 2041048016 26570896 22273968
14:40:59 6923 8192000000 10967809984 11399012352 2007047248 19.678 100 60 121 1 2050686912 24802304 18837360
14:41:22 14846 8192000000 10943791184 11394457600 1986663488 19.517 99 52 103 3 2029047856 26370800 16013568
14:41:47 12177 8192000000 10954657648 11394347008 1996497072 19.595 100 46 90 1 2037327568 26404752 14425744
14:42:08 6987 8192000000 10954696032 11382366208 1989657648 19.541 100 59 117 1 2035945872 28252256 18035968
14:42:21 12753 8192000000 10966642800 11389304832 1979123376 19.458 99 74 148 3 2031622688 30045792 22453520
14:42:43 6425 8192000000 10970454208 11395735552 1998877440 19.614 100 71 141 0 2055289104 34797216 21614448
14:42:59 13009 8192000000 10980893856 11411845120 2007342576 19.681 100 71 139 1 2063722560 35208512 21171472
14:43:20 11808 8192000000 10974119280 11412049920 2006250784 19.672 100 55 110 0 2061832224 38217344 17364096
14:43:41 2844 8192000000 10974747696 11417284608 2007749888 19.684 100 50 99 1 2061452928 37091936 16611104
14:43:51 5677 8192000000 10982496032 11422605312 2012634496 19.722 100 60 119 1 2070231296 38749184 18847616
14:44:04 15402 8192000000 10972671024 11418087424 2006764720 19.676 100 56 112 1 2059309552 34740240 17804592
14:44:28 3540 8192000000 10984720800 11421790208 2014807376 19.739 100 57 111 1 2070172656 38429952 16935328
14:44:41 5944 8192000000 10976611088 11409395712 2003015648 19.647 100 57 114 1 2059422576 38803408 17603520
14:44:55 1896 8192000000 10998441184 11418255360 2008102416 19.687 100 82 164 1 2075063024 41271360 25689248
14:45:04 1670 8192000000 11003281008 11418599424 2014584144 19.738 100 94 186 1 2085688384 42790368 28313872
14:45:13 2780 8192000000 10987940496 11416698880 2006320288 19.673 100 74 148 1 2072453152 43655632 22477232
14:45:28 7453 8192000000 10960153072 11396718592 1987644000 19.525 100 59 118 0 2046479328 40803056 18032272
14:45:45 4691 8192000000 10942795808 11372425216 1957187024 19.284 99 55 110 3 2013422976 38587248 17648704
14:45:58 9405 8192000000 10931517632 11376259072 1974799168 19.424 100 37 74 1 2022781456 35554608 12427680
14:46:19 7175 8192000000 10941014416 11377680384 1970658960 19.391 100 45 90 3 2021942784 37109216 14174608
14:46:37 2051 8192000000 10939857888 11365683200 1953481248 19.254 99 74 147 5 2018681440 40987440 24212752
14:46:49 4157 8192000000 10951640816 11384897536 1976008304 19.433 100 54 107 2 2034114368 40185376 17920688
14:47:07 5489 8192000000 10929770128 11371671552 1952453152 19.246 99 43 88 1 2004914672 38693632 13767888
14:47:34 4054 8192000000 10959148656 11385982976 1982038800 19.481 100 61 120 2 2039562896 37987376 19536720
14:47:46 6570 8192000000 10967132192 11398586368 1986388176 19.515 100 59 118 1 2049383168 43899264 19095728
14:48:00 2872 8192000000 10966075680 11396804608 1987406736 19.523 100 61 122 0 2046182800 39317968 19458096
14:48:17 8489 8192000000 10935390080 11374252032 1941065328 19.155 98 48 95 0 1994579888 38162480 15352080
14:48:38 14136 8192000000 10942334816 11394932736 1979457696 19.460 100 32 64 0 2030805088 40419760 10927632
14:49:00 6052 8192000000 10946663216 11396059136 1988558624 19.532 100 41 83 2 2038833584 37202144 13072816
14:49:26 6661 8192000000 10936974368 11374374912 1956313648 19.277 99 53 107 0 2011890112 39381984 16194480
14:49:39 9349 8192000000 10934304512 11383001088 1970807680 19.392 100 31 62 4 2021783296 40254912 10720704
14:50:08 19490 8192000000 10902478704 11344224256 1902399904 18.846 97 30 60 1 1954178176 41420336 10357936
14:50:36 8702 8192000000 10912414496 11351781376 1929310624 19.061 99 46 92 2 1987588208 43158512 15119072
14:50:53 12281 8192000000 10917303600 11352240128 1924579872 19.024 99 40 77 3 1980766000 43914304 12271824
14:51:15 11175 8192000000 10923303696 11370790912 1953755792 19.256 100 35 70 2 2011714864 46050336 11908736
14:51:43 23354 8192000000 10907340768 11354144768 1947615168 19.207 100 30 58 0 1996713888 39130656 9968064
14:52:13 10957 8192000000 10901952400 11341398016 1925504896 19.031 99 42 84 1 1973529344 35206176 12818272
14:52:44 24672 8192000000 10889797104 11335507968 1915307056 18.949 99 28 56 4 1963572640 39080048 9185536
14:53:26 36247 8192000000 10866529408 11316060160 1892630880 18.767 99 16 32 2 1936900096 38758064 5511152
14:54:09 26937 8192000000 10831843264 11278753792 1848535360 18.410 97 20 40 0 1908285120 51913408 7836352
14:55:10 29175 8192000000 10870100464 11316113408 1858770240 18.493 98 18 37 0 1916007104 50013504 7223360
14:55:46 14736 8192000000 10857715328 11324506112 1872426496 18.604 99 14 28 1 1928671568 51078784 5166288
14:56:28 70593 8192000000 10842341856 11293704192 1863441616 18.531 98 9 18 1 1876687872 10852816 2393440
14:57:54 49326 8192000000 10877749648 11319533568 1901504080 18.838 98 34 69 1 1918797216 8485856 8807280
14:58:52 73447 8192000000 10903513280 11328442368 1922253872 19.005 99 38 73 2 1945068240 12356240 10458128
15:00:16 60732 8192000000 10875948048 11331170304 1930374080 19.070 99 10 20 0 1939851056 7305696 2171280
15:01:23 22801 8192000000 10876654400 11325468672 1927325536 19.045 99 13 26 1 1938716000 7535232 3855232
15:01:55 55473 8192000000 10894788032 11336515584 1897540320 18.807 97 13 26 1 1907838048 6152592 4145136
15:02:58 37311 8192000000 10899616928 11357835264 1967300096 19.364 100 28 54 3 1985777904 10643536 7834272
15:03:45 65764 8192000000 10893129840 11365208064 1927403280 19.046 98 9 18 0 1948415952 17573600 3439072
15:05:00 159103 8192000000 10924258496 11368124416 1969881536 19.385 100 39 78 0 1995079792 14369360 10828896
15:07:45 64674 8192000000 10902017088 11368361984 1973778384 19.415 100 25 50 0 1994302144 13335616 7188144
15:08:57 8590 8192000000 10907169632 11366129664 1979418448 19.460 100 53 106 2 2005762112 10887328 15456336
15:09:17 18219 8192000000 10890741856 11354460160 1947624816 19.208 99 21 42 1 1964754288 11246976 5882496
15:09:42 14298 8192000000 10927605568 11374227456 1973050320 19.410 100 28 56 1 1994359408 13229296 8079792
15:10:07 25367 8192000000 10936582336 11384143872 1982098080 19.481 100 49 96 1 2012365792 16371424 13896288
15:10:39 34546 8192000000 10915070672 11386380288 1979895024 19.464 100 25 50 3 2004317712 17050352 7372336
15:11:24 48704 8192000000 10922858432 11394158592 1988112800 19.529 100 12 24 0 2007143328 15214384 3816144
15:12:21 74662 8192000000 10922932848 11389374464 1958539072 19.294 98 18 36 2 1981533296 17611360 5382864
15:13:43 58934 8192000000 10895829920 11371573248 1968098080 19.370 99 22 42 1 1994576560 19674048 6804432
15:14:48 70439 8192000000 10913866976 11390513152 1940511664 19.151 98 11 21 1 1959493840 15910896 3071280
15:16:10 51592 8192000000 10924639440 11401895936 1987809920 19.526 100 15 30 0 2009162304 16890192 4462192
15:17:49 69744 8192000000 10916666624 11401826304 1995449200 19.587 100 10 20 1 2011248416 13033392 2765824
15:19:08 63791 8192000000 10916850432 11394859008 1973778240 19.415 99 19 38 2 1993594976 14588320 5228416
15:20:26 76703 8192000000 10930582816 11410165760 1954312192 19.261 98 19 38 0 1978955248 19186544 5456512
15:22:50 58467 8192000000 10898846592 11377827840 1950227776 19.228 98 31 62 0 1971292000 11632640 9431584
15:24:01 56410 8192000000 10907838016 11381059584 1960993920 19.314 99 23 46 1 1975170816 7858432 6318464
15:25:04 21445 8192000000 10929801072 11383869440 1986334176 19.515 100 29 58 2 2002521952 8532368 7655408
15:25:37 28928 8192000000 10938193568 11385016320 1974039424 19.417 99 47 94 1 1998244064 11099184 13105456
15:26:17 14456 8192000000 10935075536 11392811008 1990947280 19.551 100 42 84 2 2015997536 13036416 12013840
15:26:44 51925 8192000000 10894303920 11369054208 1911139904 18.916 96 26 52 0 1929094432 11409824 6544704
15:27:43 26453 8192000000 10911172496 11364212736 1939298944 19.141 98 35 69 0 1957741248 8419712 10022592
15:28:21 57070 8192000000 10894344112 11371257856 1898440192 18.814 96 23 45 2 1918090096 13303168 6346736
15:29:52 64027 8192000000 10887659888 11343978496 1886101024 18.714 96 11 22 0 1896393216 7573568 2718624
15:31:03 46109 8192000000 10899522256 11331870720 1829110640 18.252 93 35 71 2 1847408912 8900704 9397568
15:32:00 17701 8192000000 10886934048 11335909376 1890620480 18.751 97 39 76 0 1911222624 9857152 10744992
15:32:36 37706 8192000000 10902348944 11367809024 1926482528 19.039 99 34 68 4 1948982800 13129472 9370800
15:33:20 26062 8192000000 10865498560 11344781312 1907995728 18.891 98 14 28 1 1931727760 19481856 4250176
15:34:54 101865 8192000000 10889826224 11356176384 1935284528 19.109 99 26 52 0 1953753248 11276976 7191744
15:36:42 121993 8192000000 10888960592 11348226048 1870509424 18.588 95 29 58 1 1891773488 12686992 8577072
15:38:50 69351 8192000000 10855243024 11327369216 1908883952 18.898 98 22 44 0 1929719392 14725120 6110320
15:40:06 69269 8192000000 10862509136 11337183232 1901602400 18.839 97 13 26 0 1915876016 11232816 3040800
15:41:21 54415 8192000000 10869983184 11344191488 1893220368 18.772 97 10 20 1 1904688288 8501296 2966624
15:42:23 86748 8192000000 10852570240 11327557632 1879437632 18.661 96 14 29 1 1891873152 8675216 3760304
15:43:56 45780 8192000000 10837570896 11315466240 1900984768 18.834 98 12 24 0 1912378704 8339552 3054384
15:45:35 63702 8192000000 10882666496 11350732800 1905301728 18.869 98 16 32 2 1924576992 14168528 5106736
15:46:50 63616 8192000000 10858203456 11331252224 1890174304 18.747 97 24 48 1 1906416912 9091696 7150912
15:48:00 76390 8192000000 10894940320 11369328640 1947194928 19.204 100 11 22 0 1962955856 12327104 3433824
15:49:24 77122 8192000000 10904531168 11372363776 1932203056 19.084 98 39 77 2 1960788480 17148736 11436688
15:50:59 79677 8192000000 10899680000 11384946688 1937236272 19.125 98 13 26 1 1961438896 20420976 3781648
15:52:27 65169 8192000000 10912192192 11381329920 1953893744 19.257 99 14 28 0 1970434144 12743536 3796864
15:53:45 39631 8192000000 10925178496 11386187776 1965894432 19.353 99 34 68 0 1989076224 13471904 9709888
15:55:22 30469 8192000000 10902375904 11359571968 1925327088 19.029 98 22 44 1 1942660512 11178640 6154784
15:56:02 111223 8192000000 10907908144 11370512384 1929939072 19.066 98 13 27 0 1945790640 12820272 3031296
15:58:02 24692 8192000000 10919340208 11375550464 1952965568 19.250 99 17 35 1 1971478192 13610160 4902464
15:58:35 109393 8192000000 10911550176 11376095232 1957902800 19.289 99 34 67 0 1980170544 12778112 9489632
16:00:31 26219 8192000000 10910428272 11364339712 1956548320 19.279 99 38 76 1 1976988624 9632080 10808224
16:01:05 31835 8192000000 10930063648 11390181376 1985534816 19.508 100 40 80 1 2007303872 10922736 10846320
16:01:58 114658 8192000000 10904186208 11399176192 1932245328 19.085 97 11 22 1 1955394752 20451984 2697440
16:03:59 31296 8192000000 10912413264 11407007744 1979888272 19.464 100 4 8 0 2003258992 22520464 850256
16:04:36 7151 8192000000 10913865568 11409502208 1981567040 19.477 100 3 6 0 2004420896 22370128 483728
16:04:50 56369 8192000000 10926947808 11414642688 1998065312 19.607 100 22 45 1 2013497072 9696304 5735456
16:05:52 73131 8192000000 10910248784 11399696384 1947183488 19.204 97 14 28 2 1961184752 10300896 3700368
16:07:31 73987 8192000000 10919798704 11398168576 1936603120 19.120 97 20 41 1 1951620016 8946560 6070336
16:08:55 66673 8192000000 10925906368 11416780800 1998373328 19.610 100 26 52 0 2016290128 10230528 7686272
16:10:11 115931 8192000000 10922677648 11407654912 1930578560 19.072 96 11 23 0 1946095920 12631376 2885984
16:12:13 28719 8192000000 10916173232 11405164544 1953008352 19.250 98 10 20 0 1972197632 16123200 3066080
16:12:50 78513 8192000000 10931487376 11405127680 1955152656 19.267 98 14 26 0 1976282096 17770640 3358800
16:14:15 51243 8192000000 10937385024 11409203200 1975374832 19.428 99 17 34 2 1999100560 18858848 4866880
16:15:22 39193 8192000000 10872880512 11347963904 1867752560 18.566 94 4 8 0 1877971616 9319056 900000
16:16:07 34119 8192000000 10911844864 11376001024 1953953328 19.258 99 34 68 0 1973865184 10081616 9830240
16:16:49 33378 8192000000 10891172960 11358244864 1915921600 18.954 97 31 60 2 1932967600 8962992 8083008
16:17:38 104420 8192000000 10893594272 11367940096 1930111824 19.068 98 27 54 0 1944704752 7064992 7527936
16:19:29 87139 8192000000 10898779200 11376930816 1950543744 19.231 99 17 34 1 1968084208 13059440 4481024
16:21:03 46933 8192000000 10892010576 11374870528 1954488864 19.262 99 17 34 0 1970557520 11679328 4389328
16:22:04 53143 8192000000 10864403136 11347992576 1910011824 18.907 97 4 8 0 1919378080 8480240 886016
16:23:25 49416 8192000000 10883715472 11360911360 1947702336 19.208 99 13 26 1 1959477632 7741952 4033344
16:24:21 48926 8192000000 10865407008 11347300352 1905732032 18.872 97 15 30 1 1918178416 7874032 4572352
16:25:44 92932 8192000000 10877298912 11353530368 1867924192 18.567 96 7 14 1 1878931248 9356720 1650336
16:27:23 28080 8192000000 8981113824 9159372800 143270304 1.718 8 5 6 2 147286704 2498752 1517648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 20-06-2021 16:29:11 to 20-06-2021 16:29:41.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-06-2021 16:29:42 to 20-06-2021 16:29:44.

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          239820
MON$OLDEST_ACTIVE               239821
MON$OLDEST_SNAPSHOT             239821
MON$NEXT_TRANSACTION            239821
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                       2040032
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:102: 
:103: mscs-test-161.budzdorov.ru    Sun Jun 20 16:27:54 2021
:104:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:105: 
:106: 
:107: mscs-test-161.budzdorov.ru    Sun Jun 20 16:28:03 2021
:108:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:109: 
--- end of diff output ---

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

20.06.21 16:29:45. 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-06-20 16:29:47 No severe PSQL-related problems occured
20.06.21 16:29:48. End of report.