explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vGQj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..18.85 rows=1 width=2,762) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..16.61 rows=1 width=33) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using act_idx_task_create on act_ru_task art (cost=0.28..8.30 rows=1 width=6) (actual rows= loops=)

  • Index Cond: ((create_time_ < '2019-07-25 11:47:57.3'::timestamp without time zone) AND (create_time_ > '2019-07-25 11:47:57.2'::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0

Index Scan using act_idx_hi_pro_inst_id on act_hi_procinst ahp (cost=0.28..8.30 rows=1 width=39) (actual rows= loops=)

  • Index Cond: ((proc_inst_id_)::text = (art.proc_inst_id_)::text)
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2.11 rows=13 width=3,197) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

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

  • Filter: ((ahp.business_key_)::text = (guid)::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201811_pkey on t_css_ticket_201811 tic_1 (cost=0.14..0.18 rows=1 width=3,964) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201812_pkey on t_css_ticket_201812 tic_2 (cost=0.14..0.18 rows=1 width=1,978) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
9. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201901_pkey on t_css_ticket_201901 tic_3 (cost=0.14..0.18 rows=1 width=2,108) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
10. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201902_pkey on t_css_ticket_201902 tic_4 (cost=0.14..0.18 rows=1 width=3,964) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
11. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201903_pkey on t_css_ticket_201903 tic_5 (cost=0.14..0.18 rows=1 width=2,313) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
12. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201904_pkey on t_css_ticket_201904 tic_6 (cost=0.14..0.18 rows=1 width=3,964) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
13. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201905_pkey on t_css_ticket_201905 tic_7 (cost=0.13..0.16 rows=1 width=3,964) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
14. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201906_pkey on t_css_ticket_201906 tic_8 (cost=0.14..0.18 rows=1 width=1,277) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
15. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201907_pkey on t_css_ticket_201907 tic_9 (cost=0.14..0.18 rows=1 width=3,060) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
16. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201909_pkey on t_css_ticket_201909 tic_10 (cost=0.14..0.18 rows=1 width=3,964) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
17. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201910_pkey on t_css_ticket_201910 tic_11 (cost=0.14..0.18 rows=1 width=3,964) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)
18. 0.000 0.000 ↓ 0.0

Index Scan using t_css_ticket_201908_pkey on t_css_ticket_201908 tic_12 (cost=0.14..0.17 rows=1 width=3,076) (actual rows= loops=)

  • Index Cond: ((guid)::text = (ahp.business_key_)::text)