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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-05 01:27:05
DTS_END                         2020-12-05 01:27:05.6070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37364
TRN_ID                          241874
ATT_ID                          709
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: 9311.38 19201 1117366
customer order: creation 178.08 372 21369
customer order: refuse 15.43 382 1851
order to supplier: creation 46.25 1368 5550
order to supplier: removal 3.41 96886 409
invoice (draft): creation 47.23 3203 5667
invoice (draft): removal 52.32 747 6278
invoice accept: apply 42.36 19822 5083
invoice accept: cancel 46.83 829 5620
customer reserve: creation 3967.73 195 476128
customer reserve: removal 4604.59 56 552551
realization accept: apply 85.87 177 10304
realization accept: cancel 87.93 105 10552
payment from customer: creation 60.78 119 7294
payment from customer: removal 5.98 95 717
payment to supplier: creation 50.23 132 6028
payment to supplier: removal 3.27 70 392
service: total inventory turnovers 4.93 1115 592
service: total monetary turnovers 7.28 43 874
service: aggregate perf. data 0.86 17526 103
service: refresh index statistics 0.03 240770 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-12-2020 01:27:54 to 05-12-2020 01:27:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6712
TEST_TIME 2 6387
TEST_TIME 3 5953
TEST_TIME 4 5896
TEST_TIME 5 5521
TEST_TIME 6 6166
TEST_TIME 7 6642
TEST_TIME 8 6555
TEST_TIME 9 6410
TEST_TIME 10 6842
TEST_TIME 11 6842
TEST_TIME 12 7026
TEST_TIME 13 7396
TEST_TIME 14 7523
TEST_TIME 15 7962
TEST_TIME 16 8300
TEST_TIME 17 8544
TEST_TIME 18 8971
TEST_TIME 19 9139
TEST_TIME 20 8991
TEST_TIME 21 9401
TEST_TIME 22 9379
TEST_TIME 23 9935
TEST_TIME 24 10322
TEST_TIME 25 10582
TEST_TIME 26 11190
TEST_TIME 27 11012
TEST_TIME 28 10830
TEST_TIME 29 10979
TEST_TIME 30 10917
TEST_TIME 31 10709
TEST_TIME 32 10777
TEST_TIME 33 10641
TEST_TIME 34 10410
TEST_TIME 35 10360
TEST_TIME 36 10391
TEST_TIME 37 10422
TEST_TIME 38 10528
TEST_TIME 39 10485
TEST_TIME 40 10333
TEST_TIME 41 10366
TEST_TIME 42 10375
TEST_TIME 43 10434
TEST_TIME 44 10429
TEST_TIME 45 10248
TEST_TIME 46 10047
TEST_TIME 47 10087
TEST_TIME 48 10037
TEST_TIME 49 9944
TEST_TIME 50 9910
TEST_TIME 51 9834
TEST_TIME 52 9747
TEST_TIME 53 9943
TEST_TIME 54 9886
TEST_TIME 55 9794
TEST_TIME 56 9746
TEST_TIME 57 9646
TEST_TIME 58 9518
TEST_TIME 59 9640
TEST_TIME 60 9541
TEST_TIME 61 9537
TEST_TIME 62 9521
TEST_TIME 63 9527
TEST_TIME 64 9576
TEST_TIME 65 9557
TEST_TIME 66 9633
TEST_TIME 67 9561
TEST_TIME 68 9620
TEST_TIME 69 9715
TEST_TIME 70 9698
TEST_TIME 71 9709
TEST_TIME 72 9744
TEST_TIME 73 9750
TEST_TIME 74 9726
TEST_TIME 75 9800
TEST_TIME 76 9784
TEST_TIME 77 9704
TEST_TIME 78 9614
TEST_TIME 79 9589
TEST_TIME 80 9558
TEST_TIME 81 9513
TEST_TIME 82 9476
TEST_TIME 83 9467
TEST_TIME 84 9397
TEST_TIME 85 9373
TEST_TIME 86 9327
TEST_TIME 87 9400
TEST_TIME 88 9444
TEST_TIME 89 9496
TEST_TIME 90 9523
TEST_TIME 91 9477
TEST_TIME 92 9523
TEST_TIME 93 9548
TEST_TIME 94 9575
TEST_TIME 95 9622
TEST_TIME 96 9613
TEST_TIME 97 9645
TEST_TIME 98 9677
TEST_TIME 99 9669
TEST_TIME 100 9585
TEST_TIME 101 9542
TEST_TIME 102 9514
TEST_TIME 103 9498
TEST_TIME 104 9458
TEST_TIME 105 9429
TEST_TIME 106 9391
TEST_TIME 107 9383
TEST_TIME 108 9340
TEST_TIME 109 9347
TEST_TIME 110 9384
TEST_TIME 111 9375
TEST_TIME 112 9372
TEST_TIME 113 9350
TEST_TIME 114 9363
TEST_TIME 115 9386
TEST_TIME 116 9380
TEST_TIME 117 9371
TEST_TIME 118 9384
TEST_TIME 119 9397
TEST_TIME 120 9319

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-12-2020 01:27:58 to 05-12-2020 01:28:01.

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 1558258 1558258 0 0.00 0 32210 7 0 0
doc_list_biud 1558258 1558258 0 0.00 0 55502 25 0 0
sp_add_invoice_to_stock 5245 5083 162 3.08 37 193004 19822 0 162
sp_cancel_adding_invoice 5620 5620 0 0.00 4 61080 829 0 0
sp_cancel_client_order 1851 1851 0 0.00 4 9841 383 0 0
sp_cancel_customer_reserve 552551 552551 0 0.00 1 55503 57 0 0
sp_cancel_pay_from_customer 717 717 0 0.00 3 6600 95 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 3872 71 0 0
sp_cancel_supplier_invoice 6287 6278 9 0.14 2 16795 747 0 9
sp_cancel_supplier_order 409 409 0 0.00 9 1063644 96887 0 0
sp_cancel_write_off 10552 10552 0 0.00 1 19625 106 0 0
sp_client_order 21369 21369 0 0.00 3 32227 373 0 0
sp_customer_reserve 476128 476128 0 0.00 0 76198 196 0 0
sp_fill_shopping_cart 32575 32575 0 0.00 1 26765 38 0 0
sp_fill_shopping_cart_clo_res 476103 476103 0 0.00 0 18740 12 0 0
sp_get_clo_for_invoice 5058 5058 0 0.00 0 20679 269 0 0
sp_kill_cost_storno 17281 17281 0 0.00 0 20937 53 0 0
sp_kill_qstorno_ret_qs2qd 1122341 1122341 0 0.00 0 55500 31 0 0
sp_kill_qty_storno 592623 592623 0 0.00 0 55502 66 0 0
sp_lock_selected_doc 21312 21312 0 0.00 0 9489 6 0 0
sp_make_cost_storno 28684 28684 0 0.00 0 12181 54 0 0
sp_multiply_rows_for_pdistr 28684 28684 0 0.00 0 32184 32 0 0
sp_multiply_rows_for_qdistr 21369 21369 0 0.00 0 11427 149 0 0
sp_pay_from_customer 7294 7294 0 0.00 4 16861 120 0 0
sp_pay_to_supplier 6028 6028 0 0.00 4 32215 132 0 0
sp_payment_common 13322 13322 0 0.00 1 16857 35 0 0
sp_qd_handle_on_cancel_clo 1851 1851 0 0.00 0 9834 341 0 0
sp_qd_handle_on_invoice_upd_sts 10678 10678 0 0.00 0 15925 321 0 0
sp_qd_handle_on_reserve_upd_sts 10304 10304 0 0.00 0 10050 50 0 0
sp_reserve_write_off 10304 10304 0 0.00 6 12157 178 0 0
sp_supplier_invoice 5667 5667 0 0.00 7 81584 3203 0 0
sp_supplier_order 5550 5550 0 0.00 5 69715 1368 0 0
srv_aggregate_perf_data 103 103 0 0.00 2505 121839 17526 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 800 175195 31063 0 0
srv_find_qd_qs_mism 1068237 1068237 0 0.00 0 23997 6 0 0
srv_make_invnt_saldo 592 592 0 0.00 57 59284 1116 0 0
srv_make_money_saldo 874 874 0 0.00 0 14864 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 216098 270576 240770 0 0
t$perf-abend:sp_add_invoice_to_stock 162 162 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5083 5083 0 0.00 0 9854 187 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 3210 109 0 0
t$perf-norm:sp_cancel_client_order 1851 1851 0 0.00 0 5402 15 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 3298 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 717 717 0 0.00 0 3336 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 1934 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 632 12 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 17490 1510 0 0
t$perf-norm:sp_cancel_write_off 1045 1045 0 0.00 0 2148 11 0 0
t$perf-norm:sp_client_order 21369 21369 0 0.00 0 7230 20 0 0
t$perf-norm:sp_customer_reserve 987 987 0 0.00 0 6299 12 0 0
t$perf-norm:sp_pay_from_customer 7294 7294 0 0.00 0 7245 10 0 0
t$perf-norm:sp_pay_to_supplier 6028 6028 0 0.00 0 3738 12 0 0
t$perf-norm:sp_reserve_write_off 10304 10304 0 0.00 0 5284 13 0 0
t$perf-norm:sp_supplier_invoice 5667 5667 0 0.00 0 5788 18 0 0
t$perf-norm:sp_supplier_order 5550 5550 0 0.00 0 8114 21 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 138 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 475 12 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 772 17 0 0
t$perf-norm:srv_make_money_saldo 874 874 0 0.00 0 2266 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10440 10116 324 3.10 0 5844 19 0 324
v_all_customers 38830 38830 0 0.00 0 16 1 0 0
v_all_suppliers 31378 31378 0 0.00 0 117 1 0 0
v_all_wares 42736 42736 0 0.00 0 164 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 2793 15 0 0
v_cancel_client_order 3702 3702 0 0.00 0 3636 7 0 0
v_cancel_customer_prepayment 1434 1434 0 0.00 0 3637 8 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 2483 5 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 781 5 0 0
v_cancel_supplier_invoice 790 772 18 2.27 0 2777 21 0 18
v_cancel_supplier_order 818 818 0 0.00 0 3977 14 0 0
v_cancel_write_off 2090 2090 0 0.00 0 3822 18 0 0
v_max_id_clo_ord 5546 5546 0 0.00 0 508 1 0 0
v_max_id_clo_res 987 987 0 0.00 0 2036 8 0 0
v_max_id_ord_sup 5661 5661 0 0.00 0 7190 6 0 0
v_max_non_paid_invoice 1546 1546 0 0.00 0 6683 12 0 0
v_max_non_paid_realizn 3909 3909 0 0.00 0 4349 4 0 0
v_min_id_clo_ord 5546 5546 0 0.00 0 2586 5 0 0
v_min_id_clo_res 987 987 0 0.00 0 4534 9 0 0
v_min_id_ord_sup 5661 5661 0 0.00 0 4588 7 0 0
v_min_non_paid_invoice 6028 6028 0 0.00 0 6650 17 0 0
v_min_non_paid_realizn 7294 7294 0 0.00 0 16853 25 0 0
v_our_firm 10676 10676 0 0.00 0 22 1 0 0
v_reserve_write_off 20604 20604 0 0.00 0 6502 8 0 0
x_lock_depdocs_on_canc_invoice 11512 11512 0 0.00 0 18506 130 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 17318 448 0 0
x_make_qstorno_1000_1200 5550 5550 0 0.00 2 69709 1293 0 0
x_make_qstorno_1200_2000 5667 5667 0 0.00 3 81578 3066 0 0
x_make_qstorno_2100_3300 476128 476128 0 0.00 0 76198 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-12-2020 01:28:02 to 05-12-2020 01:28:06.

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:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:15 10369 8192000000 10189606416 10494296064 858198240 9.482 68 52 104 0 877551488 2322192 17031056
22:57:34 22748 8192000000 10313270496 10625564672 1362074464 14.256 100 84 166 0 1392618528 4178960 26365104
22:58:06 33489 8192000000 10370101600 10691645440 1415454144 14.732 100 88 176 0 1450332832 6119008 28759680
22:58:51 30990 8192000000 10419609536 10743308288 1461416720 15.138 100 92 184 0 1498840656 7532064 29891872
22:59:39 37012 8192000000 10433791840 10764517376 1480204704 15.303 100 89 178 0 1518172160 9050144 28917312
23:00:24 22904 8192000000 10454857312 10787553280 1502030432 15.494 100 89 178 0 1539732368 9436720 28265216
23:00:59 20642 8192000000 10470767952 10813050880 1523972880 15.685 100 81 162 0 1559832000 10270912 25588208
23:01:31 14401 8192000000 10489232400 10835939328 1548880096 15.900 100 80 159 2 1584152736 10288656 24983984
23:01:59 16449 8192000000 10531759056 10885115904 1583423584 16.198 100 80 160 0 1618601760 10827904 24350272
23:02:26 12391 8192000000 10558599328 10912329728 1615296592 16.470 100 82 165 2 1651415824 11471088 24648144
23:02:48 10021 8192000000 10579431440 10937761792 1636750560 16.652 100 80 159 2 1672093888 11747904 23595424
23:03:13 10013 8192000000 10603104496 10965561344 1656358816 16.818 100 79 156 1 1691598480 12797808 22441856
23:03:32 9510 8192000000 10618096144 10979983360 1680931008 17.025 100 89 177 1 1720115248 13421376 25762864
23:03:58 9059 8192000000 10645238640 11011629056 1700193232 17.187 100 92 184 0 1740107968 13941808 25972928
23:04:15 5367 8192000000 10653464656 11021860864 1707157472 17.245 100 73 146 0 1741010016 13414608 20437936
23:04:27 7587 8192000000 10661184096 11032764416 1727436240 17.414 100 86 170 2 1765000048 13411856 24151952
23:04:42 6043 8192000000 10676247072 11051368448 1741137056 17.528 100 87 174 1 1779349280 13024192 25188032
23:04:55 5192 8192000000 10688154016 11064143872 1749478976 17.597 100 81 160 0 1785285216 13316416 22489824
23:05:07 6747 8192000000 10698894384 11075559424 1758092000 17.669 100 84 165 1 1794407104 12771744 23543360
23:05:23 4043 8192000000 10717431152 11090391040 1766995488 17.742 100 84 168 0 1808391680 18146016 23250176
23:05:34 3340 8192000000 10718530640 11093352448 1774621888 17.805 100 89 178 1 1814736032 15272176 24841968
23:05:45 3242 8192000000 10732829152 11108986880 1787471520 17.911 100 89 178 2 1826143744 13612352 25059872
23:05:56 4192 8192000000 10730464880 11114553344 1793934560 17.964 100 83 167 1 1829959984 13270496 22754928
23:06:07 3411 8192000000 10746024224 11129806848 1803004080 18.039 100 87 172 0 1839529024 12143696 24381248
23:06:17 2770 8192000000 10742659040 11128049664 1806619520 18.068 100 80 154 2 1839989872 11547504 21822848
23:06:27 8271 8192000000 10752777872 11137945600 1818107584 18.162 100 82 164 2 1853546992 12829088 22610320
23:06:42 4734 8192000000 10751022784 11141767168 1821042400 18.186 100 76 151 1 1854872736 12896800 20933536
23:06:53 2405 8192000000 10781668752 11165679616 1837116432 18.317 100 91 182 3 1875965440 13889264 24959744
23:07:02 2675 8192000000 10787776080 11170496512 1841323904 18.352 100 94 186 2 1882092368 15104384 25664080
23:07:11 1235 8192000000 10793320544 11178463232 1844788096 18.380 100 93 184 2 1886865696 15582976 26494624
23:07:19 2026 8192000000 10788937744 11174326272 1845268848 18.384 100 96 192 1 1886927456 14659584 26999024
23:07:27 1885 8192000000 10795514368 11181658112 1850858208 18.429 100 87 174 0 1889733952 14005296 24870448
23:07:36 1915 8192000000 10795567808 11182338048 1854752576 18.461 100 92 182 5 1893618048 13403200 25462272
23:07:44 1291 8192000000 10803951488 11191996416 1861635536 18.517 100 95 190 0 1901760416 12861904 27262976
23:07:52 1841 8192000000 10807557200 11193942016 1861444608 18.515 100 93 186 3 1900551568 12608976 26497984
23:08:00 2140 8192000000 10804728000 11195109376 1861655040 18.517 100 92 184 2 1900976672 12580224 26741408
23:08:08 2001 8192000000 10810142096 11198803968 1864689024 18.541 100 93 186 1 1904540176 13930960 25920192
23:08:17 2548 8192000000 10817381120 11205480448 1865532608 18.548 100 89 178 3 1904864832 14505184 24827040
23:08:25 1184 8192000000 10799812976 11200843776 1866458464 18.556 100 75 150 0 1901157648 14216624 20482560
23:08:34 12213 8192000000 10801117648 11203014656 1865243360 18.546 100 60 120 2 1893960960 12114304 16603296
23:08:54 3834 8192000000 10788218368 11201695744 1867245072 18.562 100 45 90 3 1890294544 10235872 12813600
23:09:05 3385 8192000000 10798606864 11210133504 1877118592 18.642 100 57 113 0 1901566272 8323136 16124544
23:09:15 6267 8192000000 10769212960 11199377408 1869271264 18.578 100 23 46 2 1882610016 6744624 6594128
23:09:27 6968 8192000000 10781817424 11203571712 1874759520 18.623 100 32 64 0 1890330496 7037072 8533904
23:09:41 6435 8192000000 10784706800 11208392704 1872377424 18.604 100 31 64 0 1886321568 5573456 8370688
23:09:54 9030 8192000000 10773708816 11205652480 1870993584 18.592 100 18 35 2 1882119472 6331904 4793984
23:10:13 10184 8192000000 10795647856 11203497984 1873531504 18.613 100 23 45 3 1885797200 6052592 6213104
23:10:31 7741 8192000000 10787984272 11215941632 1879183200 18.659 100 32 64 1 1895407840 6711072 9513568
23:10:48 71466 8192000000 10789429696 11226791936 1878186400 18.650 100 33 66 0 1893866848 5263808 10416640
23:12:07 8573 8192000000 10790612000 11228254208 1882622176 18.686 100 17 34 0 1893191648 6197824 4371648
23:12:25 7171 8192000000 10801688384 11230863360 1885689936 18.711 100 31 62 1 1902040112 7497456 8852720
23:12:39 7959 8192000000 10798667520 11227799552 1886278720 18.716 100 24 48 3 1898535280 6067472 6189088
23:12:55 5881 8192000000 10807565888 11231784960 1886429760 18.717 100 24 48 1 1899902544 6436528 7036256
23:13:10 6770 8192000000 10798839904 11234799616 1893740032 18.776 100 25 50 0 1906963904 5705728 7518144
23:13:23 9681 8192000000 10799284240 11238453248 1890611984 18.751 100 18 36 0 1901641712 5743120 5286608
23:13:39 13185 8192000000 10803392768 11241279488 1890803600 18.752 100 20 38 5 1905570688 10070784 4696304
23:14:02 7702 8192000000 10815887584 11240943616 1876908752 18.640 99 28 56 1 1891546224 6613104 8024368
23:14:16 6482 8192000000 10813135296 11244879872 1892331776 18.765 100 19 38 1 1903979904 5942016 5706112
23:14:29 10813 8192000000 10801559008 11242291200 1896428960 18.798 100 18 36 1 1907961376 6282208 5250208
23:14:47 11377 8192000000 10815487584 11248218112 1896776112 18.800 100 11 22 2 1904964128 5395584 2792432
23:15:05 8966 8192000000 10817948688 11250982912 1901257856 18.836 100 24 48 3 1914476320 6053776 7164688
23:15:20 11595 8192000000 10809499776 11243540480 1902940384 18.850 100 34 68 1 1919899280 6358272 10600624
23:16:13 37014 8192000000 10800604112 11235192832 1864712384 18.541 98 37 73 4 1890108048 14011568 11384096
23:16:56 10750 8192000000 10813554992 11241570304 1878028080 18.649 99 25 50 1 1891811568 7095600 6687888
23:17:13 5859 8192000000 10794396064 11225485312 1857233936 18.481 98 26 52 1 1871750608 6712848 7803824
23:17:27 5858 8192000000 10748711920 11168370688 1768169872 17.752 95 22 44 1 1779909792 5187408 6552512
23:17:41 7334 8192000000 10756414496 11175309312 1809808832 18.094 98 25 50 2 1827467680 10921920 6736928
23:17:55 5108 8192000000 10754405648 11177476096 1808672304 18.085 98 26 52 0 1823230112 6996368 7561440
23:18:07 5758 8192000000 10751501424 11168649216 1813643936 18.126 98 29 58 0 1828034416 5591312 8799168
23:18:19 6431 8192000000 10748146720 11169591296 1820505696 18.182 99 22 44 4 1831531248 5226048 5799504
23:18:32 9043 8192000000 10748626384 11179823104 1811766592 18.110 98 15 30 1 1821895632 5783712 4345328
23:18:48 4147 8192000000 10736005024 11146534912 1754421920 17.638 96 29 59 2 1767897408 4963392 8512096
23:19:00 5695 8192000000 10697742992 11113082880 1718000752 17.336 95 21 42 3 1729787824 5526224 6260848
23:19:14 9087 8192000000 10725055472 11129712640 1727498560 17.415 96 22 44 1 1739221232 5009376 6713296
23:19:32 7989 8192000000 10692436528 11098742784 1740241680 17.521 96 30 58 2 1754241808 5247712 8752416
23:19:51 7176 8192000000 10711395152 11132571648 1790504976 17.936 99 15 30 1 1800893184 5823760 4564448
23:20:08 79595 8192000000 10718627104 11139809280 1731469776 17.448 95 33 66 2 1746716080 5002432 10243872
23:21:35 7128 8192000000 10708195696 11132645376 1774725168 17.806 98 22 42 2 1785266896 4853424 5688304
23:21:49 6942 8192000000 10746040912 11156635648 1802716704 18.036 99 30 60 1 1817009184 5763968 8528512
23:22:03 6463 8192000000 10737078912 11163451392 1818373520 18.164 100 21 42 1 1835594288 10663872 6556896
23:22:17 5927 8192000000 10708221744 11130200064 1759211632 17.678 97 20 39 1 1769993168 5085536 5696000
23:22:31 6644 8192000000 10716999312 11135524864 1786742784 17.905 99 22 44 1 1798303328 5978032 5582512
23:22:46 6827 8192000000 10734137936 11154743296 1819092992 18.170 100 29 58 1 1834212544 6287216 8832336
23:23:01 9382 8192000000 10748560720 11167617024 1812890384 18.120 99 26 52 3 1830569152 10339552 7339216
23:23:20 8318 8192000000 10755728208 11175653376 1835352384 18.303 100 28 56 0 1853447056 9957616 8137056
23:23:34 9640 8192000000 10767091440 11190059008 1844064416 18.374 100 25 50 1 1861780944 10015248 7701280
23:23:51 11058 8192000000 10772730016 11195117568 1851255712 18.432 100 29 58 0 1865426448 5686656 8484080
23:24:11 8341 8192000000 10770958672 11198005248 1857028912 18.479 100 27 54 1 1871101344 6162192 7910240
23:24:25 9172 8192000000 10773116768 11196809216 1856785104 18.477 100 23 46 2 1868195008 5100976 6308928
23:24:40 11889 8192000000 10774597968 11206721536 1863575280 18.532 100 19 39 1 1874509120 5693376 5240464
23:25:01 57079 8192000000 10779614592 11206750208 1864539136 18.540 100 20 39 2 1876080544 5795728 5745680
23:26:08 21832 8192000000 10776831760 11210027008 1871816176 18.599 100 31 62 0 1886362240 5583632 8962432
23:26:36 9649 8192000000 10802000800 11218272256 1867548656 18.564 100 18 35 2 1878206896 5557696 5100544
23:26:54 6649 8192000000 10790906864 11219787776 1876171568 18.634 100 29 58 3 1890427856 5813968 8442320
23:27:07 16464 8192000000 10831851104 11241095168 1894152128 18.779 100 51 100 1 1915709408 7162192 14395088
23:27:33 24282 8192000000 10832382768 11253235712 1906108320 18.875 100 51 100 2 1929131808 9451792 13571696
23:28:20 30787 8192000000 10855366208 11277164544 1917963040 18.971 100 40 80 1 1939947344 10796000 11188304
23:29:01 5923 8192000000 10864887392 11282857984 1930376608 19.070 100 54 108 2 1956570512 10550768 15643136
23:29:14 4295 8192000000 10867889920 11289165824 1936429392 19.118 100 53 107 0 1964296736 12020512 15846832
23:29:26 17733 8192000000 10872894480 11298287616 1939805632 19.145 100 58 111 2 1969085392 14156720 15123040
23:30:07 27712 8192000000 10867928992 11297841152 1940914992 19.154 100 44 88 1 1967038656 13035856 13087808
23:30:42 20696 8192000000 10889510736 11315867648 1946207904 19.196 100 41 80 2 1970085824 12284912 11593008
23:31:37 28016 8192000000 10889984304 11321626624 1937081520 19.123 99 45 89 2 1961972624 11965584 12925520
23:32:17 38547 8192000000 10906075264 11336605696 1966877552 19.361 100 41 82 1 1991631984 13141104 11613328
23:33:09 2912 8192000000 10916549952 11341504512 1971885568 19.400 100 54 107 0 2002981184 15439552 15656064
23:33:18 2634 8192000000 10926612208 11344171008 1977854192 19.448 100 68 135 1 2014298944 16132496 20312256
23:33:29 3616 8192000000 10931625712 11353554944 1981184032 19.474 100 72 144 0 2021463824 19014272 21265520
23:33:42 14805 8192000000 10930327088 11357786112 1982172352 19.482 100 61 121 2 2018099664 18221424 17705888
23:34:04 5085 8192000000 10926884992 11352330240 1979276448 19.459 100 61 121 1 2014736640 18245104 17215088
23:34:19 9442 8192000000 10930542464 11357659136 1983937568 19.496 100 57 112 2 2018922384 18654608 16330208
23:34:36 6275 8192000000 10932953120 11360448512 1987814720 19.527 100 58 116 4 2024432864 19757808 16860336
23:34:50 12244 8192000000 10917036000 11346853888 1968896048 19.377 99 52 103 3 2001611456 17342384 15373024
23:35:12 10038 8192000000 10923999104 11352780800 1970646976 19.391 99 53 106 3 2003317600 17212976 15457648
23:35:29 5147 8192000000 10937192672 11363614720 1989748544 19.542 100 54 104 2 2022787776 17114192 15925040
23:35:42 19149 8192000000 10945148528 11377725440 1994941872 19.583 100 51 102 1 2031398080 21017824 15438384
23:36:18 20474 8192000000 10945602960 11385004032 1984764288 19.502 99 52 104 1 2030516784 30110608 15641888
23:36:47 10711 8192000000 10933824512 11367526400 1957901152 19.289 98 51 100 1 2000600016 27017968 15680896
23:37:10 6631 8192000000 10948763760 11378212864 1990290992 19.546 100 54 108 0 2031696064 25235056 16170016
23:37:25 6428 8192000000 10951915168 11375460352 1998474720 19.611 100 70 137 1 2042833904 23517536 20841648
23:37:39 8067 8192000000 10951749424 11380240384 2000651632 19.628 100 72 143 2 2045371056 24064592 20654832
23:37:54 6945 8192000000 10956371440 11386236928 1996823136 19.598 100 63 126 0 2040291584 24780048 18688400
23:38:12 6204 8192000000 10968784528 11395891200 2005375600 19.665 100 61 122 0 2052515328 28684032 18455696
23:38:27 2431 8192000000 10980367104 11401924608 2009959744 19.701 100 72 143 5 2060894768 28976848 21958176
23:38:36 1279 8192000000 10968578112 11386368000 1990703056 19.549 99 73 144 0 2043165632 30158352 22304224
23:38:46 5902 8192000000 10953916128 11379236864 1988936112 19.535 100 70 140 1 2042161872 31130848 22094912
23:38:59 2031 8192000000 10969486592 11388166144 1996024512 19.591 100 83 162 1 2052384352 32364736 23995104
23:39:09 3248 8192000000 10976083072 11392868352 2003116768 19.647 100 78 155 2 2057355216 31548976 22689472
23:39:22 10795 8192000000 10968099344 11392368640 1998429200 19.610 100 66 132 0 2049809808 31492128 19888480
23:39:39 4308 8192000000 10964637072 11389485056 1996616080 19.596 100 75 147 1 2054369120 35211088 22541952
23:39:50 1863 8192000000 10979570224 11394973696 1999547232 19.619 100 91 180 0 2062412928 36135792 26729904
23:39:59 5617 8192000000 10967341616 11385806848 1992437824 19.563 100 76 152 0 2052358864 36921440 22999600
23:40:12 2459 8192000000 10976883760 11390226432 1998119040 19.608 100 78 158 0 2057930544 36393360 23418144
23:40:21 1338 8192000000 10989013072 11400216576 2003951664 19.654 100 94 187 2 2067854832 34190800 29712368
23:40:30 4711 8192000000 10976085200 11396800512 1995493392 19.587 100 73 145 0 2056256960 38198176 22565392
23:40:42 2472 8192000000 10966404288 11391418368 1992927568 19.567 100 71 142 0 2053265344 38326096 22011680
23:40:52 4178 8192000000 10952550272 11367260160 1974143040 19.418 99 70 138 3 2035069312 38907360 22018912
23:41:04 1089 8192000000 10979442592 11392438272 1995178720 19.585 100 83 166 0 2059166432 38706336 25281376
23:41:11 10644 8192000000 10968771488 11394920448 1979233600 19.459 99 78 156 2 2043501552 40064768 24203184
23:41:32 3577 8192000000 10983601904 11409666048 2005145456 19.663 100 65 130 3 2067391872 41400288 20846128
23:41:44 2050 8192000000 10937360816 11357278208 1952165840 19.244 97 74 147 2 2017041648 42209968 22665840
23:41:54 1726 8192000000 10961533360 11375337472 1975476432 19.429 99 83 166 0 2043232752 42312416 25443904
23:42:02 1373 8192000000 10974701808 11382067200 1983508432 19.492 100 91 179 0 2056112752 44772480 27831840
23:42:10 3252 8192000000 10973608032 11385622528 1981865072 19.479 100 86 169 0 2054766064 46460512 26440480
23:42:20 4605 8192000000 10967164912 11377483776 1980769248 19.471 100 82 159 3 2046700416 41501152 24430016
23:42:39 3754 8192000000 10965248288 11391479808 1982302432 19.483 100 74 146 3 2051390416 46111600 22976384
23:42:50 4968 8192000000 10959048960 11378946048 1976451504 19.437 100 69 138 0 2037324096 39540160 21332432
23:43:02 2131 8192000000 10966040336 11376857088 1975253568 19.427 100 81 158 1 2039845584 39961264 24630752
23:43:11 5916 8192000000 10958930496 11384545280 1985549504 19.509 100 68 136 2 2045950704 38907376 21493824
23:43:25 4941 8192000000 10940324176 11363409920 1970773088 19.392 100 77 154 0 2032396528 37826224 23797216
23:43:37 9595 8192000000 10932894736 11352150016 1943253424 19.173 99 64 128 0 2000335504 37072800 20009280
23:43:55 7939 8192000000 10924749040 11347308544 1941349584 19.158 100 71 142 0 2005431840 42603584 21478672
23:44:19 2785 8192000000 10906970208 11314966528 1923540784 19.015 99 68 132 1 1982749856 38346192 20862880
23:44:32 800 8192000000 10926948544 11335417856 1943859104 19.178 100 76 149 3 2002781312 36565552 22356656
23:44:39 5896 8192000000 10921991536 11344969728 1956977136 19.282 100 65 130 2 2013180704 35762256 20441312
23:44:54 1080 8192000000 10917118784 11318878208 1926370480 19.038 99 85 163 2 1987904176 36034864 25498832
23:45:02 2857 8192000000 10938583504 11345354752 1951818912 19.241 100 80 160 0 2013496208 37247488 24429808
23:45:12 4250 8192000000 10934945744 11349024768 1961033520 19.314 100 79 156 1 2024457232 39560640 23863072
23:45:27 5679 8192000000 10931314416 11352113152 1959810240 19.305 100 66 130 2 2019008544 38135712 21062592
23:45:44 10082 8192000000 10914051200 11348951040 1936212656 19.117 99 46 92 0 1991561200 40313120 15035424
23:46:08 7538 8192000000 10909363232 11342229504 1932280432 19.085 99 32 64 1 1976500752 33544512 10675808
23:46:24 11514 8192000000 10938871712 11363794944 1962499872 19.326 100 63 125 0 2021555520 40004944 19050704
23:46:43 4094 8192000000 10922889600 11343896576 1929046656 19.059 98 71 142 1 1985993024 35641488 21304880
23:47:02 10925 8192000000 10904881552 11351322624 1949690976 19.224 100 35 70 0 2000946896 40070432 11185488
23:47:20 9203 8192000000 10941163776 11367260160 1962380208 19.325 100 49 96 2 2015016880 37472560 15164112
23:47:40 5234 8192000000 10919736240 11347869696 1934960272 19.107 99 52 104 1 1993375296 40869968 17545056
23:47:53 10184 8192000000 10899573040 11340312576 1932781904 19.089 99 43 86 0 1989900256 42947280 14171072
23:48:22 3207 8192000000 10929898656 11356160000 1941316976 19.157 99 62 124 0 2002879360 41376880 20185504
23:48:38 15458 8192000000 10908515536 11356303360 1943466944 19.174 100 33 66 0 2001238256 46413424 11357888
23:48:59 14807 8192000000 10896171072 11337506816 1939469152 19.143 100 32 64 0 1986040320 35157408 11413760
23:49:28 13648 8192000000 10903998592 11340726272 1936779136 19.121 100 34 68 0 1988256480 39393984 12083360
23:49:57 6042 8192000000 10926541360 11366821888 1950412352 19.230 100 39 79 0 2005807744 41993856 13401536
23:50:13 6977 8192000000 10905571728 11360219136 1927926544 19.050 99 29 58 1 1973324192 35144800 10252848
23:50:27 13512 8192000000 10908234960 11347828736 1933518192 19.095 99 41 82 2 1978466624 31317600 13630832
23:50:47 17998 8192000000 10894500256 11346812928 1908503936 18.895 98 22 44 1 1953838784 37324656 8010192
23:51:12 7433 8192000000 10912484496 11353944064 1945800048 19.193 100 32 63 4 1992644336 36532480 10311808
23:51:36 23363 8192000000 10895520944 11348381696 1929059488 19.059 99 24 48 1 1976220416 38735248 8425680
23:52:06 25116 8192000000 10885360464 11340976128 1942440912 19.166 100 14 28 1 1977106896 29785392 4880592
23:52:38 21954 8192000000 10891631568 11337469952 1900671088 18.832 98 19 38 2 1935283088 28028384 6583616
23:53:14 78716 8192000000 10870060128 11333431296 1917971376 18.971 99 14 28 1 1937712000 15280112 4460512
23:54:43 18353 8192000000 10871430208 11330117632 1938210336 19.132 100 42 81 2 1966619488 16466208 11942944
23:55:15 22280 8192000000 10877392832 11336261632 1947581216 19.207 100 30 60 0 1969645088 13863680 8200192
23:55:52 14757 8192000000 10860242160 11320901632 1920629648 18.992 99 26 51 2 1938449072 10671136 7148288
23:56:18 55474 8192000000 10867536816 11343286272 1934232752 19.101 100 9 18 3 1952526528 15517744 2776032
23:57:20 59886 8192000000 10880553152 11340361728 1908625728 18.896 98 10 18 1 1923638304 12731232 2281344
23:58:27 39982 8192000000 10888472736 11354091520 1954723568 19.264 100 16 31 0 1973593904 14568784 4301552
23:59:53 108439 8192000000 10902865360 11339169792 1895872432 18.793 97 25 49 0 1911186720 8216976 7097312
00:01:58 31930 8192000000 10909338928 11345080320 1925840976 19.034 98 39 78 0 1953156080 14509920 12805184
00:02:38 99235 8192000000 10891843040 11365683200 1941032096 19.155 99 28 55 0 1959534784 11390224 7112464
00:04:24 62365 8192000000 10898878784 11363373056 1961751072 19.320 100 9 18 0 1977715200 13527744 2436384
00:05:36 102875 8192000000 10891996688 11365896192 1927123504 19.044 98 6 12 1 1947265152 18817696 1323952
00:07:25 25171 8192000000 10928232608 11364507648 1972621264 19.406 100 42 84 1 1999968544 15390032 11957248
00:08:05 43821 8192000000 10909709216 11379793920 1981021344 19.473 100 28 56 0 2002546224 13628224 7896656
00:09:01 89719 8192000000 10920672608 11385802752 1960905648 19.313 99 8 16 0 1981170336 18482144 1782544
00:10:43 128739 8192000000 10932079712 11386863616 1965135696 19.347 99 15 29 0 1984474416 15207952 4130768
00:13:45 45521 8192000000 10916676224 11363438592 1927306704 19.045 97 32 62 3 1952589376 15798320 9484352
00:14:37 46272 8192000000 10912086144 11356332032 1958586240 19.295 99 50 97 2 1990536336 17683440 14266656
00:15:30 21917 8192000000 10895548160 11353116672 1944776464 19.185 99 35 70 1 1966303584 11915216 9611904
00:16:07 27722 8192000000 10912241840 11368112128 1975455504 19.429 100 37 74 2 2000131088 14673072 10002512
00:16:42 10969 8192000000 10915586976 11370475520 1974714832 19.423 100 34 68 1 1998343728 14575168 9053728
00:16:59 26204 8192000000 10919214432 11378524160 1985461216 19.508 100 41 82 0 2007703312 10467552 11774544
00:18:15 33783 8192000000 10909101184 11370373120 1954353456 19.261 98 22 44 1 1971298560 10813488 6131616
00:18:55 84036 8192000000 10921458000 11382353920 1964604976 19.343 99 29 59 0 1990227952 16368768 9254208
00:21:23 57828 8192000000 10908804176 11370795008 1958007968 19.290 99 13 26 1 1968620576 6835024 3777584
00:22:32 59781 8192000000 10899362800 11375636480 1980858224 19.471 100 14 30 1 1993025312 8485568 3681520
00:23:42 31924 8192000000 10891124256 11365732352 1943692352 19.176 98 10 20 0 1955285712 8791696 2801664
00:24:24 35624 8192000000 10900526368 11377160192 1977327488 19.444 100 12 24 0 1991496224 10639328 3529408
00:25:07 48428 8192000000 10900487808 11370749952 1960749008 19.312 99 19 38 0 1980432512 14601904 5081600
00:27:29 67743 8192000000 10874580096 11354710016 1914643568 18.944 97 15 30 0 1926092080 7423232 4025280
00:28:44 44357 8192000000 10876050544 11348840448 1927676176 19.048 98 11 22 2 1939686608 8842384 3168048
00:29:37 87276 8192000000 10875205888 11354501120 1879987760 18.665 95 11 22 2 1898719968 16237488 2494720
00:31:13 47021 8192000000 10895007456 11375718400 1945421056 19.190 99 19 38 1 1969100336 17997216 5682064
00:32:07 50931 8192000000 10884614000 11342897152 1892136544 18.763 96 19 38 0 1909729168 12448304 5144320
00:34:00 26864 8192000000 10865695200 11324227584 1928323408 19.053 99 38 78 1 1951052112 11970112 10758592
00:34:33 53433 8192000000 10873154528 11336421376 1876717440 18.639 96 22 44 2 1899417440 16107584 6592416
00:35:41 75880 8192000000 10837898864 11324813312 1806822592 18.070 93 15 30 1 1825659104 14508528 4327984
00:37:08 54824 8192000000 10852704928 11303559168 1833620128 18.289 95 27 54 2 1850842656 9797680 7424848
00:38:09 46822 8192000000 10880751488 11314774016 1916260480 18.957 99 42 84 3 1943268064 15086560 11921024
00:39:06 35834 8192000000 10874530304 11319873536 1898140832 18.811 98 44 88 3 1929014240 18651888 12221520
00:39:55 20961 8192000000 10872081984 11311939584 1890991472 18.754 98 45 90 1 1914400768 10611712 12797584
00:40:23 13598 8192000000 10880456192 11324338176 1912549680 18.927 99 46 92 1 1937573392 12086960 12936752
00:40:44 54222 8192000000 10884262544 11338772480 1926129280 19.036 100 21 42 3 1943602704 11812864 5660560
00:41:50 76784 8192000000 10865276976 11329265664 1884187056 18.699 97 34 68 2 1909430976 15130976 10112944
00:43:17 73515 8192000000 10833580384 11287961600 1839584976 18.337 95 25 50 1 1858411904 12142976 6683952
00:44:38 109938 8192000000 10840931600 11301879808 1909472848 18.902 99 38 76 0 1930116672 9129184 11514640
00:47:04 49392 8192000000 10852979856 11320909824 1915745040 18.953 99 19 38 1 1929343008 7836736 5761232
00:48:00 55183 8192000000 10827918288 11298643968 1891732224 18.760 98 11 22 0 1905689328 11006400 2950704
00:49:01 27863 8192000000 10847809072 11320406016 1925974352 19.035 100 12 23 1 1940091904 10476592 3640960
00:49:35 19442 8192000000 10853361600 11325603840 1930466944 19.071 100 13 24 2 1945843696 11165632 4211120
00:50:21 73923 8192000000 10871887152 11343212544 1927795824 19.049 99 30 59 2 1952496176 15780096 8920256
00:51:43 55132 8192000000 10877059008 11348803584 1949620816 19.223 100 20 40 0 1971308752 15276880 6411056
00:53:05 50064 8192000000 10879424944 11354415104 1913991632 18.939 98 14 28 0 1933135056 15197056 3946368
00:54:29 77160 8192000000 10876654112 11358285824 1916318928 18.957 98 7 14 0 1941938832 23405872 2214032
00:56:00 85896 8192000000 10848012352 11315474432 1861620448 18.516 96 12 23 1 1885837424 21041280 3175696
00:57:37 88120 8192000000 10874607184 11340328960 1909981456 18.906 98 22 43 1 1927794736 12269232 5544048
00:59:12 109807 8192000000 10878506544 11351789568 1898673200 18.816 97 12 24 0 1914448480 12685488 3089792
01:01:10 63777 8192000000 10894111296 11352502272 1940153472 19.148 99 20 40 1 1960679024 15044496 5481056
01:02:25 68883 8192000000 10896873664 11367829504 1946719136 19.200 99 34 68 0 1970741504 14360512 9661856
01:03:49 63134 8192000000 10905245248 11373875200 1943539056 19.175 99 25 49 0 1962090160 12155520 6395584
01:05:03 99532 8192000000 10898146032 11375128576 1914820432 18.945 97 13 26 0 1934140208 15537024 3782752
01:06:49 175194 8192000000 10900255920 11379937280 1977995088 19.449 100 15 30 0 1993004304 10924800 4084416
01:09:51 22099 8192000000 10907739920 11374321664 1978019072 19.449 100 35 70 2 1996364112 8687712 9657328
01:10:34 46848 8192000000 10859869424 11337519104 1933094992 19.092 98 15 29 0 1942899744 6139520 3665232
01:11:28 65977 8192000000 10879955904 11361169408 1928710080 19.057 98 10 20 1 1941282784 9608544 2964160
01:13:43 63527 8192000000 10905571904 11366928384 1953284512 19.253 99 17 35 2 1972135600 13477792 5373296
01:15:55 50353 8192000000 10894166832 11367587840 1940633984 19.152 98 31 62 2 1965218400 15420624 9163792
01:16:51 46693 8192000000 10892613232 11367391232 1958125952 19.291 99 12 24 0 1974025952 12125280 3774720
01:18:07 121487 8192000000 10864171840 11328393216 1846826112 18.396 94 14 28 0 1858981328 8265120 3890096
01:20:15 28047 8192000000 10888799040 11339309056 1899842112 18.825 97 28 57 2 1916082144 7223136 9016896
01:20:49 50382 8192000000 10861637104 11333574656 1879914704 18.664 96 32 64 1 1901128176 12677312 8536160
01:22:13 19951 8192000000 10856505440 11314073600 1877268176 18.643 97 23 46 0 1894990768 11315824 6406768
01:22:44 17019 8192000000 10869511152 11320283136 1892953616 18.770 98 36 71 1 1911689280 9567248 9168416
01:23:08 20168 8192000000 10852532464 11294679040 1869073328 18.577 97 55 110 0 1894811568 10171104 15567136
01:23:39 14388 8192000000 10861809856 11303677952 1887735664 18.728 98 51 102 2 1913588464 11668208 14184592
01:24:02 9763 8192000000 10876706752 11316629504 1925936976 19.034 100 50 100 3 1951941248 11979936 14024336
01:24:18 12653 8192000000 10889794352 11333419008 1931474160 19.079 100 56 112 1 1959880992 12978080 15428752
01:24:38 32395 8192000000 10870396528 11314274304 1839569376 18.337 95 46 92 2 1865444128 12435584 13439168
01:25:16 45907 8192000000 10856786064 11307659264 1864679408 18.541 97 43 86 2 1892973392 15951440 12342544
01:26:08 59046 8192000000 10451862384 10875674624 1473676816 15.246 76 18 36 1 1493926272 14745264 5504192

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 05-12-2020 01:28:08 to 05-12-2020 01:28:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 162 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 05-12-2020 01:28:41 to 05-12-2020 01:28:42.

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          241873
MON$OLDEST_ACTIVE               243427
MON$OLDEST_SNAPSHOT             243427
MON$NEXT_TRANSACTION            243427
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                       2035296
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.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 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 ---
:65: 
:66: mscs-test-161.budzdorov.ru    Sat Dec  5 01:27:16 2020
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Sat Dec  5 01:27:29 2020
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
:73: 
:74: mscs-test-161.budzdorov.ru    Sat Dec  5 01:27:30 2020
:75:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:76: 
--- end of diff output ---

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

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