explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oiJO

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.157 ↑ 1.0 1 1

Sort (cost=6.97..6.98 rows=1 width=110) (actual time=0.156..0.157 rows=1 loops=1)

  • Sort Key: (CASE WHEN ((lower((gbusuariosgrupos.tipo)::text) = 'grupo'::text) AND (lower((gbusuariosgrupos.grupo)::text) = 'administradores'::text)) THEN 1 WHEN (unaccent(lower((gbusuariosgrupos.tipo)::text)) = 'negacao'::text) THEN 2 WHEN (unaccent(lower((gbusuariosgrupos.tipo)::text)) = 'especifico'::text) THEN 3 ELSE 4 END)
  • Sort Method: quicksort Memory: 25kB
2. 0.064 0.146 ↑ 1.0 1 1

Hash Join (cost=3.59..6.96 rows=1 width=110) (actual time=0.087..0.146 rows=1 loops=1)

  • Hash Cond: (gbusuariosgrupos.codgrupo = gbpermissoesusuarios.codgrupo)
3. 0.039 0.039 ↓ 1.0 109 1

Seq Scan on gbusuariosgrupos (cost=0.00..3.06 rows=106 width=73) (actual time=0.013..0.039 rows=109 loops=1)

4. 0.005 0.043 ↑ 1.0 1 1

Hash (cost=3.58..3.58 rows=1 width=37) (actual time=0.043..0.043 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.038 0.038 ↑ 1.0 1 1

Seq Scan on gbpermissoesusuarios (cost=0.00..3.58 rows=1 width=37) (actual time=0.014..0.038 rows=1 loops=1)

  • Filter: (codusuario = 1)
  • Rows Removed by Filter: 125