explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ARgO

Settings
# exclusive inclusive rows x rows loops node
1. 35.183 279,083.006 ↓ 168.9 2,871 1
→

Sort (cost=50,309.85..50,309.89 rows=17 width=513) (actual time=279,081.515..279,083.006 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 3,046.691 279,047.823 ↓ 168.9 2,871 1
→

Nested Loop (cost=1,848.67..50,309.50 rows=17 width=513) (actual time=2,687.141..279,047.823 rows=2,871 loops=1)

  • Join Filter: (i1_.id_jdd = i2_.id_jdd)
  • Rows Removed by Join Filter: 7,312,229
3. 4,291.546 273,806.602 ↓ 342.6 731,510 1
→

Nested Loop (cost=1,848.39..49,953.69 rows=2,135 width=513) (actual time=714.657..273,806.602 rows=731,510 loops=1)

4. 21,791.920 22,477.968 ↓ 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=689.233..22,477.968 rows=2,166,992 loops=1)

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

  • Index Cond: (groupes_fonctionnels && '{12}'::integer[])
6. 247,037.088 247,037.088 ↓ 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.114..0.114 rows=0 loops=2,166,992)

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

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

8. 0.034 0.034 ↑ 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.016..0.034 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 279,084.366 ms