Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.12.2020 22:27
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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
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 17439160 kB
MemAvailable 31598736 kB
Buffers 0 kB
Cached 14242976 kB
SwapCached 1924 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 2020-12-02 22:27:03
DTS_END                         2020-12-02 22:27:03.0950
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60298
TRN_ID                          234499
ATT_ID                          604
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: 9219.74 24582 1106369
customer order: creation 165.18 413 19821
customer order: refuse 14.37 315 1724
order to supplier: creation 45.55 1344 5466
order to supplier: removal 3.43 119841 411
invoice (draft): creation 43.66 3559 5239
invoice (draft): removal 53.68 993 6441
invoice accept: apply 39.44 19771 4733
invoice accept: cancel 48.34 804 5801
customer reserve: creation 3746.13 189 449536
customer reserve: removal 4774.23 66 572907
realization accept: apply 80.65 184 9678
realization accept: cancel 81.28 106 9754
payment from customer: creation 56.42 140 6770
payment from customer: removal 5.28 99 634
payment to supplier: creation 46.87 169 5624
payment to supplier: removal 3.52 81 422
service: total inventory turnovers 4.66 1086 559
service: total monetary turnovers 6.38 39 766
service: aggregate perf. data 0.66 28391 79
service: refresh index statistics 0.03 314055 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-12-2020 22:28:15 to 02-12-2020 22:28:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8209
TEST_TIME 2 6386
TEST_TIME 3 6682
TEST_TIME 4 6603
TEST_TIME 5 7925
TEST_TIME 6 8012
TEST_TIME 7 8301
TEST_TIME 8 8195
TEST_TIME 9 8351
TEST_TIME 10 8013
TEST_TIME 11 8051
TEST_TIME 12 8107
TEST_TIME 13 7985
TEST_TIME 14 7861
TEST_TIME 15 8193
TEST_TIME 16 8175
TEST_TIME 17 8177
TEST_TIME 18 8088
TEST_TIME 19 8673
TEST_TIME 20 8447
TEST_TIME 21 8326
TEST_TIME 22 8339
TEST_TIME 23 8367
TEST_TIME 24 8606
TEST_TIME 25 9014
TEST_TIME 26 9236
TEST_TIME 27 9279
TEST_TIME 28 9528
TEST_TIME 29 11288
TEST_TIME 30 11577
TEST_TIME 31 11309
TEST_TIME 32 11279
TEST_TIME 33 11290
TEST_TIME 34 11088
TEST_TIME 35 10888
TEST_TIME 36 10723
TEST_TIME 37 10574
TEST_TIME 38 10452
TEST_TIME 39 10452
TEST_TIME 40 10379
TEST_TIME 41 10263
TEST_TIME 42 10151
TEST_TIME 43 10041
TEST_TIME 44 9983
TEST_TIME 45 9888
TEST_TIME 46 9770
TEST_TIME 47 9788
TEST_TIME 48 9655
TEST_TIME 49 9577
TEST_TIME 50 9560
TEST_TIME 51 9510
TEST_TIME 52 9408
TEST_TIME 53 9363
TEST_TIME 54 9282
TEST_TIME 55 9300
TEST_TIME 56 9273
TEST_TIME 57 9214
TEST_TIME 58 9371
TEST_TIME 59 9580
TEST_TIME 60 9533
TEST_TIME 61 9555
TEST_TIME 62 9568
TEST_TIME 63 9547
TEST_TIME 64 9539
TEST_TIME 65 9520
TEST_TIME 66 9565
TEST_TIME 67 9546
TEST_TIME 68 9486
TEST_TIME 69 9542
TEST_TIME 70 9593
TEST_TIME 71 9558
TEST_TIME 72 9557
TEST_TIME 73 9474
TEST_TIME 74 9442
TEST_TIME 75 9388
TEST_TIME 76 9364
TEST_TIME 77 9359
TEST_TIME 78 9406
TEST_TIME 79 9401
TEST_TIME 80 9347
TEST_TIME 81 9354
TEST_TIME 82 9316
TEST_TIME 83 9306
TEST_TIME 84 9266
TEST_TIME 85 9265
TEST_TIME 86 9186
TEST_TIME 87 9210
TEST_TIME 88 9145
TEST_TIME 89 9111
TEST_TIME 90 9160
TEST_TIME 91 9172
TEST_TIME 92 9197
TEST_TIME 93 9277
TEST_TIME 94 9268
TEST_TIME 95 9293
TEST_TIME 96 9282
TEST_TIME 97 9388
TEST_TIME 98 9342
TEST_TIME 99 9331
TEST_TIME 100 9411
TEST_TIME 101 9448
TEST_TIME 102 9469
TEST_TIME 103 9499
TEST_TIME 104 9441
TEST_TIME 105 9371
TEST_TIME 106 9319
TEST_TIME 107 9325
TEST_TIME 108 9365
TEST_TIME 109 9327
TEST_TIME 110 9297
TEST_TIME 111 9286
TEST_TIME 112 9241
TEST_TIME 113 9213
TEST_TIME 114 9231
TEST_TIME 115 9242
TEST_TIME 116 9295
TEST_TIME 117 9284
TEST_TIME 118 9287
TEST_TIME 119 9303
TEST_TIME 120 9226

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-12-2020 22:28:19 to 02-12-2020 22:28:22.

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 1521107 1521107 0 0.00 0 21482 6 0 0
doc_list_biud 1521105 1521105 0 0.00 0 31425 32 0 0
sp_add_invoice_to_stock 4881 4733 148 3.03 29 164640 19771 0 148
sp_cancel_adding_invoice 5801 5801 0 0.00 3 54372 804 0 0
sp_cancel_client_order 1724 1724 0 0.00 4 10097 315 0 0
sp_cancel_customer_reserve 572907 572907 0 0.00 1 31426 66 0 0
sp_cancel_pay_from_customer 634 634 0 0.00 2 5909 99 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 2 3588 81 0 0
sp_cancel_supplier_invoice 6454 6441 13 0.20 1 14172 993 0 13
sp_cancel_supplier_order 411 411 0 0.00 8 1188064 119842 0 0
sp_cancel_write_off 9754 9754 0 0.00 1 10480 107 0 0
sp_client_order 19821 19821 0 0.00 3 35512 413 0 0
sp_customer_reserve 449536 449536 0 0.00 0 47392 190 0 0
sp_fill_shopping_cart 30510 30510 0 0.00 1 18905 39 0 0
sp_fill_shopping_cart_clo_res 449527 449527 0 0.00 0 14933 13 0 0
sp_get_clo_for_invoice 4721 4721 0 0.00 0 17519 320 0 0
sp_kill_cost_storno 16611 16611 0 0.00 0 10020 60 0 0
sp_kill_qstorno_ret_qs2qd 1162420 1162420 0 0.00 0 31423 36 0 0
sp_kill_qty_storno 611437 611437 0 0.00 0 31423 78 0 0
sp_lock_selected_doc 19904 19904 0 0.00 0 8699 6 0 0
sp_make_cost_storno 26793 26793 0 0.00 0 21472 63 0 0
sp_multiply_rows_for_pdistr 26793 26793 0 0.00 0 9495 34 0 0
sp_multiply_rows_for_qdistr 19821 19821 0 0.00 0 26283 182 0 0
sp_pay_from_customer 6770 6770 0 0.00 4 18529 141 0 0
sp_pay_to_supplier 5624 5624 0 0.00 5 19153 170 0 0
sp_payment_common 12394 12394 0 0.00 1 19130 47 0 0
sp_qd_handle_on_cancel_clo 1724 1724 0 0.00 0 10091 290 0 0
sp_qd_handle_on_invoice_upd_sts 10522 10522 0 0.00 0 27659 362 0 0
sp_qd_handle_on_reserve_upd_sts 9678 9678 0 0.00 0 13942 54 0 0
sp_reserve_write_off 9678 9678 0 0.00 6 13998 185 0 0
sp_supplier_invoice 5239 5239 0 0.00 7 72416 3559 0 0
sp_supplier_order 5466 5466 0 0.00 5 45636 1344 0 0
srv_aggregate_perf_data 80 79 1 1.25 2485 508739 28392 0 1
srv_fill_mon_cache_memory 172 172 0 0.00 1206 175848 29399 0 0
srv_find_qd_qs_mism 1059558 1059558 0 0.00 0 13338 5 0 0
srv_make_invnt_saldo 559 559 0 0.00 29 59516 1086 0 0
srv_make_money_saldo 766 766 0 0.00 1 5606 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 157723 507125 314056 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4733 4733 0 0.00 0 8868 191 0 0
t$perf-norm:sp_cancel_adding_invoice 346 346 0 0.00 0 2263 109 0 0
t$perf-norm:sp_cancel_client_order 1724 1724 0 0.00 0 6485 18 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 1772 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 634 634 0 0.00 0 595 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 827 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 370 370 0 0.00 0 471 16 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 22359 1765 0 0
t$perf-norm:sp_cancel_write_off 940 940 0 0.00 0 2938 15 0 0
t$perf-norm:sp_client_order 19821 19821 0 0.00 0 7869 19 0 0
t$perf-norm:sp_customer_reserve 961 961 0 0.00 0 2429 9 0 0
t$perf-norm:sp_pay_from_customer 6770 6770 0 0.00 0 12501 13 0 0
t$perf-norm:sp_pay_to_supplier 5624 5624 0 0.00 0 9981 15 0 0
t$perf-norm:sp_reserve_write_off 9678 9678 0 0.00 0 11498 14 0 0
t$perf-norm:sp_supplier_invoice 5239 5239 0 0.00 0 6452 20 0 0
t$perf-norm:sp_supplier_order 5466 5466 0 0.00 0 6315 19 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 101 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 589 6 0 0
t$perf-norm:srv_make_invnt_saldo 559 559 0 0.00 0 1856 24 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 2323 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9738 9442 296 3.03 0 3502 20 0 296
v_all_customers 36004 36004 0 0.00 0 18 1 0 0
v_all_suppliers 29674 29674 0 0.00 0 17 1 0 0
v_all_wares 39642 39642 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 692 692 0 0.00 0 1897 13 0 0
v_cancel_client_order 3448 3448 0 0.00 0 2860 5 0 0
v_cancel_customer_prepayment 1268 1268 0 0.00 0 5733 16 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 3737 13 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 2596 7 0 0
v_cancel_supplier_invoice 766 740 26 3.39 0 2793 20 0 26
v_cancel_supplier_order 822 822 0 0.00 0 1794 6 0 0
v_cancel_write_off 1880 1880 0 0.00 0 988 12 0 0
v_max_id_clo_ord 5466 5466 0 0.00 0 359 1 0 0
v_max_id_clo_res 961 961 0 0.00 0 6411 15 0 0
v_max_id_ord_sup 5223 5223 0 0.00 0 6834 6 0 0
v_max_non_paid_invoice 1476 1476 0 0.00 0 1103 4 0 0
v_max_non_paid_realizn 3579 3579 0 0.00 0 4169 8 0 0
v_min_id_clo_ord 5466 5466 0 0.00 0 5109 6 0 0
v_min_id_clo_res 961 961 0 0.00 0 8002 13 0 0
v_min_id_ord_sup 5223 5223 0 0.00 0 6759 8 0 0
v_min_non_paid_invoice 5624 5624 0 0.00 0 19126 35 0 0
v_min_non_paid_realizn 6770 6770 0 0.00 0 10063 30 0 0
v_our_firm 10020 10020 0 0.00 0 21 1 0 0
v_reserve_write_off 19356 19356 0 0.00 0 4552 8 0 0
x_lock_depdocs_on_canc_invoice 11872 11872 0 0.00 0 22392 127 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 5494 361 0 0
x_make_qstorno_1000_1200 5466 5466 0 0.00 1 45618 1260 0 0
x_make_qstorno_1200_2000 5239 5239 0 0.00 3 72381 3425 0 0
x_make_qstorno_2100_3300 449536 449536 0 0.00 0 47392 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-12-2020 22:28:23 to 02-12-2020 22:28:27.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:06 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:13 11334 8192000000 10215307168 10522992640 953722016 10.428 76 51 103 0 973216192 2614576 16879600
19:57:34 17654 8192000000 10321920848 10638770176 1369811392 14.325 100 84 168 1 1403455712 4749888 28894432
19:57:58 27738 8192000000 10363751872 10686361600 1416315392 14.740 100 89 179 0 1451311920 5987040 29009488
19:58:35 18937 8192000000 10392286752 10718900224 1444124304 14.986 100 79 158 0 1476820848 6866480 25830064
19:59:05 20953 8192000000 10424519328 10756857856 1479407984 15.296 100 84 168 0 1514450304 7722032 27320288
19:59:37 20654 8192000000 10442853408 10780962816 1498265184 15.461 100 88 176 1 1535298800 8416720 28616896
20:00:06 18550 8192000000 10480272016 10821058560 1530459456 15.741 100 87 173 0 1566785856 9271904 27054496
20:00:44 22317 8192000000 10509088064 10852728832 1563638496 16.028 100 92 185 1 1606709904 14660336 28411072
20:01:15 20344 8192000000 10526099168 10873376768 1577320464 16.145 100 83 166 0 1613494192 11004800 25168928
20:01:45 19477 8192000000 10546761808 10899308544 1599619168 16.336 100 79 158 1 1634017792 10971328 23427296
20:02:13 13280 8192000000 10559161696 10918027264 1620068256 16.510 100 77 154 2 1653468288 10638432 22761600
20:02:36 14416 8192000000 10586716768 10947866624 1639927232 16.679 100 77 153 2 1673256240 10651616 22677392
20:02:57 16142 8192000000 10625654144 10988146688 1667155088 16.909 100 79 158 1 1701858288 11610192 23093008
20:03:22 10772 8192000000 10632820544 11002765312 1693240768 17.128 100 77 152 2 1727843488 12448272 22154448
20:03:43 9704 8192000000 10644523904 11017797632 1707860864 17.251 100 80 161 1 1743841152 13032912 22947376
20:03:59 12113 8192000000 10653408496 11029659648 1715944016 17.318 100 81 160 2 1751941680 13250288 22747376
20:04:18 7716 8192000000 10668352352 11042983936 1727760240 17.417 100 77 154 2 1762152416 12632928 21759248
20:04:37 9989 8192000000 10688745280 11067129856 1742717552 17.541 100 69 138 1 1774307008 12029936 19559520
20:04:56 6898 8192000000 10701956144 11081658368 1760510688 17.689 100 77 154 1 1793786400 11970896 21304816
20:05:09 5871 8192000000 10701819632 11088125952 1772250224 17.786 100 75 150 0 1805831328 12764688 20816416
20:05:21 6185 8192000000 10707133440 11094102016 1778322816 17.836 100 86 172 0 1816145344 13483552 24338976
20:05:36 4247 8192000000 10728085696 11109130240 1787134752 17.908 100 83 166 0 1823483088 13294800 23053536
20:05:55 5022 8192000000 10724810016 11115552768 1788616784 17.920 100 67 132 2 1819687360 12578720 18491856
20:06:07 2855 8192000000 10745702400 11129446400 1806939280 18.071 100 80 159 1 1840791392 11449840 22402272
20:06:17 2401 8192000000 10756109328 11143409664 1822735936 18.200 100 80 161 0 1857036384 12035392 22265056
20:06:26 3133 8192000000 10771515136 11157696512 1828437040 18.247 100 87 172 2 1866730496 14048544 24244912
20:06:36 3483 8192000000 10772742560 11161604096 1833572816 18.288 100 91 182 1 1874667248 15259344 25835088
20:06:47 2172 8192000000 10782169152 11166732288 1836714144 18.314 100 86 174 1 1874402960 13178560 24510256
20:06:55 2003 8192000000 10782872320 11172134912 1844020768 18.374 100 88 176 2 1883821104 14900944 24899392
20:07:04 2394 8192000000 10787659216 11172913152 1844301600 18.376 100 93 184 4 1883814800 12425792 27087408
20:07:12 2563 8192000000 10794215216 11180298240 1849586576 18.419 100 90 180 3 1888934576 13909856 25438144
20:07:21 2727 8192000000 10797453088 11183820800 1852127632 18.439 100 86 171 0 1888526576 12311232 24087712
20:07:31 1467 8192000000 10802241200 11188899840 1856182048 18.472 100 86 174 1 1891965008 11567552 24215408
20:07:39 1610 8192000000 10803808672 11191463936 1858916688 18.494 100 83 164 1 1893295568 11503152 22875728
20:07:47 1550 8192000000 10802416144 11194224640 1861136000 18.512 100 84 167 2 1897471056 12917216 23417840
20:07:55 2193 8192000000 10813717568 11200327680 1865662896 18.549 100 95 190 1 1905840720 13011088 27166736
20:08:04 6911 8192000000 10819823296 11206615040 1865688848 18.549 100 91 182 0 1905389040 13765568 25934624
20:08:17 1538 8192000000 10815777296 11205611520 1870022336 18.584 100 91 180 1 1909123760 13469232 25632192
20:08:25 2041 8192000000 10806330016 11203756032 1868210048 18.570 100 85 169 0 1906382288 13928720 24243520
20:08:35 3450 8192000000 10787795424 11198791680 1860648752 18.509 100 45 88 1 1884076464 10890928 12536784
20:08:45 38925 8192000000 10771329808 11197456384 1865579344 18.548 100 48 95 1 1886157040 5967456 14610240
20:09:33 10707 8192000000 10779749840 11201089536 1865388432 18.547 100 22 44 0 1878360400 6550432 6421536
20:09:53 6278 8192000000 10790524992 11215343616 1870042768 18.585 100 30 57 4 1893624384 16498480 7083136
20:10:07 10797 8192000000 10773065824 11209056256 1869836000 18.583 100 20 40 1 1882988976 7654192 5498784
20:10:24 5850 8192000000 10786273632 11211796480 1876846128 18.640 100 26 51 2 1889990576 6472512 6671936
20:10:37 3192 8192000000 10794686240 11217829888 1879849920 18.664 100 49 98 2 1901560448 8048064 13662464
20:10:48 11801 8192000000 10785130832 11213996032 1875642240 18.630 100 25 50 1 1888692592 6444592 6605760
20:11:05 6768 8192000000 10795489424 11221032960 1883752032 18.695 100 34 66 4 1899807760 6804704 9251024
20:11:20 11596 8192000000 10783175232 11220344832 1880291168 18.667 100 18 36 1 1891687056 5677968 5717920
20:11:38 9470 8192000000 10787943408 11224256512 1882017664 18.681 100 18 37 0 1893097776 6081168 4998944
20:12:00 17277 8192000000 10803182672 11228389376 1887746800 18.728 100 29 58 1 1902308320 5551440 9010080
20:12:23 56949 8192000000 10842098176 11246227456 1893891056 18.777 100 38 77 3 1910254624 5291328 11072240
20:13:26 14954 8192000000 10802273136 11241156608 1894696720 18.784 100 25 50 1 1908695680 7069712 6929248
20:13:50 9773 8192000000 10815113536 11246940160 1896135136 18.795 100 32 64 0 1912641728 7055712 9450880
20:14:06 7776 8192000000 10812054400 11243790336 1898347568 18.813 100 27 53 2 1912673104 6405840 7919696
20:14:25 5197 8192000000 10819375600 11244908544 1897151152 18.803 100 28 56 1 1911518368 6399744 7967472
20:14:38 5877 8192000000 10812380960 11242610688 1896705264 18.800 100 25 50 1 1910619584 6105616 7808704
20:14:53 5831 8192000000 10831376864 11258511360 1903616208 18.855 100 34 70 0 1923773312 10859968 9297136
20:15:09 6383 8192000000 10821366608 11253473280 1903964112 18.858 100 29 59 1 1917983888 5189920 8829856
20:15:22 9305 8192000000 10821341328 11255255040 1906114800 18.875 100 28 54 3 1919931168 6017568 7798800
20:15:39 8064 8192000000 10812760576 11247898624 1895461248 18.790 100 22 44 0 1907949584 5752176 6736160
20:15:55 5065 8192000000 10811290048 11246051328 1894546496 18.782 100 13 25 1 1903541168 5273840 3720832
20:16:09 5943 8192000000 10802527008 11240386560 1888218720 18.731 100 17 30 2 1902201088 9960672 4021696
20:16:21 42334 8192000000 10813165328 11242512384 1877670432 18.646 99 22 44 1 1890604704 5956608 6977664
20:17:32 15909 8192000000 10787650064 11223732224 1833000272 18.284 97 14 28 3 1841852208 5303136 3548800
20:17:54 9167 8192000000 10803460800 11228811264 1862364272 18.522 99 20 40 0 1873195216 5434432 5396512
20:18:10 5504 8192000000 10792688720 11213086720 1855129280 18.464 99 37 74 4 1872713008 6560640 11023088
20:18:27 6928 8192000000 10761187312 11184861184 1828046496 18.243 98 21 42 0 1840173616 5744672 6382448
20:18:40 8770 8192000000 10741420544 11148464128 1722069984 17.369 93 26 52 2 1734948080 5802224 7075872
20:18:55 5900 8192000000 10726858560 11147984896 1786504832 17.903 98 25 50 1 1804613632 11174544 6934256
20:19:07 6819 8192000000 10754903232 11181268992 1838786480 18.331 100 21 42 6 1851591344 6374400 6430464
20:19:23 6757 8192000000 10754227056 11172155392 1772026528 17.784 96 15 30 0 1781097680 4884240 4186912
20:19:36 9814 8192000000 10711219168 11128320000 1699478352 17.181 93 22 44 3 1711172944 5612224 6082368
20:19:53 10495 8192000000 10719077776 11127562240 1735258080 17.479 96 24 47 5 1746883248 4778112 6847056
20:20:09 9267 8192000000 10691984080 11108282368 1673615648 16.964 92 15 30 1 1683035376 5177632 4242096
20:20:26 6013 8192000000 10686043152 11096883200 1756260208 17.653 99 41 82 2 1775275648 6045088 12970352
20:20:39 14763 8192000000 10702350656 11113586688 1732116208 17.453 96 27 51 1 1744818432 5118704 7583520
20:21:00 69559 8192000000 10712873744 11135909888 1735867792 17.484 96 30 60 3 1750579744 5904752 8807200
20:22:15 10158 8192000000 10727540576 11154186240 1816742656 18.151 100 17 34 1 1827385312 5617744 5024912
20:22:36 7327 8192000000 10755059376 11166248960 1799457904 18.009 98 44 89 1 1819342912 7691280 12193728
20:22:50 5540 8192000000 10741123776 11158249472 1818875520 18.168 100 28 56 1 1833102640 6319248 7907872
20:23:02 5123 8192000000 10746074464 11169718272 1830813312 18.266 100 24 47 3 1844682976 5930080 7939584
20:23:14 9337 8192000000 10727616128 11151994880 1776854400 17.824 97 19 38 0 1788168528 5466640 5847488
20:23:29 10622 8192000000 10747401008 11172024320 1830013488 18.259 100 25 50 2 1843849120 5889728 7945904
20:23:48 7854 8192000000 10749827888 11179859968 1842107584 18.358 100 19 38 2 1853126320 5520080 5498656
20:24:03 7911 8192000000 10760791872 11184300032 1846692576 18.395 100 25 51 2 1859646000 5436752 7516672
20:24:21 11322 8192000000 10764576256 11187195904 1847869936 18.405 100 21 42 0 1859413008 5351280 6191792
20:24:40 15080 8192000000 10766033008 11197489152 1855891968 18.470 100 19 39 1 1866795264 5457456 5445840
20:25:02 16398 8192000000 10770669536 11203403776 1862257200 18.522 100 18 36 0 1873314544 5877168 5180176
20:25:28 17248 8192000000 10777949152 11204825088 1860894352 18.511 100 19 37 2 1871672672 5651264 5127056
20:25:51 54229 8192000000 10801260960 11213418496 1869643648 18.581 100 41 83 2 1887030288 5307600 12079040
20:26:57 12717 8192000000 10795199472 11220717568 1876323856 18.635 100 24 48 0 1888215216 5275328 6616032
20:27:18 10207 8192000000 10821769344 11241607168 1895049312 18.786 100 42 84 1 1913500112 5801328 12649472
20:27:36 6067 8192000000 10833841200 11252903936 1905173136 18.868 100 43 87 1 1923956560 6655552 12127872
20:28:00 8652 8192000000 10843336608 11259932672 1914123680 18.940 100 48 96 0 1935795744 8678816 12993248
20:28:24 10450 8192000000 10854369648 11272155136 1919776352 18.985 100 46 90 1 1942203904 9773872 12653680
20:28:47 24935 8192000000 10863104512 11285786624 1929771776 19.065 100 55 110 0 1955350944 10131040 15448128
20:29:21 22006 8192000000 10871162464 11296305152 1935544464 19.111 100 48 96 0 1959499552 10746112 13208976
20:29:52 15490 8192000000 10879761648 11304636416 1943272416 19.173 100 44 86 0 1970129936 14782624 12074896
20:30:15 30112 8192000000 10861614240 11303157760 1948887104 19.218 100 46 92 0 1973245696 11398432 12960160
20:30:52 13701 8192000000 10887977664 11312644096 1947406464 19.206 100 49 94 2 1972865184 11051104 14407616
20:31:15 16289 8192000000 10888209664 11313217536 1951617696 19.239 100 53 106 1 1980863712 13924672 15321344
20:31:38 4967 8192000000 10894272384 11317948416 1953467936 19.254 100 41 82 1 1980022624 14545264 12009424
20:31:51 1788 8192000000 10909444416 11327664128 1961106288 19.315 100 64 126 3 1996327456 15795808 19425360
20:32:06 7747 8192000000 10915667760 11335389184 1965023472 19.346 100 59 118 0 1997546672 15600016 16923184
20:32:38 7382 8192000000 10917264944 11337060352 1968352720 19.372 100 54 110 1 2000700992 15660496 16687776
20:32:53 9581 8192000000 10918623632 11341344768 1970808784 19.392 100 56 112 2 2001421216 14240992 16371440
20:33:10 1720 8192000000 10930496816 11345092608 1977616032 19.446 100 77 157 1 2016045536 16082944 22346560
20:33:18 7878 8192000000 10904756976 11337084928 1954726416 19.264 99 54 105 0 1985608336 16215664 14666256
20:33:33 3438 8192000000 10920660864 11339583488 1967988624 19.369 100 59 118 0 2002151824 17473456 16689744
20:33:43 1937 8192000000 10913459744 11327811584 1958635536 19.295 99 81 162 0 2001030800 18457152 23938112
20:33:53 3690 8192000000 10941153552 11351150592 1978942304 19.456 100 78 155 2 2020749408 19707856 22099248
20:34:03 3770 8192000000 10934188112 11344564224 1979045056 19.457 100 80 160 1 2021805744 18438608 24322080
20:34:13 4996 8192000000 10918935648 11343515648 1976594000 19.438 100 84 170 1 2018511984 17824912 24093072
20:34:27 14670 8192000000 10916355328 11341725696 1956415840 19.278 99 57 114 2 1990313664 17869264 16028560
20:35:10 4433 8192000000 10911218784 11335368704 1951680256 19.240 99 56 112 1 1989844096 21357360 16806480
20:35:26 4506 8192000000 10926252096 11348111360 1970150064 19.387 100 55 108 1 2008774928 22067856 16557008
20:35:37 3765 8192000000 10910808400 11329503232 1954534480 19.263 99 64 127 2 1996949840 23475280 18940080
20:35:50 13134 8192000000 10931689968 11358228480 1977019184 19.441 100 71 139 1 2022430272 25069696 20341392
20:36:10 16772 8192000000 10940601664 11371663360 1981507200 19.477 100 62 123 2 2023836192 24819056 17509936
20:36:39 4557 8192000000 10943223872 11375153152 1988751264 19.534 100 63 127 0 2037731824 30737696 18242864
20:37:07 9969 8192000000 10936268960 11377303552 1989718464 19.542 100 49 97 0 2034279936 29661376 14900096
20:37:40 7775 8192000000 10969571536 11402547200 2000389408 19.626 100 44 87 2 2052681472 39302864 12989200
20:37:56 3621 8192000000 10974605408 11399921664 2005702416 19.668 100 51 101 0 2056907504 36245440 14959648
20:38:08 5416 8192000000 10967003584 11397476352 1988378448 19.531 99 62 123 4 2043994320 37214320 18401552
20:38:24 3570 8192000000 10973425104 11400622080 2000971440 19.630 100 69 136 1 2057901856 35900656 21029760
20:38:34 2273 8192000000 10978056560 11395121152 1998519568 19.611 100 81 163 0 2059111120 36090384 24501168
20:38:44 8133 8192000000 10958178752 11379613696 1984910624 19.504 99 71 142 0 2044545856 38632016 21003216
20:38:59 6354 8192000000 10959904704 11378839552 1987222256 19.522 100 74 148 3 2047318896 39095536 21001104
20:39:16 4622 8192000000 10969191232 11386580992 1989181616 19.537 100 76 152 0 2052018432 39367728 23469088
20:39:28 3141 8192000000 10961040224 11381047296 1971868080 19.400 99 67 134 2 2030549824 38641104 20040640
20:39:40 6083 8192000000 10938155216 11362992128 1963755040 19.336 99 60 118 2 2022461280 40177296 18528944
20:39:53 4745 8192000000 10957118864 11381907456 1982608288 19.485 100 63 124 0 2043430304 41339232 19482784
20:40:04 4466 8192000000 10958028768 11380899840 1982147536 19.482 100 74 147 3 2046443648 41448048 22848064
20:40:19 13058 8192000000 10947405392 11377315840 1973153648 19.410 100 63 125 2 2033555264 41551792 18849824
20:40:44 4552 8192000000 10944877200 11368034304 1952994768 19.250 99 64 124 0 2014462944 42705728 18762448
20:40:56 1545 8192000000 10957801168 11376775168 1975301264 19.427 100 85 170 0 2045980976 44308864 26370848
20:41:08 2221 8192000000 10932510864 11341864960 1930704752 19.073 98 84 167 2 2000338928 44330592 25303584
20:41:18 3795 8192000000 10934182240 11350163456 1951540816 19.239 99 73 144 1 2019277984 45383664 22353504
20:41:30 3760 8192000000 10964757536 11378913280 1973997984 19.417 100 85 168 1 2046980864 47113248 25869632
20:41:43 3583 8192000000 10973404544 11379376128 1975910512 19.432 100 92 182 1 2052980960 49435824 27634624
20:41:53 6684 8192000000 10944487200 11357429760 1954440576 19.262 100 82 163 0 2029250320 50372400 24437344
20:42:08 7078 8192000000 10956510688 11376111616 1967743920 19.368 100 75 148 2 2043977728 53416320 22817488
20:42:24 1535 8192000000 10961305200 11384090624 1972053952 19.402 100 62 122 4 2043310144 52933008 18323184
20:42:34 4188 8192000000 10955180576 11366633472 1965505232 19.350 100 67 134 2 2032958256 47087232 20365792
20:42:46 6615 8192000000 10959588480 11375149056 1968749120 19.376 100 71 142 0 2041187744 50835744 21602880
20:43:03 6694 8192000000 10959645344 11376095232 1956766768 19.280 99 69 137 2 2029421376 51734176 20920432
20:43:28 7387 8192000000 10974757248 11387793408 1972058736 19.402 100 84 164 2 2055280128 58173280 25048112
20:43:43 1964 8192000000 10974408064 11387318272 1976932448 19.440 100 81 159 0 2054610256 53217760 24460048
20:43:53 10493 8192000000 10972367408 11391275008 1963949296 19.337 99 72 143 1 2040097616 54368592 21779728
20:44:20 2306 8192000000 10979308880 11393007616 1973147792 19.410 100 78 157 2 2058538208 61254352 24136064
20:44:30 1201 8192000000 10978991936 11393536000 1979092384 19.458 100 77 155 1 2060662848 57149744 24420720
20:44:39 7415 8192000000 10954786384 11377537024 1964059248 19.338 100 60 117 2 2039314800 56641664 18613888
20:44:59 1208 8192000000 10989372576 11393568768 1973778416 19.415 100 80 161 4 2058718848 59766288 25174144
20:45:10 3679 8192000000 10984343712 11403673600 1979988736 19.465 100 72 143 0 2064338304 62036288 22313280
20:45:21 3213 8192000000 10987767072 11392524288 1976279504 19.435 100 82 164 3 2065224464 63973808 24971152
20:45:32 1435 8192000000 10991639600 11400212480 1976901168 19.440 100 90 182 2 2070520112 65691952 27926992
20:45:41 2678 8192000000 11000336656 11410567168 1984347056 19.499 100 89 178 2 2079222304 66881296 27993952
20:45:51 2515 8192000000 10993647664 11412242432 1988865984 19.535 100 72 143 0 2079998608 68727360 22405264
20:46:03 2354 8192000000 11005205600 11416125440 1975783984 19.431 99 90 180 0 2070704496 67499008 27421504
20:46:14 1956 8192000000 11012248544 11416821760 1992965312 19.567 100 93 186 1 2090243632 69197520 28080800
20:46:23 1648 8192000000 10995701152 11397771264 1969176656 19.379 99 91 179 0 2065971488 68806320 27988512
20:46:31 2730 8192000000 11002677776 11414368256 1986531008 19.516 100 79 158 1 2080071840 69012992 24527840
20:46:43 4247 8192000000 10974647056 11395702784 1968456928 19.373 99 67 133 2 2053486160 64901872 20127360
20:46:56 5164 8192000000 10973626608 11412045824 1984161808 19.498 100 44 88 2 2061709680 63177360 14370512
20:47:07 5642 8192000000 10959924848 11393212416 1943805760 19.177 98 46 92 0 2023050944 63923712 15321472
20:47:23 4271 8192000000 10987209200 11408527360 1980202208 19.466 100 59 118 1 2064391872 65574096 18615568
20:47:35 4821 8192000000 10979050096 11401601024 1971855856 19.400 100 59 118 3 2060317920 69303984 19158080
20:47:48 1238 8192000000 10985176480 11399770112 1976956128 19.441 100 82 163 2 2069250096 66144048 26149920
20:47:56 4091 8192000000 10988860672 11410370560 1985799184 19.511 100 70 140 1 2075493840 67366256 22328400
20:48:08 7484 8192000000 10977549408 11412955136 1984965040 19.504 100 40 81 0 2065032656 66916560 13151056
20:48:27 9038 8192000000 10988532656 11417505792 1970938736 19.393 99 49 98 0 2055980304 69147168 15894400
20:48:47 1783 8192000000 11010304288 11423059968 1991617216 19.557 100 74 141 2 2085202272 70576912 23008144
20:48:55 7265 8192000000 11004010896 11434496000 1994300672 19.578 100 48 96 0 2085829728 75120704 16408352
20:49:10 9713 8192000000 11022334736 11440975872 2002486336 19.642 100 62 124 3 2099774592 76708112 20580144
20:49:39 8636 8192000000 11014551568 11439513600 1995078736 19.584 100 51 103 0 2090774272 77940208 17755328
20:49:56 3876 8192000000 10983482784 11406036992 1942683392 19.168 98 61 120 3 2042788112 79299008 20805712
20:50:15 8478 8192000000 10982300592 11420258304 1972644016 19.406 100 43 86 0 2071729952 83397568 15688368
20:50:37 4404 8192000000 10989621632 11423883264 1974793088 19.423 100 47 92 2 2076046944 84500704 16753152
20:50:48 8303 8192000000 10990189488 11425304576 1972383344 19.404 100 43 86 3 2070807696 83059248 15365104
20:51:04 4477 8192000000 10997359216 11431989248 1980799312 19.471 100 47 92 1 2081405872 84172896 16433664
20:51:19 4133 8192000000 10990633072 11415670784 1967110336 19.363 99 63 126 2 2066189008 77839456 21239216
20:51:33 8565 8192000000 10972742496 11412422656 1950717152 19.232 99 37 74 0 2043983072 79913008 13352912
20:51:58 19829 8192000000 10951394544 11392974848 1921782752 19.001 98 40 80 1 2018736752 82854512 14099488
20:53:16 15453 8192000000 10964059120 11409612800 1949502848 19.223 100 32 64 0 2043812112 82619888 11689376
20:53:44 26615 8192000000 10953193296 11403468800 1924620096 19.024 99 33 66 1 2024114528 86506448 12987984
20:54:27 28829 8192000000 10947398704 11398279168 1940019152 19.147 100 31 62 0 2035820192 83516608 12284432
20:55:23 33153 8192000000 10955479888 11410165760 1933416416 19.094 100 25 50 0 2039289808 95209536 10663856
20:56:09 50414 8192000000 10908880208 11394998272 1953949776 19.258 100 18 36 0 2037404240 76562608 6891856
20:57:05 43246 8192000000 10894529152 11340652544 1907134496 18.884 98 23 46 0 1947514880 32400656 7979728
20:58:21 32192 8192000000 10924477040 11353796608 1961294752 19.316 100 62 125 1 1993934128 13606592 19032784
20:59:00 21110 8192000000 10899230720 11354984448 1964118640 19.339 100 36 72 2 1988463360 14378656 9966064
20:59:34 24961 8192000000 10901920000 11358593024 1968928880 19.377 100 37 74 1 1990590848 10721056 10940912
21:00:21 74184 8192000000 10876145104 11348119552 1921584336 19.000 98 15 30 0 1940442144 14591456 4266352
21:01:42 59387 8192000000 10856118336 11317682176 1890781248 18.752 97 12 24 1 1903362912 9561888 3019776
21:03:15 93726 8192000000 10876196960 11333562368 1892921520 18.769 97 17 35 1 1907823104 10918080 3983504
21:04:55 20171 8192000000 10887465904 11341873152 1949003408 19.219 100 15 31 0 1962169136 9316464 3849264
21:05:22 67107 8192000000 10898386592 11352768512 1947022096 19.203 99 25 50 1 1965232880 10755536 7455248
21:06:48 100657 8192000000 10885175040 11345223680 1925224384 19.029 98 17 34 2 1938491104 7899680 5367040
21:08:40 39682 8192000000 10886143632 11346579456 1950533632 19.231 99 34 66 2 1968212144 8172384 9506128
21:09:34 97087 8192000000 10899845264 11366641664 1965531904 19.350 100 16 32 1 1978388656 8665968 4190784
21:11:48 100220 8192000000 10878350048 11336110080 1943418912 19.174 98 18 36 0 1963873712 15286320 5168480
21:14:06 126709 8192000000 10915605264 11372122112 1960759168 19.312 99 24 49 0 1979895696 12594944 6541584
21:16:22 9127 8192000000 10906299792 11360079872 1960487136 19.310 99 43 84 2 1980747264 8400464 11859664
21:16:40 41633 8192000000 10913984192 11377401856 1972466416 19.405 99 48 96 0 2000077392 13903024 13707952
21:17:51 95498 8192000000 10912474480 11397480448 1988091360 19.529 100 15 30 1 2011346016 19135952 4118704
21:19:34 24959 8192000000 10913398464 11383205888 1974196256 19.419 99 16 32 0 1992345680 13653184 4496240
21:20:10 41080 8192000000 10917339456 11383521280 1982271232 19.483 100 39 79 0 2008982528 15194624 11516672
21:21:09 21587 8192000000 10941620480 11398602752 1992630592 19.565 100 48 96 1 2022144432 15950320 13563520
21:21:43 52401 8192000000 10934424848 11409772544 1985387376 19.507 99 28 54 1 2016042624 22435936 8219312
21:22:57 64674 8192000000 10930954144 11410145280 1997618688 19.604 100 15 30 0 2028321872 25819632 4883552
21:24:18 111133 8192000000 10952835456 11434627072 1995765056 19.589 100 11 22 1 2035953648 36063632 4124960
21:26:56 82822 8192000000 10904251728 11372048384 1905860384 18.873 95 17 34 0 1918188656 7745824 4582448
21:28:28 55606 8192000000 10906198944 11381055488 1951315728 19.237 98 16 32 0 1965522624 10135840 4071056
21:29:34 40409 8192000000 10912364720 11389476864 1963944768 19.337 99 14 28 0 1978462144 10958832 3558544
21:30:37 44755 8192000000 10908724352 11387895808 1964896752 19.345 99 17 34 1 1983797776 13980480 4920544
21:31:28 45051 8192000000 10927284736 11382312960 1961574960 19.319 98 42 83 1 1985913680 12766176 11572544
21:32:21 34851 8192000000 10916658736 11353960448 1889482368 18.742 95 26 52 1 1904015280 7476544 7056368
21:33:03 19322 8192000000 10923426496 11369521152 1935760704 19.113 98 58 116 1 1971256656 19474656 16021296
21:33:28 9928 8192000000 10919792144 11372634112 1969747472 19.383 100 51 103 0 1996944528 12967024 14230032
21:33:46 27627 8192000000 10895935936 11366580224 1952063616 19.243 99 29 58 2 1975453856 15279408 8110832
21:34:22 54864 8192000000 10910391824 11357392896 1898068912 18.811 96 42 85 1 1921622320 11916144 11637264
21:35:26 34198 8192000000 10886860256 11336253440 1877796432 18.647 95 49 94 4 1900922176 9478048 13647696
21:36:13 102218 8192000000 10849802096 11323822080 1791417872 17.943 92 15 30 0 1805261536 10024544 3819120
21:38:36 59351 8192000000 10837786192 11289571328 1788437216 17.919 93 19 36 1 1803190592 9420976 5332400
21:39:46 140732 8192000000 10846508736 11302883328 1866186400 18.553 97 31 62 2 1883670384 9091248 8392736
21:42:16 29746 8192000000 10874610832 11318358016 1908393984 18.894 99 38 76 1 1930855584 12217536 10244064
21:43:05 63182 8192000000 10849250240 11310530560 1888325936 18.732 98 30 60 0 1913907088 16566672 9014480
21:44:28 42087 8192000000 10836433376 11304656896 1882569216 18.686 98 30 60 2 1908098032 15659936 9868880
21:45:27 64916 8192000000 10835238752 11311886336 1896386352 18.797 99 15 28 3 1913779648 13265824 4127472
21:46:38 40998 8192000000 10851436480 11311550464 1929549872 19.063 100 17 34 0 1943843504 9973568 4320064
21:47:25 78272 8192000000 10867164976 11333255168 1923214912 19.013 99 15 31 0 1937569920 9944448 4410560
21:48:53 80317 8192000000 10841415488 11309809664 1893459168 18.774 98 8 16 1 1904643696 9120080 2064448
21:51:06 73252 8192000000 10848740464 11321196544 1936828784 19.121 100 17 34 1 1949908336 8734144 4345408
21:52:54 71095 8192000000 10854196688 11319992320 1916035776 18.955 99 19 38 0 1929327168 8205456 5085936
21:54:18 80308 8192000000 10866190992 11343867904 1922233536 19.005 99 22 44 0 1936814176 7980304 6600336
21:55:46 48686 8192000000 10879832816 11351494656 1955842976 19.273 100 15 30 3 1971481008 11763408 3874624
21:56:49 54873 8192000000 10887360240 11366789120 1942245712 19.165 99 20 40 0 1964674464 16518192 5910560
21:57:50 32703 8192000000 10877331696 11345522688 1903038992 18.851 97 17 34 0 1920613888 12809040 4765856
21:58:38 20127 8192000000 10870345616 11318517760 1898586208 18.815 98 32 64 1 1917075648 9728640 8760800
21:59:06 49983 8192000000 10875984816 11340587008 1942629392 19.168 100 34 68 1 1965323824 13807920 8886512
22:00:02 75627 8192000000 10890509104 11361923072 1939180896 19.140 99 15 30 2 1963963760 20367136 4415728
22:01:24 43345 8192000000 10895894896 11366453248 1969001088 19.378 100 19 38 1 1985900736 11861216 5038432
22:02:20 73570 8192000000 10927115680 11390275584 1965789456 19.352 99 20 40 0 1985578928 14900464 4889008
22:03:41 54877 8192000000 10908792384 11381161984 1957693344 19.288 99 18 36 1 1981246464 18699712 4853408
22:04:42 41371 8192000000 10905289872 11365924864 1942559904 19.167 98 19 36 1 1956506112 8903664 5042544
22:05:38 45994 8192000000 10935243216 11395624960 1993088160 19.568 100 44 87 4 2019279856 14064240 12127456
22:06:39 51522 8192000000 10914759984 11403804672 1989936304 19.543 100 22 44 0 2009761936 13237216 6588416
22:07:40 60516 8192000000 10931326128 11410296832 1971722256 19.399 99 12 24 0 1988124976 12734128 3668592
22:08:53 66554 8192000000 10940646384 11393507328 1974626384 19.422 99 28 56 1 1995246672 12902000 7718288
22:10:08 46556 8192000000 10919285600 11396898816 1956786464 19.280 98 38 76 1 1979853392 12597696 10469232
22:11:17 112069 8192000000 10927509616 11398139904 1972717232 19.407 99 25 49 2 1989382480 9765168 6900080
22:13:16 60385 8192000000 10907375952 11385466880 1957179936 19.284 98 19 38 1 1976258704 13200432 5878336
22:14:22 32500 8192000000 10930525328 11378868224 1962503872 19.326 99 21 42 1 1977944816 9137520 6303424
22:15:03 175848 8192000000 10897746096 11388895232 1904930672 18.866 96 19 39 0 1919206608 9311728 4964208
22:18:05 44133 8192000000 10907487152 11404435456 1982094752 19.481 100 6 12 1 2002104304 18272496 1737056
22:18:56 27869 8192000000 10886550400 11373502464 1965294592 19.348 99 7 14 1 1980671216 13133776 2242848
22:20:15 72261 8192000000 10890930320 11365109760 1888316432 18.732 95 18 36 0 1904594544 11035568 5242544
22:21:49 58125 8192000000 10890971120 11363786752 1943705200 19.176 99 16 32 2 1961598960 13273232 4620528
22:22:55 47224 8192000000 10855429408 11315572736 1823490336 18.206 93 37 74 1 1851223008 16951216 10781456
22:24:01 61118 8192000000 10880325984 11349004288 1903255440 18.852 98 14 26 2 1919096528 11802416 4038672
22:25:39 63260 8192000000 10896453952 11375226880 1940680064 19.152 99 15 30 0 1968007856 22711568 4616224
22:26:52 26080 8192000000 9097591792 9328164864 253311984 2.999 14 2 2 1 260573872 6842208 419680

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 02-12-2020 22:28:29 to 02-12-2020 22:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 148 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-12-2020 22:29:02 to 02-12-2020 22:29:04.

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          234796
MON$OLDEST_ACTIVE               234797
MON$OLDEST_SNAPSHOT             234797
MON$NEXT_TRANSACTION            234797
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                       2041440
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:266: 
:267: mscs-test-161.budzdorov.ru    Wed Dec  2 22:27:22 2020
:268:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:269: 
--- end of diff output ---

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

02.12.20 22:29:05. 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
2020-12-02 22:29:07 No severe PSQL-related problems occured
02.12.20 22:29:08. End of report.