Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.12.2020 01: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 17243920 kB
MemAvailable 31645204 kB
Buffers 0 kB
Cached 14487412 kB
SwapCached 1968 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-04 01:27:02
DTS_END                         2020-12-04 01:27:02.6520
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(139:30) ==> SP_CANCEL_WRITE_OFF(41:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50186
TRN_ID                          242894
ATT_ID                          702
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: 9555.91 26919 1146709
customer order: creation 170.10 336 20412
customer order: refuse 15.00 386 1800
order to supplier: creation 46.31 1250 5557
order to supplier: removal 3.61 106083 433
invoice (draft): creation 45.67 3407 5480
invoice (draft): removal 56.18 765 6741
invoice accept: apply 41.50 17981 4980
invoice accept: cancel 50.78 841 6093
customer reserve: creation 3852.09 177 462251
customer reserve: removal 4969.90 60 596388
realization accept: apply 84.94 206 10193
realization accept: cancel 90.13 113 10815
payment from customer: creation 58.70 118 7044
payment from customer: removal 5.63 86 676
payment to supplier: creation 49.84 134 5981
payment to supplier: removal 3.49 66 419
service: total inventory turnovers 4.63 1253 555
service: total monetary turnovers 6.68 51 802
service: aggregate perf. data 0.71 24568 85
service: refresh index statistics 0.03 380508 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-12-2020 01:29:49 to 04-12-2020 01:29:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5534
TEST_TIME 2 4034
TEST_TIME 3 4215
TEST_TIME 4 4745
TEST_TIME 5 4908
TEST_TIME 6 4804
TEST_TIME 7 5232
TEST_TIME 8 5303
TEST_TIME 9 5648
TEST_TIME 10 5797
TEST_TIME 11 5881
TEST_TIME 12 5845
TEST_TIME 13 6143
TEST_TIME 14 6200
TEST_TIME 15 6242
TEST_TIME 16 6789
TEST_TIME 17 7105
TEST_TIME 18 7282
TEST_TIME 19 7586
TEST_TIME 20 7886
TEST_TIME 21 8424
TEST_TIME 22 8896
TEST_TIME 23 9128
TEST_TIME 24 9250
TEST_TIME 25 9256
TEST_TIME 26 9271
TEST_TIME 27 9706
TEST_TIME 28 9798
TEST_TIME 29 10165
TEST_TIME 30 11180
TEST_TIME 31 11053
TEST_TIME 32 10888
TEST_TIME 33 10978
TEST_TIME 34 10887
TEST_TIME 35 10741
TEST_TIME 36 10748
TEST_TIME 37 10543
TEST_TIME 38 10478
TEST_TIME 39 10605
TEST_TIME 40 10522
TEST_TIME 41 10536
TEST_TIME 42 10464
TEST_TIME 43 10268
TEST_TIME 44 10270
TEST_TIME 45 10204
TEST_TIME 46 10379
TEST_TIME 47 10229
TEST_TIME 48 10116
TEST_TIME 49 10143
TEST_TIME 50 10058
TEST_TIME 51 9923
TEST_TIME 52 10001
TEST_TIME 53 10158
TEST_TIME 54 10170
TEST_TIME 55 10166
TEST_TIME 56 10167
TEST_TIME 57 10164
TEST_TIME 58 10212
TEST_TIME 59 10184
TEST_TIME 60 10344
TEST_TIME 61 10291
TEST_TIME 62 10390
TEST_TIME 63 10346
TEST_TIME 64 10330
TEST_TIME 65 10301
TEST_TIME 66 10333
TEST_TIME 67 10275
TEST_TIME 68 10181
TEST_TIME 69 10130
TEST_TIME 70 10076
TEST_TIME 71 10017
TEST_TIME 72 9959
TEST_TIME 73 9974
TEST_TIME 74 9951
TEST_TIME 75 9880
TEST_TIME 76 9915
TEST_TIME 77 9841
TEST_TIME 78 9815
TEST_TIME 79 9825
TEST_TIME 80 9828
TEST_TIME 81 9787
TEST_TIME 82 9729
TEST_TIME 83 9825
TEST_TIME 84 9792
TEST_TIME 85 9796
TEST_TIME 86 9854
TEST_TIME 87 9893
TEST_TIME 88 9901
TEST_TIME 89 9915
TEST_TIME 90 9987
TEST_TIME 91 9994
TEST_TIME 92 9960
TEST_TIME 93 9864
TEST_TIME 94 9878
TEST_TIME 95 9863
TEST_TIME 96 9812
TEST_TIME 97 9763
TEST_TIME 98 9700
TEST_TIME 99 9673
TEST_TIME 100 9775
TEST_TIME 101 9768
TEST_TIME 102 9799
TEST_TIME 103 9747
TEST_TIME 104 9721
TEST_TIME 105 9762
TEST_TIME 106 9773
TEST_TIME 107 9777
TEST_TIME 108 9783
TEST_TIME 109 9806
TEST_TIME 110 9818
TEST_TIME 111 9837
TEST_TIME 112 9830
TEST_TIME 113 9748
TEST_TIME 114 9759
TEST_TIME 115 9719
TEST_TIME 116 9707
TEST_TIME 117 9680
TEST_TIME 118 9661
TEST_TIME 119 9638
TEST_TIME 120 9563

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-12-2020 01:29:53 to 04-12-2020 01:29:56.

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 1576128 1576128 0 0.00 0 16957 6 0 0
doc_list_biud 1576118 1576118 0 0.00 0 52522 29 0 0
sp_add_invoice_to_stock 5085 4980 105 2.06 50 185846 17982 0 105
sp_cancel_adding_invoice 6093 6093 0 0.00 5 93930 842 0 0
sp_cancel_client_order 1800 1800 0 0.00 4 20502 386 0 0
sp_cancel_customer_reserve 596388 596388 0 0.00 1 52526 61 0 0
sp_cancel_pay_from_customer 676 676 0 0.00 2 4137 86 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 4490 66 0 0
sp_cancel_supplier_invoice 6751 6741 10 0.14 2 25376 766 0 10
sp_cancel_supplier_order 433 433 0 0.00 10 1121781 106084 0 0
sp_cancel_write_off 10815 10815 0 0.00 1 20502 114 0 0
sp_client_order 20412 20412 0 0.00 3 49866 337 0 0
sp_customer_reserve 462251 462251 0 0.00 0 160574 178 0 0
sp_fill_shopping_cart 31446 31446 0 0.00 1 15920 41 0 0
sp_fill_shopping_cart_clo_res 462235 462235 0 0.00 0 21624 13 0 0
sp_get_clo_for_invoice 4964 4964 0 0.00 0 19911 264 0 0
sp_kill_cost_storno 18003 18003 0 0.00 0 10375 60 0 0
sp_kill_qstorno_ret_qs2qd 1210765 1210765 0 0.00 0 52518 32 0 0
sp_kill_qty_storno 637427 637427 0 0.00 0 52521 71 0 0
sp_lock_selected_doc 21108 21108 0 0.00 0 7758 4 0 0
sp_make_cost_storno 28182 28182 0 0.00 0 16724 54 0 0
sp_multiply_rows_for_pdistr 28182 28182 0 0.00 0 14173 34 0 0
sp_multiply_rows_for_qdistr 20412 20412 0 0.00 0 49860 150 0 0
sp_pay_from_customer 7044 7044 0 0.00 4 16055 118 0 0
sp_pay_to_supplier 5981 5981 0 0.00 4 16734 134 0 0
sp_payment_common 13025 13025 0 0.00 1 16042 33 0 0
sp_qd_handle_on_cancel_clo 1800 1800 0 0.00 0 20493 359 0 0
sp_qd_handle_on_invoice_upd_sts 11057 11057 0 0.00 0 26685 366 0 0
sp_qd_handle_on_reserve_upd_sts 10193 10193 0 0.00 0 19896 73 0 0
sp_reserve_write_off 10193 10193 0 0.00 6 20500 206 0 0
sp_supplier_invoice 5480 5480 0 0.00 8 80728 3408 0 0
sp_supplier_order 5557 5557 0 0.00 4 28159 1250 0 0
srv_aggregate_perf_data 85 85 0 0.00 3261 151152 24568 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1498 168864 31449 0 0
srv_find_qd_qs_mism 1099725 1099725 0 0.00 0 16957 5 0 0
srv_make_invnt_saldo 555 555 0 0.00 49 87784 1254 0 0
srv_make_money_saldo 802 802 0 0.00 1 10554 51 0 0
srv_recalc_idx_stat 4 4 0 0.00 222176 664461 380509 0 0
t$perf-abend:sp_add_invoice_to_stock 105 105 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4980 4980 0 0.00 0 15623 157 0 0
t$perf-norm:sp_cancel_adding_invoice 453 453 0 0.00 1 3261 83 0 0
t$perf-norm:sp_cancel_client_order 1800 1800 0 0.00 0 1802 14 0 0
t$perf-norm:sp_cancel_customer_reserve 718 718 0 0.00 0 1132 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 676 676 0 0.00 0 614 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 190 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 2696 21 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 27597 1715 0 0
t$perf-norm:sp_cancel_write_off 1024 1024 0 0.00 0 3869 9 0 0
t$perf-norm:sp_client_order 20412 20412 0 0.00 0 7813 17 0 0
t$perf-norm:sp_customer_reserve 978 978 0 0.00 0 1511 6 0 0
t$perf-norm:sp_pay_from_customer 7044 7044 0 0.00 0 5571 8 0 0
t$perf-norm:sp_pay_to_supplier 5981 5981 0 0.00 0 5968 9 0 0
t$perf-norm:sp_reserve_write_off 10193 10193 0 0.00 0 5311 9 0 0
t$perf-norm:sp_supplier_invoice 5480 5480 0 0.00 0 9525 21 0 0
t$perf-norm:sp_supplier_order 5557 5557 0 0.00 0 10981 20 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 542 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 427 8 0 0
t$perf-norm:srv_make_invnt_saldo 555 555 0 0.00 0 1042 22 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 2134 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 18 7 0 0
v_add_invoice_to_stock 10136 9926 210 2.07 0 8945 21 0 210
v_all_customers 36946 36946 0 0.00 0 254 1 0 0
v_all_suppliers 30858 30858 0 0.00 0 254 1 0 0
v_all_wares 40824 40824 0 0.00 0 256 1 0 0
v_cancel_adding_invoice 906 906 0 0.00 0 4663 16 0 0
v_cancel_client_order 3600 3600 0 0.00 0 5005 7 0 0
v_cancel_customer_prepayment 1352 1352 0 0.00 0 4083 8 0 0
v_cancel_customer_reserve 1436 1436 0 0.00 0 1944 5 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 290 3 0 0
v_cancel_supplier_invoice 878 858 20 2.27 0 5123 24 0 20
v_cancel_supplier_order 866 866 0 0.00 0 2792 18 0 0
v_cancel_write_off 2048 2048 0 0.00 0 607 12 0 0
v_max_id_clo_ord 5557 5557 0 0.00 0 4149 2 0 0
v_max_id_clo_res 978 978 0 0.00 0 1578 9 0 0
v_max_id_ord_sup 5477 5477 0 0.00 0 4517 4 0 0
v_max_non_paid_invoice 1586 1586 0 0.00 0 545 3 0 0
v_max_non_paid_realizn 3857 3857 0 0.00 0 2545 4 0 0
v_min_id_clo_ord 5557 5557 0 0.00 0 6384 11 0 0
v_min_id_clo_res 978 978 0 0.00 0 5418 15 0 0
v_min_id_ord_sup 5477 5477 0 0.00 0 3141 3 0 0
v_min_non_paid_invoice 5981 5981 0 0.00 0 12376 23 0 0
v_min_non_paid_realizn 7044 7044 0 0.00 0 14016 22 0 0
v_our_firm 10252 10252 0 0.00 0 253 1 0 0
v_reserve_write_off 20386 20386 0 0.00 0 5958 8 0 0
x_lock_depdocs_on_canc_invoice 12405 12405 0 0.00 0 18159 124 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 20051 417 0 0
x_make_qstorno_1000_1200 5557 5557 0 0.00 2 28141 1151 0 0
x_make_qstorno_1200_2000 5480 5480 0 0.00 4 80717 3276 0 0
x_make_qstorno_2100_3300 462251 462251 0 0.00 0 160570 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-12-2020 01:29:57 to 04-12-2020 01:30:01.

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
22:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:12 11186 8192000000 10220986880 10521772032 841871744 9.319 68 50 98 1 862483520 2464592 18147184
22:57:31 24927 8192000000 10320170144 10633650176 1372813824 14.352 100 84 168 0 1403649792 4318432 26517536
22:58:09 33182 8192000000 10365898512 10687885312 1410974880 14.693 100 85 169 2 1445147920 6103360 28069680
22:58:53 25432 8192000000 10407683008 10730885120 1448474608 15.024 100 93 186 1 1486754624 6898832 31381184
22:59:30 18913 8192000000 10416462448 10744160256 1471058832 15.223 100 94 188 0 1509406112 7817584 30529696
23:00:03 20838 8192000000 10426051104 10756923392 1483495856 15.332 100 91 182 0 1521074048 8332704 29245488
23:00:37 12197 8192000000 10441629056 10773921792 1497012912 15.450 100 94 188 1 1535740880 9058272 29669696
23:00:58 20292 8192000000 10459780096 10796269568 1510983296 15.572 100 81 162 0 1546147520 9255120 25909104
23:01:34 11867 8192000000 10481298976 10829774848 1542091392 15.842 100 78 156 0 1575888944 9864512 23933040
23:01:56 19379 8192000000 10520390208 10874105856 1577683584 16.148 100 73 146 2 1610160672 9903104 22573984
23:02:24 12083 8192000000 10535761808 10892120064 1595088080 16.297 100 79 158 0 1629656224 10620912 23947232
23:02:44 13070 8192000000 10566573088 10922987520 1620120752 16.511 100 80 160 0 1655750352 11494672 24134928
23:03:08 8551 8192000000 10583598544 10946789376 1643107248 16.706 100 74 147 1 1676947888 11929264 21911376
23:03:31 8426 8192000000 10608564912 10974556160 1666750128 16.906 100 75 150 0 1700898944 12379648 21769168
23:03:47 7746 8192000000 10630795200 10998067200 1684214880 17.053 100 79 158 1 1720274320 12934752 23124688
23:04:03 9674 8192000000 10650644784 11019587584 1710487216 17.273 100 86 173 1 1748566992 13082928 24996848
23:04:22 7156 8192000000 10657437904 11033812992 1721569344 17.365 100 87 174 0 1761167952 14246480 25352128
23:04:37 5894 8192000000 10682539920 11055747072 1735766144 17.483 100 85 170 1 1773296592 13225712 24304736
23:04:50 7341 8192000000 10693032720 11068653568 1751883872 17.617 100 76 151 0 1788827024 15782608 21160544
23:05:05 4479 8192000000 10702906496 11079090176 1762313280 17.704 100 81 159 2 1796976608 12465760 22197568
23:05:16 5018 8192000000 10705124160 11086254080 1770115568 17.768 100 80 160 1 1804619248 12189328 22314352
23:05:28 4675 8192000000 10723846176 11100454912 1778345664 17.836 100 83 166 2 1814034672 12351904 23337104
23:05:39 3123 8192000000 10719052160 11102654464 1786982832 17.907 100 84 167 1 1824400080 13735440 23681808
23:05:50 3396 8192000000 10738455664 11117047808 1797040720 17.990 100 91 178 1 1835952640 14602576 24309344
23:06:01 2989 8192000000 10743968576 11127283712 1798943600 18.005 100 87 174 0 1838657408 15550944 24162864
23:06:10 2220 8192000000 10747985584 11128520704 1804577888 18.051 100 83 166 1 1841662480 14574688 22509904
23:06:19 2533 8192000000 10753187168 11132452864 1811398688 18.107 100 88 177 0 1851169264 15790960 23979616
23:06:35 7336 8192000000 10746860384 11137155072 1814688384 18.134 100 82 163 0 1851619408 14028576 22902448
23:06:49 2239 8192000000 10767108352 11154595840 1826907104 18.234 100 89 178 0 1865882496 13135904 25839488
23:06:57 2037 8192000000 10775836896 11159556096 1838065264 18.325 100 82 157 3 1872240768 12157408 22018096
23:07:06 1663 8192000000 10786158896 11172126720 1842918992 18.365 100 91 183 0 1879958448 11264672 25774784
23:07:14 1914 8192000000 10791652432 11178287104 1848335392 18.409 100 87 172 2 1884912096 12354032 24222672
23:07:22 1539 8192000000 10797569712 11183742976 1854912864 18.462 100 92 185 1 1894173824 13494672 25766288
23:07:30 1566 8192000000 10803407392 11191005184 1856756928 18.477 100 93 184 2 1896433712 13727264 25949520
23:07:38 2335 8192000000 10808119248 11194273792 1860368336 18.506 100 93 185 3 1899978560 13694624 25915600
23:07:47 2012 8192000000 10809324752 11198767104 1861676080 18.517 100 91 178 1 1900761008 13989568 25095360
23:07:55 1311 8192000000 10812369872 11200307200 1864323824 18.538 100 88 176 0 1902466128 13741328 24400976
23:08:03 5008 8192000000 10796270720 11193700352 1862072752 18.520 100 76 152 0 1897106928 13868624 21165552
23:08:14 2220 8192000000 10803756448 11197689856 1867345040 18.563 100 93 186 1 1905478672 11897488 26236144
23:08:26 11091 8192000000 10807686576 11199418368 1866895744 18.559 100 75 152 1 1900093712 11484720 21713248
23:08:43 1419 8192000000 10818027136 11208740864 1872911456 18.608 100 88 178 1 1910166976 12635648 24619872
23:08:51 22424 8192000000 10784552976 11198865408 1865042592 18.544 100 44 89 0 1887095632 8791040 13262000
23:09:22 6745 8192000000 10786613184 11204984832 1868855952 18.575 100 27 55 0 1882639504 6457088 7326464
23:09:35 6250 8192000000 10777539632 11202048000 1870735136 18.590 100 24 48 5 1884769216 7255264 6778816
23:09:48 3359 8192000000 10795809456 11211345920 1878361776 18.652 100 42 81 1 1896084704 5723216 11999712
23:09:58 3937 8192000000 10791911440 11210502144 1877128256 18.642 100 37 73 2 1895744784 8730064 9886464
23:10:10 6025 8192000000 10792492400 11216187392 1879095968 18.658 100 37 74 0 1897771712 8595376 10080368
23:10:22 6117 8192000000 10791700432 11217752064 1877226016 18.643 100 27 54 0 1892394432 7887472 7280944
23:10:35 8200 8192000000 10795130912 11220414464 1883437808 18.693 100 34 68 1 1900370848 7988240 8944800
23:10:53 9859 8192000000 10799442928 11227222016 1884986896 18.705 100 28 56 1 1899690400 6813280 7890224
23:11:09 7492 8192000000 10787838176 11225268224 1885555568 18.710 100 20 40 1 1897501584 6386288 5559728
23:11:24 11922 8192000000 10789614976 11230310400 1887211248 18.723 100 18 36 2 1902535264 10181488 5142528
23:11:53 5296 8192000000 10808598752 11234836480 1893024496 18.770 100 20 40 1 1904398848 5930800 5443552
23:12:05 7701 8192000000 10803547680 11235778560 1894006336 18.778 100 17 33 2 1904652112 5579760 5066016
23:12:18 17609 8192000000 10812222032 11241881600 1902693440 18.848 100 31 61 3 1917493536 5942192 8857904
23:12:44 73366 8192000000 10813641968 11251240960 1903296544 18.853 100 31 61 2 1922140528 9892960 8951024
23:14:06 13515 8192000000 10813961888 11252666368 1906148192 18.876 100 23 45 2 1918382720 5531952 6702576
23:14:27 5898 8192000000 10826343968 11259150336 1909797920 18.905 100 30 60 0 1928394208 10421776 8174512
23:14:43 6094 8192000000 10821549232 11259490304 1909699360 18.904 100 25 50 1 1923409264 6786224 6923680
23:14:57 8725 8192000000 10815318112 11259912192 1910589152 18.911 100 21 42 2 1922741056 5742528 6409376
23:15:11 6866 8192000000 10846822848 11270733824 1912897216 18.930 100 28 56 1 1930925648 10503344 7525088
23:15:25 8837 8192000000 10808064832 11250933760 1904230128 18.860 100 22 44 2 1916806896 6446032 6130736
23:15:44 8233 8192000000 10808958432 11242807296 1891174608 18.755 99 22 44 0 1903383280 6116896 6091776
23:15:59 8599 8192000000 10809545888 11243323392 1882100864 18.682 99 22 44 1 1895319760 6992608 6226288
23:16:16 7617 8192000000 10790051680 11228741632 1857694128 18.485 98 22 44 2 1870267648 5128016 7445504
23:16:32 5244 8192000000 10799652736 11235930112 1889247616 18.740 100 25 50 2 1902560400 5852576 7460208
23:16:44 11952 8192000000 10759284592 11193110528 1856656704 18.476 99 19 38 2 1867502656 5579968 5265984
23:17:07 9186 8192000000 10755156880 11180212224 1828021248 18.243 98 34 68 1 1843633664 5391472 10220944
23:17:24 27269 8192000000 10766149552 11200901120 1794856736 17.972 96 25 49 0 1811731424 9609328 7265360
23:18:22 21306 8192000000 10724608848 11141455872 1755042448 17.643 94 56 113 0 1778861040 6805472 17013120
23:18:51 8889 8192000000 10755403728 11178717184 1782431056 17.870 96 23 46 1 1794982416 6230080 6321280
23:19:06 8805 8192000000 10756911024 11178291200 1788135840 17.916 97 25 51 2 1804566288 9598144 6832304
23:19:21 6041 8192000000 10743561424 11164659712 1793320592 17.959 98 20 38 0 1804183808 5556960 5306256
23:19:36 4823 8192000000 10730286976 11152416768 1769761424 17.765 97 15 30 0 1779586800 5242752 4582624
23:19:47 4678 8192000000 10721613840 11140046848 1771613968 17.780 97 35 70 1 1787748720 5527376 10607376
23:20:00 6837 8192000000 10703635040 11113664512 1728372992 17.422 95 26 52 0 1742302560 6541584 7387984
23:20:15 8309 8192000000 10671614480 11094122496 1721042352 17.361 96 19 38 1 1731958032 5124144 5791536
23:20:31 10036 8192000000 10657714464 11062263808 1697638848 17.165 95 23 46 0 1710048320 5436480 6972992
23:20:51 9894 8192000000 10693405744 11108098048 1744358144 17.555 98 22 43 4 1756764416 5123440 7282832
23:21:10 6188 8192000000 10700542544 11116601344 1788342032 17.918 100 23 46 0 1800565424 6048272 6175120
23:21:24 6266 8192000000 10727399952 11140104192 1807284848 18.074 100 34 66 0 1823773872 6253360 10235664
23:21:36 11597 8192000000 10716654912 11135463424 1778647728 17.838 98 30 60 1 1793511104 5263568 9599808
23:21:54 5066 8192000000 10720090832 11131777024 1787749008 17.913 99 36 72 4 1804661568 5649520 11263040
23:22:08 9755 8192000000 10711904784 11138269184 1804361936 18.050 100 22 44 1 1816058640 5714480 5982224
23:22:26 11872 8192000000 10768181680 11165884416 1809881776 18.095 99 48 93 4 1830654576 5698656 15074144
23:22:44 66403 8192000000 10731144160 11156586496 1809769520 18.094 99 22 44 0 1822128384 6103088 6255776
23:23:59 9629 8192000000 10760623904 11173326848 1834222448 18.294 100 33 66 3 1849868304 5688304 9957552
23:24:20 8917 8192000000 10759343504 11183845376 1843452000 18.369 100 33 66 1 1859745184 6256224 10036960
23:24:37 8458 8192000000 10760896304 11182702592 1844738016 18.379 100 22 43 0 1856123040 4969456 6415568
23:24:52 4375 8192000000 10761224288 11186479104 1846517008 18.394 100 30 60 1 1861712768 6738752 8457008
23:25:03 6899 8192000000 10783187808 11196547072 1856732656 18.477 100 33 65 2 1872852400 5757824 10361920
23:25:18 9616 8192000000 10767225056 11196936192 1858558032 18.492 100 25 50 2 1871263968 5086352 7619584
23:25:35 10640 8192000000 10767382224 11199725568 1860388400 18.506 100 19 38 2 1871381456 5810336 5182720
23:25:51 8379 8192000000 10768853184 11201114112 1861751456 18.517 100 23 46 4 1874656416 5454736 7450224
23:26:08 8540 8192000000 10777421216 11207340032 1866900768 18.559 100 29 58 1 1881144688 5467232 8776688
23:26:25 11967 8192000000 10780498160 11209433088 1869347600 18.579 100 23 46 2 1881919472 5402864 7169008
23:26:43 8447 8192000000 10790653008 11219447808 1869736480 18.582 100 18 36 1 1884795088 9752576 5306032
23:26:58 11195 8192000000 10797863632 11219918848 1876636240 18.638 100 21 42 0 1887852336 5948464 5267632
23:27:23 23082 8192000000 10826057120 11240038400 1899506832 18.822 100 42 84 0 1918032304 6475440 12050032
23:27:56 32452 8192000000 10845264784 11264532480 1908665312 18.896 100 54 109 0 1941000128 16834304 15500512
23:28:41 21303 8192000000 10836195584 11265355776 1917995568 18.971 100 51 100 2 1941355584 8652624 14707392
23:29:54 109115 8192000000 10862621952 11296182272 1927319600 19.045 100 24 48 1 1948185984 13694112 7172272
23:31:51 65474 8192000000 10872453776 11310940160 1943935440 19.178 100 27 54 2 1964463984 12674592 7853952
23:33:03 10430 8192000000 10882141456 11307429888 1944670080 19.184 100 46 90 1 1973506288 16010592 12825616
23:33:20 22035 8192000000 10907055584 11331158016 1956679040 19.280 100 49 94 2 1988955040 18486976 13789024
23:33:53 17377 8192000000 10905010768 11336142848 1963372512 19.333 100 49 98 1 1998168608 19959984 14836112
23:34:18 10887 8192000000 10904055200 11331502080 1948946032 19.218 99 57 114 1 1984228224 18620656 16661536
23:34:36 5208 8192000000 10913201856 11341598720 1969289840 19.380 100 59 113 1 2004801664 18503392 17008432
23:34:49 7706 8192000000 10910388272 11334270976 1955500240 19.270 99 61 122 4 1991690288 18019264 18170784
23:35:05 8367 8192000000 10923384944 11349377024 1973573328 19.414 100 58 115 3 2009192224 17995968 17622928
23:35:20 1497 8192000000 10944756624 11356045312 1977962096 19.449 100 87 172 1 2025057792 22128800 24966896
23:35:28 5492 8192000000 10936351392 11350462464 1975397552 19.428 100 61 122 0 2016934000 23703232 17833216
23:35:43 6076 8192000000 10924139920 11348721664 1959202208 19.300 99 63 124 3 2001720096 24474688 18043200
23:35:57 6833 8192000000 10912957984 11337117696 1936591008 19.120 98 60 120 0 1982671264 28538944 17541312
23:36:16 10166 8192000000 10923830544 11344293888 1967153536 19.363 100 75 148 0 2014588512 25319552 22115424
23:36:42 6993 8192000000 10931362208 11350577152 1977029952 19.441 100 70 140 0 2022315840 24658160 20627728
23:36:57 6494 8192000000 10941336144 11363094528 1986490880 19.516 100 68 133 0 2032215728 25998368 19726480
23:37:12 5253 8192000000 10915163120 11336421376 1946230720 19.196 98 59 118 2 1990279824 26179760 17869344
23:37:24 6573 8192000000 10928879968 11346862080 1964620080 19.343 99 76 152 0 2015487856 28251136 22616640
23:37:39 8764 8192000000 10938734128 11358658560 1978464992 19.453 100 66 133 0 2024620432 26891648 19263792
23:37:56 10979 8192000000 10950997216 11370905600 1985884096 19.511 100 71 142 1 2034344848 27408432 21052320
23:38:18 4219 8192000000 10931813216 11353485312 1971082896 19.394 99 70 137 0 2018513664 26446704 20984064
23:38:29 3132 8192000000 10955385952 11370041344 1992195056 19.561 100 68 134 1 2038734368 25967632 20571680
23:38:42 11180 8192000000 10957084816 11383967744 1997592880 19.604 100 68 136 0 2047794096 29588816 20612400
23:39:05 4819 8192000000 10956386304 11384446976 2001776368 19.637 100 63 126 0 2051269120 30668176 18824576
23:39:21 8229 8192000000 10968122672 11395362816 2002726784 19.644 100 63 126 0 2053321632 31724288 18870560
23:39:49 4131 8192000000 10976936080 11404386304 2010608976 19.706 100 71 142 0 2064632688 32041136 21982576
23:40:02 2808 8192000000 10975116128 11403862016 2012100448 19.718 100 67 131 1 2061309392 29096432 20112512
23:40:14 3242 8192000000 10945837008 11365814272 1969725504 19.383 99 75 150 0 2020054640 27554608 22774528
23:40:25 11795 8192000000 10945022096 11371749376 1986385808 19.515 100 66 129 3 2035198720 28779664 20033248
23:40:45 5440 8192000000 10950551904 11379904512 1980960416 19.472 99 70 139 2 2031126208 29126160 21039632
23:40:58 2534 8192000000 10964118304 11378753536 1980143520 19.466 99 86 172 1 2037056960 30093328 26820112
23:41:08 4215 8192000000 10965275424 11385171968 1997307344 19.601 100 78 156 1 2052793712 31640672 23845696
23:41:19 2821 8192000000 10975887840 11393417216 2003529392 19.651 100 88 174 1 2062402128 32476512 26396224
23:41:35 4225 8192000000 10958818480 11373715456 1967546912 19.366 98 70 142 1 2020312960 31161408 21604640
23:41:45 2181 8192000000 10984597184 11399168000 2004872880 19.661 100 91 180 2 2067485568 33353872 29258816
23:41:54 3140 8192000000 10964767040 11384340480 1992403712 19.563 100 80 158 2 2050986512 34209632 24373168
23:42:06 3093 8192000000 10971613440 11381125120 1985873776 19.511 99 87 172 1 2046771136 34071536 26825824
23:42:17 5182 8192000000 10961454448 11385053184 1976780016 19.439 99 81 162 2 2037765312 35003104 25982192
23:42:31 3551 8192000000 10960830816 11378647040 1970205584 19.387 99 77 154 0 2028291088 34501760 23583744
23:42:43 7325 8192000000 10975450816 11392471040 1995729168 19.589 100 78 155 3 2056744848 36789888 24225792
23:42:58 4232 8192000000 10972523664 11393642496 1993866480 19.574 100 76 152 0 2056895296 38282976 24745840
23:43:10 3385 8192000000 10978740800 11397259264 2002821888 19.645 100 85 171 2 2065984368 37245760 25916720
23:43:20 3441 8192000000 10960020560 11392446464 1995825712 19.590 100 64 128 0 2053342160 36960928 20555520
23:43:31 6371 8192000000 10975943584 11393454080 1999006112 19.615 100 76 152 0 2058292864 35716688 23570064
23:43:44 2933 8192000000 10968350992 11390226432 1980738048 19.471 99 79 155 4 2039220944 34123584 24359312
23:43:55 3970 8192000000 10980489872 11402330112 2000366224 19.626 100 85 169 2 2064664256 38325024 25973008
23:44:08 6084 8192000000 10986371056 11410743296 2007794880 19.684 100 70 140 0 2066625504 37104816 21725808
23:44:22 1939 8192000000 10973502496 11390652416 1992919200 19.567 100 82 163 3 2054151488 36522496 24709792
23:44:33 1843 8192000000 10984790752 11397767168 1988228640 19.530 99 89 177 1 2055009008 40357872 26422496
23:44:41 3319 8192000000 10966440208 11380043776 1969724032 19.383 98 83 165 0 2039224656 43362480 26138144
23:44:51 1498 8192000000 10966920480 11382882304 1971656528 19.399 99 82 163 1 2038960512 41861168 25442816
23:44:59 3916 8192000000 10973496704 11387129856 1969664128 19.383 99 78 152 0 2036073280 41733440 24675712
23:45:12 2332 8192000000 10957474672 11372441600 1967796432 19.368 100 88 174 0 2038721584 43575440 27349712
23:45:21 3145 8192000000 10964773120 11373281280 1971940032 19.401 100 86 169 2 2044793776 45755744 27098000
23:45:31 2789 8192000000 10983954288 11397771264 1987464544 19.524 100 93 184 0 2063647648 46970496 29212608
23:45:40 8694 8192000000 10944246192 11384877056 1973353680 19.412 100 65 130 0 2042977952 48312816 21311456
23:46:01 3831 8192000000 10953919632 11374833664 1965170144 19.347 100 58 116 2 2030166096 46352000 18643952
23:46:14 2875 8192000000 10954225472 11378704384 1966543936 19.358 100 67 134 2 2036918256 47780128 22594192
23:46:24 3256 8192000000 10950947120 11371552768 1964089120 19.339 100 85 170 0 2040090672 49012832 26988720
23:46:34 3396 8192000000 10946635984 11372691456 1962100128 19.323 100 69 138 0 2035863664 50801664 22961872
23:46:46 3390 8192000000 10939812592 11346956288 1943149536 19.172 100 85 170 0 2016717776 46961680 26606560
23:46:56 2683 8192000000 10922294144 11333996544 1913295680 18.933 99 76 152 0 1988141040 49969680 24875680
23:47:07 10147 8192000000 10901674880 11327774720 1908025872 18.891 99 49 98 1 1973033440 48903984 16103584
23:47:26 8155 8192000000 10895782800 11326599168 1915845936 18.954 99 49 98 1 1979837232 47632272 16359024
23:47:41 8040 8192000000 10938239600 11355127808 1927414576 19.046 99 54 107 2 1991868384 46454128 17999680
23:47:58 1720 8192000000 10950156768 11357290496 1934932880 19.106 99 89 172 3 2010792576 49385120 26474576
23:48:08 4968 8192000000 10927400144 11352694784 1940448592 19.150 100 63 123 2 2012947520 52384256 20114672
23:48:22 10337 8192000000 10903850960 11335565312 1919860000 18.986 99 38 77 3 1974825904 41857696 13108208
23:48:49 5426 8192000000 10917893536 11351142400 1944704000 19.184 100 41 83 0 2000991920 42518048 13769872
23:49:01 8998 8192000000 10928352416 11365281792 1952768240 19.249 100 44 88 0 2009424768 41316368 15340160
23:49:17 12490 8192000000 10916444768 11355955200 1954391568 19.261 100 31 62 3 2000125632 34922304 10811760
23:49:41 7202 8192000000 10924144560 11356295168 1954702208 19.264 100 54 108 0 2010405520 38085056 17618256
23:50:00 17128 8192000000 10925136800 11365326848 1957836784 19.289 100 45 89 6 2010472128 38047824 14587520
23:50:25 12440 8192000000 10920425472 11362521088 1939761184 19.145 99 34 68 1 1990173296 38442736 11969376
23:50:47 8866 8192000000 10912663664 11353956352 1922083200 19.004 98 41 82 0 1976469872 40377840 14008832
23:51:06 22618 8192000000 10910243232 11359768576 1921959040 19.003 98 32 64 3 1969315776 36658480 10698256
23:51:35 2427 8192000000 10927614720 11341316096 1950324624 19.229 100 85 169 3 2005943232 29158464 26460144
23:51:48 6143 8192000000 10929378432 11361402880 1957827552 19.289 100 52 104 0 2011879776 37599856 16452368
23:52:09 12448 8192000000 10934040864 11373019136 1962674448 19.327 100 40 80 0 2014928640 38803632 13450560
23:52:48 6676 8192000000 10943985904 11384299520 1973358080 19.412 100 50 99 2 2027473040 38255872 15859088
23:53:02 13574 8192000000 10942453536 11393228800 1976998960 19.441 100 37 74 0 2029150736 40156672 11995104
23:53:54 19762 8192000000 10942997536 11393708032 1955307616 19.269 99 33 66 1 2016354288 49124928 11921744
23:54:21 16559 8192000000 10937185232 11406983168 1968968048 19.377 100 20 40 1 2020474480 44277184 7229248
23:54:55 37360 8192000000 10915528704 11384201216 1958313312 19.293 100 17 34 1 2006445568 41781696 6350560
23:55:39 23095 8192000000 10907657248 11374612480 1926129600 19.036 99 16 32 0 1981869632 49528464 6211568
23:56:09 33664 8192000000 10919006480 11389014016 1940086304 19.147 100 16 32 2 2001258608 54289296 6883008
23:56:51 49631 8192000000 10899533360 11392716800 1947382736 19.206 100 10 20 0 1997153328 46764112 3006480
23:57:47 104412 8192000000 10887812960 11339141120 1856167616 18.472 94 9 18 0 1871860224 13672432 2020176
23:59:37 37122 8192000000 10917187408 11358056448 1955945344 19.274 99 48 96 2 1980323232 10665488 13712400
00:00:35 51055 8192000000 10887660048 11353899008 1957783728 19.288 100 17 34 2 1974505744 11474032 5247984
00:01:42 111858 8192000000 10908120256 11373166592 1957859136 19.289 99 21 42 0 1978533568 14902768 5771664
00:05:22 100348 8192000000 10918106720 11387138048 1963525984 19.334 99 41 78 2 1985867696 10627888 11713824
00:07:10 29031 8192000000 10926276544 11367661568 1947496144 19.207 98 37 74 0 1965440064 7285248 10658672
00:07:47 22185 8192000000 10939229776 11377217536 1979698384 19.462 100 57 115 2 2006075104 10692432 15684288
00:08:23 165808 8192000000 10938545056 11386273792 1947804656 19.209 98 33 66 0 1970882496 13068672 10009168
00:11:17 34692 8192000000 10929635200 11384455168 1971969072 19.401 99 36 73 1 1999302432 17354576 9978784
00:11:58 30188 8192000000 10933013760 11378413568 1951818608 19.241 98 41 81 0 1977753792 13387760 12547424
00:12:35 12300 8192000000 10939134592 11384426496 1987275696 19.522 100 53 106 1 2015323136 12024320 16023120
00:13:12 33503 8192000000 10885477616 11360358400 1943240368 19.173 98 37 74 1 1969117552 14717456 11159728
00:13:53 39097 8192000000 10908011120 11379126272 1976608736 19.438 100 8 16 0 1991927488 12906480 2412272
00:14:45 37191 8192000000 10906992160 11380498432 1971031536 19.394 99 14 28 1 1985689408 10306016 4351856
00:15:28 33096 8192000000 10901632096 11365216256 1931995472 19.083 97 18 36 0 1949250800 11975488 5279840
00:16:39 47237 8192000000 10915019984 11375669248 1966999824 19.362 99 19 40 0 1984199536 11344784 5854928
00:17:36 60640 8192000000 10913066160 11387404288 1963325520 19.332 99 15 30 1 1981994608 13961744 4707344
00:18:55 94881 8192000000 10935169872 11403931648 1978988032 19.457 100 27 55 2 2009350864 21715392 8647440
00:20:36 57031 8192000000 10901709760 11385597952 1967681744 19.367 99 20 40 1 1992130384 18263088 6185552
00:21:41 48874 8192000000 10886345040 11349676032 1921981056 19.003 97 12 24 0 1933654240 8918960 2754224
00:22:37 25440 8192000000 10918876048 11382714368 1973607296 19.414 100 21 42 1 1986388400 7080608 5700496
00:23:12 44267 8192000000 10913897568 11377074176 1950315744 19.229 98 26 52 1 1968956928 10566416 8074768
00:24:10 44880 8192000000 10928415552 11395325952 1973683872 19.415 99 26 51 0 1994642544 13568816 7389856
00:25:10 52146 8192000000 10908803392 11390988288 1947643184 19.208 98 22 44 1 1972468864 18445072 6380608
00:26:13 56064 8192000000 10914072416 11383779328 1953615408 19.255 99 8 16 0 1976997840 20852400 2530032
00:27:16 80347 8192000000 10885581840 11340156928 1806756112 18.069 91 12 24 1 1823674656 13966592 2951952
00:28:48 29414 8192000000 10890475392 11361255424 1936091712 19.116 99 11 22 0 1954132176 15123856 2916608
00:29:28 59967 8192000000 10855812704 11321032704 1817643312 18.158 93 14 28 0 1834492704 13023776 3825616
00:30:37 34231 8192000000 10880214304 11344130048 1889424960 18.741 97 17 34 0 1901849552 7863728 4560864
00:31:18 34134 8192000000 10896857328 11337875456 1890451728 18.749 97 27 54 0 1907075360 8875328 7748304
00:32:03 36993 8192000000 10888873472 11337826304 1879722976 18.663 96 30 60 0 1897377424 9393648 8260800
00:32:48 31461 8192000000 10880256400 11335118848 1902547920 18.847 98 37 75 4 1924810384 12063040 10199424
00:33:36 77616 8192000000 10866460848 11333185536 1885981088 18.713 97 15 30 0 1903054672 13082640 3990944
00:35:38 95010 8192000000 10825348960 11291815936 1842641952 18.362 95 32 64 0 1860599312 8767536 9189824
00:37:24 39382 8192000000 10870179344 11338379264 1938723072 19.137 100 23 46 1 1956275408 10735104 6817232
00:38:18 15733 8192000000 10885398944 11354550272 1953094352 19.251 100 23 46 0 1969676016 10580896 6000768
00:38:47 43693 8192000000 10872821600 11340722176 1931565312 19.079 99 15 30 2 1947348128 11249248 4533568
00:39:42 60068 8192000000 10869737360 11331420160 1906011072 18.875 98 13 26 1 1926490256 17014688 3464496
00:40:53 70173 8192000000 10879029328 11366912000 1949354560 19.221 100 18 36 0 1975276112 20684880 5236672
00:42:14 65947 8192000000 10888305200 11361382400 1939810992 19.145 99 13 26 1 1963162336 19631664 3719680
00:43:26 52698 8192000000 10880201376 11363176448 1935753968 19.113 99 9 18 1 1959445552 20995424 2696160
00:44:58 55361 8192000000 10879697872 11355746304 1955631008 19.271 100 15 30 2 1970547760 10437536 4479216
00:45:59 55004 8192000000 10867228512 11336245248 1919963552 18.987 98 26 53 2 1937572656 10407200 7201904
00:47:06 48882 8192000000 10857994448 11321212928 1873786928 18.615 96 16 33 1 1887440512 9400704 4252880
00:48:05 33832 8192000000 10862245376 11322015744 1918549744 18.975 99 32 64 1 1935895216 8328784 9016688
00:48:47 18557 8192000000 10847701504 11304947712 1878333488 18.652 97 45 90 0 1900290208 8508512 13448208
00:49:25 48871 8192000000 10834162304 11303550976 1866022112 18.552 97 38 74 3 1892058384 15310736 10725536
00:50:32 23752 8192000000 10838301104 11297079296 1876689696 18.638 98 29 58 3 1892208320 7666720 7851904
00:51:10 34262 8192000000 10874293712 11333844992 1933251552 19.093 100 34 68 4 1954513104 11988176 9273376
00:52:29 67801 8192000000 10880142544 11347906560 1937036464 19.123 100 17 34 0 1963471024 21182384 5252176
00:54:11 101148 8192000000 10892544624 11369512960 1954796528 19.265 100 12 24 3 1975074016 16987648 3289840
00:55:59 46601 8192000000 10890355536 11366465536 1958140704 19.291 100 15 30 2 1976120736 13863952 4116080
00:56:57 69780 8192000000 10922187408 11369811968 1950322224 19.229 99 12 24 0 1967637536 14451984 2863328
00:58:14 103201 8192000000 10907108528 11372212224 1918416256 18.974 97 15 30 1 1931905264 9490832 3998176
01:00:07 109079 8192000000 10886506688 11369947136 1956732544 19.280 99 24 48 1 1978058352 13916768 7409040
01:02:02 61325 8192000000 10874135664 11357962240 1931930560 19.082 98 15 30 0 1948626448 12669024 4026864
01:03:14 27627 8192000000 10904597136 11375812608 1964495984 19.342 100 12 24 0 1979432320 11927312 3009024
01:03:50 64426 8192000000 10900758880 11381653504 1978145472 19.450 100 11 22 3 1992549200 11453376 2950352
01:05:01 107371 8192000000 10915836432 11392110592 1927968960 19.051 97 12 24 1 1950641952 19100256 3572736
01:07:03 80780 8192000000 10884886544 11381186560 1917487296 18.967 97 16 32 0 1943699904 21491680 4720928
01:08:30 99486 8192000000 10882149632 11357736960 1906835248 18.881 97 5 10 0 1920746192 12936448 974496
01:10:16 20995 8192000000 10912315296 11359875072 1942692896 19.168 99 60 119 1 1967921968 6834928 18394144
01:10:51 26681 8192000000 10881445536 11342311424 1934344096 19.102 99 48 96 0 1958232976 10372832 13516048
01:11:26 36986 8192000000 10901213808 11350011904 1938756400 19.137 99 48 94 2 1964265904 12015440 13494064
01:12:12 24204 8192000000 10868905280 11337138176 1923798800 19.017 99 36 72 0 1944871008 10786304 10285904
01:12:53 59837 8192000000 10867758480 11335012352 1913063680 18.931 98 13 26 1 1926953968 10174832 3715456
01:13:59 63410 8192000000 10892100400 11355709440 1916156336 18.956 98 20 40 0 1931492944 9882784 5453824
01:15:09 55696 8192000000 10886902192 11356733440 1925268976 19.029 98 22 45 5 1941571216 10182656 6119584
01:16:11 53742 8192000000 10878900320 11348709376 1899046576 18.819 97 29 58 1 1922358416 15522048 7789792
01:17:11 69605 8192000000 10896766672 11357843456 1917392688 18.966 98 15 30 2 1932891872 11546736 3952448
01:18:28 168861 8192000000 10843781376 11306811392 1860839280 18.510 95 16 32 1 1879839056 14279520 4720256
01:21:26 84710 8192000000 10873332352 11345248256 1913799056 18.937 98 19 34 2 1928201824 9817184 4585584
01:22:57 7147 8192000000 10859031792 11330834432 1926303584 19.037 99 31 60 2 1948793216 13222976 9266656
01:23:13 40213 8192000000 10848597088 11330457600 1918381872 18.974 99 14 28 0 1936053936 12332080 5339984
01:24:06 62607 8192000000 10833877664 11314585600 1870330624 18.587 97 7 14 0 1886002672 13673520 1998528
01:25:17 52464 8192000000 10842906352 11318099968 1889857840 18.745 98 10 20 0 1906174800 13263296 3053664
01:26:30 42463 8192000000 9565309232 9899810816 613864256 6.971 32 2 4 0 617882336 3432528 585552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 04-12-2020 01:30:03 to 04-12-2020 01:30:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 105 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-12-2020 01:30:36 to 04-12-2020 01:30:38.

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          243336
MON$OLDEST_ACTIVE               243337
MON$OLDEST_SNAPSHOT             243337
MON$NEXT_TRANSACTION            243337
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                       2062688
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'

04.12.20 01:30:39. 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-04 01:30:41 No severe PSQL-related problems occured
04.12.20 01:30:42. End of report.