Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

4.36 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	3.76 ms	SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW' Parameters: [] View formatted query View runnable query Explain query SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW' SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type != 'VIEW';
2	0.47 ms	SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.' AND nspname != 'information_schema' Parameters: [] View formatted query View runnable query Explain query SELECT nspname FROM pg_namespace WHERE nspname ! ~ '^pg_.' AND nspname != 'information_schema' SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema';
3	0.12 ms	SHOW search_path Parameters: [] View formatted query View runnable query Explain query SHOW search_path SHOW search_path;

#▲

Time

Info

3.76 ms

SELECT quote_ident(table_name) AS table_name,
                       table_schema AS schema_name
                FROM   information_schema.tables
                WHERE  table_schema NOT LIKE 'pg\_%'
                AND    table_schema != 'information_schema'
                AND    table_name != 'geometry_columns'
                AND    table_name != 'spatial_ref_sys'
                AND    table_type != 'VIEW'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type != 'VIEW'

SELECT quote_ident(table_name) AS table_name,
                       table_schema AS schema_name
                FROM   information_schema.tables
                WHERE  table_schema NOT LIKE 'pg\_%'
                AND    table_schema != 'information_schema'
                AND    table_name != 'geometry_columns'
                AND    table_name != 'spatial_ref_sys'
                AND    table_type != 'VIEW';

0.47 ms

SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  nspname
FROM
  pg_namespace
WHERE
  nspname ! ~ '^pg_.*'
  AND nspname != 'information_schema'

SELECT nspname FROM pg_namespace WHERE nspname !~ '^pg_.*' AND nspname != 'information_schema';

0.12 ms

SHOW search_path

Parameters:

[]

View formatted query View runnable query Explain query

SHOW search_path

SHOW search_path;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Kematjaya\UserBundle\Entity\KmjUser	No errors.
Kematjaya\UserBundle\Entity\DefaultUser	No errors.

Symfony Profiler

http://opendata.kedirikab.go.id/language/en-GB/LEVIATHAN/haxorcgiapi/perl.haxor?p=language%2Fen-GB%2FLEVIATHAN%2Fhaxorcgiapi%2Fperl.haxor

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping