explain.depesz.com

A tool for finding a real cause for slow queries.

Result: UqK : Anonymized with Pg::Explain 0.62

options
# exclusive inclusive rows x rows loops node
1. 0.046 0.354 ↓ 3.8 42 1
→

Hash Left Join (cost=11.830..13.980 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: (kilo_foxtrot.juliet = kilo_tango.juliet)
2.          

Initplan (forHash Left Join)
3. 0.009 0.110 ↑ 1.0 1 1
→

Aggregate (cost=9.920..9.930 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.000..9.700 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.000..2.100 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.800..1.800 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.000..1.800 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