explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dzi

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,605.463 84,105.005 ↓ 342.5 731,510 1

Nested Loop (cost=292.39..48,397.69 rows=2,136 width=8) (actual time=568.605..84,105.005 rows=731,510 loops=1)

2. 19,114.411 19,656.774 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations o (cost=291.97..14,582.51 rows=4,125 width=8) (actual time=554.146..19,656.774 rows=2,166,992 loops=1)

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
4. 62,842.768 62,842.768 ↓ 0.0 0 2,166,992

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

  • Index Cond: (rid = o.id_releve)
  • Heap Fetches: 731510
Total runtime : 84,275.618 ms