explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dgTx : Optimization for: plan #SLSR

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 25.973 64,020.170 ↓ 168.9 2,871 1

Sort (cost=48,753.95..48,753.99 rows=17 width=513) (actual time=64,019.358..64,020.170 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 2,945.683 63,994.197 ↓ 168.9 2,871 1

Nested Loop (cost=292.67..48,753.60 rows=17 width=513) (actual time=1,055.094..63,994.197 rows=2,871 loops=1)

  • Join Filter: (i1_.id_jdd = i2_.id_jdd)
  • Rows Removed by Join Filter: 7312229
3. 3,691.463 58,853.984 ↓ 342.6 731,510 1

Nested Loop (cost=292.39..48,397.69 rows=2,135 width=513) (actual time=814.462..58,853.984 rows=731,510 loops=1)

4. 17,521.040 18,323.657 ↓ 525.3 2,166,992 1

Bitmap Heap Scan on vm_requeteur_observations i0_ (cost=291.97..14,582.51 rows=4,125 width=101) (actual time=804.519..18,323.657 rows=2,166,992 loops=1)

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
6. 36,838.864 36,838.864 ↓ 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=412) (actual time=0.017..0.017 rows=0 loops=2,166,992)

  • Index Cond: (rid = i0_.id_releve)
7. 2,194.505 2,194.530 ↑ 1.0 10 731,510

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

8. 0.025 0.025 ↑ 1.0 10 1

Index Scan using jdd_id_ca_idx on jdd i2_ (cost=0.28..35.63 rows=10 width=4) (actual time=0.014..0.025 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 64,022.646 ms