explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d8iy

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=175.48..175.50 rows=6 width=145) (actual rows= loops=)

  • Sort Key: (ts_rank((to_tsvector('simple'::regconfig, COALESCE((partners_1.short_id)::text, ''::text)) || to_tsvector('simple'::regconfig, COALESCE((partners_1.name)::text, ''::text))), '''mjmm'':*'::tsquery, 0)) DESC, partners.id
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=161.57..175.40 rows=6 width=145) (actual rows= loops=)

  • Hash Cond: (partners.id = partners_1.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on partners (cost=0.00..10.00 rows=300 width=141) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=161.50..161.50 rows=6 width=33) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on partners partners_1 (cost=0.00..161.50 rows=6 width=33) (actual rows= loops=)

  • Filter: ((to_tsvector('simple'::regconfig, COALESCE((short_id)::text, ''::text)) || to_tsvector('simple'::regconfig, COALESCE((name)::text, ''::text))) @@ '''mjmm'':*'::tsquery)