explain.depesz.com

A tool for finding a real cause for slow queries.

Result: gLM : Without anonymization

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.046 0.354 ↓ 3.8 42 1

Hash Left Join (cost=11.83..13.98 rows=11 width=268) (actual time=0.256..0.354 rows=42 loops=1)

  • Output: p.username, p.pass, p.uid, p.gid, p.gecos, p.home, p.shell, g.username, g.pass, g.gid, g.users, $0
  • Hash Cond: (p.gid = g.gid)
2.          

Initplan (forHash Left Join)

3. 0.009 0.110 ↑ 1.0 1 1

Aggregate (cost=9.92..9.93 rows=1 width=0) (actual time=0.109..0.110 rows=1 loops=1)

  • Output: count(*)
4. 0.101 0.101 ↑ 2.1 42 1

Foreign Scan on public.passwd (cost=0.00..9.70 rows=87 width=0) (actual time=0.008..0.101 rows=42 loops=1)

  • Output: passwd.username, passwd.pass, passwd.uid, passwd.gid, passwd.gecos, passwd.home, passwd.shell
  • Foreign File: /etc/passwd
  • Foreign File Size: 2079
5. 0.090 0.090 ↓ 3.8 42 1

Foreign Scan on public.passwd p (cost=0.00..2.10 rows=11 width=168) (actual time=0.020..0.090 rows=42 loops=1)

  • Output: p.username, p.pass, p.uid, p.gid, p.gecos, p.home, p.shell
  • Foreign File: /etc/passwd
  • Foreign File Size: 2079
6. 0.032 0.108 ↓ 8.9 71 1

Hash (cost=1.80..1.80 rows=8 width=100) (actual time=0.108..0.108 rows=71 loops=1)

  • Output: g.username, g.pass, g.gid, g.users
  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
7. 0.076 0.076 ↓ 8.9 71 1

Foreign Scan on public.groups g (cost=0.00..1.80 rows=8 width=100) (actual time=0.009..0.076 rows=71 loops=1)

  • Output: g.username, g.pass, g.gid, g.users
  • Foreign File: /etc/group
  • Foreign File Size: 987