explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GLC3 : Optimization for: Optimization for: Big rows; plan #euWq; plan #PtUo

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.683 22.076 ↑ 1.0 1 1

Subquery Scan on article (cost=29,524.86..29,615.89 rows=1 width=84) (actual time=17.828..22.076 rows=1 loops=1)

  • Filter: (article.article_id = 'LEGIARTI000023080663'::text)
  • Rows Removed by Filter: 6141
2. 4.848 21.393 ↓ 2.2 6,142 1

WindowAgg (cost=29,524.86..29,580.88 rows=2,801 width=88) (actual time=15.916..21.393 rows=6,142 loops=1)

3. 2.757 16.545 ↓ 2.2 6,142 1

Sort (cost=29,524.86..29,531.86 rows=2,801 width=24) (actual time=15.894..16.545 rows=6,142 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 672kB
4. 12.350 13.788 ↓ 2.2 6,142 1

Bitmap Heap Scan on articles structure (cost=628.39..29,364.48 rows=2,801 width=24) (actual time=2.215..13.788 rows=6,142 loops=1)

  • Recheck Cond: (parent_text_id = 'LEGITEXT000023086525'::text)
  • Filter: (((initial_version <> 'LEGIARTI000023086394'::text) AND (state = 'VIGUEUR'::text)) OR ((state = 'ABROGE_DIFF'::text) AND (ending_date > now())) OR (article_id = 'LEGIARTI000023080663'::text))
  • Rows Removed by Filter: 1964
  • Heap Blocks: exact=3945
5. 1.438 1.438 ↓ 1.0 8,106 1

Bitmap Index Scan on articles_parent_text_id_idx (cost=0.00..627.69 rows=7,902 width=0) (actual time=1.438..1.438 rows=8,106 loops=1)

  • Index Cond: (parent_text_id = 'LEGITEXT000023086525'::text)