Lighty is a PostgreSQL database monitoring and performance monitoring software.
The software is compatible with version 9.6 or above.
|View of several databases' performances at the same time|
|View of the activity in real time|
|View of past activity|
|Easy navigation among the many bases information through SQLs reports|
|Comparison of activity over different periods and for different bases|
The software runs on Windows and Linux platforms.
An option is provided in the software to allow you to use more or less memory depending on your needs. The minimum memory required is 256 MB with a maximum of 1024 MB. The default and recommended value is 512 MB.
Disk space occupied is about 200 MB.
Lighty is distributed as a self-contained application in a compressed file (Zip Format) on Windows platforms.
Just unzip the file in the desired location. A Lighty directory is created with a tree structure containing all the files required for its operation. Then start Lighty.exe.
|A version of the Java Runtime Environment (JRE) is included (version 8 update 161)|
The software update can be done in 2 ways. In both cases, your preferences will be saved.
A window appears, telling you if you are using the latest version. If that's not the case, you can choose to automatically download and install the latest version. (An internet connection is required. For Internet access through a proxy, it may be necessary to set up access through software options.)
Removing the Lighty tree structure then decompressing the zip file.
The free trial version is fully functional. However, you can not declare more than 5 connections. At the end of the evaluation period, only the monitoring multi bases remains accessible.
L-ASH (Lighty-ASH) is a small utility for simulating ASH functionality. This utility takes an image of active sessions every 10 seconds. These images are stored in tables so that they can be restored in the Activity Viewer screen.
shared_preload_libraries = 'pg_stat_statements' pg_stat_statements.track = all track_io_timing=on
This toolbar can be hidden. All the options in the toolbar are also available in the menus or via keyboard shortcuts.
|Ctrl + G||Moving to multiple connections mode|
|Ctrl + I||Moving to single connection mode|
|Ctrl + M||Displays the connection configuration page|
|Ctrl + A||Adding a new connection|
|Ctrl + O||Displays the options window|
|Ctrl + N||Displays or hides the connection floating window|
|Ctrl + R||Displays or hides the report floating window|
|Ctrl + Q||Displays or hides the floating window of a SQL's statistics|
|Ctrl + S||Displays or hides the floating window of a session's statistics|
Lighty uses floating windows on its GUI. These windows can be grouped, moved to the edges of the main window, resized, hidden. Some can be maximized by double-clicking on the title bar or icon.
|Window||Can be maximized||Can be Moved|
|SQL reports List|
The dashboard provides an overview of different activity statistics through a single page. It is managed through the icons. This single page is organized into tabs. You can add a new tab using the button. Each tab can be named. You can also close a tab with the appropriate button. Within each tab, you can organize your table using predefined widgets. By default, the table has 3 columns dedicated to widgets. Reduce / increase the number of columns using the button. The widgets available for the dashboard are visible by clicking on the button. To insert a widget into the dashboard, simply drag and drop it to the desired location using the mouse. Widgets are resizable (width and height). You can also customize or remove any widget on the dashboard. A single widget can be opened multiple times.
Some have options. In this case, the icon appears at the top right of the widget.
The dashboard principle is used in 2 screens (which are by default pre-filled with some widgets):
Hyperlinks allow you to easily navigate among all the information available. They are blue.
In the reporting screen, the browsing history is displayed at the top of the window, and allows you to return instantly to the desired information.
Filters are ubiquitous in the different windows of the software. They can easily isolate the desired information
There are 3 types of filters:
This component visually informs you of the identifier's activity in a certain range of time.
The example below shows you the SQLs consumption in a certain time range (11:50 am to 2:10 pm)
Several information are visible on a single component:
The implementing range
The type of activity
The activity time
Many screens offer a refresh of displayed information.
In this case, the buttons allow you to manage this refresh.
To refresh automatically, select the checkbox and the frequency on the list (10s, 30s or 60s). A countdown is displayed.
To refresh manually, click on the icon.
The export button allows, depending on the windows and the type of information displayed, different operations:
To add a connection, click on the button, the menu or the Ctrl + A shortcut. Adding a connection takes 3 steps.
The connection name must be unique.
By default, a 10-session connection pool is proposed and used. You can increase or decrease this pool.
The type and application details allow you to group your connections depending on their functions.
You can then easily identify the connections later (in the menu or in the Control Panel)
Set the user and password.
A connection as SysDBA can show some special reports (data cache, hidden settings, log alert content)
The password can be saved (in encrypted format) so you don't need to enter it for every connection.
The connection is configured entering the server name, port, and the instance or service name. You can also enter a complete connection string (TNS Entry for example).
This window is accessible from the "Options" menu, clicking the icon or by the shortcut Ctrl + M.
The window lists all defined connections. You can modify their configuration, or delete a connection.
You can list the connections via the "Connection List" menu or the floating window of the same name.
The menu regroups connections by type and application.
3 tabs help you to navigate among the statistics.
The "Activity Viewer" tab allows you to view a database's activity.
Use the buttons:
You can also choose the exact date and time of start and end by clicking the "Custom" button and entering the start / end date / time.
The "Prev Day" and "Next Day" buttons allow you to move to the previous or next day while keeping the same time period.
The "tags" list allows you to select a period recorded thanks to the button "tag".
The field filter allows you to enter a SQL ID or Session PID.
You can also show / hide the list of predefined filters using the button.
These filters are configurable ( button) from a list of elements.
Use the mouse to select a part of the graph and display the corresponding statistics.
The buttons in the graph (or the right-click menu of the mouse) allow you to save, copy to clipboard, zoom in or out...
|Widget||Details||Timeline Component||Possible Options|
|Graph||Displays the activity of a subset as a pie chart or graphical history||
Pie chart or graphical history
Choice of Statistics (Server, program, user, customer identifier, module, action, SQL operation, SQL, system event)
Distils the information by displaying the SQLs for a session.
Distils the information by displaying the system events for a SQL. The execution plan is displayed next to the SQL.
Displays the SQLs grouped by similarity (only the settings differ)
Distils the information displaying system events for a SQL. The execution plan is displayed next to the SQL.
|Blocking sessions||Displays blocking sessions and sessions blocked in the time interval|
The control panel shows in real time the database activity and statistics.
It is organized as a dashboard in which you can customize the layout.
The "Reports" tab allows you to explore your database statistics. For simplicity, these reports are classified by category and subcategory.
|Db Information||Version, Users, Extensions, Instance parameters, Databases, Schema...|
|Physical Design||Tablespace size...|
|DB Statistics||dba_cache_hit_ratio, dba_taille_objets, dba_taille_bytea, dba_fragmentation_table, dba_dependances_fk...|
|SQLs||pg_stat_statements, top queries, running...|
|Segments / Tables||...|
|Locks / Transactions||Blocking session...|
A Floating Window is dedicated to a SQL's statistics. It is automatically displayed when you click the SQL ID on the screens.
You can also enter the SQL ID to search manually.
|Find all the information relating to a SQL|
The purpose of this new tab is to improve the comparison of two data sources
• The current database with a snapshot (export) of a database saved beforehand.
• You can also compare two previous states (exports).
• Or a same base at two different points in time.
The Alert section is in the "Reports" section.
The reports in this section are called every minute.
SELECT 'FileSystemUsed' as "key",'File System Used ' || FSUse || '% > 40%' as "Alert" FROM ( SELECT (( p2.value::decimal / p.value::decimal)*100)::integer as FSUse FROM l_ash.parameters p,l_ash.parameters p2 WHERE p.name='filesys_size' AND p2.name='filesys_used' ) T WHERE FSUse > 40If the occupied size exceeds 40% of the capacity of the disk holding the Postgresql data, this query will return a result line.
In the "Reports" section, we find various reports highlighting the most relevant information for the DBAs' work. You have the possibility to create your own custom reports.
A floating window is dedicated to session statistics. It is automatically displayed when you click the SID of a session present on the different screens.
You can also enter the SID to search manually.
|Find all the information related to a session|
|SQLs execution history, in the form of a Timeline|
You can import and export databases connections between the different Lighty softwares
You can kill a session from the Lighty interface
You have the possibility to export reports in CSV format
SQL Report Wizard also allows you to duplicate or modify already existing reports. The "Duplicate" function was designed to create custom reports based on existing reports. Thus, an ordinary user will be able to define its own reports without modifying the existing ones. This will save him considerable time, because if there is already a report similar to the one he wants, he won't have to recreate everything. The "Duplicate" button is located on the Report tab, at the bottom of the screen.
|Menu||Bottom of a window||Reports Window|
|Single Line Table Properties|
|Tree Table Properties||...|
|Html Area||The query returns an HTML output that is displayed in the default browser.|
|Refresh||The report will be refreshed periodically, the period can be configurable.|
|Displayed||Indicates whether the column will be displayed in the report|
|Filtered||Indicates whether the column can be used to filter results (see Filter Values)|
|Incremental||Indicates whether the column displays the difference with the previous result of the query (in the case of a query that is periodically refreshed)|
|Virtual||Indicates whether the column's value will be calculated based on 2 other columns' value (see Virtual Columns screen)|
Indicates the type of value returned. The type can be redefined through a list; depending on the type, the column will display default links to another windows.
Example: For the SID (Session ID) type, clicking on the value opens the Session statistics window
|ProgressBar||Indicates whether the column displays values in the form of a progress bar (seeProgress Bar properties screen). Example:|
Indicates whether the column displays a link to another report (see Linked Column)
|Min. Width||Specifies the column's minimum size in pixel|
|Operand 1||Operator||Operand 2|
|CheckBox Filter||Used for Yes / No columns, it displays a checkbox and a label defined in the Filter Displayed Text field. The filter value used when the box is checked is defined in the Filter value field.
Example: for the IsDefault column, the display will be as follows:
|Field Filter||Displays a value input field for the filter
For multitenant databases, the filter on the PDB is automatically added
|Panel Filter||Displays a panel containing the values of all columns defined as filtered
Example: here Backup type and Status are columns used for filtering