explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7i4r

Settings
# exclusive inclusive rows x rows loops node
1. 56.897 431.872 ↓ 56.6 5,033 1

Gather (cost=1,000.12..62,517.05 rows=89 width=2,585) (actual time=23.832..431.872 rows=5,033 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 9.184 374.975 ↓ 27.5 1,678 3

Result (cost=0.12..61,505.33 rows=61 width=2,585) (actual time=24.334..374.975 rows=1,678 loops=3)

3. 0.520 365.791 ↓ 27.5 1,678 3

Append (cost=0.12..61,497.25 rows=61 width=2,764) (actual time=24.280..365.791 rows=1,678 loops=3)

4. 0.010 0.010 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_feb_2015 on fact_transaction_header_feb_2015 ft (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.010..0.010 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
5. 0.003 0.003 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_mar_2015 on fact_transaction_header_mar_2015 ft_1 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
6. 0.002 0.002 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_apr_2015 on fact_transaction_header_apr_2015 ft_2 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
7. 0.002 0.002 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_may_2015 on fact_transaction_header_may_2015 ft_3 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
8. 0.002 0.002 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_jun_2015 on fact_transaction_header_jun_2015 ft_4 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
9. 0.002 0.002 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_jul_2015 on fact_transaction_header_jul_2015 ft_5 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
10. 0.003 0.003 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_aug_2015 on fact_transaction_header_aug_2015 ft_6 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
11. 0.810 0.810 ↓ 2.0 2 3

Parallel Seq Scan on fact_transaction_header_sep_2015 ft_7 (cost=0.00..103.19 rows=1 width=1,419) (actual time=0.180..0.810 rows=2 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 226
12. 0.183 0.183 ↓ 0.0 0 3

Parallel Seq Scan on fact_transaction_header_oct_2015 ft_8 (cost=0.00..20.88 rows=1 width=2,374) (actual time=0.183..0.183 rows=0 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 65
13. 0.004 0.004 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_nov_2015 on fact_transaction_header_nov_2015 ft_9 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.004..0.004 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
14. 0.007 0.007 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_dec_2015 on fact_transaction_header_dec_2015 ft_10 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.007..0.007 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 1
15. 0.320 0.320 ↓ 0.0 0 3

Parallel Seq Scan on fact_transaction_header_jan_2016 ft_11 (cost=0.00..53.44 rows=1 width=2,445) (actual time=0.320..0.320 rows=0 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 101
16. 1.682 1.682 ↓ 0.0 0 3

Parallel Seq Scan on fact_transaction_header_feb_2016 ft_12 (cost=0.00..211.93 rows=1 width=1,390) (actual time=1.682..1.682 rows=0 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 497
17. 7.341 8.971 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on fact_transaction_header_mar_2016 ft_13 (cost=146.58..3,140.34 rows=1 width=818) (actual time=8.971..8.971 rows=0 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 2228
  • Heap Blocks: exact=1120
18. 1.630 1.630 ↓ 1.1 6,683 1

Bitmap Index Scan on idx_provider_id_mar_2016 (cost=0.00..146.58 rows=6,172 width=0) (actual time=1.630..1.630 rows=6,683 loops=1)

  • Index Cond: (payer_provider_id = 101)
19. 12.897 13.921 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on fact_transaction_header_apr_2016 ft_14 (cost=142.20..3,198.07 rows=1 width=2,375) (actual time=13.921..13.921 rows=0 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 2453
  • Heap Blocks: exact=848
20. 1.024 1.024 ↓ 1.1 7,359 1

Bitmap Index Scan on idx_provider_id_apr_2016 (cost=0.00..142.20 rows=6,655 width=0) (actual time=1.024..1.024 rows=7,359 loops=1)

  • Index Cond: (payer_provider_id = 101)
21. 14.106 15.355 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on fact_transaction_header_may_2016 ft_15 (cost=158.70..3,092.39 rows=1 width=1,349) (actual time=15.355..15.355 rows=0 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 2418
  • Heap Blocks: exact=609
22. 1.249 1.249 ↑ 1.0 7,255 1

Bitmap Index Scan on idx_provider_id_may_2016 (cost=0.00..158.70 rows=7,255 width=0) (actual time=1.249..1.249 rows=7,255 loops=1)

  • Index Cond: (payer_provider_id = 101)
23. 9.430 10.344 ↓ 19.0 19 3

Parallel Bitmap Heap Scan on fact_transaction_header_jun_2016 ft_16 (cost=113.26..1,672.76 rows=1 width=1,854) (actual time=9.839..10.344 rows=19 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 1624
  • Heap Blocks: exact=373
24. 0.914 0.914 ↓ 1.0 4,931 1

Bitmap Index Scan on idx_provider_id_jun_2016 (cost=0.00..113.26 rows=4,930 width=0) (actual time=0.914..0.914 rows=4,931 loops=1)

  • Index Cond: (payer_provider_id = 101)
25. 33.720 33.720 ↓ 89.0 89 3

Parallel Seq Scan on fact_transaction_header_jul_2016 ft_17 (cost=0.00..3,360.37 rows=1 width=884) (actual time=0.145..33.720 rows=89 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 7537
26. 5.250 5.832 ↓ 59.2 237 3

Parallel Bitmap Heap Scan on fact_transaction_header_aug_2016 ft_18 (cost=66.97..1,167.46 rows=4 width=828) (actual time=0.917..5.832 rows=237 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 772
  • Heap Blocks: exact=163
27. 0.582 0.582 ↓ 1.0 3,131 1

Bitmap Index Scan on idx_provider_id_aug_2016 (cost=0.00..66.97 rows=3,025 width=0) (actual time=0.582..0.582 rows=3,131 loops=1)

  • Index Cond: (payer_provider_id = 101)
28. 23.380 23.380 ↓ 23.8 95 3

Parallel Seq Scan on fact_transaction_header_sep_2016 ft_19 (cost=0.00..2,425.28 rows=4 width=1,360) (actual time=7.278..23.380 rows=95 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 6258
29. 168.145 168.145 ↓ 127.0 127 3

Parallel Seq Scan on fact_transaction_header_oct_2016 ft_20 (cost=0.00..23,387.16 rows=1 width=889) (actual time=0.718..168.145 rows=127 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 51524
30. 36.645 36.645 ↓ 28.2 254 3

Parallel Seq Scan on fact_transaction_header_nov_2016 ft_21 (cost=0.00..6,364.74 rows=9 width=883) (actual time=25.944..36.645 rows=254 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 14587
31. 2.736 3.026 ↓ 65.5 131 3

Parallel Bitmap Heap Scan on fact_transaction_header_dec_2016 ft_22 (cost=69.91..1,065.31 rows=2 width=834) (actual time=0.515..3.026 rows=131 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 827
  • Heap Blocks: exact=122
32. 0.290 0.290 ↑ 1.0 2,874 1

Bitmap Index Scan on idx_provider_id_dec_2016 (cost=0.00..69.91 rows=2,883 width=0) (actual time=0.290..0.290 rows=2,874 loops=1)

  • Index Cond: (payer_provider_id = 101)
33. 0.971 1.058 ↓ 25.0 25 3

Parallel Bitmap Heap Scan on fact_transaction_header_jan_2017 ft_23 (cost=27.62..370.00 rows=1 width=1,351) (actual time=0.181..1.058 rows=25 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 302
  • Heap Blocks: exact=55
34. 0.087 0.087 ↓ 1.0 980 1

Bitmap Index Scan on idx_provider_id_jan_2017 (cost=0.00..27.62 rows=978 width=0) (actual time=0.087..0.087 rows=980 loops=1)

  • Index Cond: (payer_provider_id = 101)
35. 1.471 1.622 ↓ 60.0 60 3

Parallel Bitmap Heap Scan on fact_transaction_header_feb_2017 ft_24 (cost=40.01..640.99 rows=1 width=1,337) (actual time=0.283..1.622 rows=60 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 463
  • Heap Blocks: exact=89
36. 0.151 0.151 ↓ 1.0 1,568 1

Bitmap Index Scan on idx_provider_id_feb_2017 (cost=0.00..40.00 rows=1,563 width=0) (actual time=0.151..0.151 rows=1,568 loops=1)

  • Index Cond: (payer_provider_id = 101)
37. 1.885 1.885 ↓ 6.0 6 3

Parallel Seq Scan on fact_transaction_header_mar_2017 ft_25 (cost=0.00..340.79 rows=1 width=1,854) (actual time=0.777..1.885 rows=6 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 941
38. 0.288 0.329 ↓ 22.0 22 3

Parallel Bitmap Heap Scan on fact_transaction_header_apr_2017 ft_26 (cost=10.20..193.08 rows=1 width=1,852) (actual time=0.117..0.329 rows=22 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 64
  • Heap Blocks: exact=14
39. 0.041 0.041 ↓ 1.0 257 1

Bitmap Index Scan on idx_provider_id_apr_2017 (cost=0.00..10.20 rows=256 width=0) (actual time=0.041..0.041 rows=257 loops=1)

  • Index Cond: (payer_provider_id = 101)
40. 3.399 3.399 ↓ 0.0 0 3

Parallel Seq Scan on fact_transaction_header_may_2017 ft_27 (cost=0.00..641.24 rows=1 width=1,896) (actual time=3.066..3.399 rows=0 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 1705
41. 1.864 1.864 ↓ 7.0 7 3

Parallel Seq Scan on fact_transaction_header_jun_2017 ft_28 (cost=0.00..353.44 rows=1 width=1,363) (actual time=0.043..1.864 rows=7 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 924
42. 6.831 7.856 ↓ 128.0 128 3

Parallel Bitmap Heap Scan on fact_transaction_header_jul_2017 ft_29 (cost=168.74..2,784.43 rows=1 width=1,343) (actual time=1.583..7.856 rows=128 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 2381
  • Heap Blocks: exact=421
43. 1.025 1.025 ↑ 1.0 7,527 1

Bitmap Index Scan on idx_provider_id_jul_2017 (cost=0.00..168.74 rows=7,527 width=0) (actual time=1.025..1.025 rows=7,527 loops=1)

  • Index Cond: (payer_provider_id = 101)
44. 22.342 24.453 ↓ 119.0 476 3

Parallel Bitmap Heap Scan on fact_transaction_header_aug_2017 ft_30 (cost=373.14..6,687.10 rows=4 width=1,341) (actual time=4.300..24.453 rows=476 loops=3)

  • Recheck Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 5257
  • Heap Blocks: exact=2002
45. 2.111 2.111 ↓ 1.0 17,198 1

Bitmap Index Scan on idx_provider_id_aug_2017 (cost=0.00..373.14 rows=17,180 width=0) (actual time=2.111..2.111 rows=17,198 loops=1)

  • Index Cond: (payer_provider_id = 101)
46. 0.326 0.326 ↓ 0.0 0 3

Parallel Seq Scan on fact_transaction_header_sep_2017 ft_31 (cost=0.00..59.96 rows=1 width=2,444) (actual time=0.326..0.326 rows=0 loops=3)

  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
  • Rows Removed by Filter: 158
47. 0.029 0.029 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_oct_2017 on fact_transaction_header_oct_2017 ft_32 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.029..0.029 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
48. 0.013 0.013 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_nov_2017 on fact_transaction_header_nov_2017 ft_33 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.013..0.013 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
49. 0.003 0.003 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_dec_2017 on fact_transaction_header_dec_2017 ft_34 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
50. 0.006 0.006 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_jan_2018 on fact_transaction_header_jan_2018 ft_35 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.006..0.006 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
51. 0.011 0.011 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_feb_2018 on fact_transaction_header_feb_2018 ft_36 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.011..0.011 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
52. 0.008 0.008 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_mar_2018 on fact_transaction_header_mar_2018 ft_37 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.008..0.008 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
53. 0.003 0.003 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_apr_2018 on fact_transaction_header_apr_2018 ft_38 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
54. 0.010 0.010 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_may_2018 on fact_transaction_header_may_2018 ft_39 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.010..0.010 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
55. 0.004 0.004 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_jun_2018 on fact_transaction_header_jun_2018 ft_40 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.004..0.004 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
56. 0.020 0.020 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_jul_2018 on fact_transaction_header_jul_2018 ft_41 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.020..0.020 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)
57. 0.003 0.003 ↓ 0.0 0 3

Parallel Index Scan using idx_provider_id_sep_2018 on fact_transaction_header_sep_2018 ft_42 (cost=0.12..8.15 rows=1 width=8,196) (actual time=0.003..0.003 rows=0 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND ((payer_status IS NULL) OR ((payer_status)::text <> 'N'::text)) AND ((payee_status IS NULL) OR ((payee_status)::text <> 'N'::text)) AND ((payer_user_type)::t (...)