explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jfb

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 19.125 ↑ 1.0 20 1

Limit (cost=7,320.28..7,320.33 rows=20 width=144) (actual time=19.122..19.125 rows=20 loops=1)

2. 2.169 19.121 ↑ 43.6 20 1

Sort (cost=7,320.28..7,322.46 rows=873 width=144) (actual time=19.121..19.121 rows=20 loops=1)

  • Sort Key: products.sum_order_7 DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 45kB
3. 2.276 16.952 ↓ 5.4 4,695 1

Nested Loop (cost=0.98..7,297.05 rows=873 width=144) (actual time=0.030..16.952 rows=4,695 loops=1)

4. 0.591 0.591 ↓ 5.4 4,695 1

Index Only Scan using wp_pidi_category_map_product_aliexpress_pkey on wp_pidi_category_map_product_aliexpress (cost=0.56..127.83 rows=873 width=8) (actual time=0.018..0.591 rows=4,695 loops=1)

  • Index Cond: (category_id = 15)
  • Heap Fetches: 0
5. 14.085 14.085 ↑ 1.0 1 4,695

Index Scan using product_id_aliexpress on wp_pidi_product_aliexpress products (cost=0.43..8.20 rows=1 width=144) (actual time=0.003..0.003 rows=1 loops=4,695)

  • Index Cond: (product_id = wp_pidi_category_map_product_aliexpress.product_id)
Planning time : 0.218 ms
Execution time : 19.165 ms