explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hylc

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 167.064 ↑ 1.0 35 1

Limit (cost=7,467.46..7,467.55 rows=35 width=854) (actual time=167.060..167.064 rows=35 loops=1)

  • Buffers: shared hit=75922
2. 4.766 167.060 ↑ 143.4 36 1

Sort (cost=7,467.46..7,480.37 rows=5,163 width=854) (actual time=167.059..167.060 rows=36 loops=1)

  • Sort Key: (ts_rank(ex.ts_vector_fts, '''guerr'''::tsquery)) DESC
  • Sort Method: top-N heapsort Memory: 28kB
  • Buffers: shared hit=75922
3. 1.509 162.294 ↓ 2.7 13,848 1

Append (cost=37.36..7,308.18 rows=5,163 width=854) (actual time=8.151..162.294 rows=13,848 loops=1)

  • Buffers: shared hit=75922
4. 74.961 78.274 ↓ 2.1 5,543 1

Bitmap Heap Scan on tb_documento_expediente_p_y2017 ex (cost=37.36..4,434.55 rows=2,588 width=854) (actual time=8.150..78.274 rows=5,543 loops=1)

  • Recheck Cond: (ts_vector_fts @@ '''guerr'''::tsquery)
  • Filter: ((dt_protocolo_central >= '2016-01-01 00:00:00'::timestamp without time zone) AND (dt_protocolo_central <= '2020-12-31 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 3668
  • Heap Blocks: exact=8541
  • Buffers: shared hit=32672
5. 3.313 3.313 ↓ 2.3 9,211 1

Bitmap Index Scan on tb_documento_expediente_p_y2017_ts_vector_fts_idx (cost=0.00..36.71 rows=4,014 width=0) (actual time=3.313..3.313 rows=9,211 loops=1)

  • Index Cond: (ts_vector_fts @@ '''guerr'''::tsquery)
  • Buffers: shared hit=8
6. 80.495 82.511 ↓ 3.2 8,305 1

Bitmap Heap Scan on tb_documento_expediente_p_y2020 ex_1 (cost=25.46..2,847.82 rows=2,575 width=854) (actual time=2.928..82.511 rows=8,305 loops=1)

  • Recheck Cond: (ts_vector_fts @@ '''guerr'''::tsquery)
  • Filter: ((dt_protocolo_central >= '2016-01-01 00:00:00'::timestamp without time zone) AND (dt_protocolo_central <= '2020-12-31 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=7566
  • Buffers: shared hit=43250
7. 2.016 2.016 ↓ 3.2 8,305 1

Bitmap Index Scan on tb_documento_expediente_p_y2020_ts_vector_fts_idx (cost=0.00..24.81 rows=2,575 width=0) (actual time=2.016..2.016 rows=8,305 loops=1)

  • Index Cond: (ts_vector_fts @@ '''guerr'''::tsquery)
  • Buffers: shared hit=8
Planning time : 1.252 ms
Execution time : 167.169 ms