explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gVq8 : 234234

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.436 ↑ 1.0 100 1

Limit (cost=2.63..393.06 rows=100 width=2,204) (actual time=0.108..0.436 rows=100 loops=1)

2. 0.010 0.422 ↑ 76.0 100 1

Merge Append (cost=2.63..29,683.11 rows=7,602 width=2,204) (actual time=0.107..0.422 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_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))
4. 0.354 0.354 ↑ 75.9 100 1

Index Scan Backward using uzgps_notification_temp_y2019m01_n_contract_id_n_value_time_idx on uzgps_notification_y2019m01 (cost=0.43..29,268.21 rows=7,589 width=2,204) (actual time=0.050..0.354 rows=100 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))
5. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m02_n_contract_id_n_value_time_idx on uzgps_notification_y2019m02 (cost=0.14..8.16 rows=1 width=2,204) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time > '2019-01-01 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_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))
7. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: ((n_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))
8. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m05_n_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 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_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 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_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))
11. 0.002 0.002 ↓ 0.0 0 1

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

  • Index Cond: ((n_contract_id = 12) AND (n_value_time > '2019-01-01 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_contract_id_n_value_time_idx on uzgps_notification_y2019m09 (cost=0.13..8.15 rows=1 width=2,204) (actual time=0.003..0.004 rows=0 loops=1)

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

Index Scan Backward using uzgps_notification_temp_y2019m10_n_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))
14. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using uzgps_notification_temp_y2019m11_n_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 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_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 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_contract_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_contract_id = 12) AND (n_value_time > '2019-01-01 00:00:00'::timestamp without time zone))