explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IC8

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,124.463 ↑ 1.0 1 1

Limit (cost=339,363.30..339,363.30 rows=1 width=48) (actual time=2,124.462..2,124.463 rows=1 loops=1)

2. 35.771 2,124.460 ↑ 228,259.0 1 1

Sort (cost=339,363.30..339,933.95 rows=228,259 width=48) (actual time=2,124.460..2,124.460 rows=1 loops=1)

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

Hash Join (cost=302,969.20..338,222.00 rows=228,259 width=48) (actual time=1,318.481..2,088.689 rows=221,499 loops=1)

  • Hash Cond: (mp.product_id = products.product_id)
4. 75.360 91.337 ↑ 1.0 221,499 1

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

  • Recheck Cond: (parent = 15)
  • Heap Blocks: exact=16651
5. 15.977 15.977 ↑ 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=15.977..15.977 rows=221,499 loops=1)

  • Index Cond: (parent = 15)
6. 478.908 1,222.478 ↑ 1.0 1,231,723 1

Hash (cost=271,725.23..271,725.23 rows=1,231,723 width=48) (actual time=1,222.478..1,222.478 rows=1,231,723 loops=1)

  • Buckets: 65536 (originally 65536) Batches: 128 (originally 32) Memory Usage: 3585kB
7. 743.570 743.570 ↑ 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=48) (actual time=0.118..743.570 rows=1,231,723 loops=1)