explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZk5

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.073 ↑ 1.0 1 1

Limit (cost=4.56..4.56 rows=1 width=749) (actual time=0.072..0.073 rows=1 loops=1)

2. 0.006 0.071 ↑ 1.0 1 1

Sort (cost=4.56..4.56 rows=1 width=749) (actual time=0.071..0.071 rows=1 loops=1)

  • Sort Key: (ts_rank(search_text__tsv, '''Jon'''::tsquery, 1)) DESC
  • Sort Method: quicksort Memory: 27kB
3. 0.003 0.065 ↑ 1.0 1 1

Group (cost=4.53..4.55 rows=1 width=749) (actual time=0.065..0.065 rows=1 loops=1)

  • Group Key: company_id, contact_id
4. 0.011 0.062 ↑ 1.0 1 1

Sort (cost=4.53..4.54 rows=1 width=745) (actual time=0.062..0.062 rows=1 loops=1)

  • Sort Key: contact_id
  • Sort Method: quicksort Memory: 27kB
5. 0.051 0.051 ↑ 1.0 1 1

Index Scan using ix_company_id_op_id_contact_type on contacts_trashbin (cost=0.29..4.52 rows=1 width=745) (actual time=0.046..0.051 rows=1 loops=1)

  • Index Cond: ((company_id = '\x5cd25b986a8da2a1e420fbc4'::bytea) AND (op_id = '\x000000000000000000000000'::bytea))
  • Filter: (search_text__tsv @@ '''jon'''::tsquery)
  • Rows Removed by Filter: 8
Planning time : 0.508 ms
Execution time : 0.130 ms