explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jjH

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=)

  • Output: fact_addons.addon_id, t.transaction_id
2. 0.000 0.000 ↓ 0.0

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

  • Output: p.product_id, t.transaction_id
3. 0.000 0.000 ↓ 0.0

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

  • Output: p.product_id, d.ticket_id
  • Inner Unique: true
4. 0.000 0.000 ↓ 0.0

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

  • Output: p.product_id, p_1.ticketno
  • Inner Unique: true
5. 0.000 0.000 ↓ 0.0

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

  • Output: p_1.id, p_1.sale_id, p_1.ticketno, p_1.transaction_date, p_1.item_quantity, p_1.item_single_value, p_1.productsku, p_1.family_name, p_1.type_description, p_1.product_description, p_1.product_serial, p_1.from_date, p_1.to_date, p_1.etl_batch_file_id, p_1.imported, p_1.created_at, p_1.updated_at, p_1.customer_id
  • Index Cond: (p_1.etl_batch_file_id = 509)
6. 0.000 0.000 ↓ 0.0

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

  • Output: p.product_id, p.identifier, p.description, p.type_description, p.brand_id, p.family_name, p.valid_from_date, p.valid_to_date, p.valid_from_date_id, p.valid_to_date_id, p.created_date, p.updated_date
  • Index Cond: ((p.identifier)::text = (p_1.productsku)::text)
7. 0.000 0.000 ↓ 0.0

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

  • Output: d.ticket_id, d.sale_id, d.ticket_number, d.sale_date, d.sale_date_id
  • Index Cond: ((d.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 scv.fact_ticket_transactions t (cost=0.42..0.55 rows=2 width=8) (actual rows= loops=)

  • Output: t.ticket_id, t.transaction_id
  • Index Cond: (t.ticket_id = d.ticket_id)
9. 0.000 0.000 ↓ 0.0

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

  • Output: fact_addons.product_id, fact_addons.addon_id" Index Cond: (fact_addons.product_id = p.product_id)