explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KfcT : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 313.142 ↑ 1.0 100 1

Limit (cost=0.00..218.61 rows=100 width=2,188) (actual time=313.072..313.142 rows=100 loops=1)

2. 0.010 313.126 ↑ 6,504.2 100 1

Append (cost=0.00..1,421,860.20 rows=650,418 width=2,188) (actual time=313.070..313.126 rows=100 loops=1)

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on uzgps_notification (cost=0.00..0.00 rows=1 width=2,188) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (n_status = 'A'::bpchar)
4. 7.445 313.113 ↑ 87.5 100 1

Bitmap Heap Scan on uzgps_notification_y2018m01 (cost=416.28..19,217.05 rows=8,755 width=2,188) (actual time=313.065..313.113 rows=100 loops=1)

  • Recheck Cond: (n_status = 'A'::bpchar)
  • Heap Blocks: exact=2
5. 305.668 305.668 ↓ 200.0 1,751,330 1

Bitmap Index Scan on uzgps_notification_temp_y2018m01_n_status_n_event_type_n_tp_tim (cost=0.00..414.09 rows=8,755 width=0) (actual time=305.668..305.668 rows=1,751,330 loops=1)

  • Index Cond: (n_status = 'A'::bpchar)
6. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m02 (cost=839.30..43,695.20 rows=19,967 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m02_n_status_n_event_type_n_tp_tim (cost=0.00..834.31 rows=19,967 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m03 (cost=1,800.37..98,148.21 rows=44,879 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m03_n_status_n_event_type_n_tp_tim (cost=0.00..1,789.15 rows=44,879 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m04 (cost=1,487.02..79,788.74 rows=36,447 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m04_n_status_n_event_type_n_tp_tim (cost=0.00..1,477.91 rows=36,447 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
12. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m05 (cost=2,073.48..116,466.73 rows=53,280 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
13. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m05_n_status_n_event_type_n_tp_tim (cost=0.00..2,060.16 rows=53,280 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
14. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m06 (cost=1,787.45..96,757.12 rows=44,244 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
15. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m06_n_status_n_event_type_n_tp_tim (cost=0.00..1,776.39 rows=44,244 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
16. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m07 (cost=2,685.76..151,407.91 rows=69,316 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
17. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m07_n_status_n_event_type_n_tp_tim (cost=0.00..2,668.43 rows=69,316 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
18. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m08 (cost=3,200.89..187,163.46 rows=85,720 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
19. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m08_n_status_n_event_type_n_tp_tim (cost=0.00..3,179.46 rows=85,720 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
20. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m09 (cost=1,994.73..106,773.07 rows=48,796 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
21. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m09_n_status_n_event_type_n_tp_tim (cost=0.00..1,982.53 rows=48,796 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
22. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m10 (cost=1,529.48..75,046.56 rows=34,184 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
23. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m10_n_status_n_event_type_n_tp_tim (cost=0.00..1,520.94 rows=34,184 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
24. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m11 (cost=3,273.46..201,945.54 rows=92,503 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
25. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m11_n_status_n_event_type_n_tp_tim (cost=0.00..3,250.34 rows=92,503 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
26. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2018m12 (cost=3,322.80..195,731.25 rows=89,579 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
27. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2018m12_n_status_n_event_type_n_tp_tim (cost=0.00..3,300.40 rows=89,579 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
28. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y2019m01 (cost=828.74..49,650.41 rows=22,733 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
29. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y2019m01_n_status_n_event_type_n_tp_tim (cost=0.00..823.05 rows=22,733 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
30. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m02 (cost=0.00..3.01 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m03 (cost=0.00..4.85 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using uzgps_notification_temp_y2019m04_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m04 (cost=0.14..8.15 rows=1 width=2,188) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using uzgps_notification_temp_y2019m05_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m05 (cost=0.14..8.15 rows=1 width=2,188) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
34. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m06 (cost=0.00..2.85 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
35. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m07 (cost=0.00..1.04 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using uzgps_notification_temp_y2019m08_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m08 (cost=0.14..8.15 rows=1 width=2,188) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
37. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m09 (cost=0.00..1.09 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using uzgps_notification_temp_y2019m10_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m10 (cost=0.14..8.15 rows=1 width=2,188) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)
39. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m11 (cost=0.00..6.94 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on uzgps_notification_y2019m12 (cost=0.00..5.15 rows=1 width=2,188) (never executed)

  • Filter: (n_status = 'A'::bpchar)
41. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on uzgps_notification_y9999m99 (cost=4.30..11.41 rows=3 width=2,188) (never executed)

  • Recheck Cond: (n_status = 'A'::bpchar)
42. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uzgps_notification_temp_y9999m99_n_status_n_event_type_n_tp_tim (cost=0.00..4.30 rows=3 width=0) (never executed)

  • Index Cond: (n_status = 'A'::bpchar)