explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Oao

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 166,088.509 ↓ 0.0 0 1

Limit (cost=26,132,250.33..26,132,250.40 rows=1 width=4) (actual time=166,088.509..166,088.509 rows=0 loops=1)

2.          

CTE _pli

3. 105.346 166,033.576 ↑ 1.0 14,391 1

Index Scan using product_list_items_product_list_id on product_list_items pli_1 (cost=0.29..26,132,250.33 rows=14,413 width=12) (actual time=43.544..166,033.576 rows=14,391 loops=1)

  • Index Cond: (product_list_id = 24)
4.          

SubPlan (for Index Scan)

5. 100.737 165,928.230 ↓ 0.0 0 14,391

Limit (cost=0.84..1,813.01 rows=1 width=8) (actual time=11.530..11.530 rows=0 loops=14,391)

6. 0.000 165,827.493 ↓ 0.0 0 14,391

Nested Loop (cost=0.84..1,813.01 rows=1 width=8) (actual time=11.523..11.523 rows=0 loops=14,391)

  • Join Filter: (pu_r.upc = pu.upc)
7. 14.391 165,827.493 ↓ 0.0 0 14,391

Nested Loop (cost=0.42..1,810.35 rows=1 width=21) (actual time=11.523..11.523 rows=0 loops=14,391)

8. 165,813.102 165,813.102 ↓ 0.0 0 14,391

Seq Scan on product_list_items pli2 (cost=0.00..1,807.71 rows=1 width=12) (actual time=11.522..11.522 rows=0 loops=14,391)

  • Filter: (price > '0'::double precision)
  • Rows Removed by Filter: 55577
9. 0.000 0.000 ↓ 0.0 0

Index Scan using product_url_pkey on product_url pu_r (cost=0.42..2.64 rows=1 width=17) (never executed)

  • Index Cond: (id = pli2.product_url_id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using product_url_pkey on product_url pu (cost=0.42..2.64 rows=1 width=13) (never executed)

  • Index Cond: (id = pli_1.product_url_id)
11. 166,088.508 166,088.508 ↓ 0.0 0 1

CTE Scan on _pli pli (cost=0.00..324.29 rows=4,804 width=4) (actual time=166,088.508..166,088.508 rows=0 loops=1)

  • Filter: (price > '0'::double precision)
  • Rows Removed by Filter: 14391
Planning time : 3.654 ms
Execution time : 166,088.987 ms