Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.01.2021 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 17119156 kB
MemAvailable 31378616 kB
Buffers 0 kB
Cached 14547504 kB
SwapCached 4864 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 2021-01-06 22:27:09
DTS_END                         2021-01-06 22:27:09.7180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(141:26) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46552
TRN_ID                          243584
ATT_ID                          666
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: 9366.56 22221 1123987
customer order: creation 177.78 346 21334
customer order: refuse 15.45 353 1854
order to supplier: creation 47.03 1334 5644
order to supplier: removal 3.72 88709 446
invoice (draft): creation 48.16 3456 5779
invoice (draft): removal 54.50 717 6540
invoice accept: apply 42.72 16658 5126
invoice accept: cancel 48.52 693 5822
customer reserve: creation 3865.56 168 463867
customer reserve: removal 4765.68 54 571882
realization accept: apply 85.69 171 10283
realization accept: cancel 79.82 106 9578
payment from customer: creation 60.36 145 7243
payment from customer: removal 5.91 67 709
payment to supplier: creation 49.91 168 5989
payment to supplier: removal 3.38 59 406
service: total inventory turnovers 4.74 1021 569
service: total monetary turnovers 6.77 30 812
service: aggregate perf. data 0.83 22595 100
service: refresh index statistics 0.03 307576 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 06-01-2021 22:28:16 to 06-01-2021 22:28:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5765
TEST_TIME 2 4781
TEST_TIME 3 5187
TEST_TIME 4 4747
TEST_TIME 5 4428
TEST_TIME 6 4275
TEST_TIME 7 4386
TEST_TIME 8 4692
TEST_TIME 9 4694
TEST_TIME 10 5328
TEST_TIME 11 5357
TEST_TIME 12 5514
TEST_TIME 13 5747
TEST_TIME 14 5981
TEST_TIME 15 6596
TEST_TIME 16 7346
TEST_TIME 17 7463
TEST_TIME 18 7786
TEST_TIME 19 8338
TEST_TIME 20 8575
TEST_TIME 21 8884
TEST_TIME 22 9044
TEST_TIME 23 9115
TEST_TIME 24 9537
TEST_TIME 25 9562
TEST_TIME 26 10500
TEST_TIME 27 10479
TEST_TIME 28 10207
TEST_TIME 29 10183
TEST_TIME 30 10295
TEST_TIME 31 10528
TEST_TIME 32 10256
TEST_TIME 33 10208
TEST_TIME 34 10059
TEST_TIME 35 10040
TEST_TIME 36 9906
TEST_TIME 37 10198
TEST_TIME 38 10266
TEST_TIME 39 10185
TEST_TIME 40 10145
TEST_TIME 41 10009
TEST_TIME 42 10056
TEST_TIME 43 9941
TEST_TIME 44 9969
TEST_TIME 45 9999
TEST_TIME 46 10074
TEST_TIME 47 9943
TEST_TIME 48 9751
TEST_TIME 49 9748
TEST_TIME 50 9693
TEST_TIME 51 9658
TEST_TIME 52 9623
TEST_TIME 53 9626
TEST_TIME 54 9639
TEST_TIME 55 9596
TEST_TIME 56 9703
TEST_TIME 57 9642
TEST_TIME 58 9580
TEST_TIME 59 9635
TEST_TIME 60 9537
TEST_TIME 61 9483
TEST_TIME 62 9491
TEST_TIME 63 9559
TEST_TIME 64 9569
TEST_TIME 65 9552
TEST_TIME 66 9578
TEST_TIME 67 9551
TEST_TIME 68 9634
TEST_TIME 69 9661
TEST_TIME 70 9716
TEST_TIME 71 9672
TEST_TIME 72 9680
TEST_TIME 73 9760
TEST_TIME 74 9849
TEST_TIME 75 9802
TEST_TIME 76 9676
TEST_TIME 77 9693
TEST_TIME 78 9688
TEST_TIME 79 9640
TEST_TIME 80 9673
TEST_TIME 81 9590
TEST_TIME 82 9602
TEST_TIME 83 9587
TEST_TIME 84 9520
TEST_TIME 85 9474
TEST_TIME 86 9456
TEST_TIME 87 9490
TEST_TIME 88 9474
TEST_TIME 89 9483
TEST_TIME 90 9469
TEST_TIME 91 9524
TEST_TIME 92 9569
TEST_TIME 93 9571
TEST_TIME 94 9587
TEST_TIME 95 9603
TEST_TIME 96 9662
TEST_TIME 97 9715
TEST_TIME 98 9683
TEST_TIME 99 9697
TEST_TIME 100 9659
TEST_TIME 101 9683
TEST_TIME 102 9721
TEST_TIME 103 9678
TEST_TIME 104 9611
TEST_TIME 105 9587
TEST_TIME 106 9563
TEST_TIME 107 9548
TEST_TIME 108 9576
TEST_TIME 109 9552
TEST_TIME 110 9527
TEST_TIME 111 9473
TEST_TIME 112 9468
TEST_TIME 113 9424
TEST_TIME 114 9495
TEST_TIME 115 9455
TEST_TIME 116 9470
TEST_TIME 117 9449
TEST_TIME 118 9451
TEST_TIME 119 9437
TEST_TIME 120 9372

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-01-2021 22:28:20 to 06-01-2021 22:28:23.

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 1555144 1555144 0 0.00 0 16259 6 0 0
doc_list_biud 1555144 1555144 0 0.00 0 22805 25 0 0
sp_add_invoice_to_stock 5187 5126 61 1.17 35 206771 16659 0 61
sp_cancel_adding_invoice 5822 5822 0 0.00 5 57956 694 0 0
sp_cancel_client_order 1854 1854 0 0.00 4 11869 353 0 0
sp_cancel_customer_reserve 571882 571882 0 0.00 1 18303 54 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 3 2556 67 0 0
sp_cancel_pay_to_supplier 406 406 0 0.00 2 2901 59 0 0
sp_cancel_supplier_invoice 6542 6540 2 0.03 1 20689 717 0 2
sp_cancel_supplier_order 446 446 0 0.00 9 1015499 88709 0 0
sp_cancel_write_off 9578 9578 0 0.00 1 22838 107 0 0
sp_client_order 21334 21334 0 0.00 3 14556 346 0 0
sp_customer_reserve 463867 463867 0 0.00 0 79849 169 0 0
sp_fill_shopping_cart 32746 32746 0 0.00 1 14688 41 0 0
sp_fill_shopping_cart_clo_res 463857 463857 0 0.00 0 20707 12 0 0
sp_get_clo_for_invoice 5116 5116 0 0.00 0 24475 250 0 0
sp_kill_cost_storno 16515 16515 0 0.00 0 7186 55 0 0
sp_kill_qstorno_ret_qs2qd 1160328 1160328 0 0.00 0 22803 29 0 0
sp_kill_qty_storno 611521 611521 0 0.00 0 22804 64 0 0
sp_lock_selected_doc 21441 21441 0 0.00 0 9111 4 0 0
sp_make_cost_storno 28631 28631 0 0.00 0 14650 57 0 0
sp_multiply_rows_for_pdistr 28631 28631 0 0.00 0 9175 33 0 0
sp_multiply_rows_for_qdistr 21334 21334 0 0.00 0 11170 140 0 0
sp_pay_from_customer 7243 7243 0 0.00 4 14861 145 0 0
sp_pay_to_supplier 5989 5989 0 0.00 4 13205 169 0 0
sp_payment_common 13232 13232 0 0.00 1 11697 41 0 0
sp_qd_handle_on_cancel_clo 1854 1854 0 0.00 0 11864 328 0 0
sp_qd_handle_on_invoice_upd_sts 10938 10938 0 0.00 0 15651 338 0 0
sp_qd_handle_on_reserve_upd_sts 10283 10283 0 0.00 0 14547 58 0 0
sp_reserve_write_off 10283 10283 0 0.00 6 14904 171 0 0
sp_supplier_invoice 5779 5779 0 0.00 7 86351 3457 0 0
sp_supplier_order 5644 5644 0 0.00 5 25759 1334 0 0
srv_aggregate_perf_data 100 100 0 0.00 2558 360382 22595 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 875 124933 33171 0 0
srv_find_qd_qs_mism 1076169 1076169 0 0.00 0 16259 5 0 0
srv_make_invnt_saldo 569 569 0 0.00 25 44103 1022 0 0
srv_make_money_saldo 812 812 0 0.00 0 3882 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 164538 556694 307576 0 0
t$perf-abend:sp_add_invoice_to_stock 61 61 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5127 5127 0 0.00 0 21030 154 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 1992 75 0 0
t$perf-norm:sp_cancel_client_order 1854 1854 0 0.00 0 2479 12 0 0
t$perf-norm:sp_cancel_customer_reserve 703 703 0 0.00 0 1620 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 672 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 406 406 0 0.00 0 687 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 1500 18 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 27880 1378 0 0
t$perf-norm:sp_cancel_write_off 1110 1110 0 0.00 0 5347 13 0 0
t$perf-norm:sp_client_order 21334 21334 0 0.00 0 4857 15 0 0
t$perf-norm:sp_customer_reserve 1029 1029 0 0.00 0 4477 9 0 0
t$perf-norm:sp_pay_from_customer 7243 7243 0 0.00 0 7178 8 0 0
t$perf-norm:sp_pay_to_supplier 5989 5989 0 0.00 0 3542 9 0 0
t$perf-norm:sp_reserve_write_off 10283 10283 0 0.00 0 4227 9 0 0
t$perf-norm:sp_supplier_invoice 5779 5779 0 0.00 0 5779 22 0 0
t$perf-norm:sp_supplier_order 5644 5644 0 0.00 0 13625 20 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 93 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 3048 24 0 0
t$perf-norm:srv_make_invnt_saldo 569 569 0 0.00 0 1032 20 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 4863 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10354 10232 122 1.17 0 6049 18 0 122
v_all_customers 38706 38706 0 0.00 0 41 1 0 0
v_all_suppliers 31714 31714 0 0.00 0 243 1 0 0
v_all_wares 42666 42666 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 1809 10 0 0
v_cancel_client_order 3708 3708 0 0.00 0 3691 7 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 2061 5 0 0
v_cancel_customer_reserve 1406 1406 0 0.00 0 3054 7 0 0
v_cancel_payment_to_supplier 812 812 0 0.00 0 495 4 0 0
v_cancel_supplier_invoice 822 818 4 0.48 0 3788 22 0 4
v_cancel_supplier_order 892 892 0 0.00 0 4020 9 0 0
v_cancel_write_off 2220 2220 0 0.00 0 4653 16 0 0
v_max_id_clo_ord 5644 5644 0 0.00 0 3387 3 0 0
v_max_id_clo_res 1029 1029 0 0.00 0 2640 15 0 0
v_max_id_ord_sup 5769 5769 0 0.00 0 6857 7 0 0
v_max_non_paid_invoice 1545 1545 0 0.00 0 3501 6 0 0
v_max_non_paid_realizn 3909 3909 0 0.00 0 2037 5 0 0
v_min_id_clo_ord 5644 5644 0 0.00 0 2585 7 0 0
v_min_id_clo_res 1029 1029 0 0.00 0 6983 14 0 0
v_min_id_ord_sup 5769 5769 0 0.00 0 12894 10 0 0
v_min_non_paid_invoice 5989 5989 0 0.00 0 10397 28 0 0
v_min_non_paid_realizn 7243 7243 0 0.00 0 9690 31 0 0
v_our_firm 10628 10628 0 0.00 0 11 1 0 0
v_reserve_write_off 20566 20566 0 0.00 0 5500 7 0 0
x_lock_depdocs_on_canc_invoice 11953 11953 0 0.00 0 7244 109 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 4465 287 0 0
x_make_qstorno_1000_1200 5644 5644 0 0.00 2 25737 1254 0 0
x_make_qstorno_1200_2000 5779 5779 0 0.00 2 85320 3308 0 0
x_make_qstorno_2100_3300 463867 463867 0 0.00 0 79848 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-01-2021 22:28:24 to 06-01-2021 22:28:28.

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:13 7 8192000000 8805312224 8817901568 8973408 0.109 2 1 2 0 9144432 61552 109472
19:57:20 14867 8192000000 10198817008 10497146880 828990864 9.189 66 57 114 0 850871392 2346656 19533872
19:57:45 33160 8192000000 10322695536 10636648448 1372417712 14.349 100 92 184 1 1407320448 4650480 30252256
19:58:30 27623 8192000000 10362141504 10683801600 1409978848 14.684 100 89 178 1 1445556384 6243776 29333760
19:59:06 27170 8192000000 10408177104 10734718976 1452965344 15.064 100 86 172 1 1487812912 7054720 27792848
19:59:43 17970 8192000000 10427807040 10757640192 1475489200 15.262 100 87 174 0 1511074992 7639520 27946272
20:00:10 31642 8192000000 10457837520 10790342656 1500321536 15.479 100 90 180 0 1537367248 8354608 28691104
20:00:51 10069 8192000000 10464689568 10801192960 1518208368 15.635 100 88 176 0 1555652496 9401456 28042672
20:01:14 15081 8192000000 10477928848 10820759552 1531418784 15.749 100 81 162 0 1566257040 9268832 25569424
20:01:38 11477 8192000000 10491868944 10837598208 1553307968 15.939 100 84 168 1 1589083072 9604080 26171024
20:02:08 16471 8192000000 10529645936 10882187264 1585634144 16.216 100 78 156 1 1619242832 9603152 24005536
20:02:36 20068 8192000000 10572827024 10929139712 1628853888 16.585 100 78 156 0 1663033536 10825088 23354560
20:03:08 11522 8192000000 10585702992 10951204864 1648846640 16.755 100 74 146 2 1681409472 11306416 21256416
20:03:28 10336 8192000000 10617585008 10985041920 1672215040 16.952 100 73 146 0 1705459040 11663760 21580240
20:03:46 8362 8192000000 10626657744 10996547584 1689095600 17.094 100 75 148 1 1722156256 11551504 21509152
20:04:02 6171 8192000000 10633971264 11011088384 1702733600 17.208 100 80 160 2 1738101328 11863936 23503792
20:04:17 9181 8192000000 10654305456 11026989056 1717481712 17.331 100 82 162 1 1754228096 11841824 24904560
20:04:34 10470 8192000000 10671379024 11042664448 1729668704 17.433 100 79 158 1 1764445808 11892096 22885008
20:04:51 5557 8192000000 10682609024 11056779264 1744344000 17.555 100 87 170 1 1780824640 12623984 23856656
20:05:03 5336 8192000000 10696534096 11073159168 1757510192 17.664 100 84 168 3 1794512432 13446608 23555632
20:05:17 5319 8192000000 10713019056 11090345984 1770493504 17.771 100 83 164 1 1807812752 14174240 23145008
20:05:29 5070 8192000000 10722127472 11101532160 1779653584 17.847 100 85 170 2 1818062512 14352080 24056848
20:05:42 4745 8192000000 10721464560 11102945280 1782089472 17.867 100 84 167 1 1819996704 14689872 23217360
20:05:53 2710 8192000000 10729384208 11110596608 1795240448 17.975 100 85 170 0 1833877232 14929904 23706880
20:06:02 3416 8192000000 10746885392 11129384960 1805859488 18.062 100 86 172 1 1844850624 14917072 24074064
20:06:13 2904 8192000000 10744839376 11132223488 1811327472 18.107 100 84 168 2 1848390368 14041776 23021120
20:06:23 2549 8192000000 10750987088 11134902272 1815801552 18.143 100 85 169 0 1853313440 14001504 23510384
20:06:32 3306 8192000000 10759018672 11149029376 1818270096 18.164 100 75 147 1 1850768176 12206048 20292032
20:06:42 4678 8192000000 10766325168 11153178624 1826329840 18.229 100 90 179 0 1868804320 17324144 25150336
20:06:53 4914 8192000000 10770337136 11157610496 1831858048 18.274 100 92 184 0 1872461312 14482240 26121024
20:07:05 2204 8192000000 10782833152 11172982784 1838579040 18.329 100 88 176 0 1877952000 14597440 24775520
20:07:14 2755 8192000000 10794408048 11182952448 1845521552 18.386 100 89 177 2 1885133792 14387872 25224368
20:07:23 1395 8192000000 10791952368 11180617728 1849826208 18.421 100 94 190 1 1891332560 15005008 26501344
20:07:31 1497 8192000000 10795122768 11183050752 1853567776 18.451 100 94 188 2 1892656720 13325200 25763744
20:07:38 1213 8192000000 10801215680 11189051392 1855704512 18.468 100 95 191 1 1895813072 13055840 27052720
20:07:46 1922 8192000000 10805403232 11195150336 1859549728 18.500 100 95 189 0 1900337024 13720112 27067184
20:07:54 1506 8192000000 10807447552 11194851328 1859398736 18.498 100 92 182 1 1899510848 14673152 25438960
20:08:02 1960 8192000000 10800301296 11194769408 1865626592 18.549 100 91 180 0 1905061216 14173408 25261216
20:08:10 1887 8192000000 10810717024 11198849024 1875950240 18.632 100 95 191 1 1915315632 13302960 26062432
20:08:18 1605 8192000000 10825290032 11215044608 1870935040 18.592 100 90 180 0 1910839376 14358784 25545552
20:08:26 1684 8192000000 10817553312 11210944512 1874785344 18.623 100 89 178 1 1912233312 12506432 24941536
20:08:34 26017 8192000000 10796087664 11204530176 1871401760 18.596 100 54 108 1 1896568096 8950864 16215472
20:09:09 15272 8192000000 10798659712 11211243520 1877171056 18.642 100 60 118 3 1905408688 10541856 17695776
20:09:31 40298 8192000000 10781830672 11210477568 1874248544 18.619 100 46 90 1 1895624320 8309168 13066608
20:10:19 7384 8192000000 10789035920 11212746752 1881014960 18.673 100 39 80 1 1897760768 5478656 11267152
20:10:34 9105 8192000000 10788185584 11213897728 1876379248 18.636 100 29 57 1 1890732000 6275808 8076944
20:10:52 4642 8192000000 10792025696 11219824640 1883952112 18.697 100 41 83 1 1903819248 8136240 11730896
20:11:04 7279 8192000000 10784014672 11217072128 1879252112 18.659 100 19 38 1 1890718128 6199984 5266032
20:11:17 10767 8192000000 10793476880 11227729920 1879612000 18.662 100 20 41 1 1891832496 6629296 5591200
20:11:34 9282 8192000000 10790500480 11221770240 1881136672 18.674 100 19 38 0 1892661648 6119024 5405952
20:11:54 9404 8192000000 10791807728 11228278784 1885764640 18.712 100 27 53 3 1898265600 5555280 6945680
20:12:10 10942 8192000000 10795615968 11229372416 1887320448 18.724 100 22 44 1 1899759984 5734864 6704672
20:12:31 15336 8192000000 10789741952 11229765632 1887907936 18.729 100 19 38 3 1898743104 5922768 4912400
20:12:56 6097 8192000000 10795564624 11232079872 1890684416 18.751 100 24 48 0 1904177056 6571632 6921008
20:13:09 10752 8192000000 10789990384 11230797824 1889782384 18.744 100 15 30 1 1901258352 6381696 5094272
20:13:28 10641 8192000000 10791715808 11233148928 1892102288 18.763 100 21 42 0 1904629296 6717952 5809056
20:13:48 8599 8192000000 10800561632 11236802560 1895385360 18.789 100 24 48 0 1908945264 7132944 6426960
20:14:03 14677 8192000000 10803359168 11239292928 1898317328 18.813 100 29 58 0 1910832656 5555088 6960240
20:14:26 64255 8192000000 10828007328 11239403520 1887915600 18.729 99 56 110 1 1909838832 5402000 16521232
20:15:36 4620 8192000000 10812747936 11246497792 1894186896 18.780 100 36 70 1 1912563296 9023024 9353376
20:15:49 4250 8192000000 10819534080 11251056640 1897543552 18.807 100 37 74 0 1915689808 7526128 10620128
20:16:00 7588 8192000000 10816745200 11250909184 1900425904 18.830 100 26 52 0 1913989296 6284800 7278592
20:16:16 4570 8192000000 10819363024 11248705536 1897592912 18.807 100 29 58 0 1912356256 6762704 8000640
20:16:28 5767 8192000000 10803358064 11243667456 1894128704 18.779 100 25 50 1 1907590224 6428608 7032912
20:16:41 6277 8192000000 10805518720 11247788032 1895525984 18.790 100 17 35 0 1907223744 6414992 5282768
20:16:54 5904 8192000000 10826468560 11251671040 1895400704 18.789 100 33 66 1 1911780400 6655360 9724336
20:17:06 6611 8192000000 10794365664 11231985664 1877553760 18.645 99 18 36 1 1887868240 5035376 5279104
20:17:19 5636 8192000000 10789754864 11220131840 1833938992 18.291 97 19 39 1 1844729392 5552592 5237808
20:17:33 9524 8192000000 10742431152 11170770944 1787551808 17.912 96 20 41 3 1799243120 5481632 6209680
20:17:51 9281 8192000000 10744964384 11177594880 1790063552 17.932 96 17 34 0 1800916624 5824784 5028288
20:18:08 12560 8192000000 10754471088 11185299456 1814546048 18.133 98 34 68 1 1830730048 6906112 9277888
20:18:27 47654 8192000000 10766897216 11184754688 1791544176 17.944 96 41 80 0 1809318368 6505680 11268512
20:19:21 12899 8192000000 10715474448 11145682944 1733131248 17.462 94 25 51 0 1745381552 4664368 7585936
20:19:41 6941 8192000000 10729643824 11153682432 1775058912 17.809 97 34 68 0 1791517728 7049616 9409200
20:19:54 10599 8192000000 10733595920 11157319680 1809667824 18.093 99 29 59 1 1823910784 5572864 8670096
20:20:11 6263 8192000000 10726317520 11138621440 1732253872 17.454 95 21 42 2 1743308800 5218016 5836912
20:20:24 4556 8192000000 10718571296 11137474560 1775963376 17.816 98 38 76 1 1793905488 7377312 10564800
20:20:37 8973 8192000000 10744647952 11163430912 1805299440 18.057 99 20 40 1 1817080496 5501312 6279744
20:20:53 8694 8192000000 10718390288 11137310720 1721816880 17.367 94 22 44 2 1733449984 5047824 6585280
20:21:10 7763 8192000000 10666318432 11076296704 1694014416 17.135 94 23 46 3 1707013808 6455808 6543584
20:21:24 5452 8192000000 10706687440 11112271872 1756938384 17.659 98 34 67 1 1773609088 7162144 9508560
20:21:36 6345 8192000000 10711736592 11124371456 1797810640 17.996 100 34 68 0 1813665136 6077472 9777024
20:21:50 3805 8192000000 10705230000 11118223360 1765987520 17.734 98 25 50 1 1778840848 5772480 7080848
20:22:00 9012 8192000000 10731915616 11137712128 1790005872 17.932 99 25 50 2 1803791952 5949888 7836192
20:22:20 10534 8192000000 10725342112 11143553024 1796979088 17.989 99 21 42 1 1808838672 5557952 6301632
20:22:39 9145 8192000000 10734693696 11149971456 1781023584 17.858 98 20 40 2 1796739616 10154032 5562000
20:22:57 45306 8192000000 10740557968 11154710528 1818960032 18.169 100 21 40 3 1830556480 5608368 5988080
20:24:01 19566 8192000000 10740549520 11169705984 1833501616 18.288 100 19 38 0 1844266432 5690368 5074448
20:24:28 10584 8192000000 10742247824 11173629952 1835645056 18.305 100 21 42 1 1848298208 5875712 6777440
20:24:45 9182 8192000000 10759000464 11181162496 1844503984 18.377 100 38 76 0 1862639200 7856320 10278896
20:25:00 7781 8192000000 10770964736 11189805056 1847229536 18.400 100 28 56 2 1861953424 6482560 8241328
20:25:18 5884 8192000000 10758103152 11184820224 1846291488 18.392 100 41 81 1 1864253888 6232736 11729664
20:25:31 7662 8192000000 10763848752 11188027392 1850108464 18.423 100 24 48 1 1863168432 5512128 7547840
20:25:48 11246 8192000000 10761652112 11192750080 1854329200 18.457 100 19 38 0 1865056640 5044608 5682832
20:26:05 11261 8192000000 10780806400 11205967872 1862652576 18.525 100 22 44 0 1874456880 5172272 6632032
20:26:23 13069 8192000000 10777676096 11207946240 1865796576 18.550 100 28 54 2 1879580320 5253360 8530384
20:26:43 12839 8192000000 10784956464 11210555392 1866103840 18.553 100 15 30 1 1875269248 4846352 4319056
20:27:08 15374 8192000000 10812077552 11233746944 1883673776 18.695 100 22 45 1 1895280064 4664544 6941744
20:27:30 8344 8192000000 10830944224 11250434048 1903712704 18.856 100 42 85 1 1922539504 6721056 12105744
20:27:46 32199 8192000000 10841861040 11263016960 1910279424 18.909 100 46 92 2 1931693504 7663776 13750304
20:28:27 39747 8192000000 10852346704 11272077312 1919131808 18.980 100 54 105 3 1943654880 9624576 14898496
20:29:14 68310 8192000000 10856904640 11285110784 1904109296 18.859 99 39 75 1 1927742080 12418752 11214032
20:30:30 16403 8192000000 10853227072 11286302720 1930201504 19.068 100 40 80 0 1954258864 12378112 11679248
20:31:03 22687 8192000000 10872842096 11303890944 1936051504 19.115 100 35 67 1 1958057152 12502592 9503056
20:31:44 15091 8192000000 10883961120 11314913280 1945664992 19.192 100 41 82 1 1974246192 16922192 11659008
20:32:07 17631 8192000000 10884779360 11321401344 1959811744 19.305 100 58 117 2 1994402144 16885520 17704880
20:32:35 42951 8192000000 10904447504 11337306112 1962614352 19.327 100 45 90 2 1996724688 20572912 13537424
20:33:25 18544 8192000000 10914687584 11349553152 1969658432 19.383 100 37 73 2 2004078480 23056224 11363824
20:33:54 11477 8192000000 10928959552 11357270016 1977599712 19.446 100 41 77 1 2013117728 23736816 11781200
20:34:18 24639 8192000000 10929410640 11368300544 1985556960 19.509 100 45 90 0 2024326640 25043952 13725728
20:34:54 12819 8192000000 10947115968 11374682112 1995678768 19.589 100 57 114 1 2038997808 25465776 17853264
20:35:16 17465 8192000000 10946433248 11381571584 1993397728 19.571 100 41 82 1 2033221712 26406784 13417200
20:35:44 3802 8192000000 10957756896 11384750080 1999034192 19.615 100 66 132 6 2045644848 26409088 20201568
20:35:55 9814 8192000000 10950050432 11385651200 2000672816 19.628 100 59 116 0 2045471792 26971664 17827312
20:36:11 2965 8192000000 10966669296 11392843776 2003860784 19.653 100 66 131 1 2052049568 27688656 20500128
20:36:22 7271 8192000000 10971976112 11390627840 2006974272 19.678 100 70 134 3 2054110992 27479360 19657360
20:36:37 8838 8192000000 10969206704 11395923968 2003598208 19.651 100 67 131 3 2054815504 31664448 19552848
20:36:58 4695 8192000000 10967783424 11394646016 2001463888 19.634 100 67 134 1 2054633952 32760624 20409440
20:37:12 6413 8192000000 10970230688 11395989504 2003815456 19.653 100 59 118 2 2055931936 34416256 17700224
20:37:25 4710 8192000000 10986330784 11403157504 2006984816 19.678 100 70 140 2 2062882208 34260768 21636624
20:37:38 9597 8192000000 10959764256 11398144000 2004206592 19.656 100 51 101 0 2049066256 30014208 14845456
20:37:56 4846 8192000000 10981271152 11405983744 2011930928 19.717 100 59 115 2 2058496368 29796800 16768640
20:38:08 1413 8192000000 10982775664 11401814016 2011234144 19.711 100 86 170 2 2068517568 32188096 25095328
20:38:18 5536 8192000000 10976033280 11398123520 2006132224 19.671 100 79 157 2 2062476400 33522816 22821360
20:38:39 3438 8192000000 10981166832 11405025280 2011342816 19.712 100 75 150 1 2068839120 34831328 22664976
20:38:55 3587 8192000000 10995209088 11409895424 2017661232 19.762 100 80 159 1 2076594192 35421456 23511504
20:39:06 3284 8192000000 10983208784 11408277504 2011363568 19.712 100 82 162 2 2072919872 36175296 25381008
20:39:20 7001 8192000000 10965677744 11390095360 1985670192 19.510 99 68 136 0 2043013488 36925536 20417760
20:39:33 10364 8192000000 10953491248 11385552896 1973278400 19.411 99 63 124 1 2031993488 39120624 19594464
20:39:53 6315 8192000000 10946462544 11377405952 1977667376 19.446 100 54 107 0 2032259472 38270144 16321952
20:40:07 2882 8192000000 10913994096 11337121792 1947733744 19.208 99 66 127 2 2004179872 36188816 20257312
20:40:19 6054 8192000000 10945389456 11368251392 1961088320 19.315 99 67 136 2 2019842224 38239712 20514192
20:40:35 10405 8192000000 10976828112 11396550656 1993724976 19.573 100 77 150 3 2057477648 41062912 22689760
20:40:53 9098 8192000000 10981210464 11402821632 1996714832 19.597 100 75 149 1 2061407760 41848016 22844912
20:41:16 3690 8192000000 10965120592 11380621312 1962767088 19.328 98 75 148 1 2025911760 41157376 21987296
20:41:28 2382 8192000000 10962718992 11376533504 1979201120 19.458 100 87 173 2 2048810160 43065648 26543392
20:41:37 3422 8192000000 10952712288 11366510592 1970861952 19.392 100 75 149 1 2035862624 42597968 22402704
20:41:47 3065 8192000000 10946563424 11357958144 1942272720 19.165 98 85 168 1 2016319760 47834352 26212688
20:41:59 2160 8192000000 10965703952 11379556352 1974914080 19.424 100 71 142 0 2045708336 48869936 21924320
20:42:08 1484 8192000000 10976781392 11389997056 1980076208 19.465 100 84 167 0 2055382592 49078688 26227696
20:42:18 3842 8192000000 10977003920 11391016960 1981540400 19.477 100 87 174 3 2059960400 50983024 27436976
20:42:30 3482 8192000000 10975258704 11393060864 1983162512 19.490 100 82 164 0 2062139568 52760864 26216192
20:42:40 3263 8192000000 10999329968 11408891904 1995157136 19.585 100 83 166 0 2074412960 53834048 25421776
20:42:51 2210 8192000000 10993223616 11402997760 1998853232 19.614 100 90 180 0 2074003760 47999184 27151344
20:43:00 2387 8192000000 11001823904 11408805888 2001052816 19.631 100 88 176 1 2076282592 47682736 27547040
20:43:09 874 8192000000 10945865024 11355017216 1942565696 19.167 98 86 170 1 2014024080 44939056 26519328
20:43:17 1606 8192000000 10965030656 11369943040 1967106688 19.362 100 91 180 1 2039896400 44542320 28247392
20:43:26 2267 8192000000 10960119312 11364315136 1948458208 19.214 99 85 166 3 2020025264 46159728 25407328
20:43:35 2871 8192000000 10961048528 11374784512 1969864672 19.384 100 71 142 2 2039225312 47266032 22094608
20:43:44 3066 8192000000 10968499232 11385737216 1975890064 19.432 100 76 152 5 2047451408 48103872 23457472
20:43:56 12149 8192000000 10930721472 11383660544 1973487648 19.413 100 35 70 2 2028021056 42918384 11615024
20:44:23 2856 8192000000 10960509536 11381682176 1967769248 19.368 99 69 136 4 2025502880 35355472 22378160
20:44:34 4257 8192000000 10925596576 11357097984 1949257984 19.221 99 56 112 2 2005084256 37483824 18342448
20:44:48 5098 8192000000 10936004800 11355205632 1955378512 19.269 100 71 142 1 2018457584 39746976 23332096
20:45:02 4381 8192000000 10933671968 11349700608 1935819104 19.113 99 79 157 0 2002301824 41549520 24933200
20:45:13 5296 8192000000 10930590320 11357528064 1955659712 19.272 100 67 134 0 2018897168 42216832 21020624
20:45:32 11195 8192000000 10946474544 11366002688 1960092016 19.307 100 60 116 0 2022326800 43458944 18775840
20:45:52 2352 8192000000 10969156976 11384844288 1972285904 19.404 100 86 169 4 2046549872 47968992 26294976
20:46:01 7930 8192000000 10918446832 11350847488 1947178432 19.204 100 52 102 0 2006870432 43083168 16608832
20:46:23 5892 8192000000 10920902800 11354914816 1939405824 19.142 99 48 96 0 1994517136 39139328 15971984
20:46:37 2269 8192000000 10923623344 11345522688 1945046192 19.187 100 63 121 0 2002562656 37170032 20346432
20:46:47 7048 8192000000 10922724800 11358846976 1959453168 19.302 100 51 102 0 2014103424 38441280 16208976
20:47:03 10879 8192000000 10918076432 11356258304 1937218096 19.125 99 31 62 2 1985221584 37455952 10547536
20:47:24 12052 8192000000 10912205520 11361943552 1959763568 19.304 100 43 85 1 2010059280 35792144 14503568
20:47:43 12683 8192000000 10897196816 11347210240 1919662512 18.984 98 30 60 2 1962162800 32549424 9950864
20:48:16 14775 8192000000 10916303408 11357962240 1949674112 19.224 100 31 62 2 1994621072 34612576 10334384
20:48:40 13951 8192000000 10901339392 11350040576 1944882848 19.186 100 28 55 4 1988945632 34802960 9259824
20:49:05 30201 8192000000 10906499760 11357044736 1939488576 19.143 99 31 62 0 1981816640 32070112 10257952
20:49:51 20975 8192000000 10886953088 11338788864 1913791456 18.937 98 21 42 0 1951422128 30684064 6946608
20:50:26 20086 8192000000 10908555792 11362689024 1950544544 19.231 100 25 50 1 1994341824 35546896 8250384
20:50:53 15669 8192000000 10913146672 11368984576 1960836160 19.313 100 22 44 0 2003407136 34350784 8220192
20:51:15 50327 8192000000 10877212944 11327795200 1811548784 18.109 93 14 28 3 1847247104 30908608 4789712
20:52:13 20176 8192000000 10881814544 11336626176 1911476032 18.918 99 22 44 1 1956733168 38192704 7064432
20:52:45 5948 8192000000 10905585856 11339120640 1926783344 19.041 100 56 105 2 1981512976 36835200 17894432
20:52:57 19036 8192000000 10900266272 11353382912 1922211344 19.005 99 26 53 0 1972258976 41672144 8375488
20:53:26 20954 8192000000 10879879680 11326337024 1873145520 18.610 97 22 43 2 1920853360 40219232 7488608
20:53:55 20339 8192000000 10854144080 11299209216 1890302320 18.748 98 15 29 1 1909599536 15605424 3691792
20:54:24 8310 8192000000 10858327056 11306778624 1919685888 18.984 100 21 41 1 1942335632 16570496 6079248
20:54:39 41969 8192000000 10866994768 11293433856 1902758672 18.848 99 31 60 1 1927101216 15672864 8669680
20:55:42 2954 8192000000 10885703488 11316809728 1929075264 19.059 100 52 104 2 1961114048 16104352 15934432
20:55:52 5921 8192000000 10885450224 11314233344 1927022688 19.043 100 48 96 1 1958693168 16007296 15663184
20:56:05 21063 8192000000 10865996160 11315605504 1907159872 18.884 98 40 81 0 1936205936 17222560 11823504
20:57:06 29356 8192000000 10878030912 11335761920 1934872432 19.106 100 14 28 2 1964720544 25435600 4412512
20:58:00 52614 8192000000 10883013456 11354411008 1945329632 19.189 100 10 20 1 1965053008 16824112 2899264
20:59:02 50782 8192000000 10895007904 11333550080 1933887488 19.098 99 11 23 0 1945699392 8947600 2864304
21:00:04 56574 8192000000 10886823456 11335761920 1952811808 19.249 100 31 60 0 1969605696 7892176 8901712
21:01:17 32746 8192000000 10882076320 11326791680 1923998336 19.019 98 44 83 1 1943452576 7815392 11638848
21:02:25 60973 8192000000 10911819072 11374956544 1965665888 19.351 100 12 24 2 1987044048 17838496 3539664
21:04:01 117317 8192000000 10903557296 11381022720 1949765024 19.225 99 8 16 0 1976744672 24538704 2440944
21:06:06 110901 8192000000 10910550784 11375173632 1920107456 18.988 97 7 14 0 1931630176 9763632 1759088
21:08:03 49120 8192000000 10930036208 11377319936 1983554032 19.493 100 24 49 0 2004454256 13085216 7815008
21:09:14 32672 8192000000 10918115104 11375415296 1981727120 19.478 100 31 62 0 2004990864 14153136 9110608
21:10:03 63731 8192000000 10917947120 11382919168 1987941024 19.528 100 36 72 1 2007695296 8526416 11227856
21:11:13 124933 8192000000 10933486304 11402940416 1969467072 19.381 99 7 14 1 1983329552 11948432 1914048
21:13:27 56324 8192000000 10943772208 11398828032 1989595232 19.541 100 17 34 0 2009502688 15282512 4624944
21:14:29 104853 8192000000 10937353568 11398987776 1995300480 19.586 100 17 34 1 2009517472 9400176 4816816
21:16:20 11277 8192000000 10947649696 11393904640 1998583088 19.612 100 52 104 1 2021886560 8550416 14753056
21:16:38 40365 8192000000 10935894800 11389476864 1966998128 19.362 98 38 77 2 1986014720 8389184 10627408
21:17:26 22582 8192000000 10934520512 11381829632 1943852656 19.177 97 52 104 0 1969994064 11794496 14346912
21:17:59 105510 8192000000 10909215264 11374866432 1914657408 18.944 96 35 70 0 1935947472 10897936 10392128
21:19:53 19265 8192000000 10905135840 11369340928 1960868000 19.313 99 28 57 1 1980458144 11127936 8462208
21:20:18 36607 8192000000 10904036832 11374112768 1956252240 19.276 99 20 40 0 1973855552 11993648 5609664
21:21:09 32316 8192000000 10914754672 11368841216 1970235152 19.387 100 29 58 1 1990771680 11771840 8764688
21:21:52 41196 8192000000 10908853184 11353235456 1908206448 18.892 97 29 59 2 1929401392 13317536 7877408
21:22:43 26240 8192000000 10883176448 11343728640 1923431936 19.014 98 33 67 0 1948706608 16044928 9229744
21:23:24 28930 8192000000 10860066256 11334946816 1930966848 19.075 99 11 22 0 1942949584 8483024 3499712
21:23:59 41203 8192000000 10862182608 11333976064 1922295008 19.005 98 21 40 1 1935108592 6201472 6612112
21:24:46 69000 8192000000 10883318048 11356033024 1938912176 19.138 99 11 21 0 1950390624 8352896 3125552
21:26:01 38488 8192000000 10878385856 11354611712 1942087392 19.163 99 16 30 1 1954301680 7466144 4748144
21:26:48 13601 8192000000 10876502064 11362410496 1961441504 19.317 100 3 6 1 1968589088 6763888 383696
21:27:09 20055 8192000000 10875306160 11353296896 1943320544 19.173 99 4 8 0 1950097056 6051232 725280
21:27:38 43664 8192000000 10875380352 11346501632 1886845696 18.720 96 15 30 0 1898027808 7015408 4166704
21:28:56 49533 8192000000 10852950496 11320999936 1850499120 18.426 95 43 86 0 1873436992 10874144 12063728
21:30:01 40615 8192000000 10858059184 11323060224 1891916480 18.761 97 11 22 1 1902444240 7408736 3119024
21:30:48 43630 8192000000 10855020560 11318198272 1865383696 18.547 96 15 30 1 1876383760 6891568 4108496
21:32:21 20266 8192000000 10897264976 11327582208 1926470624 19.039 99 55 111 2 1949007360 7205440 15331296
21:32:54 27131 8192000000 10865110176 11320360960 1898564704 18.815 98 37 73 2 1917921792 9378928 9978160
21:33:33 31056 8192000000 10868394192 11314589696 1879918816 18.664 97 33 65 2 1898653904 8989728 9745360
21:34:13 36346 8192000000 10874263408 11326074880 1907918208 18.890 99 38 76 2 1929646432 11117552 10610672
21:35:04 48280 8192000000 10860204416 11335241728 1931345280 19.078 100 25 49 1 1958979648 20500160 7134208
21:35:58 107083 8192000000 10855823744 11332411392 1810367136 18.099 93 16 32 0 1834607360 19572752 4667472
21:37:51 60728 8192000000 10859908352 11313307648 1861350016 18.514 96 14 28 3 1874118240 8743808 4024416
21:39:02 63055 8192000000 10883707712 11328106496 1881629920 18.678 97 26 52 0 1904900496 15398480 7872096
21:40:45 100654 8192000000 10874622528 11343126528 1921050976 18.995 99 12 24 0 1940571888 16007952 3512960
21:43:04 92530 8192000000 10864476816 11330568192 1914345296 18.942 99 23 46 1 1933077456 11869232 6862928
21:44:44 55961 8192000000 10896694768 11350913024 1932707840 19.089 99 42 84 1 1956645264 12110720 11826704
21:45:48 45450 8192000000 10909202960 11357921280 1949065344 19.219 99 49 97 2 1973831552 11235664 13530544
21:46:40 31952 8192000000 10905846864 11362066432 1966083808 19.354 100 40 80 0 1990548704 12895632 11569264
21:47:20 80013 8192000000 10893633728 11368501248 1950795200 19.233 99 32 63 1 1972602464 12147008 9660256
21:48:46 56269 8192000000 10893816560 11367317504 1951335840 19.237 99 10 20 0 1969468912 15231968 2901104
21:49:52 77928 8192000000 10866586592 11345965056 1904039760 18.859 97 17 34 2 1922206576 13316336 4850480
21:52:50 58362 8192000000 10881999056 11356319744 1939473872 19.143 99 17 34 1 1960742160 16294080 4974208
21:53:55 37065 8192000000 10880618064 11372384256 1955617136 19.271 100 15 30 2 1971259056 11245808 4396112
21:54:43 56614 8192000000 10876707168 11355189248 1925932112 19.034 98 17 34 2 1943065296 12040576 5092608
21:55:51 84615 8192000000 10920071408 11382779904 1971779472 19.400 100 21 40 1 1992981824 15060224 6142128
21:57:23 28762 8192000000 10923668208 11380215808 1970149872 19.387 99 41 80 1 1995058688 14118256 10790560
21:57:59 72599 8192000000 10917466016 11401543680 1967703616 19.367 99 19 38 1 1984692480 12009776 4979088
21:59:45 70675 8192000000 10906245776 11375661056 1916525264 18.959 96 27 50 0 1932673824 9028096 7120464
22:01:06 76498 8192000000 10931727200 11406872576 1962227632 19.324 99 22 44 1 1984791072 16803792 5759648
22:02:39 87931 8192000000 10923757184 11405942784 1964308256 19.340 99 8 16 0 1985373504 18853504 2211744
22:04:13 80852 8192000000 10942529120 11406200832 1954743600 19.264 98 11 22 0 1976064144 18220496 3100048
22:05:40 80577 8192000000 10916296464 11378163712 1915476880 18.951 96 14 28 0 1931501072 12130704 3893488
22:07:09 19957 8192000000 10896764368 11347197952 1926585824 19.040 98 33 65 0 1943916064 8505648 8824592
22:07:35 46936 8192000000 10891760400 11351846912 1890688992 18.751 96 35 69 0 1910773472 10709056 9375424
22:08:30 58345 8192000000 10881194288 11348467712 1888429536 18.733 96 20 40 2 1910815632 16232384 6153712
22:09:46 53465 8192000000 10869563280 11354103808 1918030656 18.971 99 12 24 0 1939195216 16804736 4359824
22:10:51 81782 8192000000 10875188368 11348373504 1932522592 19.087 99 30 60 1 1951924496 10641536 8760368
22:12:20 107464 8192000000 10864196288 11341074432 1852342368 18.441 94 21 42 0 1873695648 15412384 5940896
22:14:23 89475 8192000000 10877200576 11366277120 1906431808 18.878 98 14 27 0 1931516560 21323248 3761504
22:16:07 44014 8192000000 10885410160 11368779776 1947947808 19.210 100 9 18 0 1969482896 18815424 2719664
22:17:04 98443 8192000000 10877498384 11346931712 1908671232 18.896 97 13 26 0 1930112816 17428960 4012624
22:19:00 76738 8192000000 10879427792 11353284608 1916607584 18.960 98 13 27 0 1937468704 17006080 3855040
22:20:27 74540 8192000000 10886081024 11374653440 1934923488 19.106 99 31 62 0 1959107968 15204960 8979520
22:22:34 66254 8192000000 10866088736 11350044672 1892866496 18.769 97 6 12 0 1907037920 12277760 1893664
22:23:46 86600 8192000000 10890356688 11362713600 1898769440 18.816 97 21 42 1 1913694368 9308096 5616832
22:25:27 49887 8192000000 10885384448 11346767872 1920708464 18.993 98 22 44 0 1936750112 9450672 6590976
22:26:26 39952 8192000000 10853716960 11313414144 1847398960 18.401 95 26 52 2 1864120752 9404256 7317536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-01-2021 22:28:30 to 06-01-2021 22:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 61 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-01-2021 22:29:02 to 06-01-2021 22:29:04.

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          243885
MON$OLDEST_ACTIVE               243886
MON$OLDEST_SNAPSHOT             243886
MON$NEXT_TRANSACTION            243886
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                       2048032
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:500: 
:501: mscs-test-161.budzdorov.ru    Wed Jan  6 22:27:16 2021
:502:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:503: 
:504: 
:505: mscs-test-161.budzdorov.ru    Wed Jan  6 22:27:16 2021
:506:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:507: 
--- end of diff output ---

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

06.01.21 22:29:05. 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
2021-01-06 22:29:08 No severe PSQL-related problems occured
06.01.21 22:29:09. End of report.