explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HHgi

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.286 ↑ 1.0 20 1

Limit (cost=0.43..72.29 rows=20 width=144) (actual time=0.166..0.286 rows=20 loops=1)

2. 0.010 0.283 ↑ 11,413.0 20 1

Nested Loop (cost=0.43..820,114.08 rows=228,259 width=144) (actual time=0.166..0.283 rows=20 loops=1)

3. 0.173 0.173 ↑ 11,413.0 20 1

Seq Scan on wp_pidi_category_parent_product_aliexpress mp (cost=0.00..55,156.24 rows=228,259 width=8) (actual time=0.151..0.173 rows=20 loops=1)

  • Filter: (parent = 15)
  • Rows Removed by Filter: 239
4. 0.100 0.100 ↑ 1.0 1 20

Index Scan using product_id_aliexpress on wp_pidi_product_aliexpress products (cost=0.43..3.34 rows=1 width=144) (actual time=0.005..0.005 rows=1 loops=20)

  • Index Cond: (product_id = mp.product_id)
Planning time : 0.223 ms
Execution time : 0.317 ms