explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i8MZ

Settings
# exclusive inclusive rows x rows loops node
1. 4.260 5.356 ↓ 15.5 201 1

Sort (cost=42.20..42.23 rows=13 width=1,258) (actual time=5.328..5.356 rows=201 loops=1)

  • Sort Key: c1_.priority, p0_.title
  • Sort Method: quicksort Memory: 218kB
2. 0.228 1.096 ↓ 15.5 201 1

Nested Loop Left Join (cost=1.75..41.96 rows=13 width=1,258) (actual time=0.095..1.096 rows=201 loops=1)

3. 0.309 0.476 ↓ 15.1 196 1

Hash Left Join (cost=1.61..38.88 rows=13 width=1,195) (actual time=0.080..0.476 rows=196 loops=1)

  • Hash Cond: (p0_.category_id = c1_.id)
  • Filter: ((p0_.category_id = 108) OR (c1_.parent_id = 108))
  • Rows Removed by Filter: 127
4. 0.122 0.122 ↑ 1.0 323 1

Seq Scan on products p0_ (cost=0.00..36.23 rows=323 width=846) (actual time=0.010..0.122 rows=323 loops=1)

5. 0.025 0.045 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=349) (actual time=0.045..0.045 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
6. 0.020 0.020 ↑ 1.0 27 1

Seq Scan on categories c1_ (cost=0.00..1.27 rows=27 width=349) (actual time=0.010..0.020 rows=27 loops=1)

7. 0.392 0.392 ↑ 1.0 1 196

Index Scan using idx_price_product_id on prices p2_ (cost=0.15..0.23 rows=1 width=63) (actual time=0.002..0.002 rows=1 loops=196)

  • Index Cond: (p0_.id = product_id)