explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y8Kh

Settings
# exclusive inclusive rows x rows loops node
1. 11,355.563 13,389.121 ↑ 1.0 40,687 1

Bitmap Heap Scan on articles (cost=3,368.88..133,088.60 rows=42,381 width=24) (actual time=2,062.867..13,389.121 rows=40,687 loops=1)

  • Recheck Cond: (parent_text_id = 'LEGITEXT000006072665'::text)
  • Heap Blocks: exact=17673
2. 2,033.558 2,033.558 ↑ 1.0 40,687 1

Bitmap Index Scan on articles_parent_text_id_idx (cost=0.00..3,358.28 rows=42,381 width=0) (actual time=2,033.558..2,033.558 rows=40,687 loops=1)

  • Index Cond: (parent_text_id = 'LEGITEXT000006072665'::text)
Planning time : 0.097 ms
Execution time : 13,392.329 ms