explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vtjG : 234234

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.387 ↑ 1.0 100 1

Limit (cost=3.22..393.16 rows=100 width=2,204) (actual time=0.109..0.387 rows=100 loops=1)

2. 0.018 0.376 ↑ 374.6 100 1

Merge Append (cost=3.22..146,073.59 rows=37,460 width=2,204) (actual time=0.108..0.376 rows=100 loops=1)

  • Sort Key: uzgps_notification.n_value_time DESC
3. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_n_mobject_id_n_value_time_idx on uzgps_notification (cost=0.12..8.14 rows=1 width=2,204) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
4. 0.030 0.030 ↑ 29,860.0 1 1

Index Scan Backward using uzgps_notification_temp_y2018m12_n_mobject_id_n_value_time_idx on uzgps_notification_y2018m12 (cost=0.56..115,153.76 rows=29,860 width=2,204) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
5. 0.275 0.275 ↑ 75.9 100 1

Index Scan Backward using uzgps_notification_temp_y2019m01_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m01 (cost=0.43..29,256.17 rows=7,587 width=2,204) (actual time=0.023..0.275 rows=100 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
6. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m02_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m02 (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) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
7. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m03_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m03 (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) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
8. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
9. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
10. 0.005 0.005 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m06_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m06 (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) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
11. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m07_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m07 (cost=0.13..8.15 rows=1 width=2,204) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
12. 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.002..0.003 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
13. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m09_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m09 (cost=0.13..8.15 rows=1 width=2,204) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
14. 0.002 0.002 ↓ 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.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
15. 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.16 rows=1 width=2,204) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
16. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m12_n_mobject_id_n_value_time_idx on uzgps_notification_y2019m12 (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) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))
17. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y9999m99_n_mobject_id_n_value_time_idx on uzgps_notification_y9999m99 (cost=0.28..8.29 rows=1 width=2,204) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2018-12-01 00:00:00'::timestamp without time zone))