explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WPQb : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 260.750 ↓ 0.0 0 1

Limit (cost=1,375,800.15..1,375,800.22 rows=30 width=2,204) (actual time=260.750..260.750 rows=0 loops=1)

2. 0.017 260.749 ↓ 0.0 0 1

Sort (cost=1,375,800.15..1,375,800.22 rows=30 width=2,204) (actual time=260.749..260.749 rows=0 loops=1)

  • Sort Key: uzgps_notification.n_value_time DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.022 260.732 ↓ 0.0 0 1

Append (cost=0.00..1,375,799.41 rows=30 width=2,204) (actual time=260.732..260.732 rows=0 loops=1)

4. 0.005 0.005 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
5. 2.149 2.435 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m01 (cost=310.09..19,176.53 rows=1 width=2,204) (actual time=2.435..2.435 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 867
  • Heap Blocks: exact=634
6. 0.286 0.286 ↑ 10.1 867 1

Bitmap Index Scan on uzgps_notification_temp_y2018m01_n_mobject_id_n_value_time_idx (cost=0.00..310.09 rows=8,755 width=0) (actual time=0.286..0.286 rows=867 loops=1)

  • Index Cond: (n_mobject_id = 1060)
7. 9.035 10.112 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m02 (cost=718.18..43,723.84 rows=1 width=2,204) (actual time=10.112..10.112 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 3253
  • Heap Blocks: exact=2698
8. 1.077 1.077 ↑ 6.1 3,253 1

Bitmap Index Scan on uzgps_notification_temp_y2018m02_n_mobject_id_n_value_time_idx (cost=0.00..718.18 rows=19,967 width=0) (actual time=1.077..1.077 rows=3,253 loops=1)

  • Index Cond: (n_mobject_id = 1060)
9. 20.106 22.400 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m03 (cost=1,617.15..98,301.59 rows=1 width=2,204) (actual time=22.400..22.400 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 7746
  • Heap Blocks: exact=6431
10. 2.294 2.294 ↑ 5.8 7,746 1

Bitmap Index Scan on uzgps_notification_temp_y2018m03_n_mobject_id_n_value_time_idx (cost=0.00..1,617.15 rows=44,879 width=0) (actual time=2.294..2.294 rows=7,746 loops=1)

  • Index Cond: (n_mobject_id = 1060)
11. 19.557 21.414 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m04 (cost=1,321.79..79,896.85 rows=1 width=2,204) (actual time=21.414..21.414 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 6208
  • Heap Blocks: exact=5205
12. 1.857 1.857 ↑ 5.9 6,208 1

Bitmap Index Scan on uzgps_notification_temp_y2018m04_n_mobject_id_n_value_time_idx (cost=0.00..1,321.78 rows=36,447 width=0) (actual time=1.857..1.857 rows=6,208 loops=1)

  • Index Cond: (n_mobject_id = 1060)
13. 29.907 33.102 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m05 (cost=1,944.16..116,737.01 rows=1 width=2,204) (actual time=33.102..33.102 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 12011
  • Heap Blocks: exact=10151
14. 3.195 3.195 ↑ 4.4 12,011 1

Bitmap Index Scan on uzgps_notification_temp_y2018m05_n_mobject_id_n_value_time_idx (cost=0.00..1,944.16 rows=53,280 width=0) (actual time=3.195..3.195 rows=12,011 loops=1)

  • Index Cond: (n_mobject_id = 1060)
15. 22.004 24.726 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m06 (cost=1,608.39..96,909.89 rows=1 width=2,204) (actual time=24.726..24.726 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 8491
  • Heap Blocks: exact=7356
16. 2.722 2.722 ↑ 5.2 8,491 1

Bitmap Index Scan on uzgps_notification_temp_y2018m06_n_mobject_id_n_value_time_idx (cost=0.00..1,608.39 rows=44,244 width=0) (actual time=2.721..2.722 rows=8,491 loops=1)

  • Index Cond: (n_mobject_id = 1060)
17. 6.254 6.938 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m07 (cost=2,528.43..151,770.45 rows=2 width=2,204) (actual time=6.938..6.938 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 1836
  • Heap Blocks: exact=1624
18. 0.684 0.684 ↑ 37.8 1,836 1

Bitmap Index Scan on uzgps_notification_temp_y2018m07_n_mobject_id_n_value_time_idx (cost=0.00..2,528.43 rows=69,316 width=0) (actual time=0.684..0.684 rows=1,836 loops=1)

  • Index Cond: (n_mobject_id = 1060)
19. 42.607 48.155 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m08 (cost=3,135.46..187,740.93 rows=2 width=2,204) (actual time=48.155..48.155 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 16283
  • Heap Blocks: exact=13661
20. 5.548 5.548 ↑ 5.3 16,283 1

Bitmap Index Scan on uzgps_notification_temp_y2018m08_n_mobject_id_n_value_time_idx (cost=0.00..3,135.46 rows=85,720 width=0) (actual time=5.548..5.548 rows=16,283 loops=1)

  • Index Cond: (n_mobject_id = 1060)
21. 13.315 15.251 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m09 (cost=1,778.53..106,922.84 rows=1 width=2,204) (actual time=15.251..15.251 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 6243
  • Heap Blocks: exact=5675
22. 1.936 1.936 ↑ 7.8 6,243 1

Bitmap Index Scan on uzgps_notification_temp_y2018m09_n_mobject_id_n_value_time_idx (cost=0.00..1,778.53 rows=48,796 width=0) (actual time=1.936..1.936 rows=6,243 loops=1)

  • Index Cond: (n_mobject_id = 1060)
23. 6.153 6.738 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m10 (cost=1,220.81..74,994.27 rows=1 width=2,204) (actual time=6.738..6.738 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 2834
  • Heap Blocks: exact=2579
24. 0.585 0.585 ↑ 12.1 2,834 1

Bitmap Index Scan on uzgps_notification_temp_y2018m10_n_mobject_id_n_value_time_idx (cost=0.00..1,220.81 rows=34,184 width=0) (actual time=0.585..0.585 rows=2,834 loops=1)

  • Index Cond: (n_mobject_id = 1060)
25. 36.498 39.615 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m11 (cost=3,382.34..202,748.19 rows=2 width=2,204) (actual time=39.615..39.615 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 15264
  • Heap Blocks: exact=13983
26. 3.117 3.117 ↑ 6.1 15,264 1

Bitmap Index Scan on uzgps_notification_temp_y2018m11_n_mobject_id_n_value_time_idx (cost=0.00..3,382.34 rows=92,503 width=0) (actual time=3.117..3.117 rows=15,264 loops=1)

  • Index Cond: (n_mobject_id = 1060)
27. 27.088 29.631 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m12 (cost=3,272.41..196,352.70 rows=2 width=2,204) (actual time=29.631..29.631 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
  • Rows Removed by Filter: 12552
  • Heap Blocks: exact=11444
28. 2.543 2.543 ↑ 7.1 12,552 1

Bitmap Index Scan on uzgps_notification_temp_y2018m12_n_mobject_id_n_value_time_idx (cost=0.00..3,272.40 rows=89,579 width=0) (actual time=2.542..2.543 rows=12,552 loops=1)

  • Index Cond: (n_mobject_id = 1060)
29. 0.002 0.023 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2019m01 (cost=5.57..450.51 rows=1 width=2,204) (actual time=0.023..0.023 rows=0 loops=1)

  • Recheck Cond: ((n_mobject_id = 1060) AND (n_event_type = 1))
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone))
30. 0.021 0.021 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_y2019m01_n_mobject_id_n_event_type_n_val_idx (cost=0.00..5.57 rows=114 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_event_type = 1))
31. 0.033 0.033 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
  • Rows Removed by Filter: 81
32. 0.034 0.034 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
  • Rows Removed by Filter: 148
33. 0.005 0.005 ↓ 0.0 0 1

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

  • Index Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
34. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
35. 0.019 0.019 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
  • Rows Removed by Filter: 68
36. 0.006 0.006 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
  • Rows Removed by Filter: 3
37. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m08_n_mobject_id_n_value_time_idx 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_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
38. 0.010 0.010 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
  • Rows Removed by Filter: 7
39. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
40. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m11_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m11 (cost=0.14..8.17 rows=1 width=2,204) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
41. 0.038 0.038 ↓ 0.0 0 1

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

  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060) AND (n_event_type = 1))
  • Rows Removed by Filter: 172
42. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y9999m99 (cost=4.30..11.43 rows=1 width=2,204) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (n_mobject_id = 1060)
  • Filter: ((n_reg_date > '2019-01-01 00:00:00'::timestamp without time zone) AND (n_reg_date < '2019-01-11 00:00:00'::timestamp without time zone) AND (n_event_type = 1))
43. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_notification_temp_y9999m99_n_mobject_id_n_value_time_idx (cost=0.00..4.30 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (n_mobject_id = 1060)