explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weha

Settings
# exclusive inclusive rows x rows loops node
1. 526.991 146,006.014 ↓ 1.1 180,252 1

HashAggregate (cost=5,304,479.07..5,306,499.84 rows=161,662 width=22) (actual time=145,805.891..146,006.014 rows=180,252 loops=1)

  • Group Key: quitd.dequipol_numero_quittance, quitd.dequipol_code_garantie
  • Buffers: shared hit=14,947 read=2,251,954, temp read=141,535 written=141,533
2. 8,503.841 145,479.023 ↓ 1.2 186,518 1

Hash Join (cost=3,683,785.53..5,302,862.45 rows=161,662 width=22) (actual time=123,615.527..145,479.023 rows=186,518 loops=1)

  • Buffers: shared hit=14,947 read=2,251,954, temp read=141,535 written=141,533
3. 13,578.020 13,578.020 ↓ 1.1 183,006 1

Seq Scan on commission_detail comm (cost=0..668,159.82 rows=161,662 width=20) (actual time=5.028..13,578.02 rows=183,006 loops=1)

  • Filter: (((comm.comdet_source)::text = 'AUXIA'::text) AND (comm.comdet_numero_agent = '237'::numeric))
  • Buffers: shared hit=14,506 read=382,868
4. 46,606.973 123,397.162 ↑ 1.1 45,250,607 1

Hash (cost=2,503,841.6..2,503,841.6 rows=48,485,653 width=27) (actual time=123,397.162..123,397.162 rows=45,250,607 loops=1)

  • Buffers: shared hit=441 read=1,869,086, temp written=141,053
5. 76,790.189 76,790.189 ↑ 1.1 45,250,607 1

Seq Scan on detail_quittance quitd (cost=0..2,503,841.6 rows=48,485,653 width=27) (actual time=2.937..76,790.189 rows=45,250,607 loops=1)

  • Filter: ((quitd.dequipol_source)::text = 'AUXIA'::text)
  • Buffers: shared hit=441 read=1,869,086
Planning time : 15.154 ms
Execution time : 146,105.496 ms