explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TD9m

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

Hash Left Join (cost=3,616.53..1,746,233.44 rows=496,203 width=2,166) (actual rows= loops=)

  • Hash Cond: (li.adjuster_id = usr.id)
2.          

Initplan (forHash Left Join)

3. 0.000 0.000 ↓ 0.0

Seq Scan on bp_accounts (cost=0.00..10.75 rows=1 width=16) (actual rows= loops=)

  • Filter: ((subdomain)::text = 'johndeere'::text)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,212.24..141,804.56 rows=496,203 width=1,942) (actual rows= loops=)

  • Hash Cond: (li.invoice_id = inv.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on invoice_line_items li (cost=0.00..132,753.50 rows=500,477 width=1,926) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (client_account_id = $0))
6. 0.000 0.000 ↓ 0.0

Hash (cost=1,945.20..1,945.20 rows=21,363 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on invoices inv (cost=0.00..1,945.20 rows=21,363 width=32) (actual rows= loops=)

  • Filter: ((state)::text <> ALL ('{failed,draft,sending,submitting}'::text[]))
8. 0.000 0.000 ↓ 0.0

Hash (cost=1,221.03..1,221.03 rows=13,801 width=43) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Foreign Scan on users usr (cost=100.00..1,221.03 rows=13,801 width=43) (actual rows= loops=)