explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CXcK

Settings
# exclusive inclusive rows x rows loops node
1. 45.191 45.191 ↓ 1.9 35,066 1

Seq Scan on sym_vm_contacts_q (cost=0.00..4,170.60 rows=18,621 width=103) (actual time=0.366..45.191 rows=35,066 loops=1)

  • Filter: ((sid_historique_dt >= '2019-01-01 00:00:00'::timestamp without time zone) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 89,559
Planning time : 1.289 ms
Execution time : 46.320 ms