explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tBlV

Settings
# exclusive inclusive rows x rows loops node
1. 1,156.424 10,268.800 ↓ 0.0 0 1

Merge Join (cost=1.1..588,158.42 rows=1,275,116 width=259) (actual time=10,268.8..10,268.8 rows=0 loops=1)

  • Buffers: local hit=233103 read=1190094 written=1022
2. 1,013.198 1,013.198 ↑ 1.1 1,371,323 1

Index Scan using ix_existing_earnings_sale_contract on _existing_earnings ee (cost=0.55..97,766.56 rows=1,457,276 width=258) (actual time=0.443..1,013.198 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 read=42835 written=69
3. 8,099.178 8,099.178 ↑ 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=1.163..8,099.178 rows=1,373,074 loops=1)

  • Heap Fetches: 1373074
  • Buffers: local hit=233103 read=1147259 written=953
Planning time : 4.925 ms
Execution time : 10,268.885 ms