Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

3.81 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
3.28 ms (85.92%)	1	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.43 ms (11.25%)	1	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.11 ms (2.83%)	1	SHOW search_path Parameters: [] View formatted query View runnable query Explain query SHOW search_path SHOW search_path;

Time▼

Count

Info

3.28 ms
(85.92%)

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.43 ms
(11.25%)

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.11 ms
(2.83%)

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/modules/gamification/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php?p=modules%2Fgamification%2Fvendor%2Fphpunit%2Fphpunit%2Fsrc%2FUtil%2FPHP%2Feval-stdin.php

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping