Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.12.2020 22:27
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 17532716 kB
MemAvailable 31480840 kB
Buffers 0 kB
Cached 14135848 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-18 22:27:08
DTS_END                         2020-12-18 22:27:08.0530
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/57390
TRN_ID                          248422
ATT_ID                          708
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: 9617.05 19176 1154046
customer order: creation 177.63 340 21316
customer order: refuse 15.43 282 1852
order to supplier: creation 47.05 1194 5646
order to supplier: removal 3.62 76324 434
invoice (draft): creation 47.42 3002 5690
invoice (draft): removal 53.69 617 6443
invoice accept: apply 43.60 17667 5232
invoice accept: cancel 48.55 679 5826
customer reserve: creation 4084.76 174 490171
customer reserve: removal 4783.99 45 574079
realization accept: apply 86.02 165 10322
realization accept: cancel 90.74 90 10889
payment from customer: creation 61.53 105 7383
payment from customer: removal 5.68 82 682
payment to supplier: creation 50.78 103 6093
payment to supplier: removal 3.53 55 424
service: total inventory turnovers 4.87 898 584
service: total monetary turnovers 7.19 18 863
service: aggregate perf. data 0.94 15439 113
service: refresh index statistics 0.03 266239 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-12-2020 22:28:02 to 18-12-2020 22:28:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7952
TEST_TIME 2 5597
TEST_TIME 3 6840
TEST_TIME 4 6555
TEST_TIME 5 6639
TEST_TIME 6 6337
TEST_TIME 7 6222
TEST_TIME 8 6522
TEST_TIME 9 6826
TEST_TIME 10 6904
TEST_TIME 11 6782
TEST_TIME 12 7709
TEST_TIME 13 7860
TEST_TIME 14 8426
TEST_TIME 15 8841
TEST_TIME 16 8921
TEST_TIME 17 9436
TEST_TIME 18 9554
TEST_TIME 19 9947
TEST_TIME 20 10642
TEST_TIME 21 11169
TEST_TIME 22 11001
TEST_TIME 23 11186
TEST_TIME 24 10996
TEST_TIME 25 10868
TEST_TIME 26 11224
TEST_TIME 27 11169
TEST_TIME 28 10811
TEST_TIME 29 10814
TEST_TIME 30 10631
TEST_TIME 31 10685
TEST_TIME 32 10652
TEST_TIME 33 10496
TEST_TIME 34 10313
TEST_TIME 35 10257
TEST_TIME 36 10157
TEST_TIME 37 10069
TEST_TIME 38 10129
TEST_TIME 39 9994
TEST_TIME 40 10042
TEST_TIME 41 10103
TEST_TIME 42 10091
TEST_TIME 43 10096
TEST_TIME 44 10156
TEST_TIME 45 10156
TEST_TIME 46 10189
TEST_TIME 47 10252
TEST_TIME 48 10200
TEST_TIME 49 10136
TEST_TIME 50 10162
TEST_TIME 51 10330
TEST_TIME 52 10323
TEST_TIME 53 10195
TEST_TIME 54 10097
TEST_TIME 55 10092
TEST_TIME 56 10110
TEST_TIME 57 10054
TEST_TIME 58 9958
TEST_TIME 59 9884
TEST_TIME 60 9785
TEST_TIME 61 9830
TEST_TIME 62 9777
TEST_TIME 63 9759
TEST_TIME 64 9745
TEST_TIME 65 9928
TEST_TIME 66 9863
TEST_TIME 67 9893
TEST_TIME 68 9909
TEST_TIME 69 9906
TEST_TIME 70 9929
TEST_TIME 71 9910
TEST_TIME 72 9913
TEST_TIME 73 9997
TEST_TIME 74 9975
TEST_TIME 75 10064
TEST_TIME 76 10032
TEST_TIME 77 9935
TEST_TIME 78 9869
TEST_TIME 79 9875
TEST_TIME 80 9885
TEST_TIME 81 9812
TEST_TIME 82 9760
TEST_TIME 83 9726
TEST_TIME 84 9696
TEST_TIME 85 9686
TEST_TIME 86 9688
TEST_TIME 87 9642
TEST_TIME 88 9647
TEST_TIME 89 9698
TEST_TIME 90 9702
TEST_TIME 91 9745
TEST_TIME 92 9828
TEST_TIME 93 9876
TEST_TIME 94 9866
TEST_TIME 95 9822
TEST_TIME 96 9845
TEST_TIME 97 9955
TEST_TIME 98 9998
TEST_TIME 99 9938
TEST_TIME 100 9934
TEST_TIME 101 9878
TEST_TIME 102 9830
TEST_TIME 103 9817
TEST_TIME 104 9786
TEST_TIME 105 9762
TEST_TIME 106 9743
TEST_TIME 107 9713
TEST_TIME 108 9728
TEST_TIME 109 9680
TEST_TIME 110 9655
TEST_TIME 111 9673
TEST_TIME 112 9676
TEST_TIME 113 9636
TEST_TIME 114 9671
TEST_TIME 115 9700
TEST_TIME 116 9678
TEST_TIME 117 9695
TEST_TIME 118 9691
TEST_TIME 119 9699
TEST_TIME 120 9619

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-12-2020 22:28:05 to 18-12-2020 22:28:09.

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 1605576 1605576 0 0.00 0 17953 6 0 0
doc_list_biud 1605574 1605574 0 0.00 0 36347 21 0 0
sp_add_invoice_to_stock 5325 5232 93 1.74 36 196041 17668 0 93
sp_cancel_adding_invoice 5826 5826 0 0.00 5 41569 680 0 0
sp_cancel_client_order 1852 1852 0 0.00 4 10272 283 0 0
sp_cancel_customer_reserve 574079 574079 0 0.00 1 36934 46 0 0
sp_cancel_pay_from_customer 682 682 0 0.00 2 5776 82 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 2304 56 0 0
sp_cancel_supplier_invoice 6453 6443 10 0.15 1 25378 617 0 10
sp_cancel_supplier_order 434 434 0 0.00 5 764000 76325 0 0
sp_cancel_write_off 10889 10889 0 0.00 1 14351 91 0 0
sp_client_order 21316 21316 0 0.00 4 24189 340 0 0
sp_customer_reserve 490171 490171 0 0.00 0 63307 174 0 0
sp_fill_shopping_cart 32638 32638 0 0.00 1 14325 32 0 0
sp_fill_shopping_cart_clo_res 490161 490161 0 0.00 0 15746 13 0 0
sp_get_clo_for_invoice 5221 5221 0 0.00 0 24476 274 0 0
sp_kill_cost_storno 17821 17821 0 0.00 0 9598 39 0 0
sp_kill_qstorno_ret_qs2qd 1165924 1165924 0 0.00 0 36342 25 0 0
sp_kill_qty_storno 615063 615063 0 0.00 0 36346 54 0 0
sp_lock_selected_doc 21587 21587 0 0.00 0 9452 4 0 0
sp_make_cost_storno 29018 29018 0 0.00 0 11148 49 0 0
sp_multiply_rows_for_pdistr 29016 29016 0 0.00 0 6316 22 0 0
sp_multiply_rows_for_qdistr 21316 21316 0 0.00 0 11185 152 0 0
sp_pay_from_customer 7383 7383 0 0.00 4 13582 105 0 0
sp_pay_to_supplier 6093 6093 0 0.00 4 10517 103 0 0
sp_payment_common 13476 13476 0 0.00 1 7727 25 0 0
sp_qd_handle_on_cancel_clo 1852 1852 0 0.00 0 10262 252 0 0
sp_qd_handle_on_invoice_upd_sts 11044 11044 0 0.00 0 21183 269 0 0
sp_qd_handle_on_reserve_upd_sts 10322 10322 0 0.00 0 18755 49 0 0
sp_reserve_write_off 10322 10322 0 0.00 6 18803 165 0 0
sp_supplier_invoice 5690 5690 0 0.00 6 84049 3003 0 0
sp_supplier_order 5646 5646 0 0.00 5 36840 1195 0 0
srv_aggregate_perf_data 114 113 1 0.87 2982 143939 15440 0 1
srv_fill_mon_cache_memory 153 153 0 0.00 996 116672 35634 0 0
srv_find_qd_qs_mism 1103035 1103035 0 0.00 0 17952 6 0 0
srv_make_invnt_saldo 584 584 0 0.00 16 35465 899 0 0
srv_make_money_saldo 863 863 0 0.00 0 1207 18 0 0
srv_recalc_idx_stat 4 4 0 0.00 184479 372589 266239 0 0
t$perf-abend:sp_add_invoice_to_stock 93 93 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 5232 5232 0 0.00 0 10369 144 0 0
t$perf-norm:sp_cancel_adding_invoice 442 442 0 0.00 0 9364 114 0 0
t$perf-norm:sp_cancel_client_order 1852 1852 0 0.00 0 5128 15 0 0
t$perf-norm:sp_cancel_customer_reserve 735 735 0 0.00 0 2711 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 682 682 0 0.00 0 558 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 2508 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 2014 19 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 34042 1455 0 0
t$perf-norm:sp_cancel_write_off 1077 1077 0 0.00 0 948 5 0 0
t$perf-norm:sp_client_order 21316 21316 0 0.00 0 9141 15 0 0
t$perf-norm:sp_customer_reserve 992 992 0 0.00 0 4468 11 0 0
t$perf-norm:sp_pay_from_customer 7383 7383 0 0.00 0 5369 11 0 0
t$perf-norm:sp_pay_to_supplier 6093 6093 0 0.00 0 7950 10 0 0
t$perf-norm:sp_reserve_write_off 10322 10322 0 0.00 0 9128 10 0 0
t$perf-norm:sp_supplier_invoice 5690 5690 0 0.00 0 3445 15 0 0
t$perf-norm:sp_supplier_order 5646 5646 0 0.00 0 3383 12 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 187 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 1258 9 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 2496 14 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 2089 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10620 10434 186 1.75 0 9351 20 0 186
v_all_customers 39188 39188 0 0.00 0 42 0 0 0
v_all_suppliers 31436 31436 0 0.00 0 106 1 0 0
v_all_wares 42632 42632 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 884 884 0 0.00 0 887 7 0 0
v_cancel_client_order 3704 3704 0 0.00 0 5470 7 0 0
v_cancel_customer_prepayment 1364 1364 0 0.00 0 5739 16 0 0
v_cancel_customer_reserve 1470 1470 0 0.00 0 4696 10 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 2279 7 0 0
v_cancel_supplier_invoice 824 804 20 2.42 0 6598 28 0 20
v_cancel_supplier_order 868 868 0 0.00 0 2565 9 0 0
v_cancel_write_off 2154 2154 0 0.00 0 10497 24 0 0
v_max_id_clo_ord 5646 5646 0 0.00 0 3307 2 0 0
v_max_id_clo_res 992 992 0 0.00 0 1283 10 0 0
v_max_id_ord_sup 5676 5676 0 0.00 0 3184 4 0 0
v_max_non_paid_invoice 1697 1697 0 0.00 0 1090 3 0 0
v_max_non_paid_realizn 3827 3827 0 0.00 0 2756 4 0 0
v_min_id_clo_ord 5646 5646 0 0.00 0 1718 4 0 0
v_min_id_clo_res 992 992 0 0.00 0 8964 24 0 0
v_min_id_ord_sup 5676 5676 0 0.00 0 4754 8 0 0
v_min_non_paid_invoice 6093 6093 0 0.00 0 3407 13 0 0
v_min_non_paid_realizn 7383 7383 0 0.00 0 6652 17 0 0
v_our_firm 10556 10556 0 0.00 0 14 1 0 0
v_reserve_write_off 20644 20644 0 0.00 0 18396 9 0 0
x_lock_depdocs_on_canc_invoice 11867 11867 0 0.00 0 19833 112 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 14017 344 0 0
x_make_qstorno_1000_1200 5646 5646 0 0.00 1 36827 1133 0 0
x_make_qstorno_1200_2000 5690 5690 0 0.00 3 82765 2876 0 0
x_make_qstorno_2100_3300 490171 490171 0 0.00 0 63286 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-12-2020 22:28:10 to 18-12-2020 22:28:14.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:17 6470 8192000000 10033243488 10307743744 776873808 8.661 63 50 105 0 796262224 2094496 17293920
19:57:33 31568 8192000000 10338523264 10653528064 1368226272 14.311 100 89 178 0 1401610928 4347152 29037504
19:58:13 35105 8192000000 10403317328 10724294656 1444347200 14.988 100 94 188 1 1481507248 6943424 30216624
19:59:03 14499 8192000000 10407984448 10736046080 1466142080 15.180 100 89 177 0 1503185216 8594992 28448144
19:59:31 15258 8192000000 10419527296 10751627264 1479147680 15.294 100 92 184 1 1517735104 8859792 29727632
19:59:57 25537 8192000000 10449906944 10785001472 1497405936 15.454 100 84 168 0 1533729632 9533520 26790176
20:00:33 14875 8192000000 10464045808 10807967744 1520217104 15.652 100 82 164 3 1556232464 9851280 26164080
20:00:58 13659 8192000000 10492686592 10836860928 1539760352 15.822 100 77 154 0 1573542720 9957680 23824688
20:01:25 14340 8192000000 10524705312 10871357440 1573263920 16.110 100 83 166 0 1609288304 10534288 25490096
20:01:46 16309 8192000000 10526867008 10883526656 1586412176 16.223 100 81 162 3 1622173760 11176464 24585120
20:02:14 10633 8192000000 10552553024 10909515776 1615964720 16.476 100 82 166 0 1651976448 11202800 24808928
20:02:34 16418 8192000000 10590273456 10949091328 1637791888 16.661 100 80 160 2 1672493552 10786384 23915280
20:02:58 9050 8192000000 10602909232 10969952256 1667282144 16.910 100 81 162 2 1703582432 12601296 23698992
20:03:18 11946 8192000000 10626837200 10995089408 1686111184 17.069 100 78 156 1 1721249136 12811536 22326416
20:03:38 8832 8192000000 10639648208 11013521408 1703021136 17.210 100 73 143 4 1736045472 12411872 20612464
20:03:54 5374 8192000000 10656375936 11031961600 1721191072 17.362 100 76 152 2 1755231648 12352848 21687728
20:04:06 4900 8192000000 10678646192 11051683840 1731714192 17.450 100 83 164 1 1769435008 13417216 24303600
20:04:18 6117 8192000000 10675780448 11053580288 1741115824 17.528 100 77 151 0 1775470064 13025888 21328352
20:04:31 3927 8192000000 10688420480 11062697984 1749492880 17.597 100 82 164 0 1785998784 13468176 23037728
20:04:42 5145 8192000000 10696828352 11075567616 1758839280 17.675 100 81 161 1 1794697456 13648560 22209616
20:04:54 3791 8192000000 10714220256 11088879616 1774758832 17.806 100 85 167 1 1812815760 13583984 24472944
20:05:08 2879 8192000000 10722377328 11097591808 1780365568 17.852 100 89 180 3 1819548384 14211392 24971424
20:05:18 3368 8192000000 10726376224 11106775040 1784153728 17.884 100 87 174 0 1821970368 13806560 24010080
20:05:28 2347 8192000000 10733462320 11112095744 1792150160 17.949 100 87 174 0 1830875952 14657856 24067936
20:05:37 1444 8192000000 10737610864 11116470272 1796427024 17.985 100 87 175 0 1832639008 12539104 23672880
20:05:46 3038 8192000000 10747362304 11130306560 1806920224 18.071 100 84 165 3 1842473168 12845056 22707888
20:05:55 1583 8192000000 10761837904 11139039232 1813566528 18.125 100 96 193 0 1858601616 18607632 26427456
20:06:03 5884 8192000000 10751159648 11137351680 1811815712 18.111 100 75 150 4 1846021344 14026416 20179216
20:06:16 2321 8192000000 10764950528 11151552512 1818909472 18.169 100 87 174 1 1856454944 13112544 24432928
20:06:24 1973 8192000000 10779619120 11160371200 1836083840 18.309 100 88 176 1 1875390960 13525120 25782000
20:06:33 1433 8192000000 10775094992 11165777920 1837310896 18.319 100 83 166 0 1873546272 13400768 22834608
20:06:41 1778 8192000000 10788149184 11168555008 1842752880 18.363 100 86 170 1 1878867536 12043584 24071072
20:06:49 1370 8192000000 10787745312 11172544512 1850339584 18.425 100 88 177 7 1887490672 12276256 24874832
20:06:57 2163 8192000000 10798543552 11187974144 1850286272 18.424 100 91 182 3 1893617232 16651824 26679136
20:07:05 1347 8192000000 10798788848 11183939584 1856003040 18.471 100 92 186 2 1893203776 11802928 25397808
20:07:13 1630 8192000000 10794053920 11184062464 1855761168 18.469 100 91 183 1 1893132016 11208000 26162848
20:07:21 8235 8192000000 10796808416 11185827840 1854652544 18.460 100 74 149 1 1887852864 12008752 21191568
20:07:41 1074 8192000000 10808608304 11193155584 1860737744 18.509 100 91 183 2 1899603456 13725680 25140032
20:07:48 21223 8192000000 10766906832 11190407168 1856321408 18.473 100 45 90 2 1882394352 12673856 13399088
20:08:18 4466 8192000000 10774321152 11190054912 1861852432 18.518 100 41 82 1 1881225040 6973712 12398896
20:08:30 7320 8192000000 10769019696 11190362112 1858686576 18.493 100 34 67 1 1875569536 7572384 9310576
20:08:47 10950 8192000000 10779476144 11194941440 1862983536 18.527 100 27 55 0 1876546912 6241968 7321408
20:09:05 6447 8192000000 10767429968 11192934400 1861180624 18.513 100 22 45 0 1873156192 5717968 6257600
20:09:20 10361 8192000000 10785339024 11199705088 1864834496 18.542 100 16 33 2 1875492608 5674896 4983216
20:09:38 10739 8192000000 10780469888 11204046848 1871773072 18.599 100 27 53 1 1886293712 6541312 7979328
20:09:55 11458 8192000000 10781099792 11209035776 1876995728 18.641 100 29 58 2 1891714304 6429648 8288928
20:10:13 9103 8192000000 10788765024 11215646720 1876000272 18.633 100 19 38 1 1887377520 6162608 5214640
20:10:30 11339 8192000000 10797952448 11222265856 1886229008 18.715 100 23 44 3 1902561904 10473280 5859616
20:10:48 13973 8192000000 10799034784 11225956352 1883787120 18.696 100 13 26 0 1893048960 5640960 3620880
20:11:11 54010 8192000000 10817831120 11238293504 1893983872 18.778 100 36 73 2 1910481248 5266736 11230640
20:12:12 26704 8192000000 10802229040 11239538688 1895163040 18.787 100 35 71 4 1911399040 5947296 10288704
20:12:45 6036 8192000000 10810951584 11241521152 1895214544 18.788 100 34 68 1 1911415552 7153408 9047600
20:12:57 6560 8192000000 10810025536 11244855296 1896140032 18.795 100 31 62 2 1911818176 7230416 8447728
20:13:11 3987 8192000000 10822965136 11244818432 1896422096 18.798 100 25 50 0 1909250384 4862672 7965616
20:13:21 7053 8192000000 10820254032 11245408256 1900716064 18.832 100 37 74 1 1918400016 6579104 11104848
20:13:36 2784 8192000000 10822482320 11246788608 1899783568 18.825 100 43 86 2 1919617312 7275680 12558064
20:13:49 4164 8192000000 10819882160 11245588480 1879237152 18.659 99 32 62 2 1898248192 10523424 8487616
20:13:59 9423 8192000000 10807940352 11244044288 1895636608 18.791 100 12 24 0 1904533920 5340000 3557312
20:14:18 8178 8192000000 10810430880 11242708992 1893721664 18.776 100 22 44 1 1906316192 6318400 6276128
20:14:36 7879 8192000000 10819006784 11248349184 1897184816 18.804 100 18 37 1 1908020944 5478352 5357776
20:14:50 11648 8192000000 10805653792 11245056000 1898171184 18.812 100 19 37 1 1908589696 5315440 5103072
20:15:09 21806 8192000000 10792845744 11228209152 1857876912 18.486 98 15 30 2 1867632080 5926288 3828880
20:15:37 10704 8192000000 10785360752 11213754368 1850872800 18.429 98 21 42 3 1863048048 5567712 6607536
20:15:53 10898 8192000000 10786210800 11212341248 1838319520 18.327 98 11 22 0 1847203680 5449984 3434176
20:16:10 55969 8192000000 10776677040 11201662976 1830520768 18.264 97 23 46 0 1842848688 5038080 7289840
20:17:18 19772 8192000000 10756108848 11186360320 1762018272 17.701 94 15 30 0 1771346032 5281344 4046416
20:17:43 4918 8192000000 10728015776 11153940480 1789164448 17.925 97 25 49 1 1806191392 9617984 7408960
20:17:55 8025 8192000000 10703908832 11113172992 1665652448 16.897 91 29 57 1 1679306192 5466816 8186928
20:18:09 5842 8192000000 10730247952 11150364672 1806095136 18.064 100 21 42 0 1818432160 6507488 5829536
20:18:22 3625 8192000000 10712209248 11137769472 1767541920 17.747 97 23 47 0 1779856896 5292304 7022672
20:18:33 5488 8192000000 10743145104 11158331392 1801741104 18.028 99 32 64 3 1816495856 5493264 9261488
20:18:45 8687 8192000000 10726838256 11149221888 1779591584 17.846 98 21 42 1 1791451152 5256176 6603392
20:19:01 6560 8192000000 10685406912 11094515712 1670865520 16.940 92 23 46 1 1686459152 9049296 6544336
20:19:14 6449 8192000000 10687021568 11101503488 1685161824 17.061 94 22 44 1 1696389536 4980992 6246720
20:19:29 5833 8192000000 10697465024 11112751104 1754704864 17.641 98 35 70 2 1775679712 10868016 10106832
20:19:45 4008 8192000000 10688574032 11098099712 1769499520 17.763 100 17 35 0 1779834432 5631760 4703152
20:19:57 10654 8192000000 10697578144 11119546368 1758171264 17.669 98 17 34 2 1768376640 5626752 4578624
20:20:15 9408 8192000000 10704546688 11114913792 1779036160 17.842 99 31 61 2 1794151056 5693376 9421520
20:20:32 10270 8192000000 10720975632 11135045632 1775296432 17.811 98 26 52 0 1788867872 5355392 8216048
20:20:52 14459 8192000000 10740241424 11161448448 1823126256 18.203 100 20 38 2 1833928832 5547776 5254800
20:21:15 59064 8192000000 10770023360 11177758720 1836106480 18.309 100 37 74 0 1853022192 5986832 10928880
20:22:20 11054 8192000000 10736044192 11169226752 1824437040 18.214 100 17 34 0 1838843472 10416016 3990416
20:22:40 11244 8192000000 10757566176 11183972352 1844299376 18.376 100 21 41 1 1855507184 5010656 6197152
20:23:00 9272 8192000000 10765322736 11193192448 1853679600 18.452 100 27 54 1 1867484368 5604080 8200688
20:23:15 6907 8192000000 10765373520 11193102336 1857236640 18.481 100 26 51 3 1870633056 5778256 7618160
20:23:29 7646 8192000000 10768269264 11196678144 1857691200 18.485 100 30 60 0 1871725312 5219536 8814576
20:23:43 12109 8192000000 10784002096 11207544832 1864019440 18.536 100 21 42 0 1876919328 6140448 6759440
20:24:02 9302 8192000000 10773545792 11204780032 1864451072 18.539 100 17 34 3 1875261536 5439872 5370592
20:24:17 10640 8192000000 10771433088 11206160384 1863648368 18.533 100 12 24 0 1872328576 5419120 3261088
20:24:34 9917 8192000000 10775829856 11210153984 1865603360 18.549 100 22 44 1 1877919312 5921552 6394400
20:24:54 11819 8192000000 10773600272 11211567104 1865578160 18.548 100 14 28 1 1874958368 5357648 4022560
20:25:12 6624 8192000000 10780220992 11215884288 1874597696 18.621 100 38 77 0 1895394032 9546192 11250144
20:25:26 10874 8192000000 10780372176 11214860288 1869613232 18.581 100 13 25 2 1879191504 5810496 3767776
20:25:45 6774 8192000000 10783844016 11214680064 1871263600 18.594 100 23 44 0 1882791184 5211984 6315600
20:26:00 13794 8192000000 10784807680 11213312000 1869939264 18.584 100 7 14 0 1876877648 5023840 1914544
20:26:20 83974 8192000000 10819228144 11246825472 1891347696 18.757 100 37 72 5 1907514432 5624448 10542288
20:27:56 12393 8192000000 10844676912 11262078976 1914156592 18.940 100 52 102 1 1935501456 7091312 14253552
20:28:23 11947 8192000000 10851449040 11276890112 1925259712 19.029 100 49 98 0 1949946576 9836432 14850432
20:28:51 7182 8192000000 10872347152 11292499968 1933762608 19.097 100 56 112 0 1959403216 10262208 15378400
20:29:26 26538 8192000000 10868596160 11294437376 1936583904 19.119 100 45 90 1 1959472832 10319632 12569296
20:30:07 19323 8192000000 10869440352 11301888000 1943803376 19.177 100 40 80 1 1966108800 11002368 11303056
20:30:37 21741 8192000000 10870305584 11310026752 1947473344 19.206 100 31 62 0 1968753888 11958896 9321648
20:31:06 10506 8192000000 10875678656 11307974656 1947473936 19.206 100 46 92 4 1968570800 7955376 13141488
20:31:24 5925 8192000000 10878669952 11316359168 1955493200 19.270 100 42 85 0 1977391696 9178368 12720128
20:31:37 26207 8192000000 10894220448 11331973120 1962659872 19.327 100 44 84 1 1985151120 9942048 12549200
20:32:18 12000 8192000000 10891997056 11334627328 1968521296 19.374 100 38 75 1 1993467520 13377744 11568480
20:32:38 7476 8192000000 10903749968 11339722752 1973163024 19.411 100 45 90 1 1999146416 12373152 13610240
20:33:00 5017 8192000000 10921589840 11350269952 1982046240 19.481 100 60 120 0 2014683792 14333872 18303680
20:33:14 18960 8192000000 10903247440 11337629696 1945274688 19.189 98 48 95 2 1974498960 14798816 14425456
20:33:41 19356 8192000000 10917720592 11346374656 1976501216 19.437 100 44 88 0 2005093056 15286560 13305280
20:34:08 8600 8192000000 10919970832 11352977408 1981844992 19.479 100 52 104 2 2012942896 16530160 14567744
20:34:32 15675 8192000000 10919286976 11355922432 1983615040 19.493 100 48 96 3 2015068768 17212960 14240768
20:34:57 3004 8192000000 10918041360 11352555520 1977334480 19.444 100 47 94 0 2011488624 19633200 14520944
20:35:09 13688 8192000000 10927344048 11368116224 1988711424 19.534 100 53 103 2 2023205584 18621024 15873136
20:35:31 3189 8192000000 10948977536 11373228032 1994895840 19.582 100 68 137 2 2032617392 17662448 20059104
20:35:43 2721 8192000000 10950472880 11375144960 1992684192 19.565 100 61 122 1 2032472288 21175456 18612640
20:35:52 4090 8192000000 10951312384 11376672768 1997682752 19.604 100 64 128 0 2040506832 23011152 19812928
20:36:05 1804 8192000000 10968077008 11387465728 2005697360 19.668 100 84 168 3 2054526544 24055888 24773296
20:36:15 2935 8192000000 10975233920 11392258048 2007279936 19.680 100 81 162 0 2055979360 24691184 24008240
20:36:26 8068 8192000000 10968915216 11387760640 1989728320 19.542 99 74 145 4 2038628512 26605472 22294720
20:36:42 9636 8192000000 10955287584 11389968384 1987189264 19.522 99 61 122 3 2034836784 28447648 19199872
20:37:02 3705 8192000000 10958983552 11385237504 2001879904 19.638 100 68 136 2 2048794304 25378592 21535808
20:37:15 11929 8192000000 10934336736 11364241408 1961164240 19.315 98 46 92 2 1999868176 23718880 14985056
20:37:35 12564 8192000000 10953553568 11384041472 1996013520 19.591 100 50 101 1 2039019888 26175632 16830736
20:38:00 14926 8192000000 10929820112 11359117312 1951600960 19.239 98 54 107 0 1999304240 30347200 17356080
20:38:27 6650 8192000000 10942106080 11379286016 1983953968 19.496 100 45 90 3 2029491344 30441184 15096192
20:38:46 4155 8192000000 10914626496 11334770688 1932940688 19.090 97 63 125 0 1987796288 34194528 20661072
20:38:57 8108 8192000000 10936145072 11360841728 1965695344 19.351 100 57 114 2 2020856592 36385648 18775600
20:39:14 1920 8192000000 10926589536 11348635648 1943680096 19.176 99 71 142 0 2003343472 37277616 22385760
20:39:22 2939 8192000000 10945231792 11362365440 1970533376 19.390 100 77 153 0 2031335232 36982064 23819792
20:39:33 4338 8192000000 10951869328 11374886912 1981238960 19.475 100 66 132 1 2037173936 34498480 21436496
20:39:46 4257 8192000000 10929312064 11348844544 1944168112 19.180 98 66 130 0 1998363344 33963536 20231696
20:40:00 4451 8192000000 10938630960 11364610048 1979973632 19.464 100 63 124 0 2028227760 29496048 18758080
20:40:12 995 8192000000 10942707680 11357958144 1975391728 19.428 100 81 162 1 2029964592 30141408 24431456
20:40:21 3409 8192000000 10942744416 11364945920 1977846624 19.448 100 72 144 0 2029139792 30040432 21252736
20:40:31 1861 8192000000 10947216816 11360174080 1978544208 19.453 100 85 170 0 2034317136 30796768 24976160
20:40:40 2998 8192000000 10941988288 11348643840 1961205696 19.316 100 82 164 0 2020396208 34344336 24846176
20:40:50 1221 8192000000 10946276880 11358167040 1969929360 19.385 100 86 172 2 2031864000 35070544 26864096
20:40:58 1829 8192000000 10942037536 11352121344 1963004832 19.330 100 80 159 0 2023549088 36341792 24202464
20:41:07 1840 8192000000 10942128448 11352702976 1963371456 19.333 100 83 164 1 2026558736 37328688 25858592
20:41:21 3714 8192000000 10933646848 11352961024 1958377008 19.293 100 68 137 2 2016674096 37144768 21152320
20:41:33 6778 8192000000 10906852112 11332849664 1917304832 18.965 98 49 96 1 1968179168 35239808 15634528
20:41:47 6376 8192000000 10909013408 11344109568 1930515152 19.071 99 48 96 1 1986245792 40408848 15321792
20:42:04 12273 8192000000 10888244976 11322769408 1901693168 18.840 98 35 70 1 1950615440 37066544 11855728
20:42:25 17558 8192000000 10856820720 11294167040 1836668464 18.314 95 33 66 3 1881387616 33991376 10727776
20:42:53 7008 8192000000 10858562192 11290423296 1876169872 18.634 98 54 107 0 1927799328 34524048 17105408
20:43:09 11763 8192000000 10847117200 11274231808 1883683184 18.695 99 32 61 2 1930601968 36625888 10292896
20:43:30 10351 8192000000 10860768288 11283054592 1858126608 18.488 98 37 74 2 1909618288 39472000 12019680
20:43:47 24123 8192000000 10858375296 11287990272 1886922688 18.721 99 24 48 2 1934480080 39539824 8017568
20:44:18 12569 8192000000 10865438976 11309096960 1906040128 18.875 100 31 62 1 1955187824 38228208 10919488
20:44:40 20022 8192000000 10841135696 11272409088 1855717088 18.469 98 25 50 2 1896727776 32624720 8385968
20:45:08 11400 8192000000 10816523120 11252912128 1823833584 18.209 97 35 70 0 1875861760 40554896 11473280
20:45:31 11526 8192000000 10826843200 11263963136 1855706224 18.468 99 31 62 1 1904462704 38453184 10303296
20:45:53 33309 8192000000 10815380528 11266863104 1850282944 18.424 98 22 44 3 1895500096 37419680 7797472
20:46:32 14094 8192000000 10841084032 11273428992 1891600544 18.759 100 34 67 1 1933415136 31480736 10333856
20:46:53 17847 8192000000 10833183488 11274608640 1856125632 18.472 98 21 40 0 1896409104 33627072 6656400
20:47:25 25121 8192000000 10827564432 11271118848 1887320352 18.724 100 21 42 4 1914524080 20538016 6665712
20:48:01 34979 8192000000 10846622720 11284791296 1900289008 18.829 100 19 38 1 1924799936 17372816 7138112
20:48:47 39255 8192000000 10835001232 11284353024 1896023536 18.794 99 33 66 1 1918537008 13274848 9238624
20:49:33 21546 8192000000 10839491408 11276931072 1892247616 18.764 99 38 77 3 1912227888 8383632 11596640
20:50:15 26084 8192000000 10842846416 11293732864 1912047328 18.923 100 15 30 2 1927643472 10959344 4636800
20:50:59 34296 8192000000 10879282272 11312181248 1916164608 18.956 100 22 44 3 1941875264 19057856 6652800
20:51:40 70660 8192000000 10874759744 11321950208 1928123984 19.052 100 30 58 2 1958893952 22327856 8442112
20:52:58 63204 8192000000 10850301536 11318554624 1890716080 18.752 98 8 16 0 1910847968 17830352 2301536
20:54:10 113237 8192000000 10873903264 11313053696 1926529568 19.039 100 32 65 0 1950914048 15152496 9231984
20:56:17 33657 8192000000 10859685776 11307925504 1909607184 18.903 99 46 93 1 1933689792 11462640 12619968
20:56:59 14223 8192000000 10856641456 11301621760 1925545376 19.031 100 46 91 3 1946315168 8112928 12656864
20:57:21 2579 8192000000 10871151232 11310186496 1934771984 19.105 100 45 86 3 1954986960 8503328 11711648
20:57:35 15910 8192000000 10878155232 11315314688 1940130752 19.148 100 36 72 1 1959396400 9503456 9762192
20:58:01 18169 8192000000 10873509584 11330961408 1954211600 19.260 100 31 62 1 1971912000 9201120 8499280
20:58:26 40922 8192000000 10885985568 11342172160 1948618768 19.215 99 37 74 0 1967943200 8574400 10750032
21:00:04 29232 8192000000 10881478432 11345473536 1949290752 19.221 99 16 32 0 1960052048 6405328 4355968
21:00:41 24577 8192000000 10896624688 11355054080 1972770032 19.407 100 10 20 0 1981393312 5969552 2653728
21:01:13 42613 8192000000 10897610096 11358834688 1940924688 19.154 98 11 22 0 1954229616 10063216 3241712
21:02:08 93089 8192000000 10904498448 11373797376 1981421312 19.476 100 20 40 1 2000988240 13412752 6154176
21:03:48 66982 8192000000 10907842304 11379601408 1989127344 19.537 100 21 42 1 2007454864 12625440 5702080
21:05:04 36120 8192000000 10897973936 11374055424 1966707440 19.359 99 10 20 2 1980134000 10646048 2780512
21:05:52 66513 8192000000 10926798544 11393744896 1997297760 19.601 100 25 50 1 2015083488 9951344 7834384
21:07:05 85128 8192000000 10931323792 11406909440 2002114000 19.639 100 10 20 0 2019206384 14433552 2658832
21:08:40 56863 8192000000 10909169392 11382243328 1971261264 19.395 99 10 20 0 1982394624 8405520 2727840
21:09:44 49485 8192000000 10929740304 11401375744 2001508272 19.635 100 19 38 0 2020739728 13544976 5686480
21:10:39 54624 8192000000 10940488720 11407265792 2003551232 19.651 100 14 28 1 2023199264 15499856 4148176
21:11:40 42477 8192000000 10926416976 11408314368 1986469472 19.516 99 23 46 1 2010704208 17437344 6797392
21:12:32 34141 8192000000 10924914720 11406798848 2002872080 19.645 100 37 74 1 2029233520 15103232 11258208
21:13:13 33789 8192000000 10937982944 11407138816 2007017920 19.678 100 22 44 2 2025388352 12157840 6212592
21:13:57 68039 8192000000 10935420080 11413897216 2006319648 19.673 100 18 36 2 2023887984 12418144 5150192
21:15:12 47791 8192000000 10946202848 11408617472 2015508272 19.745 100 35 68 2 2033353600 8011616 9833712
21:16:10 31105 8192000000 10969618720 11430334464 2025460416 19.823 100 25 50 2 2042131456 9791856 6879184
21:16:49 31037 8192000000 10984336512 11439706112 2008963424 19.693 99 33 66 2 2033064048 14847856 9252768
21:17:31 34021 8192000000 10961605744 11425402880 2004547936 19.659 99 27 54 0 2028848784 17084928 7215920
21:18:17 112732 8192000000 10943564144 11405017088 1977500992 19.445 98 17 34 2 1997581792 14569936 5510864
21:20:18 84613 8192000000 10927980880 11385303040 1927407296 19.046 96 39 78 1 1951184736 12350144 11427296
21:22:10 72873 8192000000 10868782160 11346870272 1862018016 18.520 94 11 22 0 1880007664 14527696 3461952
21:23:33 15090 8192000000 10864992176 11349061632 1947126384 19.204 100 9 18 0 1963544496 13689296 2728816
21:23:56 25758 8192000000 10846086448 11322265600 1870798464 18.591 96 14 27 1 1886882784 12110720 3973600
21:24:33 35829 8192000000 10829817168 11301171200 1872558256 18.605 97 10 20 3 1885271120 10441632 2271232
21:25:15 19205 8192000000 10857265872 11325566976 1929783008 19.065 100 10 20 1 1943489728 10654944 3051776
21:25:46 66907 8192000000 10835091568 11298889728 1868143328 18.569 97 22 44 0 1886159296 11601408 6414560
21:26:59 84737 8192000000 10843169968 11310276608 1886511536 18.718 97 23 46 0 1901935824 9128640 6295648
21:28:46 53344 8192000000 10812445728 11293671424 1823728608 18.208 94 7 14 1 1834386048 8725024 1932416
21:29:45 28769 8192000000 10825985488 11288383488 1866909856 18.559 98 15 30 0 1876882960 5966976 4006128
21:30:38 46351 8192000000 10857217552 11312230400 1836569936 18.313 95 27 54 0 1852553968 8787376 7196656
21:31:31 48689 8192000000 10865744192 11330441216 1896849488 18.801 98 24 47 1 1917521312 14129856 6541968
21:32:26 72885 8192000000 10874829456 11328282624 1875134688 18.626 97 19 38 1 1895815040 15491520 5188832
21:33:49 48666 8192000000 10853139344 11323047936 1864509936 18.540 96 24 48 1 1883476368 11960960 7005472
21:34:44 22257 8192000000 10870116976 11323072512 1911067184 18.915 98 57 114 2 1934717840 7443376 16207280
21:35:20 46971 8192000000 10875953840 11346935808 1945159184 19.188 100 33 65 2 1967956048 13540880 9255984
21:36:19 24483 8192000000 10879571264 11334840320 1886379520 18.717 97 25 52 0 1912406624 18976784 7050320
21:36:51 40295 8192000000 10868901040 11313012736 1906249840 18.877 98 43 86 2 1929643472 11809392 11584240
21:37:40 60681 8192000000 10897386336 11330318336 1915537888 18.951 99 31 62 0 1936115696 11749376 8828432
21:38:49 19199 8192000000 10889970864 11334791168 1935705728 19.112 100 47 93 0 1959247392 10876768 12664896
21:39:16 25542 8192000000 10896180992 11338616832 1926539024 19.039 99 43 86 1 1952720512 13992512 12188976
21:39:58 27689 8192000000 10896568768 11350286336 1947602752 19.207 100 37 74 0 1975754272 17944000 10207520
21:40:32 72228 8192000000 10861986976 11314647040 1872682944 18.606 96 15 30 1 1894298768 17595088 4020736
21:41:51 89993 8192000000 10876258848 11353919488 1913918848 18.938 98 16 32 0 1933147472 14415056 4813568
21:43:29 66214 8192000000 10880978432 11334410240 1911460144 18.918 98 35 70 2 1935185728 13476592 10248992
21:45:09 92274 8192000000 10868690112 11343437824 1912191600 18.924 98 22 44 1 1934343824 15647328 6504896
21:47:22 42911 8192000000 10846780224 11328118784 1908203616 18.892 98 13 26 2 1925764880 13884432 3676832
21:48:12 46586 8192000000 10857752608 11333754880 1945771632 19.193 100 7 14 0 1955752224 8119936 1860656
21:49:07 55682 8192000000 10882942368 11353202688 1960607504 19.311 100 19 39 0 1974304544 7936400 5760640
21:50:28 51335 8192000000 10871669184 11337064448 1915870640 18.954 98 13 26 0 1928124016 8313392 3939984
21:51:25 78595 8192000000 10869491840 11353178112 1956775424 19.280 100 14 28 2 1968942720 8008320 4158976
21:52:50 72411 8192000000 10884244704 11362734080 1941843280 19.161 99 11 23 1 1955970608 10413856 3713472
21:54:08 32679 8192000000 10904944528 11378151424 1977183824 19.442 100 16 33 1 1993916048 12043312 4688912
21:54:56 57727 8192000000 10915313952 11388350464 1969744160 19.383 99 26 52 1 1996223936 18782112 7697664
21:56:01 47794 8192000000 10927797120 11409641472 1990492384 19.548 100 18 36 0 2017797936 21929408 5376144
21:57:13 47917 8192000000 10948791728 11400900608 1993664736 19.573 100 24 48 1 2014806576 14300416 6841424
21:58:11 66075 8192000000 10944011344 11421335552 2003808992 19.653 100 26 52 1 2033220576 21787328 7624256
21:59:37 82179 8192000000 10920773536 11403673600 1954724016 19.264 98 8 16 0 1968530576 11917440 1889120
22:01:29 62018 8192000000 10969310112 11416121344 1950536704 19.231 97 28 56 0 1967675040 9682576 7455760
22:02:44 53531 8192000000 10969269024 11423858688 2012494544 19.721 100 34 68 0 2038721696 16921696 9305456
22:03:50 37027 8192000000 10952087904 11431817216 2013561600 19.730 100 42 82 3 2045616096 20536352 11518144
22:04:33 116672 8192000000 10929451872 11416518656 1910915920 18.914 95 19 38 0 1933738336 17878400 4944016
22:06:36 28765 8192000000 10928842416 11387920384 1946019264 19.195 97 34 68 0 1964686832 8541296 10126272
22:07:12 101809 8192000000 10918254096 11377016832 1931366688 19.078 97 28 56 0 1950637696 11344336 7926672
22:09:07 72953 8192000000 10874212096 11345080320 1858223088 18.489 94 20 40 0 1875437632 11830208 5384336
22:11:32 76626 8192000000 10869808768 11351683072 1931243680 19.077 98 8 16 0 1942884304 9419376 2221248
22:12:55 59758 8192000000 10844605776 11320688640 1837359040 18.319 94 10 20 1 1847365216 7466784 2539392
22:14:01 86091 8192000000 10845631872 11307982848 1835244208 18.302 94 18 36 0 1848362256 7623056 5494992
22:16:58 60106 8192000000 10851302352 11328950272 1892400688 18.765 97 15 30 0 1910175904 13091600 4683616
22:18:05 53062 8192000000 10867564464 11349905408 1918709888 18.977 99 15 30 0 1936919680 13690816 4518976
22:19:27 70082 8192000000 10852765008 11315961856 1805629088 18.060 93 18 36 2 1817126912 6622288 4875536
22:21:00 72734 8192000000 10851887120 11329245184 1880503808 18.669 97 26 52 0 1901109008 13250576 7354624
22:22:25 75135 8192000000 10850414512 11309654016 1851117504 18.431 96 17 34 0 1871311648 15643024 4551120
22:23:52 57509 8192000000 10849942640 11312615424 1870973184 18.592 97 26 52 0 1891481024 13443024 7064816
22:24:56 57508 8192000000 10845825520 11301801984 1818572864 18.166 95 29 58 1 1836820640 10437776 7810000
22:26:09 41622 8192000000 10846666192 11308163072 1879409824 18.660 98 20 39 1 1895521168 10633504 5477840
22:26:58 24401 8192000000 9015847616 9200934912 183957552 2.196 10 2 4 0 186432624 2056512 418560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 93 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 18-12-2020 22:28:47 to 18-12-2020 22:28:49.

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          248801
MON$OLDEST_ACTIVE               248802
MON$OLDEST_SNAPSHOT             248802
MON$NEXT_TRANSACTION            248802
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                       2011456
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:60: 
:61: mscs-test-161.budzdorov.ru    Fri Dec 18 22:27:30 2020
:62:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:63: 
--- end of diff output ---

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

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