explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u5Rt

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 230.647 ↑ 1.0 20 1

Limit (cost=226,985.51..226,985.56 rows=20 width=144) (actual time=230.642..230.647 rows=20 loops=1)

2. 19.991 230.647 ↑ 2,073.3 20 1

Sort (cost=226,985.51..227,089.18 rows=41,466 width=144) (actual time=230.642..230.647 rows=20 loops=1)

  • Sort Key: products.sum_order_7 DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 45kB
3. 0.000 210.656 ↓ 1.0 43,176 1

Nested Loop (cost=922.22..225,882.12 rows=41,466 width=144) (actual time=8.733..210.656 rows=43,176 loops=1)

4. 36.499 41.758 ↓ 1.0 43,176 1

Bitmap Heap Scan on wp_pidi_category_parent_product_aliexpress mp (cost=921.79..26,395.09 rows=41,466 width=8) (actual time=8.722..41.758 rows=43,176 loops=1)

  • Recheck Cond: (parent = 100003109)
  • Heap Blocks: exact=20219
5. 5.259 5.259 ↓ 1.0 43,176 1

Bitmap Index Scan on tree_product_index (cost=0.00..911.43 rows=41,466 width=0) (actual time=5.259..5.259 rows=43,176 loops=1)

  • Index Cond: (parent = 100003109)
6. 172.704 172.704 ↑ 1.0 1 43,176

Index Scan using product_id_aliexpress on wp_pidi_product_aliexpress products (cost=0.43..4.80 rows=1 width=144) (actual time=0.003..0.004 rows=1 loops=43,176)

  • Index Cond: (product_id = mp.product_id)
Planning time : 0.240 ms
Execution time : 230.875 ms