explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WVs1

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.032 ↓ 0.0 0 1

Hash Join (cost=1.40..3.78 rows=1 width=516) (actual time=0.031..0.032 rows=0 loops=1)

  • Hash Cond: (a.id = t.logo_asset_id)
2. 0.009 0.009 ↑ 16.0 1 1

Seq Scan on asset a (cost=0.00..2.31 rows=16 width=532) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: is_active
3. 0.001 0.016 ↓ 0.0 0 1

Hash (cost=1.39..1.39 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
4. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on team t (cost=0.00..1.39 rows=1 width=16) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ((name)::text = ''::text)
  • Rows Removed by Filter: 31
Planning time : 0.090 ms