explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fSM

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,135.403 ↑ 1.0 20 1

Limit (cost=304,500.94..304,500.99 rows=20 width=144) (actual time=1,135.398..1,135.403 rows=20 loops=1)

2. 416.933 1,135.401 ↑ 61,586.2 20 1

Sort (cost=304,500.94..307,580.24 rows=1,231,723 width=144) (actual time=1,135.396..1,135.401 rows=20 loops=1)

  • Sort Key: grow_all_order DESC NULLS LAST
  • Sort Method: top-N heapsort Memory: 44kB
3. 718.468 718.468 ↑ 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=144) (actual time=0.128..718.468 rows=1,231,723 loops=1)

Planning time : 0.069 ms
Execution time : 1,135.428 ms