explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LC38

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 111.666 338,124.724 ↓ 662.5 8,613 1

Sort (cost=48,716.68..48,716.71 rows=13 width=513) (actual time=338,120.459..338,124.724 rows=8,613 loops=1)

  • Sort Key: o.oid
  • Sort Method: external merge Disk: 2224kB
2. 5,203.854 338,013.058 ↓ 662.5 8,613 1

Nested Loop (cost=296.75..48,716.44 rows=13 width=513) (actual time=2,045.762..338,013.058 rows=8,613 loops=1)

  • Join Filter: (r.id_jdd = m.id_jdd)
  • Rows Removed by Join Filter: 21936687
3. 2,804.820 329,151.654 ↓ 342.6 731,510 1

Nested Loop (cost=292.39..48,397.69 rows=2,135 width=513) (actual time=507.349..329,151.654 rows=731,510 loops=1)

4. 24,654.050 25,134.946 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations o (cost=291.97..14,582.51 rows=4,125 width=101) (actual time=491.183..25,134.946 rows=2,166,992 loops=1)

  • Recheck Cond: (groupes_fonctionnels && '{12}'::integer[])
  • Rows Removed by Index Recheck: 1704409
5. 480.896 480.896 ↓ 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=480.896..480.896 rows=2,166,992 loops=1)

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
6. 301,211.888 301,211.888 ↓ 0.0 0 2,166,992

Index Scan using vm_requeteur_releves_rid_idx on vm_requeteur_releves r (cost=0.43..8.19 rows=1 width=412) (actual time=0.139..0.139 rows=0 loops=2,166,992)

  • Index Cond: (rid = o.id_releve)
7. 3,657.468 3,657.550 ↓ 3.3 30 731,510

Materialize (cost=4.35..30.54 rows=9 width=4) (actual time=0.000..0.005 rows=30 loops=731,510)

8. 0.037 0.082 ↓ 3.3 30 1

Bitmap Heap Scan on vm_requeteur_metadonnees m (cost=4.35..30.50 rows=9 width=4) (actual time=0.057..0.082 rows=30 loops=1)

  • Recheck Cond: (id_ca = 451)
9. 0.045 0.045 ↓ 3.3 30 1

Bitmap Index Scan on vm_requeteur_metadonnees_id_ca_idx (cost=0.00..4.35 rows=9 width=0) (actual time=0.045..0.045 rows=30 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 338,132.538 ms