explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tgQo : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.516 8.199 ↓ 9.1 3,449 1

Append (cost=0.00..307.38 rows=377 width=2,204) (actual time=2.855..8.199 rows=3,449 loops=1)

2. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
3. 0.002 0.036 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m01 (cost=9.10..13.12 rows=5 width=2,204) (actual time=0.036..0.036 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
4. 0.000 0.034 ↓ 0.0 0 1

BitmapOr (cost=9.10..9.10 rows=1 width=0) (actual time=0.034..0.034 rows=0 loops=1)

5. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m01_n_status_n_event_type_n_tp_tim (cost=0.00..4.44 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
6. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m01_n_status_n_event_type_n_tp_tim (cost=0.00..4.65 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
7. 0.000 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m02 (cost=9.63..13.65 rows=11 width=2,204) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
8. 0.002 0.027 ↓ 0.0 0 1

BitmapOr (cost=9.63..9.63 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

9. 0.019 0.019 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m02_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
10. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m02_n_status_n_event_type_n_tp_tim (cost=0.00..5.05 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
11. 0.001 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m03 (cost=10.27..14.29 rows=25 width=2,204) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
12. 0.000 0.026 ↓ 0.0 0 1

BitmapOr (cost=10.27..10.27 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

13. 0.019 0.019 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m03_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
14. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m03_n_status_n_event_type_n_tp_tim (cost=0.00..5.68 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
15. 0.000 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m04 (cost=10.05..14.08 rows=20 width=2,204) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
16. 0.000 0.026 ↓ 0.0 0 1

BitmapOr (cost=10.05..10.05 rows=1 width=0) (actual time=0.025..0.026 rows=0 loops=1)

17. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m04_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
18. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m04_n_status_n_event_type_n_tp_tim (cost=0.00..5.47 rows=1 width=0) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
19. 0.000 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m05 (cost=10.48..18.51 rows=30 width=2,204) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
20. 0.002 0.027 ↓ 0.0 0 1

BitmapOr (cost=10.48..10.48 rows=2 width=0) (actual time=0.027..0.027 rows=0 loops=1)

21. 0.019 0.019 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m05_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
22. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m05_n_status_n_event_type_n_tp_tim (cost=0.00..5.89 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
23. 0.001 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m06 (cost=10.26..14.28 rows=25 width=2,204) (actual time=0.026..0.027 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
24. 0.001 0.026 ↓ 0.0 0 1

BitmapOr (cost=10.26..10.26 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

25. 0.019 0.019 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m06_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
26. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m06_n_status_n_event_type_n_tp_tim (cost=0.00..5.67 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
27. 0.001 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m07 (cost=10.91..18.94 rows=39 width=2,204) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
28. 0.000 0.027 ↓ 0.0 0 1

BitmapOr (cost=10.91..10.91 rows=2 width=0) (actual time=0.027..0.027 rows=0 loops=1)

29. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m07_n_status_n_event_type_n_tp_tim (cost=0.00..4.59 rows=2 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
30. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m07_n_status_n_event_type_n_tp_tim (cost=0.00..6.30 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
31. 0.000 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m08 (cost=15.32..27.36 rows=48 width=2,204) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
32. 0.002 0.027 ↓ 0.0 0 1

BitmapOr (cost=15.32..15.32 rows=3 width=0) (actual time=0.026..0.027 rows=0 loops=1)

33. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m08_n_status_n_event_type_n_tp_tim (cost=0.00..4.59 rows=2 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
34. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m08_n_status_n_event_type_n_tp_tim (cost=0.00..10.71 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
35. 0.000 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m09 (cost=10.36..18.39 rows=27 width=2,204) (actual time=0.027..0.027 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
36. 0.001 0.027 ↓ 0.0 0 1

BitmapOr (cost=10.36..10.36 rows=2 width=0) (actual time=0.027..0.027 rows=0 loops=1)

37. 0.019 0.019 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m09_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
38. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m09_n_status_n_event_type_n_tp_tim (cost=0.00..5.77 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
39. 0.001 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m10 (cost=9.99..14.02 rows=19 width=2,204) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
40. 0.000 0.025 ↓ 0.0 0 1

BitmapOr (cost=9.99..9.99 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=1)

41. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m10_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
42. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m10_n_status_n_event_type_n_tp_tim (cost=0.00..5.41 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
43. 0.000 0.026 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m11 (cost=15.49..27.53 rows=52 width=2,204) (actual time=0.026..0.026 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
44. 0.003 0.026 ↓ 0.0 0 1

BitmapOr (cost=15.49..15.49 rows=3 width=0) (actual time=0.026..0.026 rows=0 loops=1)

45. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m11_n_status_n_event_type_n_tp_tim (cost=0.00..4.59 rows=2 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
46. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m11_n_status_n_event_type_n_tp_tim (cost=0.00..10.87 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
47. 0.000 0.031 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m12 (cost=15.41..27.45 rows=50 width=2,204) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
48. 0.001 0.031 ↓ 0.0 0 1

BitmapOr (cost=15.41..15.41 rows=3 width=0) (actual time=0.031..0.031 rows=0 loops=1)

49. 0.023 0.023 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m12_n_status_n_event_type_n_tp_tim (cost=0.00..4.59 rows=2 width=0) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
50. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2018m12_n_status_n_event_type_n_tp_tim (cost=0.00..10.80 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
51. 4.445 6.855 ↓ 265.3 3,449 1

Bitmap Heap Scan on uzgps_notification_y2019m01 (cost=9.71..13.73 rows=13 width=2,204) (actual time=2.518..6.855 rows=3,449 loops=1)

  • Recheck Cond: (((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone)) OR ((n_status = 'A'::bpchar) AND (n_event_ty (...)
  • Heap Blocks: exact=393
52. 0.000 2.410 ↓ 0.0 0 1

BitmapOr (cost=9.71..9.71 rows=1 width=0) (actual time=2.410..2.410 rows=0 loops=1)

53. 1.497 1.497 ↓ 3,449.0 3,449 1

Bitmap Index Scan on uzgps_notification_temp_y2019m01_n_status_n_event_type_n_tp_tim (cost=0.00..4.57 rows=1 width=0) (actual time=1.497..1.497 rows=3,449 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
54. 0.914 0.914 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y2019m01_n_status_n_event_type_n_tp_tim (cost=0.00..5.13 rows=1 width=0) (actual time=0.913..0.914 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_contract_id = 12))
55. 0.068 0.068 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m02 (cost=0.00..3.82 rows=1 width=2,204) (actual time=0.068..0.068 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
  • Rows Removed by Filter: 81
56. 0.105 0.105 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m03 (cost=0.00..6.33 rows=1 width=2,204) (actual time=0.105..0.105 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
  • Rows Removed by Filter: 148
57. 0.007 0.007 ↓ 0.0 0 1

Index Scan using uzgps_notification_temp_y2019m04_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m04 (cost=0.14..8.16 rows=1 width=2,204) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
  • Filter: ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12))
58. 0.004 0.004 ↓ 0.0 0 1

Index Scan using uzgps_notification_temp_y2019m05_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m05 (cost=0.14..8.16 rows=1 width=2,204) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
  • Filter: ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12))
59. 0.044 0.044 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m06 (cost=0.00..3.53 rows=1 width=2,204) (actual time=0.044..0.044 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
  • Rows Removed by Filter: 68
60. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m07 (cost=0.00..1.07 rows=1 width=2,204) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
  • Rows Removed by Filter: 3
61. 0.003 0.003 ↓ 0.0 0 1

Index Scan using uzgps_notification_temp_y2019m08_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m08 (cost=0.14..8.16 rows=1 width=2,204) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
  • Filter: ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12))
62. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m09 (cost=0.00..1.16 rows=1 width=2,204) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
  • Rows Removed by Filter: 7
63. 0.004 0.004 ↓ 0.0 0 1

Index Scan using uzgps_notification_temp_y2019m10_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m10 (cost=0.14..8.16 rows=1 width=2,204) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
  • Filter: ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12))
64. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_notification_temp_y2019m11_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m11 (cost=0.27..8.30 rows=1 width=2,204) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
  • Filter: ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12))
65. 0.192 0.192 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m12 (cost=0.00..6.87 rows=1 width=2,204) (actual time=0.192..0.192 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12)))
  • Rows Removed by Filter: 172
66. 0.033 0.033 ↓ 0.0 0 1

Index Scan using uzgps_notification_temp_y9999m99_n_status_n_event_type_n_tp_tim on uzgps_notification_y9999m99 (cost=0.28..8.30 rows=1 width=2,204) (actual time=0.033..0.033 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone))
  • Filter: ((n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) OR (n_contract_id = 12))
  • Rows Removed by Filter: 3