explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y64n

Settings
# exclusive inclusive rows x rows loops node
1. 472.389 10,634.602 ↓ 114.8 2,871 1

Merge Join (cost=103,143.67..103,287.61 rows=25 width=272) (actual time=9,559.866..10,634.602 rows=2,871 loops=1)

  • Merge Cond: (r.rid = o.id_releve)
2.          

CTE j

3. 0.065 0.065 ↑ 1.0 10 1

Index Scan using jdd_id_ca_idx on jdd j (cost=0.28..35.63 rows=10 width=4) (actual time=0.026..0.065 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
4.          

CTE r

5. 1.508 18.285 ↑ 8.3 2,960 1

Nested Loop (cost=47.50..84,306.89 rows=24,613 width=412) (actual time=0.102..18.285 rows=2,960 loops=1)

6. 0.077 0.077 ↑ 1.0 10 1

CTE Scan on j j_1 (cost=0.00..0.20 rows=10 width=4) (actual time=0.028..0.077 rows=10 loops=1)

7. 16.140 16.700 ↑ 8.3 296 10

Bitmap Heap Scan on vm_requeteur_releves r_1 (cost=47.50..8,406.06 rows=2,461 width=412) (actual time=0.096..1.670 rows=296 loops=10)

  • Recheck Cond: (id_jdd = j_1.id_jdd)
8. 0.560 0.560 ↑ 8.3 296 10

Bitmap Index Scan on vm_requeteur_releves_id_jdd_idx (cost=0.00..46.88 rows=2,461 width=0) (actual time=0.056..0.056 rows=296 loops=10)

  • Index Cond: (id_jdd = j_1.id_jdd)
9. 2.500 23.731 ↑ 8.3 2,960 1

Sort (cost=3,970.93..4,032.46 rows=24,613 width=136) (actual time=22.920..23.731 rows=2,960 loops=1)

  • Sort Key: r.rid
  • Sort Method: quicksort Memory: 729kB
10. 21.231 21.231 ↑ 8.3 2,960 1

CTE Scan on r (cost=0.00..492.26 rows=24,613 width=136) (actual time=0.106..21.231 rows=2,960 loops=1)

11. 6,770.020 10,138.482 ↓ 525.1 2,165,974 1

Sort (cost=14,830.22..14,840.53 rows=4,125 width=136) (actual time=9,418.499..10,138.482 rows=2,165,974 loops=1)

  • Sort Key: o.id_releve
  • Sort Method: external sort Disk: 302888kB
12. 2,723.142 3,368.462 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations o (cost=291.97..14,582.51 rows=4,125 width=136) (actual time=648.550..3,368.462 rows=2,166,992 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Index Recheck: 1704409
13. 645.320 645.320 ↓ 525.3 2,166,992 1

Bitmap Index Scan on vm_requeteur_observations_groupes_fonctionnels_idx (cost=0.00..290.93 rows=4,125 width=0) (actual time=645.320..645.320 rows=2,166,992 loops=1)

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
Total runtime : 10,699.055 ms