explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 262s

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

WindowAgg (cost=18.13..18.15 rows=1 width=39) (actual time=0.019..0.019 rows=0 loops=1)

2. 0.005 0.019 ↓ 0.0 0 1

Sort (cost=18.13..18.13 rows=1 width=31) (actual time=0.018..0.019 rows=0 loops=1)

  • Sort Key: user_student.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=2.23..18.12 rows=1 width=31) (actual time=0.014..0.014 rows=0 loops=1)

4. 0.000 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.96..15.60 rows=1 width=31) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((NOT tutor_student_wx_log.is_add_wx) OR (tutor_student_wx_log.is_add_wx IS NULL))
5. 0.001 0.014 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.81..13.22 rows=1 width=39) (actual time=0.014..0.014 rows=0 loops=1)

  • Join Filter: ((class.tutor_id)::text = (user_teacher.user_teacher_id)::text)
6. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.40..10.58 rows=1 width=31) (actual time=0.013..0.013 rows=0 loops=1)

7. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.12..8.06 rows=1 width=39) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: ((curriculum.curriculum_id)::text = (class.curriculum_id)::text)
8. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.85..7.71 rows=1 width=65) (actual time=0.013..0.013 rows=0 loops=1)

9. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.57..5.03 rows=1 width=32) (actual time=0.013..0.013 rows=0 loops=1)

10. 0.013 0.013 ↓ 0.0 0 1

Index Scan using user_student_phone_live_create_date_idx on user_student (cost=0.29..2.52 rows=1 width=32) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((phone)::text = '11'::text)
  • Filter: (((name)::text ~~ '11%'::text) AND ((remark_name)::text ~~ '11%'::text) AND ((zb_open_id = ''::text) OR (zb_open_id IS NULL)) AND (grade_id = 2) AND ((province)::text = '120000'::text))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using curriculum_record_student_id_status_idx on curriculum_record (cost=0.29..2.51 rows=1 width=49) (never executed)

  • Index Cond: ((student_id)::text = (user_student.user_student_id)::text)
  • Filter: (status = ANY ('{2,5}'::integer[]))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using curriculum_title_cidx on curriculum (cost=0.28..2.67 rows=1 width=33) (never executed)

  • Index Cond: ((title >= '1111邀请有奖'::text) AND (title < '1111邀请有套'::text))
  • Filter: ((title ~~ '1111邀请有奖%'::text) AND (semester_id = 2) AND (id = ANY ('{2898,2899,2902,2903,2906,2909,2916,2917,2901,2904,2907,2910,2905,2908,2911,2912,2913,2828,2824,2880,2889,2885,2850,2818,2888,2892,2893,2895,2686,2765,2896,2810,2884,2819,2861,2887,2891,2849,2825,2692,2796,2687,2811,2897,2822,2894,2860,2863,2869,2740,2862,2858,2872,2874,2820,2817,2865,2866,2867,2871,2829,2868,2826,2873,2870,2864,2875,2688,2489,506,428,435,609,2813,2799,438,2797,2569,2579,2798,2812,611,739,606,470,2580,516,2800,114,198,2568,2807,521,614,618,608,2582,2815,405,441,2814,427,613,138,610,2554,2816,2541,2540,2542,654,607,2761,524,2586,2385,2808,737,615,2567,599,2795,2387,2890,2801,612,2879,515,2487,2821,2590,2587,2591,2257,2375}'::bigint[])))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using class_class_id_idx on class (cost=0.28..0.34 rows=1 width=73) (never executed)

  • Index Cond: ((class_id)::text = (curriculum_record.class_id)::text)
  • Filter: (((tutor_id)::text = '5c1da30144e6a8000189d719'::text) AND (id = 11))
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using curriculum_genre_curriculum_id_genre_idx on curriculum_genre (cost=0.28..2.50 rows=1 width=8) (never executed)

  • Index Cond: ((curriculum_id = curriculum.id) AND (genre = 8))
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Scan using user_teacher_user_teacher_id_idx on user_teacher (cost=0.41..2.63 rows=1 width=33) (never executed)

  • Index Cond: ((user_teacher_id)::text = '5c1da30144e6a8000189d719'::text)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using tutor_student_wx_log_teacher_id_user_student_id_idx on tutor_student_wx_log (cost=0.15..2.37 rows=1 width=17) (never executed)

  • Index Cond: ((teacher_id = user_teacher.id) AND (user_student_id = user_student.id))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using student_transfer_user_student_id_idx on student_transfer (cost=0.27..2.50 rows=1 width=8) (never executed)

  • Index Cond: (user_student_id = user_student.id)
  • Filter: (transfer_status = ANY ('{2002,1002,2003,1003,2004,1004}'::integer[]))
Planning time : 2.682 ms
Execution time : 0.129 ms