explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mXqJ

Settings
# exclusive inclusive rows x rows loops node
1. 18.098 11,067.265 ↑ 1.0 15,369 1

Sort (cost=57,395.79..57,435.71 rows=15,967 width=24) (actual time=11,064.345..11,067.265 rows=15,369 loops=1)

  • Sort Key: global_order
  • Sort Method: quicksort Memory: 1585kB
2. 11,046.663 11,049.167 ↑ 1.0 15,369 1

Bitmap Heap Scan on articles (cost=1,272.17..56,281.07 rows=15,967 width=24) (actual time=3.603..11,049.167 rows=15,369 loops=1)

  • Recheck Cond: (parent_text_id = 'LEGITEXT000006070633'::text)
  • Heap Blocks: exact=7130
3. 2.504 2.504 ↑ 1.0 15,369 1

Bitmap Index Scan on articles_parent_text_id_idx (cost=0.00..1,268.18 rows=15,967 width=0) (actual time=2.504..2.504 rows=15,369 loops=1)

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