Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.12.2020 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 17500384 kB
MemAvailable 31429016 kB
Buffers 0 kB
Cached 14158488 kB
SwapCached 2540 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-25 19:27:10
DTS_END                         2020-12-25 19:27:10.6440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54644
TRN_ID                          240328
ATT_ID                          713
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: 9155.55 21316 1098666
customer order: creation 172.29 373 20675
customer order: refuse 14.82 330 1778
order to supplier: creation 45.15 1252 5418
order to supplier: removal 3.55 89382 426
invoice (draft): creation 46.18 3476 5541
invoice (draft): removal 51.51 707 6181
invoice accept: apply 41.35 18303 4962
invoice accept: cancel 46.93 780 5632
customer reserve: creation 3823.09 181 458771
customer reserve: removal 4623.95 54 554874
realization accept: apply 82.13 163 9855
realization accept: cancel 77.13 109 9256
payment from customer: creation 58.79 95 7055
payment from customer: removal 5.60 57 672
payment to supplier: creation 48.13 103 5775
payment to supplier: removal 3.10 69 372
service: total inventory turnovers 4.83 1092 579
service: total monetary turnovers 6.18 62 742
service: aggregate perf. data 0.82 22421 98
service: refresh index statistics 0.03 287316 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-12-2020 19:28:16 to 25-12-2020 19:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3314
TEST_TIME 2 4291
TEST_TIME 3 5398
TEST_TIME 4 5195
TEST_TIME 5 5337
TEST_TIME 6 5110
TEST_TIME 7 4965
TEST_TIME 8 5357
TEST_TIME 9 5958
TEST_TIME 10 5992
TEST_TIME 11 6064
TEST_TIME 12 6673
TEST_TIME 13 6871
TEST_TIME 14 7248
TEST_TIME 15 7333
TEST_TIME 16 7340
TEST_TIME 17 7618
TEST_TIME 18 8770
TEST_TIME 19 9378
TEST_TIME 20 9613
TEST_TIME 21 9466
TEST_TIME 22 10241
TEST_TIME 23 10696
TEST_TIME 24 11112
TEST_TIME 25 10710
TEST_TIME 26 10624
TEST_TIME 27 11090
TEST_TIME 28 11032
TEST_TIME 29 10881
TEST_TIME 30 10704
TEST_TIME 31 10550
TEST_TIME 32 10420
TEST_TIME 33 10246
TEST_TIME 34 10017
TEST_TIME 35 9986
TEST_TIME 36 9981
TEST_TIME 37 9863
TEST_TIME 38 9679
TEST_TIME 39 9641
TEST_TIME 40 9622
TEST_TIME 41 9491
TEST_TIME 42 9396
TEST_TIME 43 9528
TEST_TIME 44 9475
TEST_TIME 45 9398
TEST_TIME 46 9358
TEST_TIME 47 9339
TEST_TIME 48 9299
TEST_TIME 49 9317
TEST_TIME 50 9491
TEST_TIME 51 9482
TEST_TIME 52 9537
TEST_TIME 53 9504
TEST_TIME 54 9475
TEST_TIME 55 9447
TEST_TIME 56 9758
TEST_TIME 57 9715
TEST_TIME 58 9713
TEST_TIME 59 9719
TEST_TIME 60 9733
TEST_TIME 61 9700
TEST_TIME 62 9609
TEST_TIME 63 9569
TEST_TIME 64 9515
TEST_TIME 65 9502
TEST_TIME 66 9452
TEST_TIME 67 9488
TEST_TIME 68 9442
TEST_TIME 69 9404
TEST_TIME 70 9303
TEST_TIME 71 9384
TEST_TIME 72 9432
TEST_TIME 73 9396
TEST_TIME 74 9433
TEST_TIME 75 9441
TEST_TIME 76 9428
TEST_TIME 77 9510
TEST_TIME 78 9479
TEST_TIME 79 9530
TEST_TIME 80 9492
TEST_TIME 81 9565
TEST_TIME 82 9551
TEST_TIME 83 9539
TEST_TIME 84 9586
TEST_TIME 85 9500
TEST_TIME 86 9492
TEST_TIME 87 9435
TEST_TIME 88 9427
TEST_TIME 89 9371
TEST_TIME 90 9317
TEST_TIME 91 9317
TEST_TIME 92 9228
TEST_TIME 93 9275
TEST_TIME 94 9238
TEST_TIME 95 9256
TEST_TIME 96 9268
TEST_TIME 97 9302
TEST_TIME 98 9278
TEST_TIME 99 9275
TEST_TIME 100 9279
TEST_TIME 101 9269
TEST_TIME 102 9273
TEST_TIME 103 9299
TEST_TIME 104 9317
TEST_TIME 105 9319
TEST_TIME 106 9304
TEST_TIME 107 9307
TEST_TIME 108 9366
TEST_TIME 109 9365
TEST_TIME 110 9299
TEST_TIME 111 9290
TEST_TIME 112 9256
TEST_TIME 113 9205
TEST_TIME 114 9153
TEST_TIME 115 9142
TEST_TIME 116 9163
TEST_TIME 117 9177
TEST_TIME 118 9202
TEST_TIME 119 9221
TEST_TIME 120 9161

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-12-2020 19:28:20 to 25-12-2020 19:28:23.

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 1524444 1524444 0 0.00 0 36769 6 0 0
doc_list_biud 1524444 1524444 0 0.00 0 33963 25 0 0
sp_add_invoice_to_stock 5121 4962 159 3.10 23 215920 18303 0 159
sp_cancel_adding_invoice 5632 5632 0 0.00 5 80199 781 0 0
sp_cancel_client_order 1778 1778 0 0.00 4 11173 330 0 0
sp_cancel_customer_reserve 554874 554874 0 0.00 1 18754 54 0 0
sp_cancel_pay_from_customer 672 672 0 0.00 3 3652 58 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 2 2933 69 0 0
sp_cancel_supplier_invoice 6193 6181 12 0.19 1 33967 708 0 12
sp_cancel_supplier_order 426 426 0 0.00 12 1078652 89383 0 0
sp_cancel_write_off 9256 9256 0 0.00 1 14487 110 0 0
sp_client_order 20675 20675 0 0.00 3 17446 374 0 0
sp_customer_reserve 458771 458771 0 0.00 0 104306 182 0 0
sp_fill_shopping_cart 31620 31620 0 0.00 1 21692 38 0 0
sp_fill_shopping_cart_clo_res 458758 458758 0 0.00 0 14411 14 0 0
sp_get_clo_for_invoice 4949 4949 0 0.00 0 42170 357 0 0
sp_kill_cost_storno 15932 15932 0 0.00 0 7122 56 0 0
sp_kill_qstorno_ret_qs2qd 1125611 1125611 0 0.00 0 33962 29 0 0
sp_kill_qty_storno 592951 592951 0 0.00 0 33963 64 0 0
sp_lock_selected_doc 20583 20583 0 0.00 0 9277 4 0 0
sp_make_cost_storno 27634 27634 0 0.00 0 36754 48 0 0
sp_multiply_rows_for_pdistr 27634 27634 0 0.00 0 8113 26 0 0
sp_multiply_rows_for_qdistr 20675 20675 0 0.00 0 16569 167 0 0
sp_pay_from_customer 7055 7055 0 0.00 4 10398 95 0 0
sp_pay_to_supplier 5775 5775 0 0.00 4 8966 104 0 0
sp_payment_common 12830 12830 0 0.00 1 8838 25 0 0
sp_qd_handle_on_cancel_clo 1778 1778 0 0.00 0 11167 298 0 0
sp_qd_handle_on_invoice_upd_sts 10581 10581 0 0.00 0 27361 334 0 0
sp_qd_handle_on_reserve_upd_sts 9855 9855 0 0.00 0 15056 57 0 0
sp_reserve_write_off 9855 9855 0 0.00 6 15087 164 0 0
sp_supplier_invoice 5541 5541 0 0.00 6 102954 3476 0 0
sp_supplier_order 5418 5418 0 0.00 6 40801 1252 0 0
srv_aggregate_perf_data 99 98 1 1.01 3014 499562 22422 0 1
srv_fill_mon_cache_memory 149 149 0 0.00 865 156964 37368 0 0
srv_find_qd_qs_mism 1051768 1051768 0 0.00 0 16160 5 0 0
srv_make_invnt_saldo 579 579 0 0.00 15 66716 1093 0 0
srv_make_money_saldo 742 742 0 0.00 1 14028 62 0 0
srv_recalc_idx_stat 4 4 0 0.00 206746 384366 287317 0 0
t$perf-abend:sp_add_invoice_to_stock 159 159 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 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 4962 4962 0 0.00 0 9328 142 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 1 10879 130 0 0
t$perf-norm:sp_cancel_client_order 1778 1778 0 0.00 0 2973 13 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 735 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 672 672 0 0.00 0 1500 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 436 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 407 407 0 0.00 0 1446 17 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 17292 1536 0 0
t$perf-norm:sp_cancel_write_off 1009 1009 0 0.00 0 2025 10 0 0
t$perf-norm:sp_client_order 20675 20675 0 0.00 0 7913 16 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 1507 7 0 0
t$perf-norm:sp_pay_from_customer 7055 7055 0 0.00 0 3891 7 0 0
t$perf-norm:sp_pay_to_supplier 5775 5775 0 0.00 0 2346 8 0 0
t$perf-norm:sp_reserve_write_off 9855 9855 0 0.00 0 11728 11 0 0
t$perf-norm:sp_supplier_invoice 5541 5541 0 0.00 0 14338 16 0 0
t$perf-norm:sp_supplier_order 5418 5418 0 0.00 0 4264 12 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 116 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 149 149 0 0.00 0 1879 28 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 1033 22 0 0
t$perf-norm:srv_make_money_saldo 742 742 0 0.00 0 931 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10214 9896 318 3.11 0 6957 15 0 318
v_all_customers 37422 37422 0 0.00 0 84 1 0 0
v_all_suppliers 30156 30156 0 0.00 0 99 1 0 0
v_all_wares 41350 41350 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 852 7 0 0
v_cancel_client_order 3556 3556 0 0.00 0 2340 4 0 0
v_cancel_customer_prepayment 1344 1344 0 0.00 0 3519 7 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 1592 5 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 2451 8 0 0
v_cancel_supplier_invoice 838 814 24 2.86 0 755 13 0 24
v_cancel_supplier_order 852 852 0 0.00 0 3952 11 0 0
v_cancel_write_off 2018 2018 0 0.00 0 5179 14 0 0
v_max_id_clo_ord 5418 5418 0 0.00 0 911 1 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 2279 11 0 0
v_max_id_ord_sup 5527 5527 0 0.00 0 7293 6 0 0
v_max_non_paid_invoice 1642 1642 0 0.00 0 930 3 0 0
v_max_non_paid_realizn 3768 3768 0 0.00 0 1107 3 0 0
v_min_id_clo_ord 5418 5418 0 0.00 0 3791 6 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 3034 11 0 0
v_min_id_ord_sup 5527 5527 0 0.00 0 4150 7 0 0
v_min_non_paid_invoice 5775 5775 0 0.00 0 7946 15 0 0
v_min_non_paid_realizn 7055 7055 0 0.00 0 5293 14 0 0
v_our_firm 10502 10502 0 0.00 0 84 1 0 0
v_reserve_write_off 19710 19710 0 0.00 0 3595 5 0 0
x_lock_depdocs_on_canc_invoice 11406 11406 0 0.00 0 17201 119 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 9421 312 0 0
x_make_qstorno_1000_1200 5418 5418 0 0.00 2 40792 1178 0 0
x_make_qstorno_1200_2000 5541 5541 0 0.00 3 102944 3334 0 0
x_make_qstorno_2100_3300 458771 458771 0 0.00 0 104303 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-12-2020 19:28:24 to 25-12-2020 19:28:28.

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:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:20 10216 8192000000 10178189088 10468732928 877132192 9.671 71 57 115 0 899417152 2469520 19815440
16:57:37 17634 8192000000 10310147616 10620018688 1348160496 14.131 100 89 179 1 1381586048 4084384 29341168
16:58:07 29290 8192000000 10361485936 10679844864 1405350064 14.643 100 86 172 1 1439275008 5916592 28008352
16:58:47 27420 8192000000 10412498640 10738876416 1461797008 15.142 100 93 186 0 1499156928 7236096 30123824
16:59:28 21659 8192000000 10429888544 10761846784 1478775904 15.291 100 84 168 0 1514347776 8518400 27053472
17:00:00 23970 8192000000 10443518384 10776150016 1497163296 15.451 100 91 182 0 1535982448 9435632 29383520
17:00:32 15166 8192000000 10456040496 10793095168 1510111824 15.564 100 84 168 2 1546527696 9738416 26677456
17:00:57 19713 8192000000 10504086192 10847109120 1538527056 15.811 100 82 164 0 1573926752 9470864 25928832
17:01:28 10652 8192000000 10521905504 10870145024 1573211904 16.110 100 81 161 1 1608580064 10553552 24814608
17:01:45 15550 8192000000 10533673776 10885509120 1588340784 16.240 100 80 159 0 1623225360 10731856 24152720
17:02:09 13141 8192000000 10547910448 10902757376 1609952464 16.424 100 87 174 1 1647488160 11180640 26355056
17:02:33 12848 8192000000 10566413984 10921062400 1621940176 16.526 100 88 174 2 1660551136 11939840 26671120
17:02:53 14748 8192000000 10587800144 10946592768 1640764576 16.686 100 84 168 2 1677691168 11803728 25122864
17:03:15 10495 8192000000 10595405600 10955251712 1653870576 16.797 100 86 172 1 1692642352 12841328 25930448
17:03:34 9097 8192000000 10599552736 10966659072 1660572992 16.854 100 78 156 1 1696526400 12894000 23059408
17:03:52 9420 8192000000 10610006416 10978631680 1673517024 16.963 100 84 167 0 1710704000 12971632 24215344
17:04:10 6881 8192000000 10637463264 11005714432 1689913056 17.101 100 82 165 0 1726724160 13099264 23711840
17:04:24 8787 8192000000 10652507584 11025715200 1706084592 17.236 100 78 156 2 1741590352 12822736 22683024
17:04:41 8779 8192000000 10662175792 11037646848 1721238336 17.363 100 80 160 2 1757187952 13003776 22945840
17:04:57 5794 8192000000 10672710544 11046596608 1732363680 17.455 100 80 161 0 1767835136 12766656 22704800
17:05:10 5051 8192000000 10688571872 11060883456 1743035616 17.544 100 85 167 0 1779997392 13529360 23432416
17:05:21 5368 8192000000 10686889312 11064221696 1752722736 17.624 100 81 162 3 1789164384 13692288 22749360
17:05:33 2813 8192000000 10699410272 11073941504 1757410688 17.663 100 89 178 0 1796564976 14075136 25079152
17:05:44 2836 8192000000 10707121632 11085832192 1768695600 17.756 100 88 176 1 1807760144 13748096 25316448
17:05:54 2912 8192000000 10717909424 11093102592 1775439440 17.812 100 87 172 0 1813397472 14017488 23940544
17:06:03 2511 8192000000 10716887376 11097473024 1779213920 17.843 100 83 166 0 1816569536 14009280 23346336
17:06:13 2766 8192000000 10722985008 11099717632 1786919600 17.906 100 91 180 0 1826347760 14558624 24869536
17:06:23 2421 8192000000 10730653680 11108737024 1795707616 17.979 100 87 170 0 1833564368 14735744 23121008
17:06:32 2893 8192000000 10740290208 11121643520 1798499936 18.002 100 84 168 0 1837207136 15102656 23604544
17:06:41 8798 8192000000 10737974288 11127562240 1801061120 18.023 100 72 146 0 1834154768 12895728 20197920
17:06:57 2814 8192000000 10748945824 11135311872 1811832064 18.111 100 82 164 0 1847556432 13358000 22366368
17:07:08 1724 8192000000 10769181072 11151888384 1822818736 18.201 100 91 185 0 1862824560 13979392 26026432
17:07:16 1522 8192000000 10765565296 11151228928 1826963808 18.235 100 91 180 0 1868307120 13693488 27649824
17:07:23 2038 8192000000 10772235120 11158327296 1832543872 18.280 100 86 169 2 1869701072 12370544 24786656
17:07:32 1675 8192000000 10780034944 11167608832 1839922432 18.340 100 88 174 0 1877046880 12201136 24923312
17:07:40 2722 8192000000 10788249904 11178422272 1844672896 18.379 100 89 178 1 1882703056 13099120 24931040
17:07:49 1991 8192000000 10795168592 11185111040 1853422752 18.450 100 86 172 1 1891456496 13156432 24877312
17:07:57 1630 8192000000 10800123888 11187257344 1855821392 18.469 100 98 196 0 1898193920 14487456 27885072
17:08:05 1628 8192000000 10805391776 11191324672 1857837680 18.486 100 90 180 3 1896223536 12876128 25509728
17:08:13 2268 8192000000 10804106816 11195678720 1858890624 18.494 100 91 183 1 1898186384 12465216 26830544
17:08:22 1954 8192000000 10801007392 11193532416 1862553488 18.524 100 89 178 1 1900582016 13624736 24403792
17:08:30 1719 8192000000 10806836592 11197145088 1864099568 18.537 100 97 194 1 1904836928 13303712 27433648
17:08:38 2717 8192000000 10782260176 11192713216 1856276944 18.473 100 56 112 0 1883535488 12323072 14935472
17:08:57 14000 8192000000 10789929200 11189387264 1855513872 18.467 100 46 91 2 1875189760 6475184 13200704
17:09:17 2247 8192000000 10789243920 11194884096 1862117696 18.520 100 62 125 3 1889077280 9432688 17526896
17:09:28 4570 8192000000 10768419232 11195412480 1859210544 18.497 100 34 66 3 1877124944 8635104 9279296
17:09:39 6650 8192000000 10785777760 11196784640 1861839088 18.518 100 40 81 2 1881924384 8118304 11966992
17:09:55 4598 8192000000 10778719056 11200741376 1868248672 18.570 100 43 86 2 1888621056 8189296 12183088
17:10:07 3643 8192000000 10789780032 11209084928 1871404384 18.596 100 34 66 2 1887225968 6598384 9223200
17:10:17 8527 8192000000 10794284192 11211104256 1871120064 18.593 100 27 55 1 1889712816 11418384 7174368
17:10:32 10985 8192000000 10772813120 11208871936 1873919504 18.616 100 18 35 1 1885595968 6302976 5373488
17:10:50 8068 8192000000 10785319872 11213930496 1874219488 18.618 100 14 28 2 1883871120 5795104 3856528
17:11:06 10943 8192000000 10787543920 11217018880 1877977680 18.649 100 21 40 0 1893858192 9532512 6348000
17:11:23 17320 8192000000 10793345184 11225722880 1883616848 18.694 100 11 22 0 1892350688 5725040 3008800
17:11:47 11113 8192000000 10804467008 11236171776 1890279440 18.748 100 29 55 4 1907370976 9484048 7607488
17:12:05 30489 8192000000 10799701072 11238051840 1891534768 18.758 100 20 41 3 1903586272 5272880 6778624
17:13:09 29335 8192000000 10818871120 11253485568 1899699856 18.824 100 29 56 3 1918176896 10610224 7866816
17:13:51 6303 8192000000 10815945008 11251462144 1901929744 18.842 100 24 48 1 1914265568 5211392 7124432
17:14:05 7568 8192000000 10813988080 11250393088 1903634208 18.856 100 24 48 1 1916359968 5871040 6854720
17:14:20 4751 8192000000 10819636784 11254771712 1905526128 18.871 100 23 46 2 1918395184 6469008 6400048
17:14:31 5707 8192000000 10824625616 11259248640 1906936160 18.882 100 28 56 1 1925662784 10154192 8572432
17:14:43 5723 8192000000 10825760752 11253268480 1887531536 18.726 99 31 61 1 1905405568 9098688 8775344
17:14:55 6248 8192000000 10819334672 11253686272 1903330000 18.853 100 31 62 1 1918859296 5333296 10196000
17:15:08 8063 8192000000 10816521040 11253968896 1905386832 18.870 100 19 36 1 1917150144 5120448 6642864
17:15:23 10965 8192000000 10817558736 11255209984 1887157264 18.723 99 13 26 1 1896551040 5023584 4370192
17:15:42 8639 8192000000 10792965792 11223171072 1823955696 18.210 96 11 22 2 1832599520 5178368 3465456
17:15:58 13282 8192000000 10816523248 11244650496 1876199456 18.634 99 23 46 0 1889657616 5639056 7819104
17:16:18 10896 8192000000 10810830480 11241271296 1878281136 18.651 99 22 45 3 1890237328 5411456 6544736
17:16:36 11886 8192000000 10799140464 11233857536 1875705488 18.630 99 12 24 0 1884127488 4874880 3547120
17:16:54 73661 8192000000 10767032144 11197079552 1729625760 17.432 91 27 53 1 1743091648 5388256 8077632
17:18:17 7804 8192000000 10781587056 11203088384 1844776656 18.380 99 24 48 1 1857794544 6216576 6801312
17:18:31 4677 8192000000 10765844032 11188613120 1848476144 18.410 100 37 73 4 1865398512 7062160 9860208
17:18:42 4855 8192000000 10753982320 11179319296 1837338208 18.319 100 29 59 2 1852780496 7230224 8212064
17:18:53 4511 8192000000 10735984880 11145355264 1794363664 17.968 98 35 68 1 1810929920 6863008 9703248
17:19:04 8658 8192000000 10708155584 11125817344 1723483680 17.381 95 19 36 4 1734238160 5297072 5457408
17:19:21 6898 8192000000 10667181136 11078127616 1645391488 16.725 91 25 50 0 1658717280 5149696 8176096
17:19:34 6034 8192000000 10689240832 11109715968 1755558560 17.648 98 33 66 1 1771699584 5978176 10162848
17:19:51 5585 8192000000 10695260176 11115151360 1758426288 17.671 98 23 46 0 1770825376 5731248 6667840
17:20:05 10321 8192000000 10709889024 11121680384 1759587424 17.681 98 25 50 1 1771969712 5393280 6989008
17:20:22 6495 8192000000 10720046720 11126108160 1762748688 17.707 98 22 44 0 1774339088 5132560 6457840
17:20:34 8806 8192000000 10734131888 11148136448 1808359072 18.082 100 24 49 3 1820623616 5719904 6544640
17:20:49 8906 8192000000 10723657792 11132334080 1764660480 17.723 97 22 43 1 1776098112 4924592 6513040
17:21:06 6574 8192000000 10729244064 11146125312 1808241312 18.081 100 10 20 1 1816193664 5502272 2450080
17:21:21 25019 8192000000 10726630592 11154198528 1793147008 17.958 98 18 35 0 1803567072 5034256 5385808
17:22:24 19846 8192000000 10748654672 11162484736 1776025200 17.817 97 28 56 0 1789440016 5932544 7482272
17:22:55 8545 8192000000 10739881504 11155046400 1791230384 17.942 98 38 76 0 1807793040 6746112 9816544
17:23:13 5331 8192000000 10746071456 11168980992 1817004944 18.153 99 40 80 2 1839980528 10928336 12047248
17:23:27 4961 8192000000 10760304464 11186491392 1845370688 18.385 100 26 52 2 1858984240 6246080 7367472
17:23:42 8596 8192000000 10764609872 11181178880 1834442272 18.296 99 25 50 3 1847671664 6295312 6934080
17:23:57 8727 8192000000 10759613872 11189166080 1850044448 18.422 100 19 36 2 1861014080 5300832 5668800
17:24:15 8985 8192000000 10770142160 11195408384 1853881552 18.454 100 20 40 1 1865652480 6057536 5713392
17:24:30 7173 8192000000 10766543792 11196682240 1856416096 18.474 100 19 38 0 1867613472 5760096 5437280
17:24:46 7492 8192000000 10772915248 11198328832 1858184624 18.489 100 23 46 1 1871147168 5147472 7815072
17:25:00 6627 8192000000 10778529552 11207737344 1857770464 18.485 100 12 24 0 1870056320 9366592 2919264
17:25:13 10743 8192000000 10774084208 11204481024 1859792304 18.502 100 20 39 4 1870451792 5176448 5483040
17:25:35 11988 8192000000 10773254288 11208228864 1861789472 18.518 100 13 26 0 1871350208 6085584 3475152
17:25:54 9889 8192000000 10774896256 11208949760 1864667728 18.541 100 13 26 0 1873567888 5532384 3367776
17:26:12 10847 8192000000 10779818400 11216334848 1867245472 18.562 100 13 23 0 1879884336 9367072 3271792
17:26:32 64297 8192000000 10806754128 11230552064 1879944416 18.665 100 34 68 1 1894202896 5016704 9241776
17:27:52 62517 8192000000 10827144624 11255701504 1899992688 18.826 100 35 70 2 1916503504 6983360 9527456
17:29:01 16458 8192000000 10852341664 11274428416 1917334240 18.965 100 44 86 1 1939023616 10323664 11365712
17:29:26 8640 8192000000 10859778256 11282518016 1930313456 19.069 100 56 112 2 1958357280 12538016 15505808
17:29:52 28543 8192000000 10862742640 11287179264 1927376544 19.046 100 47 95 4 1954353888 13399184 13578160
17:30:28 29866 8192000000 10870443072 11295371264 1930339776 19.070 100 47 94 1 1960186688 15729008 14117904
17:31:16 2747 8192000000 10873866576 11299287040 1938982784 19.139 100 50 100 0 1967730592 14221024 14526784
17:31:28 3240 8192000000 10884600976 11304001536 1944859552 19.186 100 55 107 1 1975322608 15693024 14770032
17:31:40 23452 8192000000 10889348800 11320213504 1953654848 19.256 100 64 128 0 1989810768 17656944 18498976
17:32:15 15980 8192000000 10896171280 11323035648 1939520832 19.143 99 50 100 0 1969687328 16001360 14165136
17:32:38 10869 8192000000 10900173808 11325673472 1959839104 19.305 100 48 94 0 1989097168 16016592 13241472
17:33:17 32310 8192000000 10915574880 11350265856 1970770560 19.392 100 46 91 0 2003585136 19728288 13086288
17:34:09 31488 8192000000 10917106800 11359031296 1980649936 19.470 100 35 70 1 2013091536 21585888 10855712
17:34:47 26177 8192000000 10920998992 11359576064 1968510816 19.374 99 44 86 3 2005807712 23903808 13393088
17:35:24 11422 8192000000 10921305456 11357761536 1978778272 19.455 100 39 78 1 2014383584 23370176 12235136
17:35:42 7175 8192000000 10915364704 11343872000 1963386464 19.333 99 56 112 1 2007704000 26380192 17937344
17:35:59 10196 8192000000 10927109856 11363876864 1980955024 19.472 100 52 104 3 2024134032 27212976 15966032
17:36:16 5705 8192000000 10951975056 11379056640 1992442960 19.563 100 59 115 1 2037908048 28220688 17244400
17:36:30 19075 8192000000 10957684272 11394285568 1996911072 19.598 100 56 111 1 2044847840 31193696 16743072
17:36:58 4550 8192000000 10954532976 11378892800 1979106736 19.458 99 64 127 3 2030526432 31610800 19808896
17:37:11 17804 8192000000 10951433856 11386896384 1990150368 19.545 100 52 103 1 2038227072 32526032 15550672
17:37:39 6131 8192000000 10958439184 11390615552 2004104224 19.655 100 56 111 0 2052816992 32705536 16007232
17:37:53 1831 8192000000 10963675456 11389054976 1993831600 19.574 99 65 130 0 2045197552 32541616 18824336
17:38:04 3606 8192000000 10969786800 11397324800 2009248624 19.696 100 70 140 1 2063589936 33016096 21325216
17:38:17 1344 8192000000 10975236720 11397537792 1999081200 19.615 99 80 160 0 2059328640 35338800 24908640
17:38:26 2332 8192000000 10984366432 11405910016 2009502208 19.698 100 74 147 0 2068738320 36719504 22516608
17:38:36 5951 8192000000 10979183648 11403038720 2004681968 19.660 100 74 146 2 2066701744 38569040 23450736
17:38:48 2268 8192000000 10975316208 11407515648 2011173536 19.711 100 63 126 1 2070138176 39526800 19437840
17:39:01 1792 8192000000 10985298208 11411070976 2011551712 19.714 100 63 126 0 2072405024 41430144 19423168
17:39:10 2519 8192000000 10992271008 11421876224 2016254272 19.751 100 76 149 3 2081323136 41623056 23445808
17:39:20 10317 8192000000 10965334688 11398000640 1995557936 19.588 99 61 122 0 2055587120 41128208 18900976
17:39:40 4352 8192000000 10979315536 11405361152 2006330736 19.673 100 71 140 1 2065107952 37437984 21339232
17:39:55 5247 8192000000 10985403264 11406651392 2000133760 19.624 100 64 127 1 2061092272 42178448 18780064
17:40:07 3649 8192000000 10977494224 11396485120 1986980464 19.520 99 90 180 0 2059319328 43147344 29191520
17:40:18 3443 8192000000 10925322592 11341045760 1917776752 18.969 96 72 144 1 1981147072 40211904 23158416
17:40:28 1415 8192000000 10966576656 11381653504 1985255088 19.506 100 83 166 2 2053521728 42053888 26212752
17:40:37 2187 8192000000 10977131136 11384983552 1983246880 19.490 100 89 178 3 2055949888 44715888 27987120
17:40:48 3985 8192000000 10977837088 11391610880 1987909008 19.527 100 86 172 1 2059693344 44733600 27050736
17:40:58 1415 8192000000 10958921936 11374682112 1963076080 19.330 99 86 173 1 2033606048 43738448 26791520
17:41:08 864 8192000000 10973961552 11384799232 1982272544 19.483 100 91 181 1 2056976304 47077376 27626384
17:41:16 2225 8192000000 10980324352 11390787584 1990071520 19.544 100 94 188 2 2064017792 44960576 28985696
17:41:26 4881 8192000000 10966060352 11387568128 1974626144 19.422 99 79 158 0 2041691760 42842192 24223424
17:41:38 3525 8192000000 10963722560 11383042048 1970556032 19.390 99 70 141 0 2036420432 43864752 21999648
17:41:54 1534 8192000000 10967402016 11382190080 1976546768 19.437 99 82 164 1 2046540400 44563232 25430400
17:42:05 4202 8192000000 10973957920 11391209472 1994290272 19.578 100 81 163 0 2060037456 41221984 24525200
17:42:20 9247 8192000000 10981060432 11403702272 1997062336 19.600 100 67 133 1 2064352064 46639168 20650560
17:42:41 1112 8192000000 10970449200 11390898176 1973306432 19.412 99 75 149 1 2045927344 48812064 23808848
17:42:50 7059 8192000000 10973464592 11396042752 1975301952 19.427 99 70 140 0 2045819904 48740592 21777360
17:43:10 2970 8192000000 10969542096 11385159680 1977762896 19.447 100 75 148 0 2051966144 50539984 23663264
17:43:20 1595 8192000000 10963259552 11379658752 1963198288 19.331 100 78 155 3 2039197984 51579776 24419920
17:43:30 1976 8192000000 10959516512 11374686208 1967421744 19.365 100 78 156 0 2045738416 53545616 24771056
17:43:41 3183 8192000000 10963178016 11382337536 1970119776 19.386 100 74 146 0 2047957856 54723072 23115008
17:43:51 2693 8192000000 10980430240 11394990080 1976434864 19.436 100 79 158 1 2058931408 56527600 25968944
17:44:02 3097 8192000000 10991936304 11404546048 1987949488 19.528 100 89 175 1 2071059936 55622720 27487728
17:44:12 2382 8192000000 10993328320 11411394560 1995845408 19.590 100 88 176 1 2080524736 56860352 27818976
17:44:23 3671 8192000000 10986535920 11401842688 1978232320 19.451 99 84 168 3 2064290720 58832064 27226336
17:44:33 2162 8192000000 10976245712 11386437632 1969239296 19.379 99 86 169 1 2055163552 58902544 27021712
17:44:42 3228 8192000000 10972973696 11387342848 1956183104 19.276 99 82 161 0 2043389888 60456816 26749968
17:44:55 4697 8192000000 10966870320 11389706240 1971929760 19.401 100 71 142 0 2060999120 65674608 23394752
17:45:07 5950 8192000000 10962717904 11392466944 1965114896 19.347 100 64 128 1 2049148784 62847488 21186400
17:45:20 2944 8192000000 10968003072 11401846784 1972753680 19.407 100 62 124 1 2055507040 61955344 20798016
17:45:37 13371 8192000000 10933188816 11375595520 1943001856 19.171 99 34 68 1 2005744080 50629088 12113136
17:46:01 5440 8192000000 10928297904 11367378944 1956522352 19.278 100 46 92 1 2022282208 49451360 16308496
17:46:15 12452 8192000000 10932799488 11363311616 1942572080 19.167 99 42 82 0 2001399296 44893184 13934032
17:46:42 5442 8192000000 10927415888 11351711744 1932312528 19.085 99 64 130 0 1996975504 43714944 20948032
17:46:55 14349 8192000000 10906786000 11364790272 1956344880 19.277 100 34 68 0 2005071104 37843728 10882496
17:47:27 17898 8192000000 10916607952 11366719488 1961849840 19.321 100 22 44 1 2004128016 35020928 7257248
17:48:06 23812 8192000000 10924843392 11367890944 1940251392 19.149 99 26 52 3 1985329216 36171632 8906192
17:48:43 16173 8192000000 10919652944 11369222144 1950216624 19.228 100 24 48 2 2003301936 44251712 8833600
17:49:08 23160 8192000000 10905064160 11359703040 1895181552 18.788 97 24 48 0 1946358048 41434240 9742256
17:49:39 53159 8192000000 10900723824 11358449664 1879687040 18.663 97 13 26 1 1921118224 36883280 4547904
17:50:39 26562 8192000000 10920034224 11372347392 1948477296 19.214 100 19 38 0 1988040640 33401664 6161680
17:51:23 31144 8192000000 10891430160 11345960960 1937762336 19.129 99 12 24 1 1957134544 15741584 3630624
17:52:21 65376 8192000000 10899783040 11349176320 1924120864 19.020 98 42 84 1 1960336608 22968416 13247328
17:53:34 35499 8192000000 10903714576 11363778560 1956944768 19.282 100 28 56 3 1988866960 23178128 8744064
17:54:27 29654 8192000000 10887160480 11366453248 1950977968 19.234 100 12 24 0 1974787296 19664688 4144640
17:55:05 98427 8192000000 10870827040 11341479936 1918378720 18.974 98 13 26 0 1937543712 15687328 3477664
17:57:42 83737 8192000000 10888059136 11348480000 1902620128 18.847 96 23 47 2 1917306720 8894272 5792320
17:59:15 75924 8192000000 10901258896 11360120832 1976515200 19.437 100 23 46 4 1991654288 8104768 7034320
18:00:39 148484 8192000000 10881979424 11338063872 1886776240 18.720 95 32 62 0 1902224976 6979824 8468912
18:03:17 55540 8192000000 10860520768 11316158464 1899446512 18.822 97 24 46 1 1917552688 11751104 6355072
18:04:19 64980 8192000000 10888032848 11342344192 1943111168 19.172 99 20 40 0 1956014096 7285280 5617648
18:05:40 28345 8192000000 10909237376 11360112640 1973859632 19.416 100 37 74 2 1993568864 8612480 11096752
18:06:17 28700 8192000000 10890693968 11349999616 1961995520 19.322 100 29 58 1 1987684000 17046768 8641712
18:06:53 45168 8192000000 10913750128 11355308032 1944823808 19.185 99 18 36 1 1963038384 11925424 6289152
18:07:48 23421 8192000000 10908332240 11360022528 1976409680 19.436 100 40 78 2 1999484960 10205424 12869856
18:08:19 27200 8192000000 10924783616 11374448640 1987935120 19.527 100 38 72 4 2010626608 12558672 10132816
18:09:01 49626 8192000000 10908331696 11370045440 1971172432 19.395 99 34 68 0 1997009024 16167744 9668848
18:10:06 156964 8192000000 10895629520 11375349760 1948130272 19.212 99 16 32 0 1971921008 19118736 4672000
18:12:59 61912 8192000000 10892448976 11369701376 1975004192 19.425 100 9 18 0 1989952192 12399328 2548672
18:14:07 51452 8192000000 10903264592 11373625344 1983951664 19.496 100 10 20 0 1998924064 12312288 2660112
18:15:05 69311 8192000000 10938506608 11413643264 2003946928 19.654 100 26 52 1 2025634080 14135536 7551616
18:16:28 55305 8192000000 10931116496 11422801920 2002767856 19.645 100 31 62 2 2032263056 19924608 9570592
18:17:42 84887 8192000000 10923350176 11406696448 1988616992 19.533 99 15 30 2 2008868288 16257168 3994128
18:19:13 92119 8192000000 10916383472 11383918592 1950507728 19.231 97 13 26 2 1964452288 9850400 4094160
18:21:01 54921 8192000000 10933856848 11405639680 1977862000 19.448 98 39 81 2 2000037488 11307264 10868224
18:22:05 87474 8192000000 10928939920 11406495744 1936327648 19.117 96 11 22 0 1955478208 16180080 2970480
18:23:39 137567 8192000000 10915538432 11384930304 1849723760 18.420 92 17 34 1 1868506656 13770400 5012496
18:26:04 67855 8192000000 10897771504 11363430400 1881769744 18.679 95 15 30 2 1897597328 12082896 3744688
18:27:20 77764 8192000000 10901344304 11376017408 1950485248 19.230 99 18 36 0 1970705616 15377024 4843344
18:28:44 87499 8192000000 10915389360 11374071808 1960377536 19.309 99 21 42 1 1973030736 7027808 5625392
18:30:20 76935 8192000000 10905389184 11375542272 1940315184 19.149 97 28 56 0 1963011744 14326096 8370464
18:32:58 65618 8192000000 10909553584 11392692224 1946262624 19.197 98 9 18 0 1965487088 16266448 2958016
18:34:16 61896 8192000000 10875774208 11335032832 1870208416 18.586 95 18 36 0 1893603488 17709984 5685088
18:35:34 64905 8192000000 10881547712 11350212608 1918735808 18.977 98 15 30 1 1933360624 9979504 4645312
18:36:46 56082 8192000000 10888058320 11356127232 1949443792 19.222 100 10 20 0 1962602464 10407728 2750944
18:37:52 43792 8192000000 10872773440 11350724608 1947991600 19.210 99 13 26 0 1965019472 12845648 4182224
18:38:44 58812 8192000000 10882845984 11380936704 1936429904 19.118 99 9 18 1 1953486736 14241440 2815392
18:40:00 13429 8192000000 10861906528 11315073024 1873944944 18.616 96 31 63 2 1888559008 5084112 9529952
18:40:19 38020 8192000000 10875055776 11332300800 1903934240 18.858 98 30 60 1 1920194416 8131216 8128960
18:41:06 63772 8192000000 10887674496 11353706496 1954392464 19.261 100 17 34 1 1969438192 10298656 4747072
18:42:22 36299 8192000000 10891611072 11355271168 1961039328 19.314 100 38 76 1 1980863472 9111552 10712592
18:43:08 37931 8192000000 10905414336 11358580736 1943624416 19.176 99 30 59 3 1962773552 10772272 8376864
18:43:57 70384 8192000000 10909516320 11366428672 1951186816 19.236 99 23 46 0 1974139872 16272256 6680800
18:45:23 75183 8192000000 10887700336 11348533248 1915752544 18.953 97 25 50 1 1936874208 14004272 7117392
18:46:44 53658 8192000000 10922988560 11355725824 1924518704 19.023 98 25 50 2 1942316128 10935536 6861888
18:47:44 17744 8192000000 10901908352 11354681344 1943699376 19.176 99 41 82 1 1969417472 13930912 11787184
18:48:18 97785 8192000000 10891255056 11336388608 1824638384 18.216 93 31 62 0 1848712816 16006928 8067504
18:50:06 31456 8192000000 10898185024 11342266368 1895980128 18.794 97 38 76 0 1917110000 10785952 10343920
18:50:48 37148 8192000000 10903300816 11364896768 1961030816 19.314 100 38 76 0 1987102320 15540080 10531424
18:51:35 98052 8192000000 10874353152 11335430144 1930002192 19.067 99 21 42 0 1951659344 15561616 6095536
18:53:21 58788 8192000000 10886282112 11335393280 1931812112 19.081 99 34 67 0 1951341216 10922544 8606560
18:54:28 13868 8192000000 10885419072 11319361536 1918136544 18.972 98 57 114 1 1947078768 12596288 16345936
18:54:48 54359 8192000000 10880849888 11344392192 1932446304 19.086 99 37 74 0 1956065392 13386352 10232736
18:55:50 68962 8192000000 10871606736 11347992576 1946749344 19.201 100 15 30 0 1968314416 17643616 3921456
18:57:09 39304 8192000000 10875214400 11352555520 1937822512 19.129 99 10 20 1 1957484832 16950144 2712176
18:58:33 60127 8192000000 10870366752 11349848064 1937487680 19.127 99 8 16 0 1952839248 13237120 2114448
19:00:02 71792 8192000000 10884869168 11367432192 1963195600 19.331 100 10 20 0 1980137728 14375584 2566544
19:01:21 29794 8192000000 10888419296 11348389888 1930791264 19.073 98 13 27 0 1944020032 9807392 3421376
19:01:57 79249 8192000000 10912355200 11379838976 1956054688 19.275 99 15 30 1 1967925984 7808240 4063056
19:03:26 65712 8192000000 10895909072 11365249024 1921862496 19.002 97 15 30 0 1935297568 9394496 4040576
19:04:38 89305 8192000000 10907656368 11375648768 1978416256 19.452 100 10 20 0 1989895584 9133216 2346112
19:06:18 70242 8192000000 10890471920 11356434432 1902757600 18.848 96 17 34 1 1915059056 7419232 4882224
19:07:54 51596 8192000000 10883551728 11345416192 1908251696 18.893 97 22 44 0 1923908768 9814448 5842624
19:08:57 73292 8192000000 10892433360 11365654528 1954952384 19.266 99 30 60 1 1975056352 11914976 8188992
19:10:28 83928 8192000000 10908449040 11378790400 1955808064 19.273 99 12 24 1 1971080816 11333920 3938832
19:11:58 53675 8192000000 10914746656 11363975168 1949134032 19.220 98 18 36 0 1962288064 7897936 5256096
19:13:01 38614 8192000000 10904318720 11354898432 1921772640 19.001 97 26 52 2 1936781616 8539520 6469456
19:13:54 12490 8192000000 10940392912 11376332800 1973829520 19.416 100 58 114 3 2003253056 13418928 16004608
19:14:15 45630 8192000000 10907815648 11366318080 1923104112 19.012 97 44 88 0 1951450368 16315264 12030992
19:15:10 90183 8192000000 10887448848 11364020224 1928429472 19.054 98 12 22 1 1945323648 13408080 3486096
19:17:09 74414 8192000000 10885476080 11343368192 1918481552 18.975 97 33 66 0 1936360224 7679072 10199600
19:18:30 37346 8192000000 10861550288 11339452416 1930690448 19.072 99 18 36 2 1943459392 7935984 4832960
19:19:15 83470 8192000000 10869668528 11341164544 1911289424 18.917 98 6 12 0 1922055712 9157776 1608512
19:20:44 86279 8192000000 10880329760 11356409856 1960312656 19.309 100 9 18 0 1975900688 12645408 2942624
19:22:17 72827 8192000000 10890039232 11369701376 1926159040 19.036 98 14 28 2 1942239712 12362144 3718528
19:23:36 55082 8192000000 10868281040 11344412672 1903699168 18.856 97 17 34 0 1922186000 13444256 5042576
19:24:40 66090 8192000000 10873899984 11347353600 1913937744 18.938 98 17 34 0 1935666336 16914880 4813712
19:25:52 82776 8192000000 9092449888 9311272960 237115872 2.813 13 3 6 0 238911040 1373136 422032

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-12-2020 19:28:30 to 25-12-2020 19:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 159 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-12-2020 19:29:02 to 25-12-2020 19:29:04.

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          240620
MON$OLDEST_ACTIVE               240621
MON$OLDEST_SNAPSHOT             240621
MON$NEXT_TRANSACTION            240621
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                       2011200
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:367: 
:368: mscs-test-161.budzdorov.ru    Fri Dec 25 19:27:17 2020
:369:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:370: 
:371: 
:372: mscs-test-161.budzdorov.ru    Fri Dec 25 19:27:17 2020
:373:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:374: 
--- end of diff output ---

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

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