explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pO5R

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

Aggregate (cost=671.05..671.06 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=663.50..671.03 rows=1 width=80) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on producers (cost=0.00..7.50 rows=1 width=48) (actual rows= loops=)

  • Filter: (a_ids = '6'::bigint)
4. 0.000 0.000 ↓ 0.0

Aggregate (cost=663.50..663.51 rows=1 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Limit (cost=5.27..663.03 rows=37 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.27..663.03 rows=37 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.99..438.52 rows=37 width=25) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on products1___producers (cost=4.71..106.01 rows=55 width=25) (actual rows= loops=)

  • Recheck Cond: (producers.a_id_ = producers)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on products1___producers_2_idx (cost=0.00..4.69 rows=55 width=0) (actual rows= loops=)

  • Index Cond: (producers.a_id_ = producers)
10. 0.000 0.000 ↓ 0.0

Index Scan using products_a_id__idx on products _1__be_0_mobilnisvet1_products (cost=0.28..6.05 rows=1 width=25) (actual rows= loops=)

  • Index Cond: (a_id_ = products1___producers.products)
  • Filter: (a_ids > '0'::bigint)
11. 0.000 0.000 ↓ 0.0

Index Scan using products_a_id__idx on products (cost=0.28..6.06 rows=1 width=57) (actual rows= loops=)

  • Index Cond: (products1___producers.products = a_id_)
12.          

SubPlan (for Index Scan)

13. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

14.          

SubPlan (for Nested Loop Left Join)

15. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

16.          

SubPlan (for Aggregate)

17. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)