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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17314212 kB
MemAvailable 31416656 kB
Buffers 0 kB
Cached 14346096 kB
SwapCached 3456 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-13 22:26:58
DTS_END                         2020-11-13 22:26:58.8840
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/37400
TRN_ID                          242303
ATT_ID                          670
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: 9536.06 20505 1144327
customer order: creation 176.78 357 21213
customer order: refuse 15.21 365 1825
order to supplier: creation 46.62 1315 5594
order to supplier: removal 3.34 104641 401
invoice (draft): creation 46.13 3399 5535
invoice (draft): removal 54.98 766 6598
invoice accept: apply 42.63 18502 5115
invoice accept: cancel 49.20 716 5904
customer reserve: creation 3993.17 181 479180
customer reserve: removal 4807.00 57 576840
realization accept: apply 84.26 181 10111
realization accept: cancel 85.75 100 10290
payment from customer: creation 60.84 121 7301
payment from customer: removal 5.38 80 646
payment to supplier: creation 49.48 129 5938
payment to supplier: removal 3.17 60 380
service: total inventory turnovers 4.74 1158 569
service: total monetary turnovers 6.49 22 779
service: aggregate perf. data 0.87 18363 104
service: refresh index statistics 0.03 259580 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-11-2020 22:27:53 to 13-11-2020 22:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5892
TEST_TIME 2 5477
TEST_TIME 3 6459
TEST_TIME 4 5756
TEST_TIME 5 5540
TEST_TIME 6 6378
TEST_TIME 7 6101
TEST_TIME 8 6071
TEST_TIME 9 6291
TEST_TIME 10 6548
TEST_TIME 11 6680
TEST_TIME 12 6694
TEST_TIME 13 6949
TEST_TIME 14 7160
TEST_TIME 15 7091
TEST_TIME 16 7251
TEST_TIME 17 7329
TEST_TIME 18 7895
TEST_TIME 19 7960
TEST_TIME 20 8387
TEST_TIME 21 8411
TEST_TIME 22 8239
TEST_TIME 23 8404
TEST_TIME 24 8469
TEST_TIME 25 9104
TEST_TIME 26 9915
TEST_TIME 27 9955
TEST_TIME 28 10788
TEST_TIME 29 11108
TEST_TIME 30 10958
TEST_TIME 31 10755
TEST_TIME 32 10750
TEST_TIME 33 10707
TEST_TIME 34 10612
TEST_TIME 35 10370
TEST_TIME 36 10315
TEST_TIME 37 10187
TEST_TIME 38 10187
TEST_TIME 39 10324
TEST_TIME 40 10273
TEST_TIME 41 10123
TEST_TIME 42 10082
TEST_TIME 43 9932
TEST_TIME 44 9782
TEST_TIME 45 9694
TEST_TIME 46 9714
TEST_TIME 47 9726
TEST_TIME 48 9614
TEST_TIME 49 9539
TEST_TIME 50 9478
TEST_TIME 51 9528
TEST_TIME 52 9537
TEST_TIME 53 9530
TEST_TIME 54 9518
TEST_TIME 55 9753
TEST_TIME 56 9791
TEST_TIME 57 9733
TEST_TIME 58 9757
TEST_TIME 59 9849
TEST_TIME 60 9893
TEST_TIME 61 9908
TEST_TIME 62 9825
TEST_TIME 63 9731
TEST_TIME 64 9676
TEST_TIME 65 9591
TEST_TIME 66 9539
TEST_TIME 67 9455
TEST_TIME 68 9495
TEST_TIME 69 9550
TEST_TIME 70 9572
TEST_TIME 71 9547
TEST_TIME 72 9551
TEST_TIME 73 9543
TEST_TIME 74 9572
TEST_TIME 75 9612
TEST_TIME 76 9575
TEST_TIME 77 9696
TEST_TIME 78 9727
TEST_TIME 79 9729
TEST_TIME 80 9787
TEST_TIME 81 9713
TEST_TIME 82 9617
TEST_TIME 83 9688
TEST_TIME 84 9622
TEST_TIME 85 9584
TEST_TIME 86 9514
TEST_TIME 87 9522
TEST_TIME 88 9453
TEST_TIME 89 9411
TEST_TIME 90 9372
TEST_TIME 91 9416
TEST_TIME 92 9519
TEST_TIME 93 9503
TEST_TIME 94 9514
TEST_TIME 95 9596
TEST_TIME 96 9625
TEST_TIME 97 9618
TEST_TIME 98 9600
TEST_TIME 99 9655
TEST_TIME 100 9633
TEST_TIME 101 9684
TEST_TIME 102 9682
TEST_TIME 103 9690
TEST_TIME 104 9704
TEST_TIME 105 9734
TEST_TIME 106 9646
TEST_TIME 107 9651
TEST_TIME 108 9612
TEST_TIME 109 9614
TEST_TIME 110 9585
TEST_TIME 111 9569
TEST_TIME 112 9532
TEST_TIME 113 9510
TEST_TIME 114 9447
TEST_TIME 115 9489
TEST_TIME 116 9509
TEST_TIME 117 9516
TEST_TIME 118 9475
TEST_TIME 119 9513
TEST_TIME 120 9544
TEST_TIME 121 9465

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 13-11-2020 22:27:56 to 13-11-2020 22:28:00.

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 1585897 1585897 0 0.00 0 13418 6 0 0
doc_list_biud 1585897 1585897 0 0.00 0 24022 27 0 0
sp_add_invoice_to_stock 5198 5115 83 1.59 35 185436 18502 0 83
sp_cancel_adding_invoice 5904 5904 0 0.00 5 60660 716 0 0
sp_cancel_client_order 1825 1825 0 0.00 4 21322 365 0 0
sp_cancel_customer_reserve 576840 576840 0 0.00 1 24024 58 0 0
sp_cancel_pay_from_customer 646 646 0 0.00 2 7667 80 0 0
sp_cancel_pay_to_supplier 380 380 0 0.00 3 2651 61 0 0
sp_cancel_supplier_invoice 6607 6598 9 0.13 2 18573 766 0 9
sp_cancel_supplier_order 401 401 0 0.00 6 1026935 104641 0 0
sp_cancel_write_off 10290 10290 0 0.00 1 8422 101 0 0
sp_client_order 21213 21213 0 0.00 3 29293 357 0 0
sp_customer_reserve 479180 479180 0 0.00 0 137552 181 0 0
sp_fill_shopping_cart 32340 32340 0 0.00 1 14244 36 0 0
sp_fill_shopping_cart_clo_res 479160 479160 0 0.00 0 16507 13 0 0
sp_get_clo_for_invoice 5094 5094 0 0.00 0 28624 303 0 0
sp_kill_cost_storno 17220 17220 0 0.00 0 5690 47 0 0
sp_kill_qstorno_ret_qs2qd 1170969 1170969 0 0.00 0 24020 31 0 0
sp_kill_qty_storno 617062 617062 0 0.00 0 24021 68 0 0
sp_lock_selected_doc 20965 20965 0 0.00 0 6411 5 0 0
sp_make_cost_storno 28443 28443 0 0.00 0 11875 47 0 0
sp_multiply_rows_for_pdistr 28443 28443 0 0.00 0 10149 30 0 0
sp_multiply_rows_for_qdistr 21213 21213 0 0.00 0 12009 165 0 0
sp_pay_from_customer 7301 7301 0 0.00 4 12550 122 0 0
sp_pay_to_supplier 5938 5938 0 0.00 4 14554 130 0 0
sp_payment_common 13239 13239 0 0.00 1 11140 26 0 0
sp_qd_handle_on_cancel_clo 1825 1825 0 0.00 0 21314 329 0 0
sp_qd_handle_on_invoice_upd_sts 10997 10997 0 0.00 0 19060 306 0 0
sp_qd_handle_on_reserve_upd_sts 10111 10111 0 0.00 0 21191 73 0 0
sp_reserve_write_off 10111 10111 0 0.00 6 21224 181 0 0
sp_supplier_invoice 5535 5535 0 0.00 6 90465 3399 0 0
sp_supplier_order 5594 5594 0 0.00 5 66668 1316 0 0
srv_aggregate_perf_data 104 104 0 0.00 2828 165934 18363 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1362 162922 31968 0 0
srv_find_qd_qs_mism 1094355 1094355 0 0.00 0 13417 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 41 135886 1158 0 0
srv_make_money_saldo 779 779 0 0.00 1 509 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 102480 515103 259580 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5115 5115 0 0.00 0 10539 182 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 5925 117 0 0
t$perf-norm:sp_cancel_client_order 1825 1825 0 0.00 0 11801 19 0 0
t$perf-norm:sp_cancel_customer_reserve 668 668 0 0.00 0 1440 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 646 646 0 0.00 0 2865 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 380 380 0 0.00 0 616 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 436 436 0 0.00 0 5043 30 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 29273 1655 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 7075 17 0 0
t$perf-norm:sp_client_order 21213 21213 0 0.00 0 10611 18 0 0
t$perf-norm:sp_customer_reserve 995 995 0 0.00 0 2802 7 0 0
t$perf-norm:sp_pay_from_customer 7301 7301 0 0.00 0 3909 8 0 0
t$perf-norm:sp_pay_to_supplier 5938 5938 0 0.00 0 11888 15 0 0
t$perf-norm:sp_reserve_write_off 10111 10111 0 0.00 0 11759 11 0 0
t$perf-norm:sp_supplier_invoice 5535 5535 0 0.00 0 6173 20 0 0
t$perf-norm:sp_supplier_order 5594 5594 0 0.00 0 4985 17 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 347 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1001 11 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 2658 28 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 960 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10350 10184 166 1.60 0 14090 22 0 166
v_all_customers 38374 38374 0 0.00 0 20 1 0 0
v_all_suppliers 30818 30818 0 0.00 0 17 1 0 0
v_all_wares 42426 42426 0 0.00 0 222 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 383 7 0 0
v_cancel_client_order 3650 3650 0 0.00 0 4041 8 0 0
v_cancel_customer_prepayment 1292 1292 0 0.00 0 1767 7 0 0
v_cancel_customer_reserve 1336 1336 0 0.00 0 2045 6 0 0
v_cancel_payment_to_supplier 760 760 0 0.00 0 1766 6 0 0
v_cancel_supplier_invoice 890 872 18 2.02 0 2220 16 0 18
v_cancel_supplier_order 802 802 0 0.00 0 1493 11 0 0
v_cancel_write_off 2010 2010 0 0.00 0 4168 20 0 0
v_max_id_clo_ord 5594 5594 0 0.00 0 1367 2 0 0
v_max_id_clo_res 995 995 0 0.00 0 1580 15 0 0
v_max_id_ord_sup 5533 5533 0 0.00 0 4399 3 0 0
v_max_non_paid_invoice 1656 1656 0 0.00 0 40 2 0 0
v_max_non_paid_realizn 3886 3886 0 0.00 0 5960 7 0 0
v_min_id_clo_ord 5594 5594 0 0.00 0 3325 6 0 0
v_min_id_clo_res 995 995 0 0.00 0 2775 7 0 0
v_min_id_ord_sup 5533 5533 0 0.00 0 4957 7 0 0
v_min_non_paid_invoice 5938 5938 0 0.00 0 6885 14 0 0
v_min_non_paid_realizn 7301 7301 0 0.00 0 10661 14 0 0
v_our_firm 10882 10882 0 0.00 0 16 1 0 0
v_reserve_write_off 20222 20222 0 0.00 0 14102 9 0 0
x_lock_depdocs_on_canc_invoice 12066 12066 0 0.00 0 20883 108 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 13798 401 0 0
x_make_qstorno_1000_1200 5594 5594 0 0.00 1 66652 1238 0 0
x_make_qstorno_1200_2000 5535 5535 0 0.00 3 90392 3268 0 0
x_make_qstorno_2100_3300 479180 479180 0 0.00 0 137536 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2020 22:28:01 to 13-11-2020 22:28:05.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:02 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:09 33248 8192000000 10283745152 10596302848 894968128 9.848 68 58 116 0 916523904 2531040 19024736
19:57:52 31337 8192000000 10347616208 10665746432 1397670208 14.574 100 88 176 0 1430963840 4655984 28637648
19:58:32 11714 8192000000 10370222448 10692923392 1429221984 14.854 100 88 176 0 1464274384 6062608 28989792
19:58:52 33862 8192000000 10402032112 10727227392 1450906624 15.046 100 85 170 0 1485099056 6710016 27482416
19:59:34 16916 8192000000 10423069456 10751762432 1478966640 15.292 100 86 172 0 1514342560 7307472 28068448
20:00:00 28606 8192000000 10445900288 10778865664 1495414912 15.436 100 88 176 0 1531583264 8095344 28073008
20:00:41 17627 8192000000 10468567280 10805985280 1519114864 15.643 100 91 182 0 1556903456 8894512 28894080
20:01:10 11297 8192000000 10489499952 10834432000 1545259568 15.869 100 85 171 1 1581469008 9624896 26584544
20:01:46 16565 8192000000 10546155952 10897641472 1601171728 16.349 100 83 166 1 1636351200 10254336 24925136
20:02:14 17759 8192000000 10586680720 10943078400 1633540640 16.625 100 86 171 1 1670059680 11315280 25203760
20:02:43 12316 8192000000 10592166976 10955096064 1649410016 16.759 100 82 164 2 1686259936 12650864 24199056
20:03:04 11543 8192000000 10616157520 10978213888 1668419248 16.920 100 84 168 3 1706284464 13198336 24666880
20:03:24 8557 8192000000 10623652496 10990166016 1683290576 17.045 100 87 174 1 1722635968 13558848 25786544
20:03:39 8152 8192000000 10636475744 11006443520 1698828048 17.175 100 78 156 0 1734309680 13375600 22106032
20:03:55 8449 8192000000 10657905184 11030208512 1715253440 17.313 100 77 152 2 1750702416 13195264 22253712
20:04:12 6546 8192000000 10657362096 11038253056 1726555312 17.407 100 73 146 2 1760733232 13315552 20862368
20:04:26 8007 8192000000 10675806576 11048427520 1735584672 17.482 100 76 150 1 1769789264 12409472 21795120
20:04:42 4805 8192000000 10680491760 11060011008 1746070960 17.569 100 76 151 0 1780192112 13510704 20610448
20:04:53 3898 8192000000 10693980128 11072081920 1754434960 17.638 100 85 171 0 1791910464 13348480 24127024
20:05:04 4564 8192000000 10695883728 11075379200 1756428880 17.655 100 81 162 1 1793157392 13837136 22891376
20:05:18 5890 8192000000 10702300784 11084214272 1763313824 17.712 100 75 150 0 1796384624 12553168 20517632
20:05:31 3745 8192000000 10712984624 11093856256 1774930864 17.808 100 89 177 4 1813485072 13542832 25011376
20:05:41 10792 8192000000 10715196688 11101638656 1778991824 17.841 100 78 156 0 1814957440 13729024 22236592
20:05:59 3425 8192000000 10728967552 11117002752 1786032944 17.899 100 76 153 0 1820375392 12977184 21365264
20:06:09 3016 8192000000 10745661200 11131318272 1804338976 18.049 100 84 168 1 1841777120 13376064 24062080
20:06:19 2580 8192000000 10753010368 11135201280 1810911712 18.103 100 89 178 0 1848876000 13008768 24955520
20:06:28 3402 8192000000 10767312496 11149164544 1822769648 18.200 100 93 186 0 1863234144 13696960 26767536
20:06:39 3480 8192000000 10754864272 11144765440 1827987648 18.243 100 76 151 2 1861795360 13309968 20497744
20:06:49 2341 8192000000 10770913808 11157868544 1831324416 18.270 100 85 168 0 1868648608 13558848 23765344
20:06:58 1739 8192000000 10779958864 11163848704 1837070880 18.317 100 87 174 0 1876037632 14790592 24176160
20:07:07 2011 8192000000 10781159696 11162796032 1841519072 18.353 100 95 191 1 1884045728 15432320 27094336
20:07:15 2310 8192000000 10780444384 11170226176 1843333488 18.368 100 85 171 1 1880770544 12797152 24639904
20:07:25 1209 8192000000 10790342928 11175194624 1844017296 18.373 100 85 166 1 1879194816 11630320 23547200
20:07:32 1960 8192000000 10786758944 11177062400 1850008224 18.422 100 92 184 1 1887868992 12219616 25641152
20:07:41 4939 8192000000 10790461344 11184336896 1856567696 18.475 100 90 179 3 1895342784 12838128 25936960
20:07:52 1608 8192000000 10805585216 11192332288 1861119984 18.512 100 94 187 1 1899454160 11775760 26558416
20:08:00 976 8192000000 10808221920 11193905152 1863002832 18.528 100 92 185 0 1901783760 12689408 26091520
20:08:07 1456 8192000000 10815501920 11203170304 1869643120 18.581 100 86 169 2 1907136880 13237568 24256192
20:08:15 34778 8192000000 10800870992 11200856064 1868730496 18.574 100 59 118 0 1895786496 10281120 16774880
20:08:56 2502 8192000000 10815316400 11210924032 1871361136 18.595 100 75 150 1 1903326704 10451888 21513680
20:09:06 7242 8192000000 10775769600 11200495616 1866213312 18.554 100 36 72 2 1885024080 8964992 9845776
20:09:20 7003 8192000000 10783632592 11204837376 1866634832 18.557 100 36 73 2 1886692112 9184352 10872928
20:09:33 7172 8192000000 10784727488 11202912256 1871793568 18.599 100 38 77 0 1890070256 6742816 11533872
20:09:49 4843 8192000000 10775158736 11203903488 1871413040 18.596 100 29 59 2 1886961504 8164944 7383520
20:10:02 3487 8192000000 10800013152 11221114880 1880979728 18.673 100 46 92 0 1910219184 16531664 12707792
20:10:14 7596 8192000000 10789998528 11214721024 1877461968 18.645 100 37 70 0 1895668208 7946880 10259360
20:10:27 5748 8192000000 10781333952 11213135872 1878542176 18.653 100 25 50 1 1892900704 7506064 6852464
20:10:44 8568 8192000000 10799750720 11224252416 1883783280 18.696 100 33 66 5 1900025648 7559472 8682896
20:11:02 14793 8192000000 10790656032 11220647936 1890719072 18.752 100 30 60 3 1905514736 5738832 9056832
20:11:23 45998 8192000000 10815041264 11233206272 1889179376 18.739 100 16 32 2 1898684944 5184864 4320704
20:12:16 30239 8192000000 10808666240 11238424576 1895260592 18.788 100 29 58 3 1912159104 7207040 9691472
20:12:53 6131 8192000000 10808864864 11242074112 1896991344 18.802 100 18 36 0 1907667488 5687696 4988448
20:13:07 5285 8192000000 10807367360 11242868736 1899535792 18.823 100 30 61 2 1915385072 7117760 8731520
20:13:20 4606 8192000000 10816603664 11248254976 1901746080 18.840 100 34 68 0 1918215072 7043728 9425264
20:13:31 5175 8192000000 10811681376 11242467328 1899289136 18.821 100 19 38 0 1911786560 6368832 6128592
20:13:45 2743 8192000000 10825977968 11253944320 1904261936 18.861 100 29 58 3 1919629856 6762368 8605552
20:13:56 6605 8192000000 10824115552 11251712000 1904554160 18.863 100 21 42 0 1915871744 5200496 6117088
20:14:09 8810 8192000000 10817162384 11250663424 1906686208 18.880 100 24 48 1 1919232320 5697200 6848912
20:14:24 7479 8192000000 10811517968 11252920320 1906850928 18.881 100 24 47 2 1920736320 7009248 6876144
20:14:38 7141 8192000000 10829641680 11258867712 1909846816 18.905 100 23 45 2 1921845024 5872848 6125360
20:14:52 4379 8192000000 10824981344 11257655296 1910763024 18.913 100 30 58 0 1926452848 7039936 8649888
20:15:03 10554 8192000000 10786312736 11225305088 1868753904 18.574 98 17 34 0 1879157696 5386384 5017408
20:15:21 10435 8192000000 10818187008 11247407104 1899495072 18.822 100 20 38 2 1910449936 5300592 5654272
20:15:39 10582 8192000000 10799218352 11231858688 1884104432 18.698 99 16 32 0 1895034672 6008752 4921488
20:15:59 60900 8192000000 10810243216 11235319808 1864889712 18.543 98 35 68 2 1880683520 5438240 10355568
20:17:08 19135 8192000000 10808612080 11242504192 1888386880 18.733 100 22 44 4 1900353760 6068800 5898080
20:17:37 4733 8192000000 10809724496 11240693760 1893338224 18.773 100 19 38 1 1904054464 5490128 5226112
20:17:48 4030 8192000000 10791519312 11209695232 1815869024 18.144 96 27 54 2 1829392864 5311280 8212560
20:18:02 5457 8192000000 10724277360 11146964992 1766983056 17.742 95 29 58 2 1781540384 5703152 8854176
20:18:19 9355 8192000000 10734710352 11153911808 1747030640 17.577 95 17 32 1 1756176032 4612768 4532624
20:18:35 10511 8192000000 10703632016 11112988672 1757947104 17.667 96 26 52 0 1771656016 6117664 7591248
20:18:52 6023 8192000000 10735968752 11157102592 1815187808 18.138 100 26 51 1 1827534224 5738320 6608096
20:19:07 6849 8192000000 10723170608 11147522048 1774044848 17.800 97 16 33 1 1784876496 5680416 5151232
20:19:22 5997 8192000000 10700334112 11119931392 1749685504 17.599 97 19 37 1 1760368256 5863488 4819264
20:19:37 10351 8192000000 10683983600 11096064000 1697280800 17.162 95 28 56 1 1710667216 5064752 8321664
20:19:56 8206 8192000000 10690760512 11098722304 1755701264 17.649 99 21 41 3 1767866256 5850400 6314592
20:20:11 7506 8192000000 10699047856 11116773376 1755943488 17.651 98 24 48 0 1768621904 5126144 7552272
20:20:28 29188 8192000000 10690539296 11108880384 1733994192 17.469 96 28 56 1 1747495904 4855968 8645744
20:21:31 18774 8192000000 10724532800 11140751360 1775689200 17.814 98 30 60 1 1790249456 5190848 9369408
20:21:56 6144 8192000000 10728397872 11140235264 1782860192 17.873 98 40 79 3 1799430160 5120704 11449264
20:22:11 7069 8192000000 10724054000 11143176192 1797432400 17.993 99 35 70 0 1814795696 7563344 9799952
20:22:27 5673 8192000000 10743143568 11154677760 1817172352 18.155 100 42 82 1 1835180368 6702464 11305552
20:22:41 6855 8192000000 10734396560 11157643264 1825106592 18.219 100 21 43 1 1836379632 5360432 5912608
20:22:58 6230 8192000000 10751395168 11172290560 1834259712 18.294 100 30 59 2 1849070288 6092832 8717744
20:23:11 6226 8192000000 10756561104 11184525312 1839807312 18.339 100 23 46 0 1854059520 7528672 6723536
20:23:23 4357 8192000000 10752466048 11169574912 1826824384 18.233 99 31 62 0 1842486176 6829376 8832416
20:23:35 8108 8192000000 10760692880 11185610752 1844097264 18.374 100 21 42 2 1856222240 6127632 5997344
20:23:50 7443 8192000000 10771021168 11191537664 1854605120 18.460 100 27 52 2 1868525088 6137440 7782528
20:24:04 8165 8192000000 10775540368 11200634880 1858518800 18.491 100 21 42 0 1870000352 5283328 6198224
20:24:18 8887 8192000000 10787310160 11207770112 1865196784 18.545 100 27 54 1 1878282672 4958560 8127328
20:24:37 14489 8192000000 10779975392 11212505088 1866464960 18.556 100 10 20 0 1874450480 5644240 2341280
20:24:58 9049 8192000000 10773908416 11209637888 1869100352 18.577 100 16 32 2 1878905216 5189712 4615152
20:25:13 18573 8192000000 10782520720 11210719232 1875641200 18.630 100 28 55 3 1889168640 5384784 8142656
20:25:40 53755 8192000000 10824348816 11223117824 1879601168 18.662 100 48 98 0 1899301984 4886288 14814528
20:26:39 8743 8192000000 10780983664 11220574208 1877007072 18.641 100 26 52 1 1891372560 6778048 7587440
20:26:55 18498 8192000000 10813606240 11234619392 1884622192 18.702 100 33 65 4 1899308224 5931024 8755008
20:27:20 2428 8192000000 10850916576 11255963648 1910081552 18.907 100 73 144 0 1940659376 8970704 21607120
20:27:34 14890 8192000000 10845402608 11262660608 1916458992 18.958 100 59 116 1 1941349664 9259712 15630960
20:27:57 2668 8192000000 10862490752 11270193152 1919213792 18.981 100 57 113 1 1943512688 8542912 15755984
20:28:06 20222 8192000000 10852337440 11274989568 1926037664 19.035 100 61 122 0 1953974960 10182272 17755024
20:28:34 9001 8192000000 10867334560 11285475328 1927557056 19.047 100 51 102 2 1953634720 11445072 14632592
20:28:52 4132 8192000000 10875616720 11291701248 1936546752 19.119 100 59 116 0 1965451472 11526320 17378400
20:29:02 3946 8192000000 10869117664 11290230784 1943148864 19.172 100 66 133 0 1975449232 14235344 18065024
20:29:14 4811 8192000000 10880533712 11299606528 1945043584 19.187 100 67 135 2 1977153824 12858800 19251440
20:29:34 13804 8192000000 10875220976 11299065856 1941825328 19.161 100 49 98 0 1967768944 12220672 13722944
20:30:02 21558 8192000000 10884810624 11311734784 1951511424 19.239 100 52 104 1 1978298384 12116016 14670944
20:30:34 30638 8192000000 10894726944 11316191232 1956678208 19.280 100 55 111 0 1985844880 13401232 15765440
20:31:12 20411 8192000000 10890310576 11321028608 1960812352 19.312 100 52 102 1 1988899440 13840624 14246464
20:31:48 5151 8192000000 10900097648 11324555264 1962055072 19.322 100 51 102 1 1991234144 13981584 15197488
20:32:12 38679 8192000000 10896965616 11332730880 1962366336 19.325 100 41 82 2 1995553264 20536256 12650672
20:33:06 7124 8192000000 10892096624 11321679872 1958209120 19.292 100 44 88 1 1984809792 13104432 13496240
20:33:20 11359 8192000000 10901226064 11330371584 1964683472 19.343 100 48 97 1 1993302672 12987872 15631328
20:33:39 6716 8192000000 10916874064 11343917056 1975424832 19.428 100 56 108 2 2006119376 13985456 16709088
20:33:55 6626 8192000000 10923754912 11340439552 1963563568 19.334 99 74 146 4 2001605408 16220304 21821536
20:34:12 6531 8192000000 10919840448 11349311488 1974910288 19.424 100 51 102 2 2011630160 21675264 15044608
20:34:28 10107 8192000000 10934889056 11355119616 1979632240 19.462 100 53 106 1 2013951648 18209856 16109552
20:34:45 10214 8192000000 10929019120 11355197440 1982996512 19.488 100 53 105 2 2016560624 18197264 15366848
20:35:02 7009 8192000000 10932149504 11355774976 1983319184 19.491 100 67 132 3 2022753488 19885424 19548880
20:35:18 12339 8192000000 10936863808 11361665024 1985587808 19.509 100 65 128 1 2024343248 19940512 18814928
20:35:38 9192 8192000000 10941712576 11366047744 1992729728 19.565 100 65 130 0 2030736432 18810640 19196064
20:35:58 10813 8192000000 10938427696 11368284160 1991826480 19.558 100 51 100 1 2028918544 21757040 15335024
20:36:20 11000 8192000000 10942026464 11376898048 1977832432 19.448 99 53 104 2 2017178864 23347312 15999120
20:36:43 4068 8192000000 10948105152 11369635840 1978471056 19.453 99 66 129 2 2022312528 23571712 20269760
20:36:57 7530 8192000000 10945158560 11376046080 1991084544 19.552 100 48 96 1 2027935824 22719680 14131600
20:37:12 11880 8192000000 10945729728 11379494912 1997366720 19.602 100 51 102 0 2035731376 22620032 15744624
20:37:33 5445 8192000000 10950577072 11378655232 1997915888 19.606 100 66 130 2 2042091040 23513760 20661392
20:37:45 1681 8192000000 10941750624 11354128384 1976961312 19.441 99 79 158 1 2023933072 24017984 22953776
20:37:53 2025 8192000000 10935886256 11343892480 1955932464 19.274 99 88 172 1 2007109872 25858160 25319248
20:38:02 3129 8192000000 10955517584 11365904384 1987247952 19.522 100 86 170 1 2037975696 25504976 25222768
20:38:12 5695 8192000000 10950011296 11371466752 1992125104 19.561 100 67 133 0 2037663376 25901712 19636560
20:38:24 3909 8192000000 10955638224 11372855296 1993652128 19.573 100 78 156 0 2044786480 27298640 23835712
20:38:36 6466 8192000000 10951734608 11376238592 1992781648 19.566 100 62 124 0 2038861584 27641312 18438624
20:38:50 8224 8192000000 10953900240 11379679232 1993982832 19.575 100 69 138 2 2044706176 30148112 20575232
20:39:05 8265 8192000000 10959959760 11369881600 1974505456 19.421 99 72 140 0 2025081920 29225248 21351216
20:39:23 1359 8192000000 10967024112 11382423552 1999495664 19.619 100 88 177 0 2057795936 31072688 27227584
20:39:32 3345 8192000000 10963496016 11374501888 1979873088 19.464 99 75 149 0 2034444624 32369376 22202160
20:39:45 1489 8192000000 10971918352 11381104640 1996110592 19.592 100 83 166 1 2054380016 32701552 25567872
20:39:53 3305 8192000000 10975040768 11388424192 1999084176 19.616 100 84 165 2 2056407792 33010784 24312832
20:40:03 5054 8192000000 10956393712 11369390080 1978648480 19.454 99 80 161 1 2037461392 33935888 24877024
20:40:16 6150 8192000000 10937987344 11349889024 1944584128 19.183 98 80 160 0 2006297888 37661056 24052704
20:40:33 2510 8192000000 10943545472 11348852736 1948676400 19.216 99 90 181 1 2012797952 37088016 27033536
20:40:45 8079 8192000000 10932427728 11345088512 1957024000 19.282 100 79 155 0 2019754528 38918256 23812272
20:41:08 3176 8192000000 10938872944 11358707712 1951314816 19.237 99 66 131 0 2010766512 39812320 19639376
20:41:25 3729 8192000000 10958989168 11371261952 1980145136 19.466 100 72 143 1 2042880672 40613712 22121824
20:41:36 6929 8192000000 10951120816 11366924288 1954884528 19.265 99 67 134 3 2017444544 42017632 20542384
20:41:51 14583 8192000000 10943564800 11359727616 1960670944 19.311 99 67 134 1 2024915856 43390048 20854864
20:42:15 5937 8192000000 10952760096 11369807872 1970141024 19.387 100 63 126 2 2035307968 44619408 20547536
20:42:28 8939 8192000000 10953172272 11376312320 1971695312 19.399 100 66 132 1 2038495920 45505552 21295056
20:42:49 7964 8192000000 10950772272 11379417088 1960815088 19.313 99 59 118 0 2023156016 43570224 18770704
20:43:04 8219 8192000000 10961880016 11385786368 1977748240 19.447 100 63 124 1 2045591248 47481440 20361568
20:43:19 5821 8192000000 10954891248 11372351488 1965505088 19.350 99 66 130 2 2033833248 47438416 20889744
20:43:33 4821 8192000000 10964271104 11381665792 1943450096 19.174 98 62 122 1 2011459984 47564496 20445392
20:43:45 12340 8192000000 10957738032 11376365568 1957262400 19.284 99 68 136 0 2026799632 48250272 21286960
20:44:04 5234 8192000000 10962912880 11381882880 1970223344 19.387 100 73 145 1 2044890784 51516336 23151104
20:44:16 3054 8192000000 10964589600 11374710784 1967474176 19.365 100 78 156 1 2040667440 48456160 24737104
20:44:27 4076 8192000000 10946051536 11360661504 1952098160 19.243 99 80 158 1 2026973696 49749376 25126160
20:44:39 4085 8192000000 10960850448 11373887488 1968599072 19.374 100 84 166 1 2045901072 51746928 25555072
20:44:50 2850 8192000000 10952056144 11367268352 1960706416 19.312 100 73 147 0 2035910688 51950240 23254032
20:45:00 3300 8192000000 10959017072 11365933056 1967921328 19.369 100 82 164 0 2040026704 45468544 26636832
20:45:09 2371 8192000000 10959267088 11366584320 1954138224 19.259 99 89 178 0 2027654928 45770400 27746304
20:45:20 5953 8192000000 10947070096 11358453760 1944480800 19.182 99 78 156 3 2014664768 45870208 24313760
20:45:32 3454 8192000000 10925437792 11342299136 1928613520 19.056 99 77 152 0 2000281584 47501008 24167056
20:46:00 4333 8192000000 10904756048 11303792640 1904604704 18.863 99 82 161 1 1976711312 46546880 25559728
20:46:12 5458 8192000000 10899806048 11322224640 1923195024 19.012 100 53 106 2 1985712368 45520864 16996480
20:46:25 10828 8192000000 10912386192 11329462272 1909436880 18.902 99 57 112 1 1973641008 45608528 18595600
20:46:51 7393 8192000000 10910845520 11340861440 1936355024 19.118 100 59 118 1 1999105040 44540384 18209632
20:47:08 4707 8192000000 10891006080 11327172608 1924737008 19.025 100 44 88 2 1982183616 43101024 14345584
20:47:19 6885 8192000000 10907921008 11342458880 1934356112 19.102 100 39 78 3 1991277344 43860912 13060320
20:47:41 23235 8192000000 10907732960 11333591040 1902697136 18.848 98 29 58 0 1955120240 42839568 9583536
20:48:13 5354 8192000000 10911393696 11337183232 1928814976 19.057 100 51 102 1 1989323040 43973856 16534208
20:48:30 2364 8192000000 10919945600 11339141120 1926295376 19.037 99 53 108 0 1993545104 49971056 17278672
20:48:39 10848 8192000000 10919228272 11344703488 1931043888 19.075 100 46 91 1 1998159184 52290672 14824624
20:48:58 10211 8192000000 10923754752 11350310912 1942045520 19.163 100 45 90 2 2012248576 54647216 15555840
20:49:24 7565 8192000000 10940660368 11370389504 1956368368 19.277 100 54 106 2 2027644848 53170864 18105616
20:49:43 18875 8192000000 10953147232 11386769408 1961311760 19.316 100 43 86 1 2034897904 59463040 14123104
20:50:10 14549 8192000000 10949828048 11381899264 1946137376 19.196 99 37 74 2 2018863392 59038432 13687584
20:50:38 9545 8192000000 10938741008 11372531712 1949153424 19.220 100 37 74 0 2022775264 60706432 12915408
20:51:01 12015 8192000000 10941480304 11379396608 1948005888 19.211 100 33 64 1 2023906896 64016464 11884544
20:51:19 24497 8192000000 10938914560 11398356992 1959342928 19.301 100 39 78 0 2045818656 73266496 13209232
20:51:52 21002 8192000000 10927880112 11366862848 1937949184 19.130 99 22 44 2 2000541152 54829568 7762400
20:52:22 28511 8192000000 10925182576 11384684544 1956482288 19.278 100 24 48 1 2014496336 49988032 8026016
20:53:35 53294 8192000000 10890690912 11362557952 1903428544 18.854 98 17 34 1 1953112672 43402192 6281936
20:54:34 16349 8192000000 10902236016 11366797312 1938060368 19.131 100 18 36 0 1976401872 32460288 5881216
20:54:59 30621 8192000000 10878207296 11339558912 1931476496 19.079 99 19 38 1 1955046944 17142928 6427520
20:55:39 78920 8192000000 10881083584 11339661312 1949374544 19.221 100 32 64 0 1968918512 10165280 9378688
20:57:06 69017 8192000000 10868334656 11315888128 1861307776 18.514 95 25 50 1 1875576240 7140976 7127488
20:58:34 98701 8192000000 10859507984 11317071872 1871079744 18.593 96 19 38 0 1886221744 10307216 4834784
21:00:19 28046 8192000000 10865342368 11327385600 1947528368 19.207 100 16 32 1 1960636736 8544928 4563440
21:01:30 52981 8192000000 10894099200 11342921728 1946464176 19.198 99 34 67 0 1965568224 9774800 9329248
21:02:30 124183 8192000000 10919357952 11363463168 1954122576 19.259 99 26 50 0 1979567152 17896400 7548176
21:04:41 62896 8192000000 10895579984 11375714304 1970755904 19.391 100 19 38 0 1995845456 18861072 6228480
21:05:52 55015 8192000000 10891372592 11361398784 1959195792 19.300 100 4 8 0 1973521232 13296592 1028848
21:07:08 29773 8192000000 10883492032 11347296256 1963664848 19.335 100 12 24 0 1976604176 9619088 3320240
21:09:08 162922 8192000000 10914621760 11385167872 1980600944 19.469 100 18 36 2 1999111200 13127008 5383248
21:11:59 81944 8192000000 10898341728 11375476736 1983875792 19.495 100 18 36 1 2002986272 13785808 5324672
21:13:27 38364 8192000000 10896274256 11368996864 1966731792 19.360 99 18 36 0 1978792992 7204672 4856528
21:14:15 60777 8192000000 10902975952 11380916224 1978596752 19.454 100 11 22 0 1989120944 7325984 3198208
21:15:22 47472 8192000000 10908754880 11392344064 1984957840 19.504 100 7 14 0 2002035360 15193088 1884432
21:16:19 23595 8192000000 10910584032 11388198912 1987327200 19.523 100 8 16 0 2005472832 15871744 2273888
21:17:20 53277 8192000000 10933759232 11406143488 1996911264 19.598 100 19 38 4 2013325824 10224928 6189632
21:18:19 45911 8192000000 10941341776 11412099072 1984876048 19.503 99 28 55 3 2006137024 12921280 8339696
21:19:12 54336 8192000000 10944309168 11416879104 2005564304 19.667 100 15 30 2 2022658256 12671840 4422112
21:20:12 80335 8192000000 10899173680 11378688000 1876020816 18.633 94 11 22 0 1898190192 18620352 3549024
21:21:44 55259 8192000000 10885151456 11362168832 1907857936 18.889 97 13 26 0 1924153392 12423568 3871888
21:22:48 53497 8192000000 10913196640 11373584384 1957654912 19.287 99 23 46 1 1974826848 10816576 6355360
21:23:48 42122 8192000000 10910790784 11368464384 1954805456 19.265 99 34 68 0 1978506704 14162544 9538704
21:24:45 93585 8192000000 10855726688 11325808640 1812308416 18.115 92 14 27 2 1833000944 16633696 4058832
21:26:26 47562 8192000000 10881196192 11360645120 1948997792 19.218 100 11 22 2 1965898672 14010432 2890448
21:27:25 101572 8192000000 10855898272 11314995200 1828667744 18.248 93 32 63 2 1849267552 11743200 8856608
21:29:30 53242 8192000000 10871379808 11329540096 1927402368 19.046 99 35 70 0 1947003184 9859872 9740944
21:30:29 33133 8192000000 10839361072 11315286016 1916800000 18.961 99 15 30 1 1931514272 10848080 3866192
21:31:12 35710 8192000000 10844265440 11316494336 1923907824 19.018 100 9 18 1 1936526512 10244624 2374064
21:31:56 23787 8192000000 10800494720 11270230016 1854683072 18.460 97 7 14 0 1865102096 8510640 1908384
21:32:35 37815 8192000000 10847743152 11323080704 1914203088 18.940 100 10 20 0 1929666304 13152240 2310976
21:33:30 71665 8192000000 10808318512 11283996672 1758899856 17.675 91 16 32 0 1773464784 10483520 4081408
21:34:48 51694 8192000000 10837390224 11289489408 1845941824 18.389 97 10 20 0 1857588160 9296400 2349936
21:35:49 40033 8192000000 10835031024 11281719296 1838829888 18.331 96 30 58 0 1854492096 7765552 7896656
21:36:36 34537 8192000000 10823508432 11264761856 1807443264 18.075 95 40 79 1 1826129408 7219200 11466944
21:37:19 37559 8192000000 10797070400 11248156672 1837113120 18.317 97 41 82 1 1859619984 11308656 11198208
21:38:03 35974 8192000000 10819727888 11274502144 1868564592 18.573 99 20 40 1 1883339696 9359600 5415504
21:38:45 50681 8192000000 10826574464 11277221888 1861561488 18.516 98 28 56 2 1882628960 13285392 7782080
21:39:49 42161 8192000000 10813793312 11275026432 1835811328 18.307 97 28 56 4 1862379472 18838368 7729776
21:40:38 64014 8192000000 10830547680 11288223744 1835844928 18.307 97 14 28 3 1851079200 11330080 3904192
21:41:48 73855 8192000000 10836094944 11288121344 1777937888 17.832 93 18 36 0 1797088864 14060672 5090304
21:43:10 91731 8192000000 10848197936 11325513728 1902220304 18.844 100 14 28 0 1920938848 14826544 3892000
21:44:51 70517 8192000000 10869252704 11338043392 1913791104 18.937 99 17 34 0 1930553520 11912576 4849840
21:46:18 60748 8192000000 10871981808 11335966720 1913598288 18.936 99 13 26 1 1932271312 15117392 3555632
21:47:28 20333 8192000000 10896089808 11339919360 1953198512 19.252 100 46 92 0 1974600880 8062160 13340208
21:47:55 127311 8192000000 10850807600 11331555328 1917440880 18.966 98 29 58 0 1937058976 11075488 8542608
21:50:09 38749 8192000000 10857174864 11329597440 1912908640 18.930 99 10 20 0 1927199728 11423232 2867856
21:50:56 9931 8192000000 10848891264 11330609152 1930224368 19.069 100 3 6 0 1942262592 11339072 699152
21:51:16 27531 8192000000 10868102688 11331186688 1938830336 19.137 100 20 40 0 1954206800 9938608 5437856
21:52:56 64433 8192000000 10868074192 11351851008 1937702944 19.128 99 15 30 1 1955265904 12788544 4774416
21:54:09 85443 8192000000 10884119536 11353722880 1931929520 19.082 99 17 34 0 1950845152 13923776 4991856
21:56:46 77016 8192000000 10910230240 11375087616 1947887712 19.210 99 14 28 0 1972341216 20002336 4451168
21:58:18 73213 8192000000 10909612496 11373428736 1955879152 19.273 99 15 30 2 1978212960 18200144 4133664
21:59:47 58388 8192000000 10926125312 11392598016 1957292720 19.285 99 15 30 0 1976545264 14947408 4305136
22:01:14 64583 8192000000 10927590480 11412946944 1990434800 19.547 100 14 28 2 2021712864 27126160 4151904
22:02:29 82806 8192000000 10946525616 11417989120 1997275648 19.601 100 14 28 1 2014937504 14260560 3401296
22:04:03 34383 8192000000 10949668544 11399761920 1969068672 19.378 98 40 80 1 1990165536 10492688 10604176
22:04:44 29194 8192000000 10956875888 11411546112 2006723488 19.676 100 39 78 2 2032422416 14900544 10798384
22:05:23 64045 8192000000 10958903696 11410866176 2006089456 19.671 100 31 62 0 2030292336 15656032 8546848
22:06:36 16354 8192000000 10973984496 11417403392 2017355888 19.759 100 51 102 0 2041996944 10320384 14320672
22:07:04 78334 8192000000 10935455200 11403984896 1913439936 18.934 95 25 50 1 1931048816 11039840 6569040
22:09:01 56978 8192000000 10960495920 11417051136 2005669728 19.667 100 38 75 2 2028649456 12635424 10344304
22:10:13 95824 8192000000 10935731504 11415744512 1956457168 19.278 98 6 12 0 1976481936 18497680 1527088
22:11:57 124208 8192000000 10909019056 11386474496 1975934432 19.432 99 18 36 1 1994724016 13394704 5394880
22:14:19 16107 8192000000 10903122400 11378917376 1981992832 19.480 100 26 51 1 1997204320 8341984 6869504
22:14:43 28411 8192000000 10906346528 11384803328 1992906448 19.567 100 37 73 2 2011467264 7855456 10705360
22:15:18 24054 8192000000 10888126016 11361202176 1945895424 19.194 98 20 40 0 1958473760 6831504 5746832
22:15:55 60442 8192000000 10892258416 11369836544 1963182160 19.331 99 12 24 1 1973504016 7335776 2986080
22:17:01 46851 8192000000 10868317712 11340386304 1915079712 18.947 97 9 18 2 1924831824 7446160 2305952
22:17:54 52912 8192000000 10873637712 11354816512 1933955328 19.098 99 7 14 0 1946484800 10496112 2033360
22:18:57 53970 8192000000 10866120816 11343745024 1924581520 19.024 98 14 27 1 1943423104 14890064 3951520
22:19:57 20483 8192000000 10879811872 11351465984 1920815024 18.993 98 8 15 0 1937007328 13980080 2212224
22:20:25 78054 8192000000 10864773952 11343077376 1899699104 18.824 97 17 33 0 1917702768 13568592 4435072
22:21:51 57056 8192000000 10884285248 11345793024 1920345760 18.990 98 18 36 1 1939843184 13399808 6097616
22:22:57 53722 8192000000 10868629360 11345567744 1899256224 18.820 97 18 36 1 1914554768 10295952 5002592
22:23:57 34474 8192000000 10871544640 11333361664 1877883120 18.648 96 15 30 2 1892387568 9806896 4697552
22:24:39 124130 8192000000 10850489968 11312979968 1773720752 17.798 91 16 32 0 1789539088 11956432 3861904
22:26:53 11108 8192000000 9087515664 9307082752 250249616 2.964 14 2 4 0 256293840 5729264 314960

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-11-2020 22:28:06 to 13-11-2020 22:28:38.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-11-2020 22:28:39 to 13-11-2020 22:28:41.

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          242663
MON$OLDEST_ACTIVE               242664
MON$OLDEST_SNAPSHOT             242664
MON$NEXT_TRANSACTION            242664
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                       2030496
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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'

13.11.20 22:28:42. 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-13 22:28:44 No severe PSQL-related problems occured
13.11.20 22:28:45. End of report.