Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.2021 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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17125868 kB
MemAvailable 31525252 kB
Buffers 0 kB
Cached 14511404 kB
SwapCached 0 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-03-17 01:27:24
DTS_END                         2021-03-17 01:27:24.0790
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54464
TRN_ID                          245026
ATT_ID                          668
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: 9559.49 22004 1147139
customer order: creation 172.48 353 20698
customer order: refuse 15.30 370 1836
order to supplier: creation 46.45 1233 5574
order to supplier: removal 3.79 102786 455
invoice (draft): creation 47.00 3464 5640
invoice (draft): removal 56.33 740 6760
invoice accept: apply 41.85 19579 5022
invoice accept: cancel 50.81 803 6097
customer reserve: creation 3861.30 194 463356
customer reserve: removal 4958.87 61 595064
realization accept: apply 85.25 194 10230
realization accept: cancel 89.48 112 10737
payment from customer: creation 59.57 132 7148
payment from customer: removal 5.74 113 689
payment to supplier: creation 49.13 154 5895
payment to supplier: removal 3.36 104 403
service: total inventory turnovers 4.92 1093 590
service: total monetary turnovers 6.95 39 834
service: aggregate perf. data 0.89 19878 107
service: refresh index statistics 0.03 288669 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2021 01:28:07 to 17-03-2021 01:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3454
TEST_TIME 2 2044
TEST_TIME 3 3127
TEST_TIME 4 4884
TEST_TIME 5 4804
TEST_TIME 6 5756
TEST_TIME 7 5869
TEST_TIME 8 5901
TEST_TIME 9 6341
TEST_TIME 10 6203
TEST_TIME 11 6242
TEST_TIME 12 6299
TEST_TIME 13 6568
TEST_TIME 14 6645
TEST_TIME 15 6848
TEST_TIME 16 6945
TEST_TIME 17 7165
TEST_TIME 18 7199
TEST_TIME 19 7465
TEST_TIME 20 7437
TEST_TIME 21 7667
TEST_TIME 22 8321
TEST_TIME 23 8268
TEST_TIME 24 8397
TEST_TIME 25 8483
TEST_TIME 26 8929
TEST_TIME 27 9121
TEST_TIME 28 9282
TEST_TIME 29 10916
TEST_TIME 30 10912
TEST_TIME 31 10828
TEST_TIME 32 10693
TEST_TIME 33 10787
TEST_TIME 34 10811
TEST_TIME 35 10715
TEST_TIME 36 10864
TEST_TIME 37 10794
TEST_TIME 38 10570
TEST_TIME 39 10307
TEST_TIME 40 10426
TEST_TIME 41 10420
TEST_TIME 42 10381
TEST_TIME 43 10265
TEST_TIME 44 10129
TEST_TIME 45 10088
TEST_TIME 46 9969
TEST_TIME 47 10157
TEST_TIME 48 10251
TEST_TIME 49 10198
TEST_TIME 50 10100
TEST_TIME 51 10019
TEST_TIME 52 9958
TEST_TIME 53 9921
TEST_TIME 54 9855
TEST_TIME 55 9797
TEST_TIME 56 9705
TEST_TIME 57 9717
TEST_TIME 58 9624
TEST_TIME 59 9712
TEST_TIME 60 9770
TEST_TIME 61 9768
TEST_TIME 62 9777
TEST_TIME 63 9760
TEST_TIME 64 9845
TEST_TIME 65 9801
TEST_TIME 66 9891
TEST_TIME 67 9918
TEST_TIME 68 9936
TEST_TIME 69 9951
TEST_TIME 70 9952
TEST_TIME 71 9953
TEST_TIME 72 9990
TEST_TIME 73 9943
TEST_TIME 74 9826
TEST_TIME 75 9875
TEST_TIME 76 9810
TEST_TIME 77 9742
TEST_TIME 78 9693
TEST_TIME 79 9662
TEST_TIME 80 9643
TEST_TIME 81 9590
TEST_TIME 82 9517
TEST_TIME 83 9618
TEST_TIME 84 9626
TEST_TIME 85 9620
TEST_TIME 86 9586
TEST_TIME 87 9602
TEST_TIME 88 9608
TEST_TIME 89 9676
TEST_TIME 90 9646
TEST_TIME 91 9649
TEST_TIME 92 9643
TEST_TIME 93 9706
TEST_TIME 94 9684
TEST_TIME 95 9837
TEST_TIME 96 9868
TEST_TIME 97 9885
TEST_TIME 98 9814
TEST_TIME 99 9761
TEST_TIME 100 9763
TEST_TIME 101 9711
TEST_TIME 102 9671
TEST_TIME 103 9708
TEST_TIME 104 9671
TEST_TIME 105 9690
TEST_TIME 106 9656
TEST_TIME 107 9631
TEST_TIME 108 9575
TEST_TIME 109 9562
TEST_TIME 110 9561
TEST_TIME 111 9524
TEST_TIME 112 9541
TEST_TIME 113 9560
TEST_TIME 114 9558
TEST_TIME 115 9589
TEST_TIME 116 9620
TEST_TIME 117 9600
TEST_TIME 118 9624
TEST_TIME 119 9618
TEST_TIME 120 9561

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2021 01:28:11 to 17-03-2021 01:28:14.

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 1577551 1577551 0 0.00 0 26595 7 0 0
doc_list_biud 1577551 1577551 0 0.00 0 58370 29 0 0
sp_add_invoice_to_stock 5223 5022 201 3.84 33 201944 19580 0 201
sp_cancel_adding_invoice 6097 6097 0 0.00 4 59549 804 0 0
sp_cancel_client_order 1836 1836 0 0.00 4 12468 370 0 0
sp_cancel_customer_reserve 595064 595064 0 0.00 1 25490 62 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 3 10684 113 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 3 4555 105 0 0
sp_cancel_supplier_invoice 6767 6760 7 0.10 2 58377 740 0 7
sp_cancel_supplier_order 455 455 0 0.00 7 1103612 102786 0 0
sp_cancel_write_off 10737 10737 0 0.00 1 18548 113 0 0
sp_client_order 20698 20698 0 0.00 4 20684 353 0 0
sp_customer_reserve 463356 463356 0 0.00 0 114295 195 0 0
sp_fill_shopping_cart 31902 31902 0 0.00 1 10474 38 0 0
sp_fill_shopping_cart_clo_res 463353 463353 0 0.00 0 11657 13 0 0
sp_get_clo_for_invoice 5019 5019 0 0.00 0 42961 262 0 0
sp_kill_cost_storno 17926 17926 0 0.00 0 10680 57 0 0
sp_kill_qstorno_ret_qs2qd 1208080 1208080 0 0.00 0 58368 33 0 0
sp_kill_qty_storno 636198 636198 0 0.00 0 58370 71 0 0
sp_lock_selected_doc 21066 21066 0 0.00 0 8347 6 0 0
sp_make_cost_storno 28292 28292 0 0.00 0 25416 55 0 0
sp_multiply_rows_for_pdistr 28292 28292 0 0.00 0 14148 37 0 0
sp_multiply_rows_for_qdistr 20698 20698 0 0.00 0 10130 151 0 0
sp_pay_from_customer 7148 7148 0 0.00 4 26984 132 0 0
sp_pay_to_supplier 5895 5895 0 0.00 4 17477 155 0 0
sp_payment_common 13043 13043 0 0.00 1 26981 36 0 0
sp_qd_handle_on_cancel_clo 1836 1836 0 0.00 0 12460 344 0 0
sp_qd_handle_on_invoice_upd_sts 11116 11116 0 0.00 0 20516 351 0 0
sp_qd_handle_on_reserve_upd_sts 10230 10230 0 0.00 0 14308 60 0 0
sp_reserve_write_off 10230 10230 0 0.00 6 21535 195 0 0
sp_supplier_invoice 5640 5640 0 0.00 7 96879 3464 0 0
sp_supplier_order 5574 5574 0 0.00 5 22145 1233 0 0
srv_aggregate_perf_data 108 107 1 0.92 3556 303215 19879 0 1
srv_fill_mon_cache_memory 177 177 0 0.00 1070 114045 28137 0 0
srv_find_qd_qs_mism 1099812 1099812 0 0.00 0 18590 6 0 0
srv_make_invnt_saldo 590 590 0 0.00 48 44472 1093 0 0
srv_make_money_saldo 834 834 0 0.00 1 5241 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 183833 408190 288669 0 0
t$perf-abend:sp_add_invoice_to_stock 201 201 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 5022 5022 0 0.00 0 10964 186 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 2835 82 0 0
t$perf-norm:sp_cancel_client_order 1836 1836 0 0.00 0 7007 20 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 1883 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 1140 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 2516 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 11096 42 0 0
t$perf-norm:sp_cancel_supplier_order 455 455 0 0.00 0 18748 1516 0 0
t$perf-norm:sp_cancel_write_off 971 971 0 0.00 0 4422 17 0 0
t$perf-norm:sp_client_order 20698 20698 0 0.00 0 9704 20 0 0
t$perf-norm:sp_customer_reserve 1028 1028 0 0.00 0 2514 11 0 0
t$perf-norm:sp_pay_from_customer 7148 7148 0 0.00 0 8702 11 0 0
t$perf-norm:sp_pay_to_supplier 5895 5895 0 0.00 0 10678 14 0 0
t$perf-norm:sp_reserve_write_off 10230 10230 0 0.00 0 9703 13 0 0
t$perf-norm:sp_supplier_invoice 5640 5640 0 0.00 0 10651 23 0 0
t$perf-norm:sp_supplier_order 5574 5574 0 0.00 0 7700 22 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 5856 60 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 1943 18 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 1266 27 0 0
t$perf-norm:srv_make_money_saldo 834 834 0 0.00 0 3744 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10438 10036 402 3.85 0 11727 23 0 402
v_all_customers 37872 37872 0 0.00 0 26 1 0 0
v_all_suppliers 30908 30908 0 0.00 0 180 1 0 0
v_all_wares 41394 41394 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 1462 8 0 0
v_cancel_client_order 3672 3672 0 0.00 0 2695 6 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 5703 18 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 5179 7 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 4530 20 0 0
v_cancel_supplier_invoice 776 762 14 1.80 0 2749 36 0 14
v_cancel_supplier_order 910 910 0 0.00 0 448 3 0 0
v_cancel_write_off 1942 1942 0 0.00 0 3913 18 0 0
v_max_id_clo_ord 5571 5571 0 0.00 0 603 1 0 0
v_max_id_clo_res 1028 1028 0 0.00 0 1244 8 0 0
v_max_id_ord_sup 5630 5630 0 0.00 0 4113 3 0 0
v_max_non_paid_invoice 1641 1641 0 0.00 0 1864 4 0 0
v_max_non_paid_realizn 3744 3744 0 0.00 0 1546 4 0 0
v_min_id_clo_ord 5570 5570 0 0.00 0 7266 9 0 0
v_min_id_clo_res 1028 1028 0 0.00 0 4163 11 0 0
v_min_id_ord_sup 5630 5630 0 0.00 0 4048 5 0 0
v_min_non_paid_invoice 5895 5895 0 0.00 0 16222 29 0 0
v_min_non_paid_realizn 7148 7148 0 0.00 0 26977 23 0 0
v_our_firm 10330 10330 0 0.00 0 16 1 0 0
v_reserve_write_off 20460 20460 0 0.00 0 4724 7 0 0
x_lock_depdocs_on_canc_invoice 12476 12476 0 0.00 0 8464 124 0 0
x_lock_depdocs_on_canc_sup_ord 455 455 0 0.00 0 4557 344 0 0
x_make_qstorno_1000_1200 5574 5574 0 0.00 2 22085 1141 0 0
x_make_qstorno_1200_2000 5640 5640 0 0.00 4 96857 3341 0 0
x_make_qstorno_2100_3300 463356 463356 0 0.00 0 114292 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2021 01:28:15 to 17-03-2021 01:28:19.

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:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:34 20593 8192000000 10262561760 10568220672 946577104 10.358 73 52 102 1 965772912 2506384 16689424
22:58:01 30564 8192000000 10368677120 10682630144 1402636928 14.618 100 90 180 1 1437236736 5233760 29366048
22:58:45 30630 8192000000 10399051024 10723741696 1436717536 14.921 100 84 168 1 1471614336 7130928 27765872
22:59:24 23457 8192000000 10418938560 10746564608 1463645776 15.158 100 86 172 0 1499609744 8002320 27961648
22:59:57 35164 8192000000 10444587696 10778169344 1499422608 15.471 100 90 180 1 1537116592 8707296 28986688
23:00:43 24117 8192000000 10462559520 10802876416 1514392768 15.602 100 87 174 1 1550984176 9559216 27032192
23:01:19 18827 8192000000 10477462064 10818899968 1532824784 15.761 100 89 178 1 1570864160 10098192 27941184
23:01:47 20775 8192000000 10503391552 10847309824 1547050880 15.885 100 87 172 1 1584418752 10277136 27090736
23:02:18 13845 8192000000 10512672128 10864136192 1572608912 16.105 100 78 156 0 1607206464 10521440 24076112
23:02:43 12882 8192000000 10550631728 10910101504 1614916864 16.467 100 84 169 0 1655328688 14831504 25580320
23:03:04 15494 8192000000 10589302272 10951118848 1633203984 16.622 100 74 148 1 1666032336 10853280 21975072
23:03:30 10099 8192000000 10606953008 10971009024 1666009648 16.900 100 79 158 1 1701729360 12091136 23628576
23:03:47 7566 8192000000 10621124576 10985816064 1674302784 16.969 100 84 168 0 1711399200 12674368 24422048
23:04:01 6661 8192000000 10638724544 11003826176 1694458928 17.139 100 82 164 0 1731270832 13029488 23782416
23:04:15 10900 8192000000 10640309328 11015196672 1699540304 17.181 100 72 145 1 1733537136 13234448 20762384
23:04:33 7488 8192000000 10648362960 11022057472 1710935200 17.277 100 87 174 0 1750534576 14462656 25136720
23:04:48 5808 8192000000 10666971888 11039830016 1720920128 17.360 100 83 163 2 1758091888 13663376 23508384
23:05:01 5154 8192000000 10661562448 11042177024 1732427664 17.456 100 76 151 2 1767395776 13012272 21955840
23:05:13 4944 8192000000 10688953824 11064348672 1752977744 17.626 100 79 156 2 1786336032 11339232 22019056
23:05:26 4608 8192000000 10696071248 11076960256 1759651120 17.682 100 84 168 1 1797133216 13472432 24009664
23:05:38 4916 8192000000 10716117040 11094384640 1774889152 17.807 100 84 166 0 1810559920 12605264 23065504
23:05:50 4320 8192000000 10715595328 11100364800 1781198752 17.859 100 83 166 1 1817994256 13115312 23680192
23:06:01 3164 8192000000 10734378432 11116486656 1791932432 17.948 100 87 175 1 1830302576 13157408 25212736
23:06:12 3449 8192000000 10742761552 11125993472 1800776464 18.020 100 82 165 1 1836986112 13331840 22877808
23:06:22 2919 8192000000 10750902112 11135336448 1812400096 18.116 100 85 170 1 1848822528 12994832 23427600
23:06:32 7315 8192000000 10747459552 11138297856 1812939136 18.120 100 74 148 1 1846199872 12757856 20502880
23:06:48 5108 8192000000 10761557104 11147505664 1824615488 18.215 100 83 166 1 1860977712 13220912 23141312
23:06:59 2221 8192000000 10781276816 11171508224 1839672320 18.338 100 87 174 1 1878588032 14647920 24267792
23:07:08 2368 8192000000 10792565168 11180740608 1848444704 18.409 100 85 172 1 1886747920 14117216 24186000
23:07:17 2242 8192000000 10794428656 11181207552 1851484480 18.434 100 90 180 2 1890883072 14647136 24751456
23:07:26 1566 8192000000 10799730832 11186987008 1854250592 18.457 100 88 173 2 1890943776 12686624 24006560
23:07:34 1902 8192000000 10801526336 11192225792 1858330352 18.490 100 97 194 4 1899008400 13330096 27347952
23:07:42 1275 8192000000 10808404544 11195133952 1864590112 18.540 100 89 181 1 1902390032 13105184 24694736
23:07:50 2328 8192000000 10811968416 11200258048 1868423472 18.572 100 93 188 2 1908321776 13055776 26842528
23:07:58 1781 8192000000 10812536992 11202019328 1869226896 18.578 100 95 190 1 1909171200 12923008 27021296
23:08:06 1372 8192000000 10814943616 11205001216 1870620112 18.589 100 93 184 1 1910166832 12268192 27278528
23:08:14 5360 8192000000 10820620368 11210891264 1873821504 18.615 100 88 178 0 1913109600 13646384 25641712
23:08:26 1302 8192000000 10815646736 11216400384 1877108416 18.642 100 79 159 0 1912223008 13492160 21622432
23:08:35 16727 8192000000 10770331344 11204382720 1869714128 18.582 100 33 66 0 1887247072 7966032 9566912
23:08:57 51315 8192000000 10778427216 11208945664 1872141072 18.602 100 33 66 1 1887359968 5325952 9892944
23:09:55 10941 8192000000 10783704512 11212922880 1873308656 18.611 100 23 46 2 1890297680 10755136 6233888
23:10:13 6433 8192000000 10794616704 11218796544 1880393968 18.668 100 32 64 1 1897082208 7918576 8769664
23:10:30 8252 8192000000 10793653728 11218796544 1876068736 18.633 100 19 38 1 1887641584 5725968 5846880
23:10:46 5462 8192000000 10797809680 11224973312 1878184544 18.650 100 21 42 2 1890230224 6240944 5804736
23:10:58 5912 8192000000 10791593440 11220877312 1883364112 18.692 100 30 60 3 1899059456 6379552 9315792
23:11:10 6831 8192000000 10793389344 11225128960 1882719424 18.687 100 20 40 0 1894604656 6401664 5483568
23:11:24 7616 8192000000 10805574736 11235168256 1891055952 18.754 100 22 44 0 1903978304 6735872 6186480
23:11:44 11503 8192000000 10798299744 11228860416 1891414784 18.757 100 18 37 4 1902201632 5991600 4795248
23:12:03 4901 8192000000 10806849760 11235655680 1895915952 18.793 100 37 74 2 1913777312 5715456 12145904
23:12:17 5860 8192000000 10811630016 11243614208 1897908080 18.809 100 26 51 2 1911591072 6434352 7248640
23:12:36 6653 8192000000 10819448304 11241889792 1899869904 18.825 100 27 54 0 1915048928 7771232 7407792
23:12:49 10828 8192000000 10802145424 11240312832 1900838160 18.833 100 18 36 0 1912155792 5892688 5424944
23:13:09 16284 8192000000 10813308400 11247382528 1903926896 18.858 100 21 42 1 1915078832 5445104 5706832
23:13:32 13906 8192000000 10816679088 11248668672 1906084832 18.875 100 35 71 5 1923276304 7353008 9838464
23:13:54 55435 8192000000 10853351856 11264995328 1912605344 18.928 100 52 105 2 1938608480 9693408 16309728
23:14:56 4677 8192000000 10830365200 11260948480 1910059680 18.907 100 33 66 0 1928060640 8650912 9350048
23:15:09 7233 8192000000 10830453824 11261947904 1910311360 18.909 100 35 70 3 1926384432 6086352 9986720
23:15:23 5210 8192000000 10838646976 11266875392 1913898912 18.938 100 31 62 0 1930224800 7127104 9198784
23:15:35 3744 8192000000 10836553152 11268079616 1919162480 18.980 100 38 76 1 1937931616 6858848 11910288
23:15:45 4546 8192000000 10846581216 11272486912 1919934288 18.986 100 42 85 1 1939832256 8166656 11731312
23:15:56 5749 8192000000 10827286720 11255808000 1875134320 18.626 98 32 63 1 1895529552 10878736 9516496
23:16:08 4665 8192000000 10826740624 11259191296 1909654368 18.904 100 29 58 1 1925235216 6945840 8635008
23:16:21 6593 8192000000 10832211392 11266445312 1915143728 18.948 100 31 63 3 1930722160 6115888 9462544
23:16:35 8300 8192000000 10809158816 11233173504 1863873920 18.535 98 27 53 2 1878201648 6158432 8169296
23:16:50 5222 8192000000 10809243568 11242549248 1894222688 18.780 100 35 70 0 1910617776 6262032 10133056
23:17:04 6391 8192000000 10795191216 11231395840 1858437840 18.491 98 24 49 2 1871311840 5795984 7078016
23:17:21 5618 8192000000 10780675648 11210850304 1848771408 18.412 98 20 40 2 1859959744 4847296 6341040
23:17:35 9486 8192000000 10767766672 11190820864 1835115312 18.301 98 20 38 1 1847290016 5837152 6337552
23:17:51 3942 8192000000 10795048848 11215101952 1859400880 18.498 99 29 57 2 1873806160 6094672 8310608
23:18:03 8591 8192000000 10766688528 11199782912 1837627040 18.321 98 20 40 3 1849614448 6457712 5529696
23:18:22 17145 8192000000 10758498704 11181293568 1793875104 17.964 96 32 64 3 1812123136 9135984 9112048
23:18:46 62577 8192000000 10729626720 11148120064 1694650704 17.140 92 29 58 1 1712259232 9725120 7883408
23:19:55 12371 8192000000 10711978384 11126505472 1700695856 17.191 93 15 29 1 1709111200 4627136 3788208
23:20:14 7056 8192000000 10707177056 11123503104 1718290432 17.338 95 25 50 0 1731071680 5565200 7216048
23:20:28 6556 8192000000 10688318272 11093295104 1704787168 17.225 95 34 68 2 1721292272 6734080 9771024
23:20:42 4535 8192000000 10716834816 11118940160 1785005104 17.891 100 43 84 1 1805468464 8122096 12341264
23:20:53 4968 8192000000 10722218144 11134726144 1781934064 17.865 99 35 70 1 1798148752 6764192 9450496
23:21:07 5586 8192000000 10691350240 11105431552 1760499008 17.689 98 33 66 0 1777590720 7424704 9667008
23:21:22 7428 8192000000 10701217456 11107766272 1737913632 17.501 97 33 66 1 1752987120 5793840 9279648
23:21:37 4237 8192000000 10702510832 11108278272 1768144432 17.752 99 33 67 2 1783030192 5477424 9408336
23:21:52 5919 8192000000 10682817728 11104780288 1763994176 17.717 98 17 34 0 1774888256 5650320 5243760
23:22:05 6416 8192000000 10727422352 11147829248 1815340560 18.140 100 30 60 0 1830220224 6229856 8649808
23:22:19 9608 8192000000 10746226032 11167748096 1828240816 18.245 100 31 63 0 1842393408 4757984 9394608
23:22:37 7362 8192000000 10750522992 11173523456 1834171312 18.293 100 27 54 2 1847532336 5504576 7856448
23:22:53 11166 8192000000 10740023328 11161362432 1821603920 18.191 99 31 59 3 1836788256 5940576 9243760
23:23:12 34324 8192000000 10758463744 11178795008 1826696624 18.232 99 34 66 2 1842373248 5122544 10554080
23:24:16 32052 8192000000 10761153488 11192614912 1850515472 18.426 100 11 22 0 1859119824 4873136 3731216
23:24:54 10056 8192000000 10773001216 11201724416 1863303664 18.530 100 24 47 2 1875236416 5415904 6516848
23:25:10 4661 8192000000 10781422528 11210055680 1868448608 18.572 100 36 70 4 1885314784 6932480 9933696
23:25:23 4435 8192000000 10790427904 11213340672 1868400960 18.571 100 36 71 3 1885459984 6415504 10643520
23:25:34 6629 8192000000 10785711024 11214217216 1868577696 18.573 100 28 56 2 1891091632 14667392 7846544
23:25:46 8911 8192000000 10786989776 11213983744 1869748256 18.582 100 22 45 0 1881912128 5719984 6443888
23:26:03 7139 8192000000 10799055280 11220570112 1877429344 18.644 100 37 75 1 1894279792 5836144 11014304
23:26:17 7723 8192000000 10793192288 11222544384 1877500736 18.645 100 25 49 2 1891327920 6120032 7707152
23:26:32 8005 8192000000 10801967968 11227869184 1879825536 18.664 100 27 54 1 1893715472 5573712 8316224
23:26:49 5451 8192000000 10806950016 11231088640 1885906544 18.713 100 33 65 4 1905096528 9624608 9565376
23:27:01 7869 8192000000 10803909408 11232882688 1885994896 18.713 100 18 36 1 1896361568 5747424 4619248
23:27:22 11358 8192000000 10842182704 11259891712 1910174256 18.908 100 36 70 4 1926681856 5193488 11314112
23:27:46 21823 8192000000 10860851040 11278598144 1925813632 19.033 100 72 142 4 1953973200 7195920 20963648
23:28:23 28843 8192000000 10874174832 11288993792 1935409744 19.110 100 62 122 4 1961812528 9039888 17362896
23:29:17 91195 8192000000 10871916608 11307454464 1946995040 19.203 100 48 96 1 1973019600 12438672 13585888
23:30:56 43110 8192000000 10863767920 11315527680 1945448000 19.190 100 22 44 0 1964008208 12167840 6392368
23:31:48 10011 8192000000 10886209168 11318288384 1952939360 19.250 100 29 57 2 1972217168 10927520 8350288
23:32:06 10365 8192000000 10891864464 11325394944 1960322816 19.309 100 40 80 1 1982012992 10007008 11683168
23:32:30 4793 8192000000 10902180640 11331067904 1966659856 19.359 100 49 97 2 1993536080 11612576 15263648
23:32:44 25023 8192000000 10897203968 11325034496 1930253712 19.069 98 43 85 2 1953985104 11570624 12160768
23:33:17 16046 8192000000 10896579872 11330658304 1966392304 19.357 100 50 101 2 1992222512 10699552 15130656
23:33:43 8938 8192000000 10920716080 11348344832 1977149504 19.442 100 53 106 1 2008019760 14992096 15878160
23:33:58 6794 8192000000 10928439872 11356966912 1986498096 19.516 100 70 140 2 2020390624 13015328 20877200
23:34:19 4192 8192000000 10933960784 11357863936 1973110896 19.410 99 61 120 1 2006855056 15979664 17764496
23:34:30 7515 8192000000 10932533568 11361943552 1988643056 19.533 100 64 128 0 2024466736 17251216 18572464
23:34:46 3629 8192000000 10917322080 11352862720 1970390640 19.389 99 50 100 0 2001543232 16275648 14876944
23:34:57 1988 8192000000 10946922320 11364429824 1992813072 19.566 100 74 145 2 2030831584 17285760 20732752
23:35:07 9135 8192000000 10944718352 11375710208 1992448608 19.563 100 59 118 0 2028018560 18505040 17064912
23:35:28 5273 8192000000 10938037808 11364794368 1976908656 19.440 99 58 113 2 2014370208 21276000 16185552
23:35:41 3079 8192000000 10955663360 11378364416 1980703152 19.470 99 70 138 1 2022655856 21355744 20596960
23:35:55 3607 8192000000 10936449888 11355942912 1971878832 19.400 99 81 162 2 2018698768 22733280 24086656
23:36:06 13233 8192000000 10935298192 11370897408 1984515808 19.500 100 57 114 1 2021857536 19908112 17433616
23:36:27 7127 8192000000 10939844800 11374981120 1993920064 19.575 100 57 113 1 2030742528 20069152 16753312
23:36:45 11022 8192000000 10938221920 11374673920 1995433792 19.587 100 50 100 2 2028784928 18882448 14468688
23:37:16 3448 8192000000 10942774272 11366334464 1968207936 19.371 99 58 114 0 2010121824 25396352 16517536
23:37:33 10241 8192000000 10936930816 11378581504 1989241440 19.538 100 48 96 0 2031283808 27829952 14212416
23:37:52 4748 8192000000 10928444912 11367251968 1978801152 19.455 100 44 88 2 2018722720 27046720 12874848
23:38:05 7101 8192000000 10909384128 11347402752 1924882048 19.026 97 41 82 2 1962938608 25723088 12333472
23:38:20 2908 8192000000 10925333296 11349643264 1957396560 19.285 99 59 120 0 1999142832 23568096 18178176
23:38:34 6002 8192000000 10922880064 11353174016 1972422832 19.405 100 55 110 1 2013442064 25231216 15788016
23:38:48 2863 8192000000 10945522544 11364495360 1984670496 19.502 100 73 146 1 2032780784 26461440 21648848
23:38:59 2987 8192000000 10955013472 11376705536 1988815376 19.534 100 77 154 2 2046839360 35435376 22588608
23:39:09 1871 8192000000 10962898912 11375480832 1990908608 19.551 100 87 173 1 2044199072 27715968 25574496
23:39:20 4339 8192000000 10956137712 11375329280 1992080544 19.560 100 91 185 0 2046244176 27880672 26282960
23:39:32 4131 8192000000 10957916576 11380477952 1993674000 19.573 100 73 145 2 2043412512 28675584 21062928
23:39:45 5930 8192000000 10946774592 11375562752 1987299168 19.522 100 58 116 2 2033488928 28921088 17268672
23:39:59 3469 8192000000 10969388352 11392978944 2001222512 19.632 100 74 149 3 2053758528 30546368 21989648
23:40:13 3971 8192000000 10949010896 11374809088 1976741968 19.439 99 76 152 2 2030861152 30868832 23250352
23:40:25 2715 8192000000 10982447344 11397439488 2000422992 19.626 100 87 175 1 2056970544 30313456 26234096
23:40:34 3964 8192000000 10975198976 11396444160 2004988848 19.662 100 74 146 1 2059758224 32696576 22072800
23:40:46 2421 8192000000 10974805440 11390001152 1982331360 19.483 99 84 168 2 2043316976 35721232 25264384
23:40:55 2889 8192000000 10972393456 11389382656 1992712160 19.565 100 84 168 1 2053754032 35466416 25575456
23:41:05 4611 8192000000 10929376224 11345219584 1943493632 19.175 98 79 154 0 2003260720 36340800 23426288
23:41:18 1455 8192000000 10946876624 11354542080 1952274976 19.245 99 88 176 2 2015726432 37043664 26407792
23:41:27 2617 8192000000 10944129072 11358543872 1962905776 19.329 100 81 157 4 2023712480 37372784 23433920
23:41:38 6308 8192000000 10939610960 11356487680 1958102400 19.291 99 73 146 2 2017588880 37418240 22068240
23:41:52 3179 8192000000 10942188736 11365920768 1971397344 19.397 100 72 143 2 2031821488 38289776 22134368
23:42:01 1357 8192000000 10964653248 11374362624 1984052512 19.497 100 81 159 3 2047157248 39169056 23935680
23:42:09 4387 8192000000 10970501600 11387224064 1989688192 19.541 100 86 170 0 2058407232 42459280 26259760
23:42:24 3685 8192000000 10976166752 11390214144 1994660816 19.581 100 82 163 2 2062700976 42952336 25087824
23:42:36 3323 8192000000 10978994432 11405176832 1998735040 19.613 100 74 147 2 2065619536 43466960 23417536
23:42:46 5654 8192000000 10971262832 11390930944 1975996176 19.433 99 84 168 2 2047090432 43616560 27477696
23:42:59 4129 8192000000 10963349360 11388137472 1987367888 19.523 100 64 126 3 2049262240 41713792 20180560
23:43:13 1946 8192000000 10973649968 11388055552 1988087296 19.529 100 81 162 2 2056651408 43266144 25297968
23:43:27 1818 8192000000 10973693424 11391619072 1985965776 19.512 100 82 162 0 2056415424 45250544 25199104
23:43:35 1184 8192000000 10962513776 11373961216 1959952048 19.306 99 94 187 2 2035111488 45703664 29455776
23:43:44 3600 8192000000 10946787632 11357777920 1947062768 19.203 99 82 163 0 2020862304 47610128 26189408
23:43:55 7745 8192000000 10950938544 11365724160 1947533360 19.207 99 77 154 0 2017813584 46135968 24144256
23:44:10 2613 8192000000 10967806528 11373527040 1970423840 19.389 100 90 179 1 2046285872 47717968 28144064
23:44:20 4880 8192000000 10966133008 11381125120 1975380272 19.428 100 81 160 0 2048239664 47295392 25564000
23:44:39 2116 8192000000 10965561456 11383627776 1966831584 19.360 99 74 148 0 2041322944 50868352 23623008
23:44:50 1222 8192000000 10971600816 11381760000 1975646448 19.430 100 88 174 1 2051443328 48586352 27210528
23:44:58 4009 8192000000 10980159968 11396276224 1986147728 19.513 100 82 161 0 2062412944 50272832 25992384
23:45:10 1986 8192000000 10985858288 11398455296 1987883488 19.527 100 86 172 1 2063729200 49869744 25975968
23:45:18 2450 8192000000 10990244656 11396915200 1992896800 19.567 100 88 173 2 2070972784 50923440 27152544
23:45:33 1348 8192000000 10997482496 11410046976 1998625536 19.612 100 78 156 0 2073866752 50610000 24631216
23:45:41 2347 8192000000 10978626624 11391447040 1980285888 19.467 100 83 166 0 2058786736 52369136 26131712
23:45:51 8007 8192000000 10997500192 11412205568 1998365360 19.610 100 86 172 0 2079067200 53221696 27480144
23:46:07 3300 8192000000 10986518080 11402932224 1976662896 19.438 99 84 168 1 2057639072 54517216 26458960
23:46:19 2708 8192000000 11007562928 11419095040 2003578880 19.651 100 88 176 1 2093149184 61487712 28082592
23:46:29 1069 8192000000 11008250832 11416494080 1992632368 19.565 100 87 174 0 2081758784 61608768 27517648
23:46:38 3918 8192000000 10996876784 11412348928 1989788896 19.542 100 84 167 1 2077992048 61538816 26664336
23:46:50 3552 8192000000 10992562048 11407974400 1989951728 19.543 100 81 162 0 2074727968 58278160 26498080
23:47:02 2201 8192000000 10999480112 11404673024 1988760816 19.534 100 94 186 1 2078105280 59624432 29720032
23:47:13 6575 8192000000 10996938976 11416268800 1990970080 19.551 100 74 148 0 2077895680 62919024 24006576
23:47:30 2819 8192000000 10996906704 11412828160 1989589120 19.541 100 82 164 2 2083160576 66663504 26907952
23:47:41 4148 8192000000 10998948432 11417071616 1987772608 19.526 100 78 156 1 2080731296 67397520 25561168
23:47:52 2783 8192000000 11006326528 11425906688 1992305776 19.562 100 76 152 0 2088912912 71498624 25108512
23:48:02 1282 8192000000 11021019616 11432542208 2000468784 19.626 100 86 174 0 2099296576 70668896 28158896
23:48:10 1293 8192000000 11030425856 11442085888 2006896736 19.677 100 87 174 2 2107447216 72274608 28275872
23:48:19 2089 8192000000 11015545760 11429896192 1995157488 19.585 99 89 179 2 2095667632 72201456 28308688
23:48:29 2421 8192000000 11026985200 11441483776 2006123168 19.671 100 84 166 1 2106591520 73962704 26505648
23:48:38 1604 8192000000 11030039776 11447255040 2011971392 19.717 100 80 160 0 2113960064 76541648 25447024
23:48:48 2384 8192000000 11017393056 11443752960 2004887792 19.661 100 68 136 1 2102994160 75944848 22161520
23:48:59 2131 8192000000 11021694112 11445325824 2007027824 19.678 100 74 148 5 2104760416 73056464 24676128
23:49:10 13652 8192000000 10994009648 11430916096 1981438608 19.476 99 51 102 3 2066518240 67793904 17285728
23:49:34 20722 8192000000 10994080896 11436351488 2002522944 19.643 100 43 86 0 2079924528 62812160 14589424
23:50:34 10534 8192000000 10998689376 11437023232 1997776528 19.605 100 39 78 0 2075448448 64636480 13035440
23:50:54 13178 8192000000 10990460320 11433885696 1979744560 19.463 99 40 80 2 2062221408 68470608 14006240
23:51:14 6972 8192000000 10985741312 11434467328 1991912880 19.559 100 41 82 2 2071027568 64900096 14214592
23:51:31 11481 8192000000 10976133776 11419947008 1974177888 19.419 99 42 84 1 2057135088 68065264 14891936
23:51:54 11955 8192000000 10982567056 11426709504 1987478320 19.524 100 44 86 1 2068168416 65866016 14824080
23:52:27 13186 8192000000 10994699776 11431821312 1986815376 19.519 100 54 108 2 2075301568 69885136 18601056
23:52:47 15396 8192000000 10999243392 11441405952 1967928256 19.369 99 48 96 2 2059652000 76289088 15434656
23:53:25 12803 8192000000 10982803136 11434598400 1986804864 19.519 100 35 70 0 2069571008 70674992 12091152
23:53:51 29164 8192000000 10979045776 11445690368 1990312128 19.546 100 29 58 2 2064340576 63971360 10057088
23:54:57 7591 8192000000 10973235968 11429396480 1975596640 19.430 100 25 50 0 2048780384 64436032 8747712
23:55:23 31874 8192000000 10957768928 11417292800 1970405568 19.389 100 19 38 0 2039931584 62037856 7488160
23:56:07 34419 8192000000 10934181280 11432116224 1963233536 19.332 100 15 30 0 2026047472 56679024 6134912
23:56:57 89668 8192000000 10916026480 11375157248 1921101296 18.996 98 9 18 0 1934212112 11199936 1910880
23:58:42 71181 8192000000 10902037248 11363651584 1919452784 18.982 97 20 40 0 1937369712 12524944 5391984
00:00:02 45245 8192000000 10919075696 11392462848 1978111888 19.450 100 14 28 0 1998278944 15958496 4208560
00:00:56 105153 8192000000 10888320368 11349008384 1872616816 18.605 95 10 21 2 1897997600 22866000 2514784
00:03:48 92680 8192000000 10896116960 11342675968 1901249264 18.836 97 14 28 0 1922810448 17279744 4281440
00:05:40 114044 8192000000 10900995184 11353067520 1910197296 18.908 97 40 78 1 1940660880 19437984 11025600
00:07:40 77247 8192000000 10882533984 11337658368 1918722624 18.977 98 36 72 1 1939783168 10733664 10326880
00:09:10 35657 8192000000 10897060864 11357188096 1950015680 19.227 99 44 87 2 1972179120 10118288 12045152
00:10:03 81859 8192000000 10904459264 11358674944 1951672816 19.240 99 30 58 4 1968205712 8809200 7723696
00:11:33 16274 8192000000 10936881248 11369246720 1963896608 19.337 99 63 126 4 1991900224 9542064 18461552
00:11:58 36921 8192000000 10909875296 11380162560 1976050384 19.433 100 32 64 0 1997715376 11956720 9708272
00:13:14 40470 8192000000 10946271792 11393671168 1986540704 19.516 100 21 43 0 2005715856 12844080 6331072
00:14:02 41609 8192000000 10927308240 11387772928 1976703296 19.439 99 43 86 2 2009349280 19047664 13598320
00:14:58 69750 8192000000 10924944384 11416932352 1992385776 19.563 100 21 42 2 2013844304 15736272 5722256
00:16:57 16178 8192000000 10899214848 11380318208 1975539568 19.429 100 6 12 0 1989963504 12906880 1517056
00:17:19 19348 8192000000 10914716960 11391463424 1982317072 19.483 100 15 30 0 1993968416 7820336 3831008
00:18:58 38080 8192000000 10912919440 11393056768 1982335584 19.483 99 16 32 0 1996976464 10050032 4590848
00:20:36 111434 8192000000 10914638240 11398074368 1926651600 19.040 96 22 44 0 1945760592 13093872 6015120
00:22:48 27908 8192000000 10914493952 11379572736 1926140816 19.036 96 24 48 0 1945387488 11721952 7524720
00:23:26 47426 8192000000 10908997408 11385872384 1962314832 19.324 99 34 68 2 1986235696 14643152 9277712
00:24:46 43816 8192000000 10904900592 11395665920 1973492080 19.413 100 13 26 0 1998844416 21616480 3735856
00:26:12 37388 8192000000 10913897616 11407286272 1980810064 19.471 100 4 8 0 1992673168 10910768 952336
00:26:58 48910 8192000000 10905713488 11394203648 1953662208 19.256 98 13 26 1 1965664944 9229008 2773728
00:27:53 23702 8192000000 10922309328 11394990080 1991244224 19.554 100 15 30 0 2002847184 7861712 3741248
00:28:26 31758 8192000000 10910694368 11391643648 1957969152 19.290 98 12 24 2 1969749584 8247520 3532912
00:29:06 24048 8192000000 10911906688 11388186624 1942179728 19.164 97 23 46 2 1956100928 7269904 6651296
00:29:42 45639 8192000000 10899983360 11384709120 1902035808 18.843 95 29 56 3 1920280896 9734944 8510144
00:30:46 24873 8192000000 10926442816 11392315392 1971085616 19.394 99 26 52 0 1988252096 9859680 7306800
00:31:20 53927 8192000000 10913045504 11372736512 1897766336 18.808 95 34 68 0 1923495792 16210368 9519088
00:32:32 35079 8192000000 10916418432 11385548800 1958878752 19.297 99 22 44 1 1979861584 14485552 6497280
00:33:25 64752 8192000000 10895149664 11376058368 1883841552 18.696 95 17 34 1 1907116128 18200432 5074144
00:34:36 52441 8192000000 10908372192 11382726656 1971105456 19.394 100 11 21 0 1986747872 12829072 2813344
00:35:34 98354 8192000000 10899392784 11369938944 1823810512 18.209 92 13 26 1 1846057648 17651536 4595600
00:37:19 55045 8192000000 10880730656 11360145408 1910548624 18.911 97 22 44 0 1933008768 16576064 5884080
00:38:23 51077 8192000000 10912503312 11353268224 1880404816 18.668 96 16 32 0 1896820992 12310656 4105520
00:39:21 91870 8192000000 10863033248 11331031040 1857217728 18.481 95 19 37 1 1874578256 12205344 5155184
00:41:39 83893 8192000000 10876765888 11346927616 1901865744 18.841 97 31 62 3 1919757808 9778448 8113616
00:43:23 56834 8192000000 10899885712 11358732288 1961484864 19.318 100 36 72 0 1980905904 8380160 11040880
00:44:27 6989 8192000000 10904263744 11363291136 1968292768 19.372 100 37 74 0 1987933104 9481392 10158944
00:44:40 31988 8192000000 10916529552 11375521792 1953662400 19.256 99 42 84 2 1975729648 10046736 12020512
00:45:20 65757 8192000000 10901226032 11385438208 1977929264 19.448 100 37 73 1 2006670224 18438576 10302384
00:46:40 58820 8192000000 10865449440 11342970880 1871655792 18.598 95 18 36 1 1889140720 12141552 5343376
00:48:43 68468 8192000000 10870545200 11348320256 1928496304 19.055 99 13 26 0 1949170864 16749808 3924752
00:50:22 50065 8192000000 10879291488 11360567296 1942879280 19.170 100 7 14 0 1960459104 15466144 2113680
00:51:20 63037 8192000000 10871431344 11337871360 1876061088 18.633 96 17 34 0 1890920112 9947616 4911408
00:52:44 43840 8192000000 10877906704 11346022400 1915511136 18.951 98 24 49 1 1932264784 9957280 6796368
00:53:48 36523 8192000000 10856858800 11337592832 1900662688 18.832 98 9 18 1 1916495568 12690832 3142048
00:54:30 29027 8192000000 10905712864 11355250688 1943927984 19.178 100 50 100 0 1969732272 12521840 13282448
00:55:12 52492 8192000000 10855302768 11334336512 1871336768 18.595 96 18 35 0 1891047088 14151200 5559120
00:57:04 51113 8192000000 10899011296 11354570752 1931984704 19.083 99 21 42 0 1948084864 10685120 5415040
00:58:04 44787 8192000000 10898672496 11375767552 1964092064 19.339 100 36 72 1 1988874448 14780848 10001536
00:59:02 72000 8192000000 10900058400 11374784512 1951046576 19.235 99 17 34 2 1965199248 9603728 4548944
01:00:20 61568 8192000000 10902993088 11370856448 1913408528 18.934 97 15 30 1 1924417984 7608768 3400688
01:01:30 39687 8192000000 10926023632 11409891328 1975135696 19.426 100 14 28 0 2001372960 21942224 4295040
01:02:23 103573 8192000000 10900835104 11393826816 1933162992 19.092 98 6 12 0 1956113616 21396272 1554352
01:04:13 65362 8192000000 10915807616 11382247424 1971277072 19.396 100 13 26 0 1993706896 18986080 3443744
01:05:27 15287 8192000000 10919788880 11372576768 1969081488 19.378 99 44 88 0 1989363488 7636624 12645376
01:05:48 111199 8192000000 10906245360 11387760640 1977158816 19.442 100 35 70 0 1997234176 10388400 9686960
01:07:46 80672 8192000000 10924631712 11401056256 1989127456 19.537 100 26 52 0 2004882400 8789760 6965184
01:09:13 9260 8192000000 10923066016 11391774720 1971782800 19.400 99 44 88 0 1996080848 12008896 12289152
01:09:29 9060 8192000000 10920404000 11398225920 1984869968 19.503 100 28 55 1 2006379376 14065552 7443856
01:09:52 42375 8192000000 10901267808 11390459904 1944618336 19.184 98 29 58 2 1965066176 11787104 8660736
01:10:43 59773 8192000000 10905971824 11399983104 1950054192 19.227 99 12 24 1 1974411584 21157760 3199632
01:11:58 61713 8192000000 10874582720 11370328064 1914208368 18.940 97 10 20 0 1932168320 15183424 2776528
01:13:10 53944 8192000000 10866575968 11347009536 1944056848 19.179 99 18 36 0 1962258848 13083808 5118192
01:14:11 37335 8192000000 10849558768 11335770112 1897641344 18.807 97 11 22 0 1911033920 10121456 3271120
01:15:05 39934 8192000000 10845147376 11324215296 1890282688 18.748 98 12 22 1 1903927936 10428240 3217008
01:15:51 59525 8192000000 10868926448 11334569984 1904566496 18.863 98 26 52 2 1919726816 7933696 7226624
01:16:57 48658 8192000000 10850196720 11343400960 1931381744 19.078 100 12 24 2 1947601776 13013840 3206192
01:17:52 89652 8192000000 10887449840 11357728768 1888898368 18.737 97 9 18 0 1909631344 18284304 2448672
01:19:28 63485 8192000000 10854053424 11338788864 1863686832 18.533 96 11 22 0 1883771216 16310016 3774368
01:20:38 60223 8192000000 10861095728 11335331840 1889266576 18.740 97 19 39 2 1907687248 13089216 5331456
01:21:47 50283 8192000000 10880375056 11350085632 1938091872 19.132 100 20 40 0 1955237200 11741808 5403520
01:22:47 70183 8192000000 10878444896 11349204992 1872760000 18.607 96 19 38 0 1892882592 14888640 5233952
01:24:07 44916 8192000000 10878404592 11329433600 1888399728 18.733 97 36 71 0 1914339136 16143392 9796016
01:24:58 41386 8192000000 10871941216 11335868416 1903423440 18.854 98 49 98 0 1929223312 12465600 13334272
01:25:48 49582 8192000000 10844791232 11304595456 1814091936 18.129 94 28 56 4 1831810176 10365600 7352640
01:26:44 29654 8192000000 10862835968 11322519552 1887788720 18.728 98 21 42 1 1900941968 7457632 5695616
01:27:21 13930 8192000000 9196681872 9439961088 356956320 4.175 19 4 8 0 360528592 2594624 977648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 17-03-2021 01:28:21 to 17-03-2021 01:28:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 201 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 17-03-2021 01:28:55 to 17-03-2021 01:28:57.

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          245408
MON$OLDEST_ACTIVE               245409
MON$OLDEST_SNAPSHOT             245409
MON$NEXT_TRANSACTION            245409
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                       2059872
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:173: 
:174: mscs-test-161.budzdorov.ru    Wed Mar 17 01:27:36 2021
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:176: 
--- end of diff output ---

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

17.03.21 01:28:58. 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-03-17 01:29:00 No severe PSQL-related problems occured
17.03.21 01:29:02. End of report.