explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 54R1

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 11,480.492 ↓ 0.0 0 1

Nested Loop (cost=906,199.94..1,051,505.28 rows=20,775 width=262) (actual time=11,480.491..11,480.492 rows=0 loops=1)

  • Buffers: shared hit=1, local hit=1,268,814 read=327,467, temp read=21,855 written=21,875
2. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on client_settings cs (cost=0..1.01 rows=1 width=16) (actual time=0.006..0.008 rows=1 loops=1)

  • Buffers: shared hit=1
3. 845.934 11,480.481 ↓ 0.0 0 1

Merge Join (cost=906,199.94..1,051,088.77 rows=20,775 width=138) (actual time=11,480.481..11,480.481 rows=0 loops=1)

  • Buffers: local hit=1,268,814 read=327,467, temp read=21,855 written=21,875
4. 1,013.640 1,013.640 ↓ 1.2 1,371,323 1

Index Scan using ix__existing_earnings_sale_contract on _existing_earnings ee (cost=0.55..97,817.93 rows=1,173,797 width=138) (actual time=0.017..1,013.64 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=1,268,814 read=45,968
5. 6,929.156 9,620.907 ↑ 2.8 1,373,074 1

Sort (cost=906,199.39..915,764.06 rows=3,825,869 width=51) (actual time=9,444.873..9,620.907 rows=1,373,074 loops=1)

  • Sort Key: s.sale_number, s.contract_family_id, s.claimant_company_id
  • Sort Method: external sort Disk: 87,456kB
  • Buffers: local read=281,499, temp read=21,855 written=21,875
6. 2,691.751 2,691.751 ↑ 2.8 1,373,074 1

Seq Scan on _sales_potential_earnings s (cost=0..319,757.69 rows=3,825,869 width=51) (actual time=331.098..2,691.751 rows=1,373,074 loops=1)

  • Buffers: local read=281,499
Planning time : 8.906 ms
Execution time : 11,495.369 ms