explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 87QM

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 736.527 ↑ 1.0 20 1

Limit (cost=314,349.01..314,349.06 rows=20 width=144) (actual time=736.521..736.527 rows=20 loops=1)

2. 0.706 736.522 ↑ 1,902.2 20 1

Sort (cost=314,349.01..314,444.12 rows=38,043 width=144) (actual time=736.519..736.522 rows=20 loops=1)

  • Sort Key: products.grow_all_order DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 44kB
3. 50.000 735.816 ↑ 28.8 1,319 1

Hash Join (cost=286,602.06..313,336.70 rows=38,043 width=144) (actual time=642.223..735.816 rows=1,319 loops=1)

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

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

  • Index Cond: (parent = 15)
6. 9.984 597.561 ↑ 27.1 7,581 1

Hash (cost=274,804.54..274,804.54 rows=205,287 width=144) (actual time=597.561..597.561 rows=7,581 loops=1)

  • Buckets: 32768 Batches: 16 Memory Usage: 584kB
7. 587.577 587.577 ↑ 27.1 7,581 1

Seq Scan on wp_pidi_product_aliexpress products (cost=0.00..274,804.54 rows=205,287 width=144) (actual time=0.251..587.577 rows=7,581 loops=1)

  • Filter: (is_dropship AND (price_min <= '10'::double precision))
  • Rows Removed by Filter: 1224142