explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HeAw

Settings
# exclusive inclusive rows x rows loops node
1. 1,001.966 7,289.420 ↓ 0.0 0 1

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

  • Buffers: local hit=1431777 read=1263642
2. 1,275.090 1,275.090 ↓ 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.018..1,275.09 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=1222477 read=92580
3. 5,012.364 5,012.364 ↑ 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.012..5,012.364 rows=1,373,074 loops=1)

  • Heap Fetches: 1373074
  • Buffers: local hit=209300 read=1171062
Planning time : 11.07 ms
Execution time : 7,289.484 ms