explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xW0d

Settings
# exclusive inclusive rows x rows loops node
1. 10.069 28.323 ↑ 1.0 8,356 1

Hash Semi Join (cost=2,361.49..4,488.52 rows=8,391 width=16) (actual time=11.974..28.323 rows=8,356 loops=1)

  • Hash Cond: (voitures.immatriculation = caracteristiques_voitures.immatriculation)
2. 6.298 6.298 ↑ 1.0 99,988 1

Seq Scan on voitures (cost=0.00..1,613.88 rows=99,988 width=16) (actual time=0.007..6.298 rows=99,988 loops=1)

3. 1.006 11.956 ↑ 1.0 8,356 1

Hash (cost=2,256.60..2,256.60 rows=8,391 width=10) (actual time=11.956..11.956 rows=8,356 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 471kB
4. 10.950 10.950 ↑ 1.0 8,356 1

Seq Scan on caracteristiques_voitures (cost=0.00..2,256.60 rows=8,391 width=10) (actual time=0.007..10.950 rows=8,356 loops=1)

  • Filter: (caracteristiques = 'toit ouvrant'::text)
  • Rows Removed by Filter: 113132