explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RxmR

Settings
# exclusive inclusive rows x rows loops node
1. 5.680 4,431,795.364 ↓ 0.0 0 1

Sort (cost=869,021,846.19..869,668,430.34 rows=258,633,659 width=1,295) (actual time=4,431,795.364..4,431,795.364 rows=0 loops=1)

  • Sort Key: t.transaction_date DESC, t.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=141185626 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
2.          

Initplan (for Sort)

3. 0.629 0.629 ↑ 1.0 1 1

-> Seq Scan on dict_transfer_type (cost=0.00..1.02 rows=1 width=8) (actual time=0.626..0.629 rows=1 loops=1)

  • Filter: (description = 'Out'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared read=1
  • I/O Timings: read=0.596
4. 0.000 0.000 ↓ 0.0 0

-> Seq Scan on dict_transfer_sort (cost=0.00..2.73 rows=1 width=8) (never executed)

  • Filter: (description = 'BLIK Transfer'::text)
5. 0.000 0.000 ↓ 0.0 0

-> Seq Scan on dict_transfer_sort dict_transfer_sort_1 (cost=0.00..2.73 rows=1 width=8) (never executed)

  • Filter: (description = 'BLIK Transfer RETURN'::text)
6. 0.000 0.000 ↓ 0.0 0

-> Seq Scan on dict_transfer_sort dict_transfer_sort_2 (cost=0.00..2.73 rows=1 width=8) (never executed)

  • Filter: (description = 'BLIK Transfer CASH_DEPOSIT'::text)
7. 0.009 4,431,789.055 ↓ 0.0 0 1

-> Hash Left Join (cost=26,838.37..541,161,939.87 rows=258,633,659 width=1,295) (actual time=4,431,789.054..4,431,789.055 rows=0 loops=1)

  • Hash Cond: (t.id_define_cyclics = tpp_cyc.id_define_cyclics)
  • Buffers: shared hit=141185626 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
8. 4.840 4,431,789.046 ↓ 0.0 0 1

-> Hash Join (cost=21,537.58..532,088,709.21 rows=6,300,455 width=1,382) (actual time=4,431,789.046..4,431,789.046 rows=0 loops=1)

  • Hash Cond: (m.id_product = common_getcommonproducts.common_getcommonproducts)
  • Buffers: shared hit=141185626 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
9. 0.002 4,431,784.206 ↓ 0.0 0 1

-> Merge Left Join (cost=21,520.33..462,552,780.37 rows=26,463,169,152 width=1,398) (actual time=4,431,784.206..4,431,784.206 rows=0 loops=1)

  • Merge Cond: (t.id = tfsm.id_transactions)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
10. 0.001 4,431,784.204 ↓ 0.0 0 1

-> Merge Left Join (cost=13,052.71..64,712,484.94 rows=353,714,755 width=1,367) (actual time=4,431,784.204..4,431,784.204 rows=0 loops=1)

  • Merge Cond: (t.id = tzus.id_transactions)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
11. 0.002 4,431,784.203 ↓ 0.0 0 1

-> Merge Left Join (cost=5,865.19..59,381,506.72 rows=6,800,959 width=1,147) (actual time=4,431,784.203..4,431,784.203 rows=0 loops=1)

  • Merge Cond: (t.id = tpp.id_transactions)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
12. 0.001 4,431,784.201 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=133.24..59,273,346.20 rows=165,675 width=1,115) (actual time=4,431,784.201..4,431,784.201 rows=0 loops=1)

  • Join Filter: (tvat.id_transactions = t.id)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
13. 0.001 4,431,784.200 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=133.24..58,766,282.14 rows=2,607 width=993) (actual time=4,431,784.200..4,431,784.200 rows=0 loops=1)

  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
14. 0.001 4,431,784.199 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=132.81..58,744,767.02 rows=2,607 width=974) (actual time=4,431,784.199..4,431,784.199 rows=0 loops=1)

  • Join Filter: (tfor.id_transactions = t.id)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
15. 0.001 4,431,784.198 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=132.81..58,730,122.12 rows=53 width=786) (actual time=4,431,784.198..4,431,784.198 rows=0 loops=1)

  • Join Filter: (dco.id = t.count_merchant)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
16. 0.001 4,431,784.197 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=132.81..58,729,902.01 rows=53 width=783) (actual time=4,431,784.197..4,431,784.197 rows=0 loops=1)

  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
17. 0.000 4,431,784.196 ↓ 0.0 0 1

-> Nested Loop (cost=132.66..58,728,568.00 rows=1 width=583) (actual time=4,431,784.196..4,431,784.196 rows=0 loops=1)

  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
18. 0.001 4,431,784.196 ↓ 0.0 0 1

-> Nested Loop (cost=132.23..58,728,559.66 rows=1 width=583) (actual time=4,431,784.195..4,431,784.196 rows=0 loops=1)

  • Join Filter: (t.id_dict_currencies = dc.id)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
19. 0.002 4,431,784.195 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=132.23..58,728,555.25 rows=1 width=579) (actual time=4,431,784.194..4,431,784.195 rows=0 loops=1)

  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
20. 10.738 4,431,784.193 ↓ 0.0 0 1

-> Nested Loop Left Join (cost=131.94..58,728,546.94 rows=1 width=569) (actual time=4,431,784.193..4,431,784.193 rows=0 loops=1)

  • Join Filter: (prdc.id_users = m.id_users)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
21. 0.001 4,431,773.455 ↓ 0.0 0 1

-> Nested Loop (cost=131.52..58,728,538.49 rows=1 width=560) (actual time=4,431,773.455..4,431,773.455 rows=0 loops=1)

  • Join Filter: (m.id_product = prd.id)
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
22. 68.941 4,431,773.454 ↓ 0.0 0 1

-> Nested Loop (cost=131.09..58,728,422.89 rows=1 width=507) (actual time=4,431,773.454..4,431,773.454 rows=0 loops=1)

  • Join Filter: (t.id_product = m.id_product)
  • Rows Removed by Join Filter: 620
  • Buffers: shared hit=141184942 read=12177665 dirtied=12270 written=130
  • I/O Timings: read=4122524.585 write=12.322
23. 3,093,954.570 4,431,704.513 ↑ 54.6 10 1

-> Merge Append (cost=130.65..58,728,199.99 rows=546 width=480) (actual time=4,431,057.190..4,431,704.513 rows=10 loops=1)

  • Sort Key: t.id DESC
  • Buffers: shared hit=141184942 read=12177604 dirtied=12270 written=130
  • I/O Timings: read=4122471.340 write=12.322
  • -> Index Scan Backward usi
24. 0.006 0.006 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_1970_pkey on part_10000000_1970 t (cost=0.14..370.77 rows=1 width=516) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared hit=1
25. 0.003 0.003 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2013q1_pkey on part_10000000_2013q1 t_1 (cost=0.14..370.77 rows=1 width=516) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared hit=1
26. 0.003 0.003 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2013q2_pkey on part_10000000_2013q2 t_2 (cost=0.14..370.77 rows=1 width=516) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared hit=1
27. 1.564 1.564 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2013q3_pkey on part_10000000_2013q3 t_3 (cost=0.14..374.77 rows=1 width=516) (actual time=1.564..1.564 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=1 read=2
  • I/O Timings: read=1.521
28. 0.848 0.848 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2013q4_pkey on part_10000000_2013q4 t_4 (cost=0.14..20.40 rows=1 width=401) (actual time=0.848..0.848 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 125
  • Buffers: shared hit=1 read=7
  • I/O Timings: read=0.755
29. 0.827 0.827 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2014q1_pkey on part_10000000_2014q1 t_5 (cost=0.14..20.61 rows=1 width=401) (actual time=0.827..0.827 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 132
  • Buffers: shared hit=1 read=7
  • I/O Timings: read=0.744
30. 0.893 0.893 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2014q2_pkey on part_10000000_2014q2 t_6 (cost=0.14..23.10 rows=1 width=403) (actual time=0.893..0.893 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 152
  • Buffers: shared hit=2 read=8
  • I/O Timings: read=0.799
31. 0.837 0.837 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2014q3_pkey on part_10000000_2014q3 t_7 (cost=0.14..21.68 rows=1 width=387) (actual time=0.837..0.837 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 134
  • Buffers: shared hit=2 read=7
  • I/O Timings: read=0.750
32. 0.859 0.859 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2014q4_pkey on part_10000000_2014q4 t_8 (cost=0.14..23.06 rows=1 width=404) (actual time=0.859..0.859 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 163
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=0.757
33. 5.844 5.844 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2015q1_pkey on part_10000000_2015q1 t_9 (cost=0.14..23.42 rows=1 width=401) (actual time=5.844..5.844 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 171
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=5.691
34. 5.108 5.108 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2015q2_pkey on part_10000000_2015q2 t_10 (cost=0.14..23.50 rows=1 width=401) (actual time=5.108..5.108 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 171
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=4.974
35. 5.895 5.895 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2015q3_pkey on part_10000000_2015q3 t_11 (cost=0.14..25.03 rows=1 width=401) (actual time=5.895..5.895 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 195
  • Buffers: shared hit=1 read=10
  • I/O Timings: read=5.734
36. 3.504 3.504 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2015q4_pkey on part_10000000_2015q4 t_12 (cost=0.14..23.79 rows=1 width=401) (actual time=3.504..3.504 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 166
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=3.379
37. 0.488 0.488 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2016q1_pkey on part_10000000_2016q1 t_13 (cost=0.14..21.98 rows=1 width=403) (actual time=0.488..0.488 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 151
  • Buffers: shared hit=1 read=8
  • I/O Timings: read=0.394
38. 3.422 3.422 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2016q2_pkey on part_10000000_2016q2 t_14 (cost=0.14..25.34 rows=1 width=400) (actual time=3.422..3.422 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 196
  • Buffers: shared hit=1 read=10
  • I/O Timings: read=3.287
39. 5.042 5.042 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2016q3_pkey on part_10000000_2016q3 t_15 (cost=0.14..32.29 rows=1 width=403) (actual time=5.042..5.042 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 194
  • Buffers: shared hit=3 read=10
  • I/O Timings: read=4.897
40. 4.653 4.653 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2016q4_pkey on part_10000000_2016q4 t_16 (cost=0.14..25.13 rows=1 width=401) (actual time=4.652..4.653 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 203
  • Buffers: shared hit=1 read=10
  • I/O Timings: read=4.512
41. 5.263 5.263 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2017q1_pkey on part_10000000_2017q1 t_17 (cost=0.14..25.47 rows=1 width=401) (actual time=5.263..5.263 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 218
  • Buffers: shared hit=1 read=10
  • I/O Timings: read=5.113
42. 5.892 5.892 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2017q2_pkey on part_10000000_2017q2 t_18 (cost=0.14..25.37 rows=1 width=403) (actual time=5.892..5.892 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 204
  • Buffers: shared hit=1 read=10
  • I/O Timings: read=5.747
43. 2.125 2.125 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2017q3_pkey on part_10000000_2017q3 t_19 (cost=0.14..23.53 rows=1 width=400) (actual time=2.125..2.125 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 182
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=1.998
44. 4.491 4.491 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2017q4_pkey on part_10000000_2017q4 t_20 (cost=0.14..25.39 rows=1 width=403) (actual time=4.491..4.491 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 208
  • Buffers: shared hit=1 read=10
  • I/O Timings: read=4.334
45. 3.369 3.369 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2018q1_pkey on part_10000000_2018q1 t_21 (cost=0.14..23.74 rows=1 width=400) (actual time=3.369..3.369 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 190
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=3.240
46. 5.236 5.236 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2018q2_pkey on part_10000000_2018q2 t_22 (cost=0.14..25.63 rows=1 width=407) (actual time=5.236..5.236 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 217
  • Buffers: shared hit=2 read=10
  • I/O Timings: read=5.056
47. 7.439 7.439 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2018q3_pkey on part_10000000_2018q3 t_23 (cost=0.14..28.81 rows=1 width=402) (actual time=7.439..7.439 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 257
  • Buffers: shared hit=1 read=12
  • I/O Timings: read=7.235
48. 2.171 2.171 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2018q4_pkey on part_10000000_2018q4 t_24 (cost=0.14..23.79 rows=1 width=398) (actual time=2.171..2.171 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 185
  • Buffers: shared hit=1 read=9
  • I/O Timings: read=2.020
49. 148,974.788 148,974.788 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2019q1_pkey on part_10000000_2019q1 t_25 (cost=0.43..922,742.60 rows=1 width=356) (actual time=148,974.788..148,974.788 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 7353972
  • Buffers: shared hit=3451145 read=440612 dirtied=3 written=5
  • I/O Timings: read=140415.563 write=0.247
50. 280,296.962 280,296.962 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2019q2_pkey on part_10000000_2019q2 t_26 (cost=0.43..1,779,574.67 rows=1 width=354) (actual time=280,296.962..280,296.962 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 14138277
  • Buffers: shared hit=10484838 read=884184 dirtied=71 written=2
  • I/O Timings: read=257274.669 write=0.105
51. 295,224.420 295,224.420 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2019q3_pkey on part_10000000_2019q3 t_27 (cost=0.43..1,631,628.28 rows=1 width=354) (actual time=295,224.420..295,224.420 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 14141725
  • Buffers: shared hit=10631283 read=888451 dirtied=82
  • I/O Timings: read=271199.998
52. 305,005.659 305,005.659 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2019q4_pkey on part_10000000_2019q4 t_28 (cost=0.43..1,633,330.23 rows=1 width=354) (actual time=305,005.659..305,005.659 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 13985121
  • Buffers: shared hit=11043905 read=902810 dirtied=61 written=1
  • I/O Timings: read=279288.734 write=0.075
53. 251,495.391 251,495.391 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2020q1_pkey on part_10000000_2020q1 t_29 (cost=0.43..1,455,857.23 rows=1 width=355) (actual time=251,495.391..251,495.391 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 13108577
  • Buffers: shared hit=10549572 read=815715 dirtied=58 written=4
  • I/O Timings: read=229388.645 write=0.134
54. 56,070.125 56,070.125 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2020q2_pkey on part_10000000_2020q2 t_30 (cost=0.43..8,024,323.03 rows=1 width=355) (actual time=56,070.125..56,070.125 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 2572605
  • Buffers: shared hit=1902745 read=161974 dirtied=4776 written=30
  • I/O Timings: read=51645.018 write=9.196
55. 0.042 0.042 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2020q3_pkey on part_10000000_2020q3 t_31 (cost=0.14..370.77 rows=1 width=516) (actual time=0.042..0.042 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.029
56. 0.025 0.025 ↓ 0.0 0 1

-> Index Scan Backward using t_10000000_2020q4_pkey on part_10000000_2020q4 t_32 (cost=0.14..370.77 rows=1 width=516) (actual time=0.025..0.025 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
57. 606.496 606.496 ↓ 4.0 8 1

-> Index Scan Backward using t_10000000_1970_default_pkey on part_10000000_default t_33 (cost=0.29..1,617.51 rows=2 width=403) (actual time=3.659..606.496 rows=8 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Rows Removed by Filter: 19582
  • Buffers: shared hit=6381 read=882 dirtied=9
  • I/O Timings: read=590.791
58. 0.029 0.029 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_1970_pkey on part_20000000_1970 t_34 (cost=0.14..370.77 rows=1 width=516) (actual time=0.029..0.029 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.018
59. 0.023 0.023 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2013q1_pkey on part_20000000_2013q1 t_35 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.023 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
60. 0.023 0.023 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2013q2_pkey on part_20000000_2013q2 t_36 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.023 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.015
61. 0.023 0.023 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2013q3_pkey on part_20000000_2013q3 t_37 (cost=0.14..370.77 rows=1 width=516) (actual time=0.023..0.023 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
62. 0.023 0.023 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2013q4_pkey on part_20000000_2013q4 t_38 (cost=0.14..370.77 rows=1 width=516) (actual time=0.023..0.023 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
63. 0.022 0.022 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2014q1_pkey on part_20000000_2014q1 t_39 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
64. 0.022 0.022 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2014q2_pkey on part_20000000_2014q2 t_40 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
65. 0.022 0.022 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2014q3_pkey on part_20000000_2014q3 t_41 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
66. 0.022 0.022 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2014q4_pkey on part_20000000_2014q4 t_42 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
67. 0.022 0.022 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2015q1_pkey on part_20000000_2015q1 t_43 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.014
68. 0.022 0.022 ↓ 0.0 0 1

-> Index Scan Backward using t_20000000_2015q2_pkey on part_20000000_2015q2 t_44 (cost=0.14..370.77 rows=1 width=516) (actual time=0.022..0.022 rows=0 loops=1)

  • Filter: ((id_dict_transfer_status = ANY ('{1}'::bigint[])) AND ((NOT ghost) OR (id_dict_transfer_sort <> $1)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $2)) AND ((NOT ghost) OR (id_dict_transfer_sort <> $3)) AND (id_dict_transfer_type = $0))
  • Buffers: shared read=1
  • I/O Timings: read=0.015