explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZNXB

Settings
# exclusive inclusive rows x rows loops node
1. 0.726 197.263 ↑ 17.7 432 1

Sort (cost=27,848.35..27,867.42 rows=7,630 width=163) (actual time=197.222..197.263 rows=432 loops=1)

  • Sort Key: (ts_rank(to_tsvector('simple'::regconfig, COALESCE((concepts_1.label)::text, ''::text)), '''psoriasis'''::tsquery, 0)) DESC, concepts.id
  • Sort Method: quicksort Memory: 132kB
2. 6.066 196.537 ↑ 17.7 432 1

Hash Join (cost=12,738.71..27,356.31 rows=7,630 width=163) (actual time=169.512..196.537 rows=432 loops=1)

  • Hash Cond: (concepts.id = concepts_1.id)
3. 21.458 21.458 ↑ 1.0 22,889 1

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

4. 0.309 169.013 ↑ 17.7 432 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 93kB
5. 168.704 168.704 ↑ 17.7 432 1

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

  • Filter: (similarity('psoriasis'::text, COALESCE((label)::text, ''::text)) >= '0.2'::double precision)
  • Rows Removed by Filter: 22,457
Planning time : 0.404 ms
Execution time : 197.382 ms