explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8GJR

Settings
# exclusive inclusive rows x rows loops node
1. 4.518 105.630 ↓ 32.3 2,033 1

Hash Join (cost=1,665.85..51,237.81 rows=63 width=11) (actual time=3.740..105.630 rows=2,033 loops=1)

  • Hash Cond: (i0_.cd_nom = i2_.cd_ref)
2. 9.163 99.184 ↓ 1.2 4,851 1

Nested Loop (cost=80.56..49,449.33 rows=4,155 width=15) (actual time=1.771..99.184 rows=4,851 loops=1)

3. 26.128 27.276 ↓ 1.0 4,183 1

Bitmap Heap Scan on releves i1_ (cost=80.13..15,223.93 rows=4,090 width=11) (actual time=1.754..27.276 rows=4,183 loops=1)

  • Recheck Cond: ((commune)::text = '33056'::text)
4. 1.148 1.148 ↓ 1.0 4,183 1

Bitmap Index Scan on releves_commune_idx (cost=0.00..79.11 rows=4,090 width=0) (actual time=1.148..1.148 rows=4,183 loops=1)

  • Index Cond: ((commune)::text = '33056'::text)
5. 62.745 62.745 ↑ 1.0 1 4,183

Index Scan using observations_interne_id_releve_idx on observations_interne i0_ (cost=0.43..8.36 rows=1 width=12) (actual time=0.013..0.015 rows=1 loops=4,183)

  • Index Cond: (id_releve = i1_.rid)
  • Filter: (the_geom IS NOT NULL)
6. 0.673 1.928 ↓ 1.1 1,467 1

Hash (cost=1,568.50..1,568.50 rows=1,343 width=4) (actual time=1.928..1.928 rows=1,467 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 52kB
7. 1.041 1.255 ↓ 1.1 1,467 1

Bitmap Heap Scan on vm_requeteur_groupes i2_ (cost=26.83..1,568.50 rows=1,343 width=4) (actual time=0.237..1.255 rows=1,467 loops=1)

  • Recheck Cond: (gid = 12)
8. 0.214 0.214 ↓ 1.1 1,467 1

Bitmap Index Scan on vm_requeteur_groupes_gid_idx (cost=0.00..26.49 rows=1,343 width=0) (actual time=0.214..0.214 rows=1,467 loops=1)

  • Index Cond: (gid = 12)
Total runtime : 106.249 ms