explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FZRj

Settings
# exclusive inclusive rows x rows loops node
1. 595.283 29,302.936 ↓ 5.6 1,943,188 1

Unique (cost=933,318.39..959,156.06 rows=344,502 width=86) (actual time=25,375.316..29,302.936 rows=1,943,188 loops=1)

  • Output: xee.sale_number, xee.contract_family_id, xee.contract_item_id, xee.sale_id, xee.created, (lower(s.active_range))
  • Buffers: shared hit=15 read=181797, temp read=103134 written=103188
  • I/O Timings: read=5999.305
2. 17,051.840 28,707.653 ↑ 1.0 3,321,081 1

Sort (cost=933,318.39..941,930.94 rows=3,445,023 width=86) (actual time=25,375.314..28,707.653 rows=3,321,081 loops=1)

  • Output: xee.sale_number, xee.contract_family_id, xee.contract_item_id, xee.sale_id, xee.created, (lower(s.active_range))
  • Sort Key: xee.sale_number, xee.contract_family_id, xee.created DESC, (lower(s.active_range)) DESC
  • Sort Method: external merge Disk: 321536kB
  • Buffers: shared hit=15 read=181797, temp read=103134 written=103188
  • I/O Timings: read=5999.305
3. 3,752.049 11,655.813 ↑ 1.0 3,321,081 1

Hash Join (cost=43,420.35..347,306.37 rows=3,445,023 width=86) (actual time=1,409.198..11,655.813 rows=3,321,081 loops=1)

  • Output: xee.sale_number, xee.contract_family_id, xee.contract_item_id, xee.sale_id, xee.created, lower(s.active_range)
  • Inner Unique: true
  • Hash Cond: (xee.sale_id = s.sale_id)
  • Buffers: shared hit=6 read=181797, temp read=39278 written=39264
  • I/O Timings: read=5999.305
4. 6,495.028 6,495.028 ↑ 1.0 3,321,081 1

Seq Scan on client_lactalis.sale_earning xee (cost=0.00..193,858.23 rows=3,445,023 width=78) (actual time=0.240..6,495.028 rows=3,321,081 loops=1)

  • Output: xee.sale_number, xee.contract_family_id, xee.contract_item_id, xee.sale_id, xee.created
  • Buffers: shared hit=2 read=159406
  • I/O Timings: read=5328.775
5. 388.280 1,408.736 ↓ 1.0 716,770 1

Hash (cost=29,561.82..29,561.82 rows=716,682 width=30) (actual time=1,408.736..1,408.736 rows=716,770 loops=1)

  • Output: s.active_range, s.sale_id
  • Buckets: 131072 Batches: 8 Memory Usage: 6498kB
  • Buffers: shared hit=4 read=22391, temp written=3829
  • I/O Timings: read=670.530
6. 1,020.456 1,020.456 ↓ 1.0 716,770 1

Seq Scan on client_lactalis.sale s (cost=0.00..29,561.82 rows=716,682 width=30) (actual time=0.005..1,020.456 rows=716,770 loops=1)

  • Output: s.active_range, s.sale_id
  • Buffers: shared hit=4 read=22391
  • I/O Timings: read=670.530
Planning time : 12.027 ms
Execution time : 29,595.020 ms