explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JSyA

Settings
# exclusive inclusive rows x rows loops node
1. 7,949.496 31,489.809 ↓ 2.1 1,479,356 1

GroupAggregate (cost=1,000,711.53..1,102,339.7 rows=689,004 width=264) (actual time=20,499.38..31,489.809 rows=1,479,356 loops=1)

  • Group Key: se.contract_family_id, se.sale_number, s.client_id, se.claimant_company_id, se.currency_conversion_ind
  • Buffers: shared hit=17 read=181797, local read=7 written=7, temp read=97623 written=97667
2. 12,899.892 23,540.313 ↑ 1.2 2,842,114 1

Sort (cost=1,000,711.53..1,009,324.09 rows=3,445,023 width=91) (actual time=20,499.261..23,540.313 rows=2,842,114 loops=1)

  • Sort Key: se.contract_family_id, se.sale_number, s.client_id, se.claimant_company_id, se.currency_conversion_ind
  • Sort Method: external merge Disk: 287344kB
  • Buffers: shared hit=17 read=181797, local read=7 written=7, temp read=97623 written=97667
3. 937.924 10,640.421 ↑ 1.2 2,842,114 1

Hash Join (cost=43,456.48..399,557.02 rows=3,445,023 width=91) (actual time=4,002.915..10,640.421 rows=2,842,114 loops=1)

  • Buffers: shared hit=6 read=181797, local read=7 written=7, temp read=43572 written=43558
4. 3,248.463 9,701.816 ↑ 1.0 3,321,081 1

Hash Join (cost=43,420.59..352,152.06 rows=3,445,023 width=91) (actual time=4,002.222..9,701.816 rows=3,321,081 loops=1)

  • Buffers: shared hit=6 read=181797, temp read=43572 written=43558
5. 2,451.467 2,451.467 ↑ 1.0 3,321,081 1

Seq Scan on sale_earning se (cost=0..193,858.23 rows=3,445,023 width=91) (actual time=0.138..2,451.467 rows=3,321,081 loops=1)

  • Buffers: shared hit=2 read=159406
6. 358.090 4,001.886 ↓ 1.0 716,770 1

Hash (cost=29,561.93..29,561.93 rows=716,693 width=32) (actual time=4,001.886..4,001.886 rows=716,770 loops=1)

  • Buffers: shared hit=4 read=22391, temp written=3975
7. 3,643.796 3,643.796 ↓ 1.0 716,770 1

Seq Scan on sale s (cost=0..29,561.93 rows=716,693 width=32) (actual time=0.004..3,643.796 rows=716,770 loops=1)

  • Buffers: shared hit=4 read=22391
8. 0.174 0.681 ↑ 1.0 1,284 1

Hash (cost=19.84..19.84 rows=1,284 width=16) (actual time=0.681..0.681 rows=1,284 loops=1)

  • Buffers: local read=7 written=7
9. 0.507 0.507 ↑ 1.0 1,284 1

Seq Scan on _contract_family xcf (cost=0..19.84 rows=1,284 width=16) (actual time=0.242..0.507 rows=1,284 loops=1)

  • Buffers: local read=7 written=7
Planning time : 67.792 ms
Execution time : 31,659.445 ms