explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tqHZ

Settings
# exclusive inclusive rows x rows loops node
1. 3.368 53.993 ↓ 0.0 0 1

Subquery Scan on article (cost=63,469.24..64,047.97 rows=1 width=84) (actual time=53.993..53.993 rows=0 loops=1)

  • Filter: (article.article_id = 'LEGIARTI000006581613'::text)
  • Rows Removed by Filter: 19457
2. 14.624 50.625 ↓ 1.1 19,457 1

WindowAgg (cost=63,469.24..63,825.38 rows=17,807 width=88) (actual time=32.896..50.625 rows=19,457 loops=1)

3. 10.221 36.001 ↓ 1.1 19,457 1

Sort (cost=63,469.24..63,513.76 rows=17,807 width=24) (actual time=32.884..36.001 rows=19,457 loops=1)

  • Sort Key: structure.global_order
  • Sort Method: quicksort Memory: 2289kB
4. 22.093 25.780 ↓ 1.1 19,457 1

Bitmap Heap Scan on articles structure (cost=1,418.44..62,212.06 rows=17,807 width=24) (actual time=4.832..25.780 rows=19,457 loops=1)

  • Recheck Cond: (parent_text_id = 'LEGITEXT000006071367'::text)
  • Filter: (initial_version <> 'LEGIARTI000006581610'::text)
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=6500
5. 3.687 3.687 ↓ 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.687..3.687 rows=19,461 loops=1)

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