Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.02.2021 01:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17007912 kB
MemAvailable 31161924 kB
Buffers 0 kB
Cached 14713196 kB
SwapCached 3904 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-20 01:27:17
DTS_END                         2021-02-20 01:27:17.1350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46844
TRN_ID                          244441
ATT_ID                          730
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: 9443.81 21308 1133257
customer order: creation 175.49 390 21059
customer order: refuse 14.72 345 1766
order to supplier: creation 46.11 1355 5533
order to supplier: removal 3.78 96813 453
invoice (draft): creation 45.63 3675 5475
invoice (draft): removal 55.72 852 6686
invoice accept: apply 41.81 16098 5017
invoice accept: cancel 49.89 737 5987
customer reserve: creation 3856.86 157 462823
customer reserve: removal 4845.17 58 581420
realization accept: apply 85.33 206 10240
realization accept: cancel 92.60 103 11112
payment from customer: creation 59.86 132 7183
payment from customer: removal 5.88 81 705
payment to supplier: creation 49.41 150 5929
payment to supplier: removal 3.28 78 393
service: total inventory turnovers 4.84 1088 581
service: total monetary turnovers 6.64 35 797
service: aggregate perf. data 0.78 19177 94
service: refresh index statistics 0.03 284633 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5973
TEST_TIME 2 4385
TEST_TIME 3 3630
TEST_TIME 4 4043
TEST_TIME 5 4965
TEST_TIME 6 4755
TEST_TIME 7 4742
TEST_TIME 8 4906
TEST_TIME 9 5015
TEST_TIME 10 5331
TEST_TIME 11 5884
TEST_TIME 12 5854
TEST_TIME 13 6035
TEST_TIME 14 6079
TEST_TIME 15 6135
TEST_TIME 16 6670
TEST_TIME 17 7176
TEST_TIME 18 7472
TEST_TIME 19 7788
TEST_TIME 20 7832
TEST_TIME 21 8602
TEST_TIME 22 8931
TEST_TIME 23 8913
TEST_TIME 24 8966
TEST_TIME 25 8973
TEST_TIME 26 9368
TEST_TIME 27 10428
TEST_TIME 28 10788
TEST_TIME 29 11116
TEST_TIME 30 11015
TEST_TIME 31 10858
TEST_TIME 32 10757
TEST_TIME 33 10532
TEST_TIME 34 10766
TEST_TIME 35 10625
TEST_TIME 36 10410
TEST_TIME 37 10300
TEST_TIME 38 10212
TEST_TIME 39 10045
TEST_TIME 40 10227
TEST_TIME 41 10170
TEST_TIME 42 10135
TEST_TIME 43 10161
TEST_TIME 44 10177
TEST_TIME 45 10079
TEST_TIME 46 10011
TEST_TIME 47 9898
TEST_TIME 48 9907
TEST_TIME 49 9848
TEST_TIME 50 9849
TEST_TIME 51 9849
TEST_TIME 52 9810
TEST_TIME 53 9727
TEST_TIME 54 9624
TEST_TIME 55 9516
TEST_TIME 56 9611
TEST_TIME 57 9565
TEST_TIME 58 9641
TEST_TIME 59 9677
TEST_TIME 60 9600
TEST_TIME 61 9690
TEST_TIME 62 9771
TEST_TIME 63 9762
TEST_TIME 64 9806
TEST_TIME 65 9770
TEST_TIME 66 9858
TEST_TIME 67 9897
TEST_TIME 68 9898
TEST_TIME 69 9969
TEST_TIME 70 9955
TEST_TIME 71 9936
TEST_TIME 72 9813
TEST_TIME 73 9782
TEST_TIME 74 9775
TEST_TIME 75 9779
TEST_TIME 76 9710
TEST_TIME 77 9646
TEST_TIME 78 9599
TEST_TIME 79 9588
TEST_TIME 80 9536
TEST_TIME 81 9523
TEST_TIME 82 9476
TEST_TIME 83 9521
TEST_TIME 84 9584
TEST_TIME 85 9609
TEST_TIME 86 9677
TEST_TIME 87 9646
TEST_TIME 88 9631
TEST_TIME 89 9661
TEST_TIME 90 9627
TEST_TIME 91 9759
TEST_TIME 92 9722
TEST_TIME 93 9787
TEST_TIME 94 9765
TEST_TIME 95 9703
TEST_TIME 96 9675
TEST_TIME 97 9619
TEST_TIME 98 9623
TEST_TIME 99 9589
TEST_TIME 100 9594
TEST_TIME 101 9588
TEST_TIME 102 9544
TEST_TIME 103 9574
TEST_TIME 104 9570
TEST_TIME 105 9608
TEST_TIME 106 9588
TEST_TIME 107 9612
TEST_TIME 108 9561
TEST_TIME 109 9626
TEST_TIME 110 9626
TEST_TIME 111 9654
TEST_TIME 112 9673
TEST_TIME 113 9615
TEST_TIME 114 9550
TEST_TIME 115 9583
TEST_TIME 116 9546
TEST_TIME 117 9565
TEST_TIME 118 9514
TEST_TIME 119 9487
TEST_TIME 120 9446

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1561667 1561667 0 0.00 0 21715 6 0 0
doc_list_biud 1561666 1561666 0 0.00 0 58375 28 0 0
sp_add_invoice_to_stock 5143 5017 126 2.44 38 222959 16099 0 126
sp_cancel_adding_invoice 5987 5987 0 0.00 4 37626 737 0 0
sp_cancel_client_order 1766 1766 0 0.00 4 13485 346 0 0
sp_cancel_customer_reserve 581420 581420 0 0.00 1 58376 58 0 0
sp_cancel_pay_from_customer 705 705 0 0.00 2 6321 81 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 3 3901 79 0 0
sp_cancel_supplier_invoice 6696 6686 10 0.14 2 31115 853 0 10
sp_cancel_supplier_order 453 453 0 0.00 7 1072165 96814 0 0
sp_cancel_write_off 11112 11112 0 0.00 1 13970 103 0 0
sp_client_order 21059 21059 0 0.00 3 45221 390 0 0
sp_customer_reserve 462823 462823 0 0.00 0 45568 158 0 0
sp_fill_shopping_cart 32057 32057 0 0.00 1 19674 39 0 0
sp_fill_shopping_cart_clo_res 462821 462821 0 0.00 0 17029 14 0 0
sp_get_clo_for_invoice 5014 5014 0 0.00 0 29378 336 0 0
sp_kill_cost_storno 18197 18197 0 0.00 0 19277 56 0 0
sp_kill_qstorno_ret_qs2qd 1181091 1181091 0 0.00 0 58371 32 0 0
sp_kill_qty_storno 622677 622677 0 0.00 0 58374 69 0 0
sp_lock_selected_doc 21134 21134 0 0.00 0 8050 6 0 0
sp_make_cost_storno 28366 28366 0 0.00 0 21707 58 0 0
sp_multiply_rows_for_pdistr 28365 28365 0 0.00 0 15119 32 0 0
sp_multiply_rows_for_qdistr 21059 21059 0 0.00 0 40336 177 0 0
sp_pay_from_customer 7183 7183 0 0.00 4 17637 133 0 0
sp_pay_to_supplier 5929 5929 0 0.00 5 17240 150 0 0
sp_payment_common 13112 13112 0 0.00 2 14529 42 0 0
sp_qd_handle_on_cancel_clo 1766 1766 0 0.00 0 12051 312 0 0
sp_qd_handle_on_invoice_upd_sts 11001 11001 0 0.00 0 24276 330 0 0
sp_qd_handle_on_reserve_upd_sts 10239 10239 0 0.00 0 16099 57 0 0
sp_reserve_write_off 10240 10240 0 0.00 6 16115 207 0 0
sp_supplier_invoice 5475 5475 0 0.00 7 100835 3676 0 0
sp_supplier_order 5533 5533 0 0.00 5 90666 1355 0 0
srv_aggregate_perf_data 94 94 0 0.00 2806 275356 19178 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 797 126053 33712 0 0
srv_find_qd_qs_mism 1085072 1085072 0 0.00 0 8101 5 0 0
srv_make_invnt_saldo 581 581 0 0.00 15 46411 1089 0 0
srv_make_money_saldo 797 797 0 0.00 0 5374 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 144821 357510 284634 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5017 5017 0 0.00 0 15701 170 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 15622 112 0 0
t$perf-norm:sp_cancel_client_order 1766 1766 0 0.00 0 11558 26 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 4462 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 705 705 0 0.00 0 3200 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 4862 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 432 432 0 0.00 0 3049 27 0 0
t$perf-norm:sp_cancel_supplier_order 453 453 0 0.00 0 21797 1616 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 5622 16 0 0
t$perf-norm:sp_client_order 21059 21059 0 0.00 0 22476 20 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 3146 12 0 0
t$perf-norm:sp_pay_from_customer 7183 7183 0 0.00 0 33330 18 0 0
t$perf-norm:sp_pay_to_supplier 5929 5929 0 0.00 0 12497 15 0 0
t$perf-norm:sp_reserve_write_off 10240 10240 0 0.00 0 10540 17 0 0
t$perf-norm:sp_supplier_invoice 5475 5475 0 0.00 0 5424 25 0 0
t$perf-norm:sp_supplier_order 5533 5533 0 0.00 0 9490 19 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 364 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 2634 21 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 2274 23 0 0
t$perf-norm:srv_make_money_saldo 797 797 0 0.00 0 1392 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10280 10028 252 2.45 0 13260 24 0 252
v_all_customers 38104 38104 0 0.00 0 19 1 0 0
v_all_suppliers 30926 30926 0 0.00 0 24 1 0 0
v_all_wares 42118 42118 0 0.00 0 135 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 2459 11 0 0
v_cancel_client_order 3532 3532 0 0.00 0 13322 8 0 0
v_cancel_customer_prepayment 1410 1410 0 0.00 0 4933 7 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 17334 20 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 3888 10 0 0
v_cancel_supplier_invoice 884 864 20 2.26 0 6431 25 0 20
v_cancel_supplier_order 906 906 0 0.00 0 1990 9 0 0
v_cancel_write_off 2040 2040 0 0.00 0 3978 18 0 0
v_max_id_clo_ord 5533 5533 0 0.00 0 2293 2 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 5311 21 0 0
v_max_id_ord_sup 5465 5465 0 0.00 0 2742 3 0 0
v_max_non_paid_invoice 1464 1464 0 0.00 0 7830 14 0 0
v_max_non_paid_realizn 3884 3884 0 0.00 0 3587 8 0 0
v_min_id_clo_ord 5533 5533 0 0.00 0 6237 13 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 2777 8 0 0
v_min_id_ord_sup 5465 5465 0 0.00 0 5349 9 0 0
v_min_non_paid_invoice 5929 5929 0 0.00 0 14453 33 0 0
v_min_non_paid_realizn 7183 7183 0 0.00 0 8373 26 0 0
v_our_firm 10612 10612 0 0.00 0 71 1 0 0
v_reserve_write_off 20478 20478 0 0.00 0 13322 8 0 0
x_lock_depdocs_on_canc_invoice 12241 12241 0 0.00 0 28213 103 0 0
x_lock_depdocs_on_canc_sup_ord 453 453 0 0.00 0 23777 370 0 0
x_make_qstorno_1000_1200 5533 5533 0 0.00 1 90650 1272 0 0
x_make_qstorno_1200_2000 5475 5475 0 0.00 3 100826 3542 0 0
x_make_qstorno_2100_3300 462823 462823 0 0.00 0 45567 141 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:20 16 8192000000 8811679072 8825573376 15987824 0.194 3 3 6 0 16256448 80704 187920
22:57:28 20376 8192000000 10230363040 10536378368 948485920 10.376 75 60 120 1 972083664 2866224 20731520
22:57:58 17945 8192000000 10300562624 10612158464 1355834848 14.200 100 85 170 0 1388891104 4726528 28329728
22:58:26 38656 8192000000 10358564016 10679214080 1403929008 14.630 100 88 176 2 1438975520 5604112 29442400
22:59:12 19766 8192000000 10385554976 10708840448 1435664736 14.911 100 90 179 0 1472048784 6581168 29802880
22:59:45 22237 8192000000 10417959920 10746986496 1469698224 15.211 100 85 170 0 1504432816 7345664 27388928
23:00:22 19550 8192000000 10441859840 10775363584 1498726400 15.465 100 90 180 0 1536555104 8443024 29385680
23:00:51 19388 8192000000 10455911456 10791751680 1512818336 15.588 100 88 176 0 1549470496 8730720 27921440
23:01:19 23014 8192000000 10479486720 10827005952 1542608320 15.846 100 75 150 1 1574479456 8794592 23076544
23:01:52 16127 8192000000 10512171856 10864087040 1578972256 16.159 100 76 152 2 1612620144 9796800 23851088
23:02:19 15780 8192000000 10545226720 10901204992 1606223168 16.393 100 79 158 1 1640843856 10078656 24542032
23:02:43 10865 8192000000 10568759584 10928537600 1628414224 16.581 100 71 142 1 1659511776 10178000 20919552
23:03:05 11183 8192000000 10599112512 10960375808 1657632448 16.829 100 83 167 0 1693586912 10859456 25095008
23:03:25 10057 8192000000 10611314976 10979328000 1673634896 16.964 100 77 154 2 1708175040 11915584 22624560
23:03:44 7810 8192000000 10626283504 10996334592 1690946576 17.109 100 75 149 2 1724571696 11507440 22117680
23:04:00 11040 8192000000 10642632736 11012530176 1705770064 17.233 100 80 158 3 1741188288 12150560 23267664
23:04:19 9161 8192000000 10659520960 11032985600 1718722304 17.342 100 72 143 0 1750468128 11733664 20012160
23:04:37 7389 8192000000 10674008144 11049660416 1739120992 17.511 100 82 164 0 1775735216 13038336 23575888
23:04:51 5368 8192000000 10679389728 11061424128 1748498096 17.589 100 81 162 1 1784214896 13025344 22691456
23:05:03 6076 8192000000 10693003952 11071492096 1756420928 17.655 100 77 154 1 1794548160 16582384 21544848
23:05:15 4291 8192000000 10708743712 11084660736 1767386192 17.745 100 84 168 1 1805901936 14288192 24227552
23:05:26 4414 8192000000 10719593376 11096698880 1773721440 17.798 100 87 173 3 1812895904 14820432 24354032
23:05:37 5554 8192000000 10714474048 11099418624 1775925696 17.816 100 75 149 0 1810491584 14243632 20322256
23:05:51 3910 8192000000 10718266784 11104485376 1777011072 17.825 100 78 156 0 1812589888 14105664 21473152
23:06:01 3573 8192000000 10726822992 11115458560 1797255744 17.991 100 86 171 4 1835271216 13494960 24520512
23:06:12 4060 8192000000 10740871168 11126218752 1806932112 18.071 100 84 167 0 1843874304 13350000 23592192
23:06:24 3299 8192000000 10756056592 11137499136 1813806096 18.127 100 93 186 3 1854870512 14886640 26177776
23:06:34 2928 8192000000 10761536464 11143938048 1820843824 18.185 100 85 171 1 1858817104 14292256 23681024
23:06:44 1556 8192000000 10764968912 11148828672 1822591728 18.199 100 88 176 0 1861574864 14031664 24951472
23:06:53 2148 8192000000 10768112384 11155894272 1828889856 18.250 100 87 176 1 1867275152 13755472 24629824
23:07:03 2434 8192000000 10768645440 11154341888 1833178880 18.285 100 86 172 2 1871446528 13597744 24669904
23:07:12 2463 8192000000 10787285840 11171401728 1843258032 18.367 100 93 188 5 1883529520 13415520 26855968
23:07:21 1742 8192000000 10780589456 11170070528 1845359760 18.384 100 92 182 1 1883082512 11967056 25755696
23:07:29 2042 8192000000 10790645104 11175464960 1848463520 18.410 100 88 176 3 1891103728 17173552 25466656
23:07:37 2159 8192000000 10789395712 11182874624 1852898000 18.446 100 89 176 1 1891206912 13307360 25001552
23:07:46 2174 8192000000 10798512592 11184455680 1856959104 18.479 100 90 180 2 1894787488 12145920 25682464
23:07:55 1621 8192000000 10803863904 11193683968 1860778432 18.510 100 88 173 1 1901850640 16557136 24515072
23:08:04 2041 8192000000 10813544320 11201290240 1864104464 18.537 100 95 190 3 1902959824 11988848 26866512
23:08:12 2095 8192000000 10809035168 11198611456 1870570816 18.589 100 96 193 1 1912169296 14002064 27596416
23:08:20 3319 8192000000 10791465280 11202060288 1867486496 18.564 100 81 162 0 1903864400 13645648 22732256
23:08:31 36076 8192000000 10808830944 11199139840 1863374336 18.531 100 62 125 1 1890402048 8611248 18416464
23:09:14 2976 8192000000 10795634544 11200548864 1870649424 18.590 100 82 165 1 1904250736 9867808 23733504
23:09:34 4636 8192000000 10787386144 11207110656 1864513360 18.540 100 38 76 0 1883697504 8939648 10244496
23:09:48 5427 8192000000 10788283552 11208163328 1873805584 18.615 100 41 82 3 1894005024 8931376 11268064
23:10:02 5798 8192000000 10797639872 11209166848 1872059984 18.601 100 36 73 2 1889353600 6864240 10429376
23:10:14 5586 8192000000 10783804912 11207806976 1871556256 18.597 100 31 62 1 1887774736 7617904 8600576
23:10:33 5186 8192000000 10790407024 11212951552 1874684320 18.622 100 37 74 1 1893413152 7674864 11053968
23:10:44 5642 8192000000 10777988144 11210338304 1876041600 18.633 100 20 40 1 1887755360 5168320 6545440
23:10:56 5053 8192000000 10788455216 11217108992 1879219488 18.659 100 31 61 2 1894580528 6753296 8607744
23:11:07 14004 8192000000 10783274864 11215523840 1878553312 18.653 100 18 36 2 1889218416 5577536 5087568
23:11:28 15455 8192000000 10788523392 11220492288 1880156832 18.666 100 18 35 3 1891993040 6533024 5303184
23:11:51 14077 8192000000 10793868640 11228385280 1883278848 18.692 100 21 41 2 1899374032 10315472 5779712
23:12:11 8834 8192000000 10792559664 11227189248 1885502128 18.710 100 17 34 0 1896934256 6909584 4522544
23:12:26 5505 8192000000 10789033280 11227279360 1888319456 18.732 100 17 33 2 1898847296 5875632 4652208
23:12:40 10847 8192000000 10792890000 11229057024 1887777904 18.728 100 8 16 1 1895801872 6092064 1931904
23:13:01 11037 8192000000 10800729632 11235688448 1893496688 18.774 100 24 46 1 1906233824 6196736 6540400
23:13:21 74904 8192000000 10830202768 11253583872 1899841264 18.825 100 35 70 1 1916334240 6024240 10468736
23:14:44 6901 8192000000 10819058384 11255955456 1899860640 18.825 100 21 42 0 1915964192 10393600 5709952
23:15:00 6834 8192000000 10824676816 11257708544 1907090064 18.883 100 25 50 1 1921131040 6245472 7795504
23:15:14 7706 8192000000 10817722208 11255332864 1905204864 18.868 100 26 53 2 1920311904 7908256 7198784
23:15:28 8048 8192000000 10822911376 11261173760 1904871424 18.865 100 19 38 0 1919921520 9859776 5190320
23:15:44 5598 8192000000 10823329056 11262382080 1909079008 18.899 100 26 52 0 1922970096 6572240 7318848
23:15:57 7071 8192000000 10830721984 11259179008 1903543008 18.855 100 24 48 1 1917058688 6353488 7162192
23:16:15 7788 8192000000 10818197216 11249061888 1887788256 18.728 99 30 58 0 1905545744 10165328 7592160
23:16:30 8161 8192000000 10813066480 11252473856 1902056192 18.843 100 18 36 0 1913814512 6812896 4945424
23:16:46 5946 8192000000 10808834064 11241922560 1863331872 18.530 98 32 63 2 1879697200 7573488 8791840
23:16:59 5071 8192000000 10813379792 11248193536 1892287040 18.764 100 26 53 1 1909993792 10501504 7205248
23:17:15 8117 8192000000 10808129696 11245117440 1897019488 18.802 100 18 36 1 1908447376 5988272 5439616
23:17:29 10039 8192000000 10795745088 11232083968 1873132352 18.610 99 18 36 1 1884466128 5753904 5579872
23:17:48 8760 8192000000 10782280736 11219095552 1867951264 18.568 100 17 35 0 1882681456 10455104 4275088
23:18:03 9364 8192000000 10721657232 11124719616 1765981136 17.734 96 27 54 0 1778826080 5594288 7250656
23:18:22 63115 8192000000 10757789840 11151609856 1693045328 17.127 91 58 118 3 1716060368 5334800 17680240
23:19:31 7486 8192000000 10737420784 11155755008 1789098240 17.924 98 23 46 0 1802502256 7035968 6368048
23:19:45 8805 8192000000 10708901840 11120955392 1757496480 17.664 97 35 70 2 1774141520 6479424 10165616
23:20:03 6243 8192000000 10712607632 11129876480 1742533824 17.540 96 23 46 1 1755192992 5477808 7181360
23:20:15 5235 8192000000 10719149504 11131514880 1787090624 17.908 99 36 72 1 1808960160 11917888 9951648
23:20:28 4573 8192000000 10710064432 11122810880 1766582864 17.739 98 26 50 1 1779543904 5958336 7002704
23:20:43 5790 8192000000 10675494656 11089780736 1714399808 17.305 96 26 53 0 1727434944 5549088 7486048
23:20:56 10901 8192000000 10680750928 11105513472 1765921408 17.733 99 38 76 5 1783987104 6382736 11682960
23:21:16 6817 8192000000 10688868928 11104604160 1761845728 17.700 98 24 48 1 1775128832 5643680 7639424
23:21:29 6717 8192000000 10720267328 11123679232 1777814944 17.831 99 29 58 0 1791888112 5232848 8840320
23:21:42 11631 8192000000 10720393216 11136778240 1786108528 17.900 99 27 53 0 1799756368 5337168 8310672
23:22:02 6822 8192000000 10734608064 11147546624 1794716576 17.971 99 33 64 2 1809932928 5307904 9908448
23:22:15 7390 8192000000 10735083776 11155677184 1803542144 18.043 99 21 41 1 1815342096 5688160 6111792
23:22:31 7929 8192000000 10742941840 11166679040 1825072784 18.219 100 12 22 1 1833525600 5286608 3166208
23:22:45 24438 8192000000 10763121664 11185852416 1837239744 18.318 100 25 50 2 1854177904 9503792 7434368
23:23:20 64400 8192000000 10767371568 11190153216 1832512016 18.280 99 25 49 2 1845611072 5054032 8045024
23:24:30 11548 8192000000 10756812016 11189862400 1852545904 18.443 100 19 36 2 1863863792 5035712 6282176
23:24:51 6914 8192000000 10781724320 11202269184 1863206672 18.529 100 37 74 2 1880771312 6653344 10911296
23:25:04 6514 8192000000 10768415424 11201839104 1860491488 18.507 100 21 42 0 1872410416 6273264 5645664
23:25:17 8441 8192000000 10786476224 11210215424 1868820208 18.575 100 30 59 4 1883613936 6469024 8324704
23:25:34 9771 8192000000 10789588896 11215351808 1871140912 18.594 100 22 44 0 1883396192 5750720 6504560
23:25:51 9357 8192000000 10782773936 11215441920 1871479216 18.596 100 23 47 0 1884296960 5203216 7614528
23:26:08 8340 8192000000 10782367104 11216146432 1871725232 18.598 100 25 50 1 1884372624 5837504 6809888
23:26:23 14442 8192000000 10777994528 11215937536 1876318512 18.635 100 21 42 2 1888526880 6210608 5997760
23:26:43 18049 8192000000 10782961840 11221839872 1876837632 18.640 100 15 30 2 1890630912 9399792 4393488
23:27:09 17339 8192000000 10828349712 11255902208 1900514224 18.830 100 21 42 0 1916332512 10358240 5460048
23:27:35 17101 8192000000 10856454880 11274637312 1918977328 18.979 100 46 92 2 1941553104 10246176 12329600
23:28:00 40033 8192000000 10862780848 11281412096 1933036592 19.091 100 60 118 1 1958596272 8366992 17192688
23:28:50 59498 8192000000 10856505152 11294179328 1937745056 19.129 100 32 65 0 1953803184 6422832 9635296
23:30:35 94826 8192000000 10893023440 11330564096 1950173216 19.228 100 30 60 0 1969623104 10784832 8665056
23:32:26 23200 8192000000 10894697184 11335606272 1962886768 19.329 100 46 93 1 1988721104 13172800 12661536
23:33:05 8327 8192000000 10904842016 11345924096 1974545056 19.421 100 46 89 0 1999346736 11840064 12961616
23:33:22 13835 8192000000 10917312736 11353636864 1978068624 19.449 100 44 86 0 2005582368 14908048 12605696
23:33:44 10797 8192000000 10924261600 11358777344 1987090912 19.521 100 44 88 3 2015614592 15985424 12538256
23:34:11 12631 8192000000 10924076576 11362566144 1987399696 19.523 100 44 88 2 2017114544 16560800 13154048
23:34:31 12033 8192000000 10939431424 11370524672 1992182224 19.561 100 55 110 0 2025884944 17302752 16399968
23:34:51 7440 8192000000 10925977968 11355680768 1977076688 19.442 99 54 108 3 2011541792 18687856 15777248
23:35:06 15722 8192000000 10943071904 11375534080 1992841680 19.566 100 50 100 1 2028147408 19512128 15793600
23:35:37 13422 8192000000 10938668624 11378307072 1995353488 19.586 100 56 111 0 2032962688 20611168 16998032
23:36:01 19708 8192000000 10942026112 11386765312 1999877360 19.622 100 50 99 0 2036867584 21600304 15389920
23:36:31 17735 8192000000 10959132016 11400941568 2010706176 19.707 100 41 81 2 2047274048 23427232 13140640
23:36:58 3554 8192000000 10974722544 11405463552 2017407600 19.760 100 69 138 4 2063653344 25917424 20328320
23:37:12 8526 8192000000 10974660688 11410292736 2018276480 19.767 100 62 124 0 2064493264 27438928 18777856
23:37:31 17163 8192000000 10974653296 11415986176 2019811360 19.779 100 47 94 0 2062716992 27945808 14959824
23:37:55 14534 8192000000 10968729600 11420258304 2027673904 19.840 100 57 114 1 2071671184 25899856 18097424
23:38:18 11362 8192000000 10981294400 11427180544 2027959920 19.843 100 49 98 2 2069123984 25321760 15842304
23:38:39 10688 8192000000 10987299232 11428347904 2035260400 19.900 100 66 132 0 2082858704 27579328 20018976
23:38:57 6550 8192000000 10995701328 11426885632 2031057104 19.867 100 78 156 1 2079476272 25343168 23076000
23:39:14 6620 8192000000 10964363104 11395227648 1997813776 19.605 99 72 144 0 2046131280 26928976 21388528
23:39:31 4117 8192000000 10964763520 11385184256 1995405024 19.586 99 77 152 2 2044958592 27696896 21856672
23:39:43 2247 8192000000 10986708800 11409022976 2012241136 19.719 100 75 150 2 2062584336 28286640 22056560
23:39:53 11009 8192000000 10981727376 11410268160 2015134368 19.742 100 66 132 2 2062600752 27766832 19699552
23:40:14 5850 8192000000 10978509168 11402018816 2015003248 19.741 100 84 166 3 2066947584 26785280 25159056
23:40:27 6659 8192000000 10979827152 11405926400 2016361136 19.752 100 63 124 2 2063790784 27494336 19935312
23:40:40 2335 8192000000 10983628448 11416121344 2016666672 19.754 100 59 118 0 2063109952 28258816 18184464
23:40:50 6791 8192000000 10978348368 11416178688 2020226704 19.782 100 56 110 2 2066406608 28650544 17529360
23:41:03 5754 8192000000 10996516016 11427467264 2028245712 19.845 100 65 128 0 2077684464 30064416 19374336
23:41:21 2072 8192000000 11010471264 11441315840 2040357040 19.940 100 72 144 1 2096922720 33683824 22881856
23:41:31 2571 8192000000 11007682512 11435192320 2033226704 19.884 100 79 157 0 2093577328 35264480 25086144
23:41:43 4519 8192000000 10981890176 11411369984 2006911696 19.677 99 63 126 1 2063711504 36471648 20328160
23:41:56 6976 8192000000 10986097008 11415031808 2012852848 19.724 100 75 148 0 2074149984 38091840 23205296
23:42:12 2585 8192000000 10989420992 11411787776 2009389456 19.697 100 85 170 0 2075553152 39701552 26462144
23:42:23 3243 8192000000 10976797376 11398524928 1989335952 19.539 99 75 150 1 2052799312 40238464 23224896
23:42:35 937 8192000000 10986103536 11406012416 2001505264 19.635 100 86 171 1 2069236880 41017088 26714528
23:42:44 2877 8192000000 10981954960 11399733248 1985779968 19.510 99 73 143 2 2050156736 41326080 23050688
23:42:54 4358 8192000000 10986057200 11410960384 2008851344 19.692 100 80 158 1 2076120720 42191408 25077968
23:43:08 5786 8192000000 10983549072 11410112512 1989598944 19.541 99 75 148 1 2057892208 44145456 24147808
23:43:22 2297 8192000000 10988982912 11410976768 2006478896 19.674 100 77 155 0 2072962128 42617296 23865936
23:43:32 1786 8192000000 10981932048 11399954432 1993163136 19.569 99 84 168 3 2064098400 44288448 26646816
23:43:42 2433 8192000000 10992300352 11406888960 1987163520 19.521 99 88 175 1 2057813264 43400608 27249136
23:43:51 3365 8192000000 10985690224 11409358848 2003979824 19.654 100 71 140 0 2067638736 41079472 22579440
23:44:03 1583 8192000000 10991881936 11407155200 2001104352 19.631 100 86 171 0 2068333952 40806320 26423280
23:44:12 3060 8192000000 10993860992 11412054016 2007178560 19.679 100 93 187 3 2077226576 41316832 28731184
23:44:23 1482 8192000000 10970623504 11382415360 1975721632 19.431 98 90 177 0 2046042752 43003648 27317472
23:44:33 2114 8192000000 10977923536 11406671872 1999638944 19.620 100 83 166 0 2069640272 44015184 25986144
23:44:42 2377 8192000000 10978294384 11403501568 1995013680 19.583 100 68 136 3 2061167072 44357632 21795760
23:44:51 18547 8192000000 10940996544 11374530560 1912306000 18.925 96 36 72 2 1968832160 43829680 12696480
23:45:16 7758 8192000000 10953404352 11383685120 1973268784 19.411 100 56 112 1 2032538144 41180240 18089120
23:45:33 7197 8192000000 10943015664 11370676224 1940284176 19.149 98 56 112 3 1997239296 39249904 17705216
23:45:50 1642 8192000000 10959329072 11372822528 1955282416 19.269 99 85 169 0 2023917008 42692480 25942112
23:45:59 796 8192000000 10944724384 11356004352 1952300512 19.245 99 86 170 1 2023474896 44388032 26786352
23:46:06 3205 8192000000 10931629472 11344834560 1929465712 19.063 99 80 159 2 1998297264 43978640 24852912
23:46:18 4628 8192000000 10933731872 11357548544 1948641520 19.216 100 72 144 2 2018426768 47072032 22713216
23:46:32 14824 8192000000 10912734480 11351330816 1922667712 19.008 99 44 88 1 1987031344 49678832 14684800
23:47:02 10028 8192000000 10916283392 11349127168 1905244336 18.868 98 39 78 0 1969499280 50642496 13612448
23:47:21 3761 8192000000 10896525424 11302064128 1871536096 18.597 97 63 129 1 1942048288 50102144 20410048
23:47:35 1784 8192000000 10921886640 11328909312 1915635136 18.952 100 84 167 2 1995530416 52305888 27589392
23:47:44 2498 8192000000 10938766208 11347730432 1936335040 19.117 100 89 178 0 2019319584 54091120 28893424
23:47:53 2789 8192000000 10920882192 11331284992 1910157520 18.908 99 85 171 2 1992772240 54789936 27824784
23:48:04 7815 8192000000 10898067600 11328008192 1899492544 18.822 99 42 84 2 1968791264 54982944 14315776
23:48:27 7671 8192000000 10876408784 11308670976 1884579024 18.702 98 45 90 0 1945402480 46399712 14423744
23:48:43 8465 8192000000 10876096368 11312263168 1916058080 18.955 100 42 82 2 1974989648 45332272 13599296
23:49:07 5565 8192000000 10915002784 11341336576 1940896672 19.154 100 63 125 1 2000795680 40379408 19519600
23:49:25 17133 8192000000 10923666592 11354791936 1954533136 19.263 100 47 92 3 2006167888 37349056 14285696
23:50:19 20481 8192000000 10919565264 11368423424 1960928016 19.313 100 30 60 1 2007289408 35772512 10588880
23:50:57 25382 8192000000 10917280448 11378429952 1963717376 19.336 100 27 54 1 2014086896 41222896 9146624
23:51:30 32093 8192000000 10927922672 11384049664 1962291968 19.324 100 24 48 2 2012346624 41818624 8236032
23:52:09 30157 8192000000 10924085696 11382312960 1955386592 19.269 100 24 48 2 2010767712 46566960 8814160
23:53:05 16725 8192000000 10932919024 11389005824 1923414512 19.014 99 29 59 1 1994857696 60598464 10844720
23:53:28 15691 8192000000 10923428800 11374325760 1945798544 19.193 100 20 40 0 2005665312 52023312 7843456
23:53:53 28158 8192000000 10923565840 11388694528 1937934704 19.130 99 31 62 1 1996931280 47874544 11122032
23:54:31 43253 8192000000 10865726720 11339411456 1897822720 18.809 98 18 36 3 1947099312 42737584 6539008
23:56:28 24838 8192000000 10883254080 11357573120 1943350560 19.173 100 17 34 1 1972118448 23447744 5320144
23:57:06 49820 8192000000 10911242400 11352748032 1957747792 19.288 100 21 43 1 1981574544 18548208 5278544
23:58:03 29855 8192000000 10908684096 11354525696 1966488144 19.358 100 50 100 1 1991812976 11135744 14189088
23:58:44 85607 8192000000 10925613232 11354492928 1945940464 19.194 99 24 48 1 1961917136 8901472 7075200
00:00:24 11044 8192000000 10890577360 11341836288 1937695376 19.128 98 48 94 1 1958140448 6966672 13478400
00:00:44 93011 8192000000 10877661024 11326283776 1870975840 18.592 95 18 36 1 1886193360 10486528 4730992
00:02:23 76953 8192000000 10869955984 11325857792 1919945312 18.986 98 16 32 0 1938053408 13315120 4792976
00:03:52 8340 8192000000 10895882080 11347636224 1958379888 19.293 100 30 60 0 1975211616 8340912 8490816
00:04:08 62100 8192000000 10881457312 11341168640 1921874000 19.002 98 28 56 1 1940711680 10429968 8407712
00:05:29 42956 8192000000 10904311760 11355652096 1948704608 19.216 99 40 80 2 1975883376 15428016 11750752
00:06:21 15606 8192000000 10908723968 11352936448 1955721136 19.272 99 53 105 1 1982347344 10959520 15666688
00:06:45 20383 8192000000 10927444224 11369582592 1976231056 19.435 100 56 113 0 2010939312 17516448 17191808
00:07:27 86413 8192000000 10907655584 11375996928 1954534976 19.263 99 15 30 1 1978354784 18663520 5156288
00:09:02 63225 8192000000 10907628960 11385683968 1980382608 19.468 100 19 38 1 2005215600 19253568 5579424
00:10:20 30713 8192000000 10909638432 11374014464 1976706704 19.439 100 21 42 1 1997058912 13875360 6476848
00:11:01 52641 8192000000 10908406176 11376783360 1982312224 19.483 100 24 45 0 1998245744 8750496 7183024
00:12:01 67323 8192000000 10910357040 11372048384 1967507744 19.366 99 16 32 0 1981658672 8586000 5564928
00:13:20 89126 8192000000 10927709504 11386736640 1981761760 19.479 100 24 49 0 2000458848 11372608 7324480
00:15:01 94779 8192000000 10916608496 11396468736 1988867968 19.535 100 22 44 0 2010688560 15178320 6642272
00:16:42 35612 8192000000 10927021232 11406262272 1991645728 19.557 100 12 23 0 2009667344 14772848 3248768
00:17:35 20598 8192000000 10929341168 11398922240 1998270224 19.609 100 14 28 1 2013361200 11257552 3833424
00:18:10 52476 8192000000 10928471584 11406888960 2003715056 19.652 100 11 22 0 2016465312 9049888 3700368
00:19:09 61522 8192000000 10920353216 11403915264 2003802128 19.653 100 22 44 2 2019747872 9044256 6901488
00:20:16 38252 8192000000 10921788080 11404705792 1993720016 19.573 99 18 36 3 2009465632 10444272 5301344
00:21:20 47712 8192000000 10925220048 11397013504 1971304288 19.396 98 16 32 1 1990417824 14581024 4532512
00:22:28 69086 8192000000 10913579840 11387166720 1941227184 19.157 97 28 57 1 1962626160 13214768 8184208
00:23:44 59700 8192000000 10904944496 11387314176 1948841232 19.217 98 19 38 2 1965110848 11033392 5236224
00:24:50 95669 8192000000 10926905984 11396464640 1950425136 19.230 98 10 20 0 1961961968 8939072 2597760
00:26:36 68326 8192000000 10943664016 11409199104 1983215616 19.490 99 18 36 1 1997490336 8971184 5303536
00:28:02 38575 8192000000 10946336816 11417694208 2013357120 19.728 100 41 82 1 2039010912 14037808 11615984
00:29:36 87975 8192000000 10872888976 11333763072 1813563360 18.125 91 12 24 0 1824977280 8214704 3199216
00:31:11 19939 8192000000 10872875328 11332460544 1899222080 18.820 97 35 70 1 1917989840 9409568 9358192
00:31:45 30176 8192000000 10876279168 11343687680 1932100128 19.084 99 31 62 0 1952391136 11512560 8778448
00:32:24 25983 8192000000 10894796592 11354750976 1959355216 19.301 100 39 78 2 1982435088 11742720 11337152
00:32:56 35719 8192000000 10854888672 11330547712 1872888208 18.608 96 34 68 0 1896862176 14288208 9685760
00:33:42 35878 8192000000 10863425536 11308658688 1824935392 18.218 94 32 64 2 1846550592 12606160 9009040
00:34:24 43013 8192000000 10864789952 11341242368 1921876864 19.002 100 20 40 2 1941128800 13765376 5486560
00:36:06 96199 8192000000 10856338960 11323453440 1821770928 18.192 95 8 16 1 1839152944 15174736 2207280
00:37:51 123652 8192000000 10840008704 11296874496 1825466928 18.222 95 18 34 2 1845193536 14935312 4791296
00:40:06 90282 8192000000 10798118592 11268726784 1847506688 18.402 97 20 40 0 1868355744 14392928 6456128
00:41:44 22430 8192000000 10836810464 11306061824 1901733200 18.840 100 24 48 1 1919796368 11644960 6418208
00:42:17 52791 8192000000 10824161040 11305611264 1878203520 18.651 98 17 34 3 1890583408 7572384 4807504
00:43:22 35979 8192000000 10820868672 11299397632 1876687072 18.638 98 7 13 1 1886377296 8164096 1526128
00:44:06 23354 8192000000 10861241312 11311443968 1915356736 18.950 100 20 38 1 1928019632 7610128 5052768
00:44:44 80176 8192000000 10846972096 11318571008 1869182528 18.578 97 16 32 0 1881991840 7528880 5280432
00:46:10 64413 8192000000 10842181056 11327836160 1928432208 19.054 100 12 22 2 1939587584 7976336 3179040
00:47:28 54938 8192000000 10868575712 11339788288 1918685760 18.976 99 14 28 1 1930484336 7522944 4275632
00:48:32 43080 8192000000 10857584720 11328921600 1905152032 18.868 98 11 22 0 1917224688 9139312 2933344
00:49:21 51196 8192000000 10875771024 11334463488 1903516096 18.855 98 22 42 1 1920727872 10835552 6376224
00:50:19 77778 8192000000 10885133968 11359285248 1929138528 19.060 99 18 36 0 1948217792 14045792 5033472
00:52:13 63341 8192000000 10889750656 11359297536 1936698960 19.120 99 18 36 0 1958152016 16533744 4919312
00:53:26 76773 8192000000 10859848864 11313696768 1850679904 18.428 95 21 41 2 1868210096 11050208 6479984
00:54:52 16811 8192000000 10881300416 11329306624 1923969984 19.019 99 43 85 2 1946614224 11094480 11549760
00:55:16 17164 8192000000 10884967248 11335192576 1934779744 19.105 100 40 80 2 1958257328 12401968 11075616
00:55:49 34539 8192000000 10888504064 11349291008 1949810592 19.225 100 41 82 2 1974028848 12814720 11403536
00:56:30 39993 8192000000 10865822656 11322134528 1886458048 18.717 97 32 64 0 1906500656 10935552 9107056
00:57:19 26128 8192000000 10897262896 11348283392 1945284944 19.189 100 33 66 0 1968681760 14504128 8892688
00:57:52 41988 8192000000 10886136048 11362263040 1939619056 19.144 99 28 56 2 1966518112 19338048 7561008
00:58:46 64478 8192000000 10893353040 11358789632 1924211376 19.021 98 13 26 0 1944005184 16644208 3149600
00:59:57 103007 8192000000 10897859952 11372044288 1923995904 19.019 98 18 36 0 1947438832 18925168 4517760
01:02:00 81609 8192000000 10892760064 11373539328 1971315920 19.396 100 26 52 0 1997060864 18458128 7286816
01:03:28 56545 8192000000 10882229136 11369209856 1954303376 19.261 99 4 8 0 1964155248 8667936 1183936
01:04:31 60950 8192000000 10875220528 11353141248 1923234416 19.013 98 14 28 3 1936518768 9474672 3809680
01:05:38 39625 8192000000 10882605312 11358027776 1930671760 19.072 99 8 16 0 1946636720 14316432 1648528
01:06:29 47357 8192000000 10901010560 11371511808 1969586720 19.382 100 25 49 0 1983574992 7572784 6415488
01:07:25 63879 8192000000 10903069024 11374923776 1943038928 19.171 98 19 38 1 1955912480 7048768 5824784
01:08:51 71117 8192000000 10914275616 11385286656 1948869488 19.217 98 19 38 1 1964200896 9445616 5885792
01:10:20 75032 8192000000 10902743120 11388674048 1950999152 19.234 98 11 22 1 1963269200 8987264 3282784
01:12:15 40326 8192000000 10910013200 11392225280 1984049568 19.497 100 11 22 1 1995789472 8496208 3243696
01:13:02 68080 8192000000 10889504528 11361886208 1855045328 18.463 93 14 28 1 1868062608 8734368 4282912
01:14:22 53030 8192000000 10893875744 11366326272 1920383552 18.990 98 10 20 0 1933709840 10628912 2697376
01:15:22 57365 8192000000 10878414944 11354980352 1870315952 18.587 95 17 34 1 1887178576 11925376 4937248
01:16:27 108654 8192000000 10857042048 11329814528 1740860624 17.526 89 7 14 1 1753242288 10432848 1948816
01:18:22 126053 8192000000 10856783760 11320160256 1753784432 17.633 90 8 16 2 1766926272 10829824 2312016
01:21:35 90054 8192000000 10871012768 11355377664 1927073200 19.043 99 18 36 0 1942446688 10719008 4654480
01:23:12 18674 8192000000 10863427504 11345612800 1938425968 19.134 100 10 20 2 1953399792 12173216 2800608
01:23:38 6479 8192000000 10853666592 11324850176 1907205088 18.884 98 25 50 1 1926348624 11901680 7241856
01:23:53 41969 8192000000 10848222640 11327328256 1906886496 18.882 98 26 52 2 1923466048 8334800 8244752
01:24:48 57527 8192000000 10839058352 11321888768 1888692144 18.735 98 7 14 0 1900658416 9814672 2151600
01:25:52 48848 8192000000 10836243824 11314667520 1892046240 18.762 98 9 18 1 1902653552 8027696 2579616
01:26:52 39485 8192000000 9359252288 9648828416 517478752 5.941 27 1 2 0 521118816 3577936 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 20-02-2021 01:29:11 to 20-02-2021 01:29:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          244818
MON$OLDEST_ACTIVE               244819
MON$OLDEST_SNAPSHOT             244819
MON$NEXT_TRANSACTION            244819
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                       2031776
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
--- end of diff output ---

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

20.02.21 01:29:45. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-02-20 01:29:48 No severe PSQL-related problems occured
20.02.21 01:29:49. End of report.