explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BeSm

Settings
# exclusive inclusive rows x rows loops node
1. 303,058.966 306,863.905 ↓ 1.1 80,134 1

Hash Left Join (cost=1,313.27..149,916.73 rows=75,243 width=2,196) (actual time=76.839..306,863.905 rows=80,134 loops=1)

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

Initplan (forHash Left Join)

3. 0.008 0.008 ↑ 1.0 1 1

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

  • Filter: ((subdomain)::text = 'experian'::text)
4. 224.548 3,740.954 ↓ 1.1 80,134 1

Hash Join (cost=1,144.19..25,932.14 rows=75,243 width=1,972) (actual time=11.455..3,740.954 rows=80,134 loops=1)

  • Hash Cond: (li.invoice_id = inv.id)
5. 3,505.010 3,505.010 ↓ 1.0 81,483 1

Seq Scan on invoice_line_items li (cost=0.00..23,729.97 rows=81,479 width=1,956) (actual time=0.023..3,505.010 rows=81,483 loops=1)

  • Filter: ((deleted_at IS NULL) AND (client_account_id = $0))
  • Rows Removed by Filter: 8915
6. 2.119 11.396 ↑ 1.0 9,435 1

Hash (cost=1,026.26..1,026.26 rows=9,435 width=32) (actual time=11.396..11.396 rows=9,435 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 718kB
7. 9.277 9.277 ↑ 1.0 9,435 1

Seq Scan on invoices inv (cost=0.00..1,026.26 rows=9,435 width=32) (actual time=0.017..9.277 rows=9,435 loops=1)

  • Filter: ((state)::text <> ALL ('{failed,draft,sending,submitting}'::text[]))
  • Rows Removed by Filter: 782
8. 3.042 63.977 ↓ 12.1 13,801 1

Hash (cost=144.11..144.11 rows=1,137 width=48) (actual time=63.977..63.977 rows=13,801 loops=1)

  • Buckets: 16384 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1141kB
9. 60.935 60.935 ↓ 12.1 13,801 1

Foreign Scan on users usr (cost=100.00..144.11 rows=1,137 width=48) (actual time=1.006..60.935 rows=13,801 loops=1)