explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nRXp

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 380.348 ↑ 1.0 12 1

Limit (cost=593.83..646.15 rows=12 width=13) (actual time=187.429..380.348 rows=12 loops=1)

2. 220.863 380.341 ↑ 283.2 12 1

Bitmap Heap Scan on contacts_suggestions (cost=593.83..15,409.27 rows=3,398 width=13) (actual time=187.427..380.341 rows=12 loops=1)

  • Recheck Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (terms @@ '''a'''::tsquery))
  • Filter: (has_email IS TRUE)
  • Rows Removed by Filter: 32
  • Heap Blocks: exact=38
3. 159.478 159.478 ↑ 1.5 5,243 1

Bitmap Index Scan on ft_ix_suggestions_company_id_terms (cost=0.00..592.98 rows=7,898 width=0) (actual time=159.478..159.478 rows=5,243 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (terms @@ '''a'''::tsquery))
Planning time : 3.901 ms
Execution time : 383.160 ms