explain.depesz.com

PostgreSQL's explain analyze made readable

Result: up3j

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 8.831 ↑ 12.0 1 1

Nested Loop (cost=87.88..161.87 rows=12 width=3,197) (actual time=8.595..8.831 rows=1 loops=1)

2. 4.374 8.775 ↑ 13.0 1 1

Hash Join (cost=87.60..156.68 rows=13 width=3,203) (actual time=8.548..8.775 rows=1 loops=1)

  • Hash Cond: ((ahp.business_key_)::text = (tic.guid)::text)
3. 4.269 4.269 ↑ 1.1 2,058 1

Seq Scan on act_hi_procinst ahp (cost=0.00..60.78 rows=2,178 width=39) (actual time=0.008..4.269 rows=2,058 loops=1)

4. 0.011 0.132 ↑ 13.0 1 1

Hash (cost=87.44..87.44 rows=13 width=3,197) (actual time=0.132..0.132 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
5. 0.032 0.121 ↑ 13.0 1 1

Append (cost=0.00..87.44 rows=13 width=3,197) (actual time=0.071..0.121 rows=1 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on t_css_ticket tic (cost=0.00..0.00 rows=1 width=3,964) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
7. 0.006 0.006 ↓ 0.0 0 1

Index Scan using t_css_ticket_201811_update_date_idx on t_css_ticket_201811 tic_1 (cost=0.14..8.16 rows=1 width=3,964) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
8. 0.003 0.003 ↓ 0.0 0 1

Index Scan using t_css_ticket_201812_update_date_idx on t_css_ticket_201812 tic_2 (cost=0.14..8.16 rows=1 width=1,978) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
9. 0.002 0.002 ↓ 0.0 0 1

Index Scan using t_css_ticket_201901_update_date_idx on t_css_ticket_201901 tic_3 (cost=0.14..8.16 rows=1 width=2,108) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
10. 0.004 0.004 ↓ 0.0 0 1

Index Scan using t_css_ticket_201902_update_date_idx on t_css_ticket_201902 tic_4 (cost=0.14..8.16 rows=1 width=3,964) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
11. 0.003 0.003 ↓ 0.0 0 1

Index Scan using t_css_ticket_201903_update_date_idx on t_css_ticket_201903 tic_5 (cost=0.14..8.16 rows=1 width=2,313) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
12. 0.003 0.003 ↓ 0.0 0 1

Index Scan using t_css_ticket_201904_update_date_idx on t_css_ticket_201904 tic_6 (cost=0.14..8.16 rows=1 width=3,964) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
13. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on t_css_ticket_201905 tic_7 (cost=0.00..1.04 rows=1 width=3,964) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
  • Rows Removed by Filter: 3
14. 0.004 0.004 ↓ 0.0 0 1

Index Scan using t_css_ticket_201906_update_date_idx on t_css_ticket_201906 tic_8 (cost=0.14..8.16 rows=1 width=1,277) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
15. 0.028 0.028 ↑ 1.0 1 1

Seq Scan on t_css_ticket_201907 tic_9 (cost=0.00..7.62 rows=1 width=3,060) (actual time=0.014..0.028 rows=1 loops=1)

  • Filter: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
  • Rows Removed by Filter: 37
16. 0.003 0.003 ↓ 0.0 0 1

Index Scan using t_css_ticket_201909_update_date_idx on t_css_ticket_201909 tic_10 (cost=0.14..8.16 rows=1 width=3,964) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
17. 0.002 0.002 ↓ 0.0 0 1

Index Scan using t_css_ticket_201910_update_date_idx on t_css_ticket_201910 tic_11 (cost=0.14..8.16 rows=1 width=3,964) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
18. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on t_css_ticket_201908 tic_12 (cost=0.00..5.36 rows=1 width=3,076) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((update_date < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (update_date > '2019-07-25 11:47:57.2'::timestamp without time zone))
  • Rows Removed by Filter: 29
19. 0.020 0.020 ↑ 1.0 1 1

Index Only Scan using act_idx_task_procinst on act_ru_task art (cost=0.28..0.39 rows=1 width=6) (actual time=0.017..0.020 rows=1 loops=1)

  • Index Cond: (proc_inst_id_ = (ahp.proc_inst_id_)::text)
  • Heap Fetches: 1
Planning time : 3.400 ms
Execution time : 9.088 ms