explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSJx

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

Sort (cost=27,848.35..27,867.42 rows=7,630 width=163) (actual rows= loops=)

  • Sort Key: (ts_rank(to_tsvector('simple'::regconfig, COALESCE((concepts_1.label)::text, ''::text)), '''psoriasis'''::tsquery, 0)) DESC, concepts.id
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,738.71..27,356.31 rows=7,630 width=163) (actual rows= loops=)

  • Hash Cond: (concepts.id = concepts_1.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on concepts (cost=0.00..12,528.89 rows=22,889 width=159) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=12,643.33..12,643.33 rows=7,630 width=35) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on concepts concepts_1 (cost=0.00..12,643.33 rows=7,630 width=35) (actual rows= loops=)

  • Filter: (similarity('psoriasis'::text, COALESCE((label)::text, ''::text)) >= '0.2'::double precision)