explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 09lM

Settings
# exclusive inclusive rows x rows loops node
1. 98.935 98.935 ↓ 0.0 0 1

Index Scan using customers_on_4s1luijuteom3b767d70_last_seen_idx on customers_on_4s1luijuteom3b767d70 (cost=0.43..33,975.31 rows=1 width=43) (actual time=98.935..98.935 rows=0 loops=1)

  • Index Cond: (last_seen > (now() - '14 days'::interval))
  • Filter: ((user_last_msg_received IS NOT NULL) AND (last_seen < last_message_creation_time) AND ((chat_platform_id)::text = 'whatsapp'::text) AND (last_message_creation_time >= (now() - '24:00:00'::interval)) AND (last_message_creation_time <= (now() - '26:00:00'::interval)) AND ((((user_last_msg_received)::bigint * 1000))::double precision < date_part('epoch'::text, last_message_creation_time)) AND (floor((date_part('epoch'::text, last_message_creation_time) - (((user_last_msg_received)::bigint * 1000))::double precision)) > '86400'::double precision))
  • Rows Removed by Filter: 45681
Planning time : 0.163 ms
Execution time : 98.972 ms