explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yinj : 12312

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.448 ↑ 1.0 1 1

3"Result (cost=9.54..9.55 rows=1 width=8) (actual time=0.448..0.448 rows=1 loops=1)

2.          

Initplan (for3"Result)

3. 0.007 0.445 ↑ 1.0 1 1

Limit (cost=9.44..9.54 rows=1 width=8) (actual time=0.440..0.445 rows=1 loops=1)

4. 0.000 0.438 ↑ 647,208.0 1 1

Merge Append (cost=9.44..64,377.24 rows=647,208 width=8) (actual time=0.438..0.438 rows=1 loops=1)

  • Sort Key: uzgps_notification.n_value_time DESC
5. 0.011 0.011 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_n_contract_id_n_value_time_idx on uzgps_notification (cost=0.12..8.14 rows=1 width=8) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
6. 0.030 0.030 ↑ 8,711.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m01_n_contract_id_n_value_time_idx on uzgps_notification_y2018m01 (cost=0.43..422.65 rows=8,711 width=8) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
7. 0.024 0.024 ↑ 19,868.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m02_n_contract_id_n_value_time_idx on uzgps_notification_y2018m02 (cost=0.43..969.79 rows=19,868 width=8) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
8. 0.021 0.021 ↑ 44,654.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m03_n_contract_id_n_value_time_idx on uzgps_notification_y2018m03 (cost=0.56..2,173.64 rows=44,654 width=8) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
9. 0.031 0.031 ↑ 36,265.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m04_n_contract_id_n_value_time_idx on uzgps_notification_y2018m04 (cost=0.56..1,773.86 rows=36,265 width=8) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
10. 0.029 0.029 ↑ 53,013.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m05_n_contract_id_n_value_time_idx on uzgps_notification_y2018m05 (cost=0.56..2,600.82 rows=53,013 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
11. 0.029 0.029 ↑ 44,022.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m06_n_contract_id_n_value_time_idx on uzgps_notification_y2018m06 (cost=0.56..2,161.00 rows=44,022 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
12. 0.022 0.022 ↑ 68,970.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m07_n_contract_id_n_value_time_idx on uzgps_notification_y2018m07 (cost=0.56..3,363.96 rows=68,970 width=8) (actual time=0.022..0.022 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
13. 0.030 0.030 ↑ 85,292.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m08_n_contract_id_n_value_time_idx on uzgps_notification_y2018m08 (cost=0.56..4,098.40 rows=85,292 width=8) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
14. 0.039 0.039 ↑ 48,552.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m09_n_contract_id_n_value_time_idx on uzgps_notification_y2018m09 (cost=0.56..2,343.60 rows=48,552 width=8) (actual time=0.038..0.039 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
15. 0.030 0.030 ↑ 34,013.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m10_n_contract_id_n_value_time_idx on uzgps_notification_y2018m10 (cost=0.56..1,648.82 rows=34,013 width=8) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
16. 0.029 0.029 ↑ 92,041.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m11_n_contract_id_n_value_time_idx on uzgps_notification_y2018m11 (cost=0.56..4,477.38 rows=92,041 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
17. 0.028 0.028 ↑ 89,132.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2018m12_n_contract_id_n_value_time_idx on uzgps_notification_y2018m12 (cost=0.56..4,339.20 rows=89,132 width=8) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
18. 0.033 0.033 ↑ 22,660.0 1 1

Index Only Scan Backward using uzgps_notification_temp_y2019m01_n_contract_id_n_value_time_idx on uzgps_notification_y2019m01 (cost=0.43..1,889.63 rows=22,660 width=8) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 1
19. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m02_n_contract_id_n_value_time_idx on uzgps_notification_y2019m02 (cost=0.14..4.16 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
20. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m03_n_contract_id_n_value_time_idx on uzgps_notification_y2019m03 (cost=0.14..4.16 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
21. 0.004 0.004 ↓ 0.0 0 1

Index Only 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=8) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
22. 0.002 0.002 ↓ 0.0 0 1

Index Only 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=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
23. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m06_n_contract_id_n_value_time_idx on uzgps_notification_y2019m06 (cost=0.14..4.16 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
24. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m07_n_contract_id_n_value_time_idx on uzgps_notification_y2019m07 (cost=0.13..4.15 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
25. 0.002 0.002 ↓ 0.0 0 1

Index Only 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=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
26. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m09_n_contract_id_n_value_time_idx on uzgps_notification_y2019m09 (cost=0.13..4.15 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
27. 0.003 0.003 ↓ 0.0 0 1

Index Only 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=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
28. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m11_n_contract_id_n_value_time_idx on uzgps_notification_y2019m11 (cost=0.14..4.16 rows=1 width=8) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
29. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y2019m12_n_contract_id_n_value_time_idx on uzgps_notification_y2019m12 (cost=0.14..4.16 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0
30. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan Backward using uzgps_notification_temp_y9999m99_n_contract_id_n_value_time_idx on uzgps_notification_y9999m99 (cost=0.28..4.34 rows=3 width=8) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: ((n_contract_id = 12) AND (n_value_time IS NOT NULL))
  • Heap Fetches: 0