explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cec3

Settings
# exclusive inclusive rows x rows loops node
1. 1.579 17.340 ↓ 3.8 215 1

Hash Join (cost=1,415.01..26,119.73 rows=56 width=4) (actual time=2.806..17.340 rows=215 loops=1)

  • Hash Cond: (i0_.cd_nom = i2_.cd_ref)
2. 13.945 15.019 ↑ 1.1 6,027 1

Bitmap Heap Scan on observations_interne i0_ (cost=128.77..24,503.72 rows=6,753 width=8) (actual time=2.001..15.019 rows=6,027 loops=1)

  • Recheck Cond: ((commune)::text = '33550'::text)
  • Filter: (the_geom IS NOT NULL)
3. 1.074 1.074 ↑ 1.1 6,027 1

Bitmap Index Scan on observations_interne_commune_idx (cost=0.00..127.08 rows=6,753 width=0) (actual time=1.074..1.074 rows=6,027 loops=1)

  • Index Cond: ((commune)::text = '33550'::text)
4. 0.200 0.742 ↑ 1.1 677 1

Hash (cost=1,277.09..1,277.09 rows=732 width=4) (actual time=0.742..0.742 rows=677 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
5. 0.472 0.542 ↑ 1.1 677 1

Bitmap Heap Scan on vm_requeteur_groupes i2_ (cost=18.10..1,277.09 rows=732 width=4) (actual time=0.085..0.542 rows=677 loops=1)

  • Recheck Cond: (gid = 5)
6. 0.070 0.070 ↑ 1.1 677 1

Bitmap Index Scan on vm_requeteur_groupes_gid_idx (cost=0.00..17.91 rows=732 width=0) (actual time=0.070..0.070 rows=677 loops=1)

  • Index Cond: (gid = 5)
Total runtime : 17.445 ms