explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DNTQ

Settings
# exclusive inclusive rows x rows loops node
1. 25.925 25.925 ↑ 10.0 1 1

Index Scan using pk_mt_tethered_hist on mt_tethered_hist (cost=0.57..3,184.79 rows=10 width=73) (actual time=25.924..25.925 rows=1 loops=1)

  • Index Cond: ((mtid = '35043357'::numeric) AND (start_dt <= to_timestamp('20181207191725'::text, 'YYYYMMDDHH24MISS'::text)))
  • Filter: ((end_dt IS NULL) OR (end_dt >= to_timestamp('20181207191725'::text, 'YYYYMMDDHH24MISS'::text)))