explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1ex

Settings
# exclusive inclusive rows x rows loops node
1. 34.638 13,218.901 ↑ 3.8 1,751 1

Nested Loop (cost=331.72..592,752.97 rows=6,659 width=206) (actual time=0.308..13,218.901 rows=1,751 loops=1)

  • Buffers: shared hit=1, local hit=1438441 read=1263998
2. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on client_settings cs (cost=0..1.01 rows=1 width=16) (actual time=0.009..0.011 rows=1 loops=1)

  • Buffers: shared hit=1
3. 1,597.432 13,171.995 ↑ 3.8 1,751 1

Merge Join (cost=331.72..568,879.44 rows=6,659 width=156) (actual time=0.229..13,171.995 rows=1,751 loops=1)

  • Buffers: local hit=1431600 read=1263818
4. 9,795.790 9,795.790 ↑ 1.0 1,373,074 1

Index Scan using ix_sales_potential_earnings_sale_contract on _sales_potential_earnings s (cost=0.55..456,413.04 rows=1,373,074 width=156) (actual time=0.008..9,795.79 rows=1,373,074 loops=1)

  • Buffers: local hit=209129 read=1171233
5. 1,778.773 1,778.773 ↑ 1.0 1,479,355 1

Index Only Scan using ix_existing_earnings_sale_contract on _existing_earnings ee (cost=0.55..91,057.19 rows=1,479,356 width=51) (actual time=0.059..1,778.773 rows=1,479,355 loops=1)

  • Heap Fetches: 1479355
  • Buffers: local hit=1222471 read=92585
6.          

SubPlan (for Nested Loop)

7. 12.257 12.257 ↓ 0.0 0 1,751

Index Only Scan using ix_existing_earnings_sale_contract on _existing_earnings x (cost=0.55..3.57 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1,751)

  • Index Cond: ((x.sale_number = s.sale_number) AND (x.contract_family_id = s.contract_family_id))
  • Buffers: local hit=6841 read=180
Planning time : 19.218 ms
Execution time : 13,219.493 ms