Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 02.02.2021 19: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 17190120 kB
MemAvailable 31210252 kB
Buffers 0 kB
Cached 14475412 kB
SwapCached 4876 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-02 19:27:16
DTS_END                         2021-02-02 19:27:16.6060
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(20:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60832
TRN_ID                          233974
ATT_ID                          672
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: 9472.88 19341 1136745
customer order: creation 179.18 337 21502
customer order: refuse 15.20 352 1824
order to supplier: creation 47.49 1281 5699
order to supplier: removal 3.28 121652 393
invoice (draft): creation 47.34 3467 5681
invoice (draft): removal 52.89 897 6347
invoice accept: apply 43.18 19745 5181
invoice accept: cancel 48.38 911 5805
customer reserve: creation 4028.51 193 483421
customer reserve: removal 4691.84 66 563021
realization accept: apply 85.63 201 10276
realization accept: cancel 94.04 121 11285
payment from customer: creation 61.50 105 7380
payment from customer: removal 5.83 95 699
payment to supplier: creation 51.60 129 6192
payment to supplier: removal 3.84 75 461
service: total inventory turnovers 5.08 1142 610
service: total monetary turnovers 7.28 36 873
service: aggregate perf. data 0.76 24091 91
service: refresh index statistics 0.03 211923 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-02-2021 19:27:53 to 02-02-2021 19:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6457
TEST_TIME 2 5500
TEST_TIME 3 5558
TEST_TIME 4 5123
TEST_TIME 5 5165
TEST_TIME 6 5028
TEST_TIME 7 5323
TEST_TIME 8 5731
TEST_TIME 9 5823
TEST_TIME 10 5860
TEST_TIME 11 5916
TEST_TIME 12 5975
TEST_TIME 13 5897
TEST_TIME 14 5922
TEST_TIME 15 6150
TEST_TIME 16 6013
TEST_TIME 17 6074
TEST_TIME 18 6201
TEST_TIME 19 6254
TEST_TIME 20 6388
TEST_TIME 21 6538
TEST_TIME 22 7135
TEST_TIME 23 7050
TEST_TIME 24 7189
TEST_TIME 25 7640
TEST_TIME 26 7831
TEST_TIME 27 8360
TEST_TIME 28 8514
TEST_TIME 29 8598
TEST_TIME 30 9133
TEST_TIME 31 10152
TEST_TIME 32 10129
TEST_TIME 33 10258
TEST_TIME 34 10361
TEST_TIME 35 10285
TEST_TIME 36 10117
TEST_TIME 37 9859
TEST_TIME 38 9877
TEST_TIME 39 9948
TEST_TIME 40 9854
TEST_TIME 41 9796
TEST_TIME 42 9859
TEST_TIME 43 9716
TEST_TIME 44 9782
TEST_TIME 45 9752
TEST_TIME 46 9695
TEST_TIME 47 9748
TEST_TIME 48 9678
TEST_TIME 49 9581
TEST_TIME 50 9527
TEST_TIME 51 9455
TEST_TIME 52 9330
TEST_TIME 53 9588
TEST_TIME 54 9516
TEST_TIME 55 9491
TEST_TIME 56 9509
TEST_TIME 57 9529
TEST_TIME 58 9578
TEST_TIME 59 9637
TEST_TIME 60 9608
TEST_TIME 61 9653
TEST_TIME 62 9680
TEST_TIME 63 9714
TEST_TIME 64 9674
TEST_TIME 65 9779
TEST_TIME 66 9777
TEST_TIME 67 9813
TEST_TIME 68 9828
TEST_TIME 69 9815
TEST_TIME 70 9723
TEST_TIME 71 9632
TEST_TIME 72 9692
TEST_TIME 73 9746
TEST_TIME 74 9706
TEST_TIME 75 9654
TEST_TIME 76 9634
TEST_TIME 77 9588
TEST_TIME 78 9572
TEST_TIME 79 9523
TEST_TIME 80 9470
TEST_TIME 81 9396
TEST_TIME 82 9453
TEST_TIME 83 9430
TEST_TIME 84 9399
TEST_TIME 85 9408
TEST_TIME 86 9406
TEST_TIME 87 9442
TEST_TIME 88 9418
TEST_TIME 89 9443
TEST_TIME 90 9444
TEST_TIME 91 9535
TEST_TIME 92 9548
TEST_TIME 93 9534
TEST_TIME 94 9583
TEST_TIME 95 9570
TEST_TIME 96 9656
TEST_TIME 97 9659
TEST_TIME 98 9638
TEST_TIME 99 9548
TEST_TIME 100 9557
TEST_TIME 101 9533
TEST_TIME 102 9505
TEST_TIME 103 9489
TEST_TIME 104 9437
TEST_TIME 105 9462
TEST_TIME 106 9400
TEST_TIME 107 9377
TEST_TIME 108 9388
TEST_TIME 109 9395
TEST_TIME 110 9410
TEST_TIME 111 9385
TEST_TIME 112 9449
TEST_TIME 113 9431
TEST_TIME 114 9494
TEST_TIME 115 9444
TEST_TIME 116 9443
TEST_TIME 117 9491
TEST_TIME 118 9469
TEST_TIME 119 9550
TEST_TIME 120 9483

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-02-2021 19:27:57 to 02-02-2021 19: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 1583430 1583430 0 0.00 0 21268 7 0 0
doc_list_biud 1583430 1583430 0 0.00 0 67196 30 0 0
sp_add_invoice_to_stock 5289 5181 108 2.04 31 251309 19745 0 108
sp_cancel_adding_invoice 5805 5805 0 0.00 5 106026 912 0 0
sp_cancel_client_order 1824 1824 0 0.00 4 8943 353 0 0
sp_cancel_customer_reserve 563021 563021 0 0.00 1 67198 66 0 0
sp_cancel_pay_from_customer 699 699 0 0.00 3 13563 95 0 0
sp_cancel_pay_to_supplier 461 461 0 0.00 3 4020 76 0 0
sp_cancel_supplier_invoice 6353 6347 6 0.09 2 19210 898 0 6
sp_cancel_supplier_order 393 393 0 0.00 6 1229451 121652 0 0
sp_cancel_write_off 11285 11285 0 0.00 1 11187 121 0 0
sp_client_order 21502 21502 0 0.00 3 63226 338 0 0
sp_customer_reserve 483421 483421 0 0.00 0 165577 194 0 0
sp_fill_shopping_cart 32878 32878 0 0.00 1 10496 34 0 0
sp_fill_shopping_cart_clo_res 483402 483402 0 0.00 0 12995 13 0 0
sp_get_clo_for_invoice 5161 5161 0 0.00 0 29495 303 0 0
sp_kill_cost_storno 18250 18250 0 0.00 0 19382 67 0 0
sp_kill_qstorno_ret_qs2qd 1144067 1144067 0 0.00 0 67192 36 0 0
sp_kill_qty_storno 604112 604112 0 0.00 0 67196 77 0 0
sp_lock_selected_doc 21369 21369 0 0.00 0 7180 5 0 0
sp_make_cost_storno 29009 29009 0 0.00 0 16648 51 0 0
sp_multiply_rows_for_pdistr 29009 29009 0 0.00 0 16847 30 0 0
sp_multiply_rows_for_qdistr 21502 21502 0 0.00 0 12428 139 0 0
sp_pay_from_customer 7380 7380 0 0.00 4 17264 105 0 0
sp_pay_to_supplier 6192 6192 0 0.00 5 16862 129 0 0
sp_payment_common 13572 13572 0 0.00 1 17257 24 0 0
sp_qd_handle_on_cancel_clo 1824 1824 0 0.00 0 8932 328 0 0
sp_qd_handle_on_invoice_upd_sts 10966 10966 0 0.00 0 31176 357 0 0
sp_qd_handle_on_reserve_upd_sts 10276 10276 0 0.00 0 29787 72 0 0
sp_reserve_write_off 10276 10276 0 0.00 6 29832 202 0 0
sp_supplier_invoice 5681 5681 0 0.00 6 123050 3467 0 0
sp_supplier_order 5699 5699 0 0.00 5 24115 1282 0 0
srv_aggregate_perf_data 92 91 1 1.08 2172 311408 24091 0 1
srv_fill_mon_cache_memory 177 177 0 0.00 1176 185714 30258 0 0
srv_find_qd_qs_mism 1086416 1086416 0 0.00 0 14197 6 0 0
srv_make_invnt_saldo 610 610 0 0.00 27 119481 1142 0 0
srv_make_money_saldo 873 873 0 0.00 1 5440 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 128824 305632 211924 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5182 5182 0 0.00 0 14398 185 0 0
t$perf-norm:sp_cancel_adding_invoice 454 454 0 0.00 1 6246 105 0 0
t$perf-norm:sp_cancel_client_order 1824 1824 0 0.00 0 4728 16 0 0
t$perf-norm:sp_cancel_customer_reserve 680 680 0 0.00 0 3409 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 699 699 0 0.00 0 382 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 461 461 0 0.00 0 1159 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1079 17 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 22105 2014 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 6768 18 0 0
t$perf-norm:sp_client_order 21502 21502 0 0.00 0 9348 21 0 0
t$perf-norm:sp_customer_reserve 1071 1071 0 0.00 0 7697 14 0 0
t$perf-norm:sp_pay_from_customer 7380 7380 0 0.00 0 18023 15 0 0
t$perf-norm:sp_pay_to_supplier 6192 6192 0 0.00 0 9516 14 0 0
t$perf-norm:sp_reserve_write_off 10276 10276 0 0.00 0 9805 15 0 0
t$perf-norm:sp_supplier_invoice 5681 5681 0 0.00 0 13934 27 0 0
t$perf-norm:sp_supplier_order 5699 5699 0 0.00 0 6118 20 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 8780 102 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 4223 26 0 0
t$perf-norm:srv_make_invnt_saldo 610 610 0 0.00 0 1911 31 0 0
t$perf-norm:srv_make_money_saldo 873 873 0 0.00 0 5432 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10530 10314 216 2.05 0 14031 22 0 216
v_all_customers 39670 39670 0 0.00 0 102 1 0 0
v_all_suppliers 32046 32046 0 0.00 0 32 1 0 0
v_all_wares 43000 43000 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 908 908 0 0.00 0 469 6 0 0
v_cancel_client_order 3648 3648 0 0.00 0 3511 5 0 0
v_cancel_customer_prepayment 1398 1398 0 0.00 0 13523 21 0 0
v_cancel_customer_reserve 1360 1360 0 0.00 0 2787 6 0 0
v_cancel_payment_to_supplier 922 922 0 0.00 0 450 4 0 0
v_cancel_supplier_invoice 822 810 12 1.45 0 6804 23 0 12
v_cancel_supplier_order 786 786 0 0.00 0 2149 9 0 0
v_cancel_write_off 2042 2042 0 0.00 0 2603 17 0 0
v_max_id_clo_ord 5699 5699 0 0.00 0 1597 1 0 0
v_max_id_clo_res 1071 1071 0 0.00 0 3854 9 0 0
v_max_id_ord_sup 5679 5679 0 0.00 0 1237 2 0 0
v_max_non_paid_invoice 1547 1547 0 0.00 0 842 3 0 0
v_max_non_paid_realizn 3807 3807 0 0.00 0 2727 3 0 0
v_min_id_clo_ord 5699 5699 0 0.00 0 3564 8 0 0
v_min_id_clo_res 1071 1071 0 0.00 0 2333 5 0 0
v_min_id_ord_sup 5679 5679 0 0.00 0 3494 3 0 0
v_min_non_paid_invoice 6192 6192 0 0.00 0 11121 14 0 0
v_min_non_paid_realizn 7380 7380 0 0.00 0 6700 13 0 0
v_our_firm 10476 10476 0 0.00 0 13 1 0 0
v_reserve_write_off 20550 20550 0 0.00 0 8737 8 0 0
x_lock_depdocs_on_canc_invoice 11747 11747 0 0.00 0 26442 128 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 25144 475 0 0
x_make_qstorno_1000_1200 5699 5699 0 0.00 1 24105 1198 0 0
x_make_qstorno_1200_2000 5681 5681 0 0.00 3 123032 3354 0 0
x_make_qstorno_2100_3300 483421 483421 0 0.00 0 165576 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-02-2021 19:28:01 to 02-02-2021 19: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
16:57:20 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:27 12531 8192000000 10212313024 10509004800 902750848 9.926 72 55 111 0 923968496 2436208 18781440
16:57:47 34407 8192000000 10339707472 10650824704 1376533072 14.386 100 89 178 0 1409549536 4202528 28813936
16:58:36 25831 8192000000 10362046544 10680623104 1417652624 14.752 100 92 184 0 1455038528 6457648 30928256
16:59:12 27539 8192000000 10380204320 10702254080 1432420496 14.883 100 81 162 0 1466094032 6952960 26720576
16:59:53 25874 8192000000 10412421056 10738298880 1462396832 15.147 100 87 174 0 1498614480 7783664 28433984
17:00:30 18175 8192000000 10421369680 10750795776 1476937776 15.275 100 83 166 0 1512694896 8438992 27318128
17:00:59 21257 8192000000 10448774352 10784579584 1502090928 15.494 100 84 168 0 1537737136 8699408 26946800
17:01:31 11901 8192000000 10468711712 10807615488 1525940832 15.702 100 84 168 1 1561737456 8962688 26833936
17:01:52 23320 8192000000 10493512512 10842566656 1540455744 15.828 100 72 144 1 1572739248 8701488 23582016
17:02:25 17714 8192000000 10522111856 10874163200 1578859088 16.158 100 79 158 1 1612643936 8957728 24827120
17:02:55 13020 8192000000 10535656096 10891694080 1598447008 16.326 100 73 148 0 1630078512 9315232 22316272
17:03:18 10200 8192000000 10561785296 10919505920 1617831888 16.491 100 71 140 1 1648355376 9311680 21211808
17:03:37 10841 8192000000 10580635184 10946482176 1643325904 16.708 100 75 150 1 1675938736 9908464 22704368
17:03:57 11105 8192000000 10602906192 10968961024 1657135904 16.825 100 66 133 1 1686566288 9603296 19827088
17:04:17 15023 8192000000 10616340560 10988134400 1683955104 17.051 100 73 144 1 1715572576 10844832 20772640
17:04:42 14764 8192000000 10663109776 11031379968 1708324528 17.255 100 84 168 1 1745332160 12392208 24615424
17:05:06 12204 8192000000 10670147552 11043684352 1730144848 17.437 100 77 154 0 1764790144 12843584 21801712
17:05:28 11704 8192000000 10690266624 11059482624 1743702176 17.549 100 87 174 1 1781218736 13299488 24217072
17:05:46 7645 8192000000 10696970768 11070902272 1753565328 17.631 100 84 169 2 1790570976 13780224 23225424
17:06:01 5640 8192000000 10700920512 11080134656 1764009984 17.718 100 86 172 0 1802372832 14435968 23926880
17:06:14 2692 8192000000 10706531888 11086319616 1771824496 17.782 100 86 172 0 1809573856 14222560 23526800
17:06:27 3870 8192000000 10718239776 11097915392 1781866608 17.865 100 86 172 1 1818937520 13486992 23583920
17:06:40 2928 8192000000 10718161376 11098820608 1783051680 17.875 100 81 158 2 1819259632 14210032 21997920
17:06:51 5200 8192000000 10733156864 11112423424 1792245168 17.950 100 79 156 1 1825420032 11394816 21780048
17:07:04 3555 8192000000 10732789376 11118723072 1798719664 18.003 100 78 156 2 1832968976 12049360 22199952
17:07:14 3384 8192000000 10738190768 11125612544 1803344832 18.041 100 79 159 3 1838625440 12299328 22981280
17:07:25 2709 8192000000 10745730784 11123744768 1806574576 18.068 100 82 164 0 1842713904 12880912 23258416
17:07:35 3977 8192000000 10751470112 11135225856 1815017296 18.137 100 87 174 1 1852766288 13793920 23955072
17:07:45 7993 8192000000 10747695120 11135066112 1814884560 18.136 100 82 164 1 1852217232 15017216 22315456
17:08:00 5836 8192000000 10772815424 11156238336 1819959952 18.177 100 87 174 1 1859401584 15304656 24136976
17:08:12 4000 8192000000 10775049232 11159887872 1832928016 18.283 100 88 176 1 1873676816 15852144 24896656
17:08:23 3518 8192000000 10789794288 11170713600 1835049472 18.300 100 90 179 0 1875021728 15246176 24726080
17:08:33 2062 8192000000 10785350224 11171155968 1843000208 18.365 100 92 185 1 1882351760 13666352 25685200
17:08:41 2086 8192000000 10785121872 11175366656 1845106336 18.382 100 88 175 2 1883917264 14194720 24616208
17:08:50 1668 8192000000 10795076096 11180920832 1850931856 18.430 100 90 180 1 1888391552 11821504 25638192
17:08:58 2771 8192000000 10783959472 11174834176 1849597232 18.419 100 82 161 0 1885669472 13490464 22581776
17:09:07 2315 8192000000 10797325344 11181019136 1859910544 18.503 100 92 184 0 1898649168 13247264 25491360
17:09:16 1707 8192000000 10802642160 11188088832 1855002800 18.463 100 91 179 0 1894414784 13767024 25644960
17:09:25 1706 8192000000 10805432112 11190964224 1859075888 18.496 100 87 171 1 1897212800 13137776 24999136
17:09:33 2185 8192000000 10799758736 11190530048 1859911104 18.503 100 84 168 1 1896423712 12889184 23623424
17:09:41 2452 8192000000 10805061520 11195539456 1861291344 18.514 100 89 178 0 1899716256 13407312 25017600
17:09:50 17147 8192000000 10788178416 11191013376 1863937392 18.535 100 70 140 0 1895231872 11975232 19319248
17:10:22 1566 8192000000 10823651056 11210579968 1872381824 18.604 100 86 172 1 1909591024 12554256 24654944
17:10:30 2262 8192000000 10800241488 11198222336 1871339312 18.595 100 72 144 2 1904769504 13721792 19708400
17:10:38 3945 8192000000 10794632128 11203887104 1867530960 18.564 100 52 104 2 1894089632 11579552 14979120
17:10:49 7647 8192000000 10776725728 11197956096 1869243536 18.578 100 38 75 2 1888542208 9424192 9874480
17:11:04 6026 8192000000 10791424848 11197591552 1870810336 18.591 100 33 65 4 1887546208 7252672 9483200
17:11:17 58292 8192000000 10813161712 11216195584 1877438576 18.644 100 56 111 2 1899173824 5916560 15818688
17:12:21 7014 8192000000 10832894320 11229446144 1886582352 18.718 100 72 144 3 1917130352 11209952 19338048
17:12:35 3929 8192000000 10794990352 11226316800 1881994032 18.681 100 33 66 1 1900825600 10027088 8804480
17:12:50 6363 8192000000 10808296080 11230298112 1887464896 18.725 100 27 53 4 1901398672 5676240 8257536
17:13:02 8540 8192000000 10803810688 11230285824 1890290592 18.748 100 25 49 2 1903886624 6485536 7110496
17:13:23 5891 8192000000 10801575040 11232907264 1895482816 18.790 100 27 54 1 1910794432 6878240 8433376
17:13:35 6382 8192000000 10810336816 11237867520 1896701680 18.800 100 27 54 0 1911727808 6689232 8336896
17:13:47 13255 8192000000 10816623744 11246501888 1901401264 18.838 100 23 46 1 1917563312 10219760 5942288
17:14:11 8601 8192000000 10817327232 11244466176 1898213472 18.812 100 20 40 0 1909676560 5406784 6056304
17:14:33 7410 8192000000 10814392080 11243917312 1901429184 18.838 100 28 55 4 1916261184 6759024 8072976
17:14:46 9526 8192000000 10811340032 11243790336 1899411232 18.822 100 12 24 0 1907772384 4959472 3401680
17:15:07 10588 8192000000 10808125088 11244756992 1900903776 18.834 100 18 36 1 1912353008 5926768 5522464
17:15:25 9045 8192000000 10811831584 11247276032 1901459472 18.838 100 18 37 0 1912274896 5610048 5205376
17:15:40 10205 8192000000 10807620544 11247034368 1901082240 18.835 100 15 30 0 1911679664 6481840 4115584
17:15:57 67099 8192000000 10833719472 11257630720 1910154816 18.908 100 37 73 1 1926339792 5009072 11175904
17:17:10 15733 8192000000 10814981888 11254542336 1893913456 18.777 99 14 28 0 1903044144 5195248 3935440
17:17:37 4918 8192000000 10835007632 11259346944 1908693952 18.896 100 42 84 4 1927725248 7422848 11608448
17:17:51 7370 8192000000 10815907472 11248410624 1888780240 18.736 99 21 40 1 1901267520 6360560 6126720
17:18:05 6134 8192000000 10822502080 11261202432 1906880960 18.882 100 33 66 0 1927688752 11659360 9148432
17:18:20 8024 8192000000 10802342096 11236376576 1864354688 18.539 98 20 39 1 1875208368 5909824 4943856
17:18:38 7824 8192000000 10810309456 11244544000 1897218416 18.804 100 28 56 1 1913079248 7574720 8286112
17:18:52 6415 8192000000 10815254464 11246702592 1880350240 18.668 99 29 58 0 1896141072 7888192 7902640
17:19:05 6594 8192000000 10811434032 11236839424 1875812944 18.631 99 24 48 0 1888868208 6352752 6702512
17:19:23 7732 8192000000 10783314736 11222167552 1869517408 18.580 99 23 46 0 1882774256 6149728 7107120
17:19:39 8036 8192000000 10802541808 11228098560 1879678256 18.663 100 25 48 1 1892181056 5656608 6846192
17:19:57 10008 8192000000 10768741344 11189469184 1787035840 17.907 95 22 44 0 1798296304 5309648 5950816
17:20:19 8388 8192000000 10750872080 11173883904 1791970512 17.948 97 14 28 2 1801290576 5285120 4034944
17:20:35 8292 8192000000 10748743440 11181342720 1821452688 18.190 99 22 44 1 1833617568 5908656 6256224
17:20:53 53147 8192000000 10695538992 11111464960 1691296656 17.112 93 35 70 1 1705967456 4461472 10209328
17:21:58 17686 8192000000 10691391296 11107942400 1702843616 17.209 94 21 42 2 1713772448 5030912 5897920
17:22:22 10275 8192000000 10713127088 11121295360 1714121472 17.303 95 32 63 4 1729026288 5732432 9172384
17:22:38 6454 8192000000 10686296128 11081195520 1707241248 17.246 95 36 72 0 1724587936 6896576 10450112
17:22:51 4724 8192000000 10716409360 11131912192 1796979712 17.989 100 29 57 3 1812892784 7372368 8540704
17:23:02 4685 8192000000 10736017968 11143184384 1804052384 18.047 100 36 72 4 1821565456 6955808 10557264
17:23:13 8198 8192000000 10687700528 11102679040 1739132928 17.511 96 29 59 2 1757292464 10013968 8145568
17:23:30 4372 8192000000 10712265744 11129413632 1781679712 17.863 99 21 42 0 1793526784 6083072 5764000
17:23:41 6668 8192000000 10695848592 11110395904 1760487040 17.688 98 27 54 0 1773844608 5470384 7887184
17:23:54 5948 8192000000 10706408480 11123544064 1765098304 17.727 98 27 54 1 1778405120 5325008 7981808
17:24:06 6183 8192000000 10713013152 11123642368 1780668752 17.855 99 23 46 3 1793969808 5796048 7505008
17:24:22 7292 8192000000 10730767184 11144998912 1795400512 17.976 99 23 46 1 1808027312 5524624 7102176
17:24:38 11155 8192000000 10753011104 11168100352 1827820000 18.242 100 35 70 0 1844160048 6257456 10082592
17:24:56 8076 8192000000 10749649520 11167211520 1819217712 18.171 99 43 87 2 1838649072 5017680 14413680
17:25:11 10524 8192000000 10747165808 11178250240 1834349056 18.295 100 16 32 0 1844226544 5195920 4681568
17:25:30 11227 8192000000 10751832400 11183116288 1843293248 18.368 100 18 35 0 1853895568 5909440 4692880
17:25:49 15412 8192000000 10779256752 11192143872 1853524416 18.451 100 38 75 2 1870909456 5523760 11861280
17:26:10 66705 8192000000 10777401472 11198033920 1838712608 18.330 99 34 68 1 1854126176 5708352 9705216
17:27:26 4072 8192000000 10818565152 11224117248 1880702192 18.671 100 58 116 0 1904176816 6329808 17144816
17:27:39 38219 8192000000 10823307152 11232313344 1886737616 18.719 100 55 108 2 1911271696 8596592 15937488
17:28:28 8671 8192000000 10829071360 11241877504 1892451632 18.766 100 53 104 1 1917122480 9409632 15261216
17:28:43 9093 8192000000 10824954544 11244400640 1898178800 18.812 100 49 94 0 1921528560 9591184 13758576
17:29:05 6816 8192000000 10830714656 11254292480 1901686832 18.840 100 51 101 1 1926063600 9560352 14816416
17:29:22 10372 8192000000 10841464528 11258294272 1907699264 18.888 100 49 98 1 1930800768 9090448 14011056
17:29:46 24329 8192000000 10844467120 11269660672 1913110672 18.932 100 44 89 2 1934360912 8732496 12517744
17:30:28 29206 8192000000 10849701312 11279130624 1925510176 19.031 100 50 100 1 1949894816 9983024 14401616
17:31:05 45423 8192000000 10868445664 11300118528 1930931440 19.074 100 47 94 2 1960606448 16434960 13240048
17:32:08 34236 8192000000 10858518080 11298361344 1935212416 19.109 100 41 78 0 1959568304 13208144 11147744
17:32:51 16687 8192000000 10864830800 11303886848 1939618864 19.144 100 35 69 2 1963762096 13564960 10578272
17:33:17 36388 8192000000 10887077280 11315548160 1941065056 19.155 100 31 62 1 1964737600 14301216 9371328
17:34:07 11822 8192000000 10893504112 11321135104 1949156304 19.220 100 45 90 2 1980264704 17158832 13949568
17:34:29 15021 8192000000 10894796960 11328491520 1954787296 19.265 100 48 95 0 1990587808 21418688 14381824
17:34:54 14613 8192000000 10890333456 11327619072 1956642288 19.279 100 41 80 1 1989259680 20077632 12539760
17:35:16 13398 8192000000 10907437440 11333238784 1959266864 19.300 100 37 73 1 1987824416 16647280 11910272
17:35:38 13043 8192000000 10906262048 11340345344 1965549952 19.350 100 43 84 1 1995534496 17341424 12643120
17:35:58 15821 8192000000 10920948960 11352223744 1973553424 19.414 100 51 103 0 2006647472 18387984 14706064
17:36:24 3489 8192000000 10927634864 11354021888 1982134640 19.482 100 68 136 1 2020049152 17974128 19940384
17:36:35 24591 8192000000 10930966992 11361918976 1982330896 19.483 100 69 139 1 2023830432 21346272 20153264
17:37:07 7149 8192000000 10935978752 11364962304 1988024032 19.528 100 74 146 0 2030520160 21464704 21031424
17:37:30 4281 8192000000 10949239328 11371347968 1990404368 19.547 100 70 139 0 2030175376 20235696 19535312
17:37:40 2824 8192000000 10953161760 11375480832 1995257088 19.585 100 78 154 3 2040006752 22972384 21777280
17:37:53 5956 8192000000 10949443952 11378462720 1996173120 19.593 100 69 136 2 2039851056 23693232 19984704
17:38:07 3736 8192000000 10962264048 11383128064 1998185280 19.608 100 64 126 1 2040316176 23878976 18251920
17:38:18 9106 8192000000 10959587168 11388542976 2003127168 19.647 100 71 141 1 2048936416 25173344 20635904
17:38:37 19978 8192000000 10964624864 11394510848 2010318160 19.704 100 56 111 0 2050766704 23918576 16529968
17:39:07 3230 8192000000 10980577392 11399663616 2012855632 19.724 100 68 134 3 2056378688 23721264 19801792
17:39:17 1815 8192000000 10986763312 11404374016 2016570576 19.753 100 78 157 3 2064899168 25118000 23210592
17:39:26 24377 8192000000 10970379232 11407192064 2016780368 19.755 100 61 123 0 2059358176 23915584 18662224
17:40:02 9278 8192000000 10959125888 11398782976 1998047488 19.607 99 52 103 0 2037881776 24310832 15523456
17:40:20 12574 8192000000 10964717632 11404443648 2015998928 19.749 100 59 118 2 2060110288 25880864 18230496
17:40:42 13586 8192000000 10974202672 11416645632 2018141840 19.766 100 46 92 2 2065122960 33044624 13936496
17:41:06 9346 8192000000 10972861600 11411349504 2016486896 19.753 100 50 100 1 2059883824 28422160 14974768
17:41:28 4925 8192000000 10989139952 11423612928 2024245168 19.813 100 57 114 1 2072034240 30033360 17755712
17:41:51 1652 8192000000 10977436848 11409436672 2014146224 19.734 99 64 127 2 2063105408 29771120 19188064
17:42:00 4145 8192000000 10992241200 11422076928 2028096976 19.844 100 71 144 2 2080041344 30336912 21607456
17:42:13 3262 8192000000 10998256032 11429830656 2029064544 19.851 100 68 133 1 2079974720 30367152 20543024
17:42:25 2270 8192000000 11008908608 11434926080 2037415616 19.917 100 77 151 2 2090043456 30551712 22076128
17:42:35 3126 8192000000 11003566944 11434487808 2036447040 19.909 100 76 151 2 2090772176 31360256 22964880
17:42:49 1944 8192000000 11018874368 11438678016 2041372448 19.948 100 94 185 3 2098165328 29149712 27643168
17:42:59 7261 8192000000 11016279440 11440795648 2042112736 19.953 100 89 175 2 2100829168 31159568 27556864
17:43:15 9543 8192000000 10997977760 11436756992 2038883152 19.928 100 65 130 3 2090355456 31560848 19911456
17:43:34 5020 8192000000 11010603488 11442659328 2042801168 19.959 100 71 142 1 2097522368 32926800 21794400
17:43:48 8856 8192000000 11011114592 11440734208 2035712272 19.903 100 58 116 1 2088087536 34123040 18252224
17:44:09 5244 8192000000 11007271904 11443163136 2038651296 19.926 100 60 119 1 2091963872 34459440 18853136
17:44:21 4088 8192000000 11008198752 11444494336 2051330160 20.026 100 76 150 0 2107371648 32848896 23192592
17:44:33 6322 8192000000 11005783840 11443077120 2044631952 19.973 100 65 130 2 2099679680 33948080 21099648
17:44:49 3433 8192000000 11032477840 11454857216 2051290736 20.025 100 76 149 3 2110638768 36254320 23093712
17:45:02 5046 8192000000 11027538704 11458768896 2053269328 20.041 100 82 164 1 2118155744 38818608 26067808
17:45:15 4215 8192000000 11026691472 11461120000 2053418384 20.042 100 73 149 0 2116340400 40557536 22364480
17:45:27 3531 8192000000 11022649792 11455926272 2045686832 19.981 100 75 150 2 2110565664 41497760 23381072
17:45:41 3102 8192000000 11027991456 11461599232 2046188352 19.985 100 67 134 2 2110375744 42655200 21532192
17:45:57 2339 8192000000 11031963360 11457941504 2048563712 20.004 100 74 149 0 2110407264 38426048 23417504
17:46:09 5216 8192000000 11030062880 11459989504 2047379728 19.995 100 75 149 1 2110194976 39682368 23132880
17:46:21 5649 8192000000 11025742112 11455639552 2046610192 19.989 100 80 160 0 2112962976 41385888 24966896
17:46:35 3870 8192000000 10988523904 11417456640 1999502784 19.619 98 71 141 3 2063344320 40523696 23317840
17:46:47 3059 8192000000 11003086608 11434582016 2025647584 19.824 100 62 124 0 2085865296 39905120 20312592
17:46:57 4715 8192000000 11008864176 11436642304 2013871392 19.732 99 76 148 2 2078712656 40847680 23993584
17:47:09 2525 8192000000 10998319216 11414097920 1996694800 19.597 98 81 159 1 2061173280 39932144 24546336
17:47:19 6890 8192000000 11013599952 11444346880 2030011008 19.859 100 79 159 0 2097678576 42704512 24963056
17:47:32 3081 8192000000 11023530384 11449597952 2037837968 19.920 100 76 153 0 2104387232 43233072 23316192
17:47:43 2086 8192000000 11033367552 11455959040 2042805520 19.959 100 85 170 0 2113681504 45084976 25791008
17:47:53 1689 8192000000 11033042112 11456126976 2037513392 19.917 100 87 174 0 2111747680 46466288 27768000
17:48:03 5294 8192000000 11025129072 11447898112 2031836592 19.873 100 81 163 3 2104940944 47583984 25520368
17:48:17 1562 8192000000 11032238576 11449913344 2031170240 19.868 100 91 180 0 2108265120 48640240 28454640
17:48:26 3004 8192000000 11016619136 11444666368 2012329456 19.720 99 88 172 2 2094166432 53616112 28220864
17:48:37 2148 8192000000 11014587072 11429371904 2000902768 19.630 99 93 186 2 2079526896 48814864 29809264
17:48:46 2214 8192000000 10987732928 11401187328 1976365216 19.436 98 93 186 2 2056708160 50831616 29511328
17:48:55 2455 8192000000 11000283872 11419684864 2000866656 19.630 100 84 166 1 2078773680 51035392 26871632
17:49:05 3069 8192000000 10993999536 11411963904 1993025248 19.568 100 89 177 0 2073438608 52475792 27937568
17:49:16 3676 8192000000 10976325296 11390316544 1977400480 19.444 99 86 171 0 2055771952 51248944 27122528
17:49:28 1173 8192000000 10998596384 11411185664 1996289008 19.593 100 84 168 0 2071690592 48916304 26485280
17:49:35 3107 8192000000 10976406544 11405254656 1990376560 19.547 100 75 148 1 2061714656 47931920 23406176
17:49:51 17101 8192000000 10951076032 11397394432 1977352832 19.444 100 36 70 4 2033277824 43472256 12452736
17:50:15 4281 8192000000 10991844064 11411607552 1995850592 19.590 100 66 129 3 2062065136 44219824 21994720
17:50:29 2062 8192000000 10992874672 11413258240 2001085168 19.631 100 72 140 2 2072622432 48358752 23178512
17:50:39 4440 8192000000 10997089520 11413770240 1983103312 19.489 99 82 163 1 2059447488 50706640 25637536
17:50:51 2941 8192000000 11007455040 11425525760 2004500496 19.658 100 83 162 2 2081369808 51031120 25838192
17:51:01 2570 8192000000 11016745616 11433218048 2012328128 19.720 100 83 166 0 2092701264 54354816 26018320
17:51:11 6203 8192000000 10991668160 11412221952 1993351968 19.570 99 76 152 1 2072803968 54818944 24633056
17:51:24 7008 8192000000 10988797872 11421908992 1983010720 19.489 99 59 118 1 2059215328 56556384 19648224
17:51:38 4192 8192000000 10988958224 11421855744 1980664464 19.470 99 63 126 1 2060581968 58819920 21097584
17:51:53 3584 8192000000 11009176608 11434246144 2004709280 19.660 100 81 160 0 2090562640 59328736 26524624
17:52:07 2697 8192000000 11022790784 11443679232 2009556448 19.698 100 84 168 1 2099333424 62562704 27214272
17:52:18 5042 8192000000 10997226048 11428737024 2002041152 19.639 100 70 140 1 2081193792 56496112 22656528
17:52:31 8923 8192000000 10990025520 11434868736 2000755808 19.629 100 49 97 1 2071995936 55146208 16093920
17:52:55 5279 8192000000 10974312912 11412267008 1980069408 19.465 99 41 82 3 2046152576 51669632 14413536
17:53:19 7383 8192000000 10956280544 11393998848 1953864272 19.257 98 57 114 2 2018943088 46496432 18582384
17:53:35 3035 8192000000 10989538928 11413499904 1991631216 19.557 100 69 136 1 2061965232 48198912 22135104
17:53:45 2267 8192000000 10999900752 11425849344 2003905424 19.654 100 76 152 0 2083309008 54321920 25081664
17:53:54 12199 8192000000 10988156608 11435814912 1999921168 19.622 100 55 110 2 2074856784 56314800 18620816
17:54:22 7505 8192000000 10974706304 11429859328 1994763952 19.581 100 46 92 3 2060906960 50730176 15412832
17:54:40 8538 8192000000 10971530480 11428229120 1993269952 19.570 100 35 70 2 2055655360 50388640 11996768
17:55:24 14641 8192000000 10955462528 11417776128 1984888368 19.503 100 27 54 2 2043617248 48916608 9812272
17:55:45 17193 8192000000 10960796240 11419664384 1979955504 19.464 100 25 50 2 2041770752 52497088 9318160
17:56:09 20878 8192000000 10953005312 11413962752 1970087680 19.386 100 24 48 1 2032670912 53406896 9176336
17:56:38 8208 8192000000 10965000672 11421302784 1979790208 19.463 100 22 44 0 2041164752 53380976 7993568
17:57:04 22808 8192000000 10955914768 11417931776 1971937952 19.401 100 19 38 2 2036820352 57922912 6959488
17:57:33 14723 8192000000 10931169728 11405062144 1944252240 19.181 99 17 34 0 2001264864 50603776 6408848
17:57:55 23973 8192000000 10929473024 11412037632 1940143568 19.148 99 16 32 0 1993572816 47670928 5758320
17:58:32 19699 8192000000 10910024640 11405799424 1958979600 19.298 100 6 12 0 1997995392 37118432 1897360
17:58:59 57814 8192000000 10921533024 11381383168 1951432784 19.238 99 8 16 1 1971320608 17386640 2501184
18:00:05 168011 8192000000 10884865152 11331522560 1804377888 18.050 92 12 22 0 1822299232 15497952 2423392
18:03:02 141037 8192000000 10921350512 11364012032 1945807456 19.193 99 41 82 0 1970891568 12909792 12174320
18:05:45 55150 8192000000 10849118848 11307982848 1832954816 18.283 94 15 30 2 1849114128 12130256 4029056
18:07:05 37179 8192000000 10830280944 11279052800 1809868976 18.095 94 36 72 0 1830020688 10146432 10005280
18:07:48 61971 8192000000 10890075040 11332096000 1927200720 19.044 100 48 97 0 1955748768 14376064 14171984
18:09:01 185714 8192000000 10884133600 11348185088 1896519616 18.798 98 16 32 1 1913292576 11501712 5271248
18:12:13 39690 8192000000 10906075136 11349291008 1937345632 19.126 99 25 49 2 1955177168 10269568 7561968
18:12:59 16282 8192000000 10922098816 11367620608 1970227584 19.387 100 65 128 2 1998264368 9224752 18812032
18:13:31 5081 8192000000 10930457216 11366797312 1977559264 19.445 100 70 140 4 2006360672 9781920 19019488
18:13:42 5828 8192000000 10921217040 11374682112 1975047568 19.425 100 51 102 0 2008277168 18577744 14651856
18:14:12 28563 8192000000 10884690192 11352776704 1939580128 19.143 99 14 28 0 1955746032 12091328 4074576
18:14:49 114994 8192000000 10828928384 11299274752 1815715472 18.143 93 12 24 0 1831912320 12582944 3613904
18:16:55 50758 8192000000 10846537024 11309182976 1903369600 18.853 99 17 34 2 1920003520 12071136 4562784
18:17:52 54432 8192000000 10875424032 11348086784 1941001888 19.155 100 17 34 0 1961403200 14901936 5499376
18:18:56 146354 8192000000 10863043376 11342381056 1928197392 19.052 99 23 46 0 1958363104 23344400 6821312
18:21:30 1775 8192000000 10896427280 11349438464 1958311744 19.293 100 61 122 1 1984002144 7854768 17835632
18:21:39 33103 8192000000 10887958336 11358052352 1954833232 19.265 100 23 46 0 1970560928 9456640 6271056
18:22:35 56840 8192000000 10886041440 11356262400 1936334432 19.117 99 10 20 0 1947863424 8773904 2755088
18:23:39 54472 8192000000 10878034368 11362803712 1943991312 19.179 99 23 46 1 1964405648 13555104 6859232
18:24:39 61632 8192000000 10879343776 11361820672 1955568560 19.271 100 17 34 1 1975375744 14752320 5054864
18:25:50 64075 8192000000 10875375760 11345911808 1913787568 18.937 98 18 37 1 1932778432 13681248 5309616
18:27:12 29078 8192000000 10909237648 11364139008 1949251424 19.221 99 26 52 1 1965051936 8211760 7588752
18:27:51 36285 8192000000 10913708480 11376181248 1981267296 19.475 100 35 67 2 2000451568 9737728 9446544
18:28:41 77562 8192000000 10885218880 11354415104 1884936688 18.705 95 11 22 1 1900277888 12215568 3125632
18:30:10 64421 8192000000 10903518608 11360681984 1926764256 19.041 98 11 22 2 1938889536 9152576 2972704
18:31:25 25128 8192000000 10910053936 11361329152 1942888704 19.170 98 39 78 3 1964227072 10098592 11239776
18:32:07 46323 8192000000 10874645072 11348303872 1922114784 19.004 98 22 44 2 1940243568 11770160 6358624
18:33:05 75015 8192000000 10891840704 11353522176 1902066208 18.843 97 20 39 0 1919029280 11954784 5008288
18:34:27 121796 8192000000 10888742208 11360964608 1840357472 18.344 94 12 24 1 1857939968 14730352 2852144
18:36:53 95540 8192000000 10897001040 11364184064 1946047472 19.195 99 19 38 2 1967664000 16134752 5481776
18:38:40 108042 8192000000 10893685488 11372290048 1953957008 19.258 99 29 58 0 1988184928 24623056 9604864
18:40:36 22858 8192000000 10907051232 11382636544 1968530416 19.374 100 12 24 1 1987198080 14998544 3669120
18:41:06 16311 8192000000 10919798848 11364831232 1976371264 19.436 100 26 52 0 1997124080 13329184 7423632
18:41:35 64768 8192000000 10877813312 11356561408 1945062880 19.187 99 14 26 2 1957348704 8326352 3959472
18:42:55 32250 8192000000 10888198176 11358777344 1946136064 19.196 99 8 16 0 1955783264 7263360 2383840
18:43:39 41978 8192000000 10892761904 11352014848 1945233312 19.188 99 27 54 1 1960239936 7352896 7653728
18:44:40 39430 8192000000 10841723776 11318820864 1878247504 18.651 96 31 62 0 1895535712 8539200 8749008
18:45:32 48980 8192000000 10881676800 11347357696 1929135456 19.060 99 20 40 1 1940339472 6353216 4850800
18:46:36 88732 8192000000 10858667984 11323260928 1922744352 19.009 98 19 38 1 1935714592 7357744 5612496
18:48:18 103233 8192000000 10859497408 11349180416 1915566256 18.951 98 19 38 1 1935191840 13877248 5748336
18:50:11 31540 8192000000 10855300304 11332055040 1915926544 18.954 99 10 20 0 1931455536 13040192 2488800
18:50:51 46807 8192000000 10859553696 11345063936 1924423296 19.022 99 6 12 1 1941064240 14956368 1684576
18:52:10 67411 8192000000 10855169184 11338625024 1908642240 18.896 98 14 28 0 1924121856 11913424 3566192
18:53:24 50799 8192000000 10869208384 11347963904 1948326848 19.213 100 32 65 3 1966246064 8439664 9479552
18:54:22 58667 8192000000 10813529552 11277688832 1738923216 17.510 90 6 12 0 1748571792 8059696 1588880
18:55:31 57190 8192000000 10879152624 11338362880 1917502144 18.967 100 25 50 0 1939033072 13934624 7596304
18:56:40 43450 8192000000 10886845616 11344273408 1926960080 19.043 99 30 60 0 1952130176 16810784 8359312
18:58:11 65314 8192000000 10879193216 11355299840 1934159296 19.100 99 21 42 1 1953630080 13806336 5664448
18:59:22 83211 8192000000 10892021216 11345641472 1882362224 18.684 96 16 31 1 1898357088 11600752 4394112
19:01:01 47628 8192000000 10908416288 11363008512 1932829312 19.089 99 27 54 1 1953086256 12869616 7387328
19:01:57 48595 8192000000 10907878960 11362422784 1924254368 19.021 98 35 70 1 1944716448 10762464 9699616
19:02:56 26166 8192000000 10913153888 11373846528 1955346320 19.269 99 28 56 2 1974499776 11388288 7765168
19:03:28 68252 8192000000 10888743328 11371757568 1908573904 18.895 97 16 32 1 1929485216 16049584 4861728
19:04:48 75146 8192000000 10886691760 11368308736 1942243104 19.165 99 15 29 2 1963763840 17187648 4333088
19:06:09 99401 8192000000 10895499168 11353972736 1885363616 18.708 96 24 48 1 1902985680 11447632 6174432
19:07:54 41960 8192000000 10904792656 11360063488 1957433168 19.286 100 43 86 1 1984463376 14950752 12079456
19:08:43 35365 8192000000 10853080208 11328147456 1915066960 18.947 98 14 28 0 1931896096 13108240 3720896
19:10:10 58108 8192000000 10862293424 11349356544 1935356176 19.110 99 9 18 1 1945958544 8252480 2349888
19:11:27 70252 8192000000 10879853440 11349430272 1930007008 19.067 98 27 54 1 1949081984 11381248 7693728
19:12:48 105884 8192000000 10887185472 11369824256 1903521712 18.855 97 6 12 0 1919260032 14417904 1320416
19:14:40 56712 8192000000 10894927008 11367243776 1918049888 18.971 98 8 16 0 1933697216 13652320 1995008
19:16:00 31380 8192000000 10883988512 11353264128 1941499056 19.159 99 43 86 1 1966584384 13019696 12065632
19:16:39 48785 8192000000 10885179616 11364896768 1923110048 19.012 98 9 18 0 1940176048 14606976 2459024
19:17:37 81584 8192000000 10892311424 11347845120 1924646496 19.024 98 21 43 1 1948964816 17648336 6669984
19:19:08 35025 8192000000 10855477792 11330547712 1874993680 18.625 96 11 22 0 1889870704 11847824 3029200
19:19:49 21388 8192000000 10868983392 11318583296 1909270656 18.901 99 31 60 0 1924966640 7217152 8478832
19:20:19 31228 8192000000 10872905408 11329871872 1880633520 18.670 97 37 74 1 1899644848 9246640 9764688
19:21:23 60313 8192000000 10878201008 11331137536 1901433424 18.838 98 18 36 1 1916336672 9599808 5303440
19:22:34 11090 8192000000 10908840256 11352567808 1951211744 19.236 100 47 94 1 1975413792 10349504 13852544
19:22:56 22092 8192000000 10891116256 11351842816 1938164800 19.132 99 42 84 1 1962374768 12788144 11421824
19:23:34 104509 8192000000 10852489520 11337109504 1824039184 18.211 94 26 52 0 1845177088 13748144 7389760
19:25:28 44741 8192000000 10885151344 11355004928 1910269280 18.909 98 23 46 1 1926069024 9564528 6235216
19:26:19 62618 8192000000 9444257888 9740902400 587798256 6.694 31 3 6 1 592000464 3438560 763648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 02-02-2021 19:28:07 to 02-02-2021 19:28:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 108 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-02-2021 19:28:40 to 02-02-2021 19:28:42.

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

02.02.21 19:28:43. 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-02 19:28:46 No severe PSQL-related problems occured
02.02.21 19:28:47. End of report.