explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3FW

Settings
# exclusive inclusive rows x rows loops node
1. 5,187.350 92,630.550 ↑ 335.0 1,958 1

GroupAggregate (cost=2,553,166.55..2,763,056.68 rows=655,907 width=90) (actual time=78,847.066..92,630.550 rows=1,958 loops=1)

  • Group Key: (date((p.date - '05:00:00'::interval))), p.processor_id, (CASE WHEN ((p.order_capability)::text = ANY ('{mobile_app_2,mobile_app_2_cc_validator}'::text[])) THEN 'Android'::text WHEN ((p.order_capability)::text = 'mobile_app_3'::text) THEN 'iOS'::text WHEN ((p.order_capability)::text = 'mobile_app_sms'::text) THEN 'SMS'::text WHEN ((p.order_capability)::text = 'mobile_web'::text) THEN 'Mobile Web'::text WHEN (p.order_capability IS NULL) THEN 'undefined'::text ELSE initcap(replace(replace((p.order_capability)::text, '_'::text, ' '::text), '-'::text, ' '::text)) END)
2. 26,299.896 87,443.200 ↓ 1.3 8,408,594 1

Sort (cost=2,553,166.55..2,569,564.22 rows=6,559,066 width=50) (actual time=78,838.884..87,443.200 rows=8,408,594 loops=1)

  • Sort Key: (date((p.date - '05:00:00'::interval))), p.processor_id, (CASE WHEN ((p.order_capability)::text = ANY ('{mobile_app_2,mobile_app_2_cc_validator}'::text[])) THEN 'Android'::text WHEN ((p.order_capability)::text = 'mobile_app_3'::text) THEN 'iOS'::text WHEN ((p.order_capability)::text = 'mobile_app_sms'::text) THEN 'SMS'::text WHEN ((p.order_capability)::text = 'mobile_web'::text) THEN 'Mobile Web'::text WHEN (p.order_capability IS NULL) THEN 'undefined'::text ELSE initcap(replace(replace((p.order_capability)::text, '_'::text, ' '::text), '-'::text, ' '::text)) END)
  • Sort Method: external merge Disk: 337208kB
3. 8,920.221 61,143.304 ↓ 1.3 8,408,594 1

Result (cost=0.00..1,362,136.37 rows=6,559,066 width=50) (actual time=25,664.668..61,143.304 rows=8,408,594 loops=1)

4. 3,591.768 52,223.083 ↓ 1.3 8,408,594 1

Append (cost=0.00..1,148,966.73 rows=6,559,066 width=37) (actual time=25,664.579..52,223.083 rows=8,408,594 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on payments_log p (cost=0.00..0.00 rows=1 width=1,158) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (processor_processed AND ((action)::text = 'authorize'::text) AND (date > ((('now'::cstring)::date - '33 days'::interval))::date))
6. 1.478 1.478 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_05_date on payments_log_2015_05 p_1 (cost=0.44..8.43 rows=1 width=31) (actual time=1.478..1.478 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
7. 1.574 1.574 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_06_date on payments_log_2015_06 p_2 (cost=0.44..8.31 rows=1 width=38) (actual time=1.574..1.574 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
8. 1.591 1.591 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_07_date on payments_log_2015_07 p_3 (cost=0.44..4.48 rows=1 width=39) (actual time=1.591..1.591 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
9. 1.600 1.600 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_08_date on payments_log_2015_08 p_4 (cost=0.44..4.47 rows=1 width=40) (actual time=1.600..1.600 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
10. 1.419 1.419 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_09_date on payments_log_2015_09 p_5 (cost=0.44..4.47 rows=1 width=39) (actual time=1.419..1.419 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
11. 1.745 1.745 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_10_date on payments_log_2015_10 p_6 (cost=0.44..7.64 rows=1 width=39) (actual time=1.745..1.745 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
12. 2.294 2.294 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_11_date on payments_log_2015_11 p_7 (cost=0.44..8.45 rows=1 width=40) (actual time=2.293..2.294 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
13. 1.555 1.555 ↓ 0.0 0 1

Index Scan using i_payments_log_2015_12_date on payments_log_2015_12 p_8 (cost=0.44..7.21 rows=1 width=40) (actual time=1.555..1.555 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
14. 1.688 1.688 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_01_date on payments_log_2016_01 p_9 (cost=0.44..7.04 rows=1 width=40) (actual time=1.688..1.688 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
15. 1.804 1.804 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_02_date on payments_log_2016_02 p_10 (cost=0.44..6.88 rows=1 width=41) (actual time=1.804..1.804 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
16. 1.501 1.501 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_03_date on payments_log_2016_03 p_11 (cost=0.44..6.76 rows=1 width=40) (actual time=1.501..1.501 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
17. 1.757 1.757 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_04_date on payments_log_2016_04 p_12 (cost=0.44..6.81 rows=1 width=41) (actual time=1.756..1.757 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
18. 1.510 1.510 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_05_date on payments_log_2016_05 p_13 (cost=0.44..6.75 rows=1 width=41) (actual time=1.510..1.510 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
19. 1.329 1.329 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_06_date on payments_log_2016_06 p_14 (cost=0.44..6.83 rows=1 width=41) (actual time=1.329..1.329 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
20. 1.476 1.476 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_07_date on payments_log_2016_07 p_15 (cost=0.44..6.64 rows=1 width=41) (actual time=1.476..1.476 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
21. 1.532 1.532 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_08_date on payments_log_2016_08 p_16 (cost=0.44..6.62 rows=1 width=42) (actual time=1.532..1.532 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
22. 3.118 3.118 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_09_date on payments_log_2016_09 p_17 (cost=0.44..6.43 rows=1 width=42) (actual time=3.117..3.118 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
23. 1.805 1.805 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_10_date on payments_log_2016_10 p_18 (cost=0.44..6.78 rows=1 width=42) (actual time=1.805..1.805 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
24. 1.443 1.443 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_11_date on payments_log_2016_11 p_19 (cost=0.44..6.87 rows=1 width=41) (actual time=1.443..1.443 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
25. 1.555 1.555 ↓ 0.0 0 1

Index Scan using i_payments_log_2016_12_date on payments_log_2016_12 p_20 (cost=0.44..6.98 rows=1 width=42) (actual time=1.555..1.555 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
26. 1.435 1.435 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_01_date on payments_log_2017_01 p_21 (cost=0.44..7.23 rows=1 width=42) (actual time=1.435..1.435 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
27. 2.730 2.730 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_02_date on payments_log_2017_02 p_22 (cost=0.44..8.43 rows=1 width=42) (actual time=2.729..2.730 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
28. 1.674 1.674 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_03_date on payments_log_2017_03 p_23 (cost=0.44..4.46 rows=1 width=42) (actual time=1.674..1.674 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
29. 1.562 1.562 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_04_date on payments_log_2017_04 p_24 (cost=0.44..4.46 rows=1 width=42) (actual time=1.562..1.562 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
30. 1.554 1.554 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_05_date on payments_log_2017_05 p_25 (cost=0.44..4.46 rows=1 width=41) (actual time=1.554..1.554 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
31. 2.728 2.728 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_06_date on payments_log_2017_06 p_26 (cost=0.44..5.83 rows=1 width=42) (actual time=2.728..2.728 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
32. 1.917 1.917 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_07_date on payments_log_2017_07 p_27 (cost=0.44..7.45 rows=1 width=41) (actual time=1.917..1.917 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
33. 1.648 1.648 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_08_date on payments_log_2017_08 p_28 (cost=0.44..4.46 rows=1 width=41) (actual time=1.648..1.648 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
34. 1.522 1.522 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_09_date on payments_log_2017_09 p_29 (cost=0.44..4.46 rows=1 width=41) (actual time=1.522..1.522 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
35. 1.640 1.640 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_10_date on payments_log_2017_10 p_30 (cost=0.44..4.46 rows=1 width=42) (actual time=1.640..1.640 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
36. 1.549 1.549 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_11_date on payments_log_2017_11 p_31 (cost=0.44..4.46 rows=1 width=41) (actual time=1.549..1.549 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
37. 1.405 1.405 ↓ 0.0 0 1

Index Scan using i_payments_log_2017_12_date on payments_log_2017_12 p_32 (cost=0.44..4.46 rows=1 width=40) (actual time=1.405..1.405 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
38. 2.411 2.411 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_01_date on payments_log_2018_01 p_33 (cost=0.57..8.39 rows=1 width=41) (actual time=2.410..2.411 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
39. 1.678 1.678 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_02_date on payments_log_2018_02 p_34 (cost=0.44..4.46 rows=1 width=40) (actual time=1.678..1.678 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
40. 2.720 2.720 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_03_date on payments_log_2018_03 p_35 (cost=0.45..4.47 rows=1 width=39) (actual time=2.720..2.720 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
41. 1.462 1.462 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_04_date on payments_log_2018_04 p_36 (cost=0.44..4.46 rows=1 width=39) (actual time=1.462..1.462 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
42. 1.442 1.442 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_05_date on payments_log_2018_05 p_37 (cost=0.45..4.47 rows=1 width=39) (actual time=1.442..1.442 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
43. 1.547 1.547 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_06_date on payments_log_2018_06 p_38 (cost=0.45..4.47 rows=1 width=40) (actual time=1.546..1.547 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
44. 1.642 1.642 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_07_date on payments_log_2018_07 p_39 (cost=0.45..4.47 rows=1 width=40) (actual time=1.642..1.642 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
45. 1.730 1.730 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_08_date on payments_log_2018_08 p_40 (cost=0.45..4.47 rows=1 width=39) (actual time=1.730..1.730 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
46. 2.485 2.485 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_09_date on payments_log_2018_09 p_41 (cost=0.44..4.46 rows=1 width=40) (actual time=2.484..2.485 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
47. 2.628 2.628 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_10_date on payments_log_2018_10 p_42 (cost=0.44..4.46 rows=1 width=40) (actual time=2.628..2.628 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
48. 2.148 2.148 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_11_date on payments_log_2018_11 p_43 (cost=0.44..4.46 rows=1 width=39) (actual time=2.148..2.148 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
49. 1.760 1.760 ↓ 0.0 0 1

Index Scan using i_payments_log_2018_12_date on payments_log_2018_12 p_44 (cost=0.45..4.47 rows=1 width=39) (actual time=1.760..1.760 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
50. 2.060 2.060 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_01_date on payments_log_2019_01 p_45 (cost=0.45..4.47 rows=1 width=38) (actual time=2.060..2.060 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
51. 1.351 1.351 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_02_date on payments_log_2019_02 p_46 (cost=0.45..4.47 rows=1 width=38) (actual time=1.350..1.351 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
52. 2.019 2.019 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_03_date on payments_log_2019_03 p_47 (cost=0.45..4.62 rows=1 width=37) (actual time=2.019..2.019 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
53. 2.370 2.370 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_04_date on payments_log_2019_04 p_48 (cost=0.45..5.78 rows=1 width=37) (actual time=2.370..2.370 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
54. 1.424 1.424 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_05_date on payments_log_2019_05 p_49 (cost=0.45..4.65 rows=1 width=37) (actual time=1.423..1.424 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
55. 5.155 5.155 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_06_date on payments_log_2019_06 p_50 (cost=0.45..4.60 rows=1 width=37) (actual time=5.154..5.155 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
56. 2.266 2.266 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_07_date on payments_log_2019_07 p_51 (cost=0.45..5.70 rows=1 width=37) (actual time=2.266..2.266 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
57. 2.620 2.620 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_08_date on payments_log_2019_08 p_52 (cost=0.45..5.69 rows=1 width=37) (actual time=2.620..2.620 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
58. 1.799 1.799 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_09_date on payments_log_2019_09 p_53 (cost=0.45..5.53 rows=1 width=38) (actual time=1.798..1.799 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
59. 2.644 2.644 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_10_date on payments_log_2019_10 p_54 (cost=0.45..5.22 rows=1 width=37) (actual time=2.644..2.644 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
60. 4.563 4.563 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_11_date on payments_log_2019_11 p_55 (cost=0.45..4.98 rows=1 width=37) (actual time=4.562..4.563 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
61. 1.962 1.962 ↓ 0.0 0 1

Index Scan using i_payments_log_2019_12_date on payments_log_2019_12 p_56 (cost=0.45..4.84 rows=1 width=37) (actual time=1.962..1.962 rows=0 loops=1)

  • Index Cond: (date > ((('now'::cstring)::date - '33 days'::interval))::date)
  • Filter: (processor_processed AND ((action)::text = 'authorize'::text))
62. 20,166.365 45,714.240 ↓ 1.3 6,916,331 1

Bitmap Heap Scan on payments_log_2020_01 p_57 (cost=200,267.10..963,049.82 rows=5,266,879 width=37) (actual time=25,555.533..45,714.240 rows=6,916,331 loops=1)

  • Recheck Cond: ((action)::text = 'authorize'::text)
  • Rows Removed by Index Recheck: 9888333
  • Filter: (processor_processed AND (date > ((('now'::cstring)::date - '33 days'::interval))::date))
  • Rows Removed by Filter: 1110716
  • Heap Blocks: exact=28743 lossy=527794
63. 25,547.875 25,547.875 ↓ 1.0 8,027,695 1

Bitmap Index Scan on i_payments_log_2020_01_action_date_5_hours (cost=0.00..198,950.38 rows=7,927,709 width=0) (actual time=25,547.875..25,547.875 rows=8,027,695 loops=1)

  • Index Cond: ((action)::text = 'authorize'::text)
64. 2,808.048 2,808.048 ↓ 1.2 1,492,263 1

Seq Scan on payments_log_2020_02 p_58 (cost=0.00..185,599.40 rows=1,292,130 width=37) (actual time=0.025..2,808.048 rows=1,492,263 loops=1)

  • Filter: (processor_processed AND ((action)::text = 'authorize'::text) AND (date > ((('now'::cstring)::date - '33 days'::interval))::date))
  • Rows Removed by Filter: 1677853
Planning time : 287.101 ms
Execution time : 92,680.986 ms