explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zGR6

Settings
# exclusive inclusive rows x rows loops node
1. 0.334 29.316 ↓ 0.0 0 1

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

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

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

3. 1.442 26.705 ↑ 2.1 3,066 1

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

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 336kB
4. 22.677 25.263 ↑ 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=3.653..25.263 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. 2.586 2.586 ↓ 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=2.586..2.586 rows=19,461 loops=1)

  • Index Cond: (parent_text_id = 'LEGITEXT000006071367'::text)
Planning time : 0.176 ms
Execution time : 29.448 ms