explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bK2A

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 35.041 ↓ 0.0 0 1

Sort (cost=171,761.37..171,886.66 rows=50,116 width=244) (actual time=35.041..35.041 rows=0 loops=1)

  • Output: id, code, name, startdate, enddate, created, changed, data
  • Sort Key: svjul.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=2
2. 0.006 35.033 ↓ 0.0 0 1

Bitmap Heap Scan on public.svjul (cost=496.40..167,849.06 rows=50,116 width=244) (actual time=35.033..35.033 rows=0 loops=1)

  • Output: id, code, name, startdate, enddate, created, changed, data
  • Recheck Cond: (to_tsvector('russian'::regconfig, (svjul.data)::text) @@ '''1745454547'''::tsquery)
  • Buffers: shared hit=3 read=2
3. 35.027 35.027 ↓ 0.0 0 1

Bitmap Index Scan on dict_svjul_to_tsvector_idx (cost=0.00..483.87 rows=50,116 width=0) (actual time=35.027..35.027 rows=0 loops=1)

  • Index Cond: (to_tsvector('russian'::regconfig, (svjul.data)::text) @@ '''1745454547'''::tsquery)
  • Buffers: shared hit=3 read=2
Planning time : 0.376 ms
Execution time : 35.103 ms