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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17292268 kB
MemAvailable 31520580 kB
Buffers 0 kB
Cached 14421788 kB
SwapCached 2868 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-02 19:27:01
DTS_END                         2020-11-02 19:27:01.4890
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60670
TRN_ID                          239526
ATT_ID                          673
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: 9217.60 20340 1106112
customer order: creation 172.41 351 20689
customer order: refuse 15.12 342 1814
order to supplier: creation 45.69 1332 5483
order to supplier: removal 3.57 98197 428
invoice (draft): creation 46.10 3345 5532
invoice (draft): removal 51.50 892 6180
invoice accept: apply 42.28 19131 5073
invoice accept: cancel 46.48 805 5577
customer reserve: creation 3940.98 188 472918
customer reserve: removal 4547.56 59 545707
realization accept: apply 84.09 175 10091
realization accept: cancel 88.50 117 10620
payment from customer: creation 60.79 120 7295
payment from customer: removal 6.05 62 726
payment to supplier: creation 50.10 131 6012
payment to supplier: removal 3.65 64 438
service: total inventory turnovers 4.97 1018 597
service: total monetary turnovers 6.77 36 812
service: aggregate perf. data 0.97 17229 116
service: refresh index statistics 0.03 263215 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-11-2020 19:29:12 to 02-11-2020 19:29:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7916
TEST_TIME 2 7056
TEST_TIME 3 6090
TEST_TIME 4 5959
TEST_TIME 5 5710
TEST_TIME 6 5805
TEST_TIME 7 6343
TEST_TIME 8 6523
TEST_TIME 9 6731
TEST_TIME 10 6528
TEST_TIME 11 6707
TEST_TIME 12 6901
TEST_TIME 13 6907
TEST_TIME 14 6964
TEST_TIME 15 7015
TEST_TIME 16 6990
TEST_TIME 17 7008
TEST_TIME 18 7431
TEST_TIME 19 8134
TEST_TIME 20 8020
TEST_TIME 21 8713
TEST_TIME 22 8719
TEST_TIME 23 8765
TEST_TIME 24 9164
TEST_TIME 25 9337
TEST_TIME 26 10051
TEST_TIME 27 10572
TEST_TIME 28 10681
TEST_TIME 29 10752
TEST_TIME 30 10829
TEST_TIME 31 10658
TEST_TIME 32 10534
TEST_TIME 33 10661
TEST_TIME 34 10438
TEST_TIME 35 10211
TEST_TIME 36 10182
TEST_TIME 37 10141
TEST_TIME 38 10086
TEST_TIME 39 10121
TEST_TIME 40 10035
TEST_TIME 41 9968
TEST_TIME 42 9910
TEST_TIME 43 9809
TEST_TIME 44 9771
TEST_TIME 45 9694
TEST_TIME 46 9731
TEST_TIME 47 9675
TEST_TIME 48 9749
TEST_TIME 49 9849
TEST_TIME 50 9920
TEST_TIME 51 9829
TEST_TIME 52 9755
TEST_TIME 53 9851
TEST_TIME 54 9862
TEST_TIME 55 9875
TEST_TIME 56 9862
TEST_TIME 57 9776
TEST_TIME 58 9872
TEST_TIME 59 9916
TEST_TIME 60 9982
TEST_TIME 61 9928
TEST_TIME 62 10000
TEST_TIME 63 10000
TEST_TIME 64 9938
TEST_TIME 65 9797
TEST_TIME 66 9804
TEST_TIME 67 9807
TEST_TIME 68 9748
TEST_TIME 69 9715
TEST_TIME 70 9648
TEST_TIME 71 9612
TEST_TIME 72 9565
TEST_TIME 73 9621
TEST_TIME 74 9600
TEST_TIME 75 9539
TEST_TIME 76 9527
TEST_TIME 77 9482
TEST_TIME 78 9518
TEST_TIME 79 9464
TEST_TIME 80 9435
TEST_TIME 81 9473
TEST_TIME 82 9596
TEST_TIME 83 9539
TEST_TIME 84 9648
TEST_TIME 85 9618
TEST_TIME 86 9654
TEST_TIME 87 9663
TEST_TIME 88 9645
TEST_TIME 89 9685
TEST_TIME 90 9764
TEST_TIME 91 9674
TEST_TIME 92 9620
TEST_TIME 93 9548
TEST_TIME 94 9579
TEST_TIME 95 9518
TEST_TIME 96 9513
TEST_TIME 97 9506
TEST_TIME 98 9523
TEST_TIME 99 9477
TEST_TIME 100 9461
TEST_TIME 101 9444
TEST_TIME 102 9467
TEST_TIME 103 9492
TEST_TIME 104 9485
TEST_TIME 105 9482
TEST_TIME 106 9539
TEST_TIME 107 9526
TEST_TIME 108 9537
TEST_TIME 109 9533
TEST_TIME 110 9537
TEST_TIME 111 9477
TEST_TIME 112 9451
TEST_TIME 113 9437
TEST_TIME 114 9413
TEST_TIME 115 9423
TEST_TIME 116 9395
TEST_TIME 117 9368
TEST_TIME 118 9339
TEST_TIME 119 9304
TEST_TIME 120 9227

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-11-2020 19:29:16 to 02-11-2020 19:29:19.

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 1543748 1543748 0 0.00 0 30567 6 0 0
doc_list_biud 1543748 1543748 0 0.00 0 53694 27 0 0
sp_add_invoice_to_stock 5163 5073 90 1.74 43 204632 19132 0 90
sp_cancel_adding_invoice 5577 5577 0 0.00 5 74042 805 0 0
sp_cancel_client_order 1814 1814 0 0.00 4 16049 343 0 0
sp_cancel_customer_reserve 545707 545707 0 0.00 1 53698 60 0 0
sp_cancel_pay_from_customer 726 726 0 0.00 3 1976 62 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 2 3967 65 0 0
sp_cancel_supplier_invoice 6193 6180 13 0.20 1 17038 892 0 13
sp_cancel_supplier_order 428 428 0 0.00 6 1022160 98198 0 0
sp_cancel_write_off 10620 10620 0 0.00 1 16209 118 0 0
sp_client_order 20689 20689 0 0.00 3 17130 351 0 0
sp_customer_reserve 472918 472918 0 0.00 0 63816 189 0 0
sp_fill_shopping_cart 31694 31694 0 0.00 1 28120 35 0 0
sp_fill_shopping_cart_clo_res 472901 472901 0 0.00 0 14383 15 0 0
sp_get_clo_for_invoice 5053 5053 0 0.00 0 32757 275 0 0
sp_kill_cost_storno 17361 17361 0 0.00 0 16207 53 0 0
sp_kill_qstorno_ret_qs2qd 1108642 1108642 0 0.00 0 53690 33 0 0
sp_kill_qty_storno 585469 585469 0 0.00 0 53694 71 0 0
sp_lock_selected_doc 21058 21058 0 0.00 0 10364 6 0 0
sp_make_cost_storno 28450 28450 0 0.00 0 30563 52 0 0
sp_multiply_rows_for_pdistr 28450 28450 0 0.00 0 6939 26 0 0
sp_multiply_rows_for_qdistr 20689 20689 0 0.00 0 14630 157 0 0
sp_pay_from_customer 7295 7295 0 0.00 4 18922 121 0 0
sp_pay_to_supplier 6012 6012 0 0.00 5 33637 132 0 0
sp_payment_common 13307 13307 0 0.00 1 33622 36 0 0
sp_qd_handle_on_cancel_clo 1814 1814 0 0.00 0 16042 306 0 0
sp_qd_handle_on_invoice_upd_sts 10629 10629 0 0.00 0 14650 312 0 0
sp_qd_handle_on_reserve_upd_sts 10091 10091 0 0.00 0 11201 63 0 0
sp_reserve_write_off 10091 10091 0 0.00 7 17363 175 0 0
sp_supplier_invoice 5532 5532 0 0.00 7 104818 3345 0 0
sp_supplier_order 5483 5483 0 0.00 6 31605 1333 0 0
srv_aggregate_perf_data 116 116 0 0.00 2730 154459 17229 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1085 144331 31354 0 0
srv_find_qd_qs_mism 1057380 1057380 0 0.00 0 7700 5 0 0
srv_make_invnt_saldo 597 597 0 0.00 33 90532 1019 0 0
srv_make_money_saldo 812 812 0 0.00 1 6130 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 141471 426174 263216 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5073 5073 0 0.00 0 17681 186 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 0 3852 99 0 0
t$perf-norm:sp_cancel_client_order 1814 1814 0 0.00 0 3057 14 0 0
t$perf-norm:sp_cancel_customer_reserve 686 686 0 0.00 0 1612 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 726 726 0 0.00 0 751 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 2583 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 368 368 0 0.00 0 3394 21 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 27476 1545 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 5765 13 0 0
t$perf-norm:sp_client_order 20689 20689 0 0.00 0 14351 19 0 0
t$perf-norm:sp_customer_reserve 1003 1003 0 0.00 0 2868 8 0 0
t$perf-norm:sp_pay_from_customer 7295 7295 0 0.00 0 3271 7 0 0
t$perf-norm:sp_pay_to_supplier 6012 6012 0 0.00 0 6627 10 0 0
t$perf-norm:sp_reserve_write_off 10091 10091 0 0.00 0 12809 13 0 0
t$perf-norm:sp_supplier_invoice 5532 5532 0 0.00 0 7641 14 0 0
t$perf-norm:sp_supplier_order 5483 5483 0 0.00 0 11039 17 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 94 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 404 9 0 0
t$perf-norm:srv_make_invnt_saldo 597 597 0 0.00 0 2807 21 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 2234 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 4 0 0
v_add_invoice_to_stock 10284 10104 180 1.75 0 11053 23 0 180
v_all_customers 37752 37752 0 0.00 0 27 1 0 0
v_all_suppliers 30736 30736 0 0.00 0 133 1 0 0
v_all_wares 41378 41378 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 2946 14 0 0
v_cancel_client_order 3628 3628 0 0.00 0 5463 9 0 0
v_cancel_customer_prepayment 1452 1452 0 0.00 0 1667 4 0 0
v_cancel_customer_reserve 1372 1372 0 0.00 0 2148 5 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 1000 5 0 0
v_cancel_supplier_invoice 762 736 26 3.41 0 2371 20 0 26
v_cancel_supplier_order 856 856 0 0.00 0 2056 8 0 0
v_cancel_write_off 2042 2042 0 0.00 0 6331 20 0 0
v_max_id_clo_ord 5483 5483 0 0.00 0 2167 2 0 0
v_max_id_clo_res 1003 1003 0 0.00 0 7103 24 0 0
v_max_id_ord_sup 5522 5522 0 0.00 0 2592 3 0 0
v_max_non_paid_invoice 1649 1649 0 0.00 0 333 2 0 0
v_max_non_paid_realizn 3871 3871 0 0.00 0 1108 3 0 0
v_min_id_clo_ord 5483 5483 0 0.00 0 2173 5 0 0
v_min_id_clo_res 1003 1003 0 0.00 0 2697 5 0 0
v_min_id_ord_sup 5522 5522 0 0.00 0 3958 5 0 0
v_min_non_paid_invoice 6012 6012 0 0.00 0 29618 23 0 0
v_min_non_paid_realizn 7295 7295 0 0.00 0 18916 21 0 0
v_our_firm 10474 10474 0 0.00 0 97 1 0 0
v_reserve_write_off 20182 20182 0 0.00 0 12208 8 0 0
x_lock_depdocs_on_canc_invoice 11389 11389 0 0.00 0 18773 125 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 7167 400 0 0
x_make_qstorno_1000_1200 5483 5483 0 0.00 2 31580 1248 0 0
x_make_qstorno_1200_2000 5532 5532 0 0.00 4 104783 3229 0 0
x_make_qstorno_2100_3300 472918 472918 0 0.00 0 63815 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2020 19:29:20 to 02-11-2020 19:29:24.

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:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 19332 8192000000 10224964560 10532204544 830208480 9.201 67 51 102 0 850417520 2376048 17832992
16:57:40 29983 8192000000 10339193824 10655399936 1391416272 14.519 100 89 178 0 1425640304 4816480 29407552
16:58:19 15176 8192000000 10367563280 10687803392 1426341280 14.829 100 91 182 0 1462275824 6254320 29680224
16:58:51 16289 8192000000 10394798384 10720227328 1450036800 15.038 100 84 168 0 1484565760 7054768 27474192
16:59:18 23631 8192000000 10428344160 10756935680 1474269136 15.251 100 85 170 0 1508725024 7422608 27033280
16:59:55 22519 8192000000 10453325424 10786258944 1504872928 15.519 100 87 174 0 1540791616 8393440 27525248
17:00:29 7369 8192000000 10459575152 10797039616 1515075808 15.607 100 84 168 0 1550209152 8823472 26309872
17:00:45 9983 8192000000 10482935360 10826420224 1537366688 15.801 100 84 168 0 1572249696 9290720 25592288
17:01:11 12663 8192000000 10497166960 10847674368 1559726672 15.994 100 84 168 0 1595263744 9619344 25917728
17:01:32 17004 8192000000 10533759888 10885525504 1575004448 16.125 100 70 140 1 1605501104 9325856 21170800
17:01:55 12089 8192000000 10555700640 10909589504 1608663888 16.413 100 78 156 1 1642229200 10212944 23352368
17:02:15 11947 8192000000 10564038624 10925318144 1628238816 16.580 100 83 166 1 1663796528 10782144 24775568
17:02:40 10107 8192000000 10587006432 10945916928 1645937840 16.730 100 78 156 1 1680788944 11869232 22981872
17:02:58 9536 8192000000 10611266192 10972725248 1662574560 16.871 100 80 160 3 1698152480 12011744 23566176
17:03:18 9631 8192000000 10618585344 10984988672 1676639184 16.989 100 79 159 3 1711698784 12461168 22598432
17:03:37 8786 8192000000 10645573856 11017072640 1695940128 17.151 100 79 157 1 1731977520 13190864 22846528
17:03:53 6093 8192000000 10655046048 11025977344 1714121504 17.303 100 84 168 0 1751313568 13206416 23985648
17:04:06 7918 8192000000 10673687872 11047374848 1728281904 17.421 100 81 161 0 1763654384 12155152 23217328
17:04:22 6318 8192000000 10678890800 11053015040 1741052592 17.527 100 79 158 1 1776245312 12734928 22457792
17:04:35 6526 8192000000 10695249632 11067576320 1751469104 17.614 100 87 174 2 1789514544 13560656 24484784
17:04:50 7240 8192000000 10695881568 11071881216 1761152384 17.694 100 83 163 1 1797857008 13036224 23668400
17:05:04 3930 8192000000 10704327552 11084222464 1767037760 17.743 100 84 168 0 1804725184 13956352 23731072
17:05:14 3275 8192000000 10704694656 11086315520 1771966672 17.783 100 77 154 0 1806853696 13406208 21480816
17:05:25 4080 8192000000 10721820560 11102965760 1785157808 17.892 100 85 170 0 1822428960 13246080 24025072
17:05:36 2567 8192000000 10736663472 11119136768 1800101712 18.015 100 87 174 1 1837732592 13323536 24307344
17:05:45 4053 8192000000 10743238400 11122655232 1801609328 18.027 100 89 176 2 1840323216 14125648 24588240
17:05:57 3137 8192000000 10741825024 11127455744 1811072448 18.105 100 81 163 0 1845426768 12133008 22221312
17:06:07 3076 8192000000 10755732480 11136466944 1816983840 18.153 100 90 180 3 1855291120 13094464 25212816
17:06:16 9343 8192000000 10756285952 11138248704 1817425424 18.157 100 88 176 0 1856540944 14228848 24886672
17:06:33 2447 8192000000 10761223152 11144257536 1819060400 18.170 100 84 167 2 1856452624 14431968 22960256
17:06:42 2215 8192000000 10774144128 11155693568 1821722672 18.192 100 90 177 1 1860609184 14482528 24403984
17:06:50 1408 8192000000 10783065936 11167010816 1839118224 18.334 100 92 183 2 1879729968 14212768 26398976
17:06:58 1786 8192000000 10790678288 11174510592 1843377376 18.368 100 91 182 0 1884672656 14816448 26478832
17:07:07 1681 8192000000 10793040032 11179433984 1854243392 18.457 100 93 190 2 1893739392 13704688 25791312
17:07:15 2624 8192000000 10794989648 11184545792 1857657984 18.484 100 88 177 2 1895562080 12187280 25716816
17:07:24 3045 8192000000 10801923456 11188633600 1861460912 18.515 100 85 168 2 1896622752 12039968 23121872
17:07:34 2358 8192000000 10811317136 11198103552 1866537984 18.556 100 93 185 2 1905398032 12971456 25888592
17:07:42 2041 8192000000 10812539408 11200425984 1866454992 18.556 100 95 190 1 1906153840 11787968 27910880
17:07:51 1833 8192000000 10822263472 11206905856 1866387936 18.555 100 92 187 1 1906103888 13654000 26061952
17:07:59 1922 8192000000 10819464448 11207548928 1870404224 18.588 100 95 190 2 1912162064 14978640 26779200
17:08:08 2086 8192000000 10813919184 11203231744 1870382896 18.587 100 94 189 1 1911477664 13657968 27436800
17:08:16 2155 8192000000 10810309760 11201200128 1871816352 18.599 100 88 175 0 1910581552 12331328 26433872
17:08:26 22412 8192000000 10772420544 11201212416 1869507664 18.580 100 63 125 1 1898686912 11067600 18111648
17:08:55 15945 8192000000 10810580064 11213987840 1875313184 18.627 100 61 122 1 1899305072 6145632 17846256
17:09:17 3000 8192000000 10822631136 11221090304 1881800272 18.680 100 75 145 2 1909566304 8034880 19731152
17:09:28 15352 8192000000 10824514704 11222138880 1884934160 18.705 100 72 141 2 1915731600 10546720 20250720
17:09:49 1260 8192000000 10842749904 11234553856 1893747488 18.776 100 95 191 2 1933320240 13153904 26418848
17:09:57 6466 8192000000 10821085504 11228180480 1889057824 18.738 100 69 137 1 1920278400 12426320 18794256
17:10:10 7275 8192000000 10812183248 11228532736 1887624000 18.727 100 50 98 2 1911117424 10248864 13244560
17:10:24 4334 8192000000 10823494416 11228020736 1886374336 18.717 100 43 87 1 1907468160 8196048 12897776
17:10:35 4194 8192000000 10802391152 11225374720 1885006448 18.706 100 35 70 1 1903040112 8151264 9882400
17:10:46 3400 8192000000 10804927632 11227639808 1888067440 18.730 100 40 80 1 1906665008 7360224 11237344
17:10:57 5667 8192000000 10797030720 11227070464 1887405968 18.725 100 34 66 3 1904413360 7129344 9878048
17:11:12 3793 8192000000 10814380368 11232862208 1894047280 18.778 100 51 102 2 1914770496 7204688 13518528
17:11:25 7188 8192000000 10802239136 11233533952 1892878224 18.769 100 36 72 1 1911455872 8350272 10227376
17:11:38 7758 8192000000 10807203392 11234832384 1893072928 18.771 100 22 44 1 1905990768 6470000 6447840
17:11:56 11483 8192000000 10803763200 11236044800 1894977360 18.786 100 25 50 1 1908244048 5748208 7518480
17:12:13 10716 8192000000 10800915040 11234996224 1894644832 18.783 100 20 40 2 1906171744 5539200 5987712
17:12:32 11745 8192000000 10812638224 11242643456 1897597712 18.807 100 28 56 0 1912400720 7070592 7732416
17:12:55 10964 8192000000 10827238480 11245764608 1899780816 18.825 100 19 36 2 1910020384 5320240 4919328
17:13:13 15735 8192000000 10822332080 11253694464 1906365328 18.877 100 32 64 4 1926984976 10340512 10279136
17:13:37 50751 8192000000 10819298112 11252822016 1905305328 18.869 100 19 38 0 1924394576 13836576 5252672
17:14:35 11916 8192000000 10815084320 11252183040 1903643568 18.856 100 34 68 0 1920139952 7551104 8945280
17:14:55 8787 8192000000 10821863264 11253424128 1907244528 18.885 100 33 65 1 1923541152 6404448 9892176
17:15:13 6859 8192000000 10825397520 11259191296 1909774352 18.905 100 36 72 2 1927642800 7578592 10289856
17:15:27 7435 8192000000 10817683776 11255468032 1907875008 18.890 100 18 36 0 1919345616 6188704 5281904
17:15:43 6651 8192000000 10826005120 11258372096 1908881584 18.898 100 18 36 2 1918849808 5400512 4567712
17:15:57 12804 8192000000 10799811088 11231051776 1850898256 18.429 97 26 52 2 1864668672 6302000 7468416
17:16:16 6317 8192000000 10810149376 11239849984 1879249328 18.659 99 29 58 3 1894089888 7222832 7617728
17:16:33 9336 8192000000 10807728848 11238121472 1874510640 18.621 99 18 36 1 1888698704 9507728 4680336
17:16:49 6056 8192000000 10803930320 11238731776 1895546016 18.790 100 38 77 1 1913263680 6334592 11383072
17:17:03 7371 8192000000 10788124832 11218292736 1847114304 18.399 98 36 73 0 1864607168 7380960 10111904
17:17:19 10401 8192000000 10789845392 11224612864 1851824320 18.437 98 19 38 2 1862478064 5598832 5054912
17:17:36 7715 8192000000 10774874160 11195985920 1762410992 17.704 93 26 53 0 1774890224 5020768 7458464
17:17:51 5869 8192000000 10743443888 11172003840 1802717088 18.036 97 18 35 1 1813184736 5180608 5287040
17:18:06 12814 8192000000 10759748688 11183767552 1794856480 17.972 97 20 40 1 1806171776 5816528 5498768
17:18:26 63211 8192000000 10704830416 11128643584 1693366560 17.130 91 34 69 0 1707875008 4472416 10036032
17:19:35 21019 8192000000 10733237296 11157991424 1758595120 17.673 96 18 36 2 1768645568 5394096 4656352
17:20:04 7056 8192000000 10758671424 11172601856 1800333488 18.017 98 26 52 1 1817541616 9979392 7228736
17:20:17 6897 8192000000 10718219680 11146076160 1787730640 17.913 98 32 64 0 1803941936 7188928 9022368
17:20:32 8901 8192000000 10721532016 11134468096 1755617088 17.648 96 22 42 2 1767475872 5824128 6034656
17:20:47 6713 8192000000 10684720288 11105824768 1739378448 17.513 96 20 40 0 1750604704 5259168 5967088
17:21:00 5427 8192000000 10710616576 11125231616 1771464112 17.779 98 31 62 2 1787286448 6624352 9197984
17:21:12 6462 8192000000 10697524112 11117735936 1737917904 17.501 96 21 41 1 1749550864 4569760 7063200
17:21:26 10906 8192000000 10698126640 11105505280 1717857520 17.334 96 26 52 0 1731397840 5614304 7926016
17:21:43 10964 8192000000 10722411216 11135012864 1792668992 17.954 100 22 45 0 1804850848 5713296 6468560
17:22:02 11302 8192000000 10736839696 11149942784 1798157584 17.999 99 23 46 0 1810801376 5523920 7119872
17:22:21 10323 8192000000 10729668128 11157921792 1822571200 18.199 100 26 52 0 1836065760 5157440 8337120
17:22:39 11326 8192000000 10757774592 11174580224 1830708640 18.265 100 22 43 1 1842831136 5748640 6373856
17:22:58 7823 8192000000 10756597696 11178872832 1823637152 18.207 99 18 36 0 1833854656 5311984 4905520
17:23:12 21083 8192000000 10756401152 11183386624 1846443584 18.393 100 26 52 2 1859760672 5833344 7483744
17:23:40 56928 8192000000 10766680768 11193597952 1849552464 18.418 100 32 65 1 1864241616 5156512 9532640
17:24:45 9489 8192000000 10759547984 11194142720 1853203392 18.448 100 19 39 0 1863855648 5628832 5023424
17:25:02 10027 8192000000 10773639824 11200364544 1857803536 18.485 100 21 43 0 1869444704 5555232 6085936
17:25:18 9929 8192000000 10791378960 11210100736 1865488096 18.548 100 35 71 3 1881052752 5783488 9781168
17:25:38 7194 8192000000 10782684288 11208093696 1866813088 18.558 100 31 62 0 1881745184 5182704 9749392
17:25:53 9009 8192000000 10773819392 11208253440 1869473552 18.580 100 31 62 2 1884092064 5527664 9090848
17:26:08 8708 8192000000 10781749856 11212316672 1868959456 18.576 100 21 41 3 1880326160 5598512 5768192
17:26:26 8815 8192000000 10781546112 11214548992 1868227088 18.570 100 18 36 1 1882310928 9414560 4669280
17:26:44 9015 8192000000 10781557472 11213475840 1872389104 18.604 100 38 76 1 1889507328 5509952 11608272
17:27:06 4124 8192000000 10824291520 11233837056 1887412944 18.725 100 52 101 0 1908714400 7116304 14185152
17:27:18 12088 8192000000 10850143952 11255463936 1904320304 18.861 100 67 133 2 1932260800 9533680 18406816
17:27:46 5520 8192000000 10847245264 11261861888 1910859312 18.914 100 65 129 0 1939546624 10828416 17858896
17:28:00 57946 8192000000 10840904208 11267579904 1913072752 18.931 100 50 100 1 1937546240 10703632 13769856
17:29:11 10536 8192000000 10840927536 11257921536 1904301552 18.861 99 57 112 1 1928472080 8402288 15768240
17:29:29 10604 8192000000 10856207488 11274485760 1921434000 18.998 100 67 135 0 1949983424 9617008 18932416
17:29:50 31245 8192000000 10863262400 11282104320 1922972944 19.011 100 58 113 2 1952741168 13124960 16643264
17:30:30 15093 8192000000 10859178592 11288395776 1927220560 19.045 100 53 106 1 1956617952 13990016 15407376
17:30:52 11478 8192000000 10860566560 11288805376 1930323184 19.069 100 49 95 1 1957018208 13098848 13596176
17:31:12 11728 8192000000 10864357840 11291017216 1935891824 19.114 100 47 94 1 1962309440 12232976 14184640
17:31:33 27578 8192000000 10890199904 11315056640 1945444048 19.190 100 51 102 2 1979446112 19227280 14774784
17:32:08 9378 8192000000 10887441280 11314888704 1950319936 19.229 100 54 108 2 1980168912 14972224 14876752
17:32:25 10931 8192000000 10888097968 11320557568 1954190512 19.260 100 52 104 1 1985777072 15625392 15961168
17:32:47 19152 8192000000 10887907648 11321303040 1953833664 19.257 100 41 82 0 1981022736 15025056 12164016
17:33:12 5417 8192000000 10905145840 11329400832 1962696016 19.327 100 57 114 1 1995953328 16614320 16642992
17:33:31 4079 8192000000 10912957600 11333672960 1964391280 19.341 100 58 116 0 1999656896 18150832 17114784
17:33:43 14602 8192000000 10902608432 11326185472 1945850064 19.193 99 56 113 1 1981039760 18322736 16866960
17:34:11 18129 8192000000 10889423664 11323883520 1943124208 19.172 99 47 94 0 1974271280 17106592 14040480
17:34:40 16645 8192000000 10892614208 11327066112 1956108784 19.275 100 50 100 2 1988097776 17034208 14954784
17:35:13 5586 8192000000 10907328288 11332677632 1960508544 19.310 100 48 92 2 1990016560 15990256 13517760
17:35:25 3212 8192000000 10902775008 11330162688 1958772672 19.296 100 60 120 2 1992652784 16415776 17464336
17:35:35 4667 8192000000 10915476144 11338391552 1968108160 19.370 100 72 144 1 2007769184 18440656 21220368
17:35:48 5452 8192000000 10923418320 11350331392 1954170448 19.260 99 61 123 3 1992780144 21140496 17469200
17:36:01 6295 8192000000 10935994336 11349712896 1975297744 19.427 100 81 162 2 2021217808 22694688 23225376
17:36:15 3948 8192000000 10940046240 11354988544 1976316528 19.436 100 66 132 1 2018420096 22802624 19300944
17:36:26 5056 8192000000 10924888192 11345969152 1959877952 19.305 99 72 144 1 2003521104 22668320 20974832
17:36:38 1964 8192000000 10943216448 11356848128 1983064960 19.489 100 85 168 2 2030683472 22615216 25003296
17:36:47 15817 8192000000 10936520144 11364450304 1981105888 19.473 100 60 120 1 2021825424 23238768 17480768
17:37:18 8620 8192000000 10936180992 11363180544 1985284080 19.507 100 58 115 0 2026177136 23824992 17068064
17:37:34 7833 8192000000 10944192144 11373416448 1988210752 19.530 100 61 122 1 2030589888 24568624 17810512
17:37:53 17823 8192000000 10934548368 11367800832 1985468768 19.508 100 54 105 0 2026725840 24972448 16284624
17:38:19 2823 8192000000 10949630832 11373981696 1988983104 19.536 100 68 136 0 2035241568 26242528 20015936
17:38:29 3848 8192000000 10948400576 11378507776 1994197792 19.577 100 66 132 0 2041007552 26669024 20140736
17:38:40 2313 8192000000 10970881536 11384307712 1999224144 19.617 100 73 144 1 2048256816 27897344 21135328
17:38:51 6858 8192000000 10962536480 11392888832 2002526768 19.643 100 65 131 1 2050788000 28630352 19630880
17:39:06 1797 8192000000 10975727376 11396984832 2006981984 19.678 100 78 153 0 2058973520 29519040 22472496
17:39:16 6629 8192000000 10954214288 11389042688 1984685680 19.502 99 60 119 0 2028813040 26346720 17780640
17:39:36 12441 8192000000 10951264960 11386667008 1998256656 19.609 100 52 103 1 2041435840 27101984 16077200
17:40:10 10171 8192000000 10966271280 11404464128 2008918592 19.693 100 48 94 0 2050042208 26914880 14208736
17:40:29 7346 8192000000 10968679136 11401383936 1998433840 19.610 99 62 124 0 2044869840 27472928 18963072
17:40:45 6729 8192000000 10974108192 11406102528 2011012448 19.709 100 66 132 1 2060419248 29576816 19829984
17:41:02 2997 8192000000 10979186400 11403677696 2007434128 19.681 100 70 141 1 2061116368 32384624 21297616
17:41:14 2705 8192000000 10979829360 11395612672 2000706512 19.628 100 83 163 1 2059490000 34362544 24420944
17:41:25 5752 8192000000 10971871632 11398320128 2004903840 19.661 100 67 134 3 2059947936 34429120 20614976
17:41:40 7917 8192000000 10983207504 11415437312 2015457600 19.744 100 68 135 1 2072648880 35587936 21603344
17:41:58 4259 8192000000 10966179712 11395563520 1991100576 19.552 99 61 122 0 2047676112 37237152 19338384
17:42:12 5339 8192000000 10973684816 11407273984 2004880144 19.661 100 61 122 1 2059705104 35968112 18856848
17:42:25 2518 8192000000 10964233264 11385434112 1988949952 19.535 99 77 154 1 2049810160 36548576 24311632
17:42:34 2841 8192000000 10978877280 11403821056 2007290640 19.680 100 75 150 1 2068558768 37668576 23599552
17:42:49 7306 8192000000 10977136512 11406528512 2004139600 19.655 100 69 138 0 2065555472 38814128 22601744
17:43:22 9527 8192000000 10976678224 11416416256 2007930592 19.685 100 48 96 1 2065137712 41512816 15694304
17:43:39 13434 8192000000 10974698144 11404517376 1968124016 19.371 98 59 118 2 2030081152 43146288 18810848
17:44:01 7255 8192000000 10981310912 11409866752 1998660480 19.612 100 62 123 0 2064707328 45447472 20599376
17:44:17 7592 8192000000 10984512368 11415613440 2001246192 19.633 100 64 128 2 2067022416 45243248 20532976
17:44:36 5416 8192000000 10995078304 11425177600 2006636576 19.675 100 66 132 2 2073999600 46213136 21149888
17:44:49 4114 8192000000 10994873952 11418763264 2007263584 19.680 100 76 151 1 2078830640 48399296 23167760
17:44:59 4860 8192000000 11010785584 11428663296 2013419200 19.728 100 83 164 0 2089192480 50394912 25378368
17:45:14 1694 8192000000 10988596512 11417583616 1990201040 19.545 99 84 169 1 2066693280 50509808 25982432
17:45:26 1498 8192000000 10980535040 11393028096 1982323808 19.483 100 93 186 2 2060232384 50326672 27581904
17:45:34 1084 8192000000 10970556864 11382820864 1972688928 19.407 100 94 186 1 2051765584 50972320 28104336
17:45:44 1250 8192000000 10987379584 11398287360 1966860880 19.361 99 89 178 3 2046949120 53113088 26975152
17:45:52 1445 8192000000 10981493760 11395928064 1989782592 19.542 100 87 174 2 2065361680 49390992 26188096
17:46:01 2111 8192000000 10966517392 11380195328 1973431520 19.413 100 87 172 0 2046942624 46783824 26727280
17:46:11 1521 8192000000 10977058352 11392475136 1984509088 19.500 100 88 172 2 2058237280 46459888 27268304
17:46:22 3814 8192000000 10963612464 11379740672 1967254048 19.364 99 84 168 0 2040677808 46826176 26597584
17:46:34 7365 8192000000 10938710448 11361898496 1937981344 19.131 98 62 121 0 2006345264 47997904 20366016
17:47:04 9659 8192000000 10941548864 11382853632 1971133856 19.394 100 40 78 2 2025751184 41544032 13073296
17:47:25 11155 8192000000 10947660400 11382968320 1965871264 19.353 99 50 99 2 2027111312 44457856 16782192
17:47:50 3754 8192000000 10944895360 11361329152 1950020704 19.227 100 80 159 0 2022515808 46194320 26300784
17:48:03 2073 8192000000 10934888176 11358900224 1949120768 19.219 100 65 129 2 2015648000 45879888 20647344
17:48:12 8013 8192000000 10910334624 11346018304 1927398880 19.046 99 52 104 1 1984756640 41380832 15976928
17:48:27 9365 8192000000 10864724960 11303481344 1848564176 18.410 96 35 70 0 1902170464 42108960 11497328
17:48:44 12643 8192000000 10875342000 11306115072 1876993184 18.641 98 33 66 2 1924148080 36719952 10434944
17:49:03 18662 8192000000 10888594816 11324084224 1900454192 18.830 99 29 58 3 1948501248 38444752 9602304
17:49:36 12804 8192000000 10891335600 11325444096 1918237376 18.973 100 34 68 2 1969909648 39786784 11885488
17:50:09 7040 8192000000 10922494544 11354202112 1944868240 19.186 100 58 114 0 2003401744 40675632 17857872
17:50:35 24376 8192000000 10914621728 11358236672 1927089056 19.044 99 32 64 1 1982626592 44280160 11257376
17:51:07 19892 8192000000 10907742944 11354226688 1934109376 19.100 100 27 54 0 1989212096 45556720 9546000
17:51:38 15355 8192000000 10916730496 11355365376 1938230992 19.133 100 36 71 1 1996357856 46496192 11630672
17:52:05 17494 8192000000 10898853168 11347144704 1935576064 19.111 100 30 60 4 1990458560 44796928 10085568
17:52:29 16001 8192000000 10898802464 11340951552 1912921712 18.930 99 26 52 2 1965873312 42989296 9962304
17:52:58 12277 8192000000 10909905696 11347079168 1928171248 19.052 100 34 67 1 1987191520 47209488 11810784
17:53:17 25061 8192000000 10910921632 11366920192 1932586240 19.088 100 27 54 1 1994951408 52018432 10346736
17:54:29 34083 8192000000 10872099664 11341090816 1917940112 18.970 99 22 44 2 1960152496 34951968 7260416
17:55:14 48559 8192000000 10890089984 11317420032 1883149184 18.691 97 24 50 1 1902401744 12369088 6883472
17:56:11 20364 8192000000 10866858112 11325952000 1937700416 19.128 100 38 74 0 1960458080 11692304 11065360
17:57:12 129412 8192000000 10899215760 11352940544 1906908096 18.882 97 13 26 0 1918917184 8923328 3085760
17:59:35 48209 8192000000 10907264112 11354910720 1953182608 19.252 99 38 75 1 1976266048 12534000 10549440
18:00:39 144331 8192000000 10855205472 11304042496 1838359152 18.327 94 13 26 1 1853162080 10970064 3832864
18:03:10 77912 8192000000 10880896752 11326267392 1893498496 18.774 98 18 36 2 1906404672 7409744 5496432
18:04:40 30538 8192000000 10882406336 11329368064 1928004832 19.051 99 27 54 1 1945773328 10234032 7534464
18:05:19 46322 8192000000 10876284896 11338387456 1934358880 19.102 99 34 68 3 1958887280 15219856 9308544
18:06:13 74712 8192000000 10882627232 11347501056 1951387456 19.238 100 21 41 0 1969966656 10940832 7638368
18:07:40 3237 8192000000 10899341072 11355537408 1955841488 19.273 99 31 63 2 1976557984 11005600 9710896
18:07:49 29991 8192000000 10916663088 11376185344 1977496384 19.445 100 25 50 2 1999943056 14810512 7636160
18:08:28 20996 8192000000 10916369312 11380523008 1982030800 19.481 100 19 38 0 2004263344 16579680 5652864
18:09:03 28475 8192000000 10939126032 11389849600 1983915808 19.496 100 27 54 1 2012594720 20605104 8073808
18:09:40 25965 8192000000 10934006992 11389460480 1990352464 19.547 100 41 81 4 2021141728 17887568 12901696
18:10:15 49570 8192000000 10926267024 11396624384 1995682688 19.589 100 44 88 1 2031823072 22772368 13368016
18:11:10 22654 8192000000 10942711648 11416645632 1998058976 19.607 100 20 41 1 2025938944 22104080 5775888
18:12:06 66608 8192000000 10941275040 11420684288 1996319408 19.594 100 19 38 0 2034335968 31930400 6086160
18:13:23 38161 8192000000 10942929408 11410042880 2004769424 19.660 100 16 32 1 2031957952 22013152 5175376
18:14:08 32487 8192000000 10943117568 11410935808 2002890864 19.646 100 13 26 1 2028529152 21196864 4441424
18:14:48 53968 8192000000 10931921456 11420823552 2001073072 19.631 100 18 36 0 2034886096 27867856 5945168
18:16:07 59240 8192000000 10928878896 11396857856 1996263344 19.593 100 36 72 1 2025368976 18324400 10781232
18:17:15 44974 8192000000 10906720096 11380277248 1957361680 19.285 98 25 49 2 1973304848 9507072 6436096
18:18:14 52585 8192000000 10938731696 11388968960 1980417920 19.468 100 14 28 1 1994651504 10250736 3982848
18:19:15 21974 8192000000 10922128080 11386060800 1976648576 19.438 99 47 93 1 2002849296 12884144 13316576
18:19:45 27605 8192000000 10915404224 11390914560 1984197008 19.498 100 19 38 1 2002613968 12667088 5749872
18:20:18 104171 8192000000 10910718672 11385831424 1923729344 19.017 97 12 23 0 1936467024 9411056 3326624
18:22:09 59738 8192000000 10890030912 11366076416 1892603920 18.767 95 14 28 1 1906410416 9747600 4058896
18:23:15 57198 8192000000 10884609264 11346780160 1909800816 18.905 97 13 26 0 1921352480 7873824 3677840
18:24:19 38137 8192000000 10897645888 11353980928 1940614192 19.152 99 32 64 1 1961574512 11492752 9467568
18:25:12 74727 8192000000 10889551456 11369787392 1908254832 18.893 97 15 30 1 1926508336 13811952 4441552
18:26:48 51765 8192000000 10873953504 11344220160 1870719344 18.590 95 11 22 1 1885887344 12327616 2840384
18:27:46 38737 8192000000 10883558912 11331887104 1879920592 18.664 96 23 46 0 1893527792 6702352 6904848
18:28:31 28461 8192000000 10887776624 11343540224 1941181168 19.156 99 28 56 2 1956667328 7980496 7505664
18:29:07 87676 8192000000 10882847680 11361165312 1868940592 18.576 95 10 20 0 1882553536 11129040 2483904
18:30:41 94919 8192000000 10843004272 11300274176 1798339552 18.000 92 20 40 2 1813725216 9905248 5480416
18:32:45 91098 8192000000 10876034528 11346481152 1928087296 19.052 99 28 56 1 1949116304 13067248 7961760
18:34:22 54161 8192000000 10886495456 11340984320 1900064272 18.827 97 26 51 2 1921277984 14318176 6895536
18:35:44 12381 8192000000 10882722080 11347017728 1947804896 19.209 100 36 70 1 1969837584 12081376 9951312
18:36:03 23741 8192000000 10882381024 11353206784 1932378992 19.086 99 13 26 0 1944741312 8947824 3414496
18:36:37 21991 8192000000 10856673296 11316219904 1899553104 18.823 98 38 76 1 1922169456 11885840 10730512
18:37:11 91481 8192000000 10880949488 11341193216 1877798688 18.647 96 22 45 0 1903382688 19013088 6570912
18:39:52 56329 8192000000 10869340128 11344797696 1915272544 18.949 98 13 26 1 1938428016 18955184 4200288
18:41:25 91432 8192000000 10853093472 11327078400 1910561968 18.911 98 15 30 1 1926480688 11454960 4463760
18:43:55 59260 8192000000 10889778848 11378704384 1961379088 19.317 100 6 12 1 1975033776 11973232 1681456
18:45:09 68433 8192000000 10901103664 11384623104 1948055120 19.211 99 9 18 1 1965390256 14970064 2365072
18:46:24 27088 8192000000 10927319168 11394654208 1994400096 19.579 100 27 54 1 2014561824 11747104 8414624
18:46:57 51339 8192000000 10922256368 11389874176 1973055184 19.410 99 22 44 2 1992518784 13143152 6320448
18:48:00 67708 8192000000 10905900192 11393974272 1938528656 19.135 98 19 38 2 1965460384 21300112 5631616
18:49:14 35144 8192000000 10901054976 11372838912 1944408128 19.182 99 16 32 4 1966493040 17423488 4661424
18:50:01 134449 8192000000 10894249520 11377377280 1911278736 18.917 97 20 39 0 1930737024 14104880 5353408
18:52:22 34472 8192000000 10902175296 11363463168 1921882976 19.002 97 26 53 1 1943060608 13828352 7349280
18:53:08 46008 8192000000 10875867872 11347640320 1894637744 18.783 97 16 32 2 1914106864 14861520 4607600
18:54:03 72558 8192000000 10904095488 11366608896 1923761888 19.017 98 24 48 3 1941848144 11761584 6324672
18:55:25 38632 8192000000 10920449104 11365531648 1947822768 19.209 99 35 70 1 1967397280 9647376 9927136
18:56:12 33280 8192000000 10930398256 11385577472 1979437648 19.460 100 49 98 4 2008825920 15309488 14078784
18:56:52 98686 8192000000 10893966816 11381149696 1937868848 19.130 98 17 34 0 1962378064 19865664 4643552
18:59:24 86016 8192000000 10904490896 11378946048 1944866704 19.186 98 26 50 2 1976045152 24099648 7078800
19:00:57 16513 8192000000 10904912032 11384860672 1965240000 19.348 100 13 26 0 1999271968 30808704 3223264
19:01:25 57205 8192000000 10899545600 11382321152 1957179952 19.284 99 22 44 0 1979919216 16674048 6065216
19:02:28 99966 8192000000 10904229184 11385819136 1942762688 19.169 98 13 26 0 1960616848 14661248 3192912
19:04:17 47936 8192000000 10909783856 11386339328 1978604688 19.454 100 7 14 0 1988754976 8149664 2000624
19:05:38 47805 8192000000 10931479664 11399151616 1994178672 19.577 100 21 39 1 2006216576 6302208 5735696
19:06:34 20769 8192000000 10928133392 11392098304 1980749056 19.471 99 29 58 0 1997450768 7901312 8800400
19:07:19 42821 8192000000 10939173632 11412164608 2006701488 19.676 100 39 77 0 2031823488 14368080 10753920
19:08:23 49220 8192000000 10925443136 11392131072 1974771328 19.423 99 21 42 0 1996080304 15016880 6292096
19:09:19 74648 8192000000 10908333792 11399757824 1931510800 19.079 97 16 31 1 1953160480 17156816 4492864
19:11:03 38896 8192000000 10907298944 11375353856 1946706704 19.200 98 17 34 0 1959081280 7794768 4579808
19:11:51 28191 8192000000 10934575744 11391537152 1985992576 19.512 100 45 90 1 2008775296 9669968 13112752
19:12:38 53260 8192000000 10895003424 11382976512 1944830608 19.185 98 14 28 1 1961523504 12778128 3914768
19:13:41 52997 8192000000 10906700144 11367759872 1922411040 19.006 97 15 30 4 1935956704 9398624 4147040
19:14:42 59297 8192000000 10893525712 11362988032 1927396048 19.046 98 20 40 1 1943439168 10784800 5258320
19:15:49 25486 8192000000 10902647728 11362947072 1960828560 19.313 99 31 62 0 1978087360 8739600 8519200
19:16:21 42334 8192000000 10912874960 11356254208 1902757232 18.848 96 31 61 1 1919728224 8325808 8645184
19:17:10 12944 8192000000 10908377824 11362566144 1949923424 19.226 99 36 72 0 1968950768 9330112 9697232
19:17:31 21011 8192000000 10893716416 11347357696 1941539328 19.159 99 36 71 3 1962782896 10836800 10406768
19:18:02 117005 8192000000 10879667952 11348377600 1920027856 18.987 98 28 56 1 1935697024 7742480 7926688
19:20:06 69460 8192000000 10882825264 11357061120 1938544896 19.135 99 22 44 1 1958373888 13779296 6049696
19:21:22 36947 8192000000 10866030096 11343237120 1939739360 19.145 99 14 28 0 1952955440 8620048 4596032
19:22:06 52636 8192000000 10867542416 11339071488 1893638864 18.775 97 11 22 0 1907863824 11360032 2864928
19:23:05 41767 8192000000 10859036416 11337097216 1908567360 18.895 98 11 21 0 1918845440 7516416 2761664
19:23:55 25687 8192000000 10868315120 11347177472 1952672352 19.248 100 13 25 1 1963592576 6631968 4288256
19:24:27 63810 8192000000 10870237680 11341762560 1883365024 18.692 96 12 24 0 1894400176 7413072 3622080
19:25:43 88392 8192000000 9604096112 9932005376 723711264 8.117 37 9 18 0 732900128 6575072 2613792

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 02-11-2020 19:29:26 to 02-11-2020 19:29:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 90 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-11-2020 19:29:59 to 02-11-2020 19:30:01.

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          239184
MON$OLDEST_ACTIVE               241069
MON$OLDEST_SNAPSHOT             241069
MON$NEXT_TRANSACTION            241069
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                       2047520
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
:233: 
:234: mscs-test-161.budzdorov.ru    Mon Nov  2 19:27:13 2020
:235:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:236: 
:237: 
:238: mscs-test-161.budzdorov.ru    Mon Nov  2 19:27:23 2020
:239:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:240: 
--- end of diff output ---

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

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