explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LNe6

Settings
# exclusive inclusive rows x rows loops node
1. 18.499 552,564.430 ↑ 1.0 1 1

Aggregate (cost=71,072,329.76..71,072,329.77 rows=1 width=8) (actual time=552,564.430..552,564.430 rows=1 loops=1)

  • Buffers: shared hit=430295995 read=10324
2. 693.847 552,545.931 ↓ 4.6 25,296 1

Seq Scan on fe_mvt_compte_courant (cost=0.00..71,072,315.94 rows=5,530 width=0) (actual time=6.908..552,545.931 rows=25,296 loops=1)

  • Filter: (mvtcc_id = (SubPlan 3))
  • Rows Removed by Filter: 1080620
  • Buffers: shared hit=430295995 read=10324
3.          

SubPlan (forSeq Scan)

4. 116,572.508 551,852.084 ↑ 1.0 1 1,105,916

Aggregate (cost=64.22..64.23 rows=1 width=4) (actual time=0.499..0.499 rows=1 loops=1,105,916)

  • Buffers: shared hit=430273664 read=10310
  • -> Index Scan using idx_fe_mvt_compte_courant_objf_id_cptc_id_dte_valeur on fe_mvt_compte_courant a (cost=0.43..64.22 rows=1 width=4) (actual time=0.195..0.498 rows=1 loops=11059
  • Index Cond: ((objf_id = fe_mvt_compte_courant.objf_id) AND (cptc_id = fe_mvt_compte_courant.cptc_id))
  • Filter: (dte_valeur = (SubPlan 2))
  • Rows Removed by Filter: 98
  • Buffers: shared hit=430273664 read=10310
5.          

SubPlan (forAggregate)

6. 108,819.894 435,279.576 ↑ 1.0 1 108,819,894

Result (cost=2.45..2.46 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=108,819,894)

  • Buffers: shared hit=326459298 read=385
7.          

Initplan (forResult)

8. 326,459.682 326,459.682 ↑ 1.0 1 108,819,894

Limit (cost=0.43..2.45 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=108,819,894)

  • Buffers: shared hit=326459298 read=385
  • -> Index Only Scan Backward using idx_fe_mvt_compte_courant_objf_id_cptc_id_dte_valeur on fe_mvt_compte_courant b (cost=0.43..4.48 rows=2 width=4) (actual t
  • Index Cond: ((objf_id = a.objf_id) AND (cptc_id = a.cptc_id) AND (dte_valeur IS NOT NULL) AND (dte_valeur <= '2009-01-01'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=326459298 read=385
Planning time : 0.428 ms
Execution time : 552,565.798 ms