explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lXAw

Settings
# exclusive inclusive rows x rows loops node
1. 87.191 95.386 ↓ 0.0 0 1

Update on contacts_trashbin (cost=91.24..2,515.76 rows=5,840 width=770) (actual time=95.386..95.386 rows=0 loops=1)

2. 6.283 8.195 ↓ 1.1 6,144 1

Bitmap Heap Scan on contacts_trashbin (cost=91.24..2,515.76 rows=5,840 width=770) (actual time=2.081..8.195 rows=6,144 loops=1)

  • Recheck Cond: (company_id = '\x56dbddbf6499a4f8f1bb9b34'::bytea)
  • Filter: ((deleted <= '2020-05-10 15:43:26.049+00'::timestamp with time zone) AND ((op_id = '\x000000000000000000000000'::bytea) OR (removing IS TRUE)))
  • Rows Removed by Filter: 4,800
  • Heap Blocks: exact=1,170
3. 1.912 1.912 ↑ 1.0 10,944 1

Bitmap Index Scan on ft_ix_company_id_op_id_search_text__tsv (cost=0.00..89.78 rows=10,944 width=0) (actual time=1.912..1.912 rows=10,944 loops=1)

  • Index Cond: (company_id = '\x56dbddbf6499a4f8f1bb9b34'::bytea)
Planning time : 0.976 ms
Execution time : 95.518 ms