explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3H2w

Settings
# exclusive inclusive rows x rows loops node
1. 46.675 207,672.175 ↓ 124.8 2,871 1

Sort (cost=50,407.22..50,407.28 rows=23 width=505) (actual time=207,670.437..207,672.175 rows=2,871 loops=1)

  • Sort Key: i0_.oid
  • Sort Method: external merge Disk: 744kB
2. 3,426.362 207,625.500 ↓ 124.8 2,871 1

Nested Loop (cost=1,848.67..50,406.70 rows=23 width=505) (actual time=567.496..207,625.500 rows=2,871 loops=1)

  • Join Filter: (i1_.id_jdd = i2_.id_jdd)
  • Rows Removed by Join Filter: 7312229
3. 4,678.692 202,004.608 ↓ 262.8 731,510 1

Nested Loop (cost=1,848.40..49,953.70 rows=2,783 width=505) (actual time=457.168..202,004.608 rows=731,510 loops=1)

4. 43,014.521 43,469.484 ↓ 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=457.128..43,469.484 rows=2,166,992 loops=1)

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

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

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

  • Index Cond: (rid = i0_.id_releve)
7. 2,194.500 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.030 0.030 ↑ 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.019..0.030 rows=10 loops=1)

  • Index Cond: (id_ca = 451)
Total runtime : 207,673.932 ms