explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pIKl

Settings
# exclusive inclusive rows x rows loops node
1. 444.694 445.172 ↓ 8.0 8 1

Bitmap Heap Scan on document d (cost=71.85..88.20 rows=1 width=1,238) (actual time=142.079..445.172 rows=8 loops=1)

  • Recheck Cond: ((category_id = ANY ('{483b8536-076a-4aa2-aa81-e3f6042e4b6b}'::uuid[])) AND (client_company_id = '7acda277-f07c-4975-bd12-d23deace6a9a'::uuid))
  • Filter: (to_tsvector('german'::regconfig, (((((((id)::text || ' '::text) || fulltext) || ' '::text) || COALESCE(title, ''::text)) || ' '::text) || filename_from_path(source_file))) @@ '''slaask'''::tsquery)
  • Rows Removed by Filter: 1221
  • Heap Blocks: exact=1064
2. 0.051 0.478 ↓ 0.0 0 1

BitmapAnd (cost=71.85..71.85 rows=10 width=0) (actual time=0.478..0.478 rows=0 loops=1)

3. 0.166 0.166 ↑ 1.0 1,229 1

Bitmap Index Scan on document_category_id_idx (cost=0.00..21.74 rows=1,229 width=0) (actual time=0.165..0.166 rows=1,229 loops=1)

  • Index Cond: (category_id = ANY ('{483b8536-076a-4aa2-aa81-e3f6042e4b6b}'::uuid[]))
4. 0.261 0.261 ↑ 1.0 2,046 1

Bitmap Index Scan on document_client_company_id_idx (cost=0.00..49.87 rows=2,046 width=0) (actual time=0.260..0.261 rows=2,046 loops=1)

  • Index Cond: (client_company_id = '7acda277-f07c-4975-bd12-d23deace6a9a'::uuid)
Planning time : 0.613 ms
Execution time : 445.243 ms