explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fNcS

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 26.907 17,472.935 ↓ 168.9 2,871 1

Sort (cost=50,310.00..50,310.04 rows=17 width=501) (actual time=17,471.703..17,472.935 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 1,623.993 17,446.028 ↓ 168.9 2,871 1

Nested Loop (cost=1,848.67..50,309.65 rows=17 width=501) (actual time=364.809..17,446.028 rows=2,871 loops=1)

  • Join Filter: (i1_.id_jdd = i2_.id_jdd)
  • Rows Removed by Join Filter: 7312229
3. 2,280.045 14,359.015 ↓ 342.5 731,510 1

Nested Loop (cost=1,848.39..49,953.69 rows=2,136 width=501) (actual time=359.835..14,359.015 rows=731,510 loops=1)

4. 3,053.294 3,411.002 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations i0_ (cost=1,847.97..16,138.51 rows=4,125 width=101) (actual time=359.797..3,411.002 rows=2,166,992 loops=1)

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

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

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

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

  • Index Cond: (rid = i0_.id_releve)
7. 1,462.974 1,463.020 ↑ 1.0 10 731,510

Materialize (cost=0.28..35.58 rows=10 width=4) (actual time=0.000..0.002 rows=10 loops=731,510)

8. 0.046 0.046 ↑ 1.0 10 1

Index Scan using jdd_id_ca_idx on jdd i2_ (cost=0.28..35.53 rows=10 width=4) (actual time=0.022..0.046 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 17,473.855 ms