Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.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 17077744 kB
MemAvailable 31374288 kB
Buffers 0 kB
Cached 14574908 kB
SwapCached 2436 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-17 16:27:42
DTS_END                         2021-06-17 16:27:42.0670
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/34648
TRN_ID                          245791
ATT_ID                          678
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: 9242.05 22192 1109046
customer order: creation 178.41 330 21409
customer order: refuse 15.33 324 1840
order to supplier: creation 48.43 1225 5812
order to supplier: removal 3.56 96785 427
invoice (draft): creation 46.82 3387 5618
invoice (draft): removal 51.45 843 6174
invoice accept: apply 43.29 18060 5195
invoice accept: cancel 45.61 824 5473
customer reserve: creation 4030.62 178 483674
customer reserve: removal 4478.59 60 537431
realization accept: apply 86.36 178 10363
realization accept: cancel 78.11 96 9373
payment from customer: creation 61.73 116 7408
payment from customer: removal 5.64 67 677
payment to supplier: creation 51.64 116 6197
payment to supplier: removal 3.41 73 409
service: total inventory turnovers 5.21 1083 625
service: total monetary turnovers 7.06 24 847
service: aggregate perf. data 0.75 24758 90
service: refresh index statistics 0.03 295315 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-06-2021 16:29:00 to 17-06-2021 16:29:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3550
TEST_TIME 2 4203
TEST_TIME 3 4174
TEST_TIME 4 4498
TEST_TIME 5 4564
TEST_TIME 6 5275
TEST_TIME 7 5658
TEST_TIME 8 5751
TEST_TIME 9 5722
TEST_TIME 10 5767
TEST_TIME 11 6074
TEST_TIME 12 5953
TEST_TIME 13 6178
TEST_TIME 14 6313
TEST_TIME 15 6582
TEST_TIME 16 6762
TEST_TIME 17 6982
TEST_TIME 18 7174
TEST_TIME 19 7376
TEST_TIME 20 7625
TEST_TIME 21 7514
TEST_TIME 22 7738
TEST_TIME 23 8078
TEST_TIME 24 8335
TEST_TIME 25 8434
TEST_TIME 26 8557
TEST_TIME 27 8654
TEST_TIME 28 8974
TEST_TIME 29 9388
TEST_TIME 30 10061
TEST_TIME 31 10285
TEST_TIME 32 10105
TEST_TIME 33 10200
TEST_TIME 34 10159
TEST_TIME 35 10278
TEST_TIME 36 10202
TEST_TIME 37 10091
TEST_TIME 38 10024
TEST_TIME 39 9888
TEST_TIME 40 9895
TEST_TIME 41 9843
TEST_TIME 42 9871
TEST_TIME 43 9906
TEST_TIME 44 9928
TEST_TIME 45 10062
TEST_TIME 46 9920
TEST_TIME 47 9744
TEST_TIME 48 9649
TEST_TIME 49 9746
TEST_TIME 50 9706
TEST_TIME 51 9585
TEST_TIME 52 9563
TEST_TIME 53 9559
TEST_TIME 54 9435
TEST_TIME 55 9523
TEST_TIME 56 9583
TEST_TIME 57 9626
TEST_TIME 58 9558
TEST_TIME 59 9590
TEST_TIME 60 9476
TEST_TIME 61 9432
TEST_TIME 62 9465
TEST_TIME 63 9403
TEST_TIME 64 9430
TEST_TIME 65 9396
TEST_TIME 66 9440
TEST_TIME 67 9508
TEST_TIME 68 9438
TEST_TIME 69 9450
TEST_TIME 70 9462
TEST_TIME 71 9447
TEST_TIME 72 9565
TEST_TIME 73 9603
TEST_TIME 74 9560
TEST_TIME 75 9604
TEST_TIME 76 9627
TEST_TIME 77 9630
TEST_TIME 78 9624
TEST_TIME 79 9546
TEST_TIME 80 9472
TEST_TIME 81 9645
TEST_TIME 82 9552
TEST_TIME 83 9541
TEST_TIME 84 9506
TEST_TIME 85 9481
TEST_TIME 86 9487
TEST_TIME 87 9453
TEST_TIME 88 9435
TEST_TIME 89 9377
TEST_TIME 90 9399
TEST_TIME 91 9364
TEST_TIME 92 9334
TEST_TIME 93 9301
TEST_TIME 94 9345
TEST_TIME 95 9329
TEST_TIME 96 9325
TEST_TIME 97 9376
TEST_TIME 98 9354
TEST_TIME 99 9358
TEST_TIME 100 9369
TEST_TIME 101 9362
TEST_TIME 102 9357
TEST_TIME 103 9389
TEST_TIME 104 9437
TEST_TIME 105 9486
TEST_TIME 106 9493
TEST_TIME 107 9524
TEST_TIME 108 9502
TEST_TIME 109 9450
TEST_TIME 110 9438
TEST_TIME 111 9423
TEST_TIME 112 9408
TEST_TIME 113 9365
TEST_TIME 114 9332
TEST_TIME 115 9385
TEST_TIME 116 9338
TEST_TIME 117 9305
TEST_TIME 118 9289
TEST_TIME 119 9280
TEST_TIME 120 9243

Performance per minute, chart


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

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 1556470 1556470 0 0.00 0 27759 6 0 0
doc_list_biud 1556470 1556470 0 0.00 0 50069 27 0 0
sp_add_invoice_to_stock 5289 5195 94 1.77 39 165833 18060 0 94
sp_cancel_adding_invoice 5473 5473 0 0.00 4 60206 825 0 0
sp_cancel_client_order 1840 1840 0 0.00 4 8395 325 0 0
sp_cancel_customer_reserve 537431 537431 0 0.00 1 22629 60 0 0
sp_cancel_pay_from_customer 677 677 0 0.00 3 6401 68 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 8301 74 0 0
sp_cancel_supplier_invoice 6181 6174 7 0.11 2 50074 843 0 7
sp_cancel_supplier_order 427 427 0 0.00 11 935300 96786 0 0
sp_cancel_write_off 9373 9373 0 0.00 1 21072 96 0 0
sp_client_order 21409 21409 0 0.00 3 18552 331 0 0
sp_customer_reserve 483674 483674 0 0.00 0 40121 179 0 0
sp_fill_shopping_cart 32835 32835 0 0.00 1 17407 38 0 0
sp_fill_shopping_cart_clo_res 483671 483671 0 0.00 0 10872 11 0 0
sp_get_clo_for_invoice 5192 5192 0 0.00 0 19961 247 0 0
sp_kill_cost_storno 15932 15932 0 0.00 0 27750 59 0 0
sp_kill_qstorno_ret_qs2qd 1090836 1090836 0 0.00 0 50066 33 0 0
sp_kill_qty_storno 576273 576273 0 0.00 0 50068 71 0 0
sp_lock_selected_doc 21515 21515 0 0.00 0 8295 4 0 0
sp_make_cost_storno 29160 29160 0 0.00 0 13232 52 0 0
sp_multiply_rows_for_pdistr 29160 29160 0 0.00 0 8056 28 0 0
sp_multiply_rows_for_qdistr 21409 21409 0 0.00 0 18543 133 0 0
sp_pay_from_customer 7408 7408 0 0.00 4 12652 116 0 0
sp_pay_to_supplier 6197 6197 0 0.00 5 13239 117 0 0
sp_payment_common 13605 13605 0 0.00 1 12647 29 0 0
sp_qd_handle_on_cancel_clo 1840 1840 0 0.00 0 8384 298 0 0
sp_qd_handle_on_invoice_upd_sts 10665 10665 0 0.00 0 23603 333 0 0
sp_qd_handle_on_reserve_upd_sts 10363 10363 0 0.00 0 13395 62 0 0
sp_reserve_write_off 10363 10363 0 0.00 7 13956 179 0 0
sp_supplier_invoice 5618 5618 0 0.00 6 90547 3387 0 0
sp_supplier_order 5812 5812 0 0.00 5 30805 1225 0 0
srv_aggregate_perf_data 90 90 0 0.00 3370 228416 24759 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1172 160040 31224 0 0
srv_find_qd_qs_mism 1059029 1059029 0 0.00 0 9925 5 0 0
srv_make_invnt_saldo 625 625 0 0.00 43 90583 1083 0 0
srv_make_money_saldo 847 847 0 0.00 0 3733 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 59680 451029 295315 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5195 5195 0 0.00 0 9954 204 0 0
t$perf-norm:sp_cancel_adding_invoice 457 457 0 0.00 0 2644 86 0 0
t$perf-norm:sp_cancel_client_order 1840 1840 0 0.00 0 4229 14 0 0
t$perf-norm:sp_cancel_customer_reserve 695 695 0 0.00 0 3114 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 677 677 0 0.00 0 1277 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 216 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 2386 30 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 19119 1665 0 0
t$perf-norm:sp_cancel_write_off 1032 1032 0 0.00 0 8075 21 0 0
t$perf-norm:sp_client_order 21409 21409 0 0.00 0 6937 17 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 1084 4 0 0
t$perf-norm:sp_pay_from_customer 7408 7408 0 0.00 0 4656 10 0 0
t$perf-norm:sp_pay_to_supplier 6197 6197 0 0.00 0 6396 11 0 0
t$perf-norm:sp_reserve_write_off 10363 10363 0 0.00 0 3837 11 0 0
t$perf-norm:sp_supplier_invoice 5618 5618 0 0.00 0 9959 25 0 0
t$perf-norm:sp_supplier_order 5812 5812 0 0.00 0 6728 18 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 1139 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 12772 83 0 0
t$perf-norm:srv_make_invnt_saldo 625 625 0 0.00 0 2254 27 0 0
t$perf-norm:srv_make_money_saldo 847 847 0 0.00 0 1800 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 26 9 0 0
v_add_invoice_to_stock 10572 10384 188 1.77 0 4634 16 0 188
v_all_customers 39382 39382 0 0.00 0 19 1 0 0
v_all_suppliers 32198 32198 0 0.00 0 24 1 0 0
v_all_wares 42818 42818 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 914 914 0 0.00 0 2005 9 0 0
v_cancel_client_order 3680 3680 0 0.00 0 1720 6 0 0
v_cancel_customer_prepayment 1354 1354 0 0.00 0 1220 4 0 0
v_cancel_customer_reserve 1390 1390 0 0.00 0 1927 6 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 452 4 0 0
v_cancel_supplier_invoice 860 846 14 1.62 0 2133 16 0 14
v_cancel_supplier_order 854 854 0 0.00 0 189 3 0 0
v_cancel_write_off 2064 2064 0 0.00 0 1452 11 0 0
v_max_id_clo_ord 5812 5812 0 0.00 0 7490 3 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 1771 14 0 0
v_max_id_ord_sup 5614 5614 0 0.00 0 5507 4 0 0
v_max_non_paid_invoice 1524 1524 0 0.00 0 224 2 0 0
v_max_non_paid_realizn 3790 3790 0 0.00 0 4163 5 0 0
v_min_id_clo_ord 5812 5812 0 0.00 0 14500 14 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 662 3 0 0
v_min_id_ord_sup 5614 5614 0 0.00 0 9683 11 0 0
v_min_non_paid_invoice 6197 6197 0 0.00 0 8397 17 0 0
v_min_non_paid_realizn 7408 7408 0 0.00 0 6478 20 0 0
v_our_firm 10672 10672 0 0.00 0 31 1 0 0
v_reserve_write_off 20726 20726 0 0.00 0 3279 6 0 0
x_lock_depdocs_on_canc_invoice 11224 11224 0 0.00 0 18609 123 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 3848 288 0 0
x_make_qstorno_1000_1200 5812 5812 0 0.00 2 30797 1137 0 0
x_make_qstorno_1200_2000 5618 5618 0 0.00 3 90539 3261 0 0
x_make_qstorno_2100_3300 483674 483674 0 0.00 0 40120 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-06-2021 16:29:08 to 17-06-2021 16:29:12.

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:45 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:52 14635 8192000000 10249626352 10550247424 936658864 10.260 75 57 115 0 959458864 2711184 20088816
13:58:13 34778 8192000000 10339487904 10653892608 1365144480 14.284 100 91 182 0 1400067696 4509168 30414048
13:58:56 21542 8192000000 10376915232 10695000064 1426707152 14.832 100 89 179 0 1462148688 6365696 29075840
13:59:28 24242 8192000000 10395871968 10723213312 1446782656 15.010 100 87 174 0 1482590432 7040192 28767584
14:00:00 18824 8192000000 10418088464 10746314752 1469153424 15.206 100 87 174 0 1504910128 7501344 28255360
14:00:29 18749 8192000000 10441806112 10773446656 1490852080 15.396 100 85 169 0 1526041520 7908384 27281056
14:00:56 22698 8192000000 10472561312 10809798656 1516451744 15.619 100 83 166 0 1550773504 8045664 26276096
14:01:28 16457 8192000000 10499942928 10841067520 1551954240 15.927 100 83 166 0 1587202224 9052176 26195808
14:01:55 8992 8192000000 10513641616 10858090496 1566821424 16.055 100 82 164 0 1601993904 9548784 25623696
14:02:13 16601 8192000000 10529684656 10878918656 1584848560 16.210 100 83 166 1 1620631616 10162368 25620688
14:02:38 8494 8192000000 10541558416 10896277504 1604785472 16.380 100 78 156 0 1638916752 10471568 23659712
14:02:59 17489 8192000000 10569478528 10929164288 1629942048 16.594 100 74 148 0 1662604928 10436960 22225920
14:03:25 11871 8192000000 10582934384 10943766528 1647215680 16.741 100 79 157 0 1681642320 10727536 23699104
14:03:46 10145 8192000000 10596169520 10963169280 1657792720 16.830 100 80 160 2 1692651840 10714000 24145120
14:04:05 13143 8192000000 10612153552 10982957056 1681314432 17.028 100 75 150 2 1714124208 10445120 22364656
14:04:28 10776 8192000000 10623634368 10996985856 1689822096 17.100 100 76 149 1 1722442448 10243200 22377152
14:04:48 7732 8192000000 10656185824 11020574720 1716371984 17.322 100 78 156 1 1749074640 10403584 22299072
14:05:03 5597 8192000000 10673714672 11045711872 1737827168 17.501 100 86 173 1 1775311584 11754320 25730096
14:05:16 7162 8192000000 10676789008 11052646400 1741529776 17.531 100 76 152 1 1775788592 12216448 22042368
14:05:30 6758 8192000000 10697706192 11075125248 1754889504 17.642 100 88 176 1 1793306464 13288912 25128048
14:05:46 8812 8192000000 10692322848 11074060288 1758871904 17.675 100 76 152 1 1794103040 13867904 21363232
14:06:04 5098 8192000000 10713073072 11092410368 1770750448 17.773 100 84 166 2 1808114096 14484000 22879648
14:06:16 3305 8192000000 10719697856 11098808320 1779408144 17.845 100 88 176 2 1819080512 14852720 24819648
14:06:26 5075 8192000000 10731083808 11109404672 1783636016 17.879 100 91 182 3 1824616848 15446768 25534064
14:06:37 3358 8192000000 10734277904 11112357888 1789090352 17.924 100 86 170 0 1827279504 14121232 24067920
14:06:48 2951 8192000000 10745709952 11128139776 1802490928 18.034 100 88 176 1 1840507504 14102240 23914336
14:06:57 4954 8192000000 10721886864 11112402944 1794038576 17.965 100 69 139 1 1826976096 14067808 18869712
14:07:10 2998 8192000000 10753646688 11133222912 1802877056 18.038 100 80 158 0 1837851296 12917024 22057216
14:07:20 2935 8192000000 10751937888 11142717440 1821582416 18.191 100 79 157 0 1856334608 11589184 23163008
14:07:29 3146 8192000000 10771116128 11153350656 1826368672 18.230 100 79 156 2 1862012144 12995568 22647904
14:07:39 2801 8192000000 10775776704 11163185152 1837749952 18.322 100 82 164 0 1875052592 13285504 24017136
14:07:48 2838 8192000000 10787303360 11170271232 1842663408 18.362 100 90 180 0 1882159952 14141872 25354672
14:07:58 2439 8192000000 10789056128 11177570304 1850944080 18.430 100 96 188 0 1891752352 14530784 26277488
14:08:06 1858 8192000000 10793646416 11181617152 1850525792 18.426 100 92 185 1 1890978400 14078608 26374000
14:08:15 1923 8192000000 10794092464 11183480832 1851021712 18.430 100 85 165 1 1887666608 13156240 23488656
14:08:23 2161 8192000000 10804479088 11191128064 1854645856 18.460 100 89 178 1 1894741168 13603136 26492176
14:08:32 1330 8192000000 10805293600 11190521856 1863267392 18.530 100 92 183 2 1903047888 13852272 25928224
14:08:39 2001 8192000000 10797564704 11187773440 1856638656 18.476 100 86 172 2 1892142432 11800624 23703152
14:08:48 1748 8192000000 10812417648 11198373888 1865721312 18.550 100 95 189 0 1904862144 12714240 26426592
14:08:56 1556 8192000000 10810084720 11196784640 1866755232 18.558 100 94 185 3 1905512400 12303936 26453232
14:09:04 1527 8192000000 10816363296 11203657728 1867626304 18.565 100 91 185 3 1905711584 12218416 25866864
14:09:12 22922 8192000000 10772506816 11192213504 1859527536 18.499 100 48 96 0 1883785856 10562928 13695392
14:09:58 1598 8192000000 10814898096 11204329472 1868824944 18.575 100 89 181 2 1904074448 8373424 26876080
14:10:06 7390 8192000000 10799271344 11203239936 1866981856 18.560 100 67 132 1 1894668944 9740160 17946928
14:10:20 3489 8192000000 10795013968 11205492736 1864299088 18.538 100 51 102 2 1890083984 11685392 14099504
14:10:30 5604 8192000000 10791721648 11206479872 1867279856 18.562 100 49 94 4 1889073056 8770960 13022240
14:10:42 6154 8192000000 10782204112 11207213056 1867566496 18.565 100 36 70 2 1885908368 8419712 9922160
14:10:58 5215 8192000000 10781333904 11207979008 1872718400 18.606 100 33 67 2 1893669088 11251072 9699616
14:11:09 5956 8192000000 10789044192 11217117184 1876803024 18.639 100 30 60 2 1897044288 11784512 8456752
14:11:22 6173 8192000000 10789358768 11216478208 1874997376 18.625 100 23 46 2 1888343664 6667728 6678560
14:11:35 4688 8192000000 10800654944 11221188608 1878173856 18.650 100 29 58 1 1892939168 6300768 8464544
14:11:47 5031 8192000000 10789125584 11218255872 1881273696 18.675 100 29 57 2 1895839392 6473168 8092528
14:12:00 3628 8192000000 10795520128 11220996096 1881463328 18.677 100 23 46 2 1894144240 6021216 6659696
14:12:16 8622 8192000000 10787861200 11225210880 1883153536 18.691 100 22 44 2 1898981120 9777056 6050528
14:12:32 9274 8192000000 10800028304 11229970432 1885258288 18.708 100 21 42 0 1897298784 6006128 6034368
14:12:48 13094 8192000000 10798458496 11228700672 1885715424 18.711 100 14 29 3 1895216880 5334256 4167200
14:13:07 8882 8192000000 10792436160 11230064640 1887992320 18.730 100 20 39 1 1899663152 5957088 5713744
14:13:25 10777 8192000000 10792800320 11230851072 1891509776 18.758 100 11 22 0 1900339680 5458304 3371600
14:13:44 57852 8192000000 10821495568 11244376064 1895186288 18.788 100 25 50 1 1908160160 5819328 7154544
14:14:48 17039 8192000000 10829255184 11250253824 1900421232 18.830 100 40 80 2 1916753056 4998864 11332960
14:15:11 7020 8192000000 10812712464 11246813184 1899635024 18.823 100 29 58 0 1915320656 7336608 8349024
14:15:26 5443 8192000000 10813057136 11251863552 1902116048 18.843 100 22 44 1 1914539840 5637536 6786256
14:15:39 7586 8192000000 10829173696 11256291328 1905159232 18.868 100 38 75 3 1922945424 7409120 10377072
14:15:54 6602 8192000000 10822984400 11252940800 1904597296 18.863 100 34 68 1 1921247712 7012720 9637696
14:16:08 5068 8192000000 10817385168 11250241536 1903064144 18.851 100 19 38 0 1914423632 5741888 5617600
14:16:19 9648 8192000000 10824728960 11255742464 1905876384 18.874 100 27 54 1 1919902784 5939184 8087216
14:16:35 9055 8192000000 10803096640 11242827776 1882591312 18.686 99 19 38 2 1892931568 4909328 5430928
14:16:50 8702 8192000000 10800521456 11236388864 1890070608 18.746 100 25 50 3 1903172368 6307136 6794624
14:17:05 10272 8192000000 10791925824 11226345472 1871538016 18.597 99 26 53 1 1885059216 6438976 7082224
14:17:29 7111 8192000000 10795850400 11217485824 1847263712 18.400 98 34 68 0 1866229488 9782560 9183216
14:17:43 10424 8192000000 10790976192 11222233088 1860276720 18.506 99 21 41 1 1875658624 9474960 5906944
14:18:02 7963 8192000000 10777628192 11202461696 1846486656 18.394 98 25 50 0 1859724976 5881968 7356352
14:18:16 9764 8192000000 10729467696 11156226048 1764984128 17.726 95 15 29 0 1773912544 4724864 4203552
14:18:34 9390 8192000000 10735530672 11167248384 1804891568 18.054 98 22 44 0 1817024976 5681664 6451744
14:18:49 50512 8192000000 10725838544 11139108864 1737022080 17.494 94 27 53 0 1754073424 9324272 7727072
14:19:52 18969 8192000000 10720152992 11141312512 1708691984 17.258 93 29 58 2 1723218256 6727072 7799200
14:20:19 11455 8192000000 10709285664 11131326464 1735070672 17.478 95 27 53 1 1748052352 5221920 7759760
14:20:41 2931 8192000000 10740705648 11153616896 1811255760 18.106 99 40 80 1 1831399376 7864080 12279536
14:20:53 3540 8192000000 10748241584 11163377664 1815398064 18.140 99 42 84 1 1834554896 7360144 11796688
14:21:02 4412 8192000000 10733722880 11145056256 1792530896 17.953 98 18 35 0 1803054736 5406848 5116992
14:21:13 5521 8192000000 10694419744 11106996224 1742534384 17.540 96 31 62 1 1757592032 6124032 8933616
14:21:28 9468 8192000000 10701326032 11119370240 1773661360 17.797 99 27 54 1 1791362768 9971168 7730240
14:21:44 9341 8192000000 10699070800 11116728320 1726100768 17.403 96 27 52 4 1739698848 5686320 7911760
14:22:00 6362 8192000000 10702760224 11108061184 1746787712 17.575 97 35 70 1 1763027376 5697184 10542480
14:22:14 6589 8192000000 10706825824 11122315264 1776806432 17.823 99 29 59 2 1792245056 5513984 9924640
14:22:29 9482 8192000000 10717814368 11141095424 1804398448 18.050 100 23 46 1 1820963824 9562960 7002416
14:22:45 9398 8192000000 10750144032 11166347264 1828406864 18.246 100 29 58 0 1842746736 5862384 8477488
14:23:03 9783 8192000000 10730931744 11162914816 1808287456 18.082 99 14 28 2 1821884880 9698880 3898544
14:23:19 28143 8192000000 10771950352 11185238016 1835979568 18.308 100 12 24 0 1844565664 5660512 2925584
14:23:55 56943 8192000000 10797791376 11190743040 1850432112 18.426 100 53 112 0 1871540208 5559616 15548480
14:24:58 9985 8192000000 10758468768 11193266176 1851039312 18.431 100 23 46 1 1865091024 7206800 6844912
14:25:16 7087 8192000000 10772875088 11199733760 1859520064 18.499 100 32 63 1 1875265216 6927200 8817952
14:25:34 6298 8192000000 10771648464 11202531328 1865121168 18.545 100 28 56 1 1878826704 6149776 7555760
14:25:46 11359 8192000000 10779850384 11207348224 1860922352 18.511 100 21 40 2 1871811408 4814240 6074816
14:26:07 5794 8192000000 10783775984 11209666560 1867522096 18.564 100 28 56 3 1882563552 7224864 7816592
14:26:24 9159 8192000000 10782568816 11212750848 1872053216 18.601 100 25 50 3 1884817120 5219264 7544640
14:26:42 13269 8192000000 10783206288 11217911808 1876651584 18.638 100 27 53 1 1889453840 4995120 7807136
14:27:03 9360 8192000000 10801723088 11232083968 1883486624 18.693 100 12 24 0 1891371072 4609664 3274784
14:27:20 9719 8192000000 10811934928 11245309952 1899751904 18.824 100 21 42 0 1911124848 5075440 6297504
14:27:36 10506 8192000000 10826245536 11254349824 1904746816 18.864 100 9 17 1 1912015088 4476416 2791856
14:28:03 23088 8192000000 10849848208 11271372800 1919891088 18.986 100 39 78 2 1937921536 5998064 12032384
14:28:36 9385 8192000000 10863998480 11280830464 1930704080 19.073 100 57 115 1 1955024656 7649056 16671520
14:29:05 6663 8192000000 10879927200 11289182208 1936179520 19.116 100 57 114 1 1959932048 8035840 15716688
14:29:21 18346 8192000000 10873456768 11298082816 1947086464 19.203 100 60 120 0 1975693728 10806864 17800400
14:29:52 71081 8192000000 10854261152 11291222016 1927447680 19.046 99 45 90 1 1950555840 9623216 13484944
14:31:11 50571 8192000000 10888237456 11325046784 1958262768 19.292 100 29 57 1 1975738704 8966416 8509520
14:32:12 13645 8192000000 10895119040 11328782336 1965886288 19.353 100 38 75 1 1985724624 9477840 10360496
14:32:33 20705 8192000000 10889297952 11328532480 1953081152 19.251 99 57 114 1 1981104848 11543008 16480688
14:33:11 6297 8192000000 10906923312 11341348864 1970188240 19.387 100 54 108 1 1998166960 12358960 15619760
14:33:26 5080 8192000000 10906674528 11337924608 1976501456 19.437 100 60 118 1 2005052704 12070848 16480400
14:33:39 9091 8192000000 10920846128 11349360640 1979530800 19.461 100 61 121 2 2008968112 11641664 17795648
14:33:56 8189 8192000000 10918488528 11348459520 1981697680 19.478 100 57 114 1 2009565856 12319984 15548192
14:34:12 4451 8192000000 10920136512 11342929920 1964753472 19.344 99 65 130 4 1995270784 12879328 17637984
14:34:23 20849 8192000000 10905506464 11329343488 1956699216 19.280 99 58 117 2 1987309072 13801744 16808112
14:34:52 13775 8192000000 10920103984 11349934080 1980558032 19.469 100 57 113 1 2011593424 14526320 16509072
14:35:14 16990 8192000000 10929600336 11360399360 1987459696 19.524 100 56 112 2 2021497968 18109120 15929152
14:35:50 16461 8192000000 10910082608 11351273472 1980931120 19.472 100 46 93 1 2007271248 12655856 13684272
14:36:20 23455 8192000000 10913455360 11348701184 1963058576 19.330 99 35 68 2 1984421344 11166768 10196000
14:36:57 13658 8192000000 10916820000 11361792000 1986695728 19.518 100 48 97 1 2013840144 12752736 14391680
14:37:24 9018 8192000000 10927395824 11359789056 1967726656 19.367 99 52 104 3 1998695424 14961008 16007760
14:37:48 21217 8192000000 10920952448 11370909696 1988357472 19.531 100 43 86 1 2020009888 18264704 13387712
14:38:18 12707 8192000000 10920415776 11358896128 1966117888 19.355 99 40 80 1 1996488352 18395376 11975088
14:38:49 6048 8192000000 10942464864 11380977664 2001284304 19.633 100 55 110 1 2036121984 18440240 16397440
14:39:04 12427 8192000000 10956206624 11392090112 2006709008 19.676 100 51 100 2 2038484192 16966816 14808368
14:39:23 3575 8192000000 10961798112 11384180736 1988042016 19.528 99 63 126 1 2023834336 16541248 19251072
14:39:35 5102 8192000000 10948368816 11377496064 1984078528 19.497 99 70 141 1 2023312960 17839104 21395328
14:39:50 3155 8192000000 10954662464 11382665216 2004038688 19.655 100 75 149 1 2044890096 18544848 22306560
14:40:12 13788 8192000000 10966687072 11392913408 2008688880 19.691 100 70 139 2 2051723264 21200496 21833888
14:40:48 7883 8192000000 10941136560 11371425792 1974443952 19.421 99 65 130 0 2016681424 20664896 21572576
14:41:05 8148 8192000000 10955621392 11381870592 1996134976 19.592 100 73 143 0 2040332752 21774448 22423328
14:41:26 3994 8192000000 10966083600 11387908096 2000866464 19.630 100 69 138 2 2047523056 24740224 21916368
14:41:39 5561 8192000000 10953670592 11383214080 1995803584 19.590 100 57 114 0 2039059296 25295040 17960672
14:41:51 13115 8192000000 10968631344 11391787008 2001765184 19.637 100 72 142 1 2048976160 25927184 21283792
14:42:11 5200 8192000000 10968356320 11401654272 2008427984 19.689 100 62 123 0 2054690576 27076368 19186224
14:42:23 3950 8192000000 10958158848 11388710912 1998922832 19.614 100 72 143 2 2047652304 26269424 22460048
14:42:34 7345 8192000000 10965594528 11389952000 2000869152 19.630 100 72 144 0 2049347824 26547984 21930688
14:42:49 4320 8192000000 10977660192 11398258688 2008737568 19.692 100 85 170 1 2062340288 26836992 26765728
14:43:00 2629 8192000000 10977166080 11387236352 1999168304 19.616 100 96 190 3 2055161360 27778976 28214080
14:43:09 4098 8192000000 10958694640 11376742400 1991519632 19.556 100 77 155 0 2043381264 28367104 23494528
14:43:21 11650 8192000000 10944234592 11366907904 1968457936 19.373 99 74 148 1 2017320128 26503680 22358512
14:43:42 8304 8192000000 10944733248 11366359040 1979730592 19.463 100 75 148 1 2030263120 28132304 22400224
14:43:58 5093 8192000000 10952410880 11365572608 1968715040 19.375 99 72 143 0 2019824352 29548336 21560976
14:44:12 5941 8192000000 10960234896 11383373824 1992823616 19.566 100 68 137 1 2042531104 29224736 20482752
14:44:26 5027 8192000000 10972490752 11385352192 1992314832 19.562 100 83 166 2 2048516928 31132816 25069280
14:44:43 13900 8192000000 10959646224 11390103552 1991520784 19.556 100 67 133 1 2048772624 37002720 20249120
14:45:06 5396 8192000000 10928011968 11353161728 1941864256 19.162 98 69 139 0 1993580112 30827008 20888848
14:45:19 4921 8192000000 10953844704 11369164800 1981607856 19.477 100 70 140 1 2032912720 30499280 20805584
14:45:31 1668 8192000000 10951979872 11363799040 1964442480 19.341 99 89 180 1 2021466128 29655248 27368400
14:45:41 3347 8192000000 10934810688 11351965696 1952278608 19.245 99 70 140 0 2003408992 30123376 21007008
14:45:53 1972 8192000000 10951055232 11361447936 1972969664 19.409 100 87 172 0 2029977856 31286384 25721808
14:46:01 8349 8192000000 10944302176 11365208064 1970063904 19.386 100 80 159 0 2030955760 36860368 24031488
14:46:17 1171 8192000000 10928272768 11345293312 1957733248 19.288 100 76 150 2 2014854656 33510352 23611056
14:46:25 4837 8192000000 10929093872 11348795392 1958948576 19.298 100 73 146 1 2015565904 33831888 22785440
14:46:39 2471 8192000000 10937642688 11345862656 1960485728 19.310 100 82 163 1 2018446000 33574368 24385904
14:46:55 5906 8192000000 10916375008 11341828096 1955054720 19.267 100 71 141 0 2009474048 33245200 21174128
14:47:08 4099 8192000000 10915869104 11343695872 1942665168 19.168 99 50 100 2 1991140992 33015328 15460496
14:47:21 6464 8192000000 10907405104 11337265152 1947616368 19.207 100 47 91 1 1993023056 31167376 14239312
14:47:35 13398 8192000000 10918563296 11351728128 1939586752 19.143 99 42 84 1 1982503056 29730048 13186256
14:47:55 3009 8192000000 10940136512 11361488896 1971028736 19.394 100 62 122 1 2022937760 32393712 19515312
14:48:06 2135 8192000000 10938564496 11351748608 1960602080 19.311 99 78 152 2 2018688912 34003744 24083088
14:48:18 3003 8192000000 10942548576 11352043520 1959236720 19.300 100 78 157 1 2020249104 35937856 25074528
14:48:29 10166 8192000000 10947179424 11360935936 1962504688 19.326 100 70 139 4 2021504224 37334672 21664864
14:48:50 3199 8192000000 10944707632 11366367232 1966958352 19.361 100 63 125 0 2028545376 41309712 20277312
14:49:02 1900 8192000000 10968685088 11383103488 1977244368 19.443 100 79 158 0 2045459312 42613520 25601424
14:49:13 3553 8192000000 10967814016 11386281984 1979903984 19.464 100 66 132 1 2045993728 43930432 22159312
14:49:28 1549 8192000000 10941533488 11362476032 1949015824 19.219 99 73 145 2 2016238752 43321136 23901792
14:49:36 8157 8192000000 10944820480 11376427008 1968863952 19.376 100 69 138 3 2037614512 45796976 22953584
14:50:02 5800 8192000000 10915077472 11342577664 1927035792 19.043 98 55 110 0 1992317776 46713952 18568032
14:50:20 9116 8192000000 10933541328 11369439232 1958234048 19.292 100 51 102 0 2023960928 48796144 16930736
14:50:37 8491 8192000000 10938602912 11372621824 1961811248 19.320 100 45 90 2 2022891920 45709680 15370992
14:51:04 12585 8192000000 10931342816 11371421696 1957828480 19.289 99 44 88 2 2018843680 46758608 14256592
14:51:24 15569 8192000000 10934742304 11383812096 1968959216 19.377 100 38 74 4 2020344576 39265984 12119376
14:51:46 9887 8192000000 10929420864 11372580864 1964619344 19.343 100 34 68 0 2017529152 41186192 11723616
14:52:07 16863 8192000000 10922590032 11359469568 1945708608 19.192 99 30 60 2 1991439376 35742944 9987824
14:52:38 13282 8192000000 10927356320 11366055936 1960231744 19.308 100 32 64 2 2008650768 37518960 10900064
14:53:05 13435 8192000000 10924972192 11367383040 1958244336 19.292 100 32 64 4 2009461824 40231552 10985936
14:53:27 18244 8192000000 10917901072 11357638656 1951611824 19.239 100 33 66 2 2004967488 41900608 11455056
14:53:54 11617 8192000000 10907451312 11357241344 1945769312 19.193 100 31 62 2 2000123792 43285584 11068896
14:54:12 8977 8192000000 10921960144 11357257728 1935400416 19.110 99 37 76 1 1990852704 42669584 12782704
14:54:41 5915 8192000000 10923245040 11364859904 1950473552 19.230 100 31 59 2 2006652640 45955840 10223248
14:55:22 27359 8192000000 10918270736 11378966528 1949131648 19.220 100 21 42 1 2000876800 44033104 7712048
14:56:22 39360 8192000000 10890500528 11352666112 1905692656 18.872 98 21 42 2 1953135376 39883920 7558800
14:57:43 59920 8192000000 10880166096 11337580544 1909863632 18.906 98 16 32 1 1936541056 21969616 4707808
14:58:50 45700 8192000000 10852177168 11310624768 1887266704 18.724 97 11 22 1 1900038864 10170144 2602016
14:59:44 70875 8192000000 10855798752 11328565248 1902853536 18.849 98 19 38 2 1917721472 9045712 5822224
15:01:15 66994 8192000000 10873261680 11342127104 1896035584 18.794 97 9 18 0 1913128432 14727632 2365216
15:02:28 160040 8192000000 10893210688 11347017728 1897227776 18.804 97 8 16 2 1913351744 13748512 2375456
15:05:14 86266 8192000000 10923651136 11368222720 1972095536 19.402 100 23 46 2 1988283312 9435200 6752576
15:06:55 63787 8192000000 10905600256 11368939520 1978705072 19.454 100 18 36 0 1996019872 12350624 4964176
15:08:06 26424 8192000000 10881914944 11348213760 1943032304 19.171 99 35 72 2 1964903968 11706288 10165376
15:08:46 21930 8192000000 10890448080 11341680640 1924534112 19.023 98 41 82 0 1945252416 8939360 11778944
15:09:15 44003 8192000000 10884384256 11342573568 1911833680 18.921 98 8 15 1 1924537376 10608080 2095616
15:10:15 88129 8192000000 10897172704 11365519360 1927037504 19.043 98 11 22 1 1947254592 17000496 3216592
15:11:52 114873 8192000000 10902682144 11375415296 1931795200 19.081 98 9 18 0 1952709952 18334288 2580464
15:13:53 84396 8192000000 10903970992 11362480128 1931593888 19.080 98 34 68 0 1952256720 10698800 9964032
15:15:50 59814 8192000000 10909063728 11374714880 1943741776 19.177 99 25 48 1 1962684928 11342016 7601136
15:16:59 20412 8192000000 10937786736 11378110464 1977033616 19.441 100 54 107 0 2001518544 8168592 16316336
15:17:29 46216 8192000000 10918685584 11380813824 1976036736 19.433 100 34 68 2 1996229088 10477264 9715088
15:18:22 22268 8192000000 10923322048 11386281984 1980621088 19.470 100 35 72 1 2001045904 10712704 9712112
15:18:55 9515 8192000000 10915790160 11380592640 1978143120 19.450 100 25 50 1 1995766048 10869152 6753776
15:19:11 12183 8192000000 10915702464 11375210496 1980113200 19.466 100 25 50 1 1995075280 7792432 7169648
15:19:36 31195 8192000000 10906094320 11372716032 1959648176 19.303 99 21 42 0 1975404288 9543312 6212800
15:20:14 81239 8192000000 10940958160 11382837248 1945072448 19.187 98 30 58 1 1963370000 9784848 8512704
15:21:46 36864 8192000000 10949687536 11393642496 1986109648 19.513 100 49 97 2 2016284432 16330944 13843840
15:22:40 49343 8192000000 10910830416 11401191424 1978782496 19.455 100 17 33 1 1999728896 15314048 5632352
15:23:54 31823 8192000000 10894581840 11387826176 1956920320 19.282 99 5 10 0 1974767424 16223984 1623120
15:24:41 13839 8192000000 10869387536 11359420416 1943725936 19.176 99 9 18 0 1961610112 14911648 2972528
15:25:01 12061 8192000000 10882970528 11367686144 1960210592 19.308 100 8 16 0 1975748192 13591696 1945904
15:25:38 92305 8192000000 10885444016 11366187008 1947201504 19.204 99 14 28 0 1961901792 10324128 4376160
15:27:16 70489 8192000000 10890279504 11370704896 1967600896 19.366 100 26 51 2 1986402992 12193280 6608816
15:28:39 43209 8192000000 10879242336 11352580096 1933590128 19.096 98 18 37 0 1945237424 6639248 5008048
15:29:34 56906 8192000000 10861525952 11335176192 1891355536 18.757 96 9 18 0 1903061808 9367088 2339184
15:30:38 43898 8192000000 10874373536 11340349440 1899153664 18.819 97 14 27 0 1913355616 10285872 3916080
15:31:36 78949 8192000000 10854898912 11334684672 1888494272 18.734 97 10 20 0 1904517216 13272000 2750944
15:33:01 38166 8192000000 10834923648 11299717120 1834044912 18.292 94 14 27 1 1844799920 7209072 3545936
15:33:46 60259 8192000000 10852388768 11323744256 1836821728 18.315 95 14 28 0 1849914704 9079072 4013904
15:34:53 28959 8192000000 10863257520 11308441600 1846043872 18.390 95 34 68 1 1862223536 6910272 9269392
15:35:33 10187 8192000000 10873415968 11306397696 1881237456 18.675 98 62 125 0 1907722992 8926256 17559280
15:35:51 13669 8192000000 10871841632 11315519488 1902682208 18.848 99 65 130 1 1932232496 11513936 18036352
15:36:54 23419 8192000000 10866485872 11322159104 1920207824 18.989 100 43 86 0 1946492048 13970576 12313648
15:37:24 32142 8192000000 10845903328 11296858112 1828612528 18.248 95 29 58 1 1847663616 11075488 7975600
15:38:04 41386 8192000000 10858699360 11325259776 1920908320 18.994 100 32 64 1 1943137936 12764352 9465264
15:39:38 106807 8192000000 10874613712 11337539584 1884173296 18.699 97 11 22 0 1899647440 12781984 2692160
15:41:32 51826 8192000000 10860160336 11320889344 1836517696 18.312 95 15 30 1 1857209856 16639280 4052880
15:42:30 54103 8192000000 10866860304 11315957760 1845716144 18.387 96 18 36 1 1864019968 13150240 5153584
15:44:09 100818 8192000000 10880561728 11351568384 1890257776 18.748 98 19 38 1 1907122656 11775824 5089056
15:45:55 79317 8192000000 10871556912 11339882496 1935474816 19.111 100 10 20 0 1957801840 19482112 2844912
15:47:50 94886 8192000000 10881208224 11346022400 1923955616 19.019 99 19 38 1 1941630688 12952912 4722160
15:49:32 28831 8192000000 10859958256 11324420096 1921646416 19.000 99 19 38 0 1941488384 14677216 5164752
15:50:07 23966 8192000000 10883163664 11348283392 1925732624 19.033 99 28 56 2 1949905840 16462640 7710576
15:50:39 43099 8192000000 10870229840 11343605760 1944729936 19.184 100 24 46 1 1960392224 8850096 6812192
15:51:28 78076 8192000000 10874737392 11353198592 1910524544 18.911 98 8 16 0 1923575312 10745248 2305520
15:52:54 50019 8192000000 10885584496 11346923520 1927938400 19.050 99 8 16 0 1943052144 12891664 2222080
15:53:50 70231 8192000000 10876312096 11353501696 1953088128 19.251 100 12 24 0 1964256000 7921984 3245888
15:55:06 49176 8192000000 10864940848 11348946944 1916955744 18.962 98 12 24 0 1935118400 14772864 3389792
15:56:02 34881 8192000000 10871444656 11355713536 1948304320 19.213 100 10 20 0 1964276496 13433488 2538688
15:56:46 62334 8192000000 10854764176 11339116544 1879089760 18.658 96 10 20 0 1889276144 7934656 2251728
15:57:55 51232 8192000000 10862599712 11340976128 1915595520 18.952 98 15 29 2 1926227808 7076048 3556240
15:58:52 62629 8192000000 10866266592 11351994368 1934282368 19.101 99 7 14 0 1943483376 7657280 1543728
16:00:15 66032 8192000000 10877999152 11352276992 1901199424 18.836 97 10 20 0 1911047840 7677392 2171024
16:01:27 67627 8192000000 10893806048 11367821312 1959956192 19.306 100 10 20 1 1974771248 11479232 3335824
16:02:41 26654 8192000000 10883773184 11351248896 1925182576 19.028 98 31 63 0 1943882640 10133952 8566112
16:03:17 16690 8192000000 10903136928 11368611840 1966494784 19.358 100 54 107 1 1993975520 12462272 15018464
16:03:40 54115 8192000000 10890082208 11361845248 1928101616 19.052 98 32 64 0 1950286464 13357424 8827424
16:04:48 52833 8192000000 10890499328 11360636928 1925801312 19.033 98 17 34 1 1945637408 15182880 4653216
16:06:00 19481 8192000000 10914112976 11379290112 1977485456 19.445 100 38 76 0 2000325824 12193136 10647232
16:06:29 40844 8192000000 10900073120 11387535360 1975184272 19.427 100 26 52 1 1997363536 14839584 7339680
16:07:17 27509 8192000000 10880655104 11352936448 1932940768 19.090 98 16 33 0 1948408256 10832336 4635152
16:07:51 31105 8192000000 10896851904 11359543296 1939128608 19.140 99 26 52 2 1953388160 7643008 6616544
16:08:31 28086 8192000000 10894198992 11352559616 1909477968 18.902 97 34 67 1 1928426256 9461616 9486672
16:09:07 22083 8192000000 10894278576 11348807680 1928936352 19.058 98 42 84 0 1951323488 11129840 11257296
16:09:36 31527 8192000000 10921153408 11381936128 1965277328 19.348 100 40 80 1 1988018736 12051856 10689552
16:10:22 85926 8192000000 10913318016 11393052672 1940334112 19.149 98 17 34 1 1959055488 13716544 5004832
16:12:00 93487 8192000000 10884511728 11350921216 1844576400 18.378 93 19 38 0 1861303600 11821248 4905952
16:13:40 47124 8192000000 10896571264 11370262528 1931594384 19.080 98 25 50 3 1948216816 9736592 6885840
16:14:52 118452 8192000000 10881604592 11351048192 1865510080 18.548 95 14 28 0 1883703008 14245808 3947120
16:17:11 74942 8192000000 10832599392 11293106176 1867955872 18.568 96 31 62 2 1883729184 6477088 9296224
16:18:32 39365 8192000000 10843393760 11326259200 1900689792 18.832 98 23 47 1 1914765840 7401312 6674736
16:20:42 88775 8192000000 10857421984 11338633216 1910953792 18.914 98 13 26 1 1923138752 8353200 3831760
16:22:30 61918 8192000000 10838969184 11332284416 1925196352 19.028 100 8 16 0 1936523872 9162896 2164624
16:23:39 30078 8192000000 10865108880 11311427584 1863931792 18.535 96 34 68 1 1878863024 5629104 9302128
16:24:17 34549 8192000000 10838943408 11308072960 1906344480 18.877 99 37 67 1 1923506592 7502688 9659424
16:25:05 49152 8192000000 10850813712 11334299648 1913105968 18.932 99 10 20 0 1924341616 8384304 2851344
16:26:07 35984 8192000000 10846788032 11302473728 1841441984 18.353 96 25 51 1 1858924416 9858784 7623648
16:26:50 36845 8192000000 10843738768 11311177728 1877383664 18.644 98 22 44 1 1891455328 8222432 5849232
16:27:38 14181 8192000000 9479378592 9790701568 629093936 7.131 33 2 4 0 635866576 6355472 417168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 17-06-2021 16:29:14 to 17-06-2021 16:29:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 94 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-06-2021 16:29:47 to 17-06-2021 16:29:49.

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          247380
MON$OLDEST_ACTIVE               247381
MON$OLDEST_SNAPSHOT             247381
MON$NEXT_TRANSACTION            247381
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                       2048224
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.33474 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33474 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33474 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33474 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 ---
:106: 
:107: mscs-test-161.budzdorov.ru    Thu Jun 17 16:27:55 2021
:108:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:109: 
:110: 
:111: mscs-test-161.budzdorov.ru    Thu Jun 17 16:27:59 2021
:112:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:113: 
--- end of diff output ---

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

17.06.21 16:29:50. 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-17 16:29:53 No severe PSQL-related problems occured
17.06.21 16:29:54. End of report.