PHP download

Download the PHP package trogers1884/laravel-mvstats without Composer

On this page you can find all versions of the php package trogers1884/laravel-mvstats. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download trogers1884/laravel-mvstats
More information about trogers1884/laravel-mvstats
Files in trogers1884/laravel-mvstats

Vendor trogers1884
Package laravel-mvstats
Short Description Laravel package for PostgreSQL statistics
License MIT

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of trogers1884/laravel-mvstats

Informations about the package laravel-mvstats

Laravel PostgreSQL Materialized View Statistics

A Laravel package that automatically tracks and manages statistics for PostgreSQL materialized views.

Features

Automatically tracks creation, modification, and refresh operations on materialized views
Records refresh durations, counts, and timestamps
Provides statistics through an easy-to-query view
Includes Artisan commands for statistics management
Supports PostgreSQL 12 or later
Compatible with Laravel 10+
Requires PHP 8.1+

Installation

You can install the package via composer:

The package will automatically register its service provider.

Requirements

PHP 8.1 or higher
Laravel 10.0 or higher
PostgreSQL 12.0 or higher

Database Objects Created

This package creates the following database objects:

Tables:
- public.tr1884_mvstats_tbl_matv_stats - Base statistics table
Views:
- public.tr1884_mvstats_vw_matv_stats - Formatted view of statistics
Functions:
- public.tr1884_mvstats_fn_mv_activity_init() - Initializes tracking for existing materialized views
- public.tr1884_mvstats_fn_mv_activity_reset_stats() - Resets statistics
- Several internal trigger functions
Event Triggers:
- Triggers for tracking materialized view operations

Usage

Viewing Statistics

Once installed, the package automatically tracks all materialized view operations. You can query the statistics view:

The view provides the following columns:

mv_name - Name of the materialized view (schema.name format)
create_mv - Creation timestamp
mod_mv - Last modification timestamp
refresh_mv_last - Last refresh timestamp
refresh_count - Number of refreshes
refresh_mv_time_last - Duration of last refresh
refresh_mv_time_total - Total refresh time
refresh_mv_time_min - Minimum refresh duration
refresh_mv_time_max - Maximum refresh duration
reset_last - Last statistics reset timestamp

Artisan Commands

Reset Statistics

Reset statistics for a specific materialized view:

Reset statistics for all materialized views:

Examples

Query views that haven't been refreshed in the last 24 hours:

Find views with the longest average refresh times:

Uninstallation

Option 1: Keep Historical Data

Remove the package:
The database objects will remain for historical reference.

Option 2: Complete Removal

First, remove all database objects:
Then remove the package:

Contributing

Please see CONTRIBUTING.md for details.

Security

If you discover any security related issues, please see SECURITY.md for reporting procedures.

Credits

Tom Rogers
Jeremy Gleed (jeremy_gleed at yahoo.com)

License

The MIT License (MIT). Please see License File for more information.

All versions of laravel-mvstats with dependencies

PHP Build Version

Package Version

Version v1.0.1 Release 15. Dec 2024
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of laravel-mvstats from vendor trogers1884

Requires php Version ^8.1|^8.2|^8.3
illuminate/support Version ^10.0|^11.0
illuminate/database Version ^10.0|^11.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package trogers1884/laravel-mvstats contains the following files

Loading the files please wait ...