Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.01.2021 19: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 17295468 kB
MemAvailable 31332484 kB
Buffers 0 kB
Cached 14370284 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-12 19:27:14
DTS_END                         2021-01-12 19:27:14.7520
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53522
TRN_ID                          242089
ATT_ID                          675
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: 9389.27 24094 1126712
customer order: creation 171.54 339 20585
customer order: refuse 14.72 332 1766
order to supplier: creation 45.81 1270 5497
order to supplier: removal 3.53 100344 424
invoice (draft): creation 45.81 3366 5497
invoice (draft): removal 54.16 763 6499
invoice accept: apply 41.89 16985 5027
invoice accept: cancel 48.98 760 5878
customer reserve: creation 3858.22 168 462986
customer reserve: removal 4792.02 58 575043
realization accept: apply 83.57 169 10028
realization accept: cancel 99.30 98 11916
payment from customer: creation 60.08 91 7209
payment from customer: removal 5.48 66 657
payment to supplier: creation 48.83 110 5859
payment to supplier: removal 3.28 61 394
service: total inventory turnovers 4.75 918 570
service: total monetary turnovers 6.45 30 774
service: aggregate perf. data 0.83 19665 99
service: refresh index statistics 0.03 336289 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-01-2021 19:27:47 to 12-01-2021 19:27:49.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3139
TEST_TIME 2 4124
TEST_TIME 3 4522
TEST_TIME 4 4526
TEST_TIME 5 4690
TEST_TIME 6 4555
TEST_TIME 7 5327
TEST_TIME 8 5661
TEST_TIME 9 5633
TEST_TIME 10 5818
TEST_TIME 11 5932
TEST_TIME 12 6283
TEST_TIME 13 6194
TEST_TIME 14 6272
TEST_TIME 15 6568
TEST_TIME 16 6702
TEST_TIME 17 7576
TEST_TIME 18 7729
TEST_TIME 19 8432
TEST_TIME 20 8693
TEST_TIME 21 8684
TEST_TIME 22 9125
TEST_TIME 23 9571
TEST_TIME 24 9710
TEST_TIME 25 10001
TEST_TIME 26 10682
TEST_TIME 27 11434
TEST_TIME 28 11046
TEST_TIME 29 10820
TEST_TIME 30 10649
TEST_TIME 31 10498
TEST_TIME 32 10466
TEST_TIME 33 10441
TEST_TIME 34 10347
TEST_TIME 35 10203
TEST_TIME 36 10146
TEST_TIME 37 10123
TEST_TIME 38 9926
TEST_TIME 39 9715
TEST_TIME 40 9844
TEST_TIME 41 9846
TEST_TIME 42 10050
TEST_TIME 43 9944
TEST_TIME 44 9866
TEST_TIME 45 9965
TEST_TIME 46 9990
TEST_TIME 47 9901
TEST_TIME 48 9811
TEST_TIME 49 9790
TEST_TIME 50 9920
TEST_TIME 51 9918
TEST_TIME 52 9887
TEST_TIME 53 10008
TEST_TIME 54 10022
TEST_TIME 55 9879
TEST_TIME 56 9764
TEST_TIME 57 9787
TEST_TIME 58 9683
TEST_TIME 59 9674
TEST_TIME 60 9606
TEST_TIME 61 9496
TEST_TIME 62 9458
TEST_TIME 63 9449
TEST_TIME 64 9415
TEST_TIME 65 9482
TEST_TIME 66 9464
TEST_TIME 67 9415
TEST_TIME 68 9427
TEST_TIME 69 9571
TEST_TIME 70 9540
TEST_TIME 71 9464
TEST_TIME 72 9602
TEST_TIME 73 9680
TEST_TIME 74 9680
TEST_TIME 75 9756
TEST_TIME 76 9689
TEST_TIME 77 9811
TEST_TIME 78 9710
TEST_TIME 79 9632
TEST_TIME 80 9602
TEST_TIME 81 9576
TEST_TIME 82 9584
TEST_TIME 83 9533
TEST_TIME 84 9508
TEST_TIME 85 9500
TEST_TIME 86 9447
TEST_TIME 87 9410
TEST_TIME 88 9421
TEST_TIME 89 9377
TEST_TIME 90 9528
TEST_TIME 91 9496
TEST_TIME 92 9554
TEST_TIME 93 9550
TEST_TIME 94 9525
TEST_TIME 95 9547
TEST_TIME 96 9538
TEST_TIME 97 9561
TEST_TIME 98 9548
TEST_TIME 99 9586
TEST_TIME 100 9585
TEST_TIME 101 9495
TEST_TIME 102 9453
TEST_TIME 103 9437
TEST_TIME 104 9477
TEST_TIME 105 9408
TEST_TIME 106 9394
TEST_TIME 107 9354
TEST_TIME 108 9371
TEST_TIME 109 9348
TEST_TIME 110 9346
TEST_TIME 111 9383
TEST_TIME 112 9381
TEST_TIME 113 9383
TEST_TIME 114 9397
TEST_TIME 115 9396
TEST_TIME 116 9465
TEST_TIME 117 9428
TEST_TIME 118 9452
TEST_TIME 119 9463
TEST_TIME 120 9391

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-01-2021 19:27:51 to 12-01-2021 19:27:54.

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 1555311 1555311 0 0.00 0 16944 6 0 0
doc_list_biud 1555311 1555311 0 0.00 0 48428 27 0 0
sp_add_invoice_to_stock 5091 5027 64 1.25 40 164866 16985 0 64
sp_cancel_adding_invoice 5878 5878 0 0.00 5 51354 760 0 0
sp_cancel_client_order 1766 1766 0 0.00 4 10804 333 0 0
sp_cancel_customer_reserve 575043 575043 0 0.00 1 48430 58 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 2896 67 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 2 5832 62 0 0
sp_cancel_supplier_invoice 6505 6499 6 0.09 2 41718 763 0 6
sp_cancel_supplier_order 424 424 0 0.00 12 993821 100344 0 0
sp_cancel_write_off 11916 11916 0 0.00 1 8366 98 0 0
sp_client_order 20585 20585 0 0.00 3 56765 340 0 0
sp_customer_reserve 462986 462986 0 0.00 0 161131 168 0 0
sp_fill_shopping_cart 31564 31564 0 0.00 1 18235 41 0 0
sp_fill_shopping_cart_clo_res 462981 462981 0 0.00 0 19602 12 0 0
sp_get_clo_for_invoice 5014 5014 0 0.00 0 35067 313 0 0
sp_kill_cost_storno 18845 18845 0 0.00 0 7282 49 0 0
sp_kill_qstorno_ret_qs2qd 1168925 1168925 0 0.00 0 48426 31 0 0
sp_kill_qty_storno 616567 616567 0 0.00 0 48428 68 0 0
sp_lock_selected_doc 20784 20784 0 0.00 0 8921 5 0 0
sp_make_cost_storno 28109 28109 0 0.00 0 16942 46 0 0
sp_multiply_rows_for_pdistr 28109 28109 0 0.00 0 5543 23 0 0
sp_multiply_rows_for_qdistr 20585 20585 0 0.00 0 56759 157 0 0
sp_pay_from_customer 7209 7209 0 0.00 4 11666 92 0 0
sp_pay_to_supplier 5859 5859 0 0.00 5 11894 110 0 0
sp_payment_common 13068 13068 0 0.00 1 11870 23 0 0
sp_qd_handle_on_cancel_clo 1766 1766 0 0.00 0 9729 299 0 0
sp_qd_handle_on_invoice_upd_sts 10891 10891 0 0.00 0 44827 327 0 0
sp_qd_handle_on_reserve_upd_sts 10028 10028 0 0.00 0 15914 54 0 0
sp_reserve_write_off 10028 10028 0 0.00 7 24466 170 0 0
sp_supplier_invoice 5497 5497 0 0.00 5 101044 3366 0 0
sp_supplier_order 5497 5497 0 0.00 4 33415 1271 0 0
srv_aggregate_perf_data 100 99 1 1.00 2442 232810 19665 0 1
srv_fill_mon_cache_memory 157 157 0 0.00 811 206961 35043 0 0
srv_find_qd_qs_mism 1078889 1078889 0 0.00 0 16896 5 0 0
srv_make_invnt_saldo 570 570 0 0.00 29 40708 918 0 0
srv_make_money_saldo 774 774 0 0.00 1 2582 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 215306 499162 336289 0 0
t$perf-abend:sp_add_invoice_to_stock 64 64 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 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 5027 5027 0 0.00 0 38468 173 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 1 5300 75 0 0
t$perf-norm:sp_cancel_client_order 1766 1766 0 0.00 0 4100 12 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 3529 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 893 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 380 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 435 435 0 0.00 0 4271 29 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 24799 1506 0 0
t$perf-norm:sp_cancel_write_off 967 967 0 0.00 0 3905 10 0 0
t$perf-norm:sp_client_order 20585 20585 0 0.00 0 12145 19 0 0
t$perf-norm:sp_customer_reserve 973 973 0 0.00 0 1833 7 0 0
t$perf-norm:sp_pay_from_customer 7209 7209 0 0.00 0 18269 13 0 0
t$perf-norm:sp_pay_to_supplier 5859 5859 0 0.00 0 10227 15 0 0
t$perf-norm:sp_reserve_write_off 10028 10028 0 0.00 0 10231 14 0 0
t$perf-norm:sp_supplier_invoice 5497 5497 0 0.00 0 7303 20 0 0
t$perf-norm:sp_supplier_order 5497 5497 0 0.00 0 7856 19 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 502 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 755 5 0 0
t$perf-norm:srv_make_invnt_saldo 570 570 0 0.00 0 853 20 0 0
t$perf-norm:srv_make_money_saldo 774 774 0 0.00 0 703 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10154 10026 128 1.26 0 10016 21 0 128
v_all_customers 37754 37754 0 0.00 0 16 1 0 0
v_all_suppliers 30248 30248 0 0.00 0 15 1 0 0
v_all_wares 41170 41170 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 2342 14 0 0
v_cancel_client_order 3532 3532 0 0.00 0 10631 8 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 2851 12 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 6095 12 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 107 2 0 0
v_cancel_supplier_invoice 882 870 12 1.36 0 1712 20 0 12
v_cancel_supplier_order 848 848 0 0.00 0 3046 10 0 0
v_cancel_write_off 1934 1934 0 0.00 0 3251 14 0 0
v_max_id_clo_ord 5497 5497 0 0.00 0 1499 1 0 0
v_max_id_clo_res 973 973 0 0.00 0 7200 24 0 0
v_max_id_ord_sup 5481 5481 0 0.00 0 4780 3 0 0
v_max_non_paid_invoice 1713 1713 0 0.00 0 3201 4 0 0
v_max_non_paid_realizn 3718 3718 0 0.00 0 2815 3 0 0
v_min_id_clo_ord 5497 5497 0 0.00 0 5840 7 0 0
v_min_id_clo_res 973 973 0 0.00 0 6871 18 0 0
v_min_id_ord_sup 5481 5481 0 0.00 0 5297 5 0 0
v_min_non_paid_invoice 5859 5859 0 0.00 0 4827 11 0 0
v_min_non_paid_realizn 7209 7209 0 0.00 0 11335 17 0 0
v_our_firm 10398 10398 0 0.00 0 13 1 0 0
v_reserve_write_off 20056 20056 0 0.00 0 11239 10 0 0
x_lock_depdocs_on_canc_invoice 11942 11942 0 0.00 0 11576 116 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 16237 363 0 0
x_make_qstorno_1000_1200 5497 5497 0 0.00 1 33405 1195 0 0
x_make_qstorno_1200_2000 5497 5497 0 0.00 2 101031 3206 0 0
x_make_qstorno_2100_3300 462986 462986 0 0.00 0 158365 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-01-2021 19:27:55 to 12-01-2021 19:27:59.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 16428 8192000000 10268384688 10578575360 935050640 10.244 73 58 117 3 957101600 2619936 19431024
16:57:54 15917 8192000000 10322685184 10645348352 1387847488 14.487 100 82 165 0 1419594048 5240640 26505920
16:58:20 28769 8192000000 10384409856 10707881984 1433039424 14.888 100 86 172 0 1467903760 6717696 28146640
16:59:11 16454 8192000000 10410531664 10739052544 1469440656 15.209 100 93 186 2 1507690624 8110656 30139312
16:59:38 24540 8192000000 10440950864 10773413888 1491776576 15.404 100 88 176 0 1528920576 9076960 28067040
17:00:13 22070 8192000000 10464866944 10798735360 1512192176 15.582 100 91 182 0 1551340608 9614032 29534400
17:00:44 18384 8192000000 10471115744 10809151488 1524819280 15.692 100 86 172 0 1562133104 10161040 27152784
17:01:15 26572 8192000000 10500179376 10843217920 1547335536 15.887 100 83 167 1 1583466528 10342560 25788432
17:01:51 17715 8192000000 10524707872 10873163776 1576167232 16.135 100 84 168 1 1612837680 10788336 25882112
17:02:20 17238 8192000000 10547476080 10898313216 1600976096 16.348 100 89 179 0 1639287488 11220288 27091104
17:02:47 14084 8192000000 10567356016 10926084096 1614960112 16.467 100 72 144 0 1647465408 11149328 21355968
17:03:10 11461 8192000000 10588008240 10947026944 1644240816 16.716 100 74 148 1 1677386640 11450576 21695248
17:03:33 8675 8192000000 10595735056 10961137664 1657540640 16.828 100 71 141 0 1689675104 11324832 20809632
17:03:50 7311 8192000000 10608737808 10982117376 1675182736 16.977 100 74 148 0 1708406064 11923504 21299824
17:04:09 8529 8192000000 10646883184 11016671232 1703172336 17.212 100 76 152 0 1736949856 11929552 21847968
17:04:26 6131 8192000000 10654051872 11027357696 1712624672 17.291 100 78 154 2 1747092448 12285488 22182288
17:04:42 7114 8192000000 10676939440 11051597824 1735598320 17.482 100 74 146 0 1767710960 12327856 19784784
17:04:58 4873 8192000000 10684570192 11061587968 1749498400 17.597 100 76 149 1 1782493024 12669872 20324752
17:05:12 6115 8192000000 10702650112 11081576448 1761974096 17.701 100 74 144 1 1795325776 12703888 20647792
17:05:25 4124 8192000000 10715940736 11096092672 1778571344 17.838 100 79 156 1 1813383712 13045696 21766672
17:05:36 4435 8192000000 10704504032 11092365312 1777359168 17.828 100 72 144 0 1810747920 13398672 19990080
17:05:48 2624 8192000000 10724523136 11111837696 1784698864 17.888 100 77 151 0 1818376848 12400656 21277328
17:05:57 3927 8192000000 10739137984 11128393728 1803775184 18.045 100 74 148 3 1836868800 11898656 21194960
17:06:08 2561 8192000000 10743614496 11133988864 1816308752 18.148 100 77 154 0 1850542928 11680880 22553296
17:06:17 2410 8192000000 10758248288 11144646656 1823004720 18.202 100 82 166 3 1857611664 11791520 22815424
17:06:26 2563 8192000000 10754267120 11145773056 1826117856 18.228 100 87 174 0 1863527440 12547680 24861904
17:06:35 2221 8192000000 10776737072 11161804800 1831419408 18.271 100 87 174 0 1869218928 13218112 24581408
17:06:44 1592 8192000000 10785575328 11170217984 1837326992 18.319 100 93 187 1 1878185744 14824768 26033984
17:06:52 1972 8192000000 10787540032 11175084032 1842297648 18.360 100 91 183 0 1883332608 15008784 26026176
17:07:00 1286 8192000000 10796543184 11179565056 1848822288 18.413 100 91 184 2 1889219664 15090416 25306960
17:07:08 2034 8192000000 10791222960 11181522944 1852037856 18.439 100 89 178 2 1891683984 13689376 25956752
17:07:16 1750 8192000000 10805941424 11191099392 1858336464 18.490 100 94 187 0 1897994592 12681792 26976336
17:07:24 1469 8192000000 10811242144 11196416000 1862527728 18.524 100 91 181 3 1901488560 12470048 26490784
17:07:32 1692 8192000000 10804720880 11191037952 1867807024 18.567 100 96 193 1 1908426048 12681152 27937872
17:07:40 1779 8192000000 10815292704 11202347008 1869800304 18.583 100 94 193 3 1909979936 11887616 28292016
17:07:48 1542 8192000000 10797156480 11202301952 1868540592 18.572 100 72 144 2 1903377136 13859760 20976784
17:07:56 36143 8192000000 10781357568 11197198336 1862590368 18.524 100 46 89 0 1883013616 8306656 12116592
17:08:40 6759 8192000000 10781601264 11204210688 1865021840 18.544 100 38 76 1 1885028320 9194976 10811504
17:08:55 3396 8192000000 10804579760 11212787712 1873817296 18.615 100 46 93 1 1898313696 11911456 12584944
17:09:10 7162 8192000000 10783358896 11204120576 1866921408 18.559 100 25 50 0 1880524352 6509008 7093936
17:09:24 4123 8192000000 10784156544 11205267456 1869556640 18.581 100 36 72 1 1887919136 8095216 10267280
17:09:35 7317 8192000000 10785396320 11212734464 1873905824 18.616 100 31 62 3 1889759040 7362480 8490736
17:09:49 9554 8192000000 10783195696 11208343552 1871241328 18.594 100 20 40 1 1883032224 6105072 5685824
17:10:07 8057 8192000000 10786644608 11216240640 1874921696 18.624 100 24 46 2 1891585072 10710816 5952560
17:10:22 5158 8192000000 10801933472 11219693568 1876743184 18.639 100 32 65 1 1893142816 6577984 9821648
17:10:33 9147 8192000000 10800989552 11224825856 1878758816 18.655 100 31 62 0 1895747872 8269232 8719824
17:10:49 7324 8192000000 10789473184 11221020672 1882551280 18.686 100 23 45 2 1895532400 6275120 6706000
17:11:02 7205 8192000000 10785725056 11221815296 1885644160 18.711 100 19 37 2 1897170864 6330752 5195952
17:11:16 13789 8192000000 10801133952 11227668480 1886805248 18.720 100 22 44 1 1899637344 6251728 6580368
17:11:36 19691 8192000000 10803734448 11232477184 1891089536 18.755 100 23 46 1 1903709248 5930592 6689120
17:12:03 58373 8192000000 10809569392 11245264896 1891204896 18.755 100 16 32 0 1901070368 4673120 5192352
17:13:10 8285 8192000000 10818712000 11252551680 1902516688 18.847 100 27 54 2 1916044016 6273760 7253568
17:13:25 5018 8192000000 10835568352 11261886464 1904839648 18.865 100 37 74 2 1926868064 11998384 10030032
17:13:37 4378 8192000000 10822390000 11255250944 1905513232 18.871 100 33 66 1 1922529072 7279264 9736576
17:13:47 4953 8192000000 10818545584 11255033856 1906323808 18.877 100 31 62 0 1921909696 6768304 8817584
17:14:00 4968 8192000000 10829823120 11259502592 1913414720 18.934 100 29 56 2 1928418608 6289600 8714288
17:14:14 4414 8192000000 10833905920 11264098304 1909714160 18.904 100 20 40 0 1921089360 5611152 5764048
17:14:25 5220 8192000000 10832272272 11262521344 1912211376 18.924 100 33 66 1 1928649040 7533104 8904560
17:14:36 5786 8192000000 10825373280 11260538880 1911456272 18.918 100 18 36 1 1922612864 6146720 5009872
17:14:48 7733 8192000000 10825940160 11264016384 1915074480 18.947 100 24 48 2 1927388320 5876112 6437728
17:15:02 7970 8192000000 10830264000 11267457024 1914022080 18.939 100 22 44 1 1925771024 5388256 6360688
17:15:18 8079 8192000000 10812421696 11247702016 1870904592 18.592 98 16 31 3 1881000800 5970944 4125264
17:15:35 6221 8192000000 10818471584 11250257920 1902878016 18.849 100 28 56 1 1917573520 6035856 8659648
17:15:50 10788 8192000000 10828872736 11250122752 1871383792 18.595 98 11 22 1 1879957328 5227536 3346000
17:16:09 7432 8192000000 10810610128 11247210496 1871426224 18.596 98 26 50 1 1884702688 5908784 7367680
17:16:22 11460 8192000000 10806319936 11237437440 1878670976 18.654 99 17 32 0 1892672576 9712048 4289552
17:16:40 57818 8192000000 10803870032 11227312128 1820981152 18.186 96 29 57 1 1835709104 5499456 9228496
17:17:44 11861 8192000000 10793500000 11212963840 1850451072 18.426 98 53 106 0 1872000560 5358784 16190704
17:18:03 12747 8192000000 10742367184 11171504128 1757464176 17.663 94 14 28 0 1767192416 5700880 4027360
17:18:23 9763 8192000000 10764148224 11194155008 1845840832 18.388 100 33 66 2 1861626496 6877472 8908192
17:18:43 2172 8192000000 10786921216 11202985984 1856881664 18.478 100 55 110 3 1886177984 11922016 17374304
17:18:54 8424 8192000000 10736465072 11154575360 1785117440 17.892 97 41 82 0 1804180208 7154464 11908304
17:19:09 5728 8192000000 10723866304 11141140480 1739646384 17.516 95 30 60 0 1754884048 5875600 9362064
17:19:23 6128 8192000000 10736127712 11148210176 1775888128 17.816 98 25 50 2 1789033456 5852288 7293040
17:19:36 5932 8192000000 10715009664 11125936128 1734838640 17.476 96 31 61 3 1750197824 6349360 9009824
17:19:50 6954 8192000000 10668494112 11083517952 1707570720 17.248 96 34 68 0 1723644960 5697632 10376608
17:20:03 5188 8192000000 10688150848 11096109056 1756218976 17.653 99 27 54 2 1769099264 5227568 7652720
17:20:15 5137 8192000000 10690532512 11107332096 1751141776 17.611 98 26 52 2 1765048736 6440400 7466560
17:20:27 7476 8192000000 10689656448 11104088064 1750773920 17.608 98 28 56 1 1765130288 6498448 7857920
17:20:41 12119 8192000000 10692380736 11114184704 1781551712 17.862 99 29 58 0 1795942880 5681408 8709760
17:21:02 9017 8192000000 10701145616 11119976448 1750940400 17.609 97 23 45 3 1762296944 4754304 6602240
17:21:17 7448 8192000000 10724682672 11139186688 1795418288 17.976 100 15 30 0 1805362128 5632128 4311712
17:21:43 54003 8192000000 10756109296 11152592896 1800826256 18.021 99 29 58 1 1814953728 6272832 7854640
17:22:44 20809 8192000000 10725116976 11152764928 1801928176 18.030 99 18 36 0 1812724000 5391456 5404368
17:23:11 8743 8192000000 10745758624 11164758016 1825273968 18.221 100 28 56 0 1839780528 6778784 7727776
17:23:26 5081 8192000000 10751452400 11171024896 1829514112 18.255 100 39 78 0 1847411072 6823808 11073152
17:23:37 6127 8192000000 10760813024 11178602496 1837260688 18.319 100 36 72 0 1854679792 7454112 9964992
17:23:51 5932 8192000000 10759979632 11184070656 1844586464 18.378 100 32 64 1 1860798048 6741328 9470256
17:24:04 5921 8192000000 10762516464 11186954240 1845325424 18.384 100 34 67 3 1861089696 5674176 10090096
17:24:18 8489 8192000000 10762214352 11192770560 1851450400 18.434 100 24 48 0 1864536032 5799776 7285856
17:24:39 8110 8192000000 10771659184 11200049152 1857138528 18.480 100 30 60 2 1872319808 5787200 9394080
17:24:55 6875 8192000000 10769230816 11197067264 1857582896 18.484 100 27 53 0 1871662432 5512752 8566784
17:25:08 7175 8192000000 10772700960 11198287872 1857825360 18.486 100 29 59 2 1871145424 4814032 8506032
17:25:22 13270 8192000000 10778691040 11210493952 1865156384 18.545 100 18 36 1 1875837408 5642960 5038064
17:25:45 16090 8192000000 10790862528 11216658432 1868624352 18.573 100 17 35 2 1878930992 5513824 4792816
17:26:13 10273 8192000000 10789772832 11217678336 1872467488 18.604 100 24 48 2 1885655328 5452784 7735056
17:26:32 102838 8192000000 10823015824 11239751680 1888169616 18.731 100 46 92 2 1907327904 4858160 14300128
17:28:24 36476 8192000000 10839367184 11265347584 1911589760 18.919 100 49 99 0 1935595664 9446288 14559616
17:29:08 7320 8192000000 10864281728 11283275776 1928400576 19.054 100 52 104 0 1954953840 11566048 14987216
17:29:22 9471 8192000000 10866431536 11290972160 1940050672 19.147 100 60 113 0 1968293760 11756848 16486240
17:29:39 37873 8192000000 10875395280 11296669696 1938506256 19.135 100 52 102 3 1965823536 12754992 14562288
17:30:25 11319 8192000000 10887611344 11308711936 1943675568 19.176 100 54 107 0 1972198224 13595536 14927120
17:30:43 32375 8192000000 10875453680 11314774016 1951131280 19.235 100 41 80 3 1978138544 14589424 12417840
17:31:23 9981 8192000000 10897415808 11323953152 1961466736 19.318 100 48 96 2 1990361456 14110656 14784064
17:31:42 6405 8192000000 10894930176 11322609664 1946511456 19.199 99 56 110 3 1978577744 15785072 16281216
17:32:02 24446 8192000000 10906693264 11335479296 1969115296 19.378 100 51 101 1 2001831296 18067904 14648096
17:32:36 18385 8192000000 10894599632 11334672384 1967497184 19.366 100 40 76 1 1996268336 16825056 11946096
17:33:01 17958 8192000000 10922973776 11347623936 1980625712 19.470 100 49 98 4 2012057424 17316336 14115376
17:33:28 7533 8192000000 10929253248 11355889664 1979394400 19.460 100 49 98 1 2013206432 18766288 15045744
17:34:00 33032 8192000000 10919475760 11352662016 1978681312 19.454 100 43 86 3 2013522416 21624016 13217088
17:34:44 35333 8192000000 10910897184 11353677824 1964611760 19.343 99 40 80 4 1997304688 19789328 12903600
17:35:27 20427 8192000000 10925244480 11365830656 1986581616 19.517 100 32 64 0 2014623056 18139696 9901744
17:35:55 2284 8192000000 10948301568 11368747008 1993943296 19.575 100 73 140 3 2032152032 17994256 20214480
17:36:05 7038 8192000000 10950574016 11377766400 1999858416 19.622 100 63 126 2 2038748896 19967312 18923168
17:36:20 2628 8192000000 10959997280 11384172544 2005261072 19.664 100 70 140 2 2047529744 20775280 21493392
17:36:32 6691 8192000000 10957058960 11381301248 2002778544 19.645 100 71 142 2 2047049680 22623248 21647888
17:36:51 11531 8192000000 10959302736 11382927360 1990033632 19.544 99 64 128 1 2031891328 22874784 18982912
17:37:09 12870 8192000000 10962342928 11386630144 2006103216 19.671 100 66 131 1 2049485712 24252320 19130176
17:37:29 2693 8192000000 10979589936 11399405568 2012852032 19.724 100 68 135 1 2057517200 25181072 19484096
17:37:40 4242 8192000000 10969257824 11400843264 2013254736 19.727 100 62 123 1 2056687808 25197040 18236032
17:37:52 4012 8192000000 10975866560 11403096064 2019909856 19.779 100 79 156 1 2068765408 25577696 23277856
17:38:04 6022 8192000000 10969893136 11398733824 2001574960 19.635 99 66 130 0 2047194960 25886000 19734000
17:38:20 4563 8192000000 10965131632 11396866048 1997465584 19.603 99 63 122 1 2042223792 26777392 17980816
17:38:34 4258 8192000000 10982210336 11407253504 2019505088 19.776 100 66 132 0 2068744896 29474016 19765792
17:38:49 9525 8192000000 10965192128 11399409664 1997358624 19.602 99 60 119 1 2049144544 33091952 18693968
17:39:06 2418 8192000000 10975919488 11407376384 2012898288 19.724 100 69 138 2 2068226272 33954752 21373232
17:39:15 12541 8192000000 10979530816 11411161088 2012028048 19.717 100 65 129 1 2069097856 35093488 21976320
17:39:43 4396 8192000000 10978424448 11409993728 2007824096 19.684 100 62 123 1 2062730992 35661440 19245456
17:39:57 1710 8192000000 10996084336 11412172800 2000908624 19.630 99 76 153 0 2061342656 37021360 23412672
17:40:06 2905 8192000000 11008484000 11424043008 2021506896 19.792 100 78 154 0 2082688528 36556496 24625136
17:40:17 4946 8192000000 10994483696 11417464832 2014204672 19.735 100 71 143 1 2075272768 39313520 21754576
17:40:31 1225 8192000000 10995416688 11409686528 2000585872 19.627 99 88 175 0 2067397024 40244448 26566704
17:40:41 2241 8192000000 11009404944 11428757504 2023762560 19.810 100 92 184 2 2094998352 42703088 28532704
17:40:51 4073 8192000000 11005391264 11424346112 2020884448 19.787 100 89 176 2 2091207968 43641584 26681936
17:41:02 3379 8192000000 10998550640 11415515136 1999858160 19.622 99 84 168 0 2070357792 44698640 25800992
17:41:13 3891 8192000000 11010006416 11429003264 2020689520 19.786 100 87 171 1 2092674464 44438880 27546064
17:41:31 4804 8192000000 10997879968 11421200384 2014997136 19.741 100 80 160 0 2085237536 45391664 24848736
17:41:43 5700 8192000000 10995153296 11417092096 2010205904 19.703 100 70 135 0 2076891456 45159952 21525600
17:41:55 11226 8192000000 10990072128 11411456000 1976355360 19.436 98 79 158 1 2048431696 47743424 24332912
17:42:20 2271 8192000000 11002363936 11419422720 1996725584 19.597 99 81 160 1 2069366000 47106112 25534304
17:42:29 2414 8192000000 11001469520 11421175808 2010587184 19.706 100 81 162 1 2085162192 48099408 26475600
17:42:38 4350 8192000000 10999234624 11419291648 2010302240 19.704 100 78 155 1 2082268784 46886048 25080496
17:42:55 3231 8192000000 10998420016 11416514560 2007268384 19.680 100 69 137 2 2077727088 48712816 21745888
17:43:08 4363 8192000000 10994950336 11422543872 2014322608 19.736 100 77 150 0 2086161376 47769104 24069664
17:43:19 1882 8192000000 11011737456 11426664448 2016246816 19.751 100 75 149 0 2088349344 49467504 22635024
17:43:28 1806 8192000000 11025606832 11435859968 2018262416 19.766 100 88 175 1 2099885152 54134288 27488448
17:43:38 1532 8192000000 11021971312 11432779776 2016938528 19.756 100 88 175 2 2099213776 54466208 27809040
17:43:48 3157 8192000000 11010086784 11432448000 2013227264 19.727 100 73 146 0 2092541328 55909504 23404560
17:43:59 4248 8192000000 11013856272 11440844800 2020131664 19.781 100 76 151 2 2102905120 57809504 24963952
17:44:10 1652 8192000000 10992461424 11417858048 1998758768 19.613 99 72 145 0 2080433184 57979536 23694880
17:44:22 1710 8192000000 11025322016 11442634752 2014627168 19.738 100 82 164 2 2098853632 57448336 26778128
17:44:30 808 8192000000 11009841376 11421720576 1992946128 19.567 99 86 170 1 2078593776 58379088 27268560
17:44:38 3725 8192000000 11008921616 11431710720 2014090000 19.734 100 78 155 1 2090192992 51527824 24575168
17:44:48 2003 8192000000 11006798832 11434536960 2017654752 19.762 100 73 147 0 2093842720 52664288 23523680
17:44:59 5736 8192000000 10997997920 11431194624 2015477840 19.745 100 62 122 0 2085301792 49978256 19845696
17:45:15 7496 8192000000 10989381328 11428397056 2007851840 19.685 100 53 105 2 2078145200 52270560 18022800
17:45:39 9374 8192000000 10940043520 11379929088 1933367280 19.094 97 40 80 2 2000504752 52442832 14694640
17:45:57 12507 8192000000 10955733760 11391139840 1963947200 19.337 99 41 82 2 2033122032 54612112 14562720
17:46:18 8080 8192000000 10989364384 11414421504 1988176128 19.529 100 60 120 2 2066584080 58068704 20339248
17:46:38 4924 8192000000 10989663584 11413168128 1979846736 19.463 99 80 159 0 2059013104 53572656 25593712
17:46:50 9044 8192000000 10978024480 11422171136 1998108960 19.608 100 53 106 2 2067674416 52517600 17047856
17:47:12 3411 8192000000 10980013888 11416637440 2002406576 19.642 100 59 115 2 2064742672 43328448 19007648
17:47:23 11398 8192000000 10968995904 11415863296 1998849504 19.614 100 37 75 1 2056133728 44822624 12461600
17:47:50 19976 8192000000 10967667552 11422699520 1998063584 19.607 100 30 60 1 2054763184 46515296 10184304
17:48:16 15689 8192000000 10969716048 11421622272 1995317584 19.586 100 34 68 3 2054738208 47608128 11812496
17:48:46 16591 8192000000 10967162944 11418419200 1992568112 19.564 100 35 70 1 2054697200 50145472 11983616
17:49:12 21202 8192000000 10967344864 11418943488 1987514256 19.524 100 35 70 1 2054099664 54042416 12542992
17:49:40 28341 8192000000 10937290656 11388084224 1925995600 19.035 97 29 59 1 1988277376 52854112 9427664
17:50:16 20447 8192000000 10932792368 11392098304 1942585840 19.167 99 25 50 1 1998532176 47453232 8493104
17:50:44 27387 8192000000 10933806240 11386261504 1924457936 19.023 98 22 44 2 1976451232 44420448 7572848
17:51:19 24979 8192000000 10940640112 11390750720 1956138928 19.275 100 26 52 0 2017232304 52336304 8757072
17:51:50 26296 8192000000 10918595584 11379032064 1921293136 18.997 98 24 49 4 1983978144 54020928 8664080
17:52:24 11401 8192000000 10922968416 11369385984 1943113104 19.172 100 29 58 0 2006590048 53894016 9582928
17:52:51 15191 8192000000 10901421136 11347931136 1897267504 18.804 98 17 34 0 1956095392 52175632 6652256
17:53:13 9317 8192000000 10891304880 11350876160 1895159392 18.787 99 18 36 3 1956352896 54845968 6347536
17:53:33 16158 8192000000 10865549504 11328499712 1890092464 18.747 99 11 22 0 1943656464 49404112 4159888
17:53:55 22973 8192000000 10851011984 11291549696 1839950832 18.340 96 23 44 3 1878147648 30806784 7390032
17:54:25 66144 8192000000 10846250720 11306438656 1914114592 18.940 100 23 44 0 1929855312 9324816 6415904
17:55:54 57161 8192000000 10868898208 11322376192 1934648656 19.104 100 41 81 0 1959329152 12454768 12225728
17:56:58 45057 8192000000 10852738656 11304169472 1901130288 18.835 98 36 72 1 1921510528 9894464 10485776
17:58:35 62643 8192000000 10900636448 11342794752 1948676736 19.216 100 39 78 1 1969617600 10229568 10711296
17:59:44 43813 8192000000 10821034160 11283042304 1823007792 18.202 94 16 32 0 1834960624 7981984 3970848
18:00:34 39619 8192000000 10835310048 11292196864 1878915632 18.656 98 11 22 0 1887340288 5583264 2841392
18:01:20 29816 8192000000 10852380768 11306336256 1931945648 19.082 100 15 30 0 1943053568 6919568 4188352
18:01:56 69691 8192000000 10846323952 11299057664 1900327984 18.829 98 16 32 0 1913909536 8668352 4913200
18:03:12 44549 8192000000 10877794672 11330486272 1941219456 19.156 100 21 40 1 1960866992 13613392 6034144
18:04:07 206961 8192000000 10886784384 11352092672 1917336896 18.966 98 15 30 1 1941534416 19851904 4345616
18:07:40 29946 8192000000 10877458448 11354046464 1931370688 19.078 99 17 34 0 1953912000 17083200 5458112
18:08:21 18789 8192000000 10882699008 11368415232 1949090512 19.219 100 6 12 0 1973576256 22615744 1870000
18:08:50 61879 8192000000 10878007744 11370582016 1934022000 19.099 99 6 13 1 1958068224 22353856 1692368
18:10:07 66353 8192000000 10904712992 11356729344 1964640528 19.343 100 13 26 0 1982254048 13948048 3665472
18:11:27 48189 8192000000 10896234672 11357749248 1952752064 19.248 99 44 88 0 1978359344 12367104 13240176
18:12:37 84366 8192000000 10891694368 11372773376 1962117968 19.323 100 10 20 0 1980805104 15473872 3213264
18:14:08 93485 8192000000 10912913776 11374256128 1980158352 19.466 100 19 38 0 1998293680 13165072 4970256
18:15:49 18539 8192000000 10940884976 11375235072 1988473728 19.532 100 66 131 4 2018883120 10844832 19564560
18:16:16 17341 8192000000 10917233120 11367383040 1965520064 19.350 99 33 66 0 1987332064 12581184 9230816
18:16:40 47748 8192000000 10891601888 11375013888 1963130320 19.331 99 25 50 2 1986227216 15784784 7312112
18:17:42 82908 8192000000 10880355424 11346030592 1859175824 18.497 94 11 22 1 1876326192 14294384 2855984
18:21:20 125633 8192000000 10906068192 11356135424 1944842400 19.185 99 12 23 1 1961009568 13173632 2993536
18:23:37 84981 8192000000 10891299936 11363917824 1934842432 19.106 98 16 32 0 1951441632 11788320 4810880
18:25:20 9218 8192000000 10888595712 11357663232 1959844624 19.305 100 27 54 1 1980272032 12944240 7483168
18:25:35 23090 8192000000 10899309488 11347632128 1947313840 19.205 99 37 75 1 1967241696 9339616 10588240
18:26:06 32557 8192000000 10865231920 11331702784 1933762432 19.097 99 38 76 0 1955692096 11082272 10847392
18:26:49 33938 8192000000 10849588256 11324231680 1924618208 19.024 99 18 36 0 1937052816 7111424 5323184
18:27:41 81281 8192000000 10880013312 11347312640 1927124432 19.044 98 14 28 0 1945106848 13968944 4013472
18:29:23 67361 8192000000 10875575056 11361656832 1960484256 19.310 100 15 30 0 1975289648 9971856 4833536
18:30:54 47894 8192000000 10889602160 11359559680 1947491808 19.206 99 12 24 0 1957611824 7045872 3074144
18:31:48 76849 8192000000 10871116256 11340591104 1889353744 18.741 96 17 35 0 1902212144 7867328 4991072
18:33:13 67764 8192000000 10923720432 11386028032 1976808320 19.439 100 17 34 0 1994015552 12083008 5124224
18:34:28 47225 8192000000 10925279104 11385774080 1983514448 19.493 100 30 60 1 2008023200 14687056 9821696
18:35:22 82309 8192000000 10913454368 11388170240 1962898368 19.329 99 12 24 0 1983744368 17264112 3581888
18:36:52 91379 8192000000 10905926832 11357335552 1893344928 18.773 95 28 56 1 1911144976 9464176 8335872
18:38:29 37629 8192000000 10895136112 11353968640 1930795984 19.073 98 47 94 0 1960922576 16645056 13481536
18:39:34 56706 8192000000 10887870560 11341660160 1844883072 18.381 94 16 32 0 1862955184 13596560 4475552
18:40:42 141497 8192000000 10868214432 11324760064 1793017584 17.957 92 18 33 1 1816036576 18096032 4922960
18:43:11 25088 8192000000 10865674624 11311325184 1890808816 18.752 98 20 40 1 1903780768 7715152 5256800
18:43:43 2491 8192000000 10886823552 11324203008 1920569520 18.991 99 57 114 1 1946219712 8832336 16817856
18:44:21 116869 8192000000 10866100928 11328655360 1929531584 19.063 99 19 38 0 1952308032 17586976 5189472
18:46:29 86059 8192000000 10878873536 11347251200 1902154176 18.844 97 32 64 1 1921872288 10860704 8857408
18:48:22 22414 8192000000 10871546608 11338723328 1929152272 19.060 99 23 46 0 1951255536 15017136 7086128
18:48:51 26746 8192000000 10862177376 11329916928 1911743904 18.921 99 17 34 1 1930669936 13694464 5231568
18:49:30 44749 8192000000 10854986240 11330252800 1903298752 18.853 98 18 36 1 1918402640 10197952 4905936
18:50:28 39524 8192000000 10852484912 11328995328 1910389696 18.910 99 10 20 0 1927076384 13661904 3024784
18:51:14 55217 8192000000 10849756384 11319902208 1916571952 18.959 99 13 26 1 1928497984 8410112 3515920
18:52:19 31689 8192000000 10863613504 11332014080 1938821632 19.137 100 8 17 0 1947181584 6473408 1886544
18:53:13 76118 8192000000 10863927872 11332210688 1918709888 18.977 98 18 36 0 1934436576 10633328 5093360
18:54:36 66480 8192000000 10860334032 11331477504 1874329520 18.619 96 8 16 0 1892508240 15607360 2571360
18:55:49 34261 8192000000 10855411792 11321995264 1881205280 18.675 97 14 27 0 1901240224 15312576 4722368
18:56:29 54791 8192000000 10878683152 11336757248 1921470160 18.999 99 27 54 0 1945654688 16613600 7570928
18:58:01 42877 8192000000 10878726544 11335090176 1915305872 18.949 98 24 44 2 1930815392 8929600 6579920
18:59:04 50945 8192000000 10860842144 11325485056 1885145488 18.707 97 30 60 1 1905434064 12211680 8076896
19:00:04 81907 8192000000 10876832688 11332694016 1883975760 18.697 97 14 28 0 1899560608 11722752 3862096
19:01:34 23607 8192000000 10901789152 11344769024 1956037520 19.275 100 41 82 0 1976213392 8867168 11308704
19:02:08 63839 8192000000 10902740464 11367911424 1964264448 19.340 100 43 86 0 1993163600 17325024 11574128
19:03:22 39278 8192000000 10897283536 11369771008 1968805744 19.376 100 24 48 0 1986562576 11376192 6380640
19:04:07 69554 8192000000 10887579200 11358126080 1941942240 19.162 99 13 26 2 1957124976 11516864 3665872
19:05:24 73572 8192000000 10878462192 11340550144 1862133856 18.521 95 14 28 1 1876846912 10823504 3889552
19:06:50 86232 8192000000 10864641104 11345293312 1912706512 18.928 98 8 16 0 1929179296 14248176 2224608
19:08:23 131602 8192000000 10889737408 11344879616 1886235296 18.715 96 35 70 2 1908548384 12223104 10089984
19:10:40 69977 8192000000 10860791648 11358105600 1910666736 18.912 98 14 28 0 1932390864 18268160 3455968
19:12:02 66015 8192000000 10871960912 11355009024 1928206640 19.053 99 7 14 0 1944221120 14261232 1753248
19:13:21 45532 8192000000 10874684112 11343847424 1930731152 19.073 99 9 18 1 1946265648 12866560 2667936
19:14:13 73674 8192000000 10900214912 11355201536 1946016752 19.195 99 17 34 0 1960613168 9745488 4850928
19:15:36 50357 8192000000 10888724720 11355942912 1906297648 18.877 97 7 14 0 1917909440 9915632 1696160
19:16:39 38537 8192000000 10881502448 11342901248 1900986560 18.834 97 14 28 2 1913123712 7643904 4493248
19:17:23 103164 8192000000 10880070112 11346186240 1886190928 18.715 96 13 26 1 1898533904 8533904 3809072
19:19:14 40157 8192000000 10877216224 11342229504 1929297920 19.061 99 25 50 1 1946200544 9683376 7219248
19:20:07 42132 8192000000 10884515904 11339280384 1923277136 19.013 98 27 54 1 1938714192 8166608 7270448
19:20:55 50989 8192000000 10891815488 11360829440 1959704720 19.304 100 20 40 1 1978609584 12956384 5948480
19:21:54 82303 8192000000 10888146128 11353563136 1903207168 18.852 97 11 22 1 1919558592 13061184 3290240
19:23:38 69224 8192000000 10913993152 11354554368 1898294096 18.813 97 18 35 1 1915104448 11637856 5172496
19:24:56 58781 8192000000 10902574816 11372007424 1945640224 19.192 99 32 64 3 1965738928 10982480 9116224
19:26:02 80492 8192000000 9121603120 9352597504 265391600 3.137 14 3 6 0 268197600 2109184 696816

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 12-01-2021 19:28:01 to 12-01-2021 19:28:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 64 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-01-2021 19:28:33 to 12-01-2021 19:28:35.

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          242381
MON$OLDEST_ACTIVE               242382
MON$OLDEST_SNAPSHOT             242382
MON$NEXT_TRANSACTION            242382
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                       2020928
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 ---
:775: 
:776: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:777:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:778: 
:779: 
:780: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:781:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:782: 
:783: 
:784: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:785:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:786: 
:787: 
:788: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:789:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:790: 
:791: 
:792: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:793:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:794: 
:795: 
:796: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:797:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:798: 
:799: 
:800: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:801:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:802: 
:803: 
:804: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:805:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:806: 
:807: 
:808: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:809:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:810: 
:811: 
:812: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:813:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:814: 
:815: 
:816: mscs-test-161.budzdorov.ru    Tue Jan 12 19:27:24 2021
:817:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:818: 
--- end of diff output ---

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

12.01.21 19:28:36. 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-12 19:28:38 No severe PSQL-related problems occured
12.01.21 19:28:39. End of report.