explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T0ag

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on temp_1978 (cost=1,665.85..51,237.81 rows=63 width=11) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,665.85..51,237.81 rows=63 width=11) (actual rows= loops=)

  • Hash Cond: (i0_.cd_nom = i2_.cd_ref)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=80.56..49,449.33 rows=4,155 width=15) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: ((commune)::text = '33056'::text)
5. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((commune)::text = '33056'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using observations_interne_id_releve_idx on observations_interne i0_ (cost=0.43..8.36 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id_releve = i1_.rid)
  • Filter: (the_geom IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

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

8. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: (gid = 12)
9. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (gid = 12)