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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17050572 kB
MemAvailable 31172232 kB
Buffers 0 kB
Cached 14625132 kB
SwapCached 4780 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-02-10 01:27:14
DTS_END                         2021-02-10 01:27:14.4850
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60572
TRN_ID                          238384
ATT_ID                          643
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: 9061.41 28698 1087369
customer order: creation 166.72 369 20006
customer order: refuse 13.95 353 1674
order to supplier: creation 46.04 1253 5525
order to supplier: removal 3.30 119380 396
invoice (draft): creation 44.13 3445 5295
invoice (draft): removal 53.59 861 6431
invoice accept: apply 39.95 18703 4794
invoice accept: cancel 48.08 872 5769
customer reserve: creation 3673.50 185 440820
customer reserve: removal 4679.09 65 561491
realization accept: apply 80.38 189 9645
realization accept: cancel 85.80 117 10296
payment from customer: creation 56.83 115 6819
payment from customer: removal 5.35 74 642
payment to supplier: creation 48.93 113 5872
payment to supplier: removal 3.32 105 398
service: total inventory turnovers 4.98 1009 598
service: total monetary turnovers 6.63 30 796
service: aggregate perf. data 0.82 20010 98
service: refresh index statistics 0.03 406709 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-02-2021 01:28:31 to 10-02-2021 01:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4827
TEST_TIME 2 5434
TEST_TIME 3 5259
TEST_TIME 4 5165
TEST_TIME 5 5430
TEST_TIME 6 5388
TEST_TIME 7 5717
TEST_TIME 8 5732
TEST_TIME 9 5663
TEST_TIME 10 5963
TEST_TIME 11 6053
TEST_TIME 12 6265
TEST_TIME 13 6534
TEST_TIME 14 6848
TEST_TIME 15 7061
TEST_TIME 16 7233
TEST_TIME 17 7552
TEST_TIME 18 7832
TEST_TIME 19 8415
TEST_TIME 20 8736
TEST_TIME 21 8513
TEST_TIME 22 8414
TEST_TIME 23 8760
TEST_TIME 24 8783
TEST_TIME 25 8984
TEST_TIME 26 9174
TEST_TIME 27 9708
TEST_TIME 28 11307
TEST_TIME 29 11102
TEST_TIME 30 10812
TEST_TIME 31 10560
TEST_TIME 32 10756
TEST_TIME 33 10504
TEST_TIME 34 10485
TEST_TIME 35 10462
TEST_TIME 36 10284
TEST_TIME 37 10281
TEST_TIME 38 10191
TEST_TIME 39 10089
TEST_TIME 40 9986
TEST_TIME 41 10046
TEST_TIME 42 9947
TEST_TIME 43 9800
TEST_TIME 44 9763
TEST_TIME 45 9734
TEST_TIME 46 9604
TEST_TIME 47 9590
TEST_TIME 48 9601
TEST_TIME 49 9508
TEST_TIME 50 9390
TEST_TIME 51 9347
TEST_TIME 52 9261
TEST_TIME 53 9405
TEST_TIME 54 9355
TEST_TIME 55 9408
TEST_TIME 56 9422
TEST_TIME 57 9385
TEST_TIME 58 9418
TEST_TIME 59 9459
TEST_TIME 60 9439
TEST_TIME 61 9435
TEST_TIME 62 9484
TEST_TIME 63 9618
TEST_TIME 64 9648
TEST_TIME 65 9651
TEST_TIME 66 9626
TEST_TIME 67 9622
TEST_TIME 68 9505
TEST_TIME 69 9466
TEST_TIME 70 9422
TEST_TIME 71 9349
TEST_TIME 72 9349
TEST_TIME 73 9313
TEST_TIME 74 9298
TEST_TIME 75 9321
TEST_TIME 76 9255
TEST_TIME 77 9205
TEST_TIME 78 9216
TEST_TIME 79 9205
TEST_TIME 80 9184
TEST_TIME 81 9184
TEST_TIME 82 9240
TEST_TIME 83 9295
TEST_TIME 84 9298
TEST_TIME 85 9347
TEST_TIME 86 9336
TEST_TIME 87 9311
TEST_TIME 88 9371
TEST_TIME 89 9373
TEST_TIME 90 9446
TEST_TIME 91 9388
TEST_TIME 92 9299
TEST_TIME 93 9273
TEST_TIME 94 9270
TEST_TIME 95 9214
TEST_TIME 96 9169
TEST_TIME 97 9209
TEST_TIME 98 9183
TEST_TIME 99 9197
TEST_TIME 100 9169
TEST_TIME 101 9151
TEST_TIME 102 9205
TEST_TIME 103 9195
TEST_TIME 104 9370
TEST_TIME 105 9387
TEST_TIME 106 9363
TEST_TIME 107 9381
TEST_TIME 108 9356
TEST_TIME 109 9351
TEST_TIME 110 9291
TEST_TIME 111 9267
TEST_TIME 112 9236
TEST_TIME 113 9225
TEST_TIME 114 9182
TEST_TIME 115 9157
TEST_TIME 116 9128
TEST_TIME 117 9133
TEST_TIME 118 9112
TEST_TIME 119 9137
TEST_TIME 120 9067

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-02-2021 01:28:34 to 10-02-2021 01:28:38.

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 1496254 1496254 0 0.00 0 33382 6 0 0
doc_list_biud 1496254 1496254 0 0.00 0 44977 31 0 0
sp_add_invoice_to_stock 4952 4794 158 3.19 35 211727 18704 0 158
sp_cancel_adding_invoice 5769 5769 0 0.00 6 51080 872 0 0
sp_cancel_client_order 1674 1674 0 0.00 4 16904 353 0 0
sp_cancel_customer_reserve 561491 561491 0 0.00 1 32680 66 0 0
sp_cancel_pay_from_customer 642 642 0 0.00 3 2663 74 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 8784 105 0 0
sp_cancel_supplier_invoice 6439 6431 8 0.12 2 22996 861 0 8
sp_cancel_supplier_order 396 396 0 0.00 7 1014235 119381 0 0
sp_cancel_write_off 10296 10296 0 0.00 1 33383 118 0 0
sp_client_order 20006 20006 0 0.00 3 34038 370 0 0
sp_customer_reserve 440820 440820 0 0.00 0 85660 185 0 0
sp_fill_shopping_cart 30807 30807 0 0.00 1 19086 41 0 0
sp_fill_shopping_cart_clo_res 440813 440813 0 0.00 0 27639 15 0 0
sp_get_clo_for_invoice 4782 4782 0 0.00 0 24209 293 0 0
sp_kill_cost_storno 17105 17105 0 0.00 0 33380 66 0 0
sp_kill_qstorno_ret_qs2qd 1140105 1140105 0 0.00 0 32653 35 0 0
sp_kill_qty_storno 600481 600481 0 0.00 0 44974 77 0 0
sp_lock_selected_doc 19943 19943 0 0.00 0 9330 5 0 0
sp_make_cost_storno 27115 27115 0 0.00 0 14715 49 0 0
sp_multiply_rows_for_pdistr 27115 27115 0 0.00 0 8672 30 0 0
sp_multiply_rows_for_qdistr 20006 20006 0 0.00 0 34019 167 0 0
sp_pay_from_customer 6819 6819 0 0.00 4 14283 115 0 0
sp_pay_to_supplier 5872 5872 0 0.00 5 16740 114 0 0
sp_payment_common 12691 12691 0 0.00 2 16461 28 0 0
sp_qd_handle_on_cancel_clo 1674 1674 0 0.00 0 16880 327 0 0
sp_qd_handle_on_invoice_upd_sts 10548 10548 0 0.00 0 44970 366 0 0
sp_qd_handle_on_reserve_upd_sts 9645 9645 0 0.00 0 12422 75 0 0
sp_reserve_write_off 9645 9645 0 0.00 6 12468 189 0 0
sp_supplier_invoice 5295 5295 0 0.00 7 66917 3446 0 0
sp_supplier_order 5525 5525 0 0.00 5 30887 1254 0 0
srv_aggregate_perf_data 99 98 1 1.01 2787 123285 20011 0 1
srv_fill_mon_cache_memory 169 169 0 0.00 822 143111 32081 0 0
srv_find_qd_qs_mism 1041513 1041513 0 0.00 0 31066 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 35 36786 1010 0 0
srv_make_money_saldo 796 796 0 0.00 1 3960 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 330220 487953 406710 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 4796 4796 0 0.00 0 22804 185 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 1 4267 121 0 0
t$perf-norm:sp_cancel_client_order 1674 1674 0 0.00 0 13873 22 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 9139 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 642 642 0 0.00 0 7343 30 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 332 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 377 377 0 0.00 0 962 11 0 0
t$perf-norm:sp_cancel_supplier_order 396 396 0 0.00 0 20251 1598 0 0
t$perf-norm:sp_cancel_write_off 966 966 0 0.00 0 3860 10 0 0
t$perf-norm:sp_client_order 20006 20006 0 0.00 0 9401 18 0 0
t$perf-norm:sp_customer_reserve 951 951 0 0.00 0 14056 19 0 0
t$perf-norm:sp_pay_from_customer 6819 6819 0 0.00 0 10277 15 0 0
t$perf-norm:sp_pay_to_supplier 5872 5872 0 0.00 0 6989 14 0 0
t$perf-norm:sp_reserve_write_off 9645 9645 0 0.00 0 9169 10 0 0
t$perf-norm:sp_supplier_invoice 5295 5295 0 0.00 0 6223 18 0 0
t$perf-norm:sp_supplier_order 5525 5525 0 0.00 0 8792 20 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 368 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 4004 26 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 946 21 0 0
t$perf-norm:srv_make_money_saldo 796 796 0 0.00 0 757 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 9874 9558 316 3.20 0 4590 18 0 316
v_all_customers 36846 36846 0 0.00 0 22 1 0 0
v_all_suppliers 30392 30392 0 0.00 0 24 1 0 0
v_all_wares 40012 40012 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 2913 10 0 0
v_cancel_client_order 3348 3348 0 0.00 0 630 3 0 0
v_cancel_customer_prepayment 1284 1284 0 0.00 0 634 4 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 1565 5 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 1306 7 0 0
v_cancel_supplier_invoice 770 754 16 2.07 0 2530 15 0 16
v_cancel_supplier_order 792 792 0 0.00 0 1487 6 0 0
v_cancel_write_off 1932 1932 0 0.00 0 1088 14 0 0
v_max_id_clo_ord 5525 5525 0 0.00 0 4249 2 0 0
v_max_id_clo_res 951 951 0 0.00 0 4808 20 0 0
v_max_id_ord_sup 5276 5276 0 0.00 0 2618 3 0 0
v_max_non_paid_invoice 1477 1477 0 0.00 0 505 3 0 0
v_max_non_paid_realizn 3476 3476 0 0.00 0 4120 4 0 0
v_min_id_clo_ord 5525 5525 0 0.00 0 3375 6 0 0
v_min_id_clo_res 951 951 0 0.00 0 2549 9 0 0
v_min_id_ord_sup 5276 5276 0 0.00 0 6410 6 0 0
v_min_non_paid_invoice 5872 5872 0 0.00 0 16450 16 0 0
v_min_non_paid_realizn 6819 6819 0 0.00 0 11396 17 0 0
v_our_firm 9852 9852 0 0.00 0 21 1 0 0
v_reserve_write_off 19290 19290 0 0.00 0 4949 5 0 0
x_lock_depdocs_on_canc_invoice 11823 11823 0 0.00 0 16107 128 0 0
x_lock_depdocs_on_canc_sup_ord 396 396 0 0.00 0 7382 382 0 0
x_make_qstorno_1000_1200 5525 5525 0 0.00 2 30855 1171 0 0
x_make_qstorno_1200_2000 5295 5295 0 0.00 3 66901 3300 0 0
x_make_qstorno_2100_3300 440820 440820 0 0.00 0 85659 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-02-2021 01:28:39 to 10-02-2021 01:28:43.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:18 2 8192000000 8799054672 8809775104 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:24 23990 8192000000 10269739152 10576945152 901682288 9.915 70 60 120 0 924766800 2799504 20285008
22:57:57 30729 8192000000 10337870928 10656124928 1389471392 14.501 100 87 174 0 1423135552 5019728 28644432
22:58:38 29525 8192000000 10384876384 10703536128 1434736336 14.903 100 93 186 0 1471757632 6546512 30474784
22:59:18 16484 8192000000 10397471872 10725105664 1453310928 15.067 100 83 165 1 1488207888 7184000 27712960
22:59:46 25279 8192000000 10438457488 10767568896 1488578480 15.376 100 90 180 0 1525567200 7954656 29034064
23:00:22 23680 8192000000 10460692016 10790682624 1514448656 15.602 100 92 184 0 1551804352 8482864 28872832
23:01:03 14285 8192000000 10464921200 10801745920 1518462672 15.637 100 83 166 1 1553831056 9354960 26013424
23:01:29 9466 8192000000 10483658672 10823086080 1539134112 15.816 100 88 176 1 1576703632 10107792 27461728
23:01:49 14235 8192000000 10505041936 10853507072 1562011648 16.014 100 82 164 2 1597030272 10135760 24882864
23:02:12 16847 8192000000 10533902768 10887065600 1594734416 16.294 100 80 160 1 1628999520 10284752 23980352
23:02:40 12726 8192000000 10571799600 10928844800 1619748768 16.508 100 76 152 2 1653282752 10653712 22880272
23:02:59 9514 8192000000 10593088432 10949427200 1647365760 16.742 100 81 162 1 1683123664 11373760 24384144
23:03:20 7348 8192000000 10594029248 10958712832 1658171440 16.833 100 76 152 0 1692717584 12069648 22476496
23:03:38 10154 8192000000 10615897808 10981543936 1675687296 16.981 100 72 144 1 1708685584 12182432 20815856
23:03:57 10933 8192000000 10649421072 11014696960 1700884368 17.193 100 86 172 0 1739303456 13390176 25028912
23:04:17 7321 8192000000 10650419472 11022647296 1711773328 17.284 100 75 150 5 1747337296 13877760 21686208
23:04:31 7594 8192000000 10673102112 11044491264 1722776064 17.375 100 73 145 2 1756985888 13795792 20414032
23:04:48 6232 8192000000 10686662272 11061477376 1746176176 17.570 100 79 158 2 1782679888 13921696 22582016
23:05:00 6496 8192000000 10698723488 11075952640 1760407776 17.688 100 82 164 0 1797621008 13670496 23542736
23:05:13 5121 8192000000 10713229072 11092103168 1774029792 17.800 100 87 172 0 1811284528 12910864 24343872
23:05:25 2973 8192000000 10720099136 11094564864 1778717152 17.839 100 80 162 1 1813024576 12206128 22101296
23:05:36 3406 8192000000 10724671664 11105161216 1787296880 17.910 100 83 162 0 1822714688 12894976 22522832
23:05:46 2610 8192000000 10737198464 11117051904 1792611120 17.953 100 89 178 0 1832113552 14633824 24868608
23:05:55 2968 8192000000 10739319600 11121504256 1801593648 18.027 100 89 179 0 1840931536 13884448 25453440
23:06:05 2831 8192000000 10742783392 11128979456 1806161856 18.064 100 85 168 2 1844286288 13772112 24352320
23:06:15 3481 8192000000 10758178208 11142275072 1817838800 18.160 100 92 184 0 1858702784 15323296 25540688
23:06:25 8010 8192000000 10759599968 11144712192 1818484752 18.165 100 83 166 1 1856388352 14734592 23169008
23:06:41 5240 8192000000 10773621904 11158872064 1823700208 18.208 100 83 165 2 1859240560 12973536 22566816
23:06:52 2480 8192000000 10778158144 11165220864 1837687968 18.322 100 89 178 1 1875565136 12981808 24895360
23:07:02 1733 8192000000 10790258256 11176189952 1843052992 18.366 100 94 188 0 1882850176 14144768 25652416
23:07:10 1710 8192000000 10788340608 11174236160 1844078176 18.374 100 88 175 1 1882516560 13572976 24865408
23:07:18 1363 8192000000 10788038144 11175870464 1845338368 18.384 100 90 180 1 1884340464 13564960 25437136
23:07:26 1998 8192000000 10789682752 11178061824 1846887904 18.397 100 86 173 0 1884726128 13475200 24363024
23:07:35 1727 8192000000 10803533376 11188994048 1858788448 18.493 100 95 191 2 1898276896 12348864 27139584
23:07:43 1329 8192000000 10806056208 11194322944 1858912064 18.494 100 86 172 2 1896115008 12518352 24684592
23:07:50 1470 8192000000 10811361888 11198119936 1864196704 18.537 100 95 191 1 1904539456 12893424 27449328
23:07:58 1470 8192000000 10812968272 11198087168 1863350064 18.530 100 92 186 0 1902486480 13620528 25515888
23:08:06 1258 8192000000 10808804032 11198902272 1866427568 18.555 100 89 178 0 1905384192 14258800 24697824
23:08:14 1276 8192000000 10816896448 11206737920 1869868624 18.583 100 94 189 0 1910015856 13535088 26612144
23:08:23 6604 8192000000 10807292496 11204239360 1871992224 18.600 100 73 145 2 1904824848 13000032 19832592
23:08:36 33854 8192000000 10795203328 11199275008 1867794720 18.566 100 61 122 1 1895667456 9937296 17935440
23:09:18 9908 8192000000 10761231344 11193053184 1862738496 18.525 100 26 52 1 1876852400 6632848 7481056
23:09:34 4379 8192000000 10772433552 11198685184 1865743456 18.550 100 32 64 1 1881283808 6606992 8933360
23:09:47 9066 8192000000 10777534928 11204022272 1869221952 18.578 100 29 58 1 1884653680 7211952 8219776
23:10:03 12416 8192000000 10783942912 11212492800 1870585184 18.589 100 18 36 0 1881948112 6672128 4690800
23:10:21 6281 8192000000 10781271600 11214155776 1875763952 18.631 100 33 66 2 1892762880 8097568 8901360
23:10:34 18530 8192000000 10775798400 11215118336 1873101568 18.609 100 5 10 1 1879728464 5178416 1448480
23:11:00 20649 8192000000 10787361248 11217027072 1880533408 18.669 100 18 36 0 1890595440 5418480 4643552
23:11:30 7216 8192000000 10786873008 11220164608 1880891760 18.672 100 20 41 0 1893194720 6198656 6104304
23:11:48 9891 8192000000 10800503632 11227242496 1882907360 18.689 100 15 30 0 1893109360 5764000 4438000
23:12:05 7022 8192000000 10806195968 11234340864 1890165744 18.747 100 30 60 2 1905637248 7428416 8043088
23:12:24 74648 8192000000 10800897616 11238150144 1894236928 18.780 100 35 71 0 1910591632 6074640 10280064
23:13:45 9140 8192000000 10812188912 11245076480 1891981184 18.762 100 12 24 1 1900599136 5341232 3276720
23:14:01 9066 8192000000 10806118960 11242250240 1896180912 18.796 100 19 38 0 1907854224 6507376 5165936
23:14:19 5643 8192000000 10817551968 11250991104 1898921344 18.818 100 18 36 2 1910027344 5730800 5375200
23:14:32 7074 8192000000 10827729888 11259428864 1904738544 18.864 100 34 69 1 1922150448 7547200 9864704
23:14:47 3895 8192000000 10828805840 11256553472 1906343744 18.877 100 36 72 4 1923534912 6970832 10220336
23:14:57 5786 8192000000 10820068864 11259510784 1905470736 18.870 100 30 60 2 1925769536 11683280 8615520
23:15:09 7987 8192000000 10800912432 11237363712 1879512176 18.661 99 25 50 0 1892214480 5461936 7240368
23:15:24 5607 8192000000 10811475280 11247980544 1896946080 18.802 100 19 38 0 1907775712 5873456 4956176
23:15:37 6372 8192000000 10820938144 11256205312 1904653680 18.864 100 21 42 3 1917065760 6673664 5738416
23:15:50 11617 8192000000 10799621488 11236241408 1875701328 18.630 99 16 32 0 1886464288 6370944 4392016
23:16:08 11055 8192000000 10802252128 11236024320 1887648512 18.727 100 14 28 1 1897186304 5842032 3695760
23:16:26 13005 8192000000 10796459968 11232092160 1870995296 18.592 99 20 41 1 1886620720 10028416 5597008
23:16:46 8457 8192000000 10793581696 11229937664 1869881808 18.583 99 28 56 2 1884941360 6858096 8201456
23:17:06 58852 8192000000 10778694704 11205320704 1786030544 17.899 95 34 68 1 1802069600 5696432 10342624
23:18:13 11895 8192000000 10737287152 11169480704 1783292400 17.877 96 19 38 2 1794497040 6233648 4970992
23:18:31 4379 8192000000 10752823408 11174748160 1833576656 18.288 100 31 62 1 1857208080 15385792 8245632
23:18:47 6656 8192000000 10752099600 11177410560 1820386432 18.181 99 27 53 0 1833395616 5469808 7539376
23:19:00 8867 8192000000 10707369456 11124649984 1711115360 17.278 94 24 47 0 1723498976 5458944 6924672
23:19:19 9242 8192000000 10733059552 11156983808 1810441488 18.099 99 36 72 3 1827441984 5857264 11143232
23:19:35 6527 8192000000 10731055712 11143266304 1785479712 17.895 98 39 78 1 1804167056 6526800 12160544
23:19:50 4664 8192000000 10732948448 11142565888 1792794976 17.955 99 21 41 3 1803506704 4688528 6023200
23:20:02 5642 8192000000 10730555936 11153010688 1814494384 18.133 100 19 37 1 1826100896 6073504 5533008
23:20:15 4651 8192000000 10719578128 11129843712 1768281616 17.753 98 35 70 0 1784765776 6642624 9841536
23:20:30 6515 8192000000 10672413232 11084267520 1717042944 17.328 97 20 40 2 1728090720 5132080 5915696
23:20:48 8465 8192000000 10690490800 11105153024 1731708768 17.450 97 21 40 2 1742828880 5786832 5333280
23:21:03 12109 8192000000 10698426048 11108270080 1753090544 17.627 98 29 57 2 1767071152 5358416 8622192
23:21:23 7040 8192000000 10714569872 11138146304 1794175056 17.966 100 24 48 2 1811248560 9795232 7278272
23:21:36 60885 8192000000 10732859120 11158908928 1799865440 18.013 99 33 66 0 1814122592 5553312 8703840
23:22:43 7728 8192000000 10711905184 11140333568 1800152224 18.015 99 20 40 2 1811302928 5280016 5870688
23:22:59 6928 8192000000 10737971712 11165163520 1827907584 18.242 100 32 64 0 1844992336 7806672 9278080
23:23:13 6548 8192000000 10754714720 11172982784 1828167792 18.244 100 24 48 1 1840791248 5725072 6898384
23:23:27 4408 8192000000 10762499680 11176484864 1833814880 18.290 100 20 40 1 1845172976 6209408 5148688
23:23:38 4377 8192000000 10767173984 11183992832 1842671744 18.363 100 46 92 2 1863896528 7420896 13803888
23:23:48 6098 8192000000 10767422816 11186507776 1845600432 18.386 100 36 70 0 1862627632 7025488 10001712
23:24:01 6836 8192000000 10768426912 11186753536 1845384976 18.385 100 27 54 3 1858692976 5389952 7918048
23:24:15 5955 8192000000 10781854912 11191234560 1847683536 18.403 100 31 63 0 1861635024 5287824 8663664
23:24:29 4238 8192000000 10770202256 11195621376 1853465232 18.450 100 34 67 2 1870563392 7653376 9444784
23:24:41 7888 8192000000 10775229728 11202920448 1855877952 18.470 100 17 33 0 1866018624 5231232 4909440
23:24:55 7759 8192000000 10774723936 11201806336 1858030272 18.487 100 20 41 1 1869294912 5356144 5908496
23:25:11 9995 8192000000 10768917840 11201310720 1860050848 18.504 100 18 36 1 1870776176 5125216 5600112
23:25:27 14498 8192000000 10773978928 11205873664 1858108880 18.488 100 16 32 0 1868262128 5287488 4865760
23:25:48 13280 8192000000 10779545392 11211644928 1866508752 18.556 100 14 27 1 1876256624 5238880 4508992
23:26:07 57616 8192000000 10796139504 11215859712 1869128640 18.577 100 19 38 1 1879773168 4761504 5883024
23:27:12 42710 8192000000 10821451872 11238113280 1889560256 18.742 100 53 106 3 1911733328 6557104 15615968
23:28:05 13802 8192000000 10835477776 11251924992 1899355136 18.821 100 48 95 0 1921812768 9591408 12866224
23:28:31 22239 8192000000 10851990304 11266482176 1911977696 18.923 100 58 113 1 1938158960 10030416 16150848
23:29:01 39502 8192000000 10849161184 11275825152 1915552768 18.951 100 47 94 2 1940000480 10821968 13625744
23:29:49 32805 8192000000 10844844528 11272093696 1904394624 18.862 99 33 66 1 1924941008 11382416 9163968
23:30:33 16792 8192000000 10856322288 11286110208 1926705392 19.041 100 34 64 3 1947350512 10676992 9968128
23:30:58 27234 8192000000 10875836800 11305750528 1937628416 19.128 100 49 96 3 1963517264 12195536 13693312
23:31:34 4542 8192000000 10902744720 11315388416 1949719056 19.224 100 66 127 1 1983275248 14973440 18582752
23:31:51 1891 8192000000 10899642192 11318484992 1954014992 19.258 100 68 135 0 1988388752 15164096 19209664
23:32:01 22429 8192000000 10896496752 11327033344 1957396256 19.285 100 57 113 1 1989849632 16212160 16241216
23:33:04 13541 8192000000 10900425056 11343155200 1965738416 19.352 100 31 62 0 1992765152 17741472 9285264
23:33:40 10230 8192000000 10913286912 11341819904 1952573488 19.247 99 48 96 1 1985341232 18501488 14266256
23:33:58 11841 8192000000 10903310160 11341393920 1967437408 19.365 100 40 80 1 2000438592 20627712 12373472
23:34:17 19976 8192000000 10912546448 11349786624 1974452608 19.421 100 47 94 1 2008826880 19790992 14583280
23:34:45 8357 8192000000 10910496496 11352162304 1976879216 19.440 100 45 87 0 2012347424 21161216 14306992
23:35:05 2518 8192000000 10945651264 11362156544 1986711776 19.518 100 71 140 3 2026066304 19232048 20122480
23:35:14 13322 8192000000 10951300224 11373645824 1990073888 19.544 100 70 140 0 2032014592 21312592 20628112
23:35:35 3486 8192000000 10947857648 11373133824 1992835968 19.566 100 59 115 2 2030547616 21233776 16477872
23:35:49 5929 8192000000 10947819792 11381223424 2001959456 19.638 100 59 118 1 2040989792 21943696 17086640
23:36:05 9724 8192000000 10952946672 11383250944 2002982928 19.646 100 67 134 1 2046185184 22519360 20682896
23:36:24 12747 8192000000 10955540064 11388792832 2005622432 19.667 100 56 110 3 2045190928 22326304 17242192
23:36:45 7391 8192000000 10941482224 11368181760 1973696512 19.415 99 58 116 0 2017521424 25868432 17956480
23:37:03 6540 8192000000 10941212192 11366723584 1985228560 19.506 100 69 136 2 2032722160 27054016 20439584
23:37:17 5561 8192000000 10958546688 11383209984 1993668288 19.573 100 79 156 2 2045202368 28551840 22982240
23:37:33 1714 8192000000 10951176912 11362594816 1981744176 19.479 100 77 153 1 2033628304 29158272 22725856
23:37:42 4582 8192000000 10950659744 11370053632 1986037584 19.512 100 77 152 1 2038873088 29258784 23576720
23:37:53 3166 8192000000 10964084256 11380776960 1991445696 19.555 100 84 166 1 2046761776 30500288 24815792
23:38:03 4161 8192000000 10972672672 11388416000 1996365872 19.594 100 85 170 0 2053614512 31775040 25473600
23:38:15 2143 8192000000 10959615040 11376803840 1977492032 19.445 99 83 166 0 2033855024 32166032 24196960
23:38:27 2454 8192000000 10948732128 11365081088 1971883376 19.400 99 74 148 1 2026626608 32865632 21877600
23:38:37 12108 8192000000 10964204512 11384262656 1990298256 19.546 100 80 160 0 2050330224 35914576 24117392
23:38:56 6118 8192000000 10965873856 11388370944 1989918848 19.543 100 69 138 1 2046717840 35930960 20868032
23:39:09 1616 8192000000 10973416768 11393982464 1993305360 19.570 100 78 157 3 2055061136 38225680 23530096
23:39:18 11350 8192000000 10972023632 11400761344 2001079216 19.631 100 68 134 0 2061081376 39180928 20821232
23:39:37 14256 8192000000 10980870304 11410845696 2006777088 19.676 100 67 134 0 2066500032 39075632 20647312
23:40:00 6259 8192000000 10969029616 11404492800 2004246256 19.656 100 63 126 1 2064328048 40403840 19677952
23:40:18 2307 8192000000 10962624960 11381309440 1962936704 19.329 99 79 159 0 2027885104 40563024 24385376
23:40:27 2653 8192000000 10968024160 11385769984 1987233456 19.522 100 69 138 0 2048356720 39861872 21261392
23:40:37 2295 8192000000 10959283712 11381067776 1981550688 19.477 100 80 160 0 2046377808 40618384 24208736
23:40:46 3177 8192000000 10968054640 11385929728 1983729952 19.494 100 77 151 1 2048565632 41453088 23382592
23:40:58 7515 8192000000 10962781104 11387678720 1971646352 19.399 99 77 152 2 2035809920 40968224 23195344
23:41:15 3298 8192000000 10961541648 11385090048 1988030720 19.528 100 75 149 2 2049488832 38132592 23325520
23:41:25 819 8192000000 10976944512 11386966016 1985531904 19.508 100 82 163 0 2053411216 42420656 25458656
23:41:33 1855 8192000000 10957396224 11368620032 1965503200 19.350 100 86 172 1 2034808352 43501616 25803536
23:41:41 2610 8192000000 10955988032 11370950656 1967053472 19.362 100 82 162 0 2036319984 44638048 24628464
23:41:52 8717 8192000000 10941960896 11361222656 1946248032 19.197 99 75 150 0 2014211040 45120768 22842240
23:42:07 4273 8192000000 10914611072 11333091328 1905236608 18.868 98 67 135 1 1972464512 46074176 21153728
23:42:20 1195 8192000000 10942613328 11353485312 1949010784 19.219 100 84 163 1 2022322176 48094496 25216896
23:42:28 3875 8192000000 10913976128 11335643136 1933688720 19.096 100 63 124 0 2001814848 48230848 19895280
23:42:40 2378 8192000000 10922516064 11337551872 1933834432 19.098 100 77 153 2 2007256608 49439168 23983008
23:42:51 7998 8192000000 10917732928 11331100672 1932398144 19.086 100 67 129 2 2000742576 48376416 19968016
23:43:08 4944 8192000000 10935718464 11355234304 1946019216 19.195 100 70 140 1 2017948128 49803120 22125792
23:43:20 3540 8192000000 10953097776 11362336768 1955048320 19.267 100 81 162 1 2032012944 51389440 25575184
23:43:30 13459 8192000000 10942558416 11363569664 1953390992 19.253 100 70 139 1 2027456800 52220960 21844848
23:43:52 4849 8192000000 10948372720 11366588416 1953031856 19.251 100 72 144 3 2029148960 53466592 22650512
23:44:08 2309 8192000000 10981884176 11385028608 1972423264 19.405 100 93 184 0 2058176352 56944016 28809072
23:44:18 1651 8192000000 10984139776 11388616704 1972130336 19.402 100 87 172 0 2056593232 58063376 26399520
23:44:25 3515 8192000000 10974959664 11386966016 1970538944 19.390 100 83 166 1 2056619808 59528672 26552192
23:44:36 1463 8192000000 10966245472 11373379584 1956757152 19.280 100 86 172 1 2044531712 60142944 27631616
23:44:45 2135 8192000000 10964466896 11374510080 1957843184 19.289 100 79 158 2 2043612608 60546576 25222848
23:44:54 3514 8192000000 10966780880 11378061312 1956935104 19.282 100 82 164 1 2044263568 61273856 26054608
23:45:07 1038 8192000000 10956243120 11361136640 1945738448 19.193 99 88 172 4 2032557312 59560656 27258208
23:45:15 13156 8192000000 10946554096 11379130368 1961184784 19.315 100 53 106 0 2035532080 57119808 17227488
23:45:38 3150 8192000000 10971274208 11395387392 1974030304 19.417 100 60 120 2 2049672192 56105280 19536608
23:45:49 4878 8192000000 10976802640 11393867776 1974857712 19.424 100 72 142 0 2055455184 57537232 23060240
23:46:02 3036 8192000000 10977646736 11399864320 1977037488 19.441 100 78 157 1 2062230944 59408016 25785440
23:46:12 3260 8192000000 10976719584 11386093568 1967836704 19.368 100 80 156 1 2050984560 58038576 25109280
23:46:22 2549 8192000000 10983845792 11397206016 1981418976 19.476 100 84 166 1 2062963760 55030992 26513792
23:46:32 3055 8192000000 10987565136 11411714048 1988384688 19.531 100 79 159 0 2068709408 55567552 24757168
23:46:47 4340 8192000000 10968779808 11406229504 1987796656 19.526 100 56 112 0 2055730000 49829040 18104304
23:47:01 7523 8192000000 10952342848 11387555840 1954200096 19.260 99 47 93 2 2021162016 51307392 15654528
23:47:15 11038 8192000000 10939007968 11373805568 1930622768 19.072 98 39 78 1 1994637824 51054224 12960832
23:47:35 8885 8192000000 10938918352 11386273792 1966359616 19.357 100 41 82 0 2031189920 51554464 13275840
23:47:58 13419 8192000000 10953156352 11376222208 1950228464 19.228 99 52 103 1 2012489504 45617280 16643760
23:48:19 10120 8192000000 10950216832 11387887616 1973680560 19.415 100 45 90 0 2036418800 48141488 14596752
23:48:45 11738 8192000000 10952669280 11388092416 1963251840 19.332 99 47 94 1 2028088992 49012368 15824784
23:49:06 4686 8192000000 10974086800 11398713344 1983482560 19.492 100 51 102 0 2048496352 49009824 16003968
23:49:18 7984 8192000000 10969096240 11400257536 1981780432 19.479 100 49 97 1 2047016064 49583552 15652080
23:49:34 4730 8192000000 10974707632 11406458880 1988227168 19.530 100 55 106 1 2057919968 51992640 17700160
23:49:50 8392 8192000000 10985727072 11420295168 1993524608 19.572 100 50 100 2 2063121776 53518112 16079056
23:50:08 22439 8192000000 10977448336 11430412288 1994551696 19.580 100 34 68 1 2061964496 55024112 12388688
23:50:41 15198 8192000000 10979529328 11433963520 1997123856 19.600 100 35 70 2 2067127312 57714768 12288688
23:51:34 37372 8192000000 10957208016 11412115456 1966236768 19.356 99 35 70 3 2035661808 56934512 12490528
23:52:48 33296 8192000000 10942672608 11399811072 1942609920 19.168 99 26 52 0 2013175872 60812640 9753312
23:53:28 18364 8192000000 10935378464 11396030464 1944045664 19.179 100 28 56 1 2021437104 66168688 11222752
23:54:09 26989 8192000000 10929583200 11386195968 1927556208 19.047 99 30 60 0 2000251744 61140240 11555296
23:54:42 44379 8192000000 10915411632 11385393152 1937673568 19.128 100 22 44 1 2010511920 64690944 8147408
23:55:33 39162 8192000000 10855141984 11324841984 1881531088 18.677 97 3 6 0 1911077088 28737552 808448
23:56:19 30498 8192000000 10902494432 11344220160 1946466384 19.198 100 32 59 3 1966332144 11381488 8484272
23:56:56 89709 8192000000 10908596080 11357523968 1959239680 19.300 100 42 83 2 1989392432 17803072 12349680
23:59:19 83999 8192000000 10897327968 11352104960 1950478592 19.230 99 34 68 0 1986212208 24859104 10874512
00:00:50 95224 8192000000 10879019168 11347218432 1896634048 18.799 96 21 42 2 1915870832 13172992 6063792
00:02:35 77828 8192000000 10876785104 11343970304 1935871280 19.114 99 12 24 0 1949877168 10868080 3137808
00:04:00 27563 8192000000 10862899056 11338764288 1933831120 19.097 99 12 24 0 1949117040 12064992 3220928
00:04:33 21999 8192000000 10880887680 11334680576 1934424592 19.102 99 15 30 1 1949209648 11260320 3524736
00:05:02 71875 8192000000 10881109312 11341643776 1909840032 18.905 98 13 27 0 1919781280 7027984 2913264
00:06:22 48700 8192000000 10886759936 11344314368 1940491696 19.151 99 17 34 2 1955685824 10204224 4989904
00:07:22 79566 8192000000 10893555920 11365707776 1969908640 19.385 100 24 48 2 1989294512 12090752 7295120
00:08:48 44834 8192000000 10891564784 11366641664 1969803536 19.384 100 17 33 1 1989296512 14860624 4632352
00:09:44 42754 8192000000 10883200432 11374538752 1967189008 19.363 100 9 18 1 1983529344 13559888 2780448
00:10:33 110065 8192000000 10903005120 11364102144 1949353456 19.221 99 23 47 1 1967843904 12306944 6183504
00:12:38 54325 8192000000 10869991888 11347759104 1954000992 19.258 99 20 38 2 1968703728 9130656 5572080
00:13:44 4837 8192000000 10890475776 11362320384 1968176832 19.371 100 12 24 1 1980754016 9238704 3338480
00:14:26 20430 8192000000 10875820672 11333214208 1922972656 19.011 97 35 69 0 1941883904 8317184 10594064
00:14:59 65535 8192000000 10880866384 11358789632 1926068416 19.035 98 11 22 1 1941893248 12965696 2859136
00:16:10 43141 8192000000 10869511744 11345018880 1946954288 19.202 99 19 38 2 1966893760 14641968 5297504
00:17:14 66883 8192000000 10879571504 11345387520 1915570096 18.951 97 20 38 3 1931374816 9935728 5868992
00:18:27 97866 8192000000 10883774064 11367821312 1964996752 19.346 100 17 34 0 1983565008 13269136 5299120
00:20:21 59396 8192000000 10875781712 11349524480 1925093984 19.028 98 9 18 0 1936288256 9078720 2115552
00:21:33 84445 8192000000 10892091504 11366903808 1934536416 19.103 98 22 43 1 1950457920 9782080 6139424
00:23:04 114384 8192000000 10897031472 11363704832 1914946080 18.946 97 20 40 1 1932345504 11905680 5493744
00:25:09 62013 8192000000 10899064016 11374489600 1954274032 19.261 99 22 44 0 1971720880 11081664 6365184
00:26:17 40120 8192000000 10887747312 11348791296 1932710688 19.089 98 16 32 0 1952601792 15340912 4550192
00:27:07 20406 8192000000 10900386240 11358072832 1955828128 19.273 99 43 82 2 1975975136 8799824 11347184
00:27:58 45891 8192000000 10891875456 11358486528 1944214704 19.180 99 16 32 0 1961052624 11818592 5019328
00:28:54 45452 8192000000 10899859712 11369377792 1952503824 19.246 99 16 30 0 1975950032 19241296 4204912
00:29:49 100800 8192000000 10873964992 11355369472 1850222864 18.424 94 11 22 0 1867919152 14990288 2706000
00:31:36 98870 8192000000 10888336256 11354181632 1837158944 18.318 94 18 36 0 1856085024 14757184 4168896
00:33:22 35569 8192000000 10872276368 11330461696 1879124688 18.658 96 27 53 1 1900503264 14171504 7207072
00:34:10 65888 8192000000 10874541552 11334262784 1888642576 18.735 97 35 70 1 1913629952 15419024 9568352
00:35:29 95438 8192000000 10872097136 11343843328 1944781360 19.185 100 37 74 1 1966446992 10830144 10835488
00:37:27 61643 8192000000 10865067040 11330265088 1874623568 18.622 96 16 32 1 1890456288 11155632 4677088
00:38:43 26315 8192000000 10850479296 11310772224 1877862112 18.648 97 30 60 2 1900177040 13563856 8751072
00:39:16 54370 8192000000 10848374608 11323535360 1923484992 19.015 100 14 28 1 1938860512 11443904 3931616
00:40:18 61627 8192000000 10844815712 11330064384 1914666416 18.944 99 8 16 0 1931199920 14391504 2142000
00:41:29 37916 8192000000 10847857232 11319083008 1900664832 18.832 98 19 37 1 1915976752 10106544 5205376
00:42:20 38538 8192000000 10855130528 11336556544 1940736272 19.153 100 17 34 2 1962979408 17339216 4903920
00:43:05 83593 8192000000 10852264480 11330682880 1889532448 18.742 97 14 28 0 1903511680 10219792 3759440
00:44:35 26075 8192000000 10855131104 11333967872 1919143296 18.980 99 5 10 0 1937483184 17077904 1261984
00:45:07 46623 8192000000 10862761312 11333001216 1889848992 18.745 98 13 25 1 1907412736 14621008 2942736
00:46:02 20363 8192000000 10878468416 11325739008 1921690464 19.000 99 44 86 0 1940420608 6472368 12257776
00:46:36 23385 8192000000 10851847632 11309289472 1881258768 18.675 97 28 56 2 1896566768 7748704 7559296
00:47:30 33825 8192000000 10857719248 11316482048 1884201264 18.699 97 28 56 1 1900943744 9102848 7639632
00:48:12 26703 8192000000 10875243040 11337748480 1930023952 19.067 100 31 62 2 1951745216 12984624 8736640
00:49:03 50712 8192000000 10846539952 11327619072 1896805824 18.801 98 21 42 2 1917257296 13955376 6496096
00:50:00 47815 8192000000 10851750448 11306680320 1865830480 18.551 97 14 28 0 1880803120 10835984 4136656
00:50:55 19828 8192000000 10856352128 11307298816 1911523760 18.919 99 37 73 1 1930698832 8367792 10807280
00:51:21 61372 8192000000 10858419376 11327692800 1890798720 18.752 98 35 68 0 1918235776 18164688 9272368
00:52:29 143111 8192000000 10887741776 11354570752 1866962128 18.560 96 19 38 0 1882887920 11130720 4795072
00:55:08 52730 8192000000 10888633584 11359068160 1947126304 19.204 100 25 50 1 1974426272 19941040 7358928
00:56:07 70196 8192000000 10883662928 11352760320 1897641104 18.807 97 20 39 1 1922235488 18909296 5685088
00:57:26 59906 8192000000 10869575696 11346743296 1864074976 18.536 96 6 12 0 1884742272 19408816 1258480
00:58:31 81268 8192000000 10878119648 11333971968 1930513552 19.071 99 29 58 0 1946926944 8103168 8310224
01:00:19 67673 8192000000 10887865568 11355668480 1919686368 18.984 98 41 82 1 1949870816 18790976 11393472
01:01:32 53331 8192000000 10865802384 11339362304 1912712384 18.928 98 23 46 1 1930251712 10819200 6720128
01:02:59 71821 8192000000 10865815680 11332448256 1907398752 18.886 98 10 20 0 1925561680 15390832 2772096
01:04:17 36225 8192000000 10898075856 11352453120 1943384192 19.174 100 17 34 0 1965455136 16450752 5620192
01:05:10 52232 8192000000 10905070928 11376365568 1954377568 19.261 99 44 89 1 1984241152 16374928 13488656
01:06:11 71248 8192000000 10919348288 11388473344 1975985040 19.433 100 30 58 5 2008565184 23534192 9045952
01:07:29 48869 8192000000 10925967568 11398168576 1983998400 19.496 100 24 47 2 2014246032 23525760 6721872
01:08:25 55186 8192000000 10920816896 11401666560 1961085344 19.315 99 15 30 1 1993786816 28136416 4565056
01:09:26 79014 8192000000 10933282336 11400237056 1954858144 19.265 99 20 41 1 1985737904 24592304 6287456
01:10:52 80959 8192000000 10909535968 11390668800 1938984128 19.139 98 8 16 0 1958892832 17993136 1915568
01:12:26 62850 8192000000 10893654656 11365179392 1915971136 18.955 97 12 24 0 1933506928 14682224 2853568
01:13:35 31410 8192000000 10916188144 11381628928 1973913200 19.416 100 31 61 0 1993819728 11515168 8391360
01:14:13 74032 8192000000 10902096928 11390509056 1955426224 19.270 99 18 36 1 1977715040 17291184 4997632
01:15:37 48884 8192000000 10885105104 11353595904 1888037712 18.730 96 21 42 2 1906298528 12098272 6162544
01:16:35 42017 8192000000 10896905712 11350654976 1942957120 19.170 99 38 73 0 1962213648 9502320 9754208
01:17:24 124467 8192000000 10881862240 11360555008 1943130624 19.172 99 28 56 0 1963184752 12181104 7873024
01:19:35 33181 8192000000 10879266720 11366248448 1959786416 19.304 100 13 26 2 1974441216 11067824 3586976
01:20:20 12810 8192000000 10877285248 11368747008 1960417392 19.309 100 7 14 0 1976448768 14229280 1802096
01:20:42 15498 8192000000 10880682192 11362512896 1957141568 19.283 100 8 16 0 1968811904 9762752 1907584
01:21:03 44455 8192000000 10878227680 11357331456 1959671936 19.303 100 11 22 0 1971703008 8871152 3159920
01:21:54 28431 8192000000 10886877552 11370729472 1968524384 19.374 100 12 23 0 1981624176 10134016 2965776
01:22:54 75712 8192000000 10882725536 11362492416 1945362784 19.190 98 18 36 1 1960342032 10138928 4840320
01:24:19 39316 8192000000 10863100944 11336392704 1898187936 18.812 97 6 12 1 1911943664 12245712 1510016
01:25:06 47240 8192000000 10861979472 11337773056 1908755088 18.897 98 12 24 0 1922892720 10979008 3158624
01:26:08 50193 8192000000 10864905456 11337592832 1913299392 18.933 99 18 37 0 1926434384 7813056 5321936
01:27:07 14707 8192000000 9074579184 9288634368 248618656 2.945 13 5 9 0 256333056 6287424 1426976

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 10-02-2021 01:28:45 to 10-02-2021 01:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 158 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-02-2021 01:29:18 to 10-02-2021 01:29:20.

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          238731
MON$OLDEST_ACTIVE               238732
MON$OLDEST_SNAPSHOT             238732
MON$NEXT_TRANSACTION            238732
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                       2031584
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:153: 
:154: mscs-test-161.budzdorov.ru    Wed Feb 10 01:27:25 2021
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
:157: 
:158: mscs-test-161.budzdorov.ru    Wed Feb 10 01:27:28 2021
:159:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:160: 
:161: 
:162: mscs-test-161.budzdorov.ru    Wed Feb 10 01:27:28 2021
:163:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:164: 
--- end of diff output ---

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

10.02.21 01:29:21. 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-02-10 01:29:23 No severe PSQL-related problems occured
10.02.21 01:29:24. End of report.