Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.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 17125752 kB
MemAvailable 31168848 kB
Buffers 0 kB
Cached 14555888 kB
SwapCached 4772 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-11 19:27:35
DTS_END                         2021-02-11 19:27:18.3200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58236
TRN_ID                          237195
ATT_ID                          274
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: 9159.33 22462 1099119
customer order: creation 176.96 356 21235
customer order: refuse 14.74 371 1769
order to supplier: creation 46.97 1260 5636
order to supplier: removal 3.32 103541 398
invoice (draft): creation 46.41 3741 5569
invoice (draft): removal 51.62 756 6194
invoice accept: apply 41.42 18989 4970
invoice accept: cancel 47.17 804 5660
customer reserve: creation 3843.76 186 461251
customer reserve: removal 4584.43 58 550131
realization accept: apply 86.18 177 10342
realization accept: cancel 83.53 107 10024
payment from customer: creation 60.97 106 7316
payment from customer: removal 6.48 85 777
payment to supplier: creation 49.45 132 5934
payment to supplier: removal 3.49 82 419
service: total inventory turnovers 4.74 1246 569
service: total monetary turnovers 6.92 47 830
service: aggregate perf. data 0.76 23908 91
service: refresh index statistics 0.03 293279 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-02-2021 19:28:17 to 11-02-2021 19:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6691
TEST_TIME 2 6465
TEST_TIME 3 5553
TEST_TIME 4 5877
TEST_TIME 5 6445
TEST_TIME 6 5949
TEST_TIME 7 6086
TEST_TIME 8 5914
TEST_TIME 9 6058
TEST_TIME 10 6180
TEST_TIME 11 6427
TEST_TIME 12 6707
TEST_TIME 13 7019
TEST_TIME 14 7376
TEST_TIME 15 7676
TEST_TIME 16 7671
TEST_TIME 17 8185
TEST_TIME 18 8684
TEST_TIME 19 8659
TEST_TIME 20 8819
TEST_TIME 21 8727
TEST_TIME 22 8653
TEST_TIME 23 8984
TEST_TIME 24 9170
TEST_TIME 25 9330
TEST_TIME 26 9965
TEST_TIME 27 10153
TEST_TIME 28 10726
TEST_TIME 29 10554
TEST_TIME 30 10332
TEST_TIME 31 10382
TEST_TIME 32 10208
TEST_TIME 33 10172
TEST_TIME 34 10109
TEST_TIME 35 9998
TEST_TIME 36 9885
TEST_TIME 37 9878
TEST_TIME 38 9739
TEST_TIME 39 9653
TEST_TIME 40 9622
TEST_TIME 41 9726
TEST_TIME 42 9748
TEST_TIME 43 9622
TEST_TIME 44 9656
TEST_TIME 45 9623
TEST_TIME 46 9769
TEST_TIME 47 9776
TEST_TIME 48 9898
TEST_TIME 49 9802
TEST_TIME 50 9795
TEST_TIME 51 9963
TEST_TIME 52 9853
TEST_TIME 53 9854
TEST_TIME 54 9920
TEST_TIME 55 9945
TEST_TIME 56 9900
TEST_TIME 57 9968
TEST_TIME 58 9961
TEST_TIME 59 9989
TEST_TIME 60 9928
TEST_TIME 61 9817
TEST_TIME 62 9816
TEST_TIME 63 9725
TEST_TIME 64 9683
TEST_TIME 65 9657
TEST_TIME 66 9666
TEST_TIME 67 9614
TEST_TIME 68 9529
TEST_TIME 69 9460
TEST_TIME 70 9428
TEST_TIME 71 9464
TEST_TIME 72 9580
TEST_TIME 73 9587
TEST_TIME 74 9625
TEST_TIME 75 9693
TEST_TIME 76 9683
TEST_TIME 77 9709
TEST_TIME 78 9651
TEST_TIME 79 9708
TEST_TIME 80 9638
TEST_TIME 81 9531
TEST_TIME 82 9503
TEST_TIME 83 9492
TEST_TIME 84 9433
TEST_TIME 85 9392
TEST_TIME 86 9315
TEST_TIME 87 9241
TEST_TIME 88 9245
TEST_TIME 89 9237
TEST_TIME 90 9297
TEST_TIME 91 9314
TEST_TIME 92 9322
TEST_TIME 93 9377
TEST_TIME 94 9400
TEST_TIME 95 9437
TEST_TIME 96 9435
TEST_TIME 97 9482
TEST_TIME 98 9433
TEST_TIME 99 9475
TEST_TIME 100 9452
TEST_TIME 101 9522
TEST_TIME 102 9525
TEST_TIME 103 9437
TEST_TIME 104 9414
TEST_TIME 105 9388
TEST_TIME 106 9371
TEST_TIME 107 9384
TEST_TIME 108 9348
TEST_TIME 109 9328
TEST_TIME 110 9307
TEST_TIME 111 9270
TEST_TIME 112 9203
TEST_TIME 113 9230
TEST_TIME 114 9200
TEST_TIME 115 9175
TEST_TIME 116 9167
TEST_TIME 117 9238
TEST_TIME 118 9232
TEST_TIME 119 9226
TEST_TIME 120 9165

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-02-2021 19:28:21 to 11-02-2021 19:28:24.

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 1526518 1526518 0 0.00 0 26079 7 0 0
doc_list_biud 1526510 1526510 0 0.00 0 76883 27 0 0
sp_add_invoice_to_stock 5053 4970 83 1.64 57 229531 18989 0 83
sp_cancel_adding_invoice 5660 5660 0 0.00 4 66118 804 0 0
sp_cancel_client_order 1769 1769 0 0.00 4 9790 372 0 0
sp_cancel_customer_reserve 550131 550131 0 0.00 1 76885 59 0 0
sp_cancel_pay_from_customer 777 777 0 0.00 2 18498 86 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 2649 83 0 0
sp_cancel_supplier_invoice 6202 6194 8 0.12 1 16220 756 0 8
sp_cancel_supplier_order 398 398 0 0.00 16 927504 103541 0 0
sp_cancel_write_off 10024 10024 0 0.00 1 14272 108 0 0
sp_client_order 21235 21235 0 0.00 3 28570 357 0 0
sp_customer_reserve 461251 461251 0 0.00 0 54235 187 0 0
sp_fill_shopping_cart 32427 32427 0 0.00 1 34673 43 0 0
sp_fill_shopping_cart_clo_res 461241 461241 0 0.00 0 12909 14 0 0
sp_get_clo_for_invoice 4960 4960 0 0.00 0 14449 330 0 0
sp_kill_cost_storno 16880 16880 0 0.00 0 18484 56 0 0
sp_kill_qstorno_ret_qs2qd 1116878 1116878 0 0.00 0 75618 32 0 0
sp_kill_qty_storno 589478 589478 0 0.00 0 76883 69 0 0
sp_lock_selected_doc 21266 21266 0 0.00 0 9077 6 0 0
sp_make_cost_storno 28552 28552 0 0.00 0 18493 50 0 0
sp_multiply_rows_for_pdistr 28552 28552 0 0.00 0 18520 33 0 0
sp_multiply_rows_for_qdistr 21235 21235 0 0.00 0 17707 184 0 0
sp_pay_from_customer 7316 7316 0 0.00 4 18535 106 0 0
sp_pay_to_supplier 5934 5934 0 0.00 5 36585 132 0 0
sp_payment_common 13250 13250 0 0.00 1 36580 31 0 0
sp_qd_handle_on_cancel_clo 1769 1769 0 0.00 0 9174 339 0 0
sp_qd_handle_on_invoice_upd_sts 10620 10620 0 0.00 0 34870 343 0 0
sp_qd_handle_on_reserve_upd_sts 10342 10342 0 0.00 0 17951 58 0 0
sp_reserve_write_off 10342 10342 0 0.00 6 18525 177 0 0
sp_supplier_invoice 5569 5569 0 0.00 5 97520 3742 0 0
sp_supplier_order 5636 5636 0 0.00 6 34683 1261 0 0
srv_aggregate_perf_data 92 91 1 1.08 2666 694291 23908 0 1
srv_fill_mon_cache_memory 173 173 0 0.00 929 130325 29668 0 0
srv_find_qd_qs_mism 1050782 1050782 0 0.00 0 15463 6 0 0
srv_make_invnt_saldo 569 569 0 0.00 27 59304 1247 0 0
srv_make_money_saldo 830 830 0 0.00 0 7854 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 143506 421465 293279 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 8 8 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 4970 4970 0 0.00 0 16471 181 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 0 2622 58 0 0
t$perf-norm:sp_cancel_client_order 1769 1769 0 0.00 0 3395 13 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 4700 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 777 777 0 0.00 0 972 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 16164 56 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 3873 28 0 0
t$perf-norm:sp_cancel_supplier_order 398 398 0 0.00 0 29580 1539 0 0
t$perf-norm:sp_cancel_write_off 1050 1050 0 0.00 0 1026 6 0 0
t$perf-norm:sp_client_order 21235 21235 0 0.00 0 24602 20 0 0
t$perf-norm:sp_customer_reserve 1013 1013 0 0.00 0 797 4 0 0
t$perf-norm:sp_pay_from_customer 7316 7316 0 0.00 0 4563 11 0 0
t$perf-norm:sp_pay_to_supplier 5934 5934 0 0.00 0 16158 13 0 0
t$perf-norm:sp_reserve_write_off 10342 10342 0 0.00 0 3152 10 0 0
t$perf-norm:sp_supplier_invoice 5569 5569 0 0.00 0 8879 20 0 0
t$perf-norm:sp_supplier_order 5636 5636 0 0.00 0 2936 15 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 1668 31 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 617 5 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 3736 43 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 12039 33 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10080 9914 166 1.64 0 10936 17 0 166
v_all_customers 38546 38546 0 0.00 0 64 1 0 0
v_all_suppliers 30724 30724 0 0.00 0 20 1 0 0
v_all_wares 42468 42468 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 174 6 0 0
v_cancel_client_order 3538 3538 0 0.00 0 2090 5 0 0
v_cancel_customer_prepayment 1554 1554 0 0.00 0 837 5 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 3287 7 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 2641 7 0 0
v_cancel_supplier_invoice 790 774 16 2.02 0 617 15 0 16
v_cancel_supplier_order 796 796 0 0.00 0 231 3 0 0
v_cancel_write_off 2100 2100 0 0.00 0 1015 13 0 0
v_max_id_clo_ord 5628 5628 0 0.00 0 748 2 0 0
v_max_id_clo_res 1013 1013 0 0.00 0 3682 19 0 0
v_max_id_ord_sup 5565 5565 0 0.00 0 4648 4 0 0
v_max_non_paid_invoice 1765 1765 0 0.00 0 2034 4 0 0
v_max_non_paid_realizn 3962 3962 0 0.00 0 582 3 0 0
v_min_id_clo_ord 5628 5628 0 0.00 0 34626 16 0 0
v_min_id_clo_res 1013 1013 0 0.00 0 1651 5 0 0
v_min_id_ord_sup 5565 5565 0 0.00 0 7148 9 0 0
v_min_non_paid_invoice 5934 5934 0 0.00 0 36576 26 0 0
v_min_non_paid_realizn 7316 7316 0 0.00 0 16518 16 0 0
v_our_firm 10630 10630 0 0.00 0 14 1 0 0
v_reserve_write_off 20684 20684 0 0.00 0 3315 5 0 0
x_lock_depdocs_on_canc_invoice 11467 11467 0 0.00 0 31126 127 0 0
x_lock_depdocs_on_canc_sup_ord 398 398 0 0.00 0 14652 427 0 0
x_make_qstorno_1000_1200 5636 5636 0 0.00 2 22611 1158 0 0
x_make_qstorno_1200_2000 5569 5569 0 0.00 2 96361 3600 0 0
x_make_qstorno_2100_3300 461251 461251 0 0.00 0 54231 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-02-2021 19:28:25 to 11-02-2021 19:28:29.

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:22 9 8192000000 8811059024 8825114624 14281680 0.174 3 2 3 0 14513104 72208 159216
16:57:28 10683 8192000000 10223957216 10525827072 975985712 10.645 77 58 116 0 997716400 2624608 19106080
16:57:46 37331 8192000000 10365222976 10686013440 1381473760 14.430 100 85 169 1 1413694080 4647344 27572976
16:58:36 22075 8192000000 10387335904 10717683712 1440436160 14.954 100 82 164 0 1474257360 7123888 26697312
16:59:06 25868 8192000000 10423698768 10752937984 1470172928 15.215 100 85 170 0 1505482640 7899824 27409888
16:59:43 18437 8192000000 10438814816 10773602304 1494615136 15.429 100 83 165 2 1529482208 8608016 26259056
17:00:16 23999 8192000000 10466092800 10801709056 1519426432 15.645 100 86 172 0 1556316960 9561984 27328544
17:00:59 19566 8192000000 10485736880 10830991360 1541148576 15.834 100 84 168 0 1577540944 10145616 26246752
17:01:27 16769 8192000000 10501158080 10847088640 1564665072 16.036 100 88 176 1 1602836240 10504640 27666528
17:01:52 22197 8192000000 10530254272 10883080192 1583973504 16.202 100 81 161 3 1619543808 10694064 24876240
17:02:26 16374 8192000000 10552590480 10906804224 1606909312 16.398 100 79 158 0 1641767520 11013216 23844992
17:02:50 13943 8192000000 10573487392 10931679232 1628997744 16.586 100 84 168 1 1665549376 11471056 25080576
17:03:17 15564 8192000000 10589896352 10949771264 1649183184 16.757 100 78 157 1 1684812912 11983376 23646352
17:03:40 9473 8192000000 10598599488 10962546688 1662502448 16.870 100 80 160 0 1698550752 12256560 23791744
17:04:01 10563 8192000000 10606023760 10977423360 1674940208 16.975 100 71 141 0 1707427584 11960704 20526672
17:04:20 9396 8192000000 10630321728 11001696256 1702629056 17.207 100 71 142 0 1734614928 11545568 20440304
17:04:37 8689 8192000000 10652398640 11023556608 1710869872 17.276 100 78 158 1 1745715824 12076992 22768960
17:04:55 8003 8192000000 10663278672 11041677312 1728350688 17.422 100 78 154 2 1762871504 12463408 22057408
17:05:11 7643 8192000000 10682986432 11061633024 1748258624 17.587 100 83 166 1 1785127424 13097696 23771104
17:05:25 7125 8192000000 10693265952 11074990080 1756545168 17.656 100 79 158 1 1791978720 13421440 22012112
17:05:40 5419 8192000000 10698306496 11081576448 1758119856 17.669 100 66 132 1 1788577936 12691680 17766400
17:05:52 5527 8192000000 10715643296 11094179840 1774827984 17.807 100 82 164 0 1810934608 13313952 22792672
17:06:05 3347 8192000000 10718168896 11100041216 1783796960 17.881 100 80 160 2 1819543952 12900416 22846576
17:06:16 2906 8192000000 10715892752 11101134848 1786543072 17.903 100 78 157 0 1822015392 13050832 22421488
17:06:34 5960 8192000000 10738148528 11126312960 1797119120 17.990 100 82 165 2 1832861056 13080272 22661664
17:06:46 4428 8192000000 10741432448 11129171968 1810544528 18.100 100 72 142 1 1842789616 12417600 19827488
17:06:59 3752 8192000000 10748065712 11139452928 1814977856 18.137 100 71 142 2 1846722304 11434144 20310304
17:07:10 5277 8192000000 10767716752 11151491072 1821119648 18.187 100 80 160 0 1856338192 13000656 22217888
17:07:23 4605 8192000000 10775476928 11159732224 1826279552 18.229 100 92 185 0 1867675504 15487408 25908544
17:07:34 3624 8192000000 10775297984 11160940544 1832314944 18.278 100 95 190 2 1874686592 16056208 26315440
17:07:44 2322 8192000000 10778265616 11162611712 1833235824 18.286 100 93 187 2 1874892752 14770528 26886400
17:07:52 1977 8192000000 10773983584 11160416256 1840579696 18.346 100 91 180 2 1882236080 14809168 26847216
17:08:01 3598 8192000000 10784200544 11171426304 1840930112 18.348 100 90 179 2 1880782976 14731376 25121488
17:08:11 2471 8192000000 10787332752 11178438656 1847762352 18.404 100 90 180 3 1887702240 13798544 26141344
17:08:21 2538 8192000000 10786744000 11181740032 1851207696 18.432 100 85 168 0 1888844112 13583152 24053264
17:08:30 3607 8192000000 10793313408 11180285952 1853850512 18.453 100 86 172 0 1892560672 13416880 25293280
17:08:41 2257 8192000000 10799773712 11185045504 1852948816 18.446 100 94 188 1 1892678672 13140992 26588864
17:08:50 2388 8192000000 10796050192 11184144384 1853708528 18.452 100 92 184 4 1892366608 12850272 25807808
17:08:59 2628 8192000000 10804856240 11190231040 1856966096 18.479 100 94 189 1 1895963792 12080176 26917520
17:09:08 2847 8192000000 10799210384 11190730752 1860430736 18.507 100 87 174 5 1897644288 11522192 25691360
17:09:17 1697 8192000000 10816363936 11202748416 1868242464 18.570 100 93 186 1 1907965216 13142224 26580528
17:09:25 1676 8192000000 10812304144 11200221184 1870017776 18.584 100 89 178 1 1907345056 12953456 24373824
17:09:34 23594 8192000000 10804839776 11203481600 1868450208 18.572 100 71 140 1 1900299200 12775120 19073872
17:10:05 11585 8192000000 10808360464 11208327168 1874811040 18.623 100 89 178 0 1911061408 10304496 25945872
17:10:31 1582 8192000000 10823448704 11212636160 1874403584 18.620 100 91 182 3 1911042320 11065904 25572832
17:10:39 3508 8192000000 10799004720 11209142272 1875714352 18.630 100 66 133 0 1906486528 12243120 18529056
17:10:55 11725 8192000000 10794845696 11213152256 1876081472 18.633 100 59 118 0 1904764800 12059536 16623792
17:11:14 5133 8192000000 10780860288 11207299072 1872733024 18.606 100 41 80 2 1893176896 8802064 11641808
17:11:28 3835 8192000000 10807798736 11211530240 1877458432 18.645 100 57 117 1 1901898320 7444752 16995136
17:11:38 3683 8192000000 10802182048 11215187968 1877106848 18.642 100 44 88 0 1898233488 8659648 12466992
17:11:50 5867 8192000000 10796490912 11215687680 1879167728 18.658 100 38 76 1 1897610400 8024848 10417824
17:12:03 6237 8192000000 10798840544 11220078592 1881462544 18.677 100 31 61 1 1901434384 11924288 8047552
17:12:18 4607 8192000000 10800200240 11222523904 1883497984 18.693 100 34 68 0 1900504880 7839056 9167840
17:12:31 5437 8192000000 10793136512 11225219072 1889914432 18.745 100 45 90 2 1914837648 12901040 12022176
17:12:44 9401 8192000000 10794463616 11220361216 1890130832 18.747 100 33 68 1 1906145232 6691408 9322992
17:13:02 8942 8192000000 10796215856 11226103808 1889935296 18.745 100 30 62 0 1904434224 6072016 8426912
17:13:18 9955 8192000000 10800194672 11226984448 1889694336 18.743 100 13 26 1 1899337648 5955056 3688256
17:13:37 7226 8192000000 10800223344 11235016704 1899284352 18.821 100 24 49 1 1912324960 5988032 7052576
17:13:51 9540 8192000000 10805585520 11235495936 1899633408 18.823 100 25 50 0 1917851200 11147936 7069856
17:14:07 11000 8192000000 10807545088 11240890368 1896164720 18.795 100 18 36 3 1906734256 5705840 4863696
17:14:24 15239 8192000000 10822809248 11246657536 1902210640 18.844 100 24 49 2 1919469792 9828912 7430240
17:14:45 49071 8192000000 10832882000 11253780480 1908060672 18.891 100 57 114 3 1931953584 6474304 17418608
17:15:44 14040 8192000000 10854950992 11265544192 1912632704 18.928 100 67 133 2 1942127792 11409712 18085376
17:16:05 4584 8192000000 10827321184 11255341056 1907620320 18.888 100 45 90 0 1930786544 10146544 13019680
17:16:15 4648 8192000000 10826428096 11253932032 1906360848 18.877 100 35 69 3 1922960880 7007936 9592096
17:16:27 6220 8192000000 10828281872 11255566336 1908234352 18.892 100 37 73 0 1926457328 7428032 10794944
17:16:41 3789 8192000000 10813067424 11245072384 1894726848 18.784 100 30 58 2 1914278432 11153040 8398544
17:16:52 3452 8192000000 10825758880 11249086464 1884895744 18.705 99 46 92 0 1905410144 8120272 12394128
17:17:01 7415 8192000000 10813317280 11249823744 1901797600 18.841 100 33 66 1 1922594368 11759936 9036832
17:17:15 4249 8192000000 10816792736 11248521216 1902389840 18.846 100 25 50 0 1915005136 5678096 6937200
17:17:27 17197 8192000000 10823203248 11251978240 1864145104 18.537 98 24 48 2 1876837536 5519232 7173200
17:17:52 39160 8192000000 10808050304 11236704256 1850596192 18.427 97 33 66 3 1870262000 10620752 9045056
17:18:40 9541 8192000000 10787307792 11215769600 1876394800 18.636 99 26 52 0 1889601648 5847856 7358992
17:18:57 7912 8192000000 10796125776 11221745664 1865353744 18.547 99 31 62 1 1885405408 11669856 8381808
17:19:12 8441 8192000000 10776154176 11201241088 1833188592 18.285 98 22 44 1 1849745376 9707888 6848896
17:19:28 8102 8192000000 10781109504 11204636672 1844735248 18.379 99 31 62 1 1860249168 6784864 8729056
17:19:43 6166 8192000000 10760220304 11181854720 1814198928 18.130 98 23 46 1 1826622832 6114400 6309504
17:19:56 8639 8192000000 10756864112 11180826624 1809480320 18.092 97 25 50 2 1822332608 5350144 7502144
17:20:10 10662 8192000000 10734745888 11162861568 1777373648 17.828 97 19 38 2 1788553968 5747600 5432720
17:20:27 9080 8192000000 10714991648 11137949696 1730628864 17.441 94 20 40 1 1742117888 5141344 6347680
17:20:43 10076 8192000000 10703461664 11114090496 1730731072 17.442 95 22 44 0 1742850320 5985424 6133824
17:21:00 8472 8192000000 10730091792 11146936320 1799877104 18.013 99 29 58 2 1814431536 6148560 8405872
17:21:17 11702 8192000000 10688132720 11101413376 1660656144 16.854 91 15 30 1 1670048816 5046304 4346368
17:21:38 66438 8192000000 10761366224 11152580608 1780937040 17.857 98 51 103 0 1802681952 6025120 15719792
17:22:50 7610 8192000000 10720493952 11147194368 1816803920 18.152 100 34 68 0 1834744960 8578896 9362144
17:23:07 5729 8192000000 10724901168 11142270976 1790722272 17.938 98 46 92 0 1810640080 7322544 12595264
17:23:19 5140 8192000000 10751465936 11166007296 1832767264 18.282 100 46 92 1 1853304880 8138224 12399392
17:23:33 6072 8192000000 10726537232 11141120000 1754733680 17.641 96 40 80 2 1771794848 6080896 10980272
17:23:45 4901 8192000000 10724584208 11138318336 1795886128 17.980 99 43 83 3 1815737152 8140480 11710544
17:23:57 4029 8192000000 10740825056 11158777856 1824742160 18.216 100 39 78 3 1843238176 7394208 11101808
17:24:09 5628 8192000000 10766770672 11180933120 1840183504 18.342 100 35 68 3 1855973280 6385536 9404240
17:24:22 6529 8192000000 10745935632 11168239616 1810065680 18.096 98 26 52 0 1822688560 4895952 7726928
17:24:35 4777 8192000000 10745449216 11168129024 1832130400 18.277 100 18 36 0 1842708720 5084096 5494224
17:24:48 6947 8192000000 10765609632 11184680960 1842285888 18.359 100 18 36 1 1853000976 5751344 4963744
17:25:04 9911 8192000000 10785073440 11201925120 1851229536 18.432 100 28 54 1 1868864656 9300720 8334400
17:25:26 49730 8192000000 10800105520 11213869056 1870437728 18.588 100 39 76 2 1887543712 5333184 11772800
17:26:23 21487 8192000000 10774037072 11209101312 1869994896 18.584 100 19 38 1 1880614672 5485216 5134560
17:26:52 9486 8192000000 10788772800 11212849152 1872247984 18.602 100 40 80 1 1890005552 6941696 10815872
17:27:08 3330 8192000000 10816405552 11230052352 1887207312 18.723 100 37 73 0 1904633024 6098576 11327136
17:27:18 26128 8192000000 10824055600 11247837184 1899436864 18.822 100 31 62 0 1918212880 9472128 9303888
17:27:52 7611 8192000000 10836138992 11255955456 1910869744 18.914 100 46 88 3 1929639632 6274096 12495792
17:28:08 24508 8192000000 10846484304 11263787008 1916556128 18.959 100 44 88 0 1937186608 8399952 12230528
17:28:41 6529 8192000000 10864131360 11276484608 1929641872 19.064 100 56 110 0 1953208624 8494192 15072560
17:28:55 14691 8192000000 10857341808 11285803008 1933624192 19.096 100 51 102 0 1957310352 9565968 14120192
17:29:20 10603 8192000000 10864992864 11296681984 1936733520 19.121 100 44 88 0 1959675344 10394320 12547504
17:29:51 11460 8192000000 10881014896 11303321600 1946540272 19.199 100 50 102 0 1970152528 8961600 14650656
17:30:16 34929 8192000000 10888136192 11316240384 1952003504 19.242 100 38 74 0 1971596224 9013728 10578992
17:31:00 79580 8192000000 10893046096 11340062720 1961176016 19.315 100 38 76 1 1984467760 12036016 11255728
17:32:27 11487 8192000000 10895506144 11330142208 1964896736 19.345 100 29 58 0 1987489792 13452640 9140416
17:32:50 2422 8192000000 10910708768 11338674176 1977630288 19.446 100 57 114 2 2005780416 11478336 16671792
17:33:03 21773 8192000000 10908230656 11343208448 1976011584 19.433 100 49 98 2 2004072624 14031968 14029072
17:33:39 9062 8192000000 10934777584 11362693120 1986709152 19.518 100 52 100 2 2023173200 22661072 13802976
17:33:56 8525 8192000000 10935487184 11365191680 1989638080 19.541 100 57 114 1 2025116288 19415952 16062256
17:34:12 12471 8192000000 10930350592 11364192256 1993588000 19.572 100 58 116 1 2029893152 19257792 17047360
17:34:31 3369 8192000000 10952528752 11374485504 1994748880 19.581 100 60 118 2 2031088400 19109888 17229632
17:34:42 4066 8192000000 10950416112 11374997504 1998530464 19.611 100 70 139 0 2038720208 20489824 19699920
17:34:57 16013 8192000000 10937716368 11360649216 1981682528 19.478 99 65 127 1 2020845984 20770112 18393344
17:35:22 9376 8192000000 10947119536 11377000448 1999468320 19.619 100 74 146 0 2042626112 22837392 20320400
17:35:42 10793 8192000000 10938718064 11372122112 1998368464 19.610 100 59 118 2 2037865728 22095248 17402016
17:36:05 11378 8192000000 10944779296 11380461568 1998781168 19.613 100 55 109 0 2035397904 20479280 16137456
17:36:25 10257 8192000000 10942101872 11381415936 2002318960 19.641 100 48 96 0 2038390416 22350816 13720640
17:36:44 3267 8192000000 10942445776 11385049088 2003928704 19.654 100 52 102 0 2040827520 21439824 15458992
17:36:57 10489 8192000000 10951466304 11389612032 2006028752 19.670 100 48 94 1 2040009232 19889344 14091136
17:37:15 4647 8192000000 10956605360 11396386816 2011778176 19.716 100 46 91 1 2048351456 22409200 14164080
17:37:30 5233 8192000000 10971454032 11399213056 2009877568 19.701 100 63 124 0 2053262800 24055264 19329968
17:37:43 3208 8192000000 10959083360 11396661248 2015427360 19.744 100 66 131 1 2059501184 24324368 19749456
17:37:52 6817 8192000000 10971856064 11404447744 2018890656 19.771 100 62 124 0 2062063568 24630448 18542464
17:38:07 4234 8192000000 10978352672 11406282752 2015990032 19.749 100 63 126 2 2062037456 27161872 18885552
17:38:18 2556 8192000000 10986207984 11412197376 2021549504 19.792 100 79 154 1 2068904480 24214864 23140112
17:38:28 4524 8192000000 10981310352 11404746752 2015840672 19.747 100 75 147 0 2064432944 26183328 22408944
17:38:42 3268 8192000000 10968060400 11394834432 2011609040 19.714 100 71 141 1 2059226624 26586528 21031056
17:38:53 12155 8192000000 10984720512 11408486400 2018491216 19.768 100 74 148 0 2068767712 28113760 22162736
17:39:16 4346 8192000000 10974522352 11403337728 2013678272 19.730 100 70 140 1 2064288240 29926080 20683888
17:39:29 10455 8192000000 10983626992 11412496384 2018752096 19.770 100 78 154 0 2072507120 30680640 23074384
17:39:56 2064 8192000000 10985047024 11411283968 2022705072 19.801 100 79 156 2 2077377264 31667680 23004512
17:40:06 2137 8192000000 10991431136 11410153472 2013421360 19.728 100 88 175 1 2070721632 30586784 26713488
17:40:15 2263 8192000000 10964692896 11388727296 2000243008 19.625 99 84 168 0 2057474576 32387104 24844464
17:40:25 5524 8192000000 10985137456 11407216640 2011559920 19.714 100 69 138 1 2065433408 33246864 20626624
17:40:37 5835 8192000000 10984280400 11410882560 2016713872 19.754 100 79 156 1 2073635328 33789152 23132304
17:40:51 2850 8192000000 10988863472 11410317312 2002124544 19.639 99 87 172 1 2063144496 35267344 25752608
17:41:00 2594 8192000000 10992285200 11413155840 2013260016 19.727 100 87 174 2 2076280672 36692208 26328448
17:41:09 7349 8192000000 10974210992 11396354048 1999401328 19.618 100 75 149 2 2058922512 37106768 22414416
17:41:23 6739 8192000000 10977058592 11409637376 2007429936 19.681 100 73 144 1 2066086912 36774288 21882688
17:41:43 2884 8192000000 10992344576 11417735168 2014506752 19.737 100 77 156 0 2075722176 37829808 23385616
17:41:53 2142 8192000000 10995395968 11416629248 2018443248 19.768 100 87 174 2 2080368544 35212160 26713136
17:42:01 2539 8192000000 10994066640 11416018944 2022282656 19.798 100 81 162 4 2083618944 36203120 25133168
17:42:12 2774 8192000000 10993244896 11413483520 2017413936 19.760 100 81 160 1 2077051520 35469824 24167760
17:42:26 5408 8192000000 10980027872 11405541376 2005488016 19.666 100 77 154 2 2067125968 37361696 24276256
17:42:39 9883 8192000000 10967556144 11395719168 1980100048 19.465 99 69 137 2 2038307760 37282080 20925632
17:42:57 1611 8192000000 10965805552 11378020352 1969227984 19.379 99 82 163 3 2030363008 36521584 24613440
17:43:07 3351 8192000000 10974059248 11388383232 1975989520 19.433 99 88 173 2 2040037904 38374864 25673520
17:43:20 3766 8192000000 10969555760 11397541888 1995112048 19.584 100 76 152 3 2058937248 40457008 23368192
17:43:33 2199 8192000000 10967863824 11389648896 1979822624 19.463 99 82 165 0 2044605088 40276640 24505824
17:43:44 3403 8192000000 10957946192 11377217536 1971019392 19.394 99 80 158 2 2038719696 41462160 26238144
17:43:55 6505 8192000000 10976546208 11401084928 1990615232 19.549 100 71 142 0 2056172864 42400464 23157168
17:44:08 5530 8192000000 10982019120 11407204352 1998724672 19.613 100 84 167 1 2069846768 43444480 27677616
17:44:22 2479 8192000000 10969346768 11382067200 1966784752 19.360 99 91 182 2 2033315168 37466592 29063824
17:44:32 3898 8192000000 10937851984 11352764416 1955522128 19.270 99 80 159 0 2017486640 37816096 24148416
17:44:47 1952 8192000000 10947789584 11358089216 1945853920 19.193 98 96 190 0 2012033088 36208752 29970416
17:44:56 3821 8192000000 10955685120 11371003904 1961324032 19.317 99 79 157 0 2023722896 37339664 25059200
17:45:09 926 8192000000 10964501952 11376652288 1979267904 19.459 100 79 158 1 2041936032 37677312 24990816
17:45:17 2382 8192000000 10956559184 11381751808 1975551808 19.429 100 73 144 0 2035052864 37576080 21924976
17:45:26 2682 8192000000 10970740816 11388551168 1987433296 19.524 100 84 167 1 2051552608 38725168 25394144
17:45:37 2248 8192000000 10964700832 11381977088 1981713408 19.478 100 74 148 0 2041478768 36962592 22802768
17:45:46 9915 8192000000 10969332016 11389145088 1993020176 19.568 100 81 162 0 2048084256 30427136 24636944
17:46:09 2931 8192000000 10970638864 11390402560 1982410992 19.484 99 84 169 1 2039507984 31053936 26043056
17:46:20 2348 8192000000 10974140272 11385548800 1993193904 19.569 100 89 176 2 2051698704 31649552 26855248
17:46:33 15246 8192000000 10964211040 11393978368 1995455840 19.587 100 62 123 2 2046562688 31674064 19432784
17:46:58 2935 8192000000 10976279808 11399663616 2002531504 19.643 100 68 137 1 2055601136 32236112 20833520
17:47:08 4704 8192000000 10970508464 11405254656 2004469456 19.658 100 56 112 0 2056327984 33416736 18441792
17:47:23 14886 8192000000 10956803520 11392270336 1981906176 19.480 99 54 110 2 2030530704 31471056 17153472
17:47:57 4311 8192000000 10955577040 11394576384 1996816352 19.598 100 52 103 1 2042759696 29424352 16518992
17:48:07 7305 8192000000 10915937056 11356356608 1960615296 19.311 99 47 94 0 2005120160 29782912 14721952
17:48:22 7946 8192000000 10934874816 11371720704 1976968912 19.441 100 38 76 1 2018920112 29937696 12013504
17:48:36 4797 8192000000 10947074720 11388592128 1988213888 19.530 100 45 89 3 2033279008 31479296 13585824
17:48:55 4275 8192000000 10953002160 11393187840 1992189408 19.561 100 49 96 2 2040362560 32627424 15545728
17:49:08 4386 8192000000 10953502368 11367047168 1975605888 19.430 99 64 126 1 2027459296 31249728 20603680
17:49:22 3843 8192000000 10937373136 11358646272 1965392016 19.349 100 72 144 1 2020610128 32346688 22871424
17:49:34 4277 8192000000 10943175472 11357167616 1964728672 19.344 100 75 148 3 2021378032 32973216 23676144
17:49:45 6974 8192000000 10943889760 11373658112 1980716192 19.470 100 72 145 1 2037366128 34210976 22438960
17:50:02 7878 8192000000 10947598240 11382374400 1978526480 19.453 100 59 117 0 2035122032 38287632 18307920
17:50:28 10365 8192000000 10925156752 11374608384 1967588144 19.366 100 40 80 1 2018122176 37469632 13064400
17:50:46 24631 8192000000 10926879344 11385896960 1972698912 19.407 100 25 51 0 2015956384 35196816 8060656
17:51:33 14877 8192000000 10926379952 11373486080 1950668288 19.232 99 24 48 1 1995200880 36613424 7919168
17:51:55 21925 8192000000 10896030944 11353513984 1923194544 19.012 98 27 54 2 1969495632 36496080 9805008
17:52:23 17294 8192000000 10902103568 11345182720 1927536576 19.047 99 31 62 2 1973599568 35070336 10992656
17:52:59 19361 8192000000 10882822640 11335114752 1912619952 18.928 99 34 68 1 1963672576 39203184 11849440
17:53:32 32568 8192000000 10889801536 11349614592 1942430128 19.166 100 30 61 3 1986503216 33860432 10212656
17:54:15 42873 8192000000 10882241216 11335094272 1877619376 18.646 97 16 32 1 1914163168 30843984 5699808
17:55:10 22168 8192000000 10862614112 11301421056 1882386240 18.684 98 32 64 0 1913256256 21005776 9864240
17:55:45 23707 8192000000 10842855264 11310534656 1898704128 18.816 99 11 22 1 1915455008 13477040 3273840
17:56:14 37710 8192000000 10867821616 11303342080 1850990528 18.430 96 26 49 5 1868806080 10594992 7220560
17:56:59 91327 8192000000 10839791168 11283820544 1820294688 18.180 94 37 74 1 1842222576 11561392 10366496
17:59:03 130324 8192000000 10887421472 11307569152 1866582352 18.557 97 35 67 1 1883790784 8131280 9077152
18:01:20 31213 8192000000 10872473088 11327086592 1944661792 19.184 100 33 66 1 1962905616 9358928 8884896
18:01:58 34519 8192000000 10864027936 11324706816 1932936544 19.090 99 15 30 0 1943798752 6360544 4501664
18:02:40 19831 8192000000 10873900016 11319312384 1930435152 19.070 99 23 46 0 1942664800 6071600 6158048
18:03:30 8008 8192000000 10905912288 11343753216 1964269136 19.340 100 62 124 0 1990387744 8877280 17241328
18:03:52 7441 8192000000 10921793248 11355746304 1976711840 19.439 100 76 150 0 2009530704 11555568 21263296
18:04:06 8358 8192000000 10911295376 11357319168 1974438480 19.421 100 47 94 1 1999622832 11858432 13325920
18:04:32 35836 8192000000 10900877648 11356708864 1952726336 19.248 99 21 40 3 1967580848 8778880 6075632
18:05:16 31447 8192000000 10924311952 11371274240 1984805008 19.503 100 29 57 0 2007484768 13023392 9656368
18:06:00 45756 8192000000 10905022368 11373170688 1966464800 19.357 99 25 50 1 1990586496 16445984 7675712
18:06:53 36389 8192000000 10901191136 11368542208 1973707664 19.415 100 14 28 0 1997960432 19618832 4633936
18:07:35 23652 8192000000 10906465568 11372367872 1977950512 19.448 100 14 28 1 2002703648 20046880 4706256
18:08:05 8527 8192000000 10899087904 11377680384 1978913840 19.456 100 11 20 0 1995450288 12949024 3587424
18:08:20 56883 8192000000 10898252976 11369750528 1961071328 19.315 99 12 24 2 1976731376 11997232 3662816
18:09:54 20641 8192000000 10918626000 11380838400 1983390784 19.492 100 24 49 0 2006313280 15681296 7241200
18:10:39 79667 8192000000 10922238176 11389898752 1987091808 19.521 100 18 37 1 2006208512 13231488 5885216
18:12:05 16827 8192000000 10921147696 11377647616 1962957632 19.330 98 29 58 1 1984321760 12986240 8377888
18:12:28 30208 8192000000 10928609568 11402452992 1995810784 19.590 100 32 63 0 2022367008 17128992 9427232
18:14:17 41210 8192000000 10941282160 11406540800 1987279264 19.522 100 18 36 2 2011930560 19321584 5329712
18:15:12 71757 8192000000 10918866800 11385757696 1954747952 19.264 98 21 42 0 1974998720 14746720 5504048
18:16:32 39998 8192000000 10906219552 11370385408 1935359424 19.110 97 28 56 0 1955958048 12844864 7753760
18:17:18 70973 8192000000 10895957376 11380199424 1935377216 19.110 98 16 32 0 1960161296 19693136 5090944
18:18:37 72337 8192000000 10921148464 11364466688 1921402400 18.998 97 26 52 2 1938390384 10240352 6747632
18:19:56 14076 8192000000 10914507680 11369488384 1964862464 19.345 99 42 84 1 1985898368 9000528 12035376
18:20:20 29140 8192000000 10933586144 11387301888 1984055488 19.497 100 42 84 1 2009015776 13510272 11450016
18:21:00 70898 8192000000 10890729456 11366002688 1880453232 18.669 95 7 13 2 1894306304 12146688 1706384
18:22:17 84931 8192000000 10876209168 11354808320 1898747088 18.816 97 14 28 1 1918727232 16207136 3773008
18:24:01 74755 8192000000 10898984576 11381628928 1967837744 19.368 100 20 41 0 1983381216 10005664 5537808
18:25:22 126137 8192000000 10897084096 11377639424 1876628816 18.638 95 15 30 1 1906391408 25226704 4535888
18:28:24 86944 8192000000 10899584016 11377115136 1973243712 19.411 100 19 38 0 1987692272 9596272 4852288
18:30:00 7511 8192000000 10899426128 11371831296 1970856304 19.392 100 12 23 0 1984529872 10947936 2725632
18:30:14 12491 8192000000 10907221280 11375255552 1979055824 19.457 100 15 30 1 1995059008 12019472 3983712
18:30:33 57069 8192000000 10885388976 11363631104 1930628512 19.072 97 24 48 0 1948267744 10895216 6744016
18:31:37 71076 8192000000 10873334656 11352633344 1952588416 19.247 99 14 28 2 1970851984 14534960 3728608
18:32:54 22786 8192000000 10893547600 11372457984 1964333280 19.340 100 5 11 0 1976751456 11129088 1289088
18:33:23 43817 8192000000 10883206800 11353391104 1948272544 19.213 99 9 18 1 1959895520 9419152 2203824
18:34:13 60747 8192000000 10899093936 11372814336 1946453376 19.198 99 11 22 0 1959109968 9508400 3148192
18:35:20 31850 8192000000 10884927152 11349385216 1906530128 18.879 97 19 39 1 1925783792 13218384 6035280
18:36:11 28705 8192000000 10897030128 11339513856 1894483760 18.782 97 52 104 2 1925594064 15269984 15840320
18:37:00 50227 8192000000 10876941616 11339829248 1934267360 19.101 100 31 62 0 1968009984 24121776 9620848
18:37:57 84842 8192000000 10864275008 11346300928 1914383584 18.942 99 21 42 2 1944869136 23804944 6680608
18:39:32 68619 8192000000 10870581200 11332583424 1886060608 18.714 97 15 29 0 1905327840 14877296 4389936
18:40:53 63173 8192000000 10879922224 11339735040 1905150080 18.868 98 18 37 1 1923831920 12857216 5824624
18:42:16 43342 8192000000 10879490096 11346849792 1889037888 18.738 97 17 34 0 1905076208 11101952 4936368
18:43:16 124925 8192000000 10859814880 11317780480 1826120624 18.228 94 11 22 1 1844738912 15741712 2876576
18:45:28 11744 8192000000 10860442624 11304710144 1882647600 18.686 97 48 94 2 1904295088 6990432 14657056
18:45:49 12157 8192000000 10875483328 11314913280 1906852368 18.881 99 31 62 2 1924707120 9239296 8615456
18:46:09 79336 8192000000 10864058016 11349049344 1941744800 19.161 100 27 54 0 1965017888 15925552 7347536
18:47:52 77756 8192000000 10876092160 11336351744 1927644048 19.048 99 28 55 1 1944547568 8686960 8216560
18:49:47 49635 8192000000 10844733248 11325923328 1904577936 18.863 98 12 24 0 1917761408 10559552 2623920
18:50:48 35053 8192000000 10857972272 11334111232 1941618336 19.160 100 9 19 0 1950499680 7146736 1734608
18:51:30 60087 8192000000 10846520608 11319975936 1904362640 18.861 98 7 14 0 1913576112 7202288 2011184
18:52:36 34932 8192000000 10851693152 11324878848 1912849952 18.930 99 11 21 1 1923771552 7851088 3070512
18:53:25 35133 8192000000 10871055440 11336499200 1944129264 19.180 100 21 41 2 1963395584 13301360 5964960
18:54:48 97526 8192000000 10884912672 11359440896 1892961216 18.770 97 13 26 1 1921256976 24440608 3855152
18:57:32 65709 8192000000 10872972096 11329409024 1904285408 18.861 98 25 49 0 1931926576 20302192 7338976
18:58:44 67039 8192000000 10888926160 11358646272 1958454400 19.294 100 30 60 1 1982228368 15177536 8596432
19:00:09 104601 8192000000 10894002416 11379740672 1922308544 19.005 98 8 16 0 1942534096 17767408 2458144
19:02:08 85849 8192000000 10883586432 11365281792 1917323504 18.965 98 8 15 1 1936558784 16935312 2299968
19:03:55 87997 8192000000 10906862864 11378343936 1951608240 19.239 99 12 24 0 1971549840 16149152 3792448
19:05:39 39151 8192000000 10913520112 11372462080 1962159440 19.323 99 44 87 1 1987916608 13053984 12703184
19:07:28 33105 8192000000 10924462128 11378606080 1960293040 19.308 99 35 70 2 1982700704 12420560 9987104
19:08:13 105214 8192000000 10913426160 11393769472 1964470320 19.342 99 10 20 1 1981190416 14060384 2659712
19:10:32 103104 8192000000 10918224064 11389939712 1951716800 19.240 98 20 41 0 1969050704 12341792 4992112
19:12:30 46854 8192000000 10926793632 11389063168 1975925872 19.432 99 33 66 0 1995914400 10829664 9158864
19:13:24 47108 8192000000 10903955040 11377586176 1971527584 19.398 100 17 34 2 1991155648 14968208 4659856
19:14:21 64347 8192000000 10884723760 11374604288 1956962960 19.282 99 6 12 0 1968272480 9735616 1573904
19:15:31 10690 8192000000 10883997008 11374858240 1969565120 19.382 100 5 10 0 1981026736 10194784 1266832
19:15:48 27020 8192000000 10886781728 11358511104 1936485152 19.119 98 17 34 1 1947527872 6495312 4547408
19:16:31 67572 8192000000 10877034640 11351592960 1910998256 18.915 97 20 40 0 1923469920 6878192 5593472
19:17:46 40164 8192000000 10877581152 11356848128 1945355216 19.189 99 13 27 0 1956473040 7961120 3156704
19:18:33 77845 8192000000 10890116848 11372617728 1974867728 19.424 100 20 40 1 1989439856 8347104 6225024
19:19:56 53752 8192000000 10892476944 11376824320 1972956288 19.409 100 17 34 1 1992375248 13983120 5435840
19:20:57 47494 8192000000 10859003584 11336523776 1893237136 18.772 96 15 30 0 1908248144 11047472 3963536
19:21:57 67865 8192000000 10875604848 11342180352 1887637920 18.727 96 18 36 0 1901491344 8716656 5136768
19:23:15 91233 8192000000 10889107104 11361591296 1938982032 19.139 99 25 50 2 1965531696 19098432 7451232
19:24:53 64839 8192000000 10888908432 11355299840 1928656368 19.056 98 19 37 0 1945182384 10636000 5890016
19:26:04 17654 8192000000 10890931504 11347185664 1938485840 19.135 99 38 76 1 1957702160 8534048 10682272
19:26:29 42881 8192000000 10879262544 11337973760 1879818000 18.664 96 23 46 0 1897276208 10919168 6539040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 11-02-2021 19:28:31 to 11-02-2021 19:29:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 83 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 11-02-2021 19:29:05 to 11-02-2021 19:29:06.

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

11.02.21 19:29:08. 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-11 19:29:10 No severe PSQL-related problems occured
11.02.21 19:29:11. End of report.