explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ROX

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.183 ↑ 1.0 1 1

Limit (cost=13.46..13.46 rows=1 width=749) (actual time=0.182..0.183 rows=1 loops=1)

2. 0.007 0.182 ↑ 5.0 1 1

Sort (cost=13.46..13.47 rows=5 width=749) (actual time=0.182..0.182 rows=1 loops=1)

  • Sort Key: (ts_rank(search_text__tsv, '''Jon'''::tsquery, 1)) DESC
  • Sort Method: quicksort Memory: 26kB
3. 0.004 0.175 ↑ 5.0 1 1

Group (cost=13.38..13.43 rows=5 width=749) (actual time=0.174..0.175 rows=1 loops=1)

  • Group Key: company_id, contact_id
4. 0.024 0.171 ↑ 5.0 1 1

Sort (cost=13.38..13.39 rows=5 width=745) (actual time=0.171..0.171 rows=1 loops=1)

  • Sort Key: contact_id
  • Sort Method: quicksort Memory: 26kB
5. 0.007 0.147 ↑ 5.0 1 1

Bitmap Heap Scan on contacts_trashbin (cost=7.76..13.32 rows=5 width=745) (actual time=0.146..0.147 rows=1 loops=1)

  • Recheck Cond: ((company_id = '\x56dbddbf6499a4f8f1bb9b34'::bytea) AND (op_id = '\x000000000000000000000000'::bytea) AND (search_text__tsv @@ '''jon'''::tsquery))
  • Heap Blocks: exact=1
6. 0.140 0.140 ↑ 5.0 1 1

Bitmap Index Scan on ft_ix_company_id_op_id_search_text__tsv (cost=0.00..7.76 rows=5 width=0) (actual time=0.140..0.140 rows=1 loops=1)

  • Index Cond: ((company_id = '\x56dbddbf6499a4f8f1bb9b34'::bytea) AND (op_id = '\x000000000000000000000000'::bytea) AND (search_text__tsv @@ '''jon'''::tsquery))
Planning time : 0.289 ms
Execution time : 0.234 ms