explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1JFZ

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

Unique (cost=1,993.98..1,993.99 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,993.98..1,993.99 rows=1 width=8) (actual rows= loops=)

  • Sort Key: (count(DISTINCT receipt0_.id))
3. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,993.96..1,993.97 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,170.22..1,993.96 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,170.22..1,873.58 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (receipt0_.fk_operationalunit = operationa2_.id)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.81..470.21 rows=1 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on businessunit businessun1_ (cost=9.81..223.65 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (fk_client = '2335925425'::bigint)
  • Filter: ((mod(fk_client, '10'::bigint) = 5) AND (id = ANY ('{4209113447,3946358637,4154609983,3689379102,4171497798,4263690244,2899595972,415461357
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on businessunit_fk_client_key (cost=0.00..9.81 rows=204 width=0) (actual rows= loops=)

  • Index Cond: (fk_client = '2335925425'::bigint)
9. 0.000 0.000 ↓ 0.0

Append (cost=0.00..246.36 rows=21 width=24) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on receipt receipt0_ (cost=0.00..0.00 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
11. 0.000 0.000 ↓ 0.0

Index Scan using receipt_0_fk_client_fk_businessunit_r_time_idx on receipt_0 receipt0__1 (cost=0.27..8.30 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
12. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_1 receipt0__2 (cost=0.00..2.52 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
13. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_2 receipt0__3 (cost=0.00..1.32 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
14. 0.000 0.000 ↓ 0.0

Index Scan using receipt_3_fk_client_fk_businessunit_r_time_idx on receipt_3 receipt0__4 (cost=0.27..8.30 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
15. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_4 receipt0__5 (cost=0.00..1.27 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
16. 0.000 0.000 ↓ 0.0

Index Scan using receipt_5_fk_client_fk_businessunit_r_time_idx on receipt_5 receipt0__6 (cost=0.28..8.31 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
17. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_6 receipt0__7 (cost=0.00..1.25 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
18. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_7 receipt0__8 (cost=0.00..1.27 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
19. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_8 receipt0__9 (cost=0.00..1.07 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
20. 0.000 0.000 ↓ 0.0

Seq Scan on receipt_9 receipt0__10 (cost=0.00..1.25 rows=1 width=24) (actual rows= loops=)

  • Filter: ((r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999'::timestamp without time zone
21. 0.000 0.000 ↓ 0.0

Index Scan using receipt_0_2018_fk_client_fk_businessunit_r_time_idx on receipt_0_2018 receipt0__11 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
22. 0.000 0.000 ↓ 0.0

Index Scan using receipt_1_2018_fk_client_fk_businessunit_r_time_idx on receipt_1_2018 receipt0__12 (cost=0.56..8.57 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
23. 0.000 0.000 ↓ 0.0

Index Scan using receipt_2_2018_fk_client_fk_businessunit_r_time_idx on receipt_2_2018 receipt0__13 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (fk_businessunit = businessun1_.id) AND (r_time >= '2018-12-03 05:00:00'::timestamp witho
  • Filter: (mod(fk_client, '10'::bigint) = 5)
24. 0.000 0.000 ↓ 0.0

Index Scan using receipt_3_2018_fk_client_fk_businessunit_r_time_idx on receipt_3_2018 receipt0__14 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (fk_businessunit = businessun1_.id) AND (r_time >= '2018-12-03 05:00:00'::timestamp witho
  • Filter: (mod(fk_client, '10'::bigint) = 5)
25. 0.000 0.000 ↓ 0.0

Index Scan using receipt_4_2018_fk_client_fk_businessunit_r_time_idx on receipt_4_2018 receipt0__15 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999':
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
26. 0.000 0.000 ↓ 0.0

Index Scan using receipt_5_2018_fk_client_fk_businessunit_r_time_idx on receipt_5_2018 receipt0__16 (cost=0.56..134.19 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (fk_businessunit = businessun1_.id) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) A
  • Filter: (mod(fk_client, '10'::bigint) = 5)
27. 0.000 0.000 ↓ 0.0

Index Scan using receipt_6_2018_fk_client_fk_businessunit_r_time_idx on receipt_6_2018 receipt0__17 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (fk_businessunit = businessun1_.id) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) A
  • Filter: (mod(fk_client, '10'::bigint) = 5)
28. 0.000 0.000 ↓ 0.0

Index Scan using receipt_7_2018_fk_client_fk_businessunit_r_time_idx on receipt_7_2018 receipt0__18 (cost=0.56..8.57 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999':
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
29. 0.000 0.000 ↓ 0.0

Index Scan using receipt_8_2018_fk_client_fk_businessunit_r_time_idx on receipt_8_2018 receipt0__19 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999':
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
30. 0.000 0.000 ↓ 0.0

Index Scan using receipt_9_2018_fk_client_fk_businessunit_r_time_idx on receipt_9_2018 receipt0__20 (cost=0.56..8.59 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (r_time >= '2018-12-03 05:00:00'::timestamp without time zone) AND (r_time <= '2018-12-04 04:59:59.999':
  • Filter: ((businessun1_.id = fk_businessunit) AND (mod(fk_client, '10'::bigint) = 5))
31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on operationalunit operationa2_ (cost=1,160.41..1,403.36 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (id = ANY ('{4209113448,3946358638,4154609984,3689379103,4171497799,4263690245,2899595973,4154613579,2479819438,4239082626,4201331129,4085028878,418289810
  • Filter: ((fk_client = '2335925425'::bigint) AND (mod(fk_client, '10'::bigint) = 5))
32. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on operationalunit_pkey (cost=0.00..1,160.41 rows=391 width=0) (actual rows= loops=)

  • Index Cond: (id = ANY ('{4209113448,3946358638,4154609984,3689379103,4171497799,4263690245,2899595973,4154613579,2479819438,4239082626,4201331129,4085028878,41828
33. 0.000 0.000 ↓ 0.0

Append (cost=0.00..120.17 rows=21 width=8) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction transactio3_ (cost=0.00..0.00 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
35. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_0_fk_receipt_idx on receipttransaction_0 transactio3__1 (cost=0.28..7.27 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
36. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_1 transactio3__2 (cost=0.00..1.27 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
37. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_2 transactio3__3 (cost=0.00..1.19 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
38. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_3_fk_client_rt_time_idx on receipttransaction_3 transactio3__4 (cost=0.27..7.06 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp
  • Filter: ((fk_transactiontype = '2420486533'::bigint) AND (receipt0_.id = fk_receipt) AND (mod(fk_client, '10'::bigint) = 5))
39. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_4 transactio3__5 (cost=0.00..2.77 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
40. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_5_fk_receipt_idx on receipttransaction_5 transactio3__6 (cost=0.28..5.66 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
41. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_6 transactio3__7 (cost=0.00..1.14 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
42. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_7 transactio3__8 (cost=0.00..1.22 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
43. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_8 transactio3__9 (cost=0.00..1.08 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
44. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_9 transactio3__10 (cost=0.00..1.25 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
45. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_0_2018_fk_client_rt_time_idx on receipttransaction_0_2018 transactio3__11 (cost=0.56..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp
  • Filter: ((fk_transactiontype = '2420486533'::bigint) AND (receipt0_.id = fk_receipt) AND (mod(fk_client, '10'::bigint) = 5))
46. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_1_2018_fk_receipt_idx on receipttransaction_1_2018 transactio3__12 (cost=0.43..9.20 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
47. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_1 transactio3__2 (cost=0.00..1.27 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
48. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_2 transactio3__3 (cost=0.00..1.19 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
49. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_3_fk_client_rt_time_idx on receipttransaction_3 transactio3__4 (cost=0.27..7.06 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp
  • Filter: ((fk_transactiontype = '2420486533'::bigint) AND (receipt0_.id = fk_receipt) AND (mod(fk_client, '10'::bigint) = 5))
50. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_4 transactio3__5 (cost=0.00..2.77 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
51. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_5_fk_receipt_idx on receipttransaction_5 transactio3__6 (cost=0.28..5.66 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
52. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_6 transactio3__7 (cost=0.00..1.14 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
53. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_7 transactio3__8 (cost=0.00..1.22 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
54. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_8 transactio3__9 (cost=0.00..1.08 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
55. 0.000 0.000 ↓ 0.0

Seq Scan on receipttransaction_9 transactio3__10 (cost=0.00..1.25 rows=1 width=8) (actual rows= loops=)

  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
56. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_0_2018_fk_client_rt_time_idx on receipttransaction_0_2018 transactio3__11 (cost=0.56..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp
  • Filter: ((fk_transactiontype = '2420486533'::bigint) AND (receipt0_.id = fk_receipt) AND (mod(fk_client, '10'::bigint) = 5))
57. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_1_2018_fk_receipt_idx on receipttransaction_1_2018 transactio3__12 (cost=0.43..9.20 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
58. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_2_2018_fk_receipt_idx on receipttransaction_2_2018 transactio3__13 (cost=0.43..9.82 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
59. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_3_2018_fk_receipt_idx on receipttransaction_3_2018 transactio3__14 (cost=0.43..9.27 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
60. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_4_2018_fk_client_rt_time_idx on receipttransaction_4_2018 transactio3__15 (cost=0.56..8.51 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp
  • Filter: ((fk_transactiontype = '2420486533'::bigint) AND (receipt0_.id = fk_receipt) AND (mod(fk_client, '10'::bigint) = 5))
61. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_5_2018_fk_receipt_idx on receipttransaction_5_2018 transactio3__16 (cost=0.43..9.82 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
62. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_6_2018_fk_receipt_idx on receipttransaction_6_2018 transactio3__17 (cost=0.43..8.72 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
63. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_7_2018_fk_receipt_idx on receipttransaction_7_2018 transactio3__18 (cost=0.43..9.15 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
64. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_8_2018_fk_receipt_idx on receipttransaction_8_2018 transactio3__19 (cost=0.43..8.73 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (fk_receipt = receipt0_.id)
  • Filter: ((rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp without time zone) AND (fk_client = '23359
65. 0.000 0.000 ↓ 0.0

Index Scan using receipttransaction_9_2018_fk_client_rt_time_idx on receipttransaction_9_2018 transactio3__20 (cost=0.56..8.59 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((fk_client = '2335925425'::bigint) AND (rt_time >= '2018-10-23 05:00:00'::timestamp without time zone) AND (rt_time <= '2018-12-04 04:59:59.999'::timestamp
  • Filter: ((fk_transactiontype = '2420486533'::bigint) AND (receipt0_.id = fk_receipt) AND (mod(fk_client, '10'::bigint) = 5))