explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UpoJ0 : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.384 ↑ 1.0 100 1

Limit (cost=2.63..393.00 rows=100 width=2,204) (actual time=0.086..0.384 rows=100 loops=1)

2. 0.011 0.367 ↑ 76.0 100 1

Merge Append (cost=2.63..29,666.93 rows=7,599 width=2,204) (actual time=0.085..0.367 rows=100 loops=1)

  • Sort Key: uzgps_notification.n_value_time DESC
3. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
4. 0.303 0.303 ↑ 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,252.15 rows=7,586 width=2,204) (actual time=0.029..0.303 rows=100 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
5. 0.006 0.006 ↓ 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.006..0.006 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
6. 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 > '2019-01-09 00:00:00'::timestamp without time zone))
7. 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 > '2019-01-09 00:00:00'::timestamp without time zone))
8. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
9. 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 > '2019-01-09 00:00:00'::timestamp without time zone))
10. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
11. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

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

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
13. 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 > '2019-01-09 00:00:00'::timestamp without time zone))
14. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: ((n_mobject_id = 1060) AND (n_value_time > '2019-01-09 00:00:00'::timestamp without time zone))
15. 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 > '2019-01-09 00:00:00'::timestamp without time zone))
16. 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 > '2019-01-09 00:00:00'::timestamp without time zone))