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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17179600 kB
MemAvailable 31523944 kB
Buffers 0 kB
Cached 14542048 kB
SwapCached 2888 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-02 01:27:00
DTS_END                         2020-11-02 01:27:00.2350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/48974
TRN_ID                          238113
ATT_ID                          686
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: 8893.02 27878 1067162
customer order: creation 162.17 350 19460
customer order: refuse 13.80 382 1656
order to supplier: creation 43.35 1253 5202
order to supplier: removal 3.26 108814 391
invoice (draft): creation 44.15 3736 5298
invoice (draft): removal 49.83 908 5979
invoice accept: apply 40.40 20338 4848
invoice accept: cancel 45.63 789 5475
customer reserve: creation 3746.59 201 449591
customer reserve: removal 4461.38 61 535365
realization accept: apply 79.07 206 9488
realization accept: cancel 79.56 101 9547
payment from customer: creation 57.03 116 6844
payment from customer: removal 5.12 102 614
payment to supplier: creation 46.70 124 5604
payment to supplier: removal 3.26 92 391
service: total inventory turnovers 4.55 1512 546
service: total monetary turnovers 6.38 29 765
service: aggregate perf. data 0.78 21379 94
service: refresh index statistics 0.03 397058 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-11-2020 01:28:23 to 02-11-2020 01:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7026
TEST_TIME 2 5377
TEST_TIME 3 5635
TEST_TIME 4 5762
TEST_TIME 5 5702
TEST_TIME 6 6459
TEST_TIME 7 6214
TEST_TIME 8 6200
TEST_TIME 9 6579
TEST_TIME 10 7334
TEST_TIME 11 7390
TEST_TIME 12 7562
TEST_TIME 13 7661
TEST_TIME 14 8268
TEST_TIME 15 8255
TEST_TIME 16 8195
TEST_TIME 17 8141
TEST_TIME 18 8108
TEST_TIME 19 8240
TEST_TIME 20 8475
TEST_TIME 21 8303
TEST_TIME 22 8347
TEST_TIME 23 8805
TEST_TIME 24 8966
TEST_TIME 25 9240
TEST_TIME 26 9226
TEST_TIME 27 9430
TEST_TIME 28 10065
TEST_TIME 29 11074
TEST_TIME 30 10794
TEST_TIME 31 10601
TEST_TIME 32 10590
TEST_TIME 33 10464
TEST_TIME 34 10346
TEST_TIME 35 10213
TEST_TIME 36 10130
TEST_TIME 37 10007
TEST_TIME 38 10226
TEST_TIME 39 10139
TEST_TIME 40 10056
TEST_TIME 41 9954
TEST_TIME 42 9890
TEST_TIME 43 9879
TEST_TIME 44 9898
TEST_TIME 45 9780
TEST_TIME 46 9671
TEST_TIME 47 9643
TEST_TIME 48 9638
TEST_TIME 49 9610
TEST_TIME 50 9550
TEST_TIME 51 9404
TEST_TIME 52 9410
TEST_TIME 53 9379
TEST_TIME 54 9454
TEST_TIME 55 9410
TEST_TIME 56 9312
TEST_TIME 57 9241
TEST_TIME 58 9178
TEST_TIME 59 9096
TEST_TIME 60 9044
TEST_TIME 61 9039
TEST_TIME 62 8967
TEST_TIME 63 9023
TEST_TIME 64 9086
TEST_TIME 65 9039
TEST_TIME 66 9105
TEST_TIME 67 9164
TEST_TIME 68 9155
TEST_TIME 69 9226
TEST_TIME 70 9148
TEST_TIME 71 9211
TEST_TIME 72 9206
TEST_TIME 73 9288
TEST_TIME 74 9344
TEST_TIME 75 9379
TEST_TIME 76 9356
TEST_TIME 77 9381
TEST_TIME 78 9344
TEST_TIME 79 9267
TEST_TIME 80 9206
TEST_TIME 81 9191
TEST_TIME 82 9264
TEST_TIME 83 9276
TEST_TIME 84 9262
TEST_TIME 85 9254
TEST_TIME 86 9198
TEST_TIME 87 9144
TEST_TIME 88 9152
TEST_TIME 89 9135
TEST_TIME 90 9146
TEST_TIME 91 9077
TEST_TIME 92 9053
TEST_TIME 93 9022
TEST_TIME 94 9046
TEST_TIME 95 9030
TEST_TIME 96 9037
TEST_TIME 97 9080
TEST_TIME 98 9079
TEST_TIME 99 9078
TEST_TIME 100 9094
TEST_TIME 101 9085
TEST_TIME 102 9114
TEST_TIME 103 9265
TEST_TIME 104 9225
TEST_TIME 105 9211
TEST_TIME 106 9210
TEST_TIME 107 9136
TEST_TIME 108 9102
TEST_TIME 109 9097
TEST_TIME 110 9116
TEST_TIME 111 9094
TEST_TIME 112 9058
TEST_TIME 113 9037
TEST_TIME 114 8974
TEST_TIME 115 9003
TEST_TIME 116 9024
TEST_TIME 117 9017
TEST_TIME 118 8992
TEST_TIME 119 8971
TEST_TIME 120 8896

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-11-2020 01:28:26 to 02-11-2020 01:28:30.

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 1483398 1483398 0 0.00 0 12829 6 0 0
doc_list_biud 1483381 1483381 0 0.00 0 63008 29 0 0
sp_add_invoice_to_stock 4985 4848 137 2.74 41 175742 20339 0 137
sp_cancel_adding_invoice 5475 5475 0 0.00 5 52739 790 0 0
sp_cancel_client_order 1656 1656 0 0.00 4 9315 382 0 0
sp_cancel_customer_reserve 535365 535365 0 0.00 1 63017 62 0 0
sp_cancel_pay_from_customer 614 614 0 0.00 3 4628 103 0 0
sp_cancel_pay_to_supplier 391 391 0 0.00 3 2755 93 0 0
sp_cancel_supplier_invoice 5997 5979 18 0.30 2 12005 909 0 18
sp_cancel_supplier_order 391 391 0 0.00 6 1332104 108814 0 0
sp_cancel_write_off 9547 9547 0 0.00 1 12717 101 0 0
sp_client_order 19460 19460 0 0.00 4 30938 350 0 0
sp_customer_reserve 449591 449591 0 0.00 0 39899 202 0 0
sp_fill_shopping_cart 29959 29959 0 0.00 1 16790 42 0 0
sp_fill_shopping_cart_clo_res 449590 449590 0 0.00 0 16900 13 0 0
sp_get_clo_for_invoice 4842 4842 0 0.00 0 24378 328 0 0
sp_kill_cost_storno 16027 16027 0 0.00 0 12273 59 0 0
sp_kill_qstorno_ret_qs2qd 1086647 1086647 0 0.00 0 63006 34 0 0
sp_kill_qty_storno 572731 572731 0 0.00 0 63008 73 0 0
sp_lock_selected_doc 19800 19800 0 0.00 0 8357 5 0 0
sp_make_cost_storno 26778 26778 0 0.00 0 12824 50 0 0
sp_multiply_rows_for_pdistr 26769 26769 0 0.00 0 9752 32 0 0
sp_multiply_rows_for_qdistr 19460 19460 0 0.00 0 30930 137 0 0
sp_pay_from_customer 6844 6844 0 0.00 4 16169 116 0 0
sp_pay_to_supplier 5604 5604 0 0.00 5 15909 124 0 0
sp_payment_common 12443 12443 0 0.00 1 9990 26 0 0
sp_qd_handle_on_cancel_clo 1656 1656 0 0.00 0 8064 339 0 0
sp_qd_handle_on_invoice_upd_sts 10313 10313 0 0.00 0 20839 336 0 0
sp_qd_handle_on_reserve_upd_sts 9480 9480 0 0.00 0 13382 73 0 0
sp_reserve_write_off 9488 9488 0 0.00 6 16812 206 0 0
sp_supplier_invoice 5298 5298 0 0.00 7 102366 3736 0 0
sp_supplier_order 5202 5202 0 0.00 5 25281 1254 0 0
srv_aggregate_perf_data 94 94 0 0.00 2869 146853 21379 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 967 149960 30630 0 0
srv_find_qd_qs_mism 1021333 1021333 0 0.00 0 8575 5 0 0
srv_make_invnt_saldo 546 546 0 0.00 25 120919 1512 0 0
srv_make_money_saldo 765 765 0 0.00 1 1135 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 192020 684628 397059 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4848 4848 0 0.00 0 23281 206 0 0
t$perf-norm:sp_cancel_adding_invoice 407 407 0 0.00 0 3975 109 0 0
t$perf-norm:sp_cancel_client_order 1656 1656 0 0.00 0 5809 19 0 0
t$perf-norm:sp_cancel_customer_reserve 657 657 0 0.00 0 6678 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 614 614 0 0.00 0 2263 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 391 391 0 0.00 0 3060 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 379 379 0 0.00 0 1047 16 0 0
t$perf-norm:sp_cancel_supplier_order 391 391 0 0.00 0 25251 1832 0 0
t$perf-norm:sp_cancel_write_off 987 987 0 0.00 0 1371 8 0 0
t$perf-norm:sp_client_order 19460 19460 0 0.00 0 17336 22 0 0
t$perf-norm:sp_customer_reserve 1037 1037 0 0.00 0 422 3 0 0
t$perf-norm:sp_pay_from_customer 6844 6844 0 0.00 0 16738 20 0 0
t$perf-norm:sp_pay_to_supplier 5604 5604 0 0.00 0 29672 22 0 0
t$perf-norm:sp_reserve_write_off 9488 9488 0 0.00 0 6589 14 0 0
t$perf-norm:sp_supplier_invoice 5298 5298 0 0.00 0 11569 22 0 0
t$perf-norm:sp_supplier_order 5202 5202 0 0.00 0 5594 19 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 1947 31 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 704 8 0 0
t$perf-norm:srv_make_invnt_saldo 546 546 0 0.00 0 1231 22 0 0
t$perf-norm:srv_make_money_saldo 765 765 0 0.00 0 2682 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9950 9676 274 2.75 0 16649 27 0 274
v_all_customers 35490 35490 0 0.00 0 21 1 0 0
v_all_suppliers 28932 28932 0 0.00 0 21 1 0 0
v_all_wares 38920 38920 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 814 814 0 0.00 0 2257 11 0 0
v_cancel_client_order 3312 3312 0 0.00 0 8740 13 0 0
v_cancel_customer_prepayment 1228 1228 0 0.00 0 4604 15 0 0
v_cancel_customer_reserve 1314 1314 0 0.00 0 724 4 0 0
v_cancel_payment_to_supplier 782 782 0 0.00 0 2747 17 0 0
v_cancel_supplier_invoice 794 758 36 4.53 0 1250 16 0 36
v_cancel_supplier_order 782 782 0 0.00 0 7766 15 0 0
v_cancel_write_off 1974 1974 0 0.00 0 2426 16 0 0
v_max_id_clo_ord 5202 5202 0 0.00 0 2881 2 0 0
v_max_id_clo_res 1037 1037 0 0.00 0 2002 10 0 0
v_max_id_ord_sup 5297 5297 0 0.00 0 4184 4 0 0
v_max_non_paid_invoice 1635 1635 0 0.00 0 1761 6 0 0
v_max_non_paid_realizn 3676 3676 0 0.00 0 2790 5 0 0
v_min_id_clo_ord 5202 5202 0 0.00 0 4421 10 0 0
v_min_id_clo_res 1037 1037 0 0.00 0 2927 13 0 0
v_min_id_ord_sup 5297 5297 0 0.00 0 5789 5 0 0
v_min_non_paid_invoice 5602 5602 0 0.00 0 9985 17 0 0
v_min_non_paid_realizn 6841 6841 0 0.00 0 5953 16 0 0
v_our_firm 9760 9760 0 0.00 0 16 1 0 0
v_reserve_write_off 18958 18958 0 0.00 0 16592 11 0 0
x_lock_depdocs_on_canc_invoice 11075 11075 0 0.00 0 12474 131 0 0
x_lock_depdocs_on_canc_sup_ord 391 391 0 0.00 0 13734 444 0 0
x_make_qstorno_1000_1200 5202 5202 0 0.00 2 24965 1161 0 0
x_make_qstorno_1200_2000 5298 5298 0 0.00 3 102229 3592 0 0
x_make_qstorno_2100_3300 449591 449591 0 0.00 0 37391 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-11-2020 01:28:31 to 02-11-2020 01:28:35.

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:04 2 8192000000 8798422528 8808923136 5084624 0.062 1 1 2 0 5202672 55488 62560
22:57:10 7174 8192000000 10103996128 10394472448 841520016 9.315 69 48 97 0 860967008 2415024 17031968
22:57:24 33681 8192000000 10321985888 10637901824 1348436448 14.133 100 83 167 0 1379674784 4001232 27237104
22:58:05 26534 8192000000 10362477360 10682638336 1410523792 14.689 100 87 174 0 1444711520 5904176 28283552
22:58:44 15561 8192000000 10391077728 10715250688 1438850496 14.940 100 88 176 1 1474787280 7013360 28923424
22:59:09 30377 8192000000 10414435104 10742091776 1462189744 15.145 100 86 172 0 1497856816 7578128 28088944
22:59:50 18014 8192000000 10420551376 10754162688 1480941872 15.310 100 86 172 0 1517389952 8620128 27827952
23:00:20 15550 8192000000 10433607056 10766249984 1490288608 15.391 100 89 178 1 1527753472 9139584 28325280
23:00:45 14275 8192000000 10449724544 10789675008 1505769056 15.526 100 84 168 0 1542031728 9555920 26706752
23:01:17 16092 8192000000 10485918864 10833469440 1546128880 15.877 100 84 167 0 1581966416 9981424 25856112
23:01:41 12497 8192000000 10511252272 10862964736 1568236192 16.067 100 75 150 1 1601453856 10249024 22968640
23:02:05 14636 8192000000 10542517856 10895568896 1599904768 16.339 100 83 165 0 1635668512 10555424 25208320
23:02:28 12237 8192000000 10558990384 10918187008 1620897296 16.518 100 75 150 2 1653771056 10355664 22518096
23:02:48 10777 8192000000 10589142496 10954350592 1654566976 16.803 100 77 154 0 1687928064 10538800 22822288
23:03:07 11046 8192000000 10608704784 10976821248 1672317600 16.953 100 78 155 1 1706381584 11597888 22466096
23:03:30 8016 8192000000 10635152208 11006849024 1698282800 17.171 100 76 152 0 1731986832 11324224 22379808
23:03:46 7358 8192000000 10652536480 11026857984 1713807888 17.301 100 74 148 1 1747615776 11784464 22023424
23:04:02 6848 8192000000 10662483376 11039985664 1728839280 17.426 100 77 154 1 1763612864 12780544 21993040
23:04:17 7709 8192000000 10678482432 11059953664 1747553616 17.581 100 75 147 2 1780194336 12631296 20009424
23:04:34 5429 8192000000 10710623536 11085766656 1768238832 17.752 100 81 162 2 1803353584 12315776 22798976
23:04:48 4751 8192000000 10699284416 11084525568 1767943232 17.750 100 70 140 1 1800547840 12968640 19635968
23:05:01 5164 8192000000 10709829792 11095453696 1778213168 17.835 100 67 134 2 1808780096 12132448 18434480
23:05:14 3750 8192000000 10726051984 11105902592 1789927904 17.931 100 80 161 0 1824054768 11721536 22405328
23:05:26 9235 8192000000 10734144320 11120377856 1796318976 17.984 100 72 145 1 1828789824 12097488 20373360
23:05:46 4084 8192000000 10744686288 11132493824 1806783456 18.070 100 76 150 1 1840248720 12565552 20899712
23:05:56 4379 8192000000 10761142448 11145121792 1818465600 18.165 100 81 162 1 1854091136 13265552 22359984
23:06:08 3401 8192000000 10766193872 11148902400 1821615040 18.191 100 83 166 3 1859632448 14427024 23590384
23:06:18 2722 8192000000 10769051232 11151028224 1829290288 18.254 100 85 169 0 1868124912 15057456 23777168
23:06:28 1791 8192000000 10779518448 11163971584 1838234992 18.326 100 88 178 2 1876567344 13612208 24720144
23:06:36 2529 8192000000 10793683728 11175391232 1840527056 18.345 100 91 183 0 1880160928 13624720 26009152
23:06:46 3008 8192000000 10784354400 11174154240 1845584704 18.386 100 84 168 2 1883129488 14182128 23362656
23:06:56 2372 8192000000 10793940176 11179606016 1847668784 18.403 100 89 178 1 1887405168 14160864 25575520
23:07:05 1357 8192000000 10797313456 11182256128 1850903168 18.429 100 93 187 2 1890677776 13331856 26442752
23:07:14 2241 8192000000 10788285472 11181064192 1854523680 18.459 100 78 156 0 1888424224 12284864 21615680
23:07:23 1251 8192000000 10806449488 11192205312 1856658368 18.476 100 89 178 1 1893782304 12370480 24753456
23:07:30 2010 8192000000 10807261680 11194073088 1863969552 18.535 100 89 177 1 1902245712 13285008 24991152
23:07:40 2298 8192000000 10812196848 11198877696 1864731472 18.542 100 95 189 4 1904602768 13019792 26851504
23:07:48 1352 8192000000 10812010336 11200397312 1866217232 18.554 100 91 182 2 1905895536 13866928 25811376
23:07:56 1065 8192000000 10823937136 11211259904 1869972432 18.584 100 93 187 0 1913925664 17779120 26174112
23:08:03 1560 8192000000 10816052560 11206156288 1872219040 18.602 100 90 181 1 1910387664 13454912 24713712
23:08:11 1359 8192000000 10820626976 11214045184 1876208928 18.634 100 97 195 2 1918546256 15647776 26689552
23:08:19 1163 8192000000 10819758672 11210276864 1882788960 18.688 100 91 182 0 1922591120 13613984 26188176
23:08:27 26654 8192000000 10808576608 11208495104 1873548864 18.613 100 64 127 0 1903666176 12144480 17972832
23:09:00 15888 8192000000 10816593152 11215134720 1876611488 18.638 100 74 144 2 1907338992 8566672 22160832
23:09:23 1680 8192000000 10824154704 11222519808 1882085232 18.682 100 90 181 2 1919491104 10407136 26998736
23:09:31 5735 8192000000 10792226624 11211902976 1872640880 18.606 100 39 78 2 1892825552 8860848 11323824
23:09:44 3896 8192000000 10788046528 11210297344 1874642672 18.622 100 41 81 0 1894405552 8226896 11535984
23:09:54 7031 8192000000 10793086256 11213660160 1876944720 18.640 100 41 82 1 1897835472 8240416 12650336
23:10:07 4799 8192000000 10809984960 11223388160 1882481872 18.685 100 47 94 2 1903475648 7753872 13239904
23:10:19 4257 8192000000 10794685712 11223666688 1889647440 18.743 100 41 81 4 1909129936 7762112 11720384
23:10:31 3614 8192000000 10803743776 11224379392 1888034016 18.730 100 37 73 2 1906698544 8364464 10300064
23:10:42 2778 8192000000 10800139056 11228520448 1893610240 18.775 100 48 95 1 1915113616 7748720 13754656
23:10:51 5257 8192000000 10815305744 11239993344 1893514240 18.774 100 44 87 3 1917210288 11518912 12177136
23:11:04 8817 8192000000 10800572320 11229384704 1891179568 18.755 100 16 32 1 1901438848 5816400 4442880
23:11:20 15800 8192000000 10798122144 11237330944 1898770672 18.816 100 30 59 1 1914658512 6512272 9375568
23:11:42 48330 8192000000 10855427120 11252805632 1902834208 18.849 100 64 129 1 1928250336 6066944 19349184
23:12:36 8050 8192000000 10812422752 11252871168 1903120224 18.851 100 35 70 5 1925340640 12664336 9556080
23:12:51 7330 8192000000 10825899520 11255701504 1906061840 18.875 100 42 85 1 1926145424 7917616 12165968
23:13:07 5376 8192000000 10831896272 11259670528 1911367040 18.918 100 38 76 1 1930559264 8830112 10362112
23:13:19 4430 8192000000 10834993152 11265445888 1911033472 18.915 100 41 82 1 1929658640 7569936 11055232
23:13:31 3973 8192000000 10833117632 11261132800 1913131392 18.932 100 40 79 1 1932025776 7950832 10943552
23:13:42 7627 8192000000 10820134128 11253567488 1908682512 18.896 100 25 50 1 1922617696 7163760 6771424
23:13:56 12140 8192000000 10826821616 11258142720 1908208288 18.892 100 24 48 1 1920684992 5380512 7096192
23:14:17 40182 8192000000 10831077744 11267461120 1917902688 18.970 100 48 97 3 1937417536 6648480 12866368
23:15:03 7203 8192000000 10834062688 11268657152 1917085984 18.963 100 33 66 1 1937066944 9372096 10608864
23:15:24 2606 8192000000 10851905120 11275087872 1922875760 19.010 100 58 118 1 1947691728 7563504 17252464
23:15:34 6327 8192000000 10838038528 11273158656 1916315888 18.957 100 23 46 2 1929174912 6479728 6379296
23:15:47 7453 8192000000 10833003984 11269574656 1920564144 18.991 100 34 68 0 1937971120 8232432 9174544
23:16:00 3511 8192000000 10839545584 11268976640 1917198400 18.964 100 28 56 1 1931697952 5825232 8674320
23:16:13 4486 8192000000 10827202768 11259211776 1897158304 18.803 99 40 80 3 1915691584 7743104 10790176
23:16:26 6225 8192000000 10803658080 11228643328 1849490784 18.418 97 28 56 1 1863614560 6576176 7547600
23:16:39 4692 8192000000 10804121584 11235045376 1888519264 18.734 100 32 65 2 1905126272 7645136 8961872
23:16:51 9602 8192000000 10778753648 11203260416 1819910896 18.177 96 22 42 0 1831239248 4946720 6381632
23:17:07 8021 8192000000 10792111680 11217379328 1858293200 18.489 99 26 49 2 1871904464 6309792 7301472
23:17:21 3580 8192000000 10766916576 11187703808 1816148240 18.146 97 14 28 0 1825227760 5298576 3780944
23:17:33 5529 8192000000 10782307312 11210375168 1864293600 18.538 100 29 57 1 1878371136 6348032 7729504
23:17:56 45345 8192000000 10756332288 11183251456 1798956048 18.005 97 21 42 2 1810449504 5683296 5810160
23:18:50 14766 8192000000 10732682848 11166023680 1769108064 17.760 95 35 70 1 1788797600 8891856 10797680
23:19:16 8753 8192000000 10720037088 11131240448 1753054208 17.627 96 35 68 3 1768872880 5513056 10305616
23:19:32 4443 8192000000 10707809664 11120914432 1739536512 17.515 96 40 80 1 1757529008 4579040 13413456
23:19:44 6301 8192000000 10663373568 11072851968 1681244560 17.028 94 35 70 1 1702716976 11470144 10002272
23:19:59 7379 8192000000 10716254304 11123011584 1735322416 17.480 97 23 47 2 1747046064 5217888 6505760
23:20:12 5370 8192000000 10685185056 11102470144 1709225456 17.262 95 33 66 0 1725966864 7009040 9732368
23:20:28 4382 8192000000 10688263056 11093753856 1738329984 17.505 98 27 55 1 1751954752 5942288 7682480
23:20:40 9324 8192000000 10717341712 11132801024 1765055872 17.726 98 19 38 1 1780544528 9681376 5807280
23:20:56 8811 8192000000 10708172064 11128197120 1752694576 17.624 97 28 56 2 1766821072 6223248 7903248
23:21:11 10164 8192000000 10715706784 11134267392 1787911904 17.915 99 22 44 1 1800849024 6352880 6584240
23:21:30 8631 8192000000 10732909888 11154292736 1800835232 18.021 99 25 49 3 1817920976 10125888 6959856
23:21:44 9745 8192000000 10710406272 11132710912 1782995136 17.874 98 15 30 0 1792859680 6005200 3859344
23:22:02 12890 8192000000 10732896080 11156377600 1809690912 18.093 99 15 29 1 1820048944 5806752 4551280
23:22:29 57370 8192000000 10740644752 11171905536 1821261056 18.188 99 44 86 0 1839383312 4648784 13473472
23:23:32 13238 8192000000 10758023232 11184730112 1842484896 18.361 100 25 50 2 1859847824 10594320 6768608
23:23:52 5569 8192000000 10744704672 11165233152 1830207584 18.261 99 35 71 1 1847103184 6470176 10425424
23:24:03 7124 8192000000 10771085616 11191148544 1850348128 18.425 100 34 66 3 1865855568 5805168 9702272
23:24:17 3806 8192000000 10772753328 11194679296 1854422624 18.458 100 35 69 3 1871408976 6854816 10131536
23:24:28 6316 8192000000 10768582656 11196428288 1857059584 18.479 100 18 36 0 1867620224 4684352 5876288
23:24:41 7730 8192000000 10789376176 11206115328 1864310368 18.538 100 48 97 3 1885498096 7666928 13520800
23:24:55 9660 8192000000 10797676576 11209326592 1862505824 18.524 100 30 60 3 1877248608 6312864 8429920
23:25:11 9136 8192000000 10781350768 11209347072 1869699264 18.582 100 29 59 0 1883813824 5587040 8527520
23:25:29 10538 8192000000 10781518112 11210481664 1871529904 18.597 100 23 46 0 1883711360 5307568 6873888
23:25:46 8385 8192000000 10792505264 11221712896 1879570912 18.662 100 33 65 3 1895023456 5942640 9509904
23:26:01 9713 8192000000 10788604416 11221049344 1878686368 18.654 100 27 54 1 1892053504 5667840 7699296
23:26:19 10938 8192000000 10797984000 11228626944 1882790064 18.688 100 34 68 3 1898056624 4892224 10374336
23:26:36 6533 8192000000 10793047552 11228409856 1884015728 18.698 100 18 35 0 1894665728 5467776 5182224
23:26:49 14117 8192000000 10810132496 11234779136 1888851824 18.737 100 23 46 0 1900431248 4496336 7083088
23:27:10 4286 8192000000 10849331296 11257217024 1909061680 18.899 100 51 102 1 1930352880 6301904 14989296
23:27:22 86164 8192000000 10852031136 11278991360 1925615440 19.032 100 57 114 2 1950141840 8092240 16434160
23:28:58 17022 8192000000 10853377824 11284967424 1936061728 19.115 100 41 82 1 1955303440 7166512 12075200
23:29:25 10819 8192000000 10875711120 11297689600 1943606544 19.176 100 45 86 3 1964285456 8149632 12529280
23:29:45 10699 8192000000 10888639936 11310415872 1953854672 19.257 100 58 114 1 1979890848 9251328 16784848
23:30:07 9533 8192000000 10894073520 11321004032 1960133904 19.307 100 57 114 1 1986261872 10461360 15666608
23:30:25 7193 8192000000 10896106416 11318964224 1964847376 19.345 100 67 134 1 1996002016 12127712 19026928
23:30:41 21402 8192000000 10894620368 11321081856 1957163344 19.283 100 55 110 0 1984233888 10685264 16385280
23:31:23 17149 8192000000 10894559728 11331067904 1963590864 19.335 100 47 92 1 1993146976 16771984 12784128
23:31:53 15092 8192000000 10902807616 11332952064 1968306256 19.372 100 43 86 0 1990622368 9496128 12819984
23:32:21 9245 8192000000 10926723984 11348553728 1979293584 19.459 100 61 120 1 2008199072 11243408 17662080
23:32:37 17954 8192000000 10931471440 11360141312 1983103104 19.489 100 56 112 1 2016599472 17112496 16383872
23:33:04 6814 8192000000 10928538528 11360112640 1986559632 19.517 100 53 106 1 2020462352 18963232 14939488
23:33:18 11997 8192000000 10924347872 11356467200 1989102832 19.537 100 57 115 1 2018336144 12381424 16851888
23:33:38 19170 8192000000 10916940080 11350622208 1967457104 19.365 99 64 128 1 2002909056 17283824 18168128
23:34:06 23344 8192000000 10910970672 11336196096 1953613808 19.255 99 50 101 0 1982975808 14187808 15174192
23:34:41 6460 8192000000 10907418224 11336765440 1969057248 19.378 100 52 104 2 1999736304 14717440 15961616
23:34:54 11583 8192000000 10926646832 11355344896 1972836912 19.408 100 44 89 0 2001811440 15360992 13613536
23:35:21 15684 8192000000 10919442512 11352969216 1968812048 19.376 99 55 110 0 2001191824 16142512 16237264
23:35:46 11886 8192000000 10920806352 11353083904 1981734320 19.478 100 55 110 2 2015749968 17456176 16559472
23:36:15 4253 8192000000 10918347040 11341615104 1964385936 19.341 99 58 114 0 2001487504 19290992 17810576
23:36:31 7388 8192000000 10926765328 11349622784 1971921904 19.401 100 66 129 2 2013000640 21999088 19079648
23:36:45 4704 8192000000 10939499728 11359887360 1980272848 19.467 100 76 152 2 2025568464 22323824 22971792
23:36:58 6732 8192000000 10928046672 11359150080 1964437008 19.341 99 59 118 1 2004167408 22185344 17545056
23:37:16 4538 8192000000 10934136304 11359752192 1984373008 19.499 100 69 137 1 2028030976 23158288 20499680
23:37:35 6235 8192000000 10928547584 11358216192 1968406976 19.373 99 56 110 0 2005389264 19983232 16999056
23:37:51 1700 8192000000 10945224560 11367780352 1990763552 19.550 100 87 174 3 2036703920 19853552 26086816
23:37:59 2788 8192000000 10943465568 11363946496 1987933280 19.527 100 87 172 1 2034292208 21159392 25199536
23:38:10 2268 8192000000 10912018128 11330547712 1954381248 19.261 99 84 165 1 2000057600 21064784 24611568
23:38:19 1950 8192000000 10930995024 11348144128 1974022480 19.417 100 87 174 0 2021268592 21373456 25872656
23:38:29 3046 8192000000 10934723888 11343851520 1964839408 19.344 100 83 166 2 2011556576 22157808 24559360
23:38:39 17130 8192000000 10919059856 11339280384 1961204048 19.316 100 74 148 1 2008245824 25305888 21735888
23:39:03 5104 8192000000 10919135104 11338133504 1958202592 19.292 100 67 134 0 2002829664 25088432 19538640
23:39:15 7119 8192000000 10926015904 11345555456 1964034304 19.338 100 73 144 2 2011385152 25743152 21607696
23:39:29 11211 8192000000 10914817344 11342700544 1944350048 19.181 99 61 121 0 1987213184 24733824 18129312
23:39:51 4471 8192000000 10924444496 11343990784 1945269520 19.189 99 70 136 0 1993276256 27166352 20840384
23:40:04 9718 8192000000 10912667872 11344044032 1959917696 19.305 100 61 121 1 2006307056 27936064 18453296
23:40:24 3971 8192000000 10928154176 11345940480 1948339104 19.213 99 70 138 1 1997740160 27371296 22029760
23:40:35 12946 8192000000 10937942720 11362869248 1975286960 19.427 100 66 132 2 2024966880 29152272 20527648
23:40:55 1729 8192000000 10934944816 11352760320 1963443536 19.333 99 74 148 0 2016166928 30380240 22343152
23:41:05 4559 8192000000 10942760672 11363057664 1970099776 19.386 100 77 155 1 2025766752 32020320 23646656
23:41:17 2093 8192000000 10913777200 11341811712 1953434848 19.254 99 72 140 2 2006857776 31394096 22028832
23:41:25 966 8192000000 10931183072 11347009536 1966588800 19.358 100 85 169 3 2018087072 26534720 24963552
23:41:33 7545 8192000000 10940452480 11355922432 1972347248 19.404 100 83 164 1 2022236960 25071840 24817872
23:41:48 2449 8192000000 10912897040 11322802176 1945298016 19.189 99 83 166 1 1997269552 26609280 25362256
23:41:59 4814 8192000000 10895794752 11306749952 1922386528 19.006 99 79 158 2 1972834448 26744416 23703504
23:42:19 3122 8192000000 10896810928 11314003968 1932711904 19.089 100 63 124 1 1979165632 27014256 19439472
23:42:30 3486 8192000000 10911956016 11329908736 1948655600 19.216 100 60 118 0 1994773984 27384704 18733680
23:42:45 1592 8192000000 10908148544 11325005824 1947048768 19.203 100 66 132 1 1995596288 28391328 20156192
23:42:54 5342 8192000000 10894169280 11307266048 1926505824 19.039 99 75 146 2 1976909680 28140304 22263552
23:43:15 5807 8192000000 10908195808 11328651264 1943168432 19.172 100 67 135 1 1993898176 30593824 20135920
23:43:28 6156 8192000000 10915796128 11333640192 1948751440 19.217 100 69 138 3 2000815088 31156256 20907392
23:43:42 7968 8192000000 10920632016 11341676544 1954300576 19.261 100 64 126 0 2004656032 30912032 19443424
23:44:08 6014 8192000000 10922118128 11344826368 1955373856 19.269 100 59 118 2 2006025472 32130704 18520912
23:44:25 10906 8192000000 10877985872 11295793152 1897429312 18.806 99 59 117 0 1944555856 29447472 17679072
23:44:44 2558 8192000000 10887224800 11299160064 1906880448 18.882 99 59 116 1 1958042640 34198224 16963968
23:44:53 2552 8192000000 10896607520 11301289984 1919812320 18.985 99 84 167 2 1978155216 32022320 26320576
23:45:03 2765 8192000000 10892724624 11296731136 1899922800 18.826 98 80 160 1 1955914928 32300016 23692112
23:45:13 3990 8192000000 10900536880 11308969984 1927715296 19.049 100 75 148 0 1982567616 33047040 21805280
23:45:25 3488 8192000000 10913070032 11321188352 1935079664 19.107 100 79 158 0 1993131088 34200752 23850672
23:45:36 1739 8192000000 10914385728 11321528320 1935882880 19.114 100 84 168 1 1996929920 35947264 25099776
23:45:44 8737 8192000000 10913906096 11329134592 1942493440 19.167 100 78 154 0 2002029824 35967280 23569104
23:46:02 2182 8192000000 10913286768 11325083648 1935411296 19.110 100 73 146 1 1996700400 38371120 22917984
23:46:12 3609 8192000000 10910730032 11321864192 1939102336 19.140 100 76 148 1 1996686256 34893424 22690496
23:46:24 1734 8192000000 10916093120 11334598656 1946926672 19.202 100 67 133 0 2004022224 35856256 21239296
23:46:33 1355 8192000000 10927469888 11340242944 1950760784 19.233 100 77 152 0 2011176832 36604752 23811296
23:46:43 4355 8192000000 10942439824 11353473024 1962391712 19.325 100 67 134 2 2020074912 36813136 20870064
23:46:56 3026 8192000000 10947481216 11364102144 1968521392 19.374 100 72 144 0 2029186208 38231984 22432832
23:47:06 1459 8192000000 10945953824 11363778560 1970604080 19.390 100 65 130 0 2029244272 37877824 20762368
23:47:15 11495 8192000000 10941220928 11365765120 1963910400 19.337 100 52 102 1 2018638896 37523136 17205360
23:47:33 1698 8192000000 10942249536 11352711168 1961792736 19.320 100 80 159 2 2025120768 37864208 25463824
23:47:41 7161 8192000000 10913516736 11345879040 1934776768 19.105 99 47 94 2 1986979648 35893184 16309696
23:48:06 9006 8192000000 10911906912 11330732032 1926336944 19.038 99 50 101 1 1980394144 37318704 16738496
23:48:24 7405 8192000000 10917017408 11342417920 1950218176 19.228 100 47 94 0 2004798512 38987344 15592992
23:48:49 2578 8192000000 10930742176 11348586496 1949230224 19.220 100 63 126 1 2013236048 43534192 20471632
23:49:08 5473 8192000000 10936836288 11360423936 1955723984 19.272 100 54 107 0 2017805008 44562096 17518928
23:49:27 4556 8192000000 10950328016 11367870464 1963024368 19.330 100 64 128 1 2030978288 45800656 22153264
23:49:45 1984 8192000000 10964517328 11380342784 1974049136 19.418 100 78 156 1 2048471328 48364352 26057840
23:49:57 11309 8192000000 10947300848 11382894592 1971388960 19.396 100 42 82 2 2035708016 49509936 14809120
23:50:15 3368 8192000000 10978015856 11390341120 1985853952 19.511 100 73 146 2 2056042736 46673936 23514848
23:50:25 3146 8192000000 10975972320 11397464064 1985789312 19.511 100 70 140 0 2057463440 48661840 23012288
23:50:40 14705 8192000000 10945786672 11382501376 1961901536 19.321 99 42 84 1 2020932752 44426768 14604448
23:51:01 10761 8192000000 10929348592 11373031424 1953812752 19.257 99 34 68 0 2007691120 42087616 11790752
23:51:20 12338 8192000000 10924688896 11360006144 1949384672 19.222 99 35 69 2 1998280224 37348064 11547488
23:51:39 14058 8192000000 10932513568 11366346752 1958434784 19.294 100 45 90 0 2015542608 41642208 15465616
23:52:04 4563 8192000000 10949811728 11373858816 1964323776 19.340 100 54 108 4 2024146608 42103312 17719520
23:52:20 24426 8192000000 10931777392 11377393664 1970286032 19.388 100 33 66 0 2022325568 40587312 11452224
23:52:53 15119 8192000000 10937059920 11379068928 1965345888 19.349 100 30 60 0 2018579008 41998800 11234320
23:53:15 20079 8192000000 10934683456 11376934912 1964821536 19.344 100 34 68 3 2019301456 42620480 11859440
23:53:42 12571 8192000000 10945245696 11387109376 1965844592 19.352 100 40 80 1 2028787120 49065808 13876720
23:54:16 10379 8192000000 10953649776 11392253952 1963789904 19.336 100 35 70 0 2034015504 56905536 13320064
23:54:34 12190 8192000000 10956180016 11401674752 1963184288 19.331 100 29 58 0 2033235200 59215616 10835296
23:55:00 11822 8192000000 10945145584 11398230016 1944656240 19.184 99 28 56 0 2018848144 64533040 9658864
23:55:18 7093 8192000000 10933210880 11374915584 1932998816 19.091 99 30 60 0 2004650656 61081616 10570224
23:55:33 12772 8192000000 10893201088 11355279360 1920258208 18.989 99 16 32 0 1977792992 51026016 6508768
23:55:53 17061 8192000000 10882716720 11345002496 1926027760 19.035 100 14 28 3 1978854896 47427040 5400096
23:56:50 35663 8192000000 10884217376 11320860672 1938197264 19.132 100 41 80 1 1956586176 6913872 11475040
23:57:33 27464 8192000000 10893757936 11331600384 1951795136 19.241 100 33 65 1 1969580864 8483408 9302320
23:58:11 46672 8192000000 10896341488 11346001920 1965317952 19.348 100 36 72 3 1987936336 12380976 10237408
23:59:04 65931 8192000000 10897909808 11367550976 1968193632 19.371 100 11 22 1 1990012544 18804400 3014512
00:00:16 67132 8192000000 10895884656 11369091072 1964485408 19.342 100 4 8 0 1983165232 17825856 853968
00:01:31 78192 8192000000 10901931552 11371425792 1972889680 19.408 100 11 21 0 1988454976 13493456 2071840
00:02:56 54826 8192000000 10937786128 11368554496 1965309872 19.348 99 37 76 4 1983062656 8135856 9616928
00:03:58 47404 8192000000 10935068464 11397058560 1998710848 19.613 100 33 65 1 2022143600 13442960 9989792
00:05:35 75423 8192000000 10905356000 11390181376 1965622512 19.351 99 7 14 0 1983665904 16195408 1847984
00:06:58 58055 8192000000 10911362816 11380428800 1983923408 19.496 100 15 30 2 1999033504 11543696 3566400
00:08:02 2690 8192000000 10929940032 11379810304 1991127888 19.553 100 51 90 4 2012256432 6989168 14139376
00:08:11 17465 8192000000 10906238944 11370594304 1968758544 19.376 99 27 54 1 1983737888 7747088 7232256
00:08:53 53484 8192000000 10916720400 11389267968 1988486816 19.532 100 16 32 3 2004235856 11176784 4572256
00:10:00 54959 8192000000 10895781792 11368865792 1944042992 19.179 98 19 38 0 1963757440 14361264 5353184
00:11:05 64351 8192000000 10891366128 11365601280 1959068896 19.299 99 11 22 1 1973848240 11891888 2887456
00:12:16 48361 8192000000 10922631088 11377610752 1980289488 19.467 100 29 59 1 1998588304 9695840 8602976
00:13:28 74718 8192000000 10911513728 11392753664 1987251600 19.522 100 14 27 2 2004551616 12207216 5092800
00:15:02 96286 8192000000 10898150896 11362029568 1949439568 19.222 98 31 63 2 1969328608 10489392 9399648
00:16:45 68674 8192000000 10876468272 11356585984 1897655648 18.807 96 19 38 2 1919558544 16657344 5245552
00:18:02 43184 8192000000 10906352768 11361046528 1945020960 19.187 99 30 60 1 1964474928 10350272 9103696
00:18:52 26322 8192000000 10913729504 11370631168 1973859424 19.416 100 36 71 1 2000281424 15718160 10703840
00:19:31 54301 8192000000 10878885168 11348086784 1930733904 19.073 98 26 52 0 1948322192 10197552 7390736
00:20:33 61732 8192000000 10884967008 11371372544 1965325072 19.348 100 21 42 0 1988783392 17288880 6169440
00:21:53 44778 8192000000 10879970752 11360714752 1949588080 19.223 99 15 30 2 1961638240 7483264 4566896
00:22:44 47134 8192000000 10876324736 11350134784 1941483792 19.159 99 14 28 0 1953373232 7970528 3918912
00:24:10 32571 8192000000 10877099552 11355004928 1963264848 19.332 100 13 25 0 1974875168 8128544 3481776
00:25:25 100271 8192000000 10857552112 11328684032 1904063056 18.859 97 13 26 1 1914376272 7094624 3218592
00:27:11 40612 8192000000 10862140000 11332902912 1932962080 19.091 99 21 42 2 1950768752 12581904 5224768
00:27:58 82731 8192000000 10885228656 11368542208 1963595744 19.335 100 12 24 1 1981327936 14218192 3514000
00:29:32 60348 8192000000 10878237872 11356663808 1923102112 19.012 98 12 24 0 1942024496 15587008 3335376
00:30:45 83100 8192000000 10833524656 11308838912 1776384160 17.820 91 15 30 1 1797372528 17996720 2991648
00:32:15 64755 8192000000 10864809264 11334369280 1859870864 18.502 96 11 22 1 1875962624 13441472 2650288
00:33:31 59648 8192000000 10846571728 11302383616 1840053344 18.341 95 25 48 2 1859162112 11720912 7387856
00:34:37 29007 8192000000 10862702368 11316219904 1910621504 18.912 99 31 62 1 1928090944 8845024 8624416
00:35:12 29792 8192000000 10858303120 11311034368 1886153328 18.715 97 44 87 3 1908368688 10339728 11875632
00:35:50 57916 8192000000 10824008816 11304718336 1835705328 18.306 96 20 40 2 1861440320 20631728 5103264
00:36:57 29110 8192000000 10862406976 11292094464 1859967664 18.503 97 35 70 3 1877653952 7759248 9927040
00:37:55 33317 8192000000 10854289536 11304370176 1892239744 18.764 98 41 82 0 1914985344 11140128 11605472
00:38:39 34718 8192000000 10871083824 11318304768 1927344816 19.046 100 33 67 1 1945575952 8993568 9237568
00:39:21 45250 8192000000 10876972720 11341287424 1921890512 19.002 99 22 44 1 1940194656 12194992 6109152
00:40:13 74278 8192000000 10878781888 11339153408 1885888944 18.713 97 8 16 0 1906385408 18387728 2108736
00:41:34 72991 8192000000 10890390192 11362934784 1934590176 19.104 99 28 56 1 1960067280 17478400 7998704
00:43:03 70449 8192000000 10872391792 11344486400 1924227952 19.021 99 18 36 1 1941132208 12287392 4616864
00:44:20 96329 8192000000 10874248912 11339546624 1898757216 18.816 97 20 38 0 1914761104 10228480 5775408
00:46:03 149960 8192000000 10873821776 11337510912 1871966688 18.600 96 21 43 1 1894869536 16982960 5919888
00:48:40 51608 8192000000 10872413392 11337981952 1894391904 18.781 98 21 42 0 1917818720 17866240 5560576
00:50:46 103837 8192000000 10828438032 11301339136 1845414080 18.385 96 7 14 0 1861130832 13814800 1901952
00:52:36 59186 8192000000 10851011792 11319877632 1904434320 18.862 99 10 20 0 1919634560 11880400 3319840
00:53:42 83405 8192000000 10853600400 11318833152 1917548288 18.967 99 15 30 0 1933815264 12115328 4151648
00:56:04 43344 8192000000 10881134352 11345727488 1942648736 19.168 100 26 52 1 1960021424 9917536 7455152
00:58:16 72499 8192000000 10885315760 11361681408 1967387472 19.365 100 16 32 1 1978436576 7069296 3979808
00:59:48 73628 8192000000 10902516528 11364560896 1936646496 19.120 98 13 25 3 1953363056 13654416 3062144
01:01:16 73253 8192000000 10892739648 11369787392 1933633088 19.096 98 12 24 0 1946009728 9072640 3304000
01:02:36 43252 8192000000 10912036400 11368742912 1945965920 19.194 98 31 60 3 1967080096 12577728 8536448
01:03:27 47943 8192000000 10909345232 11377217536 1962549168 19.326 99 32 64 0 1984361280 12822304 8989808
01:04:22 36412 8192000000 10888880608 11363491840 1958358304 19.293 99 24 47 1 1982738912 17392288 6988320
01:05:07 58637 8192000000 10918474160 11376746496 1967266816 19.364 99 25 48 2 1983305344 9297984 6740544
01:06:12 61657 8192000000 10901543136 11376295936 1932960224 19.091 97 26 52 0 1951800816 11794288 7046304
01:07:20 49143 8192000000 10899199024 11362631680 1921702000 19.000 97 14 28 1 1936504784 10916016 3886768
01:08:38 37506 8192000000 10924909808 11380703232 1982458224 19.484 100 43 85 1 2005999440 11538448 12002768
01:09:23 53935 8192000000 10906434288 11390332928 1948515584 19.215 98 28 56 1 1974146848 17840848 7790416
01:10:34 117895 8192000000 10897007456 11375308800 1892857936 18.769 96 7 14 0 1914203024 19732352 1612736
01:12:44 55564 8192000000 10901899008 11363356672 1908588192 18.895 97 22 44 0 1925191568 9266496 7336880
01:13:52 139891 8192000000 10923298960 11363786752 1917980800 18.971 97 31 62 1 1937349280 10808432 8560048
01:16:22 50095 8192000000 10929338848 11379150848 1959475360 19.302 99 55 110 1 1989343872 14788704 15079808
01:17:19 34899 8192000000 10866546384 11353522176 1949898720 19.226 99 43 86 0 1973784816 12217200 11668896
01:18:02 43941 8192000000 10873952912 11343462400 1908419520 18.894 97 14 28 1 1919221280 6635168 4166592
01:18:52 65954 8192000000 10870839632 11344388096 1903220464 18.852 97 13 26 2 1914670592 7939504 3510624
01:20:04 45524 8192000000 10866457152 11344252928 1919651088 18.984 98 10 20 0 1932211488 9740992 2819408
01:21:01 71670 8192000000 10868332976 11337449472 1940832896 19.153 99 12 24 0 1955808464 11399136 3576432
01:22:23 74100 8192000000 10857480912 11341586432 1888050352 18.730 97 7 14 0 1905833712 15380336 2403024
01:23:46 65630 8192000000 10868162048 11334619136 1920714992 18.993 99 22 44 1 1935888384 8696944 6476448
01:25:03 65439 8192000000 10869919776 11330408448 1875629904 18.630 96 23 46 1 1893232880 11024128 6578848
01:26:15 43172 8192000000 10876659760 11335057408 1908272256 18.893 98 21 42 0 1927002944 12389232 6341456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 02-11-2020 01:28:37 to 02-11-2020 01:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
user_exc 137 v_add_invoice_to_stock 335544517
user_exc 18 v_cancel_supplier_invoice 335544517

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

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          235114
MON$OLDEST_ACTIVE               238277
MON$OLDEST_SNAPSHOT             238277
MON$NEXT_TRANSACTION            238277
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                       2031776
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:191: 
:192: mscs-test-161.budzdorov.ru    Mon Nov  2 00:24:23 2020
:193:     Modifying procedure SP_ADD_TO_ABEND_LOG which is currently in use by active user requests
:194: 
:195: 
:196: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:00 2020
:197:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:198: 
:199: 
:200: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:02 2020
:201:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:202: 
:203: 
:204: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:02 2020
:205:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:206: 
:207: 
:208: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:06 2020
:209:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:210: 
:211: 
:212: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:06 2020
:213:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:214: 
:215: 
:216: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:07 2020
:217:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:218: 
:219: 
:220: mscs-test-161.budzdorov.ru    Mon Nov  2 01:27:07 2020
:221:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:222: 
--- end of diff output ---

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

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