explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BwxE

Settings
# exclusive inclusive rows x rows loops node
1. 127.714 271.837 ↑ 5,856.9 40 1

Hash Join (cost=6,075.67..848,874.62 rows=234,276 width=182) (actual time=159.977..271.837 rows=40 loops=1)

  • Buffers: local read=11912, temp read=1223 written=1221
2. 56.148 56.148 ↑ 3.2 108,488 1

Seq Scan on t_sales_potential_earnings s (cost=0..11,125.73 rows=344,773 width=149) (actual time=11.153..56.148 rows=108,488 loops=1)

  • Buffers: local read=7678
3. 37.077 64.216 ↑ 1.0 109,079 1

Hash (cost=3,207.79..3,207.79 rows=109,079 width=44) (actual time=64.216..64.216 rows=109,079 loops=1)

  • Buffers: local read=2117, temp written=426
4. 27.139 27.139 ↑ 1.0 109,079 1

Seq Scan on t_existing_earnings ee (cost=0..3,207.79 rows=109,079 width=44) (actual time=0.028..27.139 rows=109,079 loops=1)

  • Buffers: local read=2117
5.          

SubPlan (for Hash Join)

6. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using ix_existing_earnings_sale_contract on t_existing_earnings x (cost=0.42..3.44 rows=1 width=0) (never executed)

  • Index Cond: ((x.sale_number = s.sale_number) AND (x.contract_family_id = s.contract_family_id))
7. 23.759 23.759 ↑ 1.0 109,079 1

Seq Scan on t_existing_earnings x_1 (cost=0..3,207.79 rows=109,079 width=28) (actual time=0.016..23.759 rows=109,079 loops=1)

  • Buffers: local read=2117
Planning time : 10.823 ms
Execution time : 272.026 ms