explain.depesz.com

PostgreSQL's explain analyze made readable

Result: knRG

Settings
# exclusive inclusive rows x rows loops node
1. 1,194.214 11,231.179 ↓ 0.0 0 1

Merge Join (cost=1.1..578,171.94 rows=45,356 width=262) (actual time=11,231.179..11,231.179 rows=0 loops=1)

  • Buffers: local hit=1431749 read=1263670
2. 1,485.382 1,485.382 ↓ 1.2 1,371,323 1

Index Scan using ix_existing_earnings_sale_contract on _existing_earnings ee (cost=0.55..102,152.36 rows=1,179,003 width=154) (actual time=0.023..1,485.382 rows=1,371,323 loops=1)

  • Filter: ((ee.amount <> '0'::numeric) AND (ee.requested_quantity <> '0'::numeric) AND (ee.allowed_quantity <> '0'::numeric))
  • Buffers: local hit=1222479 read=92578
3. 8,551.583 8,551.583 ↑ 1.0 1,373,074 1

Index Only Scan using ix_sales_potential_earnings_sale_contract on _sales_potential_earnings s (cost=0.55..456,413.04 rows=1,373,074 width=51) (actual time=0.054..8,551.583 rows=1,373,074 loops=1)

  • Heap Fetches: 1373074
  • Buffers: local hit=209270 read=1171092
Planning time : 11.746 ms
Execution time : 11,231.246 ms