explain.depesz.com

PostgreSQL's explain analyze made readable

Result: URXo : 123123

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

Aggregate (cost=124.39..124.40 rows=1 width=8) (actual time=0.838..0.838 rows=1 loops=1)

2. 0.005 0.835 ↓ 0.0 0 1

Append (cost=0.00..124.32 rows=26 width=0) (actual time=0.835..0.835 rows=0 loops=1)

3. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on uzgps_notification (cost=0.00..0.00 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_mobject_id = 1060))
4. 0.029 0.029 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m01_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m01 (cost=0.43..4.46 rows=1 width=0) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
5. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m02_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m02 (cost=0.56..4.58 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
6. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m03_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m03 (cost=0.56..4.59 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
7. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m04_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m04 (cost=0.56..4.58 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
8. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m05_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m05 (cost=0.56..4.59 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
9. 0.019 0.019 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m06_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m06 (cost=0.56..4.59 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
10. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m07_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m07 (cost=0.56..4.61 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
11. 0.019 0.019 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m08_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m08 (cost=0.56..4.61 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
12. 0.020 0.020 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m09_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m09 (cost=0.56..4.59 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
13. 0.027 0.027 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m10_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m10 (cost=0.56..4.58 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
14. 0.027 0.027 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m11_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m11 (cost=0.56..4.61 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
15. 0.027 0.027 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2018m12_n_status_n_event_type_n_tp_tim on uzgps_notification_y2018m12 (cost=0.56..4.61 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
16. 0.436 0.436 ↓ 0.0 0 1

Index Scan using uzgps_notification_y2019m01_n_event_type_n_tp_time_n_mobjec_idx on uzgps_notification_y2019m01 (cost=0.43..10.15 rows=1 width=0) (actual time=0.435..0.436 rows=0 loops=1)

  • Index Cond: ((n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Filter: (n_status = 'A'::bpchar)
17. 0.041 0.041 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m02 (cost=0.00..3.82 rows=1 width=0) (actual time=0.041..0.041 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_mobject_id = 1060))
  • Rows Removed by Filter: 81
18. 0.007 0.007 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m03_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m03 (cost=0.14..4.17 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
19. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m04_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m04 (cost=0.14..8.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
20. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m05_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m05 (cost=0.14..8.16 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
21. 0.027 0.027 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m06 (cost=0.00..3.53 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_mobject_id = 1060))
  • Rows Removed by Filter: 68
22. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m07 (cost=0.00..1.07 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_mobject_id = 1060))
  • Rows Removed by Filter: 3
23. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m08_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m08 (cost=0.14..8.16 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
24. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on uzgps_notification_y2019m09 (cost=0.00..1.16 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_mobject_id = 1060))
  • Rows Removed by Filter: 7
25. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m10_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m10 (cost=0.14..8.16 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
26. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m11_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m11 (cost=0.27..4.30 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
27. 0.005 0.005 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y2019m12_n_status_n_event_type_n_tp_tim on uzgps_notification_y2019m12 (cost=0.14..4.17 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0
28. 0.009 0.009 ↓ 0.0 0 1

Index Only Scan using uzgps_notification_temp_y9999m99_n_status_n_event_type_n_tp_tim on uzgps_notification_y9999m99 (cost=0.28..4.30 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((n_status = 'A'::bpchar) AND (n_event_type = 1) AND (n_tp_time > '2019-01-09 12:00:00'::timestamp without time zone) AND (n_tp_time <= '2019-01-10 00:00:00'::timestamp without time zone) AND (n_mobject_id = 1060))
  • Heap Fetches: 0