explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yj5

Settings
# exclusive inclusive rows x rows loops node
1. 0.490 11,718.983 ↓ 0.0 0 1

Subquery Scan on article (cost=62,830.12..63,035.23 rows=1 width=84) (actual time=11,718.983..11,718.983 rows=0 loops=1)

  • Filter: (article.article_id = 'LEGIARTI000006581613'::text)
  • Rows Removed by Filter: 3066
2. 2.823 11,718.493 ↑ 2.1 3,066 1

WindowAgg (cost=62,830.12..62,956.34 rows=6,311 width=88) (actual time=11,715.155..11,718.493 rows=3,066 loops=1)

3. 4.430 11,715.670 ↑ 2.1 3,066 1

Sort (cost=62,830.12..62,845.90 rows=6,311 width=24) (actual time=11,715.144..11,715.670 rows=3,066 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 336kB
4. 11,505.132 11,711.240 ↑ 2.1 3,066 1

Bitmap Heap Scan on articles structure (cost=1,415.57..62,431.78 rows=6,311 width=24) (actual time=211.489..11,711.240 rows=3,066 loops=1)

  • Recheck Cond: (parent_text_id = 'LEGITEXT000006071367'::text)
  • Filter: (((initial_version <> 'LEGIARTI000006581610'::text) AND (state = 'VIGUEUR'::text)) OR ((state = 'ABROGE_DIFF'::text) AND (ending_date > now())) OR (article_id = 'LEGIARTI000023080663'::text))
  • Rows Removed by Filter: 16395
  • Heap Blocks: exact=6500
5. 206.108 206.108 ↓ 1.1 19,461 1

Bitmap Index Scan on articles_parent_text_id_idx (cost=0.00..1,413.99 rows=17,808 width=0) (actual time=206.108..206.108 rows=19,461 loops=1)

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