explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oc5Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.570 68.057 ↑ 1.0 1 1

Aggregate (cost=1,123.75..1,123.76 rows=1 width=8) (actual time=68.057..68.057 rows=1 loops=1)

2. 9.622 67.487 ↓ 213.4 5,976 1

Nested Loop (cost=7.40..1,123.68 rows=28 width=0) (actual time=8.833..67.487 rows=5,976 loops=1)

3. 2.462 23.173 ↓ 59.4 17,346 1

Nested Loop (cost=6.98..992.27 rows=292 width=16) (actual time=8.794..23.173 rows=17,346 loops=1)

4. 0.032 0.032 ↓ 3.0 3 1

Index Scan using idx_607035_vocabulary2_name_idx on vocabulary2 v (cost=0.29..8.31 rows=1 width=8) (actual time=0.030..0.032 rows=3 loops=1)

  • Index Cond: ((name)::text = 'dress'::text)
5. 14.934 20.679 ↓ 19.8 5,782 3

Bitmap Heap Scan on products_producttagsvocabulary tv (cost=6.69..981.04 rows=292 width=21) (actual time=2.923..6.893 rows=5,782 loops=3)

  • Recheck Cond: (vocabulary_id = (v.id)::numeric)
  • Heap Blocks: exact=6,470
6. 5.745 5.745 ↓ 19.8 5,782 3

Bitmap Index Scan on idx_606797_products_producttagsvocabulary_vocabulary_id_b97e596 (cost=0.00..6.62 rows=292 width=0) (actual time=1.915..1.915 rows=5,782 loops=3)

  • Index Cond: (vocabulary_id = (v.id)::numeric)
7. 34.692 34.692 ↓ 0.0 0 17,346

Index Only Scan using product_id_customer_id_idx on product p (cost=0.42..0.45 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=17,346)

  • Index Cond: ((id = tv.product_id) AND (customer_id = '108'::numeric))
  • Heap Fetches: 0
Planning time : 1.342 ms
Execution time : 68.143 ms