Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

4.91 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
4.38 ms (89.16%)	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 (8.72%)	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.10 ms (2.12%)	1	SHOW search_path Parameters: [] View formatted query View runnable query Explain query SHOW search_path SHOW search_path;

Time▼

Count

Info

4.38 ms
(89.16%)

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
(8.72%)

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.10 ms
(2.12%)

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/go2growApi/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php?p=go2growApi%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