explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 98x8

Settings
# exclusive inclusive rows x rows loops node
1. 24.881 24.881 ↓ 1.7 35,066 1

Index Scan using idx_sym_vm_contacts_q on sym_vm_contacts_q (cost=0.29..3,111.94 rows=20,790 width=103) (actual time=0.070..24.881 rows=35,066 loops=1)

  • Index Cond: (sid_historique_dt >= '2019-01-01 00:00:00'::timestamp without time zone)
  • Filter: (sid_publie_in = 1)
Planning time : 0.537 ms
Execution time : 25.966 ms