explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H2cK

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

Append (cost=0.43..90,511.57 rows=3 width=43) (actual time=225.537..225.537 rows=0 loops=1)

2. 73.158 73.158 ↓ 0.0 0 1

Index Scan using customers_on_plbwx5xygq2b3gp7in8q_partitioned2_p0_last_seen_idx on customers_on_plbwx5xygq2b3gp7in8q_partitioned2_p0 (cost=0.43..31,319.15 rows=1 width=43) (actual time=73.158..73.158 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: 31742
3. 82.186 82.186 ↓ 0.0 0 1

Index Scan using customers_on_plbwx5xygq2b3gp7in8q_partitioned2_p1_last_seen_idx on customers_on_plbwx5xygq2b3gp7in8q_partitioned2_p1 (cost=0.43..29,646.20 rows=1 width=43) (actual time=82.185..82.186 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: 31705
4. 70.188 70.188 ↓ 0.0 0 1

Index Scan using customers_on_plbwx5xygq2b3gp7in8q_partitioned2_p2_last_seen_idx on customers_on_plbwx5xygq2b3gp7in8q_partitioned2_p2 (cost=0.43..29,546.20 rows=1 width=43) (actual time=70.188..70.188 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: 31626