explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tKRy

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3,006.058 ↑ 1.0 20 1

Limit (cost=364,383.58..364,383.63 rows=20 width=144) (actual time=3,006.052..3,006.058 rows=20 loops=1)

2. 74.145 3,006.055 ↑ 11,413.0 20 1

Sort (cost=364,383.58..364,954.23 rows=228,259 width=144) (actual time=3,006.051..3,006.055 rows=20 loops=1)

  • Sort Key: products.grow_all_order DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 44kB
3. 2,031.810 2,931.910 ↑ 1.0 221,499 1

Hash Join (cost=28,270.91..358,309.69 rows=228,259 width=144) (actual time=124.258..2,931.910 rows=221,499 loops=1)

  • Hash Cond: (products.product_id = pa.product_id)
4. 776.539 776.539 ↑ 1.0 1,231,723 1

Seq Scan on wp_pidi_product_aliexpress products (cost=0.00..271,725.23 rows=1,231,723 width=144) (actual time=0.128..776.539 rows=1,231,723 loops=1)

5. 33.522 123.561 ↑ 1.0 221,499 1

Hash (cost=24,525.67..24,525.67 rows=228,259 width=8) (actual time=123.561..123.561 rows=221,499 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3186kB
6. 73.568 90.039 ↑ 1.0 221,499 1

Bitmap Heap Scan on wp_pidi_category_parent_product_aliexpress pa (cost=5,021.44..24,525.67 rows=228,259 width=8) (actual time=19.271..90.039 rows=221,499 loops=1)

  • Recheck Cond: (parent = 15)
  • Heap Blocks: exact=16651
7. 16.471 16.471 ↑ 1.0 221,499 1

Bitmap Index Scan on tree_product_index (cost=0.00..4,964.37 rows=228,259 width=0) (actual time=16.471..16.471 rows=221,499 loops=1)

  • Index Cond: (parent = 15)