explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BDOq

Settings
# exclusive inclusive rows x rows loops node
1. 0.104 2,007.522 ↑ 7,849.5 172 1

Nested Loop (cost=12,491.36..7,407,720.18 rows=1,350,111 width=20) (actual time=1,606.343..2,007.522 rows=172 loops=1)

  • Output: disease_synonym.d_id, disease_synonym.ds_syn_id, pubmed_sentence.pubmed_2019_id, pubmed_sentence.pmid, pubmed_sentence.id
  • Buffers: shared hit=3930 read=3091
  • I/O Timings: read=1698.401
2. 0.003 16.392 ↑ 1.0 1 1

Limit (cost=0.00..0.04 rows=1 width=611) (actual time=16.390..16.392 rows=1 loops=1)

  • Output: disease_synonym.ds_syn_id, NULL::character varying(500), disease_synonym.d_id, NULL::smallint, disease_synonym.tsquery_name
  • Buffers: shared read=142
  • I/O Timings: read=16.050
3. 16.389 16.389 ↑ 17,120.0 1 1

Seq Scan on public.disease_synonym (cost=0.00..634.20 rows=17,120 width=611) (actual time=16.389..16.389 rows=1 loops=1)

  • Output: disease_synonym.ds_syn_id, NULL::character varying(500), disease_synonym.d_id, NULL::smallint, disease_synonym.tsquery_name
  • Buffers: shared read=142
  • I/O Timings: read=16.050
4. 406.623 1,991.026 ↑ 7,849.5 172 1

Bitmap Heap Scan on public.pubmed_sentence (cost=12,491.36..7,394,219.02 rows=1,350,111 width=290) (actual time=1,589.946..1,991.026 rows=172 loops=1)

  • Output: pubmed_sentence.id, pubmed_sentence.pubmed_2019_id, pubmed_sentence.pmid, pubmed_sentence.sentence, pubmed_sentence.textindex_s, pubmed_sentence.created_at, pubmed_sentence.updated_at, pubmed_sentence.sentence_type
  • Recheck Cond: (pubmed_sentence.textindex_s @@ disease_synonym.tsquery_name)
  • Rows Removed by Index Recheck: 252
  • Heap Blocks: exact=356
  • Buffers: shared hit=3930 read=2949
  • I/O Timings: read=1682.351
5. 1,584.403 1,584.403 ↑ 3,184.2 424 1

Bitmap Index Scan on pubmed_sentence_textindex_s_idx (cost=0.00..12,153.83 rows=1,350,111 width=0) (actual time=1,584.402..1,584.403 rows=424 loops=1)

  • Index Cond: (pubmed_sentence.textindex_s @@ disease_synonym.tsquery_name)
  • Buffers: shared hit=3866 read=2616
  • I/O Timings: read=1281.207
Planning time : 0.150 ms