explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dG6J

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

Limit (cost=1.27..195.39 rows=500 width=88) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1.27..2,933,205.28 rows=7,555,084 width=88) (actual rows= loops=)

  • Merge Cond: ((so."customerCPF")::text = (usr.cpf)::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.83..2,164,496.68 rows=3,443,443 width=84) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using store_orders_customer_c_p_f on store_orders so (cost=0.56..1,131,259.78 rows=3,443,443 width=52) (actual rows= loops=)

  • Filter: (("crmSyncedAt" IS NULL) AND ((site)::text = 'artex'::text))
5. 0.000 0.000 ↓ 0.0

Index Scan using distributors_pkey on distributors dis (cost=0.27..0.29 rows=1 width=36) (actual rows= loops=)

  • Index Cond: ((so."distributorId")::text = (id)::text)
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..669,180.96 rows=4,897,414 width=28) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using users_cpf_site_uk on users usr (cost=0.43..656,937.42 rows=4,897,414 width=28) (actual rows= loops=)