explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ReD3

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 30.405 ↓ 0.0 0 1

Subquery Scan on article (cost=62,830.12..62,830.19 rows=1 width=84) (actual time=30.405..30.405 rows=0 loops=1)

  • Filter: (article.article_id = 'LEGIARTI000006581613'::text)
  • Rows Removed by Filter: 2
2. 0.002 30.400 ↑ 1.0 2 1

Limit (cost=62,830.12..62,830.16 rows=2 width=88) (actual time=30.398..30.400 rows=2 loops=1)

3. 0.011 30.398 ↑ 3,155.5 2 1

WindowAgg (cost=62,830.12..62,956.34 rows=6,311 width=88) (actual time=30.396..30.398 rows=2 loops=1)

4. 1.263 30.387 ↑ 2,103.7 3 1

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

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 336kB
5. 25.839 29.124 ↑ 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=4.460..29.124 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
6. 3.285 3.285 ↓ 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=3.285..3.285 rows=19,461 loops=1)

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