explain.depesz.com

PostgreSQL's explain analyze made readable

Result: akqo

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 14.003 ↑ 34.0 1 1

Unique (cost=18,729.67..18,730.52 rows=34 width=117) (actual time=14.003..14.003 rows=1 loops=1)

2. 0.016 14.002 ↑ 34.0 1 1

Sort (cost=18,729.67..18,729.76 rows=34 width=117) (actual time=14.002..14.002 rows=1 loops=1)

  • Sort Key: t1.last_modified, t1.id, t1.created, t1.state, t2ar.reference, t3.value, t4.value, t5.value, t6.state
  • Sort Method: quicksort Memory: 25kB
3. 0.000 13.986 ↑ 34.0 1 1

Nested Loop (cost=1,001.26..18,728.81 rows=34 width=117) (actual time=5.089..13.986 rows=1 loops=1)

4. 0.006 0.033 ↑ 1.0 1 1

Nested Loop (cost=0.56..12.60 rows=1 width=13) (actual time=0.030..0.033 rows=1 loops=1)

5. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_agent_ref on agent_ref t2ar (cost=0.28..8.30 rows=1 width=18) (actual time=0.017..0.019 rows=1 loops=1)

  • Index Cond: (id = '133'::numeric)
6. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using ixabidac on agent_body t2ab (cost=0.28..4.30 rows=1 width=5) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = t2ar.bodyid)
  • Heap Fetches: 1
7. 13.947 15.249 ↑ 34.0 1 1

Gather (cost=1,000.70..18,715.87 rows=34 width=125) (actual time=5.058..15.249 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
8. 0.003 1.302 ↓ 0.0 0 2 / 2

Nested Loop Left Join (cost=0.70..17,712.47 rows=20 width=125) (actual time=0.655..1.302 rows=0 loops=2)

9. 0.002 1.150 ↓ 0.0 0 2 / 2

Nested Loop Left Join (cost=0.55..16,635.66 rows=20 width=105) (actual time=0.631..1.150 rows=0 loops=2)

10. 0.003 1.004 ↓ 0.0 0 2 / 2

Nested Loop Left Join (cost=0.41..15,558.85 rows=20 width=85) (actual time=0.605..1.004 rows=0 loops=2)

11. 0.003 0.861 ↓ 0.0 0 2 / 2

Nested Loop Left Join (cost=0.27..14,482.04 rows=20 width=65) (actual time=0.575..0.861 rows=0 loops=2)

12. 0.293 0.703 ↓ 0.0 0 2 / 2

Append (cost=0.12..12,821.28 rows=31 width=58) (actual time=0.544..0.703 rows=0 loops=2)

  • -> Parallel Bitmap Heap Scan on trans_20200701 t1_3 (cost=62.71..4817.22 rows=1 width=32) (actual time=0.146..0.282rows=0 loops=2)
13. 0.003 0.003 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20200401 on trans_20200401 t1 (cost=0.12..8.14 rows=1 width=68) (actual time=0.002..0.003 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
14. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20200501 on trans_20200501 t1_1 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
15. 0.000 0.386 ↓ 0.0 0 2 / 2

Parallel Bitmap Heap Scan on trans_20200601 t1_2 (cost=217.88..7,800.56 rows=5 width=32) (actual time=0.386..0.386 rows=0 loops=2)

  • Recheck Cond: ((agentid = '133'::numeric) AND (last_modified >= '2020-06-25 00:00:00'::timestamp without time zone))
  • Filter: ((type)::text = 'create_batch'::text)
  • Rows Removed by Filter: 10
  • Heap Blocks: exact=3
  • Recheck Cond: ((agentid = '133'::numeric) AND (last_modified >= '2020-06-25 00:00:00'::timestamp without time zone))
  • Filter: ((type)::text = 'create_batch'::text)
  • Rows Removed by Filter: 814
  • Heap Blocks: exact=182
16. 0.367 0.367 ↑ 147.2 19 1 / 2

Bitmap Index Scan on adhoc_20200601 (cost=0.00..217.88 rows=2,797 width=0) (actual time=0.734..0.734 rows=19 loops=1)

  • Index Cond: ((agentid = '133'::numeric) AND (last_modified >= '2020-06-25 00:00:00'::timestamp without time zone))
17. 0.092 0.092 ↑ 1.1 1,629 1 / 2

Bitmap Index Scan on adhoc_20200701 (cost=0.00..62.70 rows=1,828 width=0) (actual time=0.184..0.184 rows=1,629 loops=1)

  • Index Cond: ((agentid = '133'::numeric) AND (last_modified >= '2020-06-25 00:00:00'::timestamp without time zone))
18. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20200801 on trans_20200801 t1_4 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
19. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20200901 on trans_20200901 t1_5 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
20. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20201001 on trans_20201001 t1_6 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
21. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20201101 on trans_20201101 t1_7 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
22. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20201201 on trans_20201201 t1_8 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
23. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210101 on trans_20210101 t1_9 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
24. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210201 on trans_20210201 t1_10 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
25. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210301 on trans_20210301 t1_11 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
26. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210401 on trans_20210401 t1_12 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
27. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210501 on trans_20210501 t1_13 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
28. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210601 on trans_20210601 t1_14 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
29. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210701 on trans_20210701 t1_15 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
30. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210801 on trans_20210801 t1_16 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
31. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20210901 on trans_20210901 t1_17 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
32. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20211001 on trans_20211001 t1_18 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
33. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20211101 on trans_20211101 t1_19 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
34. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20211201 on trans_20211201 t1_20 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
35. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20220101 on trans_20220101 t1_21 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
36. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20220201 on trans_20220201 t1_22 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
37. 0.000 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20220301 on trans_20220301 t1_23 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
38. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20220401 on trans_20220401 t1_24 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
39. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20220501 on trans_20220501 t1_25 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
40. 0.001 0.001 ↓ 0.0 0 2 / 2

Parallel Index Scan using pk_trans_20220601 on trans_20220601 t1_26 (cost=0.12..8.14 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=2)

  • Filter: ((last_modified >= '2020-06-25 00:00:00'::timestamp without time zone) AND (agentid = '133'::numeric) AND ((type)::text = 'create_batch'::text))
41. 0.151 0.155 ↑ 27.0 1 1 / 2

Append (cost=0.14..53.30 rows=27 width=18) (actual time=0.057..0.311 rows=1 loops=1)

  • -> Index Scan using ixtettrlku_20200501 on trans_ext_trans_20200501 t6_1 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.011..0.011 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20200601 on trans_ext_trans_20200601 t6_2 (cost=0.42..8.45 rows=1 width=10) (actualtime=0.015..0.015 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20200701 on trans_ext_trans_20200701 t6_3 (cost=0.42..8.44 rows=1 width=11) (actualtime=0.014..0.016 rows=1 loops=1)
  • -> Index Scan using ixtettrlku_20200801 on trans_ext_trans_20200801 t6_4 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.011..0.011 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20200901 on trans_ext_trans_20200901 t6_5 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20201001 on trans_ext_trans_20201001 t6_6 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.009..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20201101 on trans_ext_trans_20201101 t6_7 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20201201 on trans_ext_trans_20201201 t6_8 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.009..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210101 on trans_ext_trans_20210101 t6_9 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.009..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210201 on trans_ext_trans_20210201 t6_10 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.010..0.011 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210301 on trans_ext_trans_20210301 t6_11 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210401 on trans_ext_trans_20210401 t6_12 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210501 on trans_ext_trans_20210501 t6_13 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210601 on trans_ext_trans_20210601 t6_14 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.009..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210701 on trans_ext_trans_20210701 t6_15 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.010..0.010 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210801 on trans_ext_trans_20210801 t6_16 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.011..0.011 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20210901 on trans_ext_trans_20210901 t6_17 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.009..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20211001 on trans_ext_trans_20211001 t6_18 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20211101 on trans_ext_trans_20211101 t6_19 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20211201 on trans_ext_trans_20211201 t6_20 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20220101 on trans_ext_trans_20220101 t6_21 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20220201 on trans_ext_trans_20220201 t6_22 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.013..0.013 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20220301 on trans_ext_trans_20220301 t6_23 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20220401 on trans_ext_trans_20220401 t6_24 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20220501 on trans_ext_trans_20220501 t6_25 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.009..0.009 rows=0 loops=1)
  • -> Index Scan using ixtettrlku_20220601 on trans_ext_trans_20220601 t6_26 (cost=0.14..1.46 rows=1 width=32) (actualtime=0.008..0.008 rows=0 loops=1)
42. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using ixtettrlku_20200401 on trans_ext_trans_20200401 t6 (cost=0.14..1.46 rows=1 width=32) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Rows Removed by Filter: 1
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
  • Index Cond: (t1.id = transid)
  • Filter: ((type)::text = 'WT_CONFIRM'::text)
43. 0.026 0.141 ↑ 27.0 1 1 / 2

Append (cost=0.14..53.57 rows=27 width=26) (actual time=0.057..0.281 rows=1 loops=1)

44. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200401 on trans_data_20200401 t3 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
45. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200501 on trans_data_20200501 t3_1 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
46. 0.007 0.007 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200601 on trans_data_20200601 t3_2 (cost=0.56..8.58 rows=1 width=23) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
47. 0.009 0.009 ↑ 1.0 1 1 / 2

Index Scan using pk_trans_data_20200701 on trans_data_20200701 t3_3 (cost=0.56..8.58 rows=1 width=24) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
48. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200801 on trans_data_20200801 t3_4 (cost=0.14..1.46 rows=1 width=536) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
49. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200901 on trans_data_20200901 t3_5 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
50. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201001 on trans_data_20201001 t3_6 (cost=0.14..1.46 rows=1 width=536) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
51. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201101 on trans_data_20201101 t3_7 (cost=0.14..1.46 rows=1 width=536) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
52. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201201 on trans_data_20201201 t3_8 (cost=0.14..1.46 rows=1 width=536) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
53. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210101 on trans_data_20210101 t3_9 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
54. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210201 on trans_data_20210201 t3_10 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
55. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210301 on trans_data_20210301 t3_11 (cost=0.14..1.46 rows=1 width=536) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
56. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210401 on trans_data_20210401 t3_12 (cost=0.14..1.46 rows=1 width=536) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
57. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210501 on trans_data_20210501 t3_13 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
58. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210601 on trans_data_20210601 t3_14 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
59. 0.005 0.005 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210701 on trans_data_20210701 t3_15 (cost=0.14..1.46 rows=1 width=536) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
60. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210801 on trans_data_20210801 t3_16 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
61. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210901 on trans_data_20210901 t3_17 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
62. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20211001 on trans_data_20211001 t3_18 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
63. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20211101 on trans_data_20211101 t3_19 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
64. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20211201 on trans_data_20211201 t3_20 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
65. 0.011 0.011 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220101 on trans_data_20220101 t3_21 (cost=0.14..1.46 rows=1 width=536) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
66. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220201 on trans_data_20220201 t3_22 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
67. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220301 on trans_data_20220301 t3_23 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
68. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220401 on trans_data_20220401 t3_24 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
69. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220501 on trans_data_20220501 t3_25 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
70. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220601 on trans_data_20220601 t3_26 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'batch_type'::text))
71. 0.028 0.144 ↑ 27.0 1 1 / 2

Append (cost=0.14..53.57 rows=27 width=26) (actual time=0.046..0.288 rows=1 loops=1)

72. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200401 on trans_data_20200401 t4 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
73. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200501 on trans_data_20200501 t4_1 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
74. 0.005 0.005 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200601 on trans_data_20200601 t4_2 (cost=0.56..8.58 rows=1 width=23) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
75. 0.005 0.005 ↑ 1.0 1 1 / 2

Index Scan using pk_trans_data_20200701 on trans_data_20200701 t4_3 (cost=0.56..8.58 rows=1 width=24) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
76. 0.006 0.006 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200801 on trans_data_20200801 t4_4 (cost=0.14..1.46 rows=1 width=536) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
77. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200901 on trans_data_20200901 t4_5 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
78. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201001 on trans_data_20201001 t4_6 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
79. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201101 on trans_data_20201101 t4_7 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
80. 0.006 0.006 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201201 on trans_data_20201201 t4_8 (cost=0.14..1.46 rows=1 width=536) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
81. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210101 on trans_data_20210101 t4_9 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
82. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210201 on trans_data_20210201 t4_10 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
83. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210301 on trans_data_20210301 t4_11 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
84. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210401 on trans_data_20210401 t4_12 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
85. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210501 on trans_data_20210501 t4_13 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
86. 0.005 0.005 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210601 on trans_data_20210601 t4_14 (cost=0.14..1.46 rows=1 width=536) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
87. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210701 on trans_data_20210701 t4_15 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
88. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210801 on trans_data_20210801 t4_16 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
89. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210901 on trans_data_20210901 t4_17 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
90. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20211001 on trans_data_20211001 t4_18 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
91. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20211101 on trans_data_20211101 t4_19 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
92. 0.005 0.005 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20211201 on trans_data_20211201 t4_20 (cost=0.14..1.46 rows=1 width=536) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
93. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220101 on trans_data_20220101 t4_21 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
94. 0.005 0.005 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220201 on trans_data_20220201 t4_22 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.010 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
95. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220301 on trans_data_20220301 t4_23 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
96. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220401 on trans_data_20220401 t4_24 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
97. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220501 on trans_data_20220501 t4_25 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
98. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20220601 on trans_data_20220601 t4_26 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'ip_address'::text))
99. 0.106 0.149 ↑ 27.0 1 1 / 2

Append (cost=0.14..53.57 rows=27 width=26) (actual time=0.045..0.298 rows=1 loops=1)

  • -> Index Scan using pk_trans_data_20210201 on trans_data_20210201 t5_10 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210301 on trans_data_20210301 t5_11 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210401 on trans_data_20210401 t5_12 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210501 on trans_data_20210501 t5_13 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210601 on trans_data_20210601 t5_14 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210701 on trans_data_20210701 t5_15 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210801 on trans_data_20210801 t5_16 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.009rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20210901 on trans_data_20210901 t5_17 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20211001 on trans_data_20211001 t5_18 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20211101 on trans_data_20211101 t5_19 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20211201 on trans_data_20211201 t5_20 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20220101 on trans_data_20220101 t5_21 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20220201 on trans_data_20220201 t5_22 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20220301 on trans_data_20220301 t5_23 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20220401 on trans_data_20220401 t5_24 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20220501 on trans_data_20220501 t5_25 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
  • -> Index Scan using pk_trans_data_20220601 on trans_data_20220601 t5_26 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008rows=0 loops=1)
100. 0.003 0.003 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200401 on trans_data_20200401 t5 (cost=0.14..1.46 rows=1 width=536) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
101. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200501 on trans_data_20200501 t5_1 (cost=0.14..1.46 rows=1 width=536) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
102. 0.006 0.006 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200601 on trans_data_20200601 t5_2 (cost=0.56..8.58 rows=1 width=23) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
103. 0.005 0.005 ↑ 1.0 1 1 / 2

Index Scan using pk_trans_data_20200701 on trans_data_20200701 t5_3 (cost=0.56..8.58 rows=1 width=24) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
104. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200801 on trans_data_20200801 t5_4 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
105. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20200901 on trans_data_20200901 t5_5 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
106. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201001 on trans_data_20201001 t5_6 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
107. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201101 on trans_data_20201101 t5_7 (cost=0.14..1.46 rows=1 width=536) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
108. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20201201 on trans_data_20201201 t5_8 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
109. 0.004 0.004 ↓ 0.0 0 1 / 2

Index Scan using pk_trans_data_20210101 on trans_data_20210101 t5_9 (cost=0.14..1.46 rows=1 width=536) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))
  • Index Cond: ((t1.id = transid) AND ((td_key)::text = 'filename'::text))