explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j1hD

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 44,384 1

Gather Merge (cost=0..0 rows=0 width=0) (actual rows=44,384 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.000 0.000 ↓ 0.0 14,795 3 / 3

Sort (cost=0..0 rows=0 width=0) (actual rows=14,795 loops=3)

  • Sort Key: products_product.name, products_product.created_on DESC
  • Sort Method: external merge Disk: 27384kB
3. 0.000 0.000 ↓ 0.0 14,795 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual rows=14,795 loops=3)

4. 0.000 0.000 ↓ 0.0 14,795 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual rows=14,795 loops=3)

5. 0.000 0.000 ↓ 0.0 14,795 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual rows=14,795 loops=3)

6. 0.000 0.000 ↓ 0.0 14,795 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual rows=14,795 loops=3)

7. 0.000 0.000 ↓ 0.0 14,795 3 / 3

Seq Scan on products_product products_product (cost=0..0 rows=0 width=0) (actual rows=14,795 loops=3)

  • Filter: ((sub_category_id IS NULL) AND ((listing_state)::text <> 'Archived'::text))
8. 0.000 0.000 ↓ 0.0 9,486 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual rows=9,486 loops=3)

9. 0.000 0.000 ↓ 0.0 9,486 3 / 3

Seq Scan on companies_company companies_company (cost=0..0 rows=0 width=0) (actual rows=9,486 loops=3)

10. 0.000 0.000 ↓ 0.0 7 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual rows=7 loops=3)

11. 0.000 0.000 ↓ 0.0 7 3 / 3

Seq Scan on products_productcategory products_productcategory (cost=0..0 rows=0 width=0) (actual rows=7 loops=3)

12. 0.000 0.000 ↓ 0.0 2,583 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual rows=2,583 loops=3)

13. 0.000 0.000 ↓ 0.0 2,583 3 / 3

Seq Scan on brands_brand brands_brand (cost=0..0 rows=0 width=0) (actual rows=2,583 loops=3)

14. 0.000 0.000 ↓ 0.0 10,392 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual rows=10,392 loops=3)

15. 0.000 0.000 ↓ 0.0 10,392 3 / 3

Seq Scan on products_productline products_productline (cost=0..0 rows=0 width=0) (actual rows=10,392 loops=3)