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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17541564 kB
MemAvailable 31469448 kB
Buffers 0 kB
Cached 14153592 kB
SwapCached 2828 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-05 19:27:01
DTS_END                         2020-11-05 19:27:01.7180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50692
TRN_ID                          230636
ATT_ID                          585
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: 8978.39 23085 1077407
customer order: creation 162.71 427 19525
customer order: refuse 14.13 374 1695
order to supplier: creation 42.97 1405 5156
order to supplier: removal 3.44 102649 413
invoice (draft): creation 44.24 3485 5309
invoice (draft): removal 51.88 852 6226
invoice accept: apply 38.82 17992 4658
invoice accept: cancel 46.93 881 5632
customer reserve: creation 3627.82 176 435338
customer reserve: removal 4662.22 60 559466
realization accept: apply 78.91 187 9469
realization accept: cancel 85.14 115 10217
payment from customer: creation 54.83 126 6580
payment from customer: removal 5.11 62 613
payment to supplier: creation 44.51 130 5341
payment to supplier: removal 3.22 103 386
service: total inventory turnovers 4.46 1040 535
service: total monetary turnovers 6.22 29 746
service: aggregate perf. data 0.82 22440 98
service: refresh index statistics 0.03 309157 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-11-2020 19:28:28 to 05-11-2020 19:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4870
TEST_TIME 2 4723
TEST_TIME 3 5283
TEST_TIME 4 5427
TEST_TIME 5 5796
TEST_TIME 6 5467
TEST_TIME 7 5599
TEST_TIME 8 5694
TEST_TIME 9 5686
TEST_TIME 10 5989
TEST_TIME 11 6217
TEST_TIME 12 6538
TEST_TIME 13 6565
TEST_TIME 14 6569
TEST_TIME 15 6798
TEST_TIME 16 6982
TEST_TIME 17 7146
TEST_TIME 18 8033
TEST_TIME 19 8235
TEST_TIME 20 8610
TEST_TIME 21 9104
TEST_TIME 22 9512
TEST_TIME 23 9803
TEST_TIME 24 10147
TEST_TIME 25 10742
TEST_TIME 26 10885
TEST_TIME 27 10942
TEST_TIME 28 11008
TEST_TIME 29 10779
TEST_TIME 30 10638
TEST_TIME 31 10491
TEST_TIME 32 10329
TEST_TIME 33 10129
TEST_TIME 34 9966
TEST_TIME 35 10011
TEST_TIME 36 9816
TEST_TIME 37 9591
TEST_TIME 38 9600
TEST_TIME 39 9708
TEST_TIME 40 9553
TEST_TIME 41 9398
TEST_TIME 42 9314
TEST_TIME 43 9317
TEST_TIME 44 9296
TEST_TIME 45 9384
TEST_TIME 46 9259
TEST_TIME 47 9153
TEST_TIME 48 9136
TEST_TIME 49 9105
TEST_TIME 50 9111
TEST_TIME 51 9138
TEST_TIME 52 9189
TEST_TIME 53 9193
TEST_TIME 54 9232
TEST_TIME 55 9314
TEST_TIME 56 9368
TEST_TIME 57 9296
TEST_TIME 58 9478
TEST_TIME 59 9494
TEST_TIME 60 9418
TEST_TIME 61 9421
TEST_TIME 62 9283
TEST_TIME 63 9214
TEST_TIME 64 9223
TEST_TIME 65 9188
TEST_TIME 66 9161
TEST_TIME 67 9110
TEST_TIME 68 9097
TEST_TIME 69 9183
TEST_TIME 70 9132
TEST_TIME 71 9152
TEST_TIME 72 9118
TEST_TIME 73 9094
TEST_TIME 74 9189
TEST_TIME 75 9165
TEST_TIME 76 9255
TEST_TIME 77 9289
TEST_TIME 78 9321
TEST_TIME 79 9312
TEST_TIME 80 9296
TEST_TIME 81 9231
TEST_TIME 82 9201
TEST_TIME 83 9171
TEST_TIME 84 9139
TEST_TIME 85 9075
TEST_TIME 86 9073
TEST_TIME 87 9057
TEST_TIME 88 9034
TEST_TIME 89 9052
TEST_TIME 90 9037
TEST_TIME 91 9030
TEST_TIME 92 9111
TEST_TIME 93 9125
TEST_TIME 94 9096
TEST_TIME 95 9181
TEST_TIME 96 9148
TEST_TIME 97 9180
TEST_TIME 98 9189
TEST_TIME 99 9150
TEST_TIME 100 9225
TEST_TIME 101 9260
TEST_TIME 102 9277
TEST_TIME 103 9246
TEST_TIME 104 9332
TEST_TIME 105 9255
TEST_TIME 106 9217
TEST_TIME 107 9174
TEST_TIME 108 9151
TEST_TIME 109 9105
TEST_TIME 110 9095
TEST_TIME 111 9062
TEST_TIME 112 9022
TEST_TIME 113 9031
TEST_TIME 114 8986
TEST_TIME 115 8975
TEST_TIME 116 9051
TEST_TIME 117 9068
TEST_TIME 118 9062
TEST_TIME 119 9054
TEST_TIME 120 8980

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-11-2020 19:28:32 to 05-11-2020 19:28:35.

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 1481550 1481550 0 0.00 0 20171 6 0 0
doc_list_biud 1481550 1481550 0 0.00 0 67382 29 0 0
sp_add_invoice_to_stock 4788 4658 130 2.71 24 161604 17992 0 130
sp_cancel_adding_invoice 5632 5632 0 0.00 4 90673 881 0 0
sp_cancel_client_order 1695 1695 0 0.00 4 9541 375 0 0
sp_cancel_customer_reserve 559466 559466 0 0.00 1 67385 60 0 0
sp_cancel_pay_from_customer 613 613 0 0.00 3 2778 63 0 0
sp_cancel_pay_to_supplier 386 386 0 0.00 2 8099 104 0 0
sp_cancel_supplier_invoice 6236 6226 10 0.16 1 19256 852 0 10
sp_cancel_supplier_order 413 413 0 0.00 7 938775 102650 0 0
sp_cancel_write_off 10217 10217 0 0.00 1 8847 116 0 0
sp_client_order 19525 19525 0 0.00 3 34051 427 0 0
sp_customer_reserve 435338 435338 0 0.00 0 40049 176 0 0
sp_fill_shopping_cart 29973 29973 0 0.00 1 18504 44 0 0
sp_fill_shopping_cart_clo_res 435334 435334 0 0.00 0 16362 15 0 0
sp_get_clo_for_invoice 4652 4652 0 0.00 0 23556 373 0 0
sp_kill_cost_storno 16848 16848 0 0.00 0 8093 58 0 0
sp_kill_qstorno_ret_qs2qd 1135788 1135788 0 0.00 0 64498 33 0 0
sp_kill_qty_storno 597765 597765 0 0.00 0 67382 71 0 0
sp_lock_selected_doc 19622 19622 0 0.00 0 5050 2 0 0
sp_make_cost_storno 26037 26037 0 0.00 0 9806 52 0 0
sp_multiply_rows_for_pdistr 26037 26037 0 0.00 0 7351 30 0 0
sp_multiply_rows_for_qdistr 19525 19525 0 0.00 0 12936 198 0 0
sp_pay_from_customer 6580 6580 0 0.00 4 10630 126 0 0
sp_pay_to_supplier 5341 5341 0 0.00 5 10418 131 0 0
sp_payment_common 11921 11921 0 0.00 1 10565 32 0 0
sp_qd_handle_on_cancel_clo 1695 1695 0 0.00 0 9532 342 0 0
sp_qd_handle_on_invoice_upd_sts 10279 10279 0 0.00 0 22389 328 0 0
sp_qd_handle_on_reserve_upd_sts 9469 9469 0 0.00 0 30632 69 0 0
sp_reserve_write_off 9469 9469 0 0.00 6 30654 187 0 0
sp_supplier_invoice 5309 5309 0 0.00 7 74092 3485 0 0
sp_supplier_order 5156 5156 0 0.00 5 33330 1405 0 0
srv_aggregate_perf_data 99 98 1 1.01 2435 299474 22440 0 1
srv_fill_mon_cache_memory 161 161 0 0.00 1441 133620 33743 0 0
srv_find_qd_qs_mism 1033208 1033208 0 0.00 0 20169 5 0 0
srv_make_invnt_saldo 535 535 0 0.00 24 57893 1041 0 0
srv_make_money_saldo 746 746 0 0.00 1 6987 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 224695 410174 309158 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 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-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4658 4658 0 0.00 0 12222 159 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 10911 129 0 0
t$perf-norm:sp_cancel_client_order 1695 1695 0 0.00 0 15191 21 0 0
t$perf-norm:sp_cancel_customer_reserve 661 661 0 0.00 0 2035 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 613 613 0 0.00 0 1089 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 386 386 0 0.00 0 6591 23 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 680 19 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 26541 1621 0 0
t$perf-norm:sp_cancel_write_off 929 929 0 0.00 0 2503 7 0 0
t$perf-norm:sp_client_order 19525 19525 0 0.00 0 8838 14 0 0
t$perf-norm:sp_customer_reserve 924 924 0 0.00 0 1975 7 0 0
t$perf-norm:sp_pay_from_customer 6580 6580 0 0.00 0 14908 11 0 0
t$perf-norm:sp_pay_to_supplier 5341 5341 0 0.00 0 10733 13 0 0
t$perf-norm:sp_reserve_write_off 9469 9469 0 0.00 0 12986 12 0 0
t$perf-norm:sp_supplier_invoice 5309 5309 0 0.00 0 17484 20 0 0
t$perf-norm:sp_supplier_order 5156 5156 0 0.00 0 7975 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 852 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 5834 43 0 0
t$perf-norm:srv_make_invnt_saldo 535 535 0 0.00 0 2347 18 0 0
t$perf-norm:srv_make_money_saldo 746 746 0 0.00 0 5932 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 1 1 0 0
v_add_invoice_to_stock 9554 9294 260 2.72 0 6015 24 0 260
v_all_customers 35349 35349 0 0.00 0 15 1 0 0
v_all_suppliers 28780 28780 0 0.00 0 11 1 0 0
v_all_wares 39046 39046 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 2905 9 0 0
v_cancel_client_order 3390 3390 0 0.00 0 6094 11 0 0
v_cancel_customer_prepayment 1226 1226 0 0.00 0 274 3 0 0
v_cancel_customer_reserve 1322 1322 0 0.00 0 4058 8 0 0
v_cancel_payment_to_supplier 772 772 0 0.00 0 6019 20 0 0
v_cancel_supplier_invoice 830 810 20 2.40 0 5756 22 0 20
v_cancel_supplier_order 826 826 0 0.00 0 1774 10 0 0
v_cancel_write_off 1858 1858 0 0.00 0 3070 16 0 0
v_max_id_clo_ord 5155 5155 0 0.00 0 283 1 0 0
v_max_id_clo_res 924 924 0 0.00 0 1520 11 0 0
v_max_id_ord_sup 5294 5294 0 0.00 0 6333 5 0 0
v_max_non_paid_invoice 1400 1400 0 0.00 0 1905 4 0 0
v_max_non_paid_realizn 3484 3484 0 0.00 0 4909 6 0 0
v_min_id_clo_ord 5155 5155 0 0.00 0 3233 7 0 0
v_min_id_clo_res 924 924 0 0.00 0 7985 21 0 0
v_min_id_ord_sup 5294 5294 0 0.00 0 5812 9 0 0
v_min_non_paid_invoice 5341 5341 0 0.00 0 8106 17 0 0
v_min_non_paid_realizn 6580 6580 0 0.00 0 10394 23 0 0
v_our_firm 9888 9888 0 0.00 0 12 1 0 0
v_reserve_write_off 18938 18938 0 0.00 0 7360 8 0 0
x_lock_depdocs_on_canc_invoice 11453 11453 0 0.00 0 18982 129 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 9909 332 0 0
x_make_qstorno_1000_1200 5156 5156 0 0.00 1 33315 1332 0 0
x_make_qstorno_1200_2000 5309 5309 0 0.00 3 73959 3313 0 0
x_make_qstorno_2100_3300 435338 435338 0 0.00 0 39315 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-11-2020 19:28:36 to 05-11-2020 19:28:40.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 17931 8192000000 10291466704 10606178304 1123114480 12.056 86 63 125 0 1146932608 3111792 20706336
16:57:39 20225 8192000000 10374853008 10695417856 1419833648 14.771 100 86 172 0 1452182096 5288560 27059888
16:58:19 14604 8192000000 10409305120 10736074752 1461070576 15.135 100 90 180 1 1496658544 6608048 28979920
16:58:53 22628 8192000000 10431716304 10763001856 1481067856 15.311 100 86 172 0 1516101856 7881104 27152896
16:59:24 19604 8192000000 10442901136 10776178688 1499979136 15.476 100 90 180 0 1536684448 8242432 28462880
16:59:51 25662 8192000000 10466402224 10800717824 1518417664 15.636 100 93 187 1 1557298896 9206736 29674496
17:00:30 21351 8192000000 10479398224 10816372736 1531391648 15.749 100 87 174 1 1568791920 10016560 27383712
17:01:00 16900 8192000000 10488674848 10831290368 1538742848 15.813 100 84 167 0 1575616320 10045936 26827536
17:01:27 10108 8192000000 10508605392 10858205184 1569771472 16.080 100 81 162 1 1604488464 10273696 24443296
17:01:54 11005 8192000000 10534782368 10890604544 1599247584 16.333 100 78 156 1 1633315280 10458944 23608752
17:02:13 9444 8192000000 10553322368 10913501184 1613897824 16.458 100 76 148 2 1646594912 10473808 22223280
17:02:32 8679 8192000000 10579211584 10937614336 1640159824 16.681 100 85 170 0 1677702016 11611280 25930912
17:02:47 10642 8192000000 10596935440 10960257024 1652309568 16.784 100 77 154 1 1687588016 12336016 22942432
17:03:06 10692 8192000000 10611803024 10978885632 1669669440 16.930 100 78 154 1 1704827952 12447136 22711376
17:03:27 8022 8192000000 10626558688 10997198848 1692496016 17.122 100 77 154 3 1727295552 12518768 22280768
17:03:42 7081 8192000000 10646992560 11015352320 1709139456 17.262 100 79 158 0 1744615136 12664384 22811296
17:03:58 7159 8192000000 10656086512 11029549056 1716662592 17.324 100 79 158 4 1753568848 13018832 23887424
17:04:14 6929 8192000000 10677751280 11049357312 1735205248 17.479 100 78 154 1 1770481760 13522032 21754480
17:04:29 4282 8192000000 10686631248 11060703232 1742860960 17.542 100 89 178 1 1782675680 14273920 25540800
17:04:40 6166 8192000000 10700611344 11075522560 1750223440 17.603 100 74 147 0 1784942464 14454912 20264112
17:04:53 4116 8192000000 10697969472 11073908736 1762682016 17.707 100 90 178 2 1803555840 15303552 25570272
17:05:04 4472 8192000000 10702032240 11083309056 1767482304 17.746 100 81 164 1 1804246016 14043968 22719744
17:05:16 4393 8192000000 10709379360 11093925888 1779254736 17.843 100 83 166 0 1816288224 13009872 24023616
17:05:28 2903 8192000000 10727093104 11104235520 1784925632 17.890 100 84 169 2 1821597904 12754544 23917728
17:05:38 2879 8192000000 10739440688 11120902144 1800603952 18.019 100 87 172 0 1836675424 12146080 23925392
17:05:49 2599 8192000000 10744201856 11123183616 1804663312 18.052 100 86 170 1 1838994160 11310208 23020640
17:05:58 8508 8192000000 10739078080 11124658176 1810340912 18.099 100 87 176 1 1847139328 12565840 24232576
17:06:13 1756 8192000000 10762735808 11143053312 1820222624 18.180 100 96 190 2 1858732752 12846528 25663600
17:06:21 3119 8192000000 10769656320 11153915904 1820116416 18.179 100 89 178 2 1857508208 13922912 23468880
17:06:31 1455 8192000000 10775193952 11158958080 1837942528 18.324 100 93 187 1 1878140048 13973760 26223760
17:06:39 2162 8192000000 10779154048 11163873280 1840771984 18.347 100 92 184 0 1880479888 14210448 25497456
17:06:48 2062 8192000000 10794933056 11179290624 1844593472 18.378 100 94 187 0 1886035872 14958448 26483952
17:06:56 2247 8192000000 10797074688 11180982272 1850898336 18.429 100 87 175 1 1888774960 13717312 24159312
17:07:05 1454 8192000000 10797641424 11182784512 1858163632 18.488 100 96 192 0 1898968176 14013840 26790704
17:07:13 2390 8192000000 10804359424 11193122816 1860160016 18.505 100 90 181 0 1900188752 14728224 25300512
17:07:22 1440 8192000000 10808864432 11198435328 1864422288 18.539 100 87 175 1 1901515824 11818128 25275408
17:07:30 1536 8192000000 10809070656 11202650112 1871842112 18.599 100 82 165 1 1905805376 10388592 23574672
17:07:38 1588 8192000000 10815025664 11203788800 1872378816 18.604 100 84 170 1 1907046848 10515152 24152880
17:07:48 24627 8192000000 10803569056 11207655424 1871392688 18.596 100 66 132 1 1899784224 9764864 18626672
17:08:22 3066 8192000000 10814468896 11212107776 1877388736 18.644 100 76 153 1 1909985840 10256448 22340656
17:08:32 1527 8192000000 10833718304 11224133632 1884448416 18.701 100 92 180 3 1923881808 12526848 26906544
17:08:39 4907 8192000000 10816133520 11217227776 1880636912 18.670 100 67 134 1 1910550496 11425744 18487840
17:08:52 3740 8192000000 10791177696 11214602240 1880901888 18.672 100 49 98 0 1904505296 10595584 13007824
17:09:04 4566 8192000000 10790674608 11215040512 1880180448 18.667 100 35 70 0 1898090128 7761904 10147776
17:09:16 7001 8192000000 10797749792 11224031232 1886431584 18.717 100 39 76 0 1906139168 8849776 10857808
17:09:29 4434 8192000000 10799049264 11224666112 1885609440 18.710 100 21 42 1 1898385408 6268896 6507072
17:09:41 4504 8192000000 10802495504 11225878528 1888758416 18.736 100 30 60 1 1904174528 6760288 8655824
17:09:52 9060 8192000000 10823185248 11230466048 1891721664 18.760 100 31 62 1 1906983024 6342496 8918864
17:10:08 6497 8192000000 10797483040 11228782592 1890598736 18.751 100 24 48 1 1904424976 7086256 6739984
17:10:22 7354 8192000000 10793560000 11227602944 1889805904 18.744 100 20 40 2 1901159712 5788784 5565024
17:10:36 7911 8192000000 10803839968 11231772672 1893723280 18.776 100 21 42 1 1910257072 10516128 6017664
17:10:54 11438 8192000000 10798837456 11235729408 1893428544 18.773 100 17 34 0 1903926960 6012672 4485744
17:11:16 13002 8192000000 10819159216 11245539328 1900888224 18.833 100 26 52 2 1914315888 5614000 7813664
17:11:36 6211 8192000000 10812369184 11245735936 1903129424 18.851 100 22 44 1 1915979776 6864832 5985520
17:11:51 9287 8192000000 10810214736 11242405888 1902715936 18.848 100 19 37 1 1913978752 5574208 5688608
17:12:09 9093 8192000000 10832840512 11255140352 1906739184 18.880 100 34 69 1 1923333056 6066864 10527008
17:12:26 40289 8192000000 10830802864 11258036224 1907612848 18.887 100 33 66 1 1922562736 5279072 9670816
17:13:38 5399 8192000000 10834594464 11264159744 1913546896 18.935 100 55 110 0 1938410384 9545760 15317728
17:13:50 6193 8192000000 10823974176 11259166720 1910266496 18.909 100 24 48 2 1923896048 7199488 6430064
17:14:02 4402 8192000000 10822258848 11259813888 1909894416 18.906 100 22 43 0 1922451616 6301088 6256112
17:14:14 6244 8192000000 10833199552 11267010560 1915261216 18.949 100 29 57 6 1930089504 6842208 7986080
17:14:26 4736 8192000000 10827177920 11265605632 1916338144 18.957 100 34 66 1 1933688928 7520720 9830064
17:14:40 3392 8192000000 10846211312 11271159808 1921104080 18.996 100 39 78 3 1938589120 6606672 10878368
17:14:55 6615 8192000000 10831049792 11265798144 1915845744 18.954 100 31 63 2 1931002048 5897120 9259184
17:15:10 8172 8192000000 10823807296 11262205952 1899862992 18.825 99 24 48 2 1912717232 5946176 6908064
17:15:24 7931 8192000000 10824176448 11265683456 1914092000 18.939 100 19 38 3 1925290976 5895664 5303312
17:15:40 8397 8192000000 10828519376 11266281472 1916447824 18.958 100 25 50 1 1929835408 6304544 7083040
17:15:55 7499 8192000000 10833508976 11268317184 1916507152 18.959 100 14 28 1 1925777472 5445760 3824560
17:16:14 6750 8192000000 10832158320 11270664192 1919132768 18.980 100 15 30 2 1928863280 5576640 4153872
17:16:29 9303 8192000000 10830827936 11267907584 1914042704 18.939 100 13 26 1 1922929088 5899664 2986720
17:16:48 61218 8192000000 10780740448 11208646656 1758593264 17.673 92 33 65 0 1773215904 5377712 9244928
17:17:56 7741 8192000000 10763304512 11191222272 1784171776 17.884 95 26 52 1 1797374528 5744320 7458432
17:18:10 8727 8192000000 10757632720 11178033152 1768028800 17.751 95 31 61 2 1782497264 5723984 8744480
17:18:28 5712 8192000000 10754339568 11184050176 1829880064 18.258 99 24 48 0 1843406656 6586544 6940048
17:18:41 6538 8192000000 10736297584 11157147648 1787098032 17.908 98 28 56 0 1800687392 5309472 8279888
17:18:53 5006 8192000000 10721384224 11134607360 1750722176 17.608 96 37 74 1 1767857488 5735248 11400064
17:19:05 9593 8192000000 10727400272 11150548992 1801264144 18.024 99 23 46 0 1814097712 6094320 6739248
17:19:21 6010 8192000000 10712260832 11129925632 1790252608 17.934 99 34 68 2 1807399824 7194112 9953104
17:19:34 7409 8192000000 10713766336 11126808576 1774378528 17.803 98 21 42 2 1785807392 5681600 5747264
17:19:47 11901 8192000000 10697573888 11112484864 1727749056 17.417 96 22 44 1 1739338656 5602896 5986704
17:20:08 6829 8192000000 10685844624 11100676096 1728670096 17.424 97 28 56 1 1743241456 5935648 8635712
17:20:23 7304 8192000000 10693578640 11111063552 1740531456 17.523 97 34 69 1 1760471632 10231696 9708480
17:20:37 5525 8192000000 10702202384 11096375296 1753178160 17.628 98 39 78 1 1770135136 4813072 12143904
17:20:49 11928 8192000000 10692382816 11107684352 1761209088 17.694 99 26 52 0 1774195904 5289504 7697312
17:21:15 65949 8192000000 10705014400 11123372032 1748961744 17.593 97 42 84 1 1767181888 5701952 12518192
17:22:29 10252 8192000000 10716886224 11132489728 1781738288 17.864 99 26 52 1 1795140752 6200624 7201840
17:22:46 5121 8192000000 10739168256 11152281600 1814311952 18.131 100 44 89 1 1835693744 8522432 12859360
17:23:00 9190 8192000000 10739918848 11157303296 1814621264 18.134 100 22 44 0 1826525040 5709344 6194432
17:23:16 6910 8192000000 10740634992 11163717632 1823967536 18.210 100 34 68 1 1839380720 6176496 9236688
17:23:29 7486 8192000000 10748756320 11176792064 1831204480 18.269 100 21 43 1 1842649504 5282448 6162576
17:23:42 5925 8192000000 10745325360 11174121472 1836169664 18.310 100 23 46 1 1849188160 6634624 6383872
17:23:54 8533 8192000000 10757766176 11181981696 1838565088 18.329 100 17 34 2 1852553952 9798304 4190560
17:24:15 7192 8192000000 10754597616 11186286592 1846337376 18.392 100 17 34 2 1856472624 5629120 4506128
17:24:30 7508 8192000000 10769513120 11189018624 1846641712 18.395 100 21 42 2 1858680112 6190992 5847408
17:24:48 14001 8192000000 10766667072 11190484992 1850686432 18.428 100 23 46 0 1862853264 5230240 6936592
17:25:09 12392 8192000000 10777859408 11198509056 1853579968 18.451 100 23 43 3 1869782960 9825952 6377040
17:25:31 7669 8192000000 10771007872 11201953792 1859214464 18.497 100 18 35 2 1868938960 5339040 4385456
17:25:46 14617 8192000000 10779530784 11203170304 1861503456 18.515 100 18 36 1 1872279488 5296112 5479920
17:26:07 91277 8192000000 10799644832 11219623936 1870232656 18.586 100 23 47 0 1882249904 4869424 7147824
17:27:50 11596 8192000000 10841850080 11248914432 1901681312 18.840 100 61 120 1 1925735488 7999952 16054224
17:28:09 10369 8192000000 10841652992 11256406016 1908799040 18.897 100 61 121 4 1934878032 10053136 16025856
17:28:27 23883 8192000000 10840236704 11263139840 1911249184 18.917 100 53 106 0 1935329408 9591728 14488496
17:29:05 17585 8192000000 10854492352 11275661312 1920390944 18.990 100 49 98 2 1946008144 11887664 13729536
17:29:30 26084 8192000000 10862372192 11287355392 1929627408 19.064 100 53 105 2 1957770512 13477200 14665904
17:30:11 19838 8192000000 10876035600 11297505280 1934485424 19.103 100 35 70 1 1956438896 11730336 10223136
17:30:38 21500 8192000000 10878677264 11307757568 1940236000 19.149 100 39 78 0 1967384096 15794688 11353408
17:31:19 7824 8192000000 10900376096 11318685696 1952822080 19.249 100 52 104 1 1986250816 17148832 16279904
17:31:35 11180 8192000000 10897160864 11323564032 1956140112 19.275 100 54 108 0 1991938000 19567936 16229952
17:32:01 27836 8192000000 10893297872 11325902848 1956359584 19.277 100 37 74 1 1985604720 17831728 11413408
17:32:41 5235 8192000000 10908179712 11332182016 1964007728 19.338 100 58 115 1 1997352832 16677296 16667808
17:32:59 10865 8192000000 10926480016 11347099648 1971541376 19.398 100 64 127 0 2008118560 18244832 18332352
17:33:17 10329 8192000000 10919396432 11349135360 1973063136 19.410 100 56 112 1 2011141792 22263632 15815024
17:33:34 6521 8192000000 10929105760 11354198016 1977001520 19.441 100 66 132 0 2019748928 23245088 19502320
17:33:49 10564 8192000000 10930143872 11356155904 1978585536 19.453 100 57 114 1 2018498928 23484736 16428656
17:34:18 3837 8192000000 10932466928 11360067584 1985931248 19.512 100 56 110 1 2025656576 23396848 16328480
17:34:30 15692 8192000000 10946041744 11369947136 1990032384 19.544 100 65 129 0 2035329472 26472016 18825072
17:34:55 2583 8192000000 10954499040 11372589056 1994288640 19.578 100 66 131 0 2041070608 27019520 19762448
17:35:06 5124 8192000000 10953181920 11370958848 1991321808 19.554 100 68 137 0 2038754112 27583632 19848672
17:35:19 5403 8192000000 10934418768 11352207360 1964345920 19.341 99 71 140 2 2013782688 28292128 21144640
17:35:33 4264 8192000000 10948571712 11369148416 1985094960 19.505 100 66 132 0 2032275056 28509200 18670896
17:35:44 5524 8192000000 10941850688 11364900864 1984457424 19.500 100 66 129 1 2032404000 28868128 19078448
17:36:00 8154 8192000000 10936700928 11366703104 1985087168 19.505 100 59 119 0 2031678608 28741264 17850176
17:36:16 18017 8192000000 10944560272 11374940160 1983554320 19.493 100 52 105 1 2028373312 29342144 15476848
17:36:49 8266 8192000000 10961630608 11390070784 1996697648 19.597 100 66 130 0 2050405696 33370192 20337856
17:37:08 21227 8192000000 10966155920 11400998912 2001209184 19.632 100 58 116 0 2056064512 37053744 17801584
17:37:38 10101 8192000000 10965684336 11403370496 2008584384 19.690 100 49 98 2 2056258192 32107008 15566800
17:37:56 10591 8192000000 10966956192 11401334784 2003125840 19.647 100 48 96 1 2055388464 36979936 15282688
17:38:14 5697 8192000000 10960749568 11393400832 2001136224 19.632 100 56 112 1 2055283664 35659488 18487952
17:38:27 4968 8192000000 10983154032 11405795328 2007744752 19.684 100 74 147 0 2066160112 36754688 21660672
17:38:40 4899 8192000000 10975082688 11412824064 2011970304 19.717 100 66 133 0 2069918960 36898592 21050064
17:38:58 4236 8192000000 10943106976 11363291136 1958278752 19.292 97 60 118 1 2009501968 33632560 17590656
17:39:14 2696 8192000000 10971371136 11399200768 2002483344 19.642 100 57 112 0 2053996192 34632672 16880176
17:39:23 1622 8192000000 10990671216 11409539072 2012454768 19.721 100 77 152 2 2072069280 35404224 24210288
17:39:34 6673 8192000000 10968992288 11400368128 1990521296 19.548 99 62 124 1 2046191664 36314192 19356176
17:39:50 5700 8192000000 10964593424 11396579328 1983709840 19.494 99 59 118 2 2039023232 37213312 18100080
17:40:03 5846 8192000000 10962568640 11392401408 1991094048 19.552 100 59 118 2 2046011840 36463184 18454608
17:40:17 5507 8192000000 10975130480 11402911744 2002710016 19.644 100 70 141 0 2063195440 38275088 22210336
17:40:33 1437 8192000000 10983288304 11404681216 2001291280 19.633 100 83 158 1 2065974448 40170368 24512800
17:40:49 9102 8192000000 10993771968 11413889024 1984719888 19.502 99 80 159 2 2053401088 44035568 24645632
17:41:10 4065 8192000000 10976043984 11403059200 2003320368 19.649 100 66 130 2 2064435920 40789824 20325728
17:41:21 3621 8192000000 10996186672 11413864448 2010695712 19.707 100 78 156 0 2077271488 41731104 24844672
17:41:33 4282 8192000000 10990069744 11406659584 2003766624 19.652 100 86 174 1 2072864448 42394368 26703456
17:41:47 4384 8192000000 10968754768 11390349312 1984878208 19.503 99 70 138 1 2050101648 43399968 21823472
17:41:59 8438 8192000000 10976430416 11400540160 1981272304 19.475 99 65 130 2 2047554448 44583264 21698880
17:42:17 11250 8192000000 10983791568 11413970944 2007925488 19.685 100 69 138 3 2077018160 46921728 22170944
17:42:39 11235 8192000000 10975796672 11408379904 1987631168 19.525 99 57 112 2 2049726848 44113584 17982096
17:42:58 12303 8192000000 10944505936 11373228032 1949889104 19.226 98 60 120 3 2015985888 47094288 19002496
17:43:20 10101 8192000000 10977995632 11401957376 1986895664 19.519 100 72 145 3 2062599424 52439104 23264656
17:43:40 2847 8192000000 10983612864 11409567744 1998995344 19.615 100 76 150 1 2070996848 48172848 23828656
17:43:51 3382 8192000000 10955492992 11370893312 1961486304 19.318 98 81 162 1 2036833680 49774064 25573312
17:44:03 2621 8192000000 10983085696 11397222400 1983025152 19.489 99 86 173 2 2062345040 51644304 27675584
17:44:15 4132 8192000000 11000959568 11415891968 2002273312 19.641 100 82 164 3 2076180000 48549840 25356848
17:44:25 10655 8192000000 11005425744 11425566720 2008829248 19.692 100 80 160 0 2084834464 51095952 24909264
17:44:43 3824 8192000000 11002656608 11422507008 2003758016 19.652 100 77 152 0 2081361088 53401088 24201984
17:44:54 2006 8192000000 11014500192 11433435136 2012131296 19.718 100 80 159 0 2092620496 55046112 25443088
17:45:03 2464 8192000000 11020102960 11440156672 2016779760 19.755 100 85 170 0 2100663776 56859808 27024208
17:45:13 2941 8192000000 11005793088 11429400576 1994909552 19.583 99 81 160 1 2076418928 55608496 25900880
17:45:23 2749 8192000000 11012187216 11431251968 2008427712 19.689 100 88 176 0 2092605840 54853216 29324912
17:45:32 2203 8192000000 11001687168 11421179904 2004362576 19.657 100 87 172 2 2083951664 51926000 27663088
17:45:43 4441 8192000000 10998847888 11420684288 2006619776 19.675 100 84 169 2 2082108640 48826288 26662576
17:45:58 3217 8192000000 11008237328 11426787328 2007556992 19.682 100 80 161 0 2078182688 44983856 25641840
17:46:07 3122 8192000000 10997154880 11418284032 2006772480 19.676 100 88 175 0 2080844400 46865584 27206336
17:46:17 3362 8192000000 10983614336 11412979712 1999534944 19.619 100 60 117 0 2062301008 44396992 18369072
17:46:31 11114 8192000000 10973284416 11420876800 2002315360 19.641 100 46 91 1 2062743824 45746864 14681600
17:46:49 22707 8192000000 10938220768 11387449344 1921360176 18.998 96 34 68 0 1977530368 43945792 12224400
17:47:28 13796 8192000000 10954924976 11391688704 1971856880 19.400 100 41 80 1 2031123712 45518128 13748704
17:47:55 11907 8192000000 10946569856 11394752512 1967727040 19.367 99 46 91 0 2028209184 44683168 15798976
17:48:14 12399 8192000000 10929678976 11371646976 1919455200 18.982 97 38 76 1 1976060480 42661424 13943856
17:48:35 16240 8192000000 10922302176 11371868160 1934604032 19.104 99 29 55 0 1990660048 45327008 10729008
17:49:19 18110 8192000000 10911189280 11359965184 1922161920 19.004 98 40 80 0 1974118912 38664128 13292864
17:49:44 13943 8192000000 10896062496 11343470592 1925883472 19.034 99 30 59 1 1971817872 35106752 10827648
17:50:10 6185 8192000000 10911448544 11349168128 1943149984 19.172 100 52 104 1 1999247312 39459392 16637936
17:50:24 9082 8192000000 10906637488 11351777280 1943674800 19.176 100 41 82 1 1996796528 39750208 13371520
17:50:49 38569 8192000000 10862974240 11329486848 1854796816 18.461 95 18 36 0 1903908176 42606656 6504704
17:51:42 16054 8192000000 10883767072 11334258688 1923240240 19.013 100 16 32 1 1959638256 30605168 5792848
17:52:24 34045 8192000000 10820381232 11280855040 1813014336 18.121 95 18 36 0 1854565648 35453200 6098112
17:53:11 27577 8192000000 10829790496 11276005376 1860040960 18.504 99 13 26 0 1891315248 26613664 4660624
17:53:45 19863 8192000000 10824612160 11269017600 1851185792 18.432 98 31 62 1 1880845504 20206336 9453376
17:54:12 14247 8192000000 10820450752 11279638528 1878035296 18.649 100 9 18 0 1904566720 23312496 3218928
17:54:32 36086 8192000000 10832223600 11273310208 1866202688 18.554 99 22 43 1 1888462000 16306112 5953200
17:55:24 66270 8192000000 10826089760 11263877120 1853092704 18.447 98 29 57 1 1868475024 7157808 8224512
17:56:37 45846 8192000000 10808806992 11262427136 1861516816 18.516 98 39 79 1 1881900240 9138448 11244976
17:57:29 83901 8192000000 10810918720 11264245760 1871235136 18.594 99 16 31 1 1881819552 7450336 3134080
17:59:00 16395 8192000000 10841376064 11276849152 1878837376 18.656 98 50 102 1 1898112016 5914080 13360560
17:59:30 81490 8192000000 10845338928 11300548608 1882530144 18.686 98 9 18 0 1893748800 8937088 2281568
18:00:59 73621 8192000000 10844895584 11295715328 1868130240 18.569 97 16 32 1 1883704192 11258304 4315648
18:02:28 72786 8192000000 10837695584 11302477824 1889130736 18.739 99 8 15 0 1906544320 15039536 2374048
18:03:48 104396 8192000000 10846029360 11298304000 1889346400 18.741 98 36 72 2 1911427456 12016224 10064832
18:05:38 112995 8192000000 10855871040 11319009280 1918870768 18.978 99 22 44 2 1939330064 14635408 5823888
18:07:38 34661 8192000000 10866925744 11328385024 1938552864 19.135 100 16 32 0 1955378240 12670864 4154512
18:08:20 4417 8192000000 10886047936 11334881280 1947323568 19.205 100 26 52 1 1966547648 11652032 7572048
18:08:34 21735 8192000000 10911210672 11343921152 1961299728 19.316 100 60 119 2 1988174592 9681600 17193264
18:09:05 41606 8192000000 10902249328 11351396352 1962713712 19.328 100 34 68 2 1988362800 16029280 9619808
18:10:04 31463 8192000000 10885885072 11351478272 1963577920 19.334 100 26 52 1 1983256752 11237328 8441504
18:10:42 58210 8192000000 10892787408 11364458496 1967054640 19.362 100 15 30 2 1986638608 15006432 4577536
18:11:56 55510 8192000000 10893285760 11368579072 1975822528 19.432 100 15 30 1 1996211504 16063872 4325104
18:12:58 65564 8192000000 10890479264 11374088192 1974764368 19.423 100 13 27 0 1989830384 11150880 3915136
18:14:15 60610 8192000000 10894149392 11371638784 1959226416 19.300 99 7 14 0 1971483008 10531952 1724640
18:15:22 30759 8192000000 10923435168 11369693184 1984939664 19.504 100 30 57 0 1999544752 6309952 8295136
18:16:02 29605 8192000000 10900925488 11377958912 1991145296 19.553 100 42 84 1 2010955376 7145728 12664352
18:16:38 41781 8192000000 10910950976 11385229312 1994269472 19.578 100 17 34 7 2006172256 7400096 4502688
18:17:33 28327 8192000000 10915377136 11391275008 1991948384 19.559 100 20 40 1 2007398768 9901888 5548496
18:18:11 55646 8192000000 10918961440 11395465216 1976866512 19.440 99 22 43 1 1993715536 10820640 6028384
18:19:13 82365 8192000000 10912028080 11387269120 1954404992 19.262 98 8 16 0 1972988896 15748672 2835232
18:20:42 59444 8192000000 10933356848 11411562496 1980178480 19.466 99 13 26 0 2005539344 20710128 4650736
18:22:38 84897 8192000000 10944229728 11417165824 2003953088 19.654 100 13 26 0 2025390288 17530064 3907136
18:24:17 25389 8192000000 10963896880 11423428608 2016066192 19.749 100 32 64 2 2041550016 16609040 8874784
18:24:56 54015 8192000000 10941279872 11417296896 1975565664 19.430 98 32 64 1 2002793280 18165520 9062096
18:26:01 77315 8192000000 10924570960 11399098368 1977259440 19.443 99 6 12 0 1993668256 14889024 1519792
18:27:26 14130 8192000000 10954066128 11409620992 1993377792 19.570 99 40 78 0 2015366688 11238176 10750720
18:27:46 9485 8192000000 10956404944 11410087936 2015746496 19.747 100 49 94 2 2037844400 8147760 13950144
18:28:02 110414 8192000000 10918816784 11374419968 1930494704 19.071 96 21 42 0 1945210336 9189136 5526496
18:29:59 58045 8192000000 10914357712 11374624768 1951695280 19.240 98 27 55 2 1967475120 8272288 7507552
18:31:08 50631 8192000000 10865775136 11341451264 1938881952 19.138 98 20 40 1 1957898048 13382256 5633840
18:32:04 61568 8192000000 10880431616 11364323328 1964719840 19.344 100 10 20 0 1978611024 11206064 2685120
18:33:12 8333 8192000000 10885839232 11366514688 1963563600 19.334 100 8 16 0 1978856480 13199872 2093008
18:33:27 12623 8192000000 10879942480 11359748096 1921401104 18.998 98 7 14 0 1932980896 9712816 1866976
18:33:45 35107 8192000000 10877946992 11349553152 1886578032 18.718 96 8 14 2 1898930320 10480240 1872048
18:34:27 32833 8192000000 10893896912 11361304576 1965211104 19.347 100 20 40 1 1978992896 7583648 6198144
18:35:12 48811 8192000000 10894508688 11366354944 1931724656 19.081 98 16 30 1 1944311440 8007360 4579424
18:36:31 48906 8192000000 10885462832 11345989632 1917020768 18.963 97 20 40 0 1929940448 6983552 5936128
18:37:39 47679 8192000000 10895518864 11359621120 1931993376 19.083 98 27 54 0 1948640992 8429024 8218592
18:38:44 51961 8192000000 10882368816 11335303168 1909128640 18.900 97 37 75 2 1930236080 10020864 11086576
18:39:45 42368 8192000000 10877204992 11339001856 1904545168 18.863 97 24 47 0 1923853392 12454192 6854032
18:40:46 99483 8192000000 10867025296 11341389824 1877329504 18.644 96 17 34 0 1895143312 13416816 4396992
18:42:32 99976 8192000000 10868862240 11339132928 1814083280 18.129 93 10 20 0 1835153072 18144288 2925504
18:44:19 133620 8192000000 10870955984 11340324864 1817978064 18.161 94 10 18 0 1841105888 21007120 2120704
18:46:39 104451 8192000000 10867747392 11311222784 1856872688 18.478 96 27 54 1 1879542128 15348400 7321040
18:48:38 82513 8192000000 10813283808 11258724352 1776299664 17.819 92 31 63 0 1791929840 6361088 9269088
18:50:08 25410 8192000000 10807621776 11260506112 1858191216 18.489 98 40 81 1 1879554592 10062288 11301088
18:50:42 29267 8192000000 10809487024 11274686464 1854548448 18.459 98 19 36 2 1867189552 7706384 4934720
18:51:18 28859 8192000000 10781657520 11244236800 1821837600 18.193 96 23 46 0 1836064096 7053136 7173360
18:52:14 78230 8192000000 10820919920 11291017216 1865584928 18.549 98 14 28 0 1883552320 13557520 4409872
18:53:38 71403 8192000000 10812462384 11286745088 1889322608 18.740 99 14 28 1 1908236640 14795264 4118768
18:55:39 98169 8192000000 10832641776 11317010432 1884540032 18.702 98 14 28 1 1902365680 13053696 4771952
18:57:26 43209 8192000000 10862723088 11325460480 1917093008 18.964 99 16 32 0 1933908368 12359040 4456320
18:58:15 59107 8192000000 10865339504 11340734464 1924002688 19.019 99 24 48 1 1948823104 17736384 7084032
18:59:29 79123 8192000000 10876229856 11344781312 1932041792 19.083 99 14 28 0 1944604096 8817328 3744976
19:00:56 48124 8192000000 10904315008 11357241344 1924658016 19.024 98 15 30 1 1940272048 11702464 3911568
19:01:57 81526 8192000000 10878164256 11350212608 1924704160 19.025 98 13 26 0 1941493904 12898880 3890864
19:03:25 28030 8192000000 10933371600 11370758144 1970063392 19.386 100 48 94 0 1992562016 9046016 13452608
19:04:00 26858 8192000000 10915372576 11381477376 1981870688 19.480 100 51 100 0 2009288080 12620784 14796608
19:05:19 63559 8192000000 10929119840 11388596224 1963382720 19.333 99 16 32 0 1980634400 12764800 4486880
19:06:31 88450 8192000000 10934843408 11415384064 1991514864 19.556 100 18 36 2 2011891216 15365328 5011024
19:08:07 89937 8192000000 10921952112 11410497536 1984331696 19.499 99 21 42 0 2004849552 14524608 5993248
19:09:44 68301 8192000000 10953372464 11417239552 2004741328 19.660 100 21 41 0 2025640128 15419184 5479616
19:11:01 86426 8192000000 10942907888 11437993984 2011646720 19.714 100 24 48 0 2038695440 20546464 6502256
19:12:53 52193 8192000000 10932197904 11414482944 2011944928 19.717 100 13 26 2 2028067872 12720352 3402592
19:14:31 26590 8192000000 10919239808 11405262848 1988845776 19.535 99 26 51 0 2003785568 7623440 7316352
19:15:05 41953 8192000000 10920678928 11413778432 2007624160 19.683 100 15 30 0 2022153648 10251136 4278352
19:15:53 39208 8192000000 10931893648 11417305088 2016150560 19.750 100 12 24 1 2027421856 8117040 3154256
19:16:39 49918 8192000000 10918001328 11397554176 1953904176 19.258 97 6 12 0 1962809984 7348192 1557616
19:17:38 56936 8192000000 10916281712 11391913984 1959350224 19.301 98 9 18 0 1969250368 7302624 2597520
19:18:46 80022 8192000000 10885946256 11357958144 1918277040 18.973 96 24 48 2 1936667984 11348544 7042400
19:20:23 68621 8192000000 10891081360 11362668544 1934923568 19.106 97 22 45 0 1952082176 11063696 6094912
19:21:52 72294 8192000000 10916187808 11392974848 1937406704 19.126 98 24 47 0 1960564048 15922544 7234800
19:23:30 77362 8192000000 10912816624 11384389632 1947627488 19.208 98 20 40 0 1961965856 8775328 5563040
19:24:58 33020 8192000000 10910839648 11378909184 1979607824 19.462 100 34 68 1 1999696432 10977600 9111008
19:25:41 50991 8192000000 10908745968 11374710784 1947369360 19.206 98 28 56 1 1970238272 15162160 7706752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-11-2020 19:28:42 to 05-11-2020 19:29:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 130 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 05-11-2020 19:29:14 to 05-11-2020 19:29:16.

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          228152
MON$OLDEST_ACTIVE               230881
MON$OLDEST_SNAPSHOT             230881
MON$NEXT_TRANSACTION            230881
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                       2014272
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.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:59: 
:60: mscs-test-161.budzdorov.ru    Thu Nov  5 19:27:16 2020
:61:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:62: 
:63: 
:64: mscs-test-161.budzdorov.ru    Thu Nov  5 19:27:24 2020
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:66: 
--- end of diff output ---

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

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