explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D7tn : 234234

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 234.893 ↓ 0.0 0 1

Limit (cost=1,375,800.15..1,375,800.23 rows=30 width=2,204) (actual time=234.892..234.893 rows=0 loops=1)

2. 0.008 234.891 ↓ 0.0 0 1

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

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

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

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on uzgps_notification (cost=0.00..0.00 rows=1 width=2,204) (actual time=0.001..0.001 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. 1.503 1.658 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m01 (cost=310.09..19,176.53 rows=1 width=2,204) (actual time=1.658..1.658 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.155 0.155 ↑ 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.154..0.155 rows=867 loops=1)

  • Index Cond: (n_mobject_id = 1060)
7. 8.086 8.689 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y2018m02 (cost=718.18..43,723.84 rows=1 width=2,204) (actual time=8.689..8.689 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. 0.603 0.603 ↑ 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=0.603..0.603 rows=3,253 loops=1)

  • Index Cond: (n_mobject_id = 1060)
9. 21.933 24.632 ↓ 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=24.632..24.632 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.699 2.699 ↑ 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.699..2.699 rows=7,746 loops=1)

  • Index Cond: (n_mobject_id = 1060)
11. 16.940 18.720 ↓ 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=18.720..18.720 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.780 1.780 ↑ 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.780..1.780 rows=6,208 loops=1)

  • Index Cond: (n_mobject_id = 1060)
13. 31.853 35.306 ↓ 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=35.306..35.306 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.453 3.453 ↑ 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.453..3.453 rows=12,011 loops=1)

  • Index Cond: (n_mobject_id = 1060)
15. 16.976 18.597 ↓ 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=18.597..18.597 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. 1.621 1.621 ↑ 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=1.620..1.621 rows=8,491 loops=1)

  • Index Cond: (n_mobject_id = 1060)
17. 3.377 3.737 ↓ 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=3.737..3.737 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.360 0.360 ↑ 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.360..0.360 rows=1,836 loops=1)

  • Index Cond: (n_mobject_id = 1060)
19. 31.657 35.232 ↓ 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=35.232..35.232 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. 3.575 3.575 ↑ 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=3.575..3.575 rows=16,283 loops=1)

  • Index Cond: (n_mobject_id = 1060)
21. 13.058 14.292 ↓ 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=14.292..14.292 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.234 1.234 ↑ 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.234..1.234 rows=6,243 loops=1)

  • Index Cond: (n_mobject_id = 1060)
23. 5.850 6.382 ↓ 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.382..6.382 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.532 0.532 ↑ 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.532..0.532 rows=2,834 loops=1)

  • Index Cond: (n_mobject_id = 1060)
25. 33.983 36.939 ↓ 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=36.939..36.939 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. 2.956 2.956 ↑ 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=2.956..2.956 rows=15,264 loops=1)

  • Index Cond: (n_mobject_id = 1060)
27. 28.077 30.505 ↓ 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=30.505..30.505 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.428 2.428 ↑ 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.428..2.428 rows=12,552 loops=1)

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

Bitmap Heap Scan on uzgps_notification_y2019m01 (cost=5.57..450.51 rows=1 width=2,204) (actual time=0.017..0.017 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.015 0.015 ↓ 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.015..0.015 rows=0 loops=1)

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

Seq Scan on uzgps_notification_y2019m02 (cost=0.00..3.62 rows=1 width=2,204) (actual time=0.030..0.030 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.033 0.033 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m03 (cost=0.00..5.96 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: 148
33. 0.004 0.004 ↓ 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.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))
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.018 0.018 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m06 (cost=0.00..3.36 rows=1 width=2,204) (actual time=0.018..0.018 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.005 0.005 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m07 (cost=0.00..1.06 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))
  • 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.008 0.008 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m09 (cost=0.00..1.14 rows=1 width=2,204) (actual time=0.008..0.008 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.037 0.037 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m12 (cost=0.00..6.44 rows=1 width=2,204) (actual time=0.037..0.037 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.006 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_notification_y9999m99 (cost=4.30..11.43 rows=1 width=2,204) (actual time=0.006..0.006 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.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: (n_mobject_id = 1060)