Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.11.2020 16:34
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 16104716 kB
MemAvailable 31549964 kB
Buffers 0 kB
Cached 15585908 kB
SwapCached 5216 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-11-18 16:32:14
DTS_END                         2020-11-18 16:32:14.4350
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/55728
TRN_ID                          251068
ATT_ID                          664
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: 9209.25 19637 1105110
customer order: creation 189.48 350 22737
customer order: refuse 16.27 366 1952
order to supplier: creation 50.97 1201 6116
order to supplier: removal 3.18 96248 381
invoice (draft): creation 50.38 3353 6046
invoice (draft): removal 47.33 756 5680
invoice accept: apply 45.77 16448 5492
invoice accept: cancel 42.87 831 5144
customer reserve: creation 4173.90 164 500868
customer reserve: removal 4284.01 57 514081
realization accept: apply 93.05 194 11166
realization accept: cancel 71.59 104 8591
payment from customer: creation 64.04 129 7685
payment from customer: removal 6.01 61 721
payment to supplier: creation 53.15 143 6378
payment to supplier: removal 3.97 107 476
service: total inventory turnovers 5.02 1220 602
service: total monetary turnovers 7.48 35 898
service: aggregate perf. data 0.77 23171 92
service: refresh index statistics 0.03 247808 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-11-2020 16:35:02 to 18-11-2020 16:35:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3281
TEST_TIME 2 3488
TEST_TIME 3 4368
TEST_TIME 4 4257
TEST_TIME 5 4891
TEST_TIME 6 5360
TEST_TIME 7 5335
TEST_TIME 8 5153
TEST_TIME 9 5085
TEST_TIME 10 5558
TEST_TIME 11 6058
TEST_TIME 12 6553
TEST_TIME 13 6814
TEST_TIME 14 7172
TEST_TIME 15 8059
TEST_TIME 16 7980
TEST_TIME 17 8182
TEST_TIME 18 8646
TEST_TIME 19 8830
TEST_TIME 20 9212
TEST_TIME 21 9275
TEST_TIME 22 9479
TEST_TIME 23 9478
TEST_TIME 24 9768
TEST_TIME 25 10029
TEST_TIME 26 10021
TEST_TIME 27 10514
TEST_TIME 28 10778
TEST_TIME 29 10677
TEST_TIME 30 10673
TEST_TIME 31 10611
TEST_TIME 32 10589
TEST_TIME 33 10522
TEST_TIME 34 10419
TEST_TIME 35 10582
TEST_TIME 36 10462
TEST_TIME 37 10538
TEST_TIME 38 10304
TEST_TIME 39 10132
TEST_TIME 40 10176
TEST_TIME 41 10106
TEST_TIME 42 9978
TEST_TIME 43 9962
TEST_TIME 44 9900
TEST_TIME 45 9872
TEST_TIME 46 9859
TEST_TIME 47 9821
TEST_TIME 48 9688
TEST_TIME 49 9627
TEST_TIME 50 9597
TEST_TIME 51 9993
TEST_TIME 52 10013
TEST_TIME 53 9905
TEST_TIME 54 9865
TEST_TIME 55 9890
TEST_TIME 56 9910
TEST_TIME 57 9949
TEST_TIME 58 9917
TEST_TIME 59 10011
TEST_TIME 60 9920
TEST_TIME 61 9947
TEST_TIME 62 9953
TEST_TIME 63 9896
TEST_TIME 64 9840
TEST_TIME 65 9877
TEST_TIME 66 9788
TEST_TIME 67 9740
TEST_TIME 68 9709
TEST_TIME 69 9663
TEST_TIME 70 9593
TEST_TIME 71 9658
TEST_TIME 72 9586
TEST_TIME 73 9565
TEST_TIME 74 9475
TEST_TIME 75 9450
TEST_TIME 76 9407
TEST_TIME 77 9314
TEST_TIME 78 9337
TEST_TIME 79 9380
TEST_TIME 80 9371
TEST_TIME 81 9331
TEST_TIME 82 9310
TEST_TIME 83 9298
TEST_TIME 84 9432
TEST_TIME 85 9442
TEST_TIME 86 9368
TEST_TIME 87 9389
TEST_TIME 88 9424
TEST_TIME 89 9546
TEST_TIME 90 9594
TEST_TIME 91 9705
TEST_TIME 92 9624
TEST_TIME 93 9530
TEST_TIME 94 9494
TEST_TIME 95 9484
TEST_TIME 96 9456
TEST_TIME 97 9415
TEST_TIME 98 9384
TEST_TIME 99 9412
TEST_TIME 100 9370
TEST_TIME 101 9333
TEST_TIME 102 9305
TEST_TIME 103 9403
TEST_TIME 104 9494
TEST_TIME 105 9462
TEST_TIME 106 9436
TEST_TIME 107 9497
TEST_TIME 108 9488
TEST_TIME 109 9572
TEST_TIME 110 9540
TEST_TIME 111 9481
TEST_TIME 112 9431
TEST_TIME 113 9421
TEST_TIME 114 9439
TEST_TIME 115 9407
TEST_TIME 116 9387
TEST_TIME 117 9368
TEST_TIME 118 9330
TEST_TIME 119 9288
TEST_TIME 120 9213

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-11-2020 16:35:06 to 18-11-2020 16:35:09.

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 1567191 1567191 0 0.00 0 22302 6 0 0
doc_list_biud 1567181 1567181 0 0.00 0 34199 24 0 0
sp_add_invoice_to_stock 5643 5492 151 2.67 37 275938 16448 0 151
sp_cancel_adding_invoice 5144 5144 0 0.00 5 59666 832 0 0
sp_cancel_client_order 1952 1952 0 0.00 4 8733 367 0 0
sp_cancel_customer_reserve 514081 514081 0 0.00 1 17775 57 0 0
sp_cancel_pay_from_customer 721 721 0 0.00 3 4404 61 0 0
sp_cancel_pay_to_supplier 476 476 0 0.00 3 5116 107 0 0
sp_cancel_supplier_invoice 5698 5680 18 0.31 2 17994 756 0 18
sp_cancel_supplier_order 381 381 0 0.00 10 881107 96248 0 0
sp_cancel_write_off 8591 8591 0 0.00 1 11566 105 0 0
sp_client_order 22737 22737 0 0.00 4 21518 350 0 0
sp_customer_reserve 500868 500868 0 0.00 0 28711 164 0 0
sp_fill_shopping_cart 34897 34897 0 0.00 1 9060 41 0 0
sp_fill_shopping_cart_clo_res 500867 500867 0 0.00 0 23456 13 0 0
sp_get_clo_for_invoice 5488 5488 0 0.00 0 23027 262 0 0
sp_kill_cost_storno 14932 14932 0 0.00 0 8787 52 0 0
sp_kill_qstorno_ret_qs2qd 1042814 1042814 0 0.00 0 17735 31 0 0
sp_kill_qty_storno 552476 552476 0 0.00 0 34198 67 0 0
sp_lock_selected_doc 22832 22832 0 0.00 0 8603 6 0 0
sp_make_cost_storno 30717 30717 0 0.00 0 20760 67 0 0
sp_multiply_rows_for_pdistr 30716 30716 0 0.00 0 9381 27 0 0
sp_multiply_rows_for_qdistr 22737 22737 0 0.00 0 13118 161 0 0
sp_pay_from_customer 7685 7685 0 0.00 4 20713 129 0 0
sp_pay_to_supplier 6378 6378 0 0.00 4 21162 143 0 0
sp_payment_common 14061 14061 0 0.00 1 20679 33 0 0
sp_qd_handle_on_cancel_clo 1952 1952 0 0.00 0 8727 340 0 0
sp_qd_handle_on_invoice_upd_sts 10628 10628 0 0.00 0 34196 319 0 0
sp_qd_handle_on_reserve_upd_sts 11163 11163 0 0.00 0 22386 61 0 0
sp_reserve_write_off 11166 11166 0 0.00 6 22424 195 0 0
sp_supplier_invoice 6046 6046 0 0.00 7 78485 3353 0 0
sp_supplier_order 6116 6116 0 0.00 5 27940 1201 0 0
srv_aggregate_perf_data 92 92 0 0.00 2937 389722 23171 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 1100 155150 32114 0 0
srv_find_qd_qs_mism 1052201 1052201 0 0.00 0 14885 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 31 66669 1220 0 0
srv_make_money_saldo 898 898 0 0.00 0 7001 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 197636 326049 247809 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5492 5492 0 0.00 0 12905 144 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 3969 102 0 0
t$perf-norm:sp_cancel_client_order 1952 1952 0 0.00 0 5775 12 0 0
t$perf-norm:sp_cancel_customer_reserve 790 790 0 0.00 0 2635 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 721 721 0 0.00 0 2060 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 476 476 0 0.00 0 2061 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 1646 11 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 21227 1508 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 1339 5 0 0
t$perf-norm:sp_client_order 22737 22737 0 0.00 0 7331 16 0 0
t$perf-norm:sp_customer_reserve 1136 1136 0 0.00 0 10679 14 0 0
t$perf-norm:sp_pay_from_customer 7685 7685 0 0.00 0 12383 10 0 0
t$perf-norm:sp_pay_to_supplier 6378 6378 0 0.00 0 12166 10 0 0
t$perf-norm:sp_reserve_write_off 11166 11166 0 0.00 0 10033 12 0 0
t$perf-norm:sp_supplier_invoice 6046 6046 0 0.00 0 5759 15 0 0
t$perf-norm:sp_supplier_order 6116 6116 0 0.00 0 5706 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 100 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 1934 14 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 990 22 0 0
t$perf-norm:srv_make_money_saldo 898 898 0 0.00 0 737 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 11268 10966 302 2.68 0 3763 19 0 302
v_all_customers 40548 40548 0 0.00 0 20 1 0 0
v_all_suppliers 32882 32882 0 0.00 0 96 1 0 0
v_all_wares 45474 45474 0 0.00 0 95 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 314 6 0 0
v_cancel_client_order 3904 3904 0 0.00 0 3105 6 0 0
v_cancel_customer_prepayment 1442 1442 0 0.00 0 973 5 0 0
v_cancel_customer_reserve 1580 1580 0 0.00 0 3747 10 0 0
v_cancel_payment_to_supplier 952 952 0 0.00 0 4873 14 0 0
v_cancel_supplier_invoice 852 816 36 4.22 0 1288 18 0 36
v_cancel_supplier_order 762 762 0 0.00 0 1479 7 0 0
v_cancel_write_off 2130 2130 0 0.00 0 2020 15 0 0
v_max_id_clo_ord 6115 6115 0 0.00 0 588 2 0 0
v_max_id_clo_res 1136 1136 0 0.00 0 1604 14 0 0
v_max_id_ord_sup 6045 6045 0 0.00 0 5190 5 0 0
v_max_non_paid_invoice 2096 2096 0 0.00 0 166 2 0 0
v_max_non_paid_realizn 4408 4408 0 0.00 0 386 3 0 0
v_min_id_clo_ord 6115 6115 0 0.00 0 6332 15 0 0
v_min_id_clo_res 1136 1136 0 0.00 0 2167 5 0 0
v_min_id_ord_sup 6045 6045 0 0.00 0 6988 12 0 0
v_min_non_paid_invoice 6377 6377 0 0.00 0 6566 17 0 0
v_min_non_paid_realizn 7684 7684 0 0.00 0 15404 24 0 0
v_our_firm 11478 11478 0 0.00 0 152 1 0 0
v_reserve_write_off 22326 22326 0 0.00 0 4610 7 0 0
x_lock_depdocs_on_canc_invoice 10416 10416 0 0.00 0 12126 120 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 8865 337 0 0
x_make_qstorno_1000_1200 6116 6116 0 0.00 2 27934 1107 0 0
x_make_qstorno_1200_2000 6046 6046 0 0.00 3 73081 3220 0 0
x_make_qstorno_2100_3300 500868 500868 0 0.00 0 27478 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-11-2020 16:35:10 to 18-11-2020 16:35:14.

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
14:02:19 201 8192000000 8902243952 8941592576 83400944 1.007 23 11 10 0 84103600 185648 517008
14:02:26 11843 8192000000 10212195168 10516103168 988867376 10.770 78 60 121 1 1011960096 2753120 20339600
14:02:47 43174 8192000000 10310194896 10629246976 1366996960 14.300 100 82 164 0 1397248336 4266736 25984640
14:03:39 35812 8192000000 10368626752 10692386816 1415769632 14.735 100 85 169 0 1449907632 6096784 28041216
14:04:22 20032 8192000000 10394274928 10719490048 1449427408 15.033 100 89 177 2 1484869136 6922240 28519488
14:04:52 33314 8192000000 10418138160 10744705024 1471167312 15.224 100 91 183 0 1508142864 7773072 29202480
14:05:32 19817 8192000000 10432370224 10761117696 1483942976 15.336 100 92 184 0 1521814544 8448880 29422688
14:06:14 17277 8192000000 10446521104 10778406912 1499562112 15.472 100 94 188 0 1538874576 9489536 29822928
14:06:39 18114 8192000000 10456257392 10794270720 1513838560 15.597 100 92 184 1 1553228800 10290960 29099280
14:07:18 14551 8192000000 10489599888 10831769600 1540841584 15.831 100 83 166 1 1577229584 10762432 25625568
14:07:41 13460 8192000000 10505491728 10853974016 1556635040 15.967 100 79 157 2 1590879504 10752864 23491600
14:08:06 19837 8192000000 10547846560 10906628096 1596199632 16.307 100 71 142 1 1628093216 10971984 20921600
14:08:37 10935 8192000000 10565009280 10926055424 1628136176 16.579 100 80 160 0 1663989744 11980720 23872848
14:08:57 10797 8192000000 10587308640 10951012352 1640952256 16.688 100 74 148 0 1674998352 11498096 22548000
14:09:17 10449 8192000000 10616432208 10981302272 1670583264 16.938 100 79 158 1 1705847072 11711776 23552032
14:09:37 11764 8192000000 10627430176 10999930880 1692160912 17.119 100 84 168 0 1729104688 12629280 24314496
14:09:55 5863 8192000000 10635246144 11005648896 1696754880 17.158 100 78 154 3 1731789152 13171920 21862352
14:10:08 8787 8192000000 10654359264 11029303296 1721408400 17.364 100 80 160 5 1757228912 13224928 22595584
14:10:24 4581 8192000000 10670310752 11042672640 1728674848 17.424 100 82 164 2 1765243360 13634256 22934256
14:10:36 5875 8192000000 10683667696 11054501888 1739019280 17.510 100 83 165 1 1776339664 14316336 23004048
14:10:48 4975 8192000000 10687956464 11059884032 1745449024 17.564 100 89 176 2 1785861936 15468336 24944576
14:11:01 3995 8192000000 10700022928 11071717376 1755963936 17.651 100 91 182 2 1797470384 15924992 25581456
14:11:11 4599 8192000000 10703075616 11079168000 1761328160 17.695 100 83 165 1 1798640256 14305856 23006240
14:11:23 3522 8192000000 10704833312 11084943360 1770487120 17.771 100 88 176 0 1809141664 13901184 24753360
14:11:33 3678 8192000000 10712283328 11089727488 1774236128 17.802 100 82 164 0 1811684016 14378976 23068912
14:11:43 3196 8192000000 10728023264 11105247232 1782273664 17.868 100 88 174 0 1822153616 15050496 24829456
14:11:53 5816 8192000000 10730765728 11113385984 1787009456 17.907 100 82 164 1 1825155536 15434704 22711376
14:12:06 4740 8192000000 10737182784 11126820864 1795354192 17.976 100 78 154 5 1831136368 13842672 21939504
14:12:18 3104 8192000000 10757452496 11139510272 1813388208 18.124 100 83 164 0 1850711392 13839888 23483296
14:12:28 2337 8192000000 10762032880 11146575872 1822426960 18.198 100 85 166 2 1858240448 12261088 23552400
14:12:37 3275 8192000000 10761596368 11152252928 1827724704 18.241 100 88 174 1 1865396816 12573792 25098320
14:12:47 2386 8192000000 10772825280 11159396352 1835461360 18.304 100 90 180 0 1875188112 13877712 25849040
14:12:55 2147 8192000000 10778194128 11161235456 1842747888 18.363 100 95 190 4 1882514096 13347600 26418608
14:13:04 1333 8192000000 10782371488 11166896128 1839602912 18.338 100 96 192 1 1880856032 14146976 27106144
14:13:11 1352 8192000000 10789543392 11172220928 1842386144 18.360 100 91 185 0 1880765056 13013984 25364928
14:13:19 2210 8192000000 10788850224 11175452672 1847072192 18.398 100 93 186 3 1887718912 14810256 25836464
14:13:28 1645 8192000000 10795378640 11181740032 1852956864 18.446 100 87 175 1 1891367856 13825584 24585408
14:13:36 1668 8192000000 10801258016 11187200000 1852128288 18.439 100 90 179 1 1891779312 12954880 26696144
14:13:44 1351 8192000000 10796340688 11185713152 1857416064 18.482 100 91 179 0 1896584976 14128032 25040880
14:13:53 1027 8192000000 10803237776 11189211136 1857857920 18.486 100 91 182 0 1897348688 13782000 25708768
14:14:00 1692 8192000000 10801570224 11191914496 1860921488 18.511 100 89 178 1 1900207168 13972320 25313360
14:14:10 7759 8192000000 10804145152 11196096512 1861037584 18.512 100 79 158 1 1898132256 14167120 22927552
14:14:24 1239 8192000000 10813116064 11202142208 1869614112 18.581 100 96 193 0 1910741728 14107680 27019936
14:14:32 20084 8192000000 10790857648 11195584512 1862665152 18.525 100 62 124 2 1891096256 11179248 17251856
14:14:59 8437 8192000000 10811624432 11207802880 1871575312 18.597 100 78 153 2 1903501008 9595728 22329968
14:15:14 1517 8192000000 10813266192 11212881920 1878475072 18.653 100 91 182 2 1916703888 12721856 25506960
14:15:22 2041 8192000000 10800784400 11208069120 1874649344 18.622 100 72 143 1 1905931600 12193104 19089152
14:15:31 3383 8192000000 10804777136 11212255232 1870267776 18.586 100 51 103 1 1895781504 11262320 14251408
14:15:40 4395 8192000000 10794977232 11209015296 1876656832 18.638 100 55 111 1 1901024336 8444832 15922672
14:15:52 2836 8192000000 10795226272 11212787712 1878069408 18.650 100 47 94 1 1900010688 9163952 12777328
14:16:02 5570 8192000000 10808643536 11218264064 1880716784 18.671 100 50 101 0 1904373712 10152656 13504272
14:16:21 4911 8192000000 10788869456 11214135296 1879215584 18.659 100 38 76 1 1898486416 8392816 10878016
14:16:32 8163 8192000000 10781567920 11211505664 1877140000 18.642 100 23 46 3 1890211648 6172336 6899312
14:16:48 5717 8192000000 10798759712 11214548992 1880594208 18.670 100 29 56 1 1895719056 7323088 7801760
14:17:00 8612 8192000000 10782941040 11216166912 1881753184 18.679 100 21 42 1 1893561168 5780624 6027360
14:17:15 8358 8192000000 10791389152 11221454848 1882463200 18.685 100 11 22 2 1890989664 4856928 3669536
14:17:34 9470 8192000000 10792081072 11223949312 1885515552 18.710 100 15 30 2 1895293488 5435696 4342240
14:17:50 7702 8192000000 10788020160 11225317376 1886130304 18.715 100 18 36 2 1897834432 6439680 5264448
14:18:04 6005 8192000000 10792547232 11228168192 1888884752 18.737 100 18 36 1 1900750032 7031984 4833296
14:18:19 11189 8192000000 10814540080 11229073408 1891293744 18.756 100 26 52 0 1904646768 5517520 7835504
14:18:39 13433 8192000000 10788882304 11230363648 1889956752 18.745 100 16 32 1 1900412528 5269360 5186416
14:18:58 57417 8192000000 10808179920 11243569152 1895282752 18.788 100 41 83 1 1912518192 4866704 12368736
14:20:06 5537 8192000000 10809117440 11241771008 1894975504 18.786 100 27 54 1 1909822752 7000976 7846272
14:20:19 5682 8192000000 10832273648 11257307136 1898331152 18.813 100 26 52 1 1920545184 15220752 6993280
14:20:33 3827 8192000000 10837154048 11252523008 1903783568 18.857 100 45 92 2 1927757568 10709120 13264880
14:20:45 6937 8192000000 10830702080 11259039744 1903108368 18.851 100 41 83 2 1926855264 12421664 11325232
14:20:58 6247 8192000000 10830877536 11257438208 1909494000 18.903 100 43 86 2 1928180048 5754752 12931296
14:21:11 9185 8192000000 10825303936 11255320576 1905452176 18.870 100 23 47 2 1918650704 6382016 6816512
14:21:29 5778 8192000000 10809790448 11242835968 1883153568 18.691 99 21 42 1 1895361488 5450352 6757568
14:21:42 14130 8192000000 10800751744 11234533376 1870482544 18.588 99 20 41 0 1881843344 5586608 5774192
14:22:03 5454 8192000000 10800459088 11231576064 1872595520 18.605 99 29 59 2 1886275824 5094576 8585728
14:22:15 6078 8192000000 10808715040 11242979328 1891806928 18.760 100 34 68 2 1907962288 6768176 9387184
14:22:27 12021 8192000000 10781568272 11221180416 1821181552 18.187 96 22 44 0 1833522576 6010768 6330256
14:22:46 5972 8192000000 10783972896 11212648448 1863462672 18.531 100 33 67 1 1883595712 10187408 9945632
14:23:00 9530 8192000000 10787637664 11194343424 1829228384 18.253 98 25 49 1 1842213728 5271312 7714032
14:23:17 62393 8192000000 10792719328 11183566848 1760840064 17.691 94 65 127 0 1786833920 6587584 19406272
14:24:25 7635 8192000000 10747097536 11167932416 1797544976 17.994 98 34 68 1 1815609520 8846224 9218320
14:24:43 5956 8192000000 10750320096 11166494720 1812082624 18.113 98 36 72 1 1827944560 5223200 10638736
14:24:55 7188 8192000000 10728418752 11141070848 1749341888 17.596 95 38 74 2 1767515648 6398352 11775408
14:25:08 8445 8192000000 10731285248 11157274624 1809574880 18.092 99 22 44 0 1823368384 7285072 6508432
14:25:24 7460 8192000000 10705797536 11116793856 1758839552 17.675 98 29 58 2 1772546272 5244240 8462480
14:25:38 10683 8192000000 10692831648 11103879168 1686006896 17.068 94 26 52 1 1699735664 5151744 8577024
14:25:56 5714 8192000000 10688993904 11106017280 1749100048 17.594 98 31 63 1 1764659664 6624304 8935312
14:26:08 5496 8192000000 10704887056 11118403584 1770738496 17.773 99 19 38 2 1782042592 5671360 5632736
14:26:20 7344 8192000000 10712305648 11130597376 1791810064 17.947 100 26 50 3 1805040640 5709056 7521520
14:26:34 9303 8192000000 10710199424 11122831360 1758809248 17.675 98 34 68 0 1774817424 6223824 9784352
14:26:51 6888 8192000000 10682830976 11097722880 1740683984 17.524 98 24 47 2 1753650640 6297824 6668832
14:27:10 7945 8192000000 10701513152 11114942464 1788178880 17.917 100 34 66 6 1804288336 5303584 10805872
14:27:24 10202 8192000000 10700342400 11118977024 1756440672 17.655 98 13 26 2 1765292080 4996576 3854832
14:27:45 5778 8192000000 10712045600 11128098816 1795284416 17.975 100 35 70 1 1812102384 6394464 10423504
14:27:59 58794 8192000000 10731106624 11144232960 1774818064 17.807 98 20 39 0 1785030512 5130560 5081888
14:29:04 10633 8192000000 10747489952 11159842816 1827565152 18.239 100 41 83 0 1844340768 5707648 11067968
14:29:21 3632 8192000000 10750427616 11164749824 1831029072 18.268 100 39 78 0 1849423776 7479888 10914816
14:29:32 6368 8192000000 10747816176 11164438528 1831034512 18.268 100 32 64 1 1846475904 6324368 9117024
14:29:45 4718 8192000000 10765869456 11179069440 1837016896 18.317 100 41 82 2 1859593792 11177888 11399008
14:29:56 5881 8192000000 10757542976 11179970560 1846437232 18.393 100 41 82 0 1864133136 6134560 11561344
14:30:10 8413 8192000000 10756265520 11172823040 1824453872 18.214 99 21 42 0 1835950160 5185472 6310816
14:30:25 8268 8192000000 10768591536 11186806784 1844456432 18.377 100 42 84 1 1863148240 6577008 12114800
14:30:40 9137 8192000000 10766331648 11191693312 1848652048 18.411 100 25 50 0 1861593888 5444400 7497440
14:30:57 7118 8192000000 10765483680 11192000512 1853475088 18.450 100 35 70 2 1869836736 5773264 10588384
14:31:12 11536 8192000000 10782735232 11197665280 1858349776 18.490 100 27 54 0 1871750064 5098976 8301312
14:31:31 9486 8192000000 10774584208 11200946176 1858521600 18.491 100 18 33 1 1869060192 6142560 4396032
14:31:47 9470 8192000000 10773460160 11205533696 1865245760 18.546 100 25 50 2 1878643568 5500704 7897104
14:32:02 8601 8192000000 10789453600 11217408000 1875366624 18.628 100 18 34 2 1889132000 9243904 4521472
14:32:17 30470 8192000000 10831423392 11238211584 1895691088 18.792 100 50 94 7 1916856576 6246992 14918496
14:32:58 87745 8192000000 10829739456 11254857728 1906391280 18.878 100 43 87 0 1929120368 9929312 12799776
14:34:38 11787 8192000000 10846491104 11266088960 1914696688 18.944 100 37 74 0 1934434864 9572608 10165568
14:34:56 16780 8192000000 10855039152 11272232960 1919053792 18.979 100 43 82 2 1941067904 10547408 11466704
14:35:20 7004 8192000000 10860648992 11279712256 1927925968 19.050 100 55 110 4 1957021520 13104672 15990880
14:35:35 14847 8192000000 10864286768 11290112000 1930873600 19.074 100 48 96 1 1957720128 13313056 13533472
14:36:04 17359 8192000000 10871219456 11296952320 1933859280 19.098 100 44 88 0 1959573504 13140160 12574064
14:36:48 16714 8192000000 10889424288 11309387776 1944535968 19.183 100 46 92 1 1975271824 17440080 13295776
14:37:27 6617 8192000000 10901063616 11322978304 1953138304 19.251 100 48 94 1 1985498400 18812192 13547904
14:37:40 36266 8192000000 10897218432 11331690496 1955407840 19.270 100 46 90 1 1994306400 25871232 13027328
14:38:24 33247 8192000000 10901441296 11339591680 1961394528 19.317 100 34 68 2 1988736304 17246192 10095584
14:39:14 26790 8192000000 10914143664 11349884928 1972704480 19.407 100 44 85 1 2003697504 18245456 12747568
14:39:52 4107 8192000000 10917079136 11350142976 1976211088 19.435 100 46 91 1 2007502624 17769376 13522160
14:40:03 11545 8192000000 10923768960 11356004352 1980806576 19.471 100 47 94 0 2013735920 19611728 13317616
14:40:29 7279 8192000000 10931604960 11362050048 1987741744 19.526 100 57 114 0 2025292896 21135936 16415216
14:40:47 4367 8192000000 10941843152 11368419328 1991797408 19.558 100 64 126 3 2032931680 21613504 19520768
14:41:01 24644 8192000000 10951920896 11381465088 1993367152 19.570 100 59 117 2 2037404416 26955232 17082032
14:41:33 5292 8192000000 10924813984 11356176384 1969037392 19.378 99 49 98 0 2008822896 24829088 14956416
14:41:46 9964 8192000000 10931473952 11359080448 1965992224 19.354 99 57 108 3 2007093024 25045408 16055392
14:42:03 3237 8192000000 10940962176 11366137856 1982373280 19.483 100 56 107 2 2021962320 23795936 15793104
14:42:13 3254 8192000000 10954341472 11366064128 1984824464 19.503 100 85 170 0 2036296944 26070704 25401776
14:42:24 5625 8192000000 10944887392 11371139072 1987126064 19.521 100 65 130 1 2034983920 28402144 19455712
14:42:39 6551 8192000000 10944092176 11374194688 1988477984 19.532 100 64 128 1 2034820624 27514336 18828304
14:42:55 4135 8192000000 10952444800 11374809088 1991619648 19.557 100 72 143 0 2042167664 29125344 21422672
14:43:10 4506 8192000000 10960859552 11384770560 1997407824 19.602 100 69 136 0 2045734432 28325056 20001552
14:43:21 5258 8192000000 10966073360 11392073728 2003501952 19.650 100 72 145 0 2052643984 27926880 21215152
14:43:39 2415 8192000000 10972246336 11397115904 2004618496 19.659 100 80 156 1 2060861072 33320416 22922160
14:43:49 2125 8192000000 10975631296 11391741952 2009912176 19.701 100 92 186 0 2066579584 29198064 27469344
14:43:57 7729 8192000000 10962667264 11392434176 1996392336 19.594 100 68 136 0 2049273280 32950752 19930192
14:44:18 1721 8192000000 10963529792 11383222272 1984333616 19.499 99 84 168 0 2039030656 29810608 24886432
14:44:29 2049 8192000000 10955794560 11374137344 1969238512 19.379 99 86 171 1 2027040128 30142128 27659488
14:44:38 1618 8192000000 10957834960 11371778048 1984483504 19.500 100 85 171 1 2040815664 31644400 24687760
14:44:47 1675 8192000000 10966461440 11378434048 1989724080 19.542 100 85 168 3 2047491408 32089104 25678224
14:44:56 3884 8192000000 10946099024 11362996224 1963161024 19.331 99 87 174 1 2021826080 32357936 26307120
14:45:08 2970 8192000000 10958040784 11371900928 1982864160 19.487 100 90 178 1 2040411936 30956640 26591136
14:45:18 2137 8192000000 10957065712 11369865216 1981351376 19.475 100 88 174 2 2038845760 31708672 25785712
14:45:26 1289 8192000000 10946895344 11360747520 1962213184 19.324 99 85 168 1 2020348832 32021328 26114320
14:45:36 4417 8192000000 10923830976 11344683008 1950916816 19.234 99 75 150 0 2009215968 35196688 23102464
14:45:47 6607 8192000000 10942459888 11365183488 1962969456 19.330 100 73 142 2 2020056144 35860592 21226096
14:46:01 2403 8192000000 10949380272 11366305792 1970367632 19.388 100 90 179 2 2034079248 37544128 26167488
14:46:10 3157 8192000000 10947571888 11365916672 1970064544 19.386 100 78 155 1 2031888304 37496176 24327584
14:46:23 1748 8192000000 10932643776 11350409216 1958588544 19.295 100 83 165 5 2021829168 37933664 25306960
14:46:31 2822 8192000000 10918230672 11332587520 1938918448 19.138 99 85 167 1 2001795312 37443392 25433472
14:46:42 4775 8192000000 10918061520 11343986688 1922276352 19.005 98 79 157 3 1981487056 36136848 23073856
14:46:54 1574 8192000000 10944726592 11352256512 1957259984 19.284 100 92 182 2 2022048192 37416720 27371488
14:47:03 2603 8192000000 10946380592 11362689024 1966271872 19.356 100 84 168 2 2026289504 34371552 25646080
14:47:13 1099 8192000000 10944213216 11354394624 1969518032 19.382 100 94 183 1 2026292336 28749728 28024576
14:47:21 3096 8192000000 10932188656 11355922432 1967492816 19.366 100 75 151 0 2018031424 28091312 22447296
14:47:31 3955 8192000000 10929293760 11349950464 1959216992 19.300 100 73 146 2 2010721952 29123568 22381392
14:47:46 2473 8192000000 10919023328 11350126592 1963028880 19.330 100 66 132 3 2012131936 28956048 20147008
14:47:56 8059 8192000000 10920627824 11355590656 1966137552 19.355 100 49 98 3 2009599376 27770016 15691808
14:48:15 13099 8192000000 10925949952 11355979776 1951436448 19.238 99 56 112 3 1999193760 30525856 17231456
14:48:35 3895 8192000000 10935080480 11366858752 1972117744 19.402 100 65 130 0 2024187520 31679296 20390480
14:48:47 10432 8192000000 10949201280 11375681536 1975583680 19.430 100 64 122 0 2026332464 32482080 18266704
14:49:07 6950 8192000000 10963008784 11386847232 1986996784 19.520 100 72 144 0 2044498048 35771456 21729808
14:49:25 3550 8192000000 10960187952 11384922112 1981879280 19.480 100 73 146 0 2044537488 40258128 22400080
14:49:39 1526 8192000000 10964878288 11384455168 1981146176 19.474 100 83 163 0 2047262400 40516080 25600144
14:49:47 2417 8192000000 10972251648 11387191296 1982489264 19.484 100 90 179 0 2052922000 42071904 28360832
14:49:55 4218 8192000000 10969952448 11385360384 1969686896 19.383 99 85 170 1 2035038704 39848032 25503776
14:50:06 3832 8192000000 10947559520 11375677440 1973292144 19.412 100 63 126 2 2032314016 38489936 20531936
14:50:19 12085 8192000000 10910636464 11358015488 1955669056 19.272 100 33 66 3 2002200928 35905696 10626176
14:50:41 7313 8192000000 10922168064 11355475968 1943313840 19.173 99 32 62 2 1983721488 30478320 9929328
14:50:55 5987 8192000000 10942851744 11367075840 1969949344 19.385 100 66 132 0 2029160224 38389744 20821136
14:51:09 8196 8192000000 10957378944 11384225792 1980707936 19.470 100 73 144 3 2044228368 41010928 22509504
14:51:26 2355 8192000000 10942508816 11365908480 1935757376 19.113 98 68 136 3 1996811728 40210272 20844080
14:51:39 2139 8192000000 10957800432 11380772864 1973407104 19.412 100 74 146 1 2038801360 42348288 23045968
14:51:48 2167 8192000000 10948622368 11373027328 1964260720 19.340 100 65 130 3 2021855344 37275984 20318640
14:52:10 11003 8192000000 10897863680 11349417984 1913459808 18.934 98 25 50 2 1962362640 40547952 8354880
14:52:27 8025 8192000000 10893492784 11326038016 1934697968 19.104 100 41 83 1 1980269248 32729408 12841872
14:52:55 6986 8192000000 10915689808 11350315008 1954058688 19.259 100 49 97 0 2000099856 31375328 14665840
14:53:09 6586 8192000000 10896254672 11334791168 1936520688 19.119 99 52 103 2 1981243984 28723328 15999968
14:53:22 7700 8192000000 10924594624 11349639168 1951389360 19.238 100 47 91 1 1996576352 30769120 14417872
14:53:37 17972 8192000000 10892503472 11334287360 1921344336 18.998 99 26 53 1 1962075680 32370656 8360688
14:54:13 16878 8192000000 10887967024 11329576960 1932741728 19.089 100 22 44 1 1970167744 30333344 7092672
14:54:36 23488 8192000000 10895024640 11340345344 1945011168 19.187 100 22 44 0 1981799264 29328176 7459920
14:55:11 22474 8192000000 10907429504 11351945216 1949710288 19.224 100 24 48 3 1989752384 31689024 8353072
14:55:41 7548 8192000000 10932744000 11367284736 1966579376 19.358 100 45 90 0 2013485808 32495056 14411376
14:56:05 26072 8192000000 10912519968 11362684928 1923803328 19.017 98 24 48 1 1968994128 36820656 8370144
14:56:44 32579 8192000000 10897265760 11353726976 1902980352 18.850 97 29 58 1 1954098544 41622688 9495504
14:57:23 35090 8192000000 10866297408 11318853632 1842090304 18.358 95 19 38 1 1879063024 30594304 6378416
14:58:06 44063 8192000000 10891631552 11339563008 1923913136 19.018 100 27 54 0 1966052896 33594288 8545472
14:59:01 32371 8192000000 10883857552 11340853248 1928546736 19.055 100 19 38 0 1972186000 36939808 6699456
14:59:41 41480 8192000000 10873326496 11336462336 1931044720 19.075 100 8 16 2 1958324384 24278016 3001648
15:00:29 36454 8192000000 10863022144 11330793472 1898059664 18.811 98 13 27 0 1915676176 14011600 3604912
15:01:12 62995 8192000000 10872728368 11318353920 1897361536 18.805 98 22 44 0 1921409728 18013472 6034720
15:02:22 70288 8192000000 10853592576 11314778112 1896005072 18.794 98 7 14 1 1910853872 13386432 1462368
15:03:52 64739 8192000000 10881028912 11337723904 1935247776 19.109 99 18 35 1 1947170416 7500576 4422064
15:05:05 91351 8192000000 10889691616 11343790080 1905266720 18.869 97 14 25 2 1918018864 8982400 3769744
15:06:43 25395 8192000000 10907875408 11361775616 1972659120 19.407 100 22 44 1 1987842112 9155088 6027904
15:07:17 60446 8192000000 10896788320 11364081664 1932954928 19.090 98 15 30 1 1950385520 13302896 4127696
15:08:25 76278 8192000000 10899211664 11366490112 1928072832 19.051 98 12 24 1 1945738672 14294896 3370944
15:09:53 72433 8192000000 10917589328 11379073024 1972903744 19.408 100 10 20 0 1989934608 13651504 3379360
15:11:18 27041 8192000000 10906421872 11366879232 1966379536 19.357 99 46 89 3 1985480112 6330832 12769744
15:12:00 31225 8192000000 10937880624 11373207552 1985609952 19.509 100 57 110 2 2012246720 11322080 15314688
15:12:38 33864 8192000000 10909414176 11381035008 1967846720 19.368 99 28 55 0 1987583664 11973680 7763264
15:13:21 72635 8192000000 10912455792 11380215808 1986111808 19.513 100 19 38 0 1999661648 8035424 5514416
15:14:42 4417 8192000000 10925349168 11387351040 1992007360 19.560 100 31 62 2 2013357072 12778544 8571168
15:14:53 2236 8192000000 10965155376 11397144576 2004721264 19.660 100 64 131 1 2035472128 11077824 19673040
15:15:01 6673 8192000000 10955755744 11404103680 2006420272 19.673 100 50 100 0 2033932880 13414912 14097696
15:15:18 21860 8192000000 10938070368 11400024064 1986147488 19.513 99 42 83 5 2014341136 16371936 11821712
15:15:47 11934 8192000000 10941527296 11395248128 1985138816 19.505 99 41 82 0 2010700640 12662432 12899392
15:16:09 14636 8192000000 10936044640 11389083648 1979539920 19.461 99 48 96 0 2005217856 11968112 13709824
15:16:35 37726 8192000000 10918621296 11370414080 1954627472 19.263 98 45 90 1 1983227680 15277008 13323200
15:17:30 23829 8192000000 10935917520 11388768256 1956910608 19.281 98 50 99 2 1989690944 17556304 15224032
15:18:04 36719 8192000000 10934799440 11400962048 1992237136 19.561 100 24 46 4 2016955440 17495664 7222640
15:18:50 63582 8192000000 10930029408 11405549568 1996104160 19.592 100 15 30 1 2018962864 17967760 4890944
15:20:12 71181 8192000000 10932798688 11400671232 1988854720 19.535 99 16 32 0 2015755072 20871408 6028944
15:21:30 33972 8192000000 10925359952 11391426560 1975943072 19.433 99 20 41 0 2006540992 23515952 7081968
15:22:12 41010 8192000000 10929439760 11398295552 1948751616 19.217 98 28 52 1 1983238016 25742784 8743616
15:23:08 37823 8192000000 10894705456 11378860032 1964340208 19.341 100 21 42 2 2000775488 29565664 6869616
15:23:52 80146 8192000000 10874480032 11345911808 1870566432 18.589 95 11 20 0 1887250912 13451264 3233216
15:25:18 30039 8192000000 10902927760 11345506304 1948262496 19.213 99 44 87 4 1966167632 7061264 10843872
15:25:59 28681 8192000000 10890498720 11348795392 1909736640 18.905 97 27 54 1 1925933152 8640816 7555696
15:26:35 23119 8192000000 10904640688 11364155392 1968848672 19.376 100 51 101 4 1992053360 9354928 13849760
15:27:09 79934 8192000000 10860699296 11327238144 1844583616 18.378 94 13 27 1 1859262880 11377104 3302160
15:28:40 62963 8192000000 10865301920 11336720384 1881560144 18.678 97 16 33 0 1896545040 10101232 4883664
15:29:52 39749 8192000000 10876589568 11340369920 1922619264 19.008 99 10 20 1 1938077424 12265664 3192496
15:30:38 42048 8192000000 10880190896 11343011840 1896635136 18.799 97 24 48 2 1916153520 12769440 6748944
15:31:28 100190 8192000000 10903317232 11348881408 1877953312 18.649 96 17 34 2 1898460272 16512672 3994288
15:33:15 57204 8192000000 10898801952 11357454336 1946155024 19.196 99 21 42 0 1967263968 15874288 5234656
15:34:19 47384 8192000000 10886635824 11355054080 1871758864 18.599 95 23 46 0 1894643104 16525504 6358736
15:35:12 109607 8192000000 10861947344 11335098368 1893097008 18.771 97 13 26 0 1916876992 19990880 3789104
15:37:19 101362 8192000000 10855177024 11324870656 1845713792 18.387 95 22 43 1 1867771616 15790656 6267168
15:39:06 11550 8192000000 10858673328 11327246336 1923064288 19.011 100 10 19 1 1941903392 16159456 2679648
15:39:24 43696 8192000000 10879746032 11345084416 1934727568 19.105 100 25 47 3 1953315744 10536176 8052000
15:40:18 80424 8192000000 10852840320 11331506176 1871915280 18.600 96 7 14 0 1888858528 15206560 1736688
15:41:45 30864 8192000000 10866961952 11327049728 1900575136 18.831 98 18 36 0 1920244592 13748064 5921392
15:42:36 70466 8192000000 10865533504 11344015360 1914927904 18.946 99 18 36 2 1933094240 13241936 4924400
15:43:57 46558 8192000000 10836152976 11309256704 1872785776 18.607 97 9 18 0 1887404176 12242448 2375952
15:44:50 67606 8192000000 10830116128 11303165952 1880287600 18.667 98 22 44 0 1896779872 10149968 6342304
15:46:18 45911 8192000000 10858809376 11312345088 1890882400 18.753 98 29 57 1 1905047072 6259984 7904688
15:47:10 19171 8192000000 10871235408 11322310656 1933721824 19.097 100 46 92 0 1956081184 9749152 12610208
15:47:35 38097 8192000000 10884393568 11335286784 1936325424 19.117 100 31 61 3 1952636800 7423744 8887632
15:48:56 57910 8192000000 10853654912 11318857728 1909088800 18.899 99 19 39 1 1928643824 14026576 5528448
15:50:01 30024 8192000000 10842532656 11320934400 1907051056 18.883 99 12 24 0 1924053472 13602000 3400416
15:50:40 51070 8192000000 10858943424 11344363520 1929506192 19.063 100 8 16 0 1949731104 17859296 2365616
15:51:37 48538 8192000000 10867512768 11335987200 1926295392 19.037 99 13 26 0 1938551120 8038480 4217248
15:52:35 38366 8192000000 10862745088 11330375680 1903401120 18.854 98 15 30 0 1914982496 7296832 4284544
15:53:21 24218 8192000000 10879814016 11335704576 1926481024 19.039 99 40 80 1 1947818336 10245968 11091344
15:53:51 38465 8192000000 10868897616 11327766528 1888780192 18.736 97 22 44 0 1909371984 14412128 6179664
15:54:40 34077 8192000000 10870416384 11333718016 1915900656 18.954 99 31 62 0 1941321504 16387808 9033040
15:55:21 57827 8192000000 10879056048 11349131264 1939690352 19.144 100 28 56 1 1971579168 23337632 8551184
15:56:26 98637 8192000000 10889618464 11367100416 1934404816 19.102 99 18 36 2 1951004576 11810832 4788928
15:58:11 30364 8192000000 10907569936 11368620032 1971506160 19.397 100 23 46 2 1989879520 11552864 6820496
15:58:48 23602 8192000000 10953675152 11389775872 1983434064 19.492 100 50 101 0 2014314864 15466848 15413952
15:59:19 24373 8192000000 10928583280 11389214720 1979945248 19.464 100 34 68 1 2006134464 16931792 9257424
16:00:05 33258 8192000000 10927374144 11394863104 1982854144 19.487 100 32 65 1 2012553968 20374512 9325312
16:00:50 38034 8192000000 10932609952 11407011840 1980341040 19.467 100 11 22 0 2009644432 25509168 3794224
16:02:29 111183 8192000000 10898289856 11389231104 1909221872 18.900 96 10 20 0 1934720032 23162752 2335408
16:04:26 97728 8192000000 10911743744 11371732992 1959684352 19.304 99 30 58 2 1975747168 7851472 8211344
16:06:19 74529 8192000000 10882230288 11364777984 1904050592 18.859 96 24 48 2 1920115696 9504672 6560432
16:07:41 35323 8192000000 10887244048 11374391296 1950013184 19.227 99 4 8 0 1959826912 8878720 935008
16:08:23 52543 8192000000 10893526608 11356303360 1905767184 18.873 97 13 26 2 1917349312 7241344 4340784
16:09:37 30800 8192000000 10926283120 11375661056 1970137424 19.387 100 37 72 3 1989429328 9822656 9469248
16:10:22 45745 8192000000 10907972352 11373686784 1922109360 19.004 97 25 50 1 1939464480 10456736 6898384
16:11:21 36498 8192000000 10888520304 11366817792 1930551200 19.071 98 19 38 0 1949143792 13395184 5197408
16:12:06 46976 8192000000 10914810960 11379331072 1934923632 19.106 98 19 38 0 1955594832 15339808 5331392
16:12:59 60319 8192000000 10902970352 11363590144 1882885504 18.688 95 20 40 1 1908078112 19497200 5695408
16:14:19 56062 8192000000 10900652352 11374084096 1946896224 19.202 99 23 46 3 1980023712 26118816 7008672
16:15:21 155149 8192000000 10876399488 11349217280 1810744800 18.102 93 10 20 0 1834857760 21361920 2751040
16:18:07 46474 8192000000 10886977120 11352363008 1903358656 18.853 98 10 20 0 1921217136 14692352 3166128
16:19:01 112483 8192000000 10888088560 11347066880 1800735760 18.020 92 17 34 1 1821050896 16564400 3750736
16:21:01 103590 8192000000 10864534496 11327963136 1853519552 18.451 95 21 40 1 1876601968 17076432 6005984
16:23:00 96174 8192000000 10882837248 11343007744 1939602816 19.144 99 37 74 0 1962140624 11963504 10574304
16:24:42 65821 8192000000 10869796560 11342061568 1891161632 18.755 97 25 50 1 1911304128 12866176 7276320
16:26:35 27174 8192000000 10853552752 11331821568 1922141424 19.004 99 18 36 1 1942081888 14153664 5786800
16:27:09 52221 8192000000 10838882608 11302932480 1837787344 18.323 95 11 22 0 1849081920 8331840 2962736
16:28:07 57812 8192000000 10830277760 11306446848 1906969856 18.882 99 7 14 0 1916005264 7018160 2017248
16:29:11 51133 8192000000 10852302688 11329814528 1917088240 18.964 99 14 28 1 1928470208 7592144 3789824
16:30:12 100796 8192000000 10843027168 11314479104 1803163984 18.040 93 15 30 2 1815843824 8538176 4141664
16:31:58 42169 8192000000 10109068384 10508021760 1231100896 13.064 64 5 10 0 1240730096 8109856 1519344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 18-11-2020 16:35:16 to 18-11-2020 16:35:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-11-2020 16:35:50 to 18-11-2020 16:35:52.

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          252188
MON$OLDEST_ACTIVE               252189
MON$OLDEST_SNAPSHOT             252189
MON$NEXT_TRANSACTION            252189
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                       2058848
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.33391 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33391 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33391 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33391 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Wed Nov 18 16:33:03 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

18.11.20 16:35:53. 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-11-18 16:35:55 No severe PSQL-related problems occured
18.11.20 16:35:56. End of report.