explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mWjt

Settings
# exclusive inclusive rows x rows loops node
1. 0.245 0.445 ↑ 1.0 295 1

Sort (cost=23.79..24.53 rows=295 width=617) (actual time=0.432..0.445 rows=295 loops=1)

  • Sort Key: ((search ~~ 'fn$%$|'::text))
  • Sort Method: quicksort Memory: 106kB
2. 0.200 0.200 ↑ 1.0 295 1

Seq Scan on contacts (cost=0.00..11.69 rows=295 width=617) (actual time=0.012..0.200 rows=295 loops=1)

Planning time : 0.105 ms
Execution time : 0.587 ms