explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qJgi

Settings
# exclusive inclusive rows x rows loops node
1. 0.369 62.692 ↑ 1.0 1,000 1

Limit (cost=38,531.91..38,534.41 rows=1,000 width=1,110) (actual time=61.967..62.692 rows=1,000 loops=1)

  • Buffers: shared hit=18,994
2. 8.539 62.323 ↑ 9.7 1,000 1

Sort (cost=38,531.91..38,556.23 rows=9,727 width=1,110) (actual time=61.965..62.323 rows=1,000 loops=1)

  • Sort Key: id
  • Sort Method: top-N heapsort Memory: 427kB
  • Buffers: shared hit=18,994
3. 50.441 53.784 ↓ 2.1 20,122 1

Bitmap Heap Scan on item_catalogue (cost=400.42..37,998.59 rows=9,727 width=1,110) (actual time=6.521..53.784 rows=20,122 loops=1)

  • Recheck Cond: (categoryid = 3,881)
  • Filter: (id > 696781)
  • Rows Removed by Filter: 135
  • Heap Blocks: exact=18,892
  • Buffers: shared hit=18,991
4. 3.343 3.343 ↓ 2.1 20,289 1

Bitmap Index Scan on ""item_catalogue_IX_item_catalogue_categoryId"" (cost=0.00..397.99 rows=9,789 width=0) (actual time=3.343..3.343 rows=20,289 loops=1)

  • Index Cond: (categoryid = 3,881)
  • Buffers: shared hit=99
Planning time : 1.881 ms
Execution time : 63.112 ms