explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4iTe

Settings
# exclusive inclusive rows x rows loops node
1. 0.409 74.475 ↑ 1.0 1 1

Aggregate (cost=1,193.84..1,193.85 rows=1 width=8) (actual time=74.474..74.475 rows=1 loops=1)

2. 0.000 74.066 ↓ 221.3 5,976 1

Nested Loop (cost=7.40..1,193.77 rows=27 width=0) (actual time=4.851..74.066 rows=5,976 loops=1)

3. 1.353 23.507 ↓ 59.4 17,346 1

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

4. 0.053 0.053 ↓ 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.047..0.053 rows=3 loops=1)

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

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

  • Recheck Cond: (vocabulary_id = (v.id)::numeric)
  • Heap Blocks: exact=6,470
6. 4.200 4.200 ↓ 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.400..1.400 rows=5,782 loops=3)

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

Index Scan using idx_606683_primary on product p (cost=0.42..0.69 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=17,346)

  • Index Cond: (id = tv.product_id)
  • Filter: (customer_id = '108'::numeric)
  • Rows Removed by Filter: 1
Planning time : 1.531 ms
Execution time : 74.577 ms