explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ggzG

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

Limit (cost=363,541.89..363,541.94 rows=20 width=112) (actual time=3,822.000..3,822.006 rows=20 loops=1)

2. 68.869 3,822.003 ↑ 11,413.0 20 1

Sort (cost=363,541.89..364,112.54 rows=228,259 width=112) (actual time=3,821.999..3,822.003 rows=20 loops=1)

  • Sort Key: products.grow_all_order DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 35kB
3. 1,913.300 3,753.134 ↑ 1.0 221,499 1

Hash Join (cost=312,592.20..357,468.00 rows=228,259 width=112) (actual time=1,848.251..3,753.134 rows=221,499 loops=1)

  • Hash Cond: (mp.product_id = products.product_id)
4. 72.954 88.973 ↑ 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.742..88.973 rows=221,499 loops=1)

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

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

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

  • Buckets: 32768 (originally 32768) Batches: 128 (originally 64) Memory Usage: 3841kB
7. 772.469 772.469 ↑ 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=112) (actual time=0.117..772.469 rows=1,231,723 loops=1)

Planning time : 0.178 ms
Execution time : 3,822.407 ms