explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r5CY

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

Append (cost=4.63..244,592.82 rows=118 width=619) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_123d (cost=4.63..66.10 rows=1 width=564) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_123d_idx (cost=0.00..4.62 rows=17 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_360nxs (cost=4.78..112.40 rows=1 width=686) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_360nxs_idx (cost=0.00..4.78 rows=29 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_3dsmax (cost=186.23..11,218.51 rows=1 width=543) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_3dsmax_idx (cost=0.00..186.23 rows=3,014 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
8. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_a360_idx on segments_a360 (cost=0.28..8.31 rows=1 width=386) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_abo (cost=4.59..56.59 rows=1 width=643) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_abo_idx (cost=0.00..4.59 rows=14 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_acad (cost=272.43..16,651.35 rows=1 width=488) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_acad_idx (cost=0.00..272.43 rows=4,470 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
13. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_acd (cost=423.87..26,509.45 rows=1 width=569) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_acd_idx (cost=0.00..423.87 rows=6,985 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_acm (cost=10.30..581.34 rows=1 width=696) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_acm_idx (cost=0.00..10.30 rows=150 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_ad (cost=4.82..125.65 rows=1 width=580) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
18. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_ad_idx (cost=0.00..4.82 rows=32 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_adsk360 (cost=9.85..444.27 rows=1 width=633) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_adsk360_idx (cost=0.00..9.85 rows=114 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
21. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_adst (cost=35.26..2,041.05 rows=1 width=663) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
22. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_adst_idx (cost=0.00..35.26 rows=537 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
23. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_aec_collection (cost=4.46..19.69 rows=1 width=422) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
24. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_aec_collection_idx (cost=0.00..4.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
25. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_airmax (cost=19.89..1,037.82 rows=1 width=668) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
26. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_airmax_idx (cost=0.00..19.89 rows=267 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
27. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_akn (cost=20.50..1,175.28 rows=1 width=321) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
28. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_akn_idx (cost=0.00..20.50 rows=316 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
29. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_algor (cost=4.70..90.01 rows=1 width=426) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_algor_idx (cost=0.00..4.70 rows=22 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
31. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_alias (cost=4.65..36.39 rows=1 width=404) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
32. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_alias_idx (cost=0.00..4.65 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
33. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_amech_pp (cost=30.40..1,803.72 rows=1 width=647) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
34. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_amech_pp_idx (cost=0.00..30.40 rows=468 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
35. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_appstore (cost=4.84..134.23 rows=1 width=742) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
36. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_appstore_idx (cost=0.00..4.84 rows=34 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
37. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_archdesk (cost=132.11..8,431.84 rows=1 width=645) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
38. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_archdesk_idx (cost=0.00..132.11 rows=2,204 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
39. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_ardes (cost=20.07..1,072.12 rows=1 width=640) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
40. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_ardes_idx (cost=0.00..20.07 rows=292 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
41. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_arnold_idx on segments_arnold (cost=0.42..12.49 rows=1 width=410) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
42. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_artc (cost=10.32..560.99 rows=1 width=457) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
43. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_artc_idx (cost=0.00..10.32 rows=152 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
44. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_asmes (cost=30.19..1,691.40 rows=1 width=717) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
45. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_asmes_idx (cost=0.00..30.18 rows=451 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
46. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_aspro (cost=15.40..896.49 rows=1 width=768) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_aspro_idx (cost=0.00..15.39 rows=238 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
48. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_avt (cost=14.94..743.21 rows=1 width=593) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
49. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_avt_idx (cost=0.00..14.94 rows=191 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
50. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_bds (cost=4.49..27.00 rows=1 width=473) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
51. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_bds_idx (cost=0.00..4.49 rows=6 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
52. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_beast_idx on segments_beast (cost=0.41..8.45 rows=1 width=434) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
53. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_bim360 (cost=34.96..1,931.56 rows=1 width=507) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
54. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_bim360_idx (cost=0.00..34.96 rows=513 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
55. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_bldsys (cost=318.88..19,827.53 rows=1 width=696) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_bldsys_idx (cost=0.00..318.88 rows=5,306 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
57. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_buzzsaw (cost=15.29..861.00 rows=1 width=700) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
58. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_buzzsaw_idx (cost=0.00..15.29 rows=229 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
59. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_cam360 (cost=4.44..12.29 rows=1 width=390) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
60. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_cam360_idx (cost=0.00..4.44 rows=2 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
61. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_cdx (cost=4.57..50.46 rows=1 width=700) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
62. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_cdx_idx (cost=0.00..4.57 rows=12 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
63. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_cercip (cost=4.46..19.75 rows=1 width=741) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
64. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_cercip_idx (cost=0.00..4.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
65. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_cfd (cost=14.81..707.66 rows=1 width=388) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
66. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_cfd_idx (cost=0.00..14.81 rows=191 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
67. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_cfg360 (cost=4.78..112.37 rows=1 width=554) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_cfg360_idx (cost=0.00..4.78 rows=29 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
69. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_civ3d (cost=126.36..7,951.64 rows=1 width=614) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
70. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_civ3d_idx (cost=0.00..126.36 rows=2,064 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
71. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_connect (cost=4.53..38.25 rows=1 width=411) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
72. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_connect_idx (cost=0.00..4.52 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
73. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_dwg (cost=5.09..186.28 rows=1 width=391) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
74. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_dwg_idx (cost=0.00..5.09 rows=54 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
75. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_dynamo_idx on segments_dynamo (cost=0.41..8.45 rows=1 width=429) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
76. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_edu (cost=4.47..22.98 rows=1 width=416) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_edu_idx (cost=0.00..4.47 rows=5 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
78. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_e_learning (cost=150.63..8,870.47 rows=1 width=449) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
79. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_e_learning_idx (cost=0.00..150.63 rows=2,406 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
80. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_estore (cost=4.73..97.91 rows=1 width=406) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
81. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_estore_idx (cost=0.00..4.73 rows=25 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
82. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_fcam (cost=25.61..1,508.02 rows=1 width=407) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
83. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_fcam_idx (cost=0.00..25.61 rows=405 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
84. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_fds (cost=10.12..522.70 rows=1 width=570) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
85. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_fds_idx (cost=0.00..10.12 rows=136 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
86. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_fdu (cost=10.01..485.67 rows=1 width=427) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
87. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_fdu_idx (cost=0.00..10.01 rows=127 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
88. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_featurecam (cost=4.52..37.15 rows=1 width=408) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
89. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_featurecam_idx (cost=0.00..4.52 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
90. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_flame (cost=4.50..30.04 rows=1 width=389) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
91. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_flame_idx (cost=0.00..4.50 rows=7 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
92. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_formit_idx on segments_formit (cost=0.41..8.44 rows=1 width=408) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
93. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_fsn360_idx on segments_fsn360 (cost=0.55..8.58 rows=1 width=661) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
94. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_fsnt (cost=4.62..64.32 rows=1 width=372) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
95. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_fsnt_idx (cost=0.00..4.62 rows=16 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
96. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_fusion (cost=4.51..34.12 rows=1 width=414) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
97. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_fusion_idx (cost=0.00..4.51 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
98. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_gw (cost=5.25..218.18 rows=1 width=439) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
99. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_gw_idx (cost=0.00..5.25 rows=56 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
100. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_hsmwks (cost=4.89..147.31 rows=1 width=719) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_hsmwks_idx (cost=0.00..4.89 rows=38 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
102. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_hstylr (cost=9.74..382.77 rows=1 width=643) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
103. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_hstylr_idx (cost=0.00..9.74 rows=106 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
104. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_humanik_idx on segments_humanik (cost=0.42..8.45 rows=1 width=444) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
105. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_icd (cost=20.09..1,049.31 rows=1 width=410) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
106. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_icd_idx (cost=0.00..20.09 rows=283 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
107. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_ids (cost=4.46..19.42 rows=1 width=467) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
108. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_ids_idx (cost=0.00..4.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
109. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_ims (cost=35.11..1,989.83 rows=1 width=687) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
110. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_ims_idx (cost=0.00..35.11 rows=525 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
111. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_infmdr (cost=15.15..835.17 rows=1 width=646) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
112. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_infmdr_idx (cost=0.00..15.15 rows=218 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
113. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_infraworks (cost=5.07..200.82 rows=1 width=657) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
114. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_infraworks_idx (cost=0.00..5.07 rows=52 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
115. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_instd_idx on segments_instd (cost=0.28..8.32 rows=1 width=644) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
116. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_instructables_idx on segments_instructables (cost=0.28..8.32 rows=1 width=2,091) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
117. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_inv (cost=258.41..16,440.02 rows=1 width=607) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
118. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_inv_idx (cost=0.00..258.41 rows=4,308 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
119. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_kynapse_idx on segments_kynapse (cost=0.41..8.45 rows=1 width=2,117) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
120. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_lirafx (cost=4.94..165.56 rows=1 width=674) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
121. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_lirafx_idx (cost=0.00..4.94 rows=42 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
122. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_m360 (cost=4.56..47.40 rows=1 width=694) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
123. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_m360_idx (cost=0.00..4.56 rows=12 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
124. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_map (cost=171.76..10,813.18 rows=1 width=639) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
125. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_map_idx (cost=0.00..171.76 rows=2,816 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
126. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_marqueeapps (cost=4.68..85.00 rows=1 width=738) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
127. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_marqueeapps_idx (cost=0.00..4.68 rows=21 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
128. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_maya_idx on segments_maya (cost=0.55..73.15 rows=1 width=552) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
129. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_mbxpro (cost=5.14..212.61 rows=1 width=669) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
130. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_mbxpro_idx (cost=0.00..5.14 rows=58 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
131. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_mf (cost=20.45..1,204.07 rows=1 width=723) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
132. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_mf_idx (cost=0.00..20.45 rows=312 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
133. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_moldflow (cost=80.56..4,837.23 rows=1 width=420) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
134. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_moldflow_idx (cost=0.00..80.56 rows=1,280 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
135. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_motionbuilder_idx on segments_motionbuilder (cost=0.41..8.45 rows=1 width=434) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
136. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_mud (cost=9.58..327.30 rows=1 width=425) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
137. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_mud_idx (cost=0.00..9.58 rows=93 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
138. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_myadsk (cost=5.13..223.09 rows=1 width=729) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
139. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_myadsk_idx (cost=0.00..5.13 rows=57 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
140. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_nav (cost=40.63..2,442.92 rows=1 width=590) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
141. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_nav_idx (cost=0.00..40.63 rows=646 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
142. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_netf (cost=14.43..615.30 rows=1 width=569) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
143. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_netf_idx (cost=0.00..14.43 rows=161 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
144. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_nin (cost=9.70..361.68 rows=1 width=406) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
145. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_nin_idx (cost=0.00..9.70 rows=92 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
146. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_nstrn (cost=5.24..248.95 rows=1 width=552) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
147. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_nstrn_idx (cost=0.00..5.24 rows=66 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
148. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_pixlr (cost=4.46..19.27 rows=1 width=2,099) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
149. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_pixlr_idx (cost=0.00..4.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
150. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_plant3d (cost=116.93..7,313.54 rows=1 width=661) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
151. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_plant3d_idx (cost=0.00..116.93 rows=1,950 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
152. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_plm (cost=9.98..455.27 rows=1 width=401) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
153. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_plm_idx (cost=0.00..9.98 rows=125 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
154. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_pm (cost=35.19..2,030.46 rows=1 width=648) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
155. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_pm_idx (cost=0.00..35.19 rows=531 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
156. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_power (cost=4.79..114.75 rows=1 width=411) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
157. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_power_idx (cost=0.00..4.79 rows=30 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
158. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_prds (cost=4.67..79.72 rows=1 width=407) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
159. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_prds_idx (cost=0.00..4.67 rows=20 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
160. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_prnstu (cost=4.47..22.19 rows=1 width=2,035) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
161. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_prnstu_idx (cost=0.00..4.47 rows=5 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
162. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_prod_gateway (cost=4.46..19.65 rows=1 width=391) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
163. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_prod_gateway_idx (cost=0.00..4.46 rows=4 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
164. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_pw (cost=76.32..4,703.30 rows=1 width=384) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
165. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_pw_idx (cost=0.00..76.32 rows=1,261 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
166. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_qto (cost=4.69..81.69 rows=1 width=2,079) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
167. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_qto_idx (cost=0.00..4.69 rows=22 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
168. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_raster (cost=9.68..364.97 rows=1 width=404) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
169. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_raster_idx (cost=0.00..9.68 rows=101 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
170. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_rctstr (cost=25.38..1,476.12 rows=1 width=649) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
171. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_rctstr_idx (cost=0.00..25.38 rows=386 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
172. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_recap (cost=4.86..138.19 rows=1 width=669) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
173. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_recap_idx (cost=0.00..4.86 rows=35 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
174. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_rendering (cost=4.64..72.86 rows=1 width=525) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
175. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_rendering_idx (cost=0.00..4.64 rows=18 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
176. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_robot (cost=50.84..2,850.72 rows=1 width=430) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
177. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_robot_idx (cost=0.00..50.84 rows=823 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
178. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_rsapro (cost=25.40..1,489.88 rows=1 width=648) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
179. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_rsapro_idx (cost=0.00..25.40 rows=388 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
180. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_rvt (cost=257.49..16,100.15 rows=1 width=575) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
181. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_rvt_idx (cost=0.00..257.49 rows=4,234 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
182. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_scfd (cost=9.87..445.22 rows=1 width=685) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
183. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_scfd_idx (cost=0.00..9.87 rows=116 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
184. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_seo (cost=4.49..26.97 rows=1 width=447) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
185. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_seo_idx (cost=0.00..4.49 rows=6 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
186. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_sftim_idx on segments_sftim (cost=0.41..8.45 rows=1 width=622) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
187. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_shared (cost=111.56..7,002.01 rows=1 width=408) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
188. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_shared_idx (cost=0.00..111.56 rows=1,840 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
189. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_shotgun_idx on segments_shotgun (cost=0.42..8.46 rows=1 width=514) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
190. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_showcase (cost=5.22..237.47 rows=1 width=695) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
191. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_showcase_idx (cost=0.00..5.22 rows=64 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
192. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_sim (cost=14.62..675.97 rows=1 width=647) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
193. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_sim_idx (cost=0.00..14.62 rows=176 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
194. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_sjm (cost=4.58..52.97 rows=1 width=397) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
195. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_sjm_idx (cost=0.00..4.57 rows=13 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
196. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_sketch (cost=9.66..377.99 rows=1 width=618) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
197. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_sketch_idx (cost=0.00..9.66 rows=99 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
198. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_softimage_idx on segments_softimage (cost=0.42..8.46 rows=1 width=2,073) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
199. 0.000 0.000 ↓ 0.0

Index Scan using segments_exact_stingray_idx on segments_stingray (cost=0.42..8.46 rows=1 width=411) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
200. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_strdet (cost=14.60..655.85 rows=1 width=649) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
201. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_strdet_idx (cost=0.00..14.60 rows=174 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
202. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_subs (cost=4.43..12.06 rows=1 width=451) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
203. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_subs_idx (cost=0.00..4.43 rows=2 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
204. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_tkrcad (cost=4.97..173.15 rows=1 width=655) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
205. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_tkrcad_idx (cost=0.00..4.97 rows=44 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
206. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_tnnuinv (cost=4.51..33.64 rows=1 width=454) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
207. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_tnnuinv_idx (cost=0.00..4.51 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
208. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_torch (cost=4.32..15.64 rows=1 width=638) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
209. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_torch_idx (cost=0.00..4.32 rows=3 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
210. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_trufbr (cost=4.47..22.69 rows=1 width=443) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
211. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_trufbr_idx (cost=0.00..4.47 rows=5 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
212. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_trupln (cost=4.55..44.50 rows=1 width=439) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
213. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_trupln_idx (cost=0.00..4.55 rows=11 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
214. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_vault (cost=25.10..1,383.86 rows=1 width=418) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
215. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_vault_idx (cost=0.00..25.10 rows=364 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
216. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_vlt (cost=76.01..4,777.72 rows=1 width=706) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
217. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_vlt_idx (cost=0.00..76.01 rows=1,236 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
218. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_vred (cost=4.51..32.28 rows=1 width=469) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
219. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_vred_idx (cost=0.00..4.51 rows=7 width=0) (actual rows= loops=)

  • Index Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
220. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on segments_default (cost=474.95..29,319.65 rows=1 width=371) (actual rows= loops=)

  • Recheck Cond: ((md5(src) = 'ce114e4501d2f4e2dcea3e17b546f339'::text) AND ((src_lng)::text = 'eng-US'::text) AND ((trg_lng)::text = 'fra-FR'::text))
  • Filter: ((previous_hash = '-2147483648'::integer) AND (next_hash = 580981343) AND (sequence_num = 1) AND (params_md5 = '-8493165078039039259'::bigint) AND (sid = 'Index'::text))
221. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on segments_exact_default_idx (cost=0.00..474.95 rows=7,871 width=0) (actual rows= loops=)