explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcO9

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

Nested Loop Left Join (cost=2,268.52..4,975.33 rows=259 width=1,421) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,268.23..3,005.90 rows=259 width=757) (actual rows= loops=)

  • Hash Cond: (trc.id = applied_taxrate.taxrateconfig_id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on "TaxRateConfig" trc (cost=0.00..526.74 rows=15,274 width=687) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=2,264.99..2,264.99 rows=259 width=70) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.16..2,264.99 rows=259 width=70) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using menuitemselection_appliedtaxrate__menuitemselection_id on "MenuItemSelection_AppliedTaxRate" as_atr (cost=0.58..38.89 rows=259 width=16) (actual rows= loops=)

  • Index Cond: (menuitemselection_id = ANY ('{1,2,3}'::bigint[]))
7. 0.000 0.000 ↓ 0.0

Index Scan using "AppliedTaxRate_pkey" on "AppliedTaxRate" applied_taxrate (cost=0.58..8.60 rows=1 width=54) (actual rows= loops=)

  • Index Cond: (id = as_atr.appliedtaxes_id)
8. 0.000 0.000 ↓ 0.0

Index Scan using "TaxRate_pkey" on "TaxRate" tr (cost=0.29..7.60 rows=1 width=664) (actual rows= loops=)

  • Index Cond: (applied_taxrate.taxrate_id = id)