explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xq9g

Settings
# exclusive inclusive rows x rows loops node
1. 232.889 752.129 ↑ 3.1 1,776 1

Hash Join (cost=79..155,320.69 rows=5,554 width=32) (actual time=280.299..752.129 rows=1,776 loops=1)

  • Buffers: shared hit=50, local read=101069 written=88
2. 518.851 518.851 ↑ 3.1 1,373,074 1

Seq Scan on _sales_potential_earnings s (cost=0..143,961.75 rows=4,289,275 width=102) (actual time=166.936..518.851 rows=1,373,074 loops=1)

  • Buffers: local read=101069 written=88
3. 0.007 0.389 ↑ 1.0 3 1

Hash (cost=78.96..78.96 rows=3 width=16) (actual time=0.388..0.389 rows=3 loops=1)

  • Buffers: shared hit=50
4. 0.382 0.382 ↑ 1.0 3 1

Seq Scan on contract_family cf2 (cost=0..78.96 rows=3 width=16) (actual time=0.046..0.382 rows=3 loops=1)

  • Filter: (cf2.contract_type = ANY ('{GROWTH_STANDARD,GROWTH_AUTOPAY}'::enum.contract_type[]))
  • Buffers: shared hit=50
Planning time : 0.314 ms
Execution time : 752.298 ms