explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wATG

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

Nested Loop (cost=1.72..66.06 rows=6 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.43..2.44 rows=1 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.01..1.79 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..1.10 rows=1 width=13) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using "index_etl.products_on_etl_batch_file_id" on products p_1 (cost=0.44..0.70 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (etl_batch_file_id = 509)
6. 0.000 0.000 ↓ 0.0

Index Scan using dim_products_identifier on dim_products p (cost=0.14..0.40 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((identifier)::text = (p_1.productsku)::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using idx_unique_tickets on dim_tickets d (cost=0.43..0.69 rows=1 width=13) (actual rows= loops=)

  • Index Cond: ((ticket_number)::text = (p_1.ticketno)::text)
8. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_ticket_xaction_ticket_id_transaction_id on fact_ticket_transactions t (cost=0.42..0.55 rows=2 width=8) (actual rows= loops=)

  • Index Cond: (ticket_id = d.ticket_id)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_fact_addons_product_addon_id on fact_addons (cost=0.29..34.21 rows=588 width=8) (actual rows= loops=)