explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mGe1

Settings
# exclusive inclusive rows x rows loops node
1. 0.097 24.980 ↑ 17.7 72 1

Sort (cost=865.20..868.39 rows=1,277 width=248) (actual time=24.968..24.980 rows=72 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: 44kB
2. 0.637 24.883 ↑ 17.7 72 1

Hash Join (cost=242.43..799.32 rows=1,277 width=248) (actual time=23.579..24.883 rows=72 loops=1)

  • Hash Cond: (concepts.id = concepts_1.id)
3. 0.715 0.715 ↑ 1.0 3,831 1

Seq Scan on concepts (cost=0.00..207.31 rows=3,831 width=244) (actual time=0.004..0.715 rows=3,831 loops=1)

4. 0.023 23.531 ↑ 17.7 72 1

Hash (cost=226.47..226.47 rows=1,277 width=35) (actual time=23.531..23.531 rows=72 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 21kB
5. 23.508 23.508 ↑ 17.7 72 1

Seq Scan on concepts concepts_1 (cost=0.00..226.47 rows=1,277 width=35) (actual time=0.888..23.508 rows=72 loops=1)

  • Filter: (similarity('psoriasis'::text, COALESCE((label)::text, ''::text)) >= '0.2'::double precision)
  • Rows Removed by Filter: 3759
Planning time : 1.247 ms
Execution time : 25.025 ms