explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aeHU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 0.099 ↑ 1.0 1 1

Subquery Scan on article (cost=121.55..121.81 rows=1 width=84) (actual time=0.091..0.099 rows=1 loops=1)

  • Filter: (article.article_id = 'LEGIARTI000023080663'::text)
  • Rows Removed by Filter: 13
2. 0.017 0.096 ↓ 1.8 14 1

WindowAgg (cost=121.55..121.71 rows=8 width=88) (actual time=0.087..0.096 rows=14 loops=1)

3. 0.007 0.079 ↓ 1.8 14 1

Sort (cost=121.55..121.57 rows=8 width=24) (actual time=0.078..0.079 rows=14 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 26kB
4. 0.054 0.072 ↓ 1.8 14 1

Bitmap Heap Scan on articles structure (cost=4.53..121.43 rows=8 width=24) (actual time=0.028..0.072 rows=14 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: 19
  • Heap Blocks: exact=24
5. 0.018 0.018 ↑ 1.0 33 1

Bitmap Index Scan on articles_parent_text_id_idx (cost=0.00..4.53 rows=33 width=0) (actual time=0.018..0.018 rows=33 loops=1)

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