explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CMwz

Settings
# exclusive inclusive rows x rows loops node
1. 751,982.850 751,982.850 ↓ 8.6 32,082 1

Seq Scan on import.circe_g_tcc140_a320_af wire_bdo (cost=0.00..461,717.53 rows=3,726 width=32) (actual time=0.039..751,982.850 rows=32,082 loops=1)

  • Output: repere_electrique_extremite_1, repere_de_lensemble_constitut
  • Filter: (wire_bdo.groupe_validite_cablage_binair @> '{1105}'::integer[])
  • Rows Removed by Filter: 718,604
  • Buffers: shared hit=641,657 read=728,833