explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vasd

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

Nested Loop (cost=538.84..916.12 rows=1 width=8,009) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=538.55..907.98 rows=1 width=6,874) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=538.13..872.08 rows=3 width=3,716) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on public.prices (cost=537.71..846.78 rows=3 width=2,132) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=537.71..537.71 rows=80 width=0) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on prices_channel (cost=0.00..184.49 rows=8,008 width=0) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

BitmapOr (cost=352.98..352.98 rows=16,015 width=0) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on prices_distributor_id_end (cost=0.00..176.49 rows=8,008 width=0) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on prices_distributor_id_end (cost=0.00..176.49 rows=8,008 width=0) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using br_sku_tax_config_pkey on public.br_sku_tax_config ""taxConfig"" (cost=0.42..8.44 rows=1 width=1,584) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using skus_sku_unique on public.skus ""SKU"" (cost=0.42..11.68 rows=1 width=3,158) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using products_pkey on public.products product (cost=0.29..8.15 rows=1 width=1,135) (actual rows= loops=)