explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 16Jv : Optimization for: plan #oPAW

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.078 0.112 ↓ 33.0 33 1

Index Scan using index_products_on_company_id on products (cost=19.88..27.90 rows=1 width=166) (actual time=0.077..0.112 rows=33 loops=1)

  • Index Cond: (company_id = 55)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 1
2.          

SubPlan (for Index Scan)

3. 0.003 0.034 ↑ 1.0 1 1

Nested Loop (cost=4.45..19.60 rows=1 width=8) (actual time=0.031..0.034 rows=1 loops=1)

4. 0.007 0.013 ↑ 1.0 1 1

Bitmap Heap Scan on issues (cost=4.17..11.30 rows=1 width=8) (actual time=0.011..0.013 rows=1 loops=1)

  • Recheck Cond: ((issueable_type)::text = 'Product'::text)
  • Filter: ((status = 0) AND (issue_type = 1))
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=1
5. 0.006 0.006 ↓ 1.7 5 1

Bitmap Index Scan on index_issues_on_issueable_type_and_issueable_id (cost=0.00..4.17 rows=3 width=0) (actual time=0.006..0.006 rows=5 loops=1)

  • Index Cond: ((issueable_type)::text = 'Product'::text)
6. 0.018 0.018 ↑ 1.0 1 1

Index Only Scan using products_pkey on products products_1 (cost=0.28..8.29 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (id = issues.issueable_id)
  • Heap Fetches: 1
Planning time : 0.393 ms
Execution time : 0.208 ms