explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DIcf : Optimization for: Optimization for: plan #XHKo; plan #a8Uq

Settings

Optimization path:

Optimization(s) for this plan:

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

Index Scan using tutor_student_wx_log_teacher_id_user_student_id_idx on multi.tutor_student_wx_log (cost=0.14..3.23 rows=1 width=58) (actual time=0.018..0.019 rows=0 loops=1)

  • Output: id, created_at, updated_at, deleted_at, is_delete, teacher_id, user_student_id, is_add_wx, add_wx_at
  • Index Cond: (tutor_student_wx_log.teacher_id = 112,272)
  • Filter: ((tutor_student_wx_log.user_student_id = 158,065) OR (tutor_student_wx_log.user_student_id = 158,065) OR (tutor_student_wx_log.user_student_id = 158,065) OR (tutor_student_wx_log.user_student_id = 158,065) OR (tutor_student_wx_log.user_student_id = 158,065) OR (tutor_student_wx_log.user_student_id = 158,063) OR (tutor_student_wx_log.user_student_id = 158,063) OR (tutor_student_wx_log.user_student_id = 158,063) OR (tutor_student_wx_log.user_student_id = 158,063) OR (tutor_student_wx_log.user_student_id = 158,063) OR (tutor_student_wx_log.user_student_id = 158,061) OR (tutor_student_wx_log.user_student_id = 158,061) OR (tutor_student_wx_log.user_student_id = 158,061) OR (tutor_student_wx_log.user_student_id = 158,061) OR (tutor_student_wx_log.user_student_id = 158,061) OR (tutor_student_wx_log.user_student_id = 158,060) OR (tutor_student_wx_log.user_student_id = 158,060) OR (tutor_student_wx_log.user_student_id = 158,060) OR (tutor_student_wx_log.user_student_id = 158,060) OR (tutor_student_wx_log.user_student_id = 158,060) OR (tutor_student_wx_log.user_student_id = 158,059) OR (tutor_student_wx_log.user_student_id = 158,059) OR (tutor_student_wx_log.user_student_id = 158,059) OR (tutor_student_wx_log.user_student_id = 158,059) OR (tutor_student_wx_log.user_student_id = 158,059) OR (tutor_student_wx_log.user_student_id = 158,058) OR (tutor_student_wx_log.user_student_id = 158,058) OR (tutor_student_wx_log.user_student_id = 158,058) OR (tutor_student_wx_log.user_student_id = 158,058) OR (tutor_student_wx_log.user_student_id = 158,058) OR (tutor_student_wx_log.user_student_id = 158,057) OR (tutor_student_wx_log.user_student_id = 158,057) OR (tutor_student_wx_log.user_student_id = 158,057) OR (tutor_student_wx_log.user_student_id = 158,057) OR (tutor_student_wx_log.user_student_id = 158,057) OR (tutor_student_wx_log.user_student_id = 158,056) OR (tutor_student_wx_log.user_student_id = 158,056) OR (tutor_student_wx_log.user_student_id = 158,056) OR (tutor_student_wx_log.user_student_id = 158,056) OR (tutor_student_wx_log.user_student_id = 158,056) OR (tutor_student_wx_log.user_student_id = 158,055) OR (tutor_student_wx_log.user_student_id = 158,055) OR (tutor_student_wx_log.user_student_id = 158,055) OR (tutor_student_wx_log.user_student_id = 158,055) OR (tutor_student_wx_log.user_student_id = 158,055) OR (tutor_student_wx_log.user_student_id = 157,784) OR (tutor_student_wx_log.user_student_id = 157,784) OR (tutor_student_wx_log.user_student_id = 157,784) OR (tutor_student_wx_log.user_student_id = 157,723) OR (tutor_student_wx_log.user_student_id = 157,723) OR (tutor_student_wx_log.user_student_id = 157,723) OR (tutor_student_wx_log.user_student_id = 157,723) OR (tutor_student_wx_log.user_student_id = 157,723) OR (tutor_student_wx_log.user_student_id = 157,723) OR (tutor_student_wx_log.user_student_id = 157,721) OR (tutor_student_wx_log.user_student_id = 157,721) OR (tutor_student_wx_log.user_student_id = 157,721) OR (tutor_student_wx_log.user_student_id = 157,721) OR (tutor_student_wx_log.user_student_id = 157,720) OR (tutor_student_wx_log.user_student_id = 157,720) OR (tutor_student_wx_log.user_student_id = 157,720) OR (tutor_student_wx_log.user_student_id = 157,720) OR (tutor_student_wx_log.user_student_id = 157,195) OR (tutor_student_wx_log.user_student_id = 157,190) OR (tutor_student_wx_log.user_student_id = 151,148) OR (tutor_student_wx_log.user_student_id = 151,148) OR (tutor_student_wx_log.user_student_id = 151,148) OR (tutor_student_wx_log.user_student_id = 151,148) OR (tutor_student_wx_log.user_student_id = 150,067) OR (tutor_student_wx_log.user_student_id = 150,067) OR (tutor_student_wx_log.user_student_id = 150,057) OR (tutor_student_wx_log.user_student_id = 150,057) OR (tutor_student_wx_log.user_student_id = 150,057) OR (tutor_student_wx_log.user_student_id = 150,057) OR (tutor_student_wx_log.user_student_id = 150,055) OR (tutor_student_wx_log.user_student_id = 150,046) OR (tutor_student_wx_log.user_student_id = 150,046) OR (tutor_student_wx_log.user_student_id = 150,046) OR (tutor_student_wx_log.user_student_id = 150,046) OR (tutor_student_wx_log.user_student_id = 150,046) OR (tutor_student_wx_log.user_student_id = 150,046) OR (tutor_student_wx_log.user_student_id = 149,956) OR (tutor_student_wx_log.user_student_id = 149,956) OR (tutor_student_wx_log.user_student_id = 149,956) OR (tutor_student_wx_log.user_student_id = 149,956) OR (tutor_student_wx_log.user_student_id = 149,865) OR (tutor_student_wx_log.user_student_id = 149,865) OR (tutor_student_wx_log.user_student_id = 149,865) OR (tutor_student_wx_log.user_student_id = 149,865) OR (tutor_student_wx_log.user_student_id = 149,865) OR (tutor_student_wx_log.user_student_id = 149,865) OR (tutor_student_wx_log.user_student_id = 149,864) OR (tutor_student_wx_log.user_student_id = 149,864) OR (tutor_student_wx_log.user_student_id = 149,864) OR (tutor_student_wx_log.user_student_id = 149,864) OR (tutor_student_wx_log.user_student_id = 149,864) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,863) OR (tutor_student_wx_log.user_student_id = 149,862) OR (tutor_student_wx_log.user_student_id = 149,862) OR (tutor_student_wx_log.user_student_id = 149,862) OR (tutor_student_wx_log.user_student_id = 149,862) OR (tutor_student_wx_log.user_student_id = 149,861) OR (tutor_student_wx_log.user_student_id = 149,861) OR (tutor_student_wx_log.user_student_id = 149,861) OR (tutor_student_wx_log.user_student_id = 149,861) OR (tutor_student_wx_log.user_student_id = 149,860) OR (tutor_student_wx_log.user_student_id = 149,860) OR (tutor_student_wx_log.user_student_id = 149,860) OR (tutor_student_wx_log.user_student_id = 149,860) OR (tutor_student_wx_log.user_student_id = 149,859) OR (tutor_student_wx_log.user_student_id = 149,859) OR (tutor_student_wx_log.user_student_id = 149,859) OR (tutor_student_wx_log.user_student_id = 149,858) OR (tutor_student_wx_log.user_student_id = 149,858) OR (tutor_student_wx_log.user_student_id = 149,858) OR (tutor_student_wx_log.user_student_id = 149,857) OR (tutor_student_wx_log.user_student_id = 149,857) OR (tutor_student_wx_log.user_student_id = 149,857) OR (tutor_student_wx_log.user_student_id = 149,857) OR (tutor_student_wx_log.user_student_id = 149,856) OR (tutor_student_wx_log.user_student_id = 149,856) OR (tutor_student_wx_log.user_student_id = 149,856) OR (tutor_student_wx_log.user_student_id = 149,856) OR (tutor_student_wx_log.user_student_id = 149,855) OR (tutor_student_wx_log.user_student_id = 149,855) OR (tutor_student_wx_log.user_student_id = 149,855) OR (tutor_student_wx_log.user_student_id = 149,855) OR (tutor_student_wx_log.user_student_id = 149,854) OR (tutor_student_wx_log.user_student_id = 149,854) OR (tutor_student_wx_log.user_student_id = 149,854) OR (tutor_student_wx_log.user_student_id = 149,854) OR (tutor_student_wx_log.user_student_id = 149,853) OR (tutor_student_wx_log.user_student_id = 149,853) OR (tutor_student_wx_log.user_student_id = 149,853) OR (tutor_student_wx_log.user_student_id = 149,853) OR (tutor_student_wx_log.user_student_id = 149,852) OR (tutor_student_wx_log.user_student_id = 149,852) OR (tutor_student_wx_log.user_student_id = 149,852) OR (tutor_student_wx_log.user_student_id = 149,852) OR (tutor_student_wx_log.user_student_id = 149,851) OR (tutor_student_wx_log.user_student_id = 149,851) OR (tutor_student_wx_log.user_student_id = 149,851) OR (tutor_student_wx_log.user_student_id = 149,851) OR (tutor_student_wx_log.user_student_id = 149,850) OR (tutor_student_wx_log.user_student_id = 149,850) OR (tutor_student_wx_log.user_student_id = 149,850) OR (tutor_student_wx_log.user_student_id = 149,850) OR (tutor_student_wx_log.user_student_id = 149,849) OR (tutor_student_wx_log.user_student_id = 149,849) OR (tutor_student_wx_log.user_student_id = 149,849) OR (tutor_student_wx_log.user_student_id = 149,849) OR (tutor_student_wx_log.user_student_id = 149,848) OR (tutor_student_wx_log.user_student_id = 149,848) OR (tutor_student_wx_log.user_student_id = 149,848) OR (tutor_student_wx_log.user_student_id = 149,848) OR (tutor_student_wx_log.user_student_id = 149,847) OR (tutor_student_wx_log.user_student_id = 149,847) OR (tutor_student_wx_log.user_student_id = 149,847) OR (tutor_student_wx_log.user_student_id = 149,847) OR (tutor_student_wx_log.user_student_id = 149,846) OR (tutor_student_wx_log.user_student_id = 149,846) OR (tutor_student_wx_log.user_student_id = 149,846) OR (tutor_student_wx_log.user_student_id = 149,846) OR (tutor_student_wx_log.user_student_id = 149,845) OR (tutor_student_wx_log.user_student_id = 149,845) OR (tutor_student_wx_log.user_student_id = 149,845) OR (tutor_student_wx_log.user_student_id = 149,845) OR (tutor_student_wx_log.user_student_id = 149,844) OR (tutor_student_wx_log.user_student_id = 149,844) OR (tutor_student_wx_log.user_student_id = 149,844) OR (tutor_student_wx_log.user_student_id = 149,844) OR (tutor_student_wx_log.user_student_id = 149,843) OR (tutor_student_wx_log.user_student_id = 149,843) OR (tutor_student_wx_log.user_student_id = 149,843) OR (tutor_student_wx_log.user_student_id = 149,843) OR (tutor_student_wx_log.user_student_id = 149,842) OR (tutor_student_wx_log.user_student_id = 149,842) OR (tutor_student_wx_log.user_student_id = 149,842) OR (tutor_student_wx_log.user_student_id = 149,842) OR (tutor_student_wx_log.user_student_id = 149,841) OR (tutor_student_wx_log.user_student_id = 149,841) OR (tutor_student_wx_log.user_student_id = 149,841) OR (tutor_student_wx_log.user_student_id = 149,840) OR (tutor_student_wx_log.user_student_id = 149,840) OR (tutor_student_wx_log.user_student_id = 149,840) OR (tutor_student_wx_log.user_student_id = 149,839) OR (tutor_student_wx_log.user_student_id = 149,839) OR (tutor_student_wx_log.user_student_id = 149,839) OR (tutor_student_wx_log.user_student_id = 149,838) OR (tutor_student_wx_log.user_student_id = 149,838) OR (tutor_student_wx_log.user_student_id = 149,838) OR (tutor_student_wx_log.user_student_id = 149,837) OR (tutor_student_wx_log.user_student_id = 149,837) OR (tutor_student_wx_log.user_student_id = 149,837) OR (tutor_student_wx_log.user_student_id = 149,836) OR (tutor_student_wx_log.user_student_id = 149,836) OR (tutor_student_wx_log.user_student_id = 149,836) OR (tutor_student_wx_log.user_student_id = 149,835) OR (tutor_student_wx_log.user_student_id = 149,835) OR (tutor_student_wx_log.user_student_id = 149,835) OR (tutor_student_wx_log.user_student_id = 149,834) OR (tutor_student_wx_log.user_student_id = 149,834) OR (tutor_student_wx_log.user_student_id = 149,834) OR (tutor_student_wx_log.user_student_id = 149,833) OR (tutor_student_wx_log.user_student_id = 149,833) OR (tutor_student_wx_log.user_student_id = 149,833) OR (tutor_student_wx_log.user_student_id = 149,832) OR (tutor_student_wx_log.user_student_id = 149,832) OR (tutor_student_wx_log.user_student_id = 149,832) OR (tutor_student_wx_log.user_student_id = 149,831) OR (tutor_student_wx_log.user_student_id = 149,831) OR (tutor_student_wx_log.user_student_id = 149,831) OR (tutor_student_wx_log.user_student_id = 149,830) OR (tutor_student_wx_log.user_student_id = 149,830) OR (tutor_student_wx_log.user_student_id = 149,830) OR (tutor_student_wx_log.user_student_id = 149,829) OR (tutor_student_wx_log.user_student_id = 149,829) OR (tutor_student_wx_log.user_student_id = 149,829) OR (tutor_student_wx_log.user_student_id = 149,828) OR (tutor_student_wx_log.user_student_id = 149,828) OR (tutor_student_wx_log.user_student_id = 149,828) OR (tutor_student_wx_log.user_student_id = 149,827) OR (tutor_student_wx_log.user_student_id = 149,827) OR (tutor_student_wx_log.user_student_id = 149,827) OR (tutor_student_wx_log.user_student_id = 149,826) OR (tutor_student_wx_log.user_student_id = 149,826) OR (tutor_student_wx_log.user_student_id = 149,826) OR (tutor_student_wx_log.user_student_id = 149,825) OR (tutor_student_wx_log.user_student_id = 149,825) OR (tutor_student_wx_log.user_student_id = 149,825) OR (tutor_student_wx_log.user_student_id = 149,824) OR (tutor_student_wx_log.user_student_id = 149,824) OR (tutor_student_wx_log.user_student_id = 149,824) OR (tutor_student_wx_log.user_student_id = 149,823) OR (tutor_student_wx_log.user_student_id = 149,823) OR (tutor_student_wx_log.user_student_id = 149,823) OR (tutor_student_wx_log.user_student_id = 149,822) OR (tutor_student_wx_log.user_student_id = 149,822) OR (tutor_student_wx_log.user_student_id = 149,822) OR (tutor_student_wx_log.user_student_id = 149,821) OR (tutor_student_wx_log.user_student_id = 149,821) OR (tutor_student_wx_log.user_student_id = 149,821) OR (tutor_student_wx_log.user_student_id = 149,820) OR (tutor_student_wx_log.user_student_id = 149,820) OR (tutor_student_wx_log.user_student_id = 149,820) OR (tutor_student_wx_log.user_student_id = 149,819) OR (tutor_student_wx_log.user_student_id = 149,819) OR (tutor_student_wx_log.user_student_id = 149,819) OR (tutor_student_wx_log.user_student_id = 149,818) OR (tutor_student_wx_log.user_student_id = 149,818) OR (tutor_student_wx_log.user_student_id = 149,818) OR (tutor_student_wx_log.user_student_id = 149,817) OR (tutor_student_wx_log.user_student_id = 149,817) OR (tutor_student_wx_log.user_student_id = 149,817) OR (tutor_student_wx_log.user_student_id = 149,816) OR (tutor_student_wx_log.user_student_id = 149,816) OR (tutor_student_wx_log.user_student_id = 149,816) OR (tutor_student_wx_log.user_student_id = 149,815) OR (tutor_student_wx_log.user_student_id = 149,815) OR (tutor_student_wx_log.user_student_id = 149,815) OR (tutor_student_wx_log.user_student_id = 149,814) OR (tutor_student_wx_log.user_student_id = 149,814) OR (tutor_student_wx_log.user_student_id = 149,814) OR (tutor_student_wx_log.user_student_id = 149,813) OR (tutor_student_wx_log.user_student_id = 149,813) OR (tutor_student_wx_log.user_student_id = 149,813) OR (tutor_student_wx_log.user_student_id = 149,812) OR (tutor_student_wx_log.user_student_id = 149,812) OR (tutor_student_wx_log.user_student_id = 149,812) OR (tutor_student_wx_log.user_student_id = 149,811) OR (tutor_student_wx_log.user_student_id = 149,811) OR (tutor_student_wx_log.user_student_id = 149,811) OR (tutor_student_wx_log.user_student_id = 149,810) OR (tutor_student_wx_log.user_student_id = 149,810) OR (tutor_student_wx_log.user_student_id = 149,810) OR (tutor_student_wx_log.user_student_id = 149,809) OR (tutor_student_wx_log.user_student_id = 149,809) OR (tutor_student_wx_log.user_student_id = 149,809) OR (tutor_student_wx_log.user_student_id = 149,808) OR (tutor_student_wx_log.user_student_id = 149,808) OR (tutor_student_wx_log.user_student_id = 149,808) OR (tutor_student_wx_log.user_student_id = 149,807) OR (tutor_student_wx_log.user_student_id = 149,807) OR (tutor_student_wx_log.user_student_id = 149,807) OR (tutor_student_wx_log.user_student_id = 149,806) OR (tutor_student_wx_log.user_student_id = 149,806) OR (tutor_student_wx_log.user_student_id = 149,806) OR (tutor_student_wx_log.user_student_id = 149,805) OR (tutor_student_wx_log.user_student_id = 149,805) OR (tutor_student_wx_log.user_student_id = 149,805) OR (tutor_student_wx_log.user_student_id = 149,804) OR (tutor_student_wx_log.user_student_id = 149,804) OR (tutor_student_wx_log.user_student_id = 149,804) OR (tutor_student_wx_log.user_student_id = 149,803) OR (tutor_student_wx_log.user_student_id = 149,803) OR (tutor_student_wx_log.user_student_id = 149,803) OR (tutor_student_wx_log.user_student_id = 149,802) OR (tutor_student_wx_log.user_student_id = 149,802) OR (tutor_student_wx_log.user_student_id = 149,802) OR (tutor_student_wx_log.user_student_id = 149,801) OR (tutor_student_wx_log.user_student_id = 149,801) OR (tutor_student_wx_log.user_student_id = 149,801) OR (tutor_student_wx_log.user_student_id = 149,800) OR (tutor_student_wx_log.user_student_id = 149,800) OR (tutor_student_wx_log.user_student_id = 149,800) OR (tutor_student_wx_log.user_student_id = 149,799) OR (tutor_student_wx_log.user_student_id = 149,799) OR (tutor_student_wx_log.user_student_id = 149,799) OR (tutor_student_wx_log.user_student_id = 149,798) OR (tutor_student_wx_log.user_student_id = 149,798) OR (tutor_student_wx_log.user_student_id = 149,798) OR (tutor_student_wx_log.user_student_id = 149,797) OR (tutor_student_wx_log.user_student_id = 149,797) OR (tutor_student_wx_log.user_student_id = 149,797) OR (tutor_student_wx_log.user_student_id = 149,796) OR (tutor_student_wx_log.user_student_id = 149,796) OR (tutor_student_wx_log.user_student_id = 149,796) OR (tutor_student_wx_log.user_student_id = 149,795) OR (tutor_student_wx_log.user_student_id = 149,795) OR (tutor_student_wx_log.user_student_id = 149,795) OR (tutor_student_wx_log.user_student_id = 149,794) OR (tutor_student_wx_log.user_student_id = 149,794) OR (tutor_student_wx_log.user_student_id = 149,794) OR (tutor_student_wx_log.user_student_id = 149,793) OR (tutor_student_wx_log.user_student_id = 149,793) OR (tutor_student_wx_log.user_student_id = 149,793) OR (tutor_student_wx_log.user_student_id = 149,792) OR (tutor_student_wx_log.user_student_id = 149,792) OR (tutor_student_wx_log.user_student_id = 149,792) OR (tutor_student_wx_log.user_student_id = 149,791) OR (tutor_student_wx_log.user_student_id = 149,791) OR (tutor_student_wx_log.user_student_id = 149,791) OR (tutor_student_wx_log.user_student_id = 149,790) OR (tutor_student_wx_log.user_student_id = 149,790) OR (tutor_student_wx_log.user_student_id = 149,790) OR (tutor_student_wx_log.user_student_id = 149,789) OR (tutor_student_wx_log.user_student_id = 149,789) OR (tutor_student_wx_log.user_student_id = 149,789) OR (tutor_student_wx_log.user_student_id = 149,788) OR (tutor_student_wx_log.user_student_id = 149,788) OR (tutor_student_wx_log.user_student_id = 149,788) OR (tutor_student_wx_log.user_student_id = 149,787) OR (tutor_student_wx_log.user_student_id = 149,787) OR (tutor_student_wx_log.user_student_id = 149,787))
  • Buffers: shared hit=1
Planning time : 1.509 ms
Execution time : 0.134 ms