Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.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 17417484 kB
MemAvailable 31344080 kB
Buffers 0 kB
Cached 14246448 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-10 19:27:08
DTS_END                         2021-01-10 19:27:08.0160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50770
TRN_ID                          243497
ATT_ID                          725
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: 9229.82 20045 1107578
customer order: creation 176.53 353 21184
customer order: refuse 14.55 336 1746
order to supplier: creation 47.33 1154 5680
order to supplier: removal 3.27 97264 392
invoice (draft): creation 46.43 3123 5572
invoice (draft): removal 50.79 740 6095
invoice accept: apply 43.66 17327 5239
invoice accept: cancel 46.07 747 5528
customer reserve: creation 4006.85 173 480822
customer reserve: removal 4495.22 56 539426
realization accept: apply 85.26 170 10231
realization accept: cancel 82.82 108 9938
payment from customer: creation 60.78 97 7293
payment from customer: removal 5.67 83 680
payment to supplier: creation 48.89 119 5867
payment to supplier: removal 3.27 61 392
service: total inventory turnovers 4.81 1166 577
service: total monetary turnovers 6.69 22 803
service: aggregate perf. data 0.91 21539 109
service: refresh index statistics 0.03 256252 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-01-2021 19:27:59 to 10-01-2021 19:28:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8234
TEST_TIME 2 6209
TEST_TIME 3 5287
TEST_TIME 4 5381
TEST_TIME 5 5101
TEST_TIME 6 4944
TEST_TIME 7 5177
TEST_TIME 8 5251
TEST_TIME 9 5513
TEST_TIME 10 5570
TEST_TIME 11 5977
TEST_TIME 12 5968
TEST_TIME 13 6165
TEST_TIME 14 6529
TEST_TIME 15 7092
TEST_TIME 16 6992
TEST_TIME 17 7922
TEST_TIME 18 7803
TEST_TIME 19 7935
TEST_TIME 20 8634
TEST_TIME 21 8922
TEST_TIME 22 9494
TEST_TIME 23 9919
TEST_TIME 24 10107
TEST_TIME 25 10126
TEST_TIME 26 11014
TEST_TIME 27 10805
TEST_TIME 28 10598
TEST_TIME 29 10325
TEST_TIME 30 10498
TEST_TIME 31 10364
TEST_TIME 32 10217
TEST_TIME 33 10257
TEST_TIME 34 10109
TEST_TIME 35 9952
TEST_TIME 36 9868
TEST_TIME 37 9861
TEST_TIME 38 9898
TEST_TIME 39 9775
TEST_TIME 40 9625
TEST_TIME 41 9576
TEST_TIME 42 9475
TEST_TIME 43 9412
TEST_TIME 44 9430
TEST_TIME 45 9435
TEST_TIME 46 9343
TEST_TIME 47 9511
TEST_TIME 48 9559
TEST_TIME 49 9613
TEST_TIME 50 9581
TEST_TIME 51 9621
TEST_TIME 52 9571
TEST_TIME 53 9690
TEST_TIME 54 9686
TEST_TIME 55 9771
TEST_TIME 56 9833
TEST_TIME 57 9823
TEST_TIME 58 9676
TEST_TIME 59 9540
TEST_TIME 60 9508
TEST_TIME 61 9629
TEST_TIME 62 9555
TEST_TIME 63 9506
TEST_TIME 64 9436
TEST_TIME 65 9453
TEST_TIME 66 9445
TEST_TIME 67 9412
TEST_TIME 68 9475
TEST_TIME 69 9434
TEST_TIME 70 9446
TEST_TIME 71 9454
TEST_TIME 72 9550
TEST_TIME 73 9516
TEST_TIME 74 9513
TEST_TIME 75 9510
TEST_TIME 76 9490
TEST_TIME 77 9547
TEST_TIME 78 9601
TEST_TIME 79 9634
TEST_TIME 80 9559
TEST_TIME 81 9489
TEST_TIME 82 9539
TEST_TIME 83 9522
TEST_TIME 84 9468
TEST_TIME 85 9431
TEST_TIME 86 9390
TEST_TIME 87 9348
TEST_TIME 88 9301
TEST_TIME 89 9294
TEST_TIME 90 9262
TEST_TIME 91 9261
TEST_TIME 92 9274
TEST_TIME 93 9270
TEST_TIME 94 9353
TEST_TIME 95 9374
TEST_TIME 96 9497
TEST_TIME 97 9465
TEST_TIME 98 9478
TEST_TIME 99 9515
TEST_TIME 100 9488
TEST_TIME 101 9474
TEST_TIME 102 9478
TEST_TIME 103 9586
TEST_TIME 104 9535
TEST_TIME 105 9456
TEST_TIME 106 9421
TEST_TIME 107 9377
TEST_TIME 108 9396
TEST_TIME 109 9334
TEST_TIME 110 9321
TEST_TIME 111 9312
TEST_TIME 112 9273
TEST_TIME 113 9272
TEST_TIME 114 9316
TEST_TIME 115 9326
TEST_TIME 116 9306
TEST_TIME 117 9321
TEST_TIME 118 9339
TEST_TIME 119 9304
TEST_TIME 120 9231

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-01-2021 19:28:03 to 10-01-2021 19:28:06.

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 1550238 1550238 0 0.00 0 31640 6 0 0
doc_list_biud 1550237 1550237 0 0.00 0 27494 25 0 0
sp_add_invoice_to_stock 5328 5239 89 1.67 32 170284 17328 0 89
sp_cancel_adding_invoice 5528 5528 0 0.00 5 55387 747 0 0
sp_cancel_client_order 1746 1746 0 0.00 4 9790 336 0 0
sp_cancel_customer_reserve 539426 539426 0 0.00 1 26523 57 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 2 7921 84 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 2778 61 0 0
sp_cancel_supplier_invoice 6102 6095 7 0.11 1 21080 741 0 7
sp_cancel_supplier_order 392 392 0 0.00 8 916057 97265 0 0
sp_cancel_write_off 9938 9938 0 0.00 1 31642 109 0 0
sp_client_order 21184 21184 0 0.00 3 20238 354 0 0
sp_customer_reserve 480822 480822 0 0.00 0 38939 174 0 0
sp_fill_shopping_cart 32431 32431 0 0.00 1 14551 41 0 0
sp_fill_shopping_cart_clo_res 480821 480821 0 0.00 0 14369 13 0 0
sp_get_clo_for_invoice 5237 5237 0 0.00 0 33147 300 0 0
sp_kill_cost_storno 16538 16538 0 0.00 0 31640 49 0 0
sp_kill_qstorno_ret_qs2qd 1095277 1095277 0 0.00 0 26520 31 0 0
sp_kill_qty_storno 578593 578593 0 0.00 0 27492 66 0 0
sp_lock_selected_doc 21186 21186 0 0.00 0 6850 5 0 0
sp_make_cost_storno 28628 28628 0 0.00 0 12646 49 0 0
sp_multiply_rows_for_pdistr 28628 28628 0 0.00 0 11794 24 0 0
sp_multiply_rows_for_qdistr 21184 21184 0 0.00 0 13531 175 0 0
sp_pay_from_customer 7293 7293 0 0.00 4 20458 97 0 0
sp_pay_to_supplier 5867 5867 0 0.00 4 20459 119 0 0
sp_payment_common 13160 13160 0 0.00 1 11767 22 0 0
sp_qd_handle_on_cancel_clo 1746 1746 0 0.00 0 8026 304 0 0
sp_qd_handle_on_invoice_upd_sts 10765 10765 0 0.00 0 27491 311 0 0
sp_qd_handle_on_reserve_upd_sts 10231 10231 0 0.00 0 16110 63 0 0
sp_reserve_write_off 10231 10231 0 0.00 6 18210 171 0 0
sp_supplier_invoice 5572 5572 0 0.00 7 74868 3123 0 0
sp_supplier_order 5680 5680 0 0.00 5 41100 1154 0 0
srv_aggregate_perf_data 110 109 1 0.90 2904 394148 21540 0 1
srv_fill_mon_cache_memory 155 155 0 0.00 1653 142103 33208 0 0
srv_find_qd_qs_mism 1057302 1057302 0 0.00 0 11542 5 0 0
srv_make_invnt_saldo 577 577 0 0.00 34 103558 1166 0 0
srv_make_money_saldo 803 803 0 0.00 1 1624 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 138228 423898 256252 0 0
t$perf-abend:sp_add_invoice_to_stock 89 89 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 5239 5239 0 0.00 0 8170 150 0 0
t$perf-norm:sp_cancel_adding_invoice 387 387 0 0.00 0 2260 69 0 0
t$perf-norm:sp_cancel_client_order 1746 1746 0 0.00 0 2950 15 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 730 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 2220 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 344 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 364 364 0 0.00 0 1186 15 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 20709 1417 0 0
t$perf-norm:sp_cancel_write_off 1026 1026 0 0.00 0 6643 16 0 0
t$perf-norm:sp_client_order 21184 21184 0 0.00 0 8288 16 0 0
t$perf-norm:sp_customer_reserve 1000 1000 0 0.00 0 6514 17 0 0
t$perf-norm:sp_pay_from_customer 7293 7293 0 0.00 0 5452 8 0 0
t$perf-norm:sp_pay_to_supplier 5867 5867 0 0.00 0 7703 12 0 0
t$perf-norm:sp_reserve_write_off 10231 10231 0 0.00 0 3443 9 0 0
t$perf-norm:sp_supplier_invoice 5572 5572 0 0.00 0 7850 16 0 0
t$perf-norm:sp_supplier_order 5680 5680 0 0.00 0 5986 15 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 1238 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 514 9 0 0
t$perf-norm:srv_make_invnt_saldo 577 577 0 0.00 0 3144 31 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 964 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10652 10474 178 1.67 0 7004 18 0 178
v_all_customers 38504 38504 0 0.00 0 78 1 0 0
v_all_suppliers 30716 30716 0 0.00 0 20 1 0 0
v_all_wares 42368 42368 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 774 774 0 0.00 0 319 6 0 0
v_cancel_client_order 3492 3492 0 0.00 0 2911 6 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 2837 10 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 3313 8 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 346 3 0 0
v_cancel_supplier_invoice 742 728 14 1.88 0 578 12 0 14
v_cancel_supplier_order 784 784 0 0.00 0 160 2 0 0
v_cancel_write_off 2052 2052 0 0.00 0 2811 17 0 0
v_max_id_clo_ord 5675 5675 0 0.00 0 1025 1 0 0
v_max_id_clo_res 1000 1000 0 0.00 0 4768 29 0 0
v_max_id_ord_sup 5571 5571 0 0.00 0 6811 5 0 0
v_max_non_paid_invoice 1755 1755 0 0.00 0 429 2 0 0
v_max_non_paid_realizn 3885 3885 0 0.00 0 2474 3 0 0
v_min_id_clo_ord 5675 5675 0 0.00 0 9110 13 0 0
v_min_id_clo_res 1000 1000 0 0.00 0 5252 17 0 0
v_min_id_ord_sup 5571 5571 0 0.00 0 6648 7 0 0
v_min_non_paid_invoice 5867 5867 0 0.00 0 9436 15 0 0
v_min_non_paid_realizn 7293 7293 0 0.00 0 11750 13 0 0
v_our_firm 10680 10680 0 0.00 0 11 1 0 0
v_reserve_write_off 20462 20462 0 0.00 0 3513 6 0 0
x_lock_depdocs_on_canc_invoice 11259 11259 0 0.00 0 15803 106 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 12583 333 0 0
x_make_qstorno_1000_1200 5680 5680 0 0.00 2 41091 1068 0 0
x_make_qstorno_1200_2000 5572 5572 0 0.00 2 74780 2977 0 0
x_make_qstorno_2100_3300 480822 480822 0 0.00 0 38938 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-01-2021 19:28:07 to 10-01-2021 19:28:11.

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:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:18 13144 8192000000 10199677232 10499043328 832288000 9.222 67 54 111 1 852467328 2225424 17953904
16:57:40 29475 8192000000 10341529056 10660519936 1387932208 14.487 100 79 158 0 1418318272 4580800 25805264
16:58:27 18510 8192000000 10364942528 10687520768 1427447360 14.839 100 87 174 0 1462745408 6803824 28494224
16:59:00 25955 8192000000 10403261328 10730061824 1452876784 15.063 100 86 172 0 1488295056 7297488 28120784
16:59:35 13237 8192000000 10418452032 10744152064 1471815984 15.230 100 88 176 0 1508098048 7891440 28390624
17:00:08 26017 8192000000 10435792144 10769788928 1490302176 15.392 100 92 184 0 1528448144 8700960 29445008
17:00:41 23825 8192000000 10462416656 10801217536 1517130128 15.625 100 84 168 0 1551921328 8858704 25932496
17:01:19 16507 8192000000 10495260688 10839842816 1545168432 15.868 100 81 162 3 1579775024 9443440 25163152
17:01:47 19503 8192000000 10523264944 10873556992 1580620672 16.173 100 83 166 2 1616300192 10410480 25269040
17:02:16 11019 8192000000 10537130032 10889863168 1594374096 16.291 100 79 158 0 1629430672 10908960 24147616
17:02:35 14623 8192000000 10553249904 10908454912 1607858592 16.406 100 73 146 1 1640040400 10280880 21900928
17:02:57 16391 8192000000 10585903664 10947321856 1643545728 16.710 100 83 165 0 1678879776 11136656 24197392
17:03:25 10953 8192000000 10606472640 10969059328 1659905456 16.848 100 77 152 0 1694063936 11405840 22752640
17:03:46 7214 8192000000 10620588512 10987094016 1681937504 17.034 100 76 152 0 1715350496 11335056 22077936
17:04:02 9051 8192000000 10638174304 11009556480 1698560448 17.173 100 74 149 1 1731376864 11273296 21543120
17:04:18 5962 8192000000 10653908032 11028455424 1720153456 17.353 100 78 156 3 1754835552 11949712 22732384
17:04:33 6523 8192000000 10667932160 11041931264 1729831888 17.434 100 75 149 2 1762634096 11410896 21391312
17:04:47 7213 8192000000 10678385008 11059863552 1747094032 17.578 100 79 158 2 1781748288 11464416 23189840
17:05:01 7300 8192000000 10692831808 11074048000 1759165008 17.677 100 78 156 2 1793922288 12022032 22735248
17:05:16 4901 8192000000 10713644976 11091714048 1769575840 17.764 100 77 154 0 1803358240 12148192 21634208
17:05:28 8018 8192000000 10721252640 11100237824 1778754304 17.839 100 82 164 1 1815271936 13405744 23111888
17:05:45 5008 8192000000 10724113808 11100917760 1783598176 17.879 100 81 161 1 1819565664 12954464 23013024
17:05:57 3762 8192000000 10725613712 11109879808 1792938896 17.956 100 86 172 2 1829686080 12618160 24129024
17:06:07 3578 8192000000 10742406176 11123142656 1802399776 18.034 100 85 170 1 1839345840 13638912 23307152
17:06:18 4619 8192000000 10743501280 11128623104 1806320816 18.066 100 85 168 3 1843159664 13513472 23325376
17:06:30 2913 8192000000 10755374592 11135307776 1812048432 18.113 100 87 174 0 1850425952 14099184 24278336
17:06:39 2102 8192000000 10756245536 11142004736 1815632784 18.142 100 87 174 0 1854014064 14635344 23745936
17:06:48 4448 8192000000 10758953168 11144642560 1815576656 18.142 100 74 147 2 1849505904 13682560 20246688
17:06:59 2200 8192000000 10765196064 11152084992 1823960960 18.210 100 84 167 0 1860677360 13269056 23447344
17:07:07 3011 8192000000 10774602960 11166625792 1824774800 18.217 100 68 137 2 1856552800 12964384 18813616
17:07:17 1737 8192000000 10785278816 11172749312 1842952576 18.365 100 86 172 0 1880913648 13421024 24540048
17:07:25 1915 8192000000 10790247600 11174973440 1851975424 18.438 100 92 179 3 1890120272 12160064 25984784
17:07:34 1438 8192000000 10802914704 11186798592 1855839632 18.470 100 88 176 2 1892417440 11648048 24929760
17:07:42 2173 8192000000 10796839200 11186421760 1858247008 18.489 100 82 163 0 1892199456 10634800 23317648
17:07:50 1395 8192000000 10810999984 11198365696 1867215456 18.562 100 96 190 2 1907703856 12868768 27619632
17:07:58 2271 8192000000 10812653424 11202240512 1869126448 18.577 100 96 192 0 1910265952 14216768 26922736
17:08:06 1723 8192000000 10814992944 11202539520 1869915056 18.584 100 92 183 2 1910040192 14471216 25653920
17:08:14 1425 8192000000 10824037472 11212304384 1878402672 18.652 100 96 192 0 1919379424 13762816 27213936
17:08:23 2101 8192000000 10819824000 11211685888 1876357120 18.636 100 90 178 1 1915392832 13719040 25316672
17:08:31 2039 8192000000 10817233808 11213832192 1879873360 18.664 100 88 176 0 1917630064 13484976 24271728
17:08:40 16560 8192000000 10819245184 11213488128 1880057568 18.666 100 76 152 2 1912887936 11440624 21389744
17:09:03 18104 8192000000 10822602640 11216674816 1879554736 18.662 100 74 150 0 1911793552 10965632 21273184
17:09:27 2006 8192000000 10826135360 11225255936 1884440784 18.701 100 79 160 1 1918309408 11606672 22261952
17:09:36 21641 8192000000 10802530448 11219582976 1881511744 18.677 100 48 97 0 1904214864 8051936 14651184
17:10:04 9223 8192000000 10783864896 11214807040 1880372832 18.668 100 28 56 2 1894675712 6386976 7915904
17:10:20 5299 8192000000 10786449152 11217707008 1886769280 18.720 100 36 72 0 1904339248 6937232 10632736
17:10:32 7487 8192000000 10783354272 11217481728 1884970736 18.705 100 27 54 0 1899546592 5932048 8643808
17:10:47 5097 8192000000 10794735088 11223019520 1888927424 18.737 100 35 68 3 1906269632 8315856 9026352
17:10:59 11824 8192000000 10797681168 11223027712 1886048272 18.714 100 19 38 2 1897555168 6461328 5045568
17:11:18 9190 8192000000 10811185680 11231068160 1893862560 18.777 100 27 52 2 1907438496 6192304 7383632
17:11:35 15605 8192000000 10796076416 11229364224 1890746272 18.752 100 15 29 1 1899880944 5354928 3779744
17:12:02 11463 8192000000 10797470160 11234127872 1893619792 18.775 100 15 30 0 1903603952 5851120 4133040
17:12:25 9891 8192000000 10798629216 11234172928 1894993408 18.786 100 15 30 1 1905196384 6173424 4029552
17:12:43 9196 8192000000 10814881280 11238793216 1898794800 18.817 100 17 34 1 1909042784 5161024 5086960
17:12:59 20127 8192000000 10799008928 11237826560 1898730480 18.816 100 12 24 0 1907863024 5271328 3861216
17:13:28 80218 8192000000 10807632672 11255058432 1904043312 18.859 100 26 51 1 1917268912 5696256 7529344
17:14:55 4950 8192000000 10818810224 11251548160 1905464288 18.870 100 24 48 3 1919019840 6216176 7339376
17:15:08 4600 8192000000 10831515744 11263856640 1909737600 18.905 100 40 81 1 1932639696 12119488 10782608
17:15:19 6638 8192000000 10814373504 11257139200 1907018816 18.883 100 25 50 2 1921351344 7478976 6853552
17:15:33 6489 8192000000 10830351792 11261194240 1911408064 18.918 100 31 63 0 1926315936 6441216 8466656
17:15:45 9421 8192000000 10832188560 11256590336 1890390112 18.749 99 28 56 1 1904653296 6134656 8128528
17:16:01 7046 8192000000 10817119296 11253895168 1904016016 18.859 100 21 42 2 1915096208 4975584 6104608
17:16:15 7587 8192000000 10819417360 11253731328 1904249072 18.860 100 19 38 0 1915368096 5901552 5217472
17:16:31 7577 8192000000 10823012000 11255824384 1887561376 18.726 99 22 44 0 1899770768 6230256 5979136
17:16:49 9765 8192000000 10804677648 11243630592 1882283024 18.684 99 13 24 2 1891145872 5624464 3238384
17:17:06 6558 8192000000 10804606176 11242307584 1882499408 18.685 99 21 42 2 1894280448 6113008 5668032
17:17:21 11385 8192000000 10743652688 11172106240 1804523840 18.051 95 20 40 2 1815526848 5375808 5627200
17:17:40 11686 8192000000 10771357232 11198066688 1819527104 18.174 97 12 24 1 1828799952 5300336 3972512
17:18:01 22102 8192000000 10696197728 11113480192 1637906016 16.662 88 12 23 0 1645561200 4587568 3067616
17:18:55 37371 8192000000 10687461728 11100311552 1582607664 16.191 86 35 69 1 1597899424 5522928 9768832
17:19:40 6979 8192000000 10703186208 11123892224 1773319776 17.794 99 35 70 2 1790338128 7510848 9507504
17:19:54 8042 8192000000 10721236288 11139784704 1802738064 18.036 100 33 64 2 1818325952 6805072 8782816
17:20:08 6742 8192000000 10737385856 11151568896 1805212768 18.057 99 31 63 1 1820941280 6947584 8780928
17:20:21 8409 8192000000 10719611776 11134259200 1730688208 17.441 95 21 40 2 1742344496 5976432 5679856
17:20:38 4260 8192000000 10702563424 11115225088 1781704880 17.864 99 21 42 0 1792989472 5445120 5839472
17:20:49 9908 8192000000 10714405120 11132440576 1739778992 17.517 96 28 54 3 1753667104 6166000 7722112
17:21:05 5797 8192000000 10713871760 11126325248 1763906848 17.717 98 33 65 0 1779396112 6600032 8889232
17:21:18 6904 8192000000 10697807264 11112378368 1737138496 17.495 97 15 30 1 1746352720 5111936 4102288
17:21:33 5288 8192000000 10708260512 11121217536 1782310576 17.869 99 25 50 0 1794363488 5212000 6840912
17:21:46 8365 8192000000 10746338656 11157688320 1817852192 18.160 100 15 29 1 1826709584 4739808 4117584
17:22:01 9391 8192000000 10745743168 11166507008 1809137168 18.089 99 18 35 0 1818633568 4711280 4785120
17:22:21 9758 8192000000 10755799056 11170385920 1826699456 18.232 100 25 50 0 1843978160 9261536 8017168
17:22:37 11817 8192000000 10758993264 11180892160 1821452208 18.190 99 29 59 2 1836070128 5981696 8636224
17:22:57 87210 8192000000 10753692096 11184357376 1813643408 18.126 98 22 44 1 1826412976 5362400 7407168
17:24:34 5483 8192000000 10766411760 11188826112 1837544160 18.321 99 36 72 2 1855030256 7094000 10392096
17:24:49 11114 8192000000 10783266384 11203411968 1859430432 18.499 100 45 87 1 1878745360 7257888 12057040
17:25:06 7993 8192000000 10764172656 11202625536 1860772864 18.510 100 21 42 3 1873031632 5770160 6488608
17:25:21 7079 8192000000 10787306512 11209068544 1868820624 18.575 100 25 49 1 1881901952 5545008 7536320
17:25:36 5505 8192000000 10789467392 11212894208 1869583872 18.581 100 19 38 1 1880095472 4929888 5581712
17:25:50 5786 8192000000 10789982656 11217620992 1872661280 18.606 100 23 46 2 1885525088 6211680 6652128
17:26:04 6334 8192000000 10793813024 11220070400 1873324672 18.611 100 18 36 0 1883983664 5742528 4916464
17:26:16 6044 8192000000 10786960592 11222110208 1874829680 18.623 100 26 51 1 1893174832 11274992 7070160
17:26:29 6252 8192000000 10792800272 11224203264 1875282592 18.627 100 20 40 2 1891057088 10140848 5633648
17:26:42 9032 8192000000 10795829312 11223969792 1877479648 18.645 100 24 48 1 1890284480 6285776 6519056
17:27:01 9905 8192000000 10811487392 11233562624 1886066160 18.714 100 19 38 0 1896389600 4936208 5387232
17:27:19 4902 8192000000 10846061312 11257688064 1913942000 18.938 100 59 118 2 1938783376 7673968 17167408
17:27:34 6381 8192000000 10865169024 11272577024 1917840240 18.970 100 67 134 1 1945517072 9135424 18541408
17:27:48 6682 8192000000 10871522736 11279859712 1929233952 19.061 100 64 125 2 1956234752 9970240 17030560
17:28:08 47069 8192000000 10866602544 11286675456 1932846784 19.090 100 54 109 2 1958148272 10155872 15145616
17:29:07 54566 8192000000 10873432432 11302289408 1942966272 19.170 100 49 97 0 1965432528 7945680 14520576
17:30:10 15699 8192000000 10879285664 11308568576 1951387968 19.238 100 41 78 3 1972366176 9939040 11039168
17:30:51 12862 8192000000 10897565040 11323052032 1961550320 19.318 100 45 90 0 1986516688 11907056 13059312
17:31:12 18072 8192000000 10905154880 11329556480 1966394560 19.357 100 53 104 1 1992996064 11755920 14845584
17:31:42 14424 8192000000 10903909648 11333091328 1969414352 19.381 100 42 84 0 1992629360 10287600 12927408
17:32:18 29593 8192000000 10903364592 11343757312 1973755760 19.415 100 35 70 1 1995151104 10955376 10439968
17:32:55 21230 8192000000 10913043072 11350417408 1985963200 19.512 100 41 82 0 2010132800 11704640 12464960
17:33:24 13604 8192000000 10918562000 11358011392 1988711760 19.534 100 39 77 2 2012984576 12599376 11673440
17:33:45 13725 8192000000 10947933248 11374989312 1996978896 19.599 100 46 92 2 2026159488 15237424 13943168
17:34:13 14579 8192000000 10955817184 11392614400 2004231760 19.656 100 49 97 2 2041663392 23399296 14032336
17:34:38 7604 8192000000 10966645760 11393732608 2009532560 19.698 100 56 110 2 2047850800 21559760 16758480
17:34:53 11912 8192000000 10946865440 11387334656 2003062656 19.647 100 45 90 1 2042257728 26284592 12910480
17:35:18 13288 8192000000 10973062192 11397660672 2011462992 19.713 100 55 108 0 2051174336 22786096 16925248
17:35:40 7665 8192000000 10942656448 11372560384 1987618368 19.525 99 63 122 2 2032133552 25107312 19407872
17:35:56 9841 8192000000 10955203536 11389263872 2004895824 19.661 100 63 126 1 2048982432 24495584 19591024
17:36:15 13195 8192000000 10953714624 11389247488 2006961600 19.678 100 53 106 0 2045761776 22781984 16018192
17:36:39 10000 8192000000 10945987520 11377692672 1983208832 19.490 99 61 123 3 2023359776 22535616 17615328
17:36:57 7786 8192000000 10947052480 11376078848 1996969568 19.599 100 68 135 2 2040562800 23345728 20247504
17:37:13 1883 8192000000 10951382448 11361792000 1982163520 19.482 100 78 151 1 2028490624 23680064 22647040
17:37:23 2132 8192000000 10957569776 11370762240 1995361392 19.586 100 88 175 3 2045590000 24492176 25736432
17:37:32 6201 8192000000 10957726880 11372392448 1979688736 19.462 99 73 146 0 2027281280 26096160 21496384
17:37:47 6567 8192000000 10959796096 11382755328 1996723440 19.597 100 71 142 1 2044957504 27207440 21026624
17:38:01 6607 8192000000 10956564352 11384135680 2002539280 19.643 100 62 124 0 2048609184 27823136 18246768
17:38:15 4676 8192000000 10966070432 11384221696 2004356512 19.657 100 81 160 3 2054473472 26305056 23811904
17:38:28 2990 8192000000 10973494224 11390783488 2008617504 19.691 100 76 150 0 2058890928 28106032 22167392
17:38:40 4545 8192000000 10955808400 11375386624 1989294944 19.538 99 76 149 4 2038637248 27500048 21842256
17:38:56 4542 8192000000 10960949920 11392638976 2006540176 19.674 100 62 124 1 2053519616 27412480 19566960
17:39:10 5245 8192000000 10954021568 11383349248 2000697504 19.628 100 72 144 1 2048929472 26330800 21901168
17:39:28 2288 8192000000 10961826192 11394875392 2005817472 19.669 100 66 127 1 2052786128 26103328 20865328
17:39:39 6340 8192000000 10989016448 11409625088 2012392288 19.720 100 74 147 2 2066168080 31195664 22580128
17:40:04 2945 8192000000 10991076976 11416809472 2017023968 19.757 100 66 132 2 2073865440 36496752 20344720
17:40:13 2206 8192000000 10978985520 11398582272 1979893952 19.464 98 81 161 0 2041771600 37351984 24525664
17:40:22 5440 8192000000 10989534464 11401580544 2002307648 19.641 100 79 155 1 2065196384 39646208 23242528
17:40:35 2565 8192000000 10974675328 11394252800 1982791280 19.487 99 75 149 0 2046099072 40129760 23178032
17:40:45 2685 8192000000 10984355456 11395698688 1995179568 19.585 100 71 141 0 2057662960 39335856 23147536
17:40:55 4534 8192000000 10978402304 11395493888 1994238784 19.577 100 73 146 0 2058885472 42222400 22424288
17:41:07 2441 8192000000 10950562736 11370156032 1964790416 19.344 99 68 133 0 2026647936 40885776 20971744
17:41:19 2436 8192000000 10972337792 11387895808 1992891504 19.567 100 81 161 1 2057275952 39739696 24644752
17:41:30 3195 8192000000 10963551312 11386855424 1988036352 19.528 100 74 148 0 2054351632 43192880 23122400
17:41:40 3130 8192000000 10985726672 11404783616 2000661808 19.628 100 79 154 1 2069186064 42764832 25759424
17:41:50 3589 8192000000 10982903136 11403706368 1998549696 19.611 100 77 153 3 2067819104 44592144 24677264
17:42:02 3884 8192000000 10979639136 11404349440 2001863200 19.637 100 69 136 0 2068681200 45334048 21483952
17:42:26 5229 8192000000 10964997328 11387633664 1985951520 19.512 100 68 136 1 2052815104 45256480 21607104
17:42:41 12510 8192000000 10957724608 11386515456 1978697872 19.454 100 57 115 1 2043704080 46428912 18577296
17:43:09 2622 8192000000 10937751744 11357925376 1958399968 19.293 99 67 131 3 2022585616 42784992 21400656
17:43:18 10777 8192000000 10933249216 11358666752 1934891808 19.106 98 63 124 1 1997797424 42975424 19930192
17:43:41 4252 8192000000 10904151840 11324420096 1896640336 18.799 97 61 120 0 1961487424 45886960 18960128
17:43:52 5091 8192000000 10930609504 11350241280 1942866624 19.170 100 58 115 1 2008501360 47544448 18090288
17:44:08 6878 8192000000 10934247024 11356762112 1955802800 19.273 100 65 129 0 2018960880 43664624 19493456
17:44:23 4319 8192000000 10944595936 11365580800 1962161696 19.323 100 74 149 1 2030915872 45750256 23003920
17:44:34 16983 8192000000 10872347744 11321683968 1905326704 18.869 98 53 106 1 1969462656 47223248 16912704
17:45:24 10011 8192000000 10892005472 11323125760 1901156496 18.836 98 38 76 1 1951747344 37938704 12652144
17:45:42 10346 8192000000 10903135328 11332886528 1904924320 18.866 98 31 62 1 1956414240 40896032 10593888
17:46:00 19161 8192000000 10906861840 11344936960 1904741360 18.864 98 44 88 0 1968197216 48908032 14547824
17:46:32 13336 8192000000 10912262848 11352477696 1942074576 19.163 100 31 62 0 1997243584 43569888 11599120
17:46:58 3730 8192000000 10934093968 11358277632 1935079312 19.107 99 68 137 2 2005183712 48612496 21491904
17:47:10 5513 8192000000 10927813728 11362271232 1938295264 19.133 99 58 117 0 2003563120 46508000 18759856
17:47:23 24063 8192000000 10916601760 11356602368 1946628096 19.200 100 27 51 1 1995899296 40671376 8599824
17:48:06 18195 8192000000 10908926960 11355758592 1934743760 19.105 99 29 58 1 1987846784 42793392 10309632
17:48:36 20002 8192000000 10901320384 11338321920 1903104384 18.851 98 27 54 1 1955154224 42369504 9680336
17:49:02 21839 8192000000 10895582096 11335147520 1916182944 18.956 99 22 44 0 1976853056 52624384 8045728
17:49:32 10866 8192000000 10886032400 11322388480 1888996112 18.738 98 32 64 1 1943368496 43487648 10884736
17:49:51 8435 8192000000 10894404256 11327909888 1918752864 18.977 100 37 74 0 1969287168 37904928 12629376
17:50:06 1653 8192000000 10911399792 11339993088 1936408848 19.118 100 63 126 3 1995738384 39977408 19352128
17:50:16 5442 8192000000 10914834976 11345371136 1936390896 19.118 100 59 118 1 1997986752 43353808 18242048
17:50:31 6784 8192000000 10886525696 11326103552 1919770576 18.985 100 46 92 1 1975813616 41342128 14700912
17:50:57 29323 8192000000 10861887840 11312627712 1907147120 18.884 99 15 30 0 1939876928 28181504 4548304
17:51:34 49306 8192000000 10863782880 11318714368 1892360272 18.765 98 20 40 2 1925060640 26722880 5977488
17:52:29 32820 8192000000 10868832080 11325759488 1899300288 18.821 99 16 30 0 1937186304 32014016 5872000
17:54:21 20005 8192000000 10871278576 11306987520 1911361024 18.918 99 38 76 2 1937961872 15500304 11100544
17:54:49 23365 8192000000 10870357712 11302690816 1902459760 18.846 99 37 72 3 1926199232 13423296 10316176
17:55:20 41305 8192000000 10857351296 11310178304 1909340880 18.901 99 43 82 1 1938740800 16587584 12812336
17:56:50 77208 8192000000 10840759024 11314171904 1904995184 18.866 99 19 38 3 1926344464 15996544 5352736
17:58:14 7655 8192000000 10859534256 11308183552 1905835824 18.873 99 17 33 2 1921598784 10777424 4985536
17:58:30 51944 8192000000 10877963056 11326083072 1943416256 19.174 100 32 62 0 1958249616 7064976 7768384
17:59:33 44893 8192000000 10867643744 11330256896 1937962640 19.130 99 32 64 4 1957512656 11381104 8168912
18:01:17 40223 8192000000 10894137088 11354877952 1972882080 19.408 100 12 24 0 1986778000 10496464 3399456
18:02:22 72075 8192000000 10903376304 11372961792 1980601408 19.469 100 16 32 1 1998883616 13791936 4490272
18:04:16 64956 8192000000 10874016992 11331153920 1887340944 18.724 95 25 50 0 1904276160 9496528 7438688
18:05:28 26985 8192000000 10877909376 11340791808 1957622528 19.287 100 16 32 0 1969291104 7415856 4252720
18:06:02 31477 8192000000 10895406576 11355136000 1965600288 19.351 100 9 18 0 1976063520 7876832 2586400
18:06:40 46379 8192000000 10894483040 11354861568 1970080432 19.386 100 23 46 0 1983256288 7019024 6156832
18:07:34 36141 8192000000 10902078864 11356622848 1953761664 19.256 99 38 74 1 1976222784 11556400 10904720
18:08:22 42726 8192000000 10872009856 11344400384 1943452560 19.174 99 18 36 1 1959832032 11586448 4793024
18:09:11 61995 8192000000 10879304480 11349131264 1958609728 19.295 100 12 24 0 1972685040 9972592 4102720
18:10:20 86274 8192000000 10893275840 11377553408 1969619264 19.382 100 19 38 2 1989935952 14530688 5786000
18:11:54 53148 8192000000 10893960480 11371008000 1969610656 19.382 100 16 32 3 1987161456 12878560 4672240
18:13:09 30543 8192000000 10913935232 11369848832 1941994928 19.163 98 23 46 1 1968340048 19508368 6836752
18:13:46 41132 8192000000 10900004272 11375120384 1977691744 19.446 100 26 52 1 2006469968 20772592 8005632
18:14:44 56724 8192000000 10892623328 11371479040 1953734560 19.256 99 14 28 2 1979333312 21240176 4358576
18:15:47 42475 8192000000 10884926976 11347755008 1927799248 19.049 98 23 47 2 1948104768 13650720 6654800
18:16:41 55009 8192000000 10907294208 11360878592 1948322160 19.213 99 16 32 0 1964386448 11726256 4338032
18:18:14 63189 8192000000 10910011312 11371982848 1972718896 19.407 100 16 31 0 1990908960 14000720 4189344
18:19:55 113503 8192000000 10904145440 11370471424 1926628320 19.040 97 12 24 0 1946068688 15830112 3610256
18:21:55 76692 8192000000 10886893680 11370348544 1901624032 18.839 96 32 64 0 1927545136 16940240 8980864
18:23:18 142103 8192000000 10878813408 11344109568 1864947792 18.543 95 11 22 0 1885890416 17265776 3676848
18:26:26 50168 8192000000 10876964112 11349536768 1955622896 19.271 100 31 62 1 1978627216 14210000 8794320
18:27:23 39973 8192000000 10880084512 11346071552 1923539264 19.015 98 19 38 0 1943806160 14580240 5686656
18:28:15 56475 8192000000 10849438368 11335110656 1891262064 18.756 97 4 8 0 1905853168 13882624 708480
18:29:17 31935 8192000000 10842192720 11304493056 1874924336 18.624 97 11 22 0 1883306160 5803968 2577856
18:29:55 52475 8192000000 10850135200 11320389632 1911332624 18.917 99 9 18 1 1926685808 13013152 2340032
18:30:54 42634 8192000000 10826351872 11304009728 1854731472 18.461 96 5 10 0 1866361024 10654224 975328
18:32:06 55090 8192000000 10848146432 11314266112 1902517088 18.847 99 11 22 1 1915980000 9271440 4191472
18:33:45 34401 8192000000 10843156112 11285200896 1855469744 18.467 97 22 44 2 1876258096 14349584 6438768
18:34:27 117144 8192000000 10853810656 11329089536 1882460208 18.685 98 19 38 0 1904789472 16670608 5658656
18:36:39 31660 8192000000 10850714208 11303596032 1901900832 18.842 98 22 44 2 1916958176 8509696 6547648
18:37:17 38281 8192000000 10868819424 11317342208 1879603824 18.662 97 35 70 2 1902790000 12989600 10196576
18:38:02 56629 8192000000 10862512592 11319988224 1892344368 18.765 98 20 40 3 1912661936 14342000 5975568
18:39:49 49036 8192000000 10831507968 11284414464 1845032240 18.382 96 22 44 0 1859562896 8675056 5855600
18:40:45 76672 8192000000 10816010480 11266568192 1800034960 18.014 94 21 41 0 1815483856 9328352 6120544
18:42:13 73268 8192000000 10830045744 11292381184 1847625264 18.403 97 16 32 0 1865563456 13679744 4258448
18:43:43 38507 8192000000 10836591520 11306385408 1894379248 18.781 99 24 48 2 1915933984 14908016 6646720
18:44:28 32587 8192000000 10857857504 11291918336 1868017952 18.568 97 32 65 2 1887548688 10037104 9493632
18:45:11 76259 8192000000 10840206112 11299340288 1855494352 18.467 97 27 54 0 1874126032 11428976 7202704
18:46:36 78681 8192000000 10850024096 11318779904 1909246688 18.901 99 17 34 4 1930932064 16456560 5228816
18:48:43 92869 8192000000 10881356608 11345309696 1933788688 19.097 100 17 34 0 1962463040 23325904 5348448
18:50:42 30176 8192000000 10857312032 11336728576 1915148960 18.948 99 7 14 0 1937859552 20649824 2060768
18:51:22 57279 8192000000 10858607472 11327291392 1935403184 19.110 100 12 24 1 1945253200 6546992 3303024
18:52:27 67344 8192000000 10866358864 11343380480 1955850400 19.273 100 11 22 0 1968780928 9573680 3356848
18:53:46 7884 8192000000 10867499536 11343237120 1952148256 19.244 100 5 10 1 1962907600 9228832 1530512
18:54:07 55903 8192000000 10874715872 11339448320 1923205280 19.013 98 21 42 0 1938005360 8739952 6060128
18:55:09 58179 8192000000 10872730432 11343953920 1955876160 19.273 100 16 32 0 1969303680 8680416 4747104
18:56:23 80523 8192000000 10906089776 11375878144 1949264912 19.221 99 10 20 0 1963921008 11922528 2733568
18:57:50 34661 8192000000 10894307808 11359223808 1965074624 19.346 99 17 34 1 1983127520 12996080 5056816
18:58:31 59367 8192000000 10885982096 11351150592 1896596256 18.799 96 12 24 2 1912796512 12972464 3227792
18:59:37 99999 8192000000 10920623136 11389349888 1903036032 18.851 96 24 48 1 1931086032 21285568 6764432
19:01:26 55299 8192000000 10892061888 11371765760 1932958928 19.091 98 15 30 1 1960795600 23428736 4407936
19:02:27 59685 8192000000 10886112544 11360862208 1926083232 19.036 98 15 29 2 1951891392 21450960 4357200
19:03:33 36242 8192000000 10872767456 11340935168 1919058064 18.979 98 13 26 0 1936339440 13863920 3417456
19:04:16 25345 8192000000 10916585584 11357687808 1954153392 19.260 99 50 99 0 1977406080 9542096 13710592
19:04:50 51003 8192000000 10903938992 11356688384 1960182464 19.307 100 33 65 2 1979785104 10612304 8990336
19:05:49 85658 8192000000 10898139504 11354181632 1929179520 19.060 98 13 26 1 1945074720 12122416 3772784
19:07:22 19735 8192000000 10920875264 11368120320 1977390416 19.444 100 43 86 2 1998281840 9239184 11652240
19:07:55 39419 8192000000 10910011856 11366514688 1963159552 19.331 99 35 70 0 1983353696 10419888 9774256
19:08:41 18995 8192000000 10911734864 11343888384 1900330528 18.829 96 38 76 1 1920489088 9654480 10504080
19:09:15 18775 8192000000 10911915600 11354107904 1943372336 19.174 99 44 88 0 1970009680 14311872 12325472
19:09:45 100658 8192000000 10907395920 11388096512 1972715856 19.407 100 17 34 0 1993188832 15615824 4857152
19:11:31 99878 8192000000 10891836880 11360735232 1965347952 19.349 99 20 40 0 1979191200 8458752 5384496
19:13:28 56495 8192000000 10899511488 11356192768 1925012416 19.027 97 33 64 0 1942218656 8285104 8921136
19:14:36 14163 8192000000 10901004048 11357220864 1974207232 19.419 100 34 68 2 1992422768 8572992 9642544
19:14:58 45524 8192000000 10889221248 11368251392 1964076800 19.338 99 14 28 0 1976723904 8995680 3651424
19:15:51 45900 8192000000 10866389232 11338579968 1936983984 19.123 98 6 12 1 1947926000 9301232 1640784
19:17:30 69325 8192000000 10857885312 11317653504 1832598496 18.281 93 18 36 0 1848395888 10377360 5420032
19:18:45 63443 8192000000 10865887584 11330859008 1909405088 18.902 98 21 42 0 1928196016 12262000 6528928
19:20:07 105472 8192000000 10876855312 11362246656 1918991136 18.979 98 17 34 0 1942205632 18546960 4667536
19:22:35 52619 8192000000 10851161264 11319881728 1883528752 18.694 97 22 44 1 1897322288 7732352 6061184
19:23:52 18515 8192000000 10872168000 11318415360 1907417744 18.886 99 48 94 0 1929039744 8656560 12965440
19:24:21 32290 8192000000 10842929568 11301740544 1859210064 18.497 96 42 84 0 1880616320 10185280 11220976
19:25:00 60294 8192000000 10856725408 11329097728 1909104448 18.899 99 16 32 1 1927382688 14021104 4257136
19:26:39 28868 8192000000 10915695200 11353878528 1937214944 19.125 99 38 76 1 1956637104 9122720 10299440

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 10-01-2021 19:28:13 to 10-01-2021 19:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 89 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-01-2021 19:28:44 to 10-01-2021 19:28:46.

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          242200
MON$OLDEST_ACTIVE               243879
MON$OLDEST_SNAPSHOT             243879
MON$NEXT_TRANSACTION            243879
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                       2011520
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 ---
:651: 
:652: mscs-test-161.budzdorov.ru    Sun Jan 10 19:27:12 2021
:653:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:654: 
--- end of diff output ---

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

10.01.21 19:28:47. 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-10 19:28:50 No severe PSQL-related problems occured
10.01.21 19:28:51. End of report.