explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MRMA

Settings
# exclusive inclusive rows x rows loops node
1. 8.031 19.655 ↑ 1.0 1,481 1

Merge Join (cost=0.76..1,811.90 rows=1,481 width=1,235) (actual time=0.055..19.655 rows=1,481 loops=1)

  • Merge Cond: (gg.fk_salarie = ss.id_salarie)
2. 1.558 1.558 ↑ 7.4 1,482 1

Index Scan using i_fk_t_geocodage_t_salarie on t_geocodage gg (cost=0.29..1,380.22 rows=10,975 width=247) (actual time=0.019..1.558 rows=1,482 loops=1)

3. 10.066 10.066 ↑ 1.0 8,467 1

Index Scan using pk_t_salarie on t_salarie ss (cost=0.29..1,585.47 rows=8,568 width=988) (actual time=0.013..10.066 rows=8,467 loops=1)