Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.12.2020 22:29
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 17454424 kB
MemAvailable 31639304 kB
Buffers 0 kB
Cached 14276752 kB
SwapCached 1964 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-03 22:27:02
DTS_END                         2020-12-03 22:27:02.2060
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/48154
TRN_ID                          244216
ATT_ID                          705
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: 9454.03 23713 1134483
customer order: creation 175.33 355 21039
customer order: refuse 15.51 332 1861
order to supplier: creation 46.10 1228 5532
order to supplier: removal 3.48 97452 418
invoice (draft): creation 47.23 3245 5667
invoice (draft): removal 54.42 759 6530
invoice accept: apply 42.34 17198 5081
invoice accept: cancel 48.49 785 5819
customer reserve: creation 3973.32 167 476798
customer reserve: removal 4740.34 56 568841
realization accept: apply 86.43 150 10372
realization accept: cancel 85.93 102 10312
payment from customer: creation 61.78 98 7413
payment from customer: removal 6.00 62 720
payment to supplier: creation 50.64 115 6077
payment to supplier: removal 3.68 92 441
service: total inventory turnovers 5.12 1077 614
service: total monetary turnovers 7.09 34 851
service: aggregate perf. data 0.78 22607 93
service: refresh index statistics 0.03 328350 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 03-12-2020 22:29:32 to 03-12-2020 22:29:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3923
TEST_TIME 2 3628
TEST_TIME 3 5306
TEST_TIME 4 4626
TEST_TIME 5 4792
TEST_TIME 6 4576
TEST_TIME 7 4378
TEST_TIME 8 5044
TEST_TIME 9 5013
TEST_TIME 10 5099
TEST_TIME 11 5616
TEST_TIME 12 6043
TEST_TIME 13 6634
TEST_TIME 14 6814
TEST_TIME 15 6989
TEST_TIME 16 7244
TEST_TIME 17 7855
TEST_TIME 18 8582
TEST_TIME 19 8699
TEST_TIME 20 8999
TEST_TIME 21 9126
TEST_TIME 22 9074
TEST_TIME 23 9795
TEST_TIME 24 10251
TEST_TIME 25 10899
TEST_TIME 26 11100
TEST_TIME 27 11439
TEST_TIME 28 11477
TEST_TIME 29 11235
TEST_TIME 30 10991
TEST_TIME 31 10796
TEST_TIME 32 10858
TEST_TIME 33 10837
TEST_TIME 34 10799
TEST_TIME 35 10688
TEST_TIME 36 10565
TEST_TIME 37 10501
TEST_TIME 38 10337
TEST_TIME 39 10421
TEST_TIME 40 10511
TEST_TIME 41 10342
TEST_TIME 42 10231
TEST_TIME 43 10125
TEST_TIME 44 10195
TEST_TIME 45 10112
TEST_TIME 46 10146
TEST_TIME 47 10053
TEST_TIME 48 9988
TEST_TIME 49 9899
TEST_TIME 50 9848
TEST_TIME 51 9760
TEST_TIME 52 9809
TEST_TIME 53 9846
TEST_TIME 54 9787
TEST_TIME 55 9854
TEST_TIME 56 9829
TEST_TIME 57 9924
TEST_TIME 58 9859
TEST_TIME 59 9853
TEST_TIME 60 9980
TEST_TIME 61 9964
TEST_TIME 62 10064
TEST_TIME 63 10116
TEST_TIME 64 10211
TEST_TIME 65 10192
TEST_TIME 66 10152
TEST_TIME 67 10074
TEST_TIME 68 10101
TEST_TIME 69 9993
TEST_TIME 70 9999
TEST_TIME 71 9947
TEST_TIME 72 9942
TEST_TIME 73 9914
TEST_TIME 74 9883
TEST_TIME 75 9838
TEST_TIME 76 9753
TEST_TIME 77 9721
TEST_TIME 78 9714
TEST_TIME 79 9669
TEST_TIME 80 9654
TEST_TIME 81 9727
TEST_TIME 82 9707
TEST_TIME 83 9770
TEST_TIME 84 9799
TEST_TIME 85 9751
TEST_TIME 86 9761
TEST_TIME 87 9839
TEST_TIME 88 9909
TEST_TIME 89 9933
TEST_TIME 90 9930
TEST_TIME 91 9948
TEST_TIME 92 9884
TEST_TIME 93 9840
TEST_TIME 94 9793
TEST_TIME 95 9791
TEST_TIME 96 9760
TEST_TIME 97 9713
TEST_TIME 98 9691
TEST_TIME 99 9677
TEST_TIME 100 9627
TEST_TIME 101 9646
TEST_TIME 102 9642
TEST_TIME 103 9639
TEST_TIME 104 9649
TEST_TIME 105 9621
TEST_TIME 106 9644
TEST_TIME 107 9672
TEST_TIME 108 9683
TEST_TIME 109 9667
TEST_TIME 110 9652
TEST_TIME 111 9649
TEST_TIME 112 9720
TEST_TIME 113 9697
TEST_TIME 114 9707
TEST_TIME 115 9652
TEST_TIME 116 9668
TEST_TIME 117 9623
TEST_TIME 118 9590
TEST_TIME 119 9537
TEST_TIME 120 9459

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-12-2020 22:29:35 to 03-12-2020 22:29:39.

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 1574921 1574921 0 0.00 0 19211 6 0 0
doc_list_biud 1574921 1574921 0 0.00 0 64200 26 0 0
sp_add_invoice_to_stock 5191 5081 110 2.11 34 166680 17199 0 110
sp_cancel_adding_invoice 5819 5819 0 0.00 4 59846 786 0 0
sp_cancel_client_order 1861 1861 0 0.00 4 11385 332 0 0
sp_cancel_customer_reserve 568841 568841 0 0.00 1 64203 57 0 0
sp_cancel_pay_from_customer 720 720 0 0.00 2 4607 63 0 0
sp_cancel_pay_to_supplier 441 441 0 0.00 2 6697 93 0 0
sp_cancel_supplier_invoice 6536 6530 6 0.09 2 21028 759 0 6
sp_cancel_supplier_order 418 418 0 0.00 9 1363036 97452 0 0
sp_cancel_write_off 10312 10312 0 0.00 1 10353 102 0 0
sp_client_order 21039 21039 0 0.00 3 72387 355 0 0
sp_customer_reserve 476798 476798 0 0.00 0 95778 168 0 0
sp_fill_shopping_cart 32226 32226 0 0.00 1 11182 36 0 0
sp_fill_shopping_cart_clo_res 476796 476796 0 0.00 0 18713 14 0 0
sp_get_clo_for_invoice 5073 5073 0 0.00 0 32497 294 0 0
sp_kill_cost_storno 17292 17292 0 0.00 0 8531 52 0 0
sp_kill_qstorno_ret_qs2qd 1154942 1154942 0 0.00 0 64182 31 0 0
sp_kill_qty_storno 609225 609225 0 0.00 0 64200 67 0 0
sp_lock_selected_doc 21450 21450 0 0.00 0 7953 3 0 0
sp_make_cost_storno 28934 28934 0 0.00 0 13747 45 0 0
sp_multiply_rows_for_pdistr 28934 28934 0 0.00 0 7745 24 0 0
sp_multiply_rows_for_qdistr 21039 21039 0 0.00 0 72363 167 0 0
sp_pay_from_customer 7413 7413 0 0.00 4 32353 99 0 0
sp_pay_to_supplier 6077 6077 0 0.00 5 40456 116 0 0
sp_payment_common 13490 13490 0 0.00 1 40087 32 0 0
sp_qd_handle_on_cancel_clo 1861 1861 0 0.00 0 11376 308 0 0
sp_qd_handle_on_invoice_upd_sts 10891 10891 0 0.00 0 16772 308 0 0
sp_qd_handle_on_reserve_upd_sts 10372 10372 0 0.00 0 19568 52 0 0
sp_reserve_write_off 10372 10372 0 0.00 7 19586 151 0 0
sp_supplier_invoice 5667 5667 0 0.00 6 76424 3246 0 0
sp_supplier_order 5532 5532 0 0.00 6 27521 1228 0 0
srv_aggregate_perf_data 93 93 0 0.00 2594 316995 22608 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1191 111954 33776 0 0
srv_find_qd_qs_mism 1084753 1084753 0 0.00 0 18980 5 0 0
srv_make_invnt_saldo 614 614 0 0.00 23 88395 1077 0 0
srv_make_money_saldo 851 851 0 0.00 0 3813 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 248132 387305 328350 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5081 5081 0 0.00 0 17374 179 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 15598 123 0 0
t$perf-norm:sp_cancel_client_order 1861 1861 0 0.00 0 9851 29 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 1800 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 720 720 0 0.00 0 1108 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 441 441 0 0.00 0 1230 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 977 11 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 16688 1717 0 0
t$perf-norm:sp_cancel_write_off 1025 1025 0 0.00 0 1785 7 0 0
t$perf-norm:sp_client_order 21039 21039 0 0.00 0 11589 19 0 0
t$perf-norm:sp_customer_reserve 1004 1004 0 0.00 0 1826 6 0 0
t$perf-norm:sp_pay_from_customer 7413 7413 0 0.00 0 23685 16 0 0
t$perf-norm:sp_pay_to_supplier 6077 6077 0 0.00 0 7275 12 0 0
t$perf-norm:sp_reserve_write_off 10372 10372 0 0.00 0 9729 14 0 0
t$perf-norm:sp_supplier_invoice 5667 5667 0 0.00 0 8733 22 0 0
t$perf-norm:sp_supplier_order 5532 5532 0 0.00 0 7555 16 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 108 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 105 2 0 0
t$perf-norm:srv_make_invnt_saldo 614 614 0 0.00 0 1478 18 0 0
t$perf-norm:srv_make_money_saldo 851 851 0 0.00 0 4285 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 4 0 0
v_add_invoice_to_stock 10364 10144 220 2.12 0 4780 17 0 220
v_all_customers 38560 38560 0 0.00 0 19 1 0 0
v_all_suppliers 31370 31370 0 0.00 0 17 1 0 0
v_all_wares 42074 42074 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 1631 9 0 0
v_cancel_client_order 3722 3722 0 0.00 0 5334 5 0 0
v_cancel_customer_prepayment 1440 1440 0 0.00 0 4577 7 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 1071 5 0 0
v_cancel_payment_to_supplier 882 882 0 0.00 0 6528 18 0 0
v_cancel_supplier_invoice 892 880 12 1.34 0 262 13 0 12
v_cancel_supplier_order 836 836 0 0.00 0 603 4 0 0
v_cancel_write_off 2050 2050 0 0.00 0 4501 17 0 0
v_max_id_clo_ord 5532 5532 0 0.00 0 5322 2 0 0
v_max_id_clo_res 1004 1004 0 0.00 0 3120 18 0 0
v_max_id_ord_sup 5656 5656 0 0.00 0 6197 5 0 0
v_max_non_paid_invoice 1580 1580 0 0.00 0 5194 6 0 0
v_max_non_paid_realizn 3939 3939 0 0.00 0 4699 7 0 0
v_min_id_clo_ord 5532 5532 0 0.00 0 3374 5 0 0
v_min_id_clo_res 1004 1004 0 0.00 0 5661 19 0 0
v_min_id_ord_sup 5656 5656 0 0.00 0 4675 7 0 0
v_min_non_paid_invoice 6077 6077 0 0.00 0 40083 21 0 0
v_min_non_paid_realizn 7413 7413 0 0.00 0 32333 17 0 0
v_our_firm 10462 10462 0 0.00 0 13 1 0 0
v_reserve_write_off 20744 20744 0 0.00 0 6821 7 0 0
x_lock_depdocs_on_canc_invoice 11909 11909 0 0.00 0 28268 112 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 24269 391 0 0
x_make_qstorno_1000_1200 5532 5532 0 0.00 2 27479 1156 0 0
x_make_qstorno_1200_2000 5667 5667 0 0.00 3 76400 3113 0 0
x_make_qstorno_2100_3300 476798 476798 0 0.00 0 95751 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-12-2020 22:29:40 to 03-12-2020 22:29:44.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:05 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:12 21668 8192000000 10273271200 10582675456 889263600 9.792 70 57 115 0 910673968 2503360 18907008
19:57:44 27447 8192000000 10351922272 10673287168 1393562816 14.538 100 84 168 0 1426721200 5421152 27737232
19:58:23 14858 8192000000 10381805872 10708537344 1441500480 14.963 100 85 170 0 1476281616 6658432 28122704
19:58:59 17719 8192000000 10417058704 10747551744 1471381824 15.226 100 89 178 0 1508717184 7917232 29418128
19:59:28 15671 8192000000 10442547680 10774159360 1491529888 15.402 100 85 170 0 1527305552 8188464 27587200
19:59:54 18293 8192000000 10460631536 10797375488 1515915936 15.615 100 85 170 0 1552036272 9019616 27100720
20:00:21 20810 8192000000 10476903808 10818220032 1529428448 15.732 100 86 171 1 1566250288 9511456 27310384
20:00:51 19797 8192000000 10495286720 10843709440 1547430208 15.888 100 78 156 0 1582091408 9483200 25178000
20:01:25 18190 8192000000 10537324176 10884362240 1581607648 16.182 100 89 176 2 1618984736 10102448 27274640
20:01:51 15019 8192000000 10531839088 10892914688 1599715280 16.337 100 79 158 1 1634230128 10619984 23894864
20:02:17 13753 8192000000 10559824048 10917142528 1618323312 16.496 100 76 152 1 1651918160 10834336 22760512
20:02:40 8856 8192000000 10574057008 10933690368 1633130528 16.621 100 90 180 0 1673024880 12225712 27668640
20:02:59 9268 8192000000 10584359984 10945560576 1640086720 16.680 100 79 158 0 1675740624 12141872 23512032
20:03:26 11114 8192000000 10605700000 10971033600 1663021888 16.874 100 82 164 2 1699431648 11858976 24550784
20:03:49 8983 8192000000 10622024960 10993852416 1686421808 17.071 100 78 156 0 1720055552 10953008 22680736
20:04:07 7121 8192000000 10647270496 11018010624 1705807952 17.234 100 81 162 1 1740745472 11233296 23704224
20:04:20 7063 8192000000 10648707504 11027861504 1716411536 17.322 100 71 142 0 1748175120 10952064 20811520
20:04:35 7105 8192000000 10667794448 11043655680 1726983552 17.410 100 78 156 1 1761280608 11476432 22820624
20:04:49 6051 8192000000 10685012160 11064066048 1744360960 17.555 100 71 142 1 1780737232 16041920 20334352
20:05:03 3820 8192000000 10700750992 11073540096 1757051184 17.660 100 86 170 3 1793286528 12614944 23620400
20:05:14 4267 8192000000 10703026096 11082715136 1764610768 17.723 100 77 151 0 1799756128 14122064 21023296
20:05:25 4231 8192000000 10708360096 11088076800 1769303840 17.761 100 77 154 0 1805404752 14144352 21956560
20:05:36 3355 8192000000 10720264496 11097538560 1777513632 17.829 100 86 172 0 1817583440 14887184 25182624
20:05:46 2101 8192000000 10728603824 11106811904 1787348160 17.910 100 85 168 0 1824425104 13030336 24046608
20:05:54 3244 8192000000 10725621312 11110129664 1792289776 17.951 100 81 157 2 1826409296 11561008 22558512
20:06:06 2744 8192000000 10744308624 11123924992 1798570544 18.002 100 82 164 0 1834222896 12105536 23546816
20:06:15 3391 8192000000 10741416688 11122171904 1802782544 18.037 100 77 154 1 1837638944 12902416 21953984
20:06:25 3149 8192000000 10750298544 11132563456 1808877200 18.087 100 92 184 2 1848149200 13831328 25440672
20:06:36 3852 8192000000 10753292608 11138793472 1809619760 18.093 100 81 161 2 1845057984 13348928 22089296
20:06:46 7881 8192000000 10762723008 11146665984 1819244976 18.172 100 83 166 0 1856716416 14526784 22944656
20:07:00 1922 8192000000 10782804336 11164340224 1833311552 18.286 100 90 181 2 1873184976 14701168 25172256
20:07:09 2215 8192000000 10784599376 11170643968 1840414944 18.344 100 93 186 2 1880696224 13959104 26322176
20:07:17 2274 8192000000 10781579376 11174723584 1848397888 18.409 100 87 174 1 1886103088 13325280 24379920
20:07:26 2815 8192000000 10788288928 11180670976 1852648112 18.444 100 87 176 2 1890411296 13014672 24748512
20:07:36 2608 8192000000 10800220304 11188076544 1854594592 18.459 100 89 179 1 1891888432 12015536 25278304
20:07:46 2104 8192000000 10805300768 11192745984 1860954880 18.511 100 95 189 1 1900521408 12188736 27377792
20:07:54 2044 8192000000 10808636320 11196157952 1862244544 18.521 100 95 191 1 1901831840 12544784 27042512
20:08:02 1855 8192000000 10807817184 11197415424 1864388432 18.539 100 91 182 2 1903887344 13556848 25942064
20:08:11 1782 8192000000 10809896240 11197091840 1869455952 18.580 100 89 176 2 1905965680 11883936 24625792
20:08:20 4844 8192000000 10802283872 11205353472 1868556288 18.573 100 84 168 1 1905980656 13746144 23678224
20:08:31 27634 8192000000 10813237008 11211931648 1867469840 18.564 100 70 143 1 1898268208 11508208 19290160
20:09:06 1929 8192000000 10824067952 11217195008 1880029136 18.665 100 85 169 1 1915340432 11226288 24085008
20:09:14 2071 8192000000 10821551520 11215831040 1882168112 18.683 100 76 148 3 1913523392 10559328 20795952
20:09:23 1831 8192000000 10820941504 11222126592 1880553264 18.670 100 65 130 1 1910316432 11799216 17963952
20:09:32 2403 8192000000 10815097792 11219484672 1884482080 18.701 100 70 140 2 1915461024 10936704 20042240
20:09:41 2054 8192000000 10813492064 11224399872 1883776912 18.696 100 65 129 1 1911944848 9914096 18253840
20:09:49 2394 8192000000 10808360048 11221282816 1882603504 18.686 100 50 100 0 1907139232 10783568 13752160
20:09:58 7800 8192000000 10801761088 11222749184 1887797232 18.728 100 59 120 4 1916982272 12544976 16640064
20:10:14 2491 8192000000 10814419872 11227029504 1887956064 18.729 100 54 109 2 1910842768 7036928 15849776
20:10:25 8469 8192000000 10787594896 11222429696 1883894896 18.697 100 22 44 0 1897265888 7291776 6079216
20:10:42 2355 8192000000 10804508256 11222564864 1890099312 18.747 100 41 79 1 1906571072 4756912 11714848
20:10:53 4953 8192000000 10793668416 11225853952 1884779472 18.704 100 21 42 0 1897869632 7373760 5716400
20:11:04 10499 8192000000 10799953888 11231268864 1886327120 18.716 100 22 44 1 1898587536 6465504 5794912
20:11:25 7336 8192000000 10798539616 11228651520 1889995280 18.746 100 19 38 3 1900476480 5248768 5232432
20:11:39 8917 8192000000 10802570736 11228966912 1893284112 18.772 100 30 58 3 1908133936 6666672 8183152
20:11:57 62842 8192000000 10806492960 11240316928 1898845728 18.817 100 41 82 2 1916490704 4996592 12648384
20:13:06 19986 8192000000 10813169808 11245723648 1900494080 18.830 100 27 54 2 1914190064 6143776 7552208
20:13:33 10182 8192000000 10815553744 11248775168 1900023648 18.826 100 26 52 3 1912723904 5381440 7318816
20:13:51 6623 8192000000 10819522000 11250753536 1903563888 18.855 100 30 56 4 1918617632 6359072 8694672
20:14:04 10912 8192000000 10825225760 11256274944 1908588032 18.895 100 36 73 1 1925467824 6455984 10423808
20:14:23 10307 8192000000 10820488848 11251265536 1903151184 18.852 100 20 38 2 1914233312 5357744 5724384
20:14:43 10479 8192000000 10816471984 11253927936 1903188176 18.852 100 19 38 2 1914499408 6140368 5170864
20:15:03 12018 8192000000 10812229296 11253690368 1903887072 18.858 100 16 33 2 1913726944 5155024 4684848
20:15:21 8282 8192000000 10826937488 11255750656 1908804080 18.897 100 25 50 0 1922311248 5808384 7698784
20:15:36 7660 8192000000 10819196480 11251220480 1903273712 18.853 100 26 50 0 1917615872 6870688 7471472
20:15:51 10177 8192000000 10804692592 11238273024 1868585152 18.573 98 12 24 0 1877787104 5720032 3481920
20:16:08 8616 8192000000 10798586928 11239444480 1864682960 18.541 98 20 38 1 1875899520 5585248 5631312
20:16:27 13152 8192000000 10814108512 11244023808 1876819824 18.639 99 16 32 3 1886118256 5052000 4246432
20:16:48 62317 8192000000 10807356768 11222011904 1822246176 18.196 96 42 84 1 1843866144 9366752 12253216
20:17:57 12576 8192000000 10736041056 11164454912 1750281216 17.604 94 18 36 1 1761041648 5605216 5155216
20:18:20 4953 8192000000 10741361520 11162759168 1783532400 17.879 97 19 38 1 1798797728 10232944 5032384
20:18:32 6530 8192000000 10743577328 11168149504 1815461664 18.141 99 15 30 1 1824729648 5306656 3961328
20:18:45 8398 8192000000 10737536976 11170893824 1801307392 18.025 98 15 30 1 1811482720 5161616 5013712
20:19:00 9420 8192000000 10740170288 11171622912 1792703136 17.954 97 14 28 1 1801587712 4726816 4157760
20:19:16 10919 8192000000 10712121776 11130982400 1753529152 17.631 95 19 38 2 1765308640 6108784 5670704
20:19:35 8978 8192000000 10748426704 11168194560 1802462448 18.034 98 18 35 1 1812731424 5494608 4774368
20:19:54 8530 8192000000 10728382672 11140337664 1717238160 17.329 94 24 49 0 1730598416 6125056 7235200
20:20:12 11366 8192000000 10699759248 11125731328 1723525200 17.382 95 27 54 1 1736714416 5653040 7536176
20:20:29 8441 8192000000 10702889440 11119558656 1741888448 17.534 97 27 54 2 1756208176 5844736 8474992
20:20:46 10135 8192000000 10688570560 11099557888 1672075776 16.951 93 20 39 0 1683060800 4971216 6013808
20:21:04 11396 8192000000 10706001920 11127513088 1786854288 17.906 100 17 30 2 1796314496 5244000 4216208
20:21:22 17671 8192000000 10729927600 11142680576 1794894976 17.972 99 28 56 0 1810088496 5721872 9471648
20:21:49 69952 8192000000 10711341712 11139821568 1751278688 17.612 96 22 44 3 1762474352 5017712 6177952
20:23:05 19690 8192000000 10755318368 11173498880 1831477408 18.271 100 25 50 1 1844279680 5413520 7388752
20:23:32 5865 8192000000 10761371296 11180613632 1839407168 18.336 100 30 60 1 1854378336 6382320 8588848
20:23:47 13870 8192000000 10757763216 11187253248 1845276624 18.384 100 22 44 2 1857345616 5887776 6181216
20:24:10 7175 8192000000 10760547056 11190042624 1849409824 18.417 100 25 50 3 1862971712 6528384 7033504
20:24:27 11151 8192000000 10776412480 11197628416 1853014944 18.447 100 25 50 0 1865942272 5331456 7595872
20:24:48 13936 8192000000 10771714544 11201417216 1855414528 18.466 100 14 28 1 1864750144 5549584 3786032
20:25:10 9577 8192000000 10777446304 11205193728 1859472000 18.499 100 23 46 0 1871856608 5332544 7052064
20:25:30 15703 8192000000 10772867376 11210428416 1863465872 18.531 100 19 38 3 1878842976 9904144 5472960
20:25:52 10382 8192000000 10775421424 11211612160 1866573392 18.557 100 13 25 3 1875504160 5335584 3595184
20:26:10 12583 8192000000 10785012560 11218935808 1872802352 18.607 100 10 19 1 1881037344 4991520 3243472
20:26:32 10817 8192000000 10791864016 11223642112 1875412416 18.628 100 13 26 0 1885431008 6369296 3649296
20:26:51 64299 8192000000 10823006048 11243409408 1890405552 18.749 100 33 65 2 1904974656 4532080 10037024
20:28:06 51134 8192000000 10841283184 11269476352 1916148704 18.956 100 33 64 2 1934111760 8672256 9290800
20:29:10 43715 8192000000 10868814144 11295490048 1928451504 19.054 100 37 74 0 1951706896 12880688 10374704
20:30:15 34274 8192000000 10884560656 11323748352 1953073152 19.251 100 28 56 1 1975616336 14015776 8527408
20:30:59 41714 8192000000 10904947376 11340652544 1968670896 19.375 100 36 71 1 1993226608 13905936 10649776
20:31:49 21540 8192000000 10919323472 11353300992 1976429040 19.436 100 47 93 1 2007996896 17177792 14390064
20:32:20 6587 8192000000 10929455008 11360374784 1985482896 19.508 100 45 89 0 2017266080 18625712 13157472
20:32:34 19835 8192000000 10936451968 11368484864 1993297552 19.570 100 54 107 3 2029829872 19876992 16655328
20:33:03 19654 8192000000 10936493936 11373920256 1995955744 19.591 100 44 88 2 2027712416 18570512 13186160
20:33:33 7710 8192000000 10948508416 11380461568 2001936336 19.638 100 51 100 2 2036017840 19144688 14936816
20:33:48 19536 8192000000 10957675328 11388231680 2008404352 19.689 100 50 100 1 2045346016 20889392 16052272
20:34:16 17184 8192000000 10957993248 11393220608 2010888672 19.709 100 58 116 1 2050034064 22211072 16934320
20:34:44 6498 8192000000 10959346048 11397218304 2014661424 19.738 100 55 110 2 2054433632 23454256 16317952
20:35:04 18090 8192000000 10964349296 11404148736 2016279008 19.751 100 45 90 3 2055705280 25121312 14304960
20:35:31 10242 8192000000 10958464384 11404390400 2018000720 19.764 100 44 86 1 2055649344 24144816 13503808
20:35:49 2583 8192000000 10973137760 11398295552 2015835056 19.747 100 63 124 0 2057533776 22582032 19116688
20:35:59 3482 8192000000 10974341888 11405279232 2020813328 19.787 100 62 123 0 2062888368 23689696 18385344
20:36:19 6587 8192000000 10980774064 11409543168 2026784096 19.833 100 67 132 2 2071972672 25759840 19428736
20:36:34 11490 8192000000 10988942400 11418275840 2028265232 19.845 100 66 132 0 2075139952 26808448 20066272
20:36:56 7336 8192000000 10974251936 11419533312 2028496368 19.847 100 49 98 0 2070591680 26812944 15282368
20:37:13 10271 8192000000 10969047120 11396849664 2009689408 19.699 99 62 124 0 2055314160 26067088 19557664
20:37:33 16220 8192000000 10959398624 11400847360 2003793232 19.653 99 45 89 2 2046861728 29042192 14026304
20:38:03 7126 8192000000 10962021872 11400474624 2009118112 19.695 100 45 90 2 2052015120 28917616 13979392
20:38:17 3302 8192000000 10979817616 11405574144 2017092112 19.757 100 69 139 0 2068671200 29804800 21774288
20:38:29 2158 8192000000 11004708352 11424460800 2030417776 19.862 100 77 150 1 2084502896 31728416 22356704
20:38:37 2362 8192000000 10991419616 11418034176 2027300768 19.837 100 81 162 2 2084555376 31969040 25285568
20:38:46 4646 8192000000 10990098896 11416702976 2020575920 19.785 100 74 147 1 2076360800 33383248 22401632
20:39:01 4494 8192000000 10993388080 11409813504 2017866304 19.763 100 80 160 0 2074057040 31950624 24240112
20:39:12 3538 8192000000 10968357600 11385688064 1968529968 19.374 98 84 167 5 2027061984 33514720 25017296
20:39:22 2050 8192000000 10972055872 11388092416 1997116432 19.600 100 85 170 2 2056306896 33952912 25237552
20:39:33 3257 8192000000 10982956896 11400437760 2004362384 19.657 100 88 176 0 2066048352 35637568 26048400
20:39:47 1643 8192000000 10992638304 11403120640 2004512928 19.658 100 83 165 1 2069199616 39779248 24907440
20:39:56 2083 8192000000 11003182416 11416518656 2019295376 19.775 100 90 183 0 2086239408 39496096 27447936
20:40:04 2455 8192000000 10994348144 11412598784 2015097328 19.742 100 85 170 3 2082034848 41192016 25745504
20:40:14 3310 8192000000 10980433408 11398909952 1999512288 19.619 100 84 169 0 2063402176 37953936 25935952
20:40:24 2554 8192000000 10986190192 11403128832 1991170512 19.553 99 91 182 1 2057845344 39096000 27578832
20:40:34 2841 8192000000 10994801536 11410620416 2010528192 19.706 100 86 169 1 2076966512 40519168 25919152
20:40:43 2386 8192000000 10973840624 11387006976 1989781280 19.542 100 91 179 1 2055954176 39591984 26580912
20:40:57 2603 8192000000 10970421216 11385004032 1980861456 19.472 99 86 171 1 2044653328 37967120 25824752
20:41:10 5335 8192000000 10968917936 11382972416 1989525808 19.540 100 80 160 0 2053175760 39603984 24045968
20:41:25 8124 8192000000 10975498256 11395375104 1992109552 19.560 100 76 150 1 2055879472 40757776 23012144
20:41:45 2376 8192000000 10972308688 11401310208 1995841744 19.590 100 63 126 2 2061195056 45248768 20104544
20:41:57 3672 8192000000 10977346784 11404423168 1999672880 19.620 100 70 134 3 2064177872 42747744 21757248
20:42:08 5132 8192000000 10961206864 11383099392 1979849936 19.464 99 72 140 1 2041369344 39333088 22186320
20:42:20 4605 8192000000 10968939936 11393912832 1997136576 19.600 100 72 145 2 2060997280 40511088 23349616
20:42:32 1517 8192000000 10988921472 11407089664 2002311616 19.641 100 79 158 0 2067256144 40107360 24837168
20:42:41 4225 8192000000 10986720032 11413876736 2005759456 19.668 100 78 156 1 2072864160 42235952 24868752
20:43:01 5517 8192000000 10986399232 11405422592 1993038160 19.568 100 77 154 2 2067065280 50040560 23986560
20:43:14 3832 8192000000 10985855088 11408220160 1994587216 19.580 100 78 152 1 2065381296 46611408 24182672
20:43:26 2635 8192000000 10962215472 11378692096 1971648288 19.399 99 78 156 1 2041878832 45547392 24683152
20:43:37 3474 8192000000 10975157152 11393929216 1982007760 19.481 100 80 160 1 2054098528 46384448 25706320
20:43:49 2517 8192000000 10974237488 11393679360 1985130720 19.505 100 83 165 2 2056196000 44965504 26099776
20:43:59 1188 8192000000 10971690720 11387850752 1983637344 19.493 100 88 175 1 2057079504 46674032 26768128
20:44:09 1870 8192000000 10977289088 11395072000 1985254304 19.506 100 87 173 0 2061740064 49717488 26768272
20:44:18 3526 8192000000 10981902832 11402952704 1989758864 19.542 100 77 152 0 2061710720 47982912 23968944
20:44:28 6848 8192000000 10983626352 11397582848 1983745056 19.494 100 75 149 3 2055802256 48936464 23120736
20:44:41 2233 8192000000 10966165888 11386863616 1963593888 19.335 99 83 164 1 2038148016 47675344 26878784
20:44:52 3578 8192000000 10981549360 11401621504 1972269168 19.403 99 79 158 0 2047220128 50884352 24066608
20:45:02 5269 8192000000 10938718080 11367559168 1957707184 19.288 99 58 114 0 2024220288 48652976 17860128
20:45:14 13796 8192000000 10926307824 11369103360 1935420560 19.110 98 45 90 0 2000646816 49625680 15600576
20:45:37 8231 8192000000 10930083968 11370168320 1960638608 19.311 100 41 82 1 2016137808 41587824 13911376
20:45:54 16075 8192000000 10928411136 11377602560 1962971488 19.330 100 27 54 0 2012976848 40213520 9791840
20:46:19 16911 8192000000 10936204560 11380236288 1968078352 19.370 100 30 60 0 2016220112 37944384 10197376
20:46:46 10920 8192000000 10917073280 11354017792 1913144768 18.932 97 44 88 2 1967875168 39557360 15173040
20:47:07 14309 8192000000 10927150080 11376861184 1967040112 19.362 100 42 85 0 2018903024 38542160 13320752
20:47:40 19891 8192000000 10903622192 11353034752 1898582304 18.815 97 32 64 1 1952634880 43036720 11015856
20:48:06 14722 8192000000 10916756672 11364691968 1948319104 19.213 100 24 47 3 1997797728 41192848 8285776
20:48:32 18205 8192000000 10911846752 11358040064 1911883184 18.922 98 26 52 1 1961545456 40496048 9166224
20:48:58 13438 8192000000 10923782208 11369660416 1948241920 19.212 100 39 78 2 2010205872 49084224 12879728
20:49:22 13055 8192000000 10911235568 11350372352 1926490224 19.039 99 39 78 0 1990387888 49873504 14024160
20:49:47 9884 8192000000 10904174272 11341033472 1907909184 18.890 99 38 77 0 1974331200 53099408 13322608
20:50:04 21276 8192000000 10908096832 11356655616 1930501920 19.071 100 29 58 1 2000170208 59073312 10594976
20:50:32 33630 8192000000 10890796912 11340746752 1929210256 19.061 100 26 52 2 1980194784 42016528 8968000
20:51:17 17420 8192000000 10915847872 11369533440 1940942288 19.154 100 26 52 1 2002257648 52220304 9095056
20:51:42 30992 8192000000 10884144064 11349975040 1905944944 18.874 98 18 36 2 1953670576 41448240 6277392
20:52:31 34851 8192000000 10883264144 11342917632 1921538192 18.999 99 13 24 2 1950236560 24597888 4100480
20:53:13 30628 8192000000 10894397920 11358564352 1940635568 19.152 100 18 37 0 1972929456 26397168 5896720
20:53:54 36633 8192000000 10885611968 11359875072 1947888096 19.210 100 8 16 1 1970950512 20572800 2489616
20:55:07 91966 8192000000 10873407328 11335987200 1895543104 18.790 97 13 27 2 1914736912 14485728 4708080
20:56:53 111954 8192000000 10870469136 11320496128 1877062064 18.641 96 27 53 0 1892751232 8382416 7306752
20:59:10 9255 8192000000 10899505760 11340886016 1939668944 19.144 99 62 123 1 1968422848 11526464 17227440
20:59:29 99955 8192000000 10874494496 11306053632 1822964864 18.202 93 21 36 0 1836481136 8750480 4765792
21:01:21 77437 8192000000 10867190144 11333906432 1925055904 19.027 99 20 40 1 1940978480 10026464 5896112
21:02:45 27127 8192000000 10866110512 11332055040 1944795728 19.185 100 6 12 0 1954432016 8416224 1220064
21:03:19 3046 8192000000 10872802176 11327688704 1944495952 19.183 100 14 27 0 1956083472 7282752 4304768
21:03:29 13181 8192000000 10918282512 11363770368 1967319952 19.364 100 47 93 2 1989037888 7765728 13952208
21:04:02 22909 8192000000 10886287264 11338133504 1953978672 19.258 100 20 40 1 1967829680 7986944 5864064
21:04:34 20078 8192000000 10900860560 11341750272 1928951248 19.058 98 25 50 0 1945376608 9053072 7372288
21:05:01 42308 8192000000 10924190336 11358167040 1953310976 19.253 99 53 106 0 1978597552 9853376 15433200
21:05:50 35646 8192000000 10915940976 11372630016 1977237088 19.443 100 43 86 3 2003261232 13988720 12035424
21:06:35 27260 8192000000 10898109536 11357827072 1954829744 19.265 99 21 42 1 1976541456 15400768 6310944
21:07:09 79950 8192000000 10897777456 11374903296 1971991904 19.401 100 15 30 2 1990672928 14227504 4453520
21:08:39 102272 8192000000 10921061040 11389087744 1990601984 19.549 100 19 38 0 2008010928 11625520 5783424
21:10:28 60931 8192000000 10919604544 11398148096 1990868912 19.551 100 15 30 0 2018652256 22934256 4849088
21:11:41 54483 8192000000 10919758640 11375423488 1972074560 19.402 99 18 36 0 1994668112 17017216 5576336
21:12:49 81444 8192000000 10908922224 11397349376 1987032624 19.520 100 19 36 2 2008700272 17045392 4622256
21:14:19 40429 8192000000 10904857008 11381448704 1973190992 19.411 99 16 32 1 1988587984 10900352 4496640
21:15:11 49796 8192000000 10886905776 11368165376 1957389104 19.285 99 29 58 0 1976966656 11756128 7821424
21:16:47 49988 8192000000 10880433488 11374325760 1968879968 19.377 100 9 17 0 1981847440 9938672 3028800
21:18:16 42938 8192000000 10879693312 11352788992 1899298064 18.821 96 15 30 1 1913168688 9804976 4065648
21:19:21 34816 8192000000 10886199040 11356905472 1931742928 19.081 98 16 32 2 1947434672 11192448 4499296
21:20:06 70636 8192000000 10908259968 11361071104 1920441232 18.990 98 16 32 0 1935253744 10662352 4150160
21:21:31 45500 8192000000 10894192192 11362648064 1933533328 19.095 98 31 62 4 1953244448 10209808 9501312
21:22:30 67412 8192000000 10902208928 11376459776 1950395056 19.230 99 21 42 3 1967460464 11641184 5424224
21:23:44 42340 8192000000 10905577072 11372224512 1937900608 19.130 98 22 44 0 1957790352 13408336 6481408
21:24:36 59850 8192000000 10896452144 11362009088 1875710272 18.630 95 17 34 1 1888424272 7255216 5458784
21:25:50 50365 8192000000 10918451744 11382009856 1954402048 19.262 99 24 48 0 1981624608 20303488 6919072
21:26:59 69984 8192000000 10866448096 11340554240 1874386784 18.620 96 15 30 1 1892851392 14415040 4049568
21:28:38 77205 8192000000 10861480160 11324395520 1830246976 18.261 94 17 34 2 1850167360 15056864 4863520
21:31:11 87688 8192000000 10867318544 11321892864 1857785248 18.485 96 13 26 0 1873055936 11665776 3604912
21:32:53 84785 8192000000 10865466176 11326164992 1907745872 18.889 98 17 34 1 1928468176 15742144 4980160
21:34:46 106250 8192000000 10869059728 11325276160 1859852304 18.502 95 21 42 1 1874880192 9753536 5274352
21:36:50 13702 8192000000 10853502016 11309105152 1880166592 18.666 97 36 72 2 1902921568 11955696 10799280
21:37:11 30694 8192000000 10871821584 11317108736 1886857920 18.720 98 45 90 2 1910536032 10556224 13121888
21:37:55 12239 8192000000 10857180496 11315855360 1931436416 19.078 100 31 62 2 1950358880 10588544 8333920
21:38:14 97974 8192000000 10850807344 11315896320 1889790080 18.744 98 27 54 0 1907506144 10143040 7573024
21:40:02 49884 8192000000 10848940704 11317850112 1923179264 19.012 100 13 26 1 1938523536 10068752 5275520
21:40:59 48961 8192000000 10867504752 11334922240 1940505824 19.151 100 17 34 1 1959686608 13878896 5301888
21:41:54 57758 8192000000 10873743696 11353219072 1954326992 19.261 100 9 18 0 1976649024 19790960 2531072
21:42:58 44400 8192000000 10870632992 11352576000 1957497248 19.286 100 10 20 1 1969920912 9817760 2605904
21:43:48 72089 8192000000 10869948496 11343368192 1904181616 18.860 97 39 77 1 1929054160 13255808 11616736
21:45:07 34386 8192000000 10867515840 11343265792 1949962432 19.226 100 22 44 1 1964699840 7911968 6825440
21:45:49 47138 8192000000 10870978464 11348987904 1920056928 18.987 98 15 30 0 1935966128 11856224 4052976
21:46:49 86394 8192000000 10884030784 11355664384 1898265408 18.812 97 22 44 0 1919825376 15607920 5952048
21:48:49 60570 8192000000 10850629440 11323199488 1901572592 18.839 98 13 26 0 1917285728 11639712 4073424
21:50:22 88560 8192000000 10899089696 11363332096 1952821632 19.249 100 26 52 1 1980981776 21250704 6909440
21:51:58 26803 8192000000 10884677760 11338317824 1923881872 19.018 98 46 92 2 1948676832 11213328 13581632
21:52:39 40086 8192000000 10887521520 11344408576 1942282080 19.165 99 41 82 0 1967414816 13784240 11348496
21:53:25 76228 8192000000 10903845152 11380264960 1930425888 19.070 98 20 40 1 1957543600 21335008 5782704
21:54:48 84395 8192000000 10892332080 11377938432 1944999296 19.187 99 15 30 2 1977393552 27722112 4672144
21:56:42 49578 8192000000 10923731632 11369738240 1955521408 19.270 99 39 78 1 1981275808 14680736 11073664
21:57:38 28439 8192000000 10907817936 11362324480 1970242592 19.387 100 36 73 1 1988808192 8891472 9674128
21:58:18 79322 8192000000 10884730224 11358355456 1929583728 19.064 98 14 28 3 1943926480 10261808 4080944
22:00:52 63545 8192000000 10905248288 11377623040 1959602640 19.303 99 30 60 0 1986216720 18700896 7913184
22:02:02 28568 8192000000 10882714240 11366932480 1950811440 19.233 99 10 20 0 1963381568 9849664 2720464
22:02:37 48925 8192000000 10882345328 11356692480 1926331936 19.038 98 15 30 0 1938861056 7464096 5065024
22:03:35 71652 8192000000 10894921440 11371032576 1961571152 19.319 99 12 24 1 1975680480 10506864 3602464
22:04:53 70374 8192000000 10884416208 11364687872 1938720016 19.137 98 8 16 0 1952008352 11135760 2152576
22:06:09 101899 8192000000 10860265904 11346706432 1872488400 18.604 95 9 18 0 1889595008 13861264 3245344
22:08:34 59246 8192000000 10890605888 11327483904 1897792608 18.809 97 35 63 4 1911869920 6501424 7575888
22:09:46 55977 8192000000 10870926672 11352469504 1891084880 18.755 97 20 40 1 1904875776 8152384 5638512
22:10:49 50951 8192000000 10864417664 11347656704 1932885984 19.090 99 14 28 0 1946096656 9345840 3864832
22:11:49 44362 8192000000 10882255776 11352100864 1947399552 19.206 99 23 46 2 1961308272 7540176 6368544
22:12:42 60728 8192000000 10886732400 11362807808 1930984672 19.075 98 21 42 0 1947607632 10740480 5882480
22:14:19 60533 8192000000 10876038720 11344007168 1920030432 18.987 98 11 22 2 1934636256 11295024 3310800
22:15:26 54374 8192000000 10894316288 11349409792 1900815856 18.833 97 32 64 0 1921157232 10996192 9345184
22:16:28 45073 8192000000 10882714816 11337912320 1891594944 18.759 97 39 78 3 1912914608 10662928 10656736
22:17:22 11942 8192000000 10884378800 11331706880 1912346128 18.925 98 48 96 1 1937164352 11265296 13552928
22:17:44 43458 8192000000 10858201520 11318607872 1876857920 18.640 97 42 84 1 1901008560 12766384 11384256
22:18:33 30063 8192000000 10861894448 11309928448 1872736400 18.606 97 34 68 2 1892158416 10073312 9348704
22:19:12 41662 8192000000 10836699472 11305426944 1860066896 18.504 97 33 66 2 1887485008 18244624 9173488
22:20:35 60290 8192000000 10865954144 11322298368 1886790560 18.720 98 17 35 1 1906663984 14090928 5782496
22:21:45 93203 8192000000 10828173152 11294838784 1843534080 18.370 96 27 54 1 1867706048 16079728 8092240
22:25:06 88481 8192000000 10816603680 11286495232 1823421792 18.206 95 9 18 0 1833525472 7137712 2965968
22:26:41 33863 8192000000 9393820400 9689370624 557381520 6.370 29 2 4 0 561128944 3303440 443984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 03-12-2020 22:29:46 to 03-12-2020 22:30:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-12-2020 22:30:17 to 03-12-2020 22:30:19.

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          245509
MON$OLDEST_ACTIVE               245510
MON$OLDEST_SNAPSHOT             245510
MON$NEXT_TRANSACTION            245510
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                       2039904
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.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

03.12.20 22:30:20. 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-03 22:30:22 No severe PSQL-related problems occured
03.12.20 22:30:23. End of report.