Lighty is a PostgreSQL database monitoring and performance monitoring software.
The software is compatible with version 9.6 or above.
|View of the performances of several databases 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 according to needs. The minimum memory required is 256 MB with a maximum of 1024 MB. The default and recommended value is 512 MB.
The occupied disk space 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 preserved.
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 options in the toolbar are also available in the menus or via keyboard shortcuts.
|Ctrl + G||Passage in 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 connections floating window|
|Ctrl + R||Shows or hides the reports floating window|
|Ctrl + Q||Shows or hides the floating window of a SQL's statistics|
|Ctrl + S||Shows or hides the floating window of a session's statistics|
Lighty uses floating windows on its GUI. These windows can be grouped, displaced on one edge 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 allows through a single page to provide an overview of different activity statistics. It is managed with the icons. This single page is organized into tabs. You can add a new tab from the button. Each tab can be named. You can also close a tab with the appropriate button. Within each tab, 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 integrate a widget into the dashboard, simply drag and drop the widget 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 principle of the dashboard is used in 2 screens (by default, pre-filled with some widgets):
Hyperlinks allow you to easily navigate among the many information available. They are blue.
In the reporting screen, the history of your browsing 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 activity of an identifier in a range of time.
The example below shows you the SQLs consumption in a time range (11:50 a.m. to 2:10 p.m.)
Several information 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.
For automatic refresh, select the check box and the frequency on the list (10s, 30s or 60s). A countdown is displayed.
To manually refresh, click the icon.
The export button allows, depending on the windows and the type of information displayed, different operations:
Adding by pressing 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 allow you to group your connections according to their functions.
You can 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 configuration can be done by entering the server name, port, and the name of the instance or service name. You can also enter a complete chain of connection (TNS Entry for example)
This window is accessible from the "Options" menu, by 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 wearing the same name.
The menu regroups connections by type and application.
3 tabs help to navigate among the statistics.
The "Activity Viewer" tab allows you to view a database's activity.
This is done using 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 by keeping the time period
The list "tags" 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.
This is done using the mouse. Select a portion of the graph to display the corresponding statistics.
The buttons in the graphic (or the right-click menu of the mouse) allow you to save, copy to clipboard, select zoom, remove zoom...
|Widget||Details||Timeline Component||Possible Options|
|Graph||Displays the activity of a subset as a type of graph or pie chart history||
Pie chart or historical
Choice of Statistics (machine, program, user...)
Refines the information by displaying the SQLs for a session.
Refines 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)
Allows to refine the information displaying system events for a SQL. The execution plan is displayed next to the SQL.
|Blocking sessions||Shows blocking sessions and the sessions blocked in the time interval|
The control panel shows in real time the activity and the statistics of the database .
It is organized as a dashboard allowing you to customize the layout.
The "Reports" tab allows you to explore the statistics of your database. These reports are distributed by category and subcategory for simplicity.
|Db Informations||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 present on the screens.
You can also enter the SQL ID to search manually.
|Find all the information related to a SQL|
|The execution plans|
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.
• We can also compare two previous states (exports).
• Or the same base but at two different times.
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 size occupied exceeds 40% of the capacity of the disk holding the Postgresql data, this query will return a result line.
In the "Reports" section, we have 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 statistics for a session. It is automatically displayed when you click the SID of a session present on the various screens.
You can also enter the SID to search manually.
|Find all the informations related to a session|
|The SQLs' execution history in the form of a Timeline|
You can import and export databases connections between Lighty softwares
You can kill a session from the Lighty interface
You have the ability to export reports in CSV format
SQL Report Wizard also allows you to duplicate or modify existing reports. The "Duplicate" function has been 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 one. This will save him considerable time because if there is already a report similar to the one he wants, he will not have to recreate everything. The duplicate button is located on the Report tab at the bottom of the screen.
|Menu||Bottom of 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.|
|Refreshable||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 (case of a query that is refreshed periodically)|
|Virtual||Indicates whether the column's value will be calculated based on 2 columns (see Virtuals Columns screen)|
Indicates the type of value returned. The type can be redefined by a list; depending on the type, the column will display default links to another window.
Example: For the SID (Session ID) type, clicking on the value opens the Session statistics window
|ProgressBar||Indicates whether the column displays values as a progress bar (see Progress Bar properties screen). Example:|
Indicates whether the column displays a link to another report (see Linked Column)
|Min. Width||Specifies the minimum pixel size of the column|
|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 value used to filter when the box is checked is defined in the Filter value field.
Example: for the column IsDefault the display will be as follows:
|Field Filter||Displays an input field of a value 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